Log File Initialized... 1/27/2025 12:35:53 AM
1/27/2025 12:35:53 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 12:37:29 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 1:03:50 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 1:06:51 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 1:07:16 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 1:25:40 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 1:31:16 AM: Number of days finished to make changes
ZealERP.ZealFramework.Utils.ZealException: Number of days finished to make changes
   at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.BeforeUpdate(SaveDataModel record, OracleCommand command)
   at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass26_0.<Update>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
1/27/2025 1:31:16 AM: Number of days finished to make changes
ZealERP.ZealFramework.Utils.ZealException: Number of days finished to make changes
   at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.BeforeUpdate(SaveDataModel record, OracleCommand command)
   at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass26_0.<Update>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
   at ZealERP.ZealFramework.Services.DBService.Update(SaveDataModel record)
   at ZealERP.ZealFramework.Services.DBService.UpdateSecure(SaveDataModel record)
   at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass7_0.<UpdateDataSecure>b__0()
1/27/2025 1:49:43 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 1:55:30 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 1:57:43 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 2:05:15 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 3:49:15 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 3:50:37 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 4:18:05 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 4:19:14 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 4:32:21 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 4:59:38 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 5:04:00 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 5:58:09 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 6:03:09 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 6:06:44 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 6:31:03 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 6:42:00 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 7:00:04 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.LoginNew.btnLogin_Click(Object sender, EventArgs e)
1/27/2025 7:01:16 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 7:13:23 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()
1/27/2025 7:13:23 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()
1/27/2025 7:14:18 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 7:15:12 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 7:17:14 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()
1/27/2025 7:17:14 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()
1/27/2025 7:38:28 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 8:11:00 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 8:14:08 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 8:42:49 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 8:49:16 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 8:52:37 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 8:56:06 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 9:04:08 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 9:07:18 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 11:02:06 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 11:14:01 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 8:01:49 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(FIRST_SUBMISSION_DATE,'dd/MM/yyyy') FIRST_SUBMISSION_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, NIV_ADJUSTMENT_AMOUNT, NIV_ADJUSTMENT_AMOUNT_ADHOC, POLICY_HOLD_FLAG, ASSIGNEE_TAG ,BANK_REF_NO,FACE_VALUE_INCREASE_TAG , nvl(a.SMOKER_TAG,'N') SMOKER_TAG , SUM_COVERED_ORIG 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=
1/27/2025 8:01:49 PM: ORA-00904: "SUM_COVERED_ORIG": invalid identifier
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00904: "SUM_COVERED_ORIG": 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)
   at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, OracleCommand trans)
   at ZealERP.ZealTakaful.Services.ILAS.DocHeaderUtilityILAS.GetDocObjHeaderOnly(String ReferenceKey, String RecordType, String DocType, OracleCommand transaction, Boolean FirstRecordOnly, Boolean UpdatedValuesOnly, Boolean isFromPMDUnderwiting)
   at ZealERP.ZealTakaful.Models.Reports.ReportDataModelForWebForm.GetDocFromCache(DocumentHeaderModelILAS doc)
   at ZealERP.ZealTakaful.Services.Reports.ReportsService.GetAddressAndName(DocumentHeaderModelILAS doc)
   at ZealERP.ZealTakaful.Reports.NonPaymentOfOverdueContribution.NonPaymentOfOverdueContribution.PrepareReport()
1/27/2025 8:01:49 PM: ORA-00904: "SUM_COVERED_ORIG": invalid identifier
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00904: "SUM_COVERED_ORIG": 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)
   at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, OracleCommand trans)
   at ZealERP.ZealTakaful.Services.ILAS.DocHeaderUtilityILAS.GetDocObjHeaderOnly(String ReferenceKey, String RecordType, String DocType, OracleCommand transaction, Boolean FirstRecordOnly, Boolean UpdatedValuesOnly, Boolean isFromPMDUnderwiting)
   at ZealERP.ZealTakaful.Models.Reports.ReportDataModelForWebForm.GetDocFromCache(DocumentHeaderModelILAS doc)
   at ZealERP.ZealTakaful.Services.Reports.ReportsService.GetAddressAndName(DocumentHeaderModelILAS doc)
   at ZealERP.ZealTakaful.Reports.NonPaymentOfOverdueContribution.NonPaymentOfOverdueContribution.PrepareReport()
1/27/2025 8:12:33 PM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 8:13:46 PM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 8:14:25 PM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 8:15:18 PM: Thread was being aborted.
System.Threading.ThreadAbortException: Thread was being aborted.
   at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.AbortCurrentThread()
   at System.Web.HttpResponse.End()
   at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent)
   at System.Web.HttpResponse.Redirect(String url)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 8:15:32 PM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 8:20:22 PM: 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()
1/27/2025 8:20:22 PM: 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()
1/27/2025 8:20:30 PM: 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()
1/27/2025 8:20:30 PM: 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()
1/27/2025 8:23:01 PM: 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()
1/27/2025 8:23:01 PM: 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()
1/27/2025 8:23:11 PM: 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()
1/27/2025 8:23:11 PM: 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()
1/27/2025 8:23:39 PM: 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()
1/27/2025 8:23:39 PM: 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()
1/27/2025 8:24:05 PM: 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()
1/27/2025 8:24:05 PM: 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()
1/27/2025 8:24:10 PM: 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()
1/27/2025 8:24:10 PM: 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()
1/27/2025 8:24:21 PM: 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()
1/27/2025 8:24:21 PM: 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()
1/27/2025 8:25:26 PM: 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()
1/27/2025 8:25:26 PM: 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()
1/27/2025 8:26:44 PM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 8:28:14 PM: 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()
1/27/2025 8:28:14 PM: 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()
1/27/2025 8:28:25 PM: 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()
1/27/2025 8:28:25 PM: 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()
1/27/2025 8:28:36 PM: 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()
1/27/2025 8:28:36 PM: 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()
1/27/2025 8:30:55 PM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 8:40:14 PM: 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()
1/27/2025 8:40:14 PM: 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()
1/27/2025 8:46:19 PM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 8:50:08 PM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 10:32:45 PM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 10:41:22 PM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/27/2025 11:40:20 PM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)