Log File Initialized... 4/29/2024 2:33:51 AM 4/29/2024 2:33:51 AM: Object reference not set to an instance of an object. System.NullReferenceException: Object reference not set to an instance of an object. at ZealERP.ZealTakaful.Reports.TravelPolicy.TravelPolicySD.PrepareReport() 4/29/2024 3:17:32 AM: insert into GL_VOUCHER_HEADER_T (VOUCHER_NO,ORG_ID,BRANCH_ID,VOUCHER_REF_NO,VOUCHER_AMOUNT,VOUCHER_DATE,VOUCHER_STATUS,VOUCHER_TYPE,FISCAL_YEAR,VOUCHER_DESCRIPTION,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE) values (:VOUCHER_NO,:ORG_ID,:BRANCH_ID,:VOUCHER_REF_NO,:VOUCHER_AMOUNT,:VOUCHER_DATE,:VOUCHER_STATUS,:VOUCHER_TYPE,:FISCAL_YEAR,:VOUCHER_DESCRIPTION,:CREATED_BY,:CREATION_DATE,:LAST_UPDATED_BY,:LAST_UPDATE_DATE) params: VOUCHER_NO=0400009, ORG_ID=4, BRANCH_ID=14, VOUCHER_REF_NO=PCV-0400009/04/20232024, VOUCHER_AMOUNT=3000, VOUCHER_DATE=4/29/2024 3:17:32 AM, VOUCHER_STATUS=D, VOUCHER_TYPE=PCV, FISCAL_YEAR=20232024, VOUCHER_DESCRIPTION=Water tanker share for office 1st and 2nd Floor dated 28-04-2024., CREATED_BY=malik.zealsoft, CREATION_DATE=4/29/2024 3:17:32 PM, LAST_UPDATED_BY=malik.zealsoft, LAST_UPDATE_DATE=4/29/2024 3:17:32 PM 4/29/2024 3:17:32 AM: ORA-01653: unable to extend table ZEAL_ERP.GL_VOUCHER_HEADER_T by 8 in tablespace USERS Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01653: unable to extend table ZEAL_ERP.GL_VOUCHER_HEADER_T by 8 in tablespace USERS at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone) at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, OracleException& exceptionForArrayBindDML, OracleConnection connection, Boolean isFromEF) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery() at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans) 4/29/2024 3:17:32 AM: ORA-01653: unable to extend table ZEAL_ERP.GL_VOUCHER_HEADER_T by 8 in tablespace USERS Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01653: unable to extend table ZEAL_ERP.GL_VOUCHER_HEADER_T by 8 in tablespace USERS at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans) at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, OracleCommand trans) at ZealERP.ZealFramework.Utils.DB.InsertRecord(String TableName, OracleParameter[] parameters, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 4/29/2024 3:17:32 AM: Application Error. Please Contact Vendor or Refer Logs. System.Exception: Application Error. Please Contact Vendor or Refer Logs. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0() 4/29/2024 3:18:34 AM: insert into GL_VOUCHER_HEADER_T (VOUCHER_NO,ORG_ID,BRANCH_ID,VOUCHER_REF_NO,VOUCHER_AMOUNT,VOUCHER_DATE,VOUCHER_STATUS,VOUCHER_TYPE,FISCAL_YEAR,VOUCHER_DESCRIPTION,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE) values (:VOUCHER_NO,:ORG_ID,:BRANCH_ID,:VOUCHER_REF_NO,:VOUCHER_AMOUNT,:VOUCHER_DATE,:VOUCHER_STATUS,:VOUCHER_TYPE,:FISCAL_YEAR,:VOUCHER_DESCRIPTION,:CREATED_BY,:CREATION_DATE,:LAST_UPDATED_BY,:LAST_UPDATE_DATE) params: VOUCHER_NO=0400009, ORG_ID=4, BRANCH_ID=14, VOUCHER_REF_NO=PCV-0400009/04/20232024, VOUCHER_AMOUNT=3000, VOUCHER_DATE=4/29/2024 3:18:33 AM, VOUCHER_STATUS=D, VOUCHER_TYPE=PCV, FISCAL_YEAR=20232024, VOUCHER_DESCRIPTION=Water tanker share for office 1st and 2nd Floor dated 28-04-2024., CREATED_BY=malik.zealsoft, CREATION_DATE=4/29/2024 3:18:34 PM, LAST_UPDATED_BY=malik.zealsoft, LAST_UPDATE_DATE=4/29/2024 3:18:34 PM 4/29/2024 3:18:34 AM: ORA-01653: unable to extend table ZEAL_ERP.GL_VOUCHER_HEADER_T by 8 in tablespace USERS Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01653: unable to extend table ZEAL_ERP.GL_VOUCHER_HEADER_T by 8 in tablespace USERS at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone) at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, OracleException& exceptionForArrayBindDML, OracleConnection connection, Boolean isFromEF) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery() at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans) 4/29/2024 3:18:34 AM: ORA-01653: unable to extend table ZEAL_ERP.GL_VOUCHER_HEADER_T by 8 in tablespace USERS Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01653: unable to extend table ZEAL_ERP.GL_VOUCHER_HEADER_T by 8 in tablespace USERS at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans) at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, OracleCommand trans) at ZealERP.ZealFramework.Utils.DB.InsertRecord(String TableName, OracleParameter[] parameters, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 4/29/2024 3:18:34 AM: Application Error. Please Contact Vendor or Refer Logs. System.Exception: Application Error. Please Contact Vendor or Refer Logs. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0() 4/29/2024 3:18:55 AM: insert into GL_VOUCHER_HEADER_T (VOUCHER_NO,ORG_ID,BRANCH_ID,VOUCHER_REF_NO,VOUCHER_AMOUNT,VOUCHER_DATE,VOUCHER_STATUS,VOUCHER_TYPE,FISCAL_YEAR,VOUCHER_DESCRIPTION,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE) values (:VOUCHER_NO,:ORG_ID,:BRANCH_ID,:VOUCHER_REF_NO,:VOUCHER_AMOUNT,:VOUCHER_DATE,:VOUCHER_STATUS,:VOUCHER_TYPE,:FISCAL_YEAR,:VOUCHER_DESCRIPTION,:CREATED_BY,:CREATION_DATE,:LAST_UPDATED_BY,:LAST_UPDATE_DATE) params: VOUCHER_NO=0400009, ORG_ID=4, BRANCH_ID=14, VOUCHER_REF_NO=PCV-0400009/04/20232024, VOUCHER_AMOUNT=3000, VOUCHER_DATE=4/29/2024 3:18:55 AM, VOUCHER_STATUS=D, VOUCHER_TYPE=PCV, FISCAL_YEAR=20232024, VOUCHER_DESCRIPTION=Water tanker share for office 1st and 2nd Floor dated 28-04-2024., CREATED_BY=malik.zealsoft, CREATION_DATE=4/29/2024 3:18:55 PM, LAST_UPDATED_BY=malik.zealsoft, LAST_UPDATE_DATE=4/29/2024 3:18:55 PM 4/29/2024 3:18:55 AM: ORA-01653: unable to extend table ZEAL_ERP.GL_VOUCHER_HEADER_T by 8 in tablespace USERS Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01653: unable to extend table ZEAL_ERP.GL_VOUCHER_HEADER_T by 8 in tablespace USERS at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone) at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, OracleException& exceptionForArrayBindDML, OracleConnection connection, Boolean isFromEF) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery() at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans) 4/29/2024 3:18:55 AM: ORA-01653: unable to extend table ZEAL_ERP.GL_VOUCHER_HEADER_T by 8 in tablespace USERS Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01653: unable to extend table ZEAL_ERP.GL_VOUCHER_HEADER_T by 8 in tablespace USERS at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans) at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, OracleCommand trans) at ZealERP.ZealFramework.Utils.DB.InsertRecord(String TableName, OracleParameter[] parameters, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 4/29/2024 3:18:55 AM: Application Error. Please Contact Vendor or Refer Logs. System.Exception: Application Error. Please Contact Vendor or Refer Logs. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0() 4/29/2024 3:19:39 AM: insert into GL_VOUCHER_HEADER_T (VOUCHER_NO,ORG_ID,BRANCH_ID,VOUCHER_REF_NO,VOUCHER_AMOUNT,VOUCHER_DATE,VOUCHER_STATUS,VOUCHER_TYPE,FISCAL_YEAR,VOUCHER_DESCRIPTION,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE) values (:VOUCHER_NO,:ORG_ID,:BRANCH_ID,:VOUCHER_REF_NO,:VOUCHER_AMOUNT,:VOUCHER_DATE,:VOUCHER_STATUS,:VOUCHER_TYPE,:FISCAL_YEAR,:VOUCHER_DESCRIPTION,:CREATED_BY,:CREATION_DATE,:LAST_UPDATED_BY,:LAST_UPDATE_DATE) params: VOUCHER_NO=0400009, ORG_ID=4, BRANCH_ID=14, VOUCHER_REF_NO=PCV-0400009/04/20232024, VOUCHER_AMOUNT=3000, VOUCHER_DATE=4/29/2024 3:19:39 AM, VOUCHER_STATUS=D, VOUCHER_TYPE=PCV, FISCAL_YEAR=20232024, VOUCHER_DESCRIPTION=Water tanker share for office 1st and 2nd Floor dated 28-04-2024., CREATED_BY=malik.zealsoft, CREATION_DATE=4/29/2024 3:19:39 PM, LAST_UPDATED_BY=malik.zealsoft, LAST_UPDATE_DATE=4/29/2024 3:19:39 PM 4/29/2024 3:19:39 AM: ORA-01653: unable to extend table ZEAL_ERP.GL_VOUCHER_HEADER_T by 8 in tablespace USERS Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01653: unable to extend table ZEAL_ERP.GL_VOUCHER_HEADER_T by 8 in tablespace USERS at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone) at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, OracleException& exceptionForArrayBindDML, OracleConnection connection, Boolean isFromEF) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery() at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans) 4/29/2024 3:19:39 AM: ORA-01653: unable to extend table ZEAL_ERP.GL_VOUCHER_HEADER_T by 8 in tablespace USERS Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01653: unable to extend table ZEAL_ERP.GL_VOUCHER_HEADER_T by 8 in tablespace USERS at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans) at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, OracleCommand trans) at ZealERP.ZealFramework.Utils.DB.InsertRecord(String TableName, OracleParameter[] parameters, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 4/29/2024 3:19:39 AM: Application Error. Please Contact Vendor or Refer Logs. System.Exception: Application Error. Please Contact Vendor or Refer Logs. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0() 4/29/2024 3:19:45 AM: insert into GL_VOUCHER_HEADER_T (VOUCHER_NO,ORG_ID,BRANCH_ID,VOUCHER_REF_NO,VOUCHER_AMOUNT,VOUCHER_DATE,VOUCHER_STATUS,VOUCHER_TYPE,FISCAL_YEAR,VOUCHER_DESCRIPTION,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE) values (:VOUCHER_NO,:ORG_ID,:BRANCH_ID,:VOUCHER_REF_NO,:VOUCHER_AMOUNT,:VOUCHER_DATE,:VOUCHER_STATUS,:VOUCHER_TYPE,:FISCAL_YEAR,:VOUCHER_DESCRIPTION,:CREATED_BY,:CREATION_DATE,:LAST_UPDATED_BY,:LAST_UPDATE_DATE) params: VOUCHER_NO=0400009, ORG_ID=4, BRANCH_ID=14, VOUCHER_REF_NO=PCV-0400009/04/20232024, VOUCHER_AMOUNT=3000, VOUCHER_DATE=4/29/2024 3:19:45 AM, VOUCHER_STATUS=D, VOUCHER_TYPE=PCV, FISCAL_YEAR=20232024, VOUCHER_DESCRIPTION=Water tanker share for office 1st and 2nd Floor dated 28-04-2024., CREATED_BY=malik.zealsoft, CREATION_DATE=4/29/2024 3:19:45 PM, LAST_UPDATED_BY=malik.zealsoft, LAST_UPDATE_DATE=4/29/2024 3:19:45 PM 4/29/2024 3:19:45 AM: ORA-01653: unable to extend table ZEAL_ERP.GL_VOUCHER_HEADER_T by 8 in tablespace USERS Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01653: unable to extend table ZEAL_ERP.GL_VOUCHER_HEADER_T by 8 in tablespace USERS at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone) at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, OracleException& exceptionForArrayBindDML, OracleConnection connection, Boolean isFromEF) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery() at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans) 4/29/2024 3:19:45 AM: ORA-01653: unable to extend table ZEAL_ERP.GL_VOUCHER_HEADER_T by 8 in tablespace USERS Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01653: unable to extend table ZEAL_ERP.GL_VOUCHER_HEADER_T by 8 in tablespace USERS at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans) at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, OracleCommand trans) at ZealERP.ZealFramework.Utils.DB.InsertRecord(String TableName, OracleParameter[] parameters, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 4/29/2024 3:19:45 AM: Application Error. Please Contact Vendor or Refer Logs. System.Exception: Application Error. Please Contact Vendor or Refer Logs. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0() 4/29/2024 4:05:35 AM: Object reference not set to an instance of an object. System.NullReferenceException: Object reference not set to an instance of an object. at ZealERP.ZealTakaful.Reports.TravelPolicy.TravelPolicySD.PrepareReport() 4/29/2024 4:11:01 AM: Object reference not set to an instance of an object. System.NullReferenceException: Object reference not set to an instance of an object. at ZealERP.ZealTakaful.Reports.TravelPolicy.TravelPolicySD.PrepareReport() 4/29/2024 5:43:18 AM: Please Enter User Id ZealERP.ZealFramework.Utils.ZealException: Please Enter User Id at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 4/29/2024 5:43:18 AM: Please Enter User Id ZealERP.ZealFramework.Utils.ZealException: Please Enter User Id at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 4/29/2024 4:30:32 PM: select a.ORG_ID,a.BRANCH_ID,a.MAIN_PRODUCT_CODE,a.SUB_PRODUCT_CODE,a.TAKAFUL_TYPE,DOCUMENT_TYPE,DOCUMENT_NO,RECORD_TYPE,a.NON_FINANCIAL_SUB_ACTIVITY,a.NON_FINANCIAL_ACTIVITY ,DOCUMENT_YEAR,ISSUE_COUNT,APPLICATION_ID,ENDORSEMENT_NO,a.CLIENT_CODE,DOC_REFERENCE_NO,ADVANCE_AMOUNT,a.COVER_MULTIPLE ,a.AGE1_OLD,to_char(a.DOB1_OLD,'dd/mm/yyyy') DOB1_OLD,a.GENDER1_OLD,a.POLICY_TERM_OLD,a.PAYMENT_TERM_OLD,a.PAYMENT_MODE_OLD ,a.SUM_COVERED_MODAL_OLD,a.COVER_MULTIPLE_OLD,a.BASIC_CONTRIBUTION_MODAL_OLD,a.FUND_SWITCH_CHARGES,a.FUND_CHANGE_TAG,a.UNDERWRITING_IL_CREATE ,a.CNIC_NO_OLD,a.NAME1_OLD, a.MIDDLE_NAME1_OLD, a.LAST_NAME1_OLD, a.IL_REVISE_TAG ,to_char(ISSUE_DATE,'dd/mm/yyyy') ISSUE_DATE ,to_char(COMM_DATE,'dd/mm/yyyy') COMM_DATE ,to_char(ALTERATION_DATE,'dd/mm/yyyy') ALTERATION_DATE ,to_char(DOC_DISPATCH_DATE,'dd/mm/yyyy') DOC_DISPATCH_DATE ,to_char(DOC_RECEIVE_DATE,'dd/mm/yyyy') DOC_RECEIVE_DATE ,to_char(RECEIVE_ACK_DATE,'dd/mm/yyyy') RECEIVE_ACK_DATE ,to_char(CANCELLATION_DATE,'dd/mm/yyyy') CANCELLATION_DATE ,to_char(DOB1,'dd/mm/yyyy') DOB1 ,to_char(EXPIRY_DATE,'dd/mm/yyyy') EXPIRY_DATE,COST_CENTER_CODE,CONVERT_TAG,REVISED_TAG,PAYMENT_MODE, ILLUSTRATION_REF_NO ,OCCUPATIONAL_CLASS,MASTER_REF_NO,BASE_DOC_NO,ALTERATION_TYPE,SUM_COVERED_MODAL,POSTING_TAG,AGE1, GENDER1 ,UNDWT_STATUS,UNDWT_DECISION,BASIC_CONTRIBUTION_MODAL,SUBMIT_TAG,POLICY_TERM,PAYMENT_TERM ,RISK_PROFILE, CONTRIBUTION_TYPE, RISK_PROFILE_COMMENTS, CUSTOMER_PROFILE_COMMENTS,BASIC_CONTRIBUTION,CONVERT_PROPOSAL ,AGENT_ID,CHANNEL_ID,MODEL_ID,PARTNER_ID,CONTRIBUTION_INDEX,SUM_COVERED_INDEX,SUM_COVERED,TOTAL_CONTRIBUTION_MODAL,TOPUP_AMOUNT ,CANCELLATION_TYPE,CHARGEABLE_FROM,CHARGEABLE_AMOUNT, NAME1, MIDDLE_NAME1, LAST_NAME1, a.CNIC_NO, a.BASE_DOC_NO_KEY, a.ILLUSTRATION_REF_NO_KEY, a.CONVERTED_DOC_NO_KEY, a.AGENT_BRANCH_ID ,CONVERTED_POLICY_NO, UNDWT_DECISION_REASON ,'PKR' CURRENCY_CODE, f.client_desc, CANCEL_TAG, REJECTED_TAG, CONSIGNMENT_NO, CANCELLATION_REMARKS ,POLICY_POSTED,UNDWT_DECISION_SYSTEM, PAYER_SAME_TAG, PROPOSAL_APPROVED_BY,a.AUTO_RENEWAL_TOPUP_TAG,a.AUTO_RENEWAL_TOPUP_TAG_OLD,CONTRIBUTION_INDEX_OLD,SUM_COVERED_INDEX_OLD, TOTAL_SCORE from IL_DOC_HEADER_T a left join GLAS_CLIENT_SETUP_T f on a.ORG_ID = f.ORG_ID and a.CLIENT_CODE = f.CLIENT_CODE where a.ORG_ID = :ORG_ID and a.BRANCH_ID = :BRANCH_ID and a.MAIN_PRODUCT_CODE = :MAIN_PRODUCT_CODE and a.SUB_PRODUCT_CODE = :SUB_PRODUCT_CODE and a.TAKAFUL_TYPE = :TAKAFUL_TYPE and a.DOCUMENT_TYPE = :DOCUMENT_TYPE and a.DOCUMENT_NO = :DOCUMENT_NO and a.RECORD_TYPE = :RECORD_TYPE and a.DOCUMENT_YEAR = :DOCUMENT_YEAR and a.ISSUE_COUNT = :ISSUE_COUNT and a.ENDORSEMENT_NO = :ENDORSEMENT_NO and a.APPLICATION_ID = :APPLICATION_ID params: ORG_ID=0, BRANCH_ID=0, MAIN_PRODUCT_CODE=0, SUB_PRODUCT_CODE=0, TAKAFUL_TYPE=, DOCUMENT_TYPE=, DOCUMENT_NO=, RECORD_TYPE=, DOCUMENT_YEAR=, ISSUE_COUNT=, ENDORSEMENT_NO=, APPLICATION_ID= 4/29/2024 4:30:32 PM: ORA-00904: "TOTAL_SCORE": invalid identifier Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00904: "TOTAL_SCORE": invalid identifier at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone) at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, Int64 internalInitialJSONFS, OracleException& exceptionForArrayBindDML, OracleConnection connection, IEnumerable`1 adrianParsedStmt, Boolean isDescribeOnly, Boolean isFromEF) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) at Oracle.ManagedDataAccess.Client.OracleDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans, Boolean PrintLog) 4/29/2024 4:30:32 PM: ORA-00904: "TOTAL_SCORE": invalid identifier Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00904: "TOTAL_SCORE": invalid identifier at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans, Boolean PrintLog) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, Boolean ExecuteSp) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters) at ZealERP.ZealTakaful.Services.Reports.ReportsService.GetAddressAndName(DocumentHeaderModelILAS doc) at ZealERP.ZealTakaful.Reports.MembershipReinstatement.MembershipReinstatementRe.PrepareReport() 4/29/2024 10:51:20 PM: Executing Procedure HCM.UPDATE_EMP_CALENDAR_T params: 4/29/2024 10:51:20 PM: @P_ORG_ID=5 4/29/2024 10:51:20 PM: @P_EMPLOYEE_ID=57 4/29/2024 10:51:20 PM: @P_CAL_YEAR=2024 4/29/2024 10:51:20 PM: ORA-20001: ORA-01403: no data found ORA-06512: at "HCM.UPDATE_EMP_CALENDAR_T", line 64 ORA-06512: at line 1 Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-20001: ORA-01403: no data found ORA-06512: at "HCM.UPDATE_EMP_CALENDAR_T", line 64 ORA-06512: at line 1 at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone) at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, Int64 internalInitialJSONFS, OracleException& exceptionForArrayBindDML, OracleConnection connection, IEnumerable`1 adrianParsedStmt, Boolean isDescribeOnly, Boolean isFromEF) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) at Oracle.ManagedDataAccess.Client.OracleDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at ZealERP.ZealFramework.Utils.DB.SelectProc_Dataset(String SpName, OracleParameter[] param) at ZealERP.ZealFramework.Utils.DB.ExecuteSP(String procedureName, OracleParameter[] oracleParameters) 4/29/2024 10:51:20 PM: ORA-20001: ORA-01403: no data found ORA-06512: at "HCM.UPDATE_EMP_CALENDAR_T", line 64 ORA-06512: at line 1 Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-20001: ORA-01403: no data found ORA-06512: at "HCM.UPDATE_EMP_CALENDAR_T", line 64 ORA-06512: at line 1 at ZealERP.ZealFramework.Utils.DB.ExecuteSP(String procedureName, OracleParameter[] oracleParameters) at ZealERP.ZealTakaful.Services.DBServiceChildEmployee.AfterSaveAndCommit(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0() 4/29/2024 10:51:51 PM: Employee number 'ZP022' already exist ZealERP.ZealFramework.Utils.ZealException: Employee number 'ZP022' already exist at ZealERP.ZealTakaful.Services.DBServiceChildEmployee.ValidateEmployeeNumber(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildEmployee.BeforeSave(SaveDataModel record, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 4/29/2024 10:51:51 PM: Error.. Employee number 'ZP022' already exist ZealERP.ZealFramework.Utils.ZealException: Error.. Employee number 'ZP022' already exist at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0() 4/29/2024 10:52:39 PM: Executing Procedure HCM.UPDATE_EMP_CALENDAR_T params: 4/29/2024 10:52:39 PM: @P_ORG_ID=5 4/29/2024 10:52:39 PM: @P_EMPLOYEE_ID=58 4/29/2024 10:52:39 PM: @P_CAL_YEAR=2024 4/29/2024 10:52:39 PM: ORA-20001: ORA-01403: no data found ORA-06512: at "HCM.UPDATE_EMP_CALENDAR_T", line 64 ORA-06512: at line 1 Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-20001: ORA-01403: no data found ORA-06512: at "HCM.UPDATE_EMP_CALENDAR_T", line 64 ORA-06512: at line 1 at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone) at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, Int64 internalInitialJSONFS, OracleException& exceptionForArrayBindDML, OracleConnection connection, IEnumerable`1 adrianParsedStmt, Boolean isDescribeOnly, Boolean isFromEF) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) at Oracle.ManagedDataAccess.Client.OracleDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at ZealERP.ZealFramework.Utils.DB.SelectProc_Dataset(String SpName, OracleParameter[] param) at ZealERP.ZealFramework.Utils.DB.ExecuteSP(String procedureName, OracleParameter[] oracleParameters) 4/29/2024 10:52:39 PM: ORA-20001: ORA-01403: no data found ORA-06512: at "HCM.UPDATE_EMP_CALENDAR_T", line 64 ORA-06512: at line 1 Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-20001: ORA-01403: no data found ORA-06512: at "HCM.UPDATE_EMP_CALENDAR_T", line 64 ORA-06512: at line 1 at ZealERP.ZealFramework.Utils.DB.ExecuteSP(String procedureName, OracleParameter[] oracleParameters) at ZealERP.ZealTakaful.Services.DBServiceChildEmployee.AfterSaveAndCommit(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0() 4/29/2024 10:52:52 PM: Employee number 'ZP023' already exist ZealERP.ZealFramework.Utils.ZealException: Employee number 'ZP023' already exist at ZealERP.ZealTakaful.Services.DBServiceChildEmployee.ValidateEmployeeNumber(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildEmployee.BeforeSave(SaveDataModel record, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 4/29/2024 10:52:52 PM: Error.. Employee number 'ZP023' already exist ZealERP.ZealFramework.Utils.ZealException: Error.. Employee number 'ZP023' already exist at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0()