Log File Initialized... 10/21/2024 12:31:26 AM 10/21/2024 12:31:26 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) 10/21/2024 12:34:52 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) 10/21/2024 12:36:54 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) 10/21/2024 12:37: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) 10/21/2024 12:42: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) 10/21/2024 12:56: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) 10/21/2024 1:16:15 AM: Invalid Credentials ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials 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) 10/21/2024 1:16:15 AM: **************************** Error at Login Request for User alasam.travel123, Message: Invalid Credentials **************************** 10/21/2024 1:16:44 AM: Invalid Credentials ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials 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) 10/21/2024 1:16:44 AM: **************************** Error at Login Request for User alasam.travel123, Message: Invalid Credentials **************************** 10/21/2024 1:16:48 AM: Invalid Credentials ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials 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) 10/21/2024 1:16:48 AM: **************************** Error at Login Request for User alasam.travel123, Message: Invalid Credentials **************************** 10/21/2024 1:17:00 AM: Invalid Credentials ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials 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) 10/21/2024 1:17:00 AM: **************************** Error at Login Request for User alasam.travel123, Message: Invalid Credentials **************************** 10/21/2024 1:17: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) 10/21/2024 1:23: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) 10/21/2024 1:35:59 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) 10/21/2024 1:37:57 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) 10/21/2024 1:39:47 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) 10/21/2024 1:50: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) 10/21/2024 2:51:55 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) 10/21/2024 3:57:24 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) 10/21/2024 4:35: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) 10/21/2024 4:40: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) 10/21/2024 4:44:42 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) 10/21/2024 4:49:30 AM: Insert into TK_ILL_DOC_RIDERS (ORG_ID,BRANCH_ID,MAIN_PRODUCT_CODE,SUB_PRODUCT_CODE,TAKAFUL_TYPE,DOCUMENT_TYPE,RECORD_TYPE,DOCUMENT_YEAR,ISSUE_COUNT,ENDORSEMENT_NO,APPLICATION_ID,DOCUMENT_NO,BENEFIT_CODE,SUM_ASSURED,CONTRIBUTION,LAST_UPDATED_BY,LAST_UPDATE_DATE,RIDER_TERM,PAYMENT_TERM,SA_PERCENT,MONTHLY_AMOUNT,RIDER_RATE,REMARKS,DECISION_CODE,LOADING_CONTRIBUTION,LOADING_CONTRIBUTION_MODAL,CONTRIBUTION_MODAL,TOTAL_CONTRIBUTION,TOTAL_CONTRIBUTION_MODAL,RIDER_NET_RATE,NET_CONTRIBUTION_MODAL,NET_CONTRIBUTION,ENDORSEMENT_TAG,CREATED_BY,CREATION_DATE) select '8','14','2','11','D','Q','O','2024','1','0','13','000031',BENEFIT_CODE,SUM_ASSURED,CONTRIBUTION,LAST_UPDATED_BY,LAST_UPDATE_DATE,RIDER_TERM,PAYMENT_TERM,SA_PERCENT,MONTHLY_AMOUNT,RIDER_RATE,REMARKS,DECISION_CODE,LOADING_CONTRIBUTION,LOADING_CONTRIBUTION_MODAL,CONTRIBUTION_MODAL,TOTAL_CONTRIBUTION,TOTAL_CONTRIBUTION_MODAL,RIDER_NET_RATE,NET_CONTRIBUTION_MODAL,NET_CONTRIBUTION,ENDORSEMENT_TAG,'waada',sysdate from TK_ILL_DOC_RIDERS where ORG_ID='8' and BRANCH_ID='14' and MAIN_PRODUCT_CODE='2' and SUB_PRODUCT_CODE='11' and TAKAFUL_TYPE='D' and DOCUMENT_TYPE='Q' and DOCUMENT_NO='000024' and RECORD_TYPE='O' and DOCUMENT_YEAR='2024' and ISSUE_COUNT='1' and ENDORSEMENT_NO='0' and APPLICATION_ID='13' 10/21/2024 4:49:30 AM: ORA-00001: unique constraint (ZEAL_ERP.ILL_RIDER_PK) violated Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00001: unique constraint (ZEAL_ERP.ILL_RIDER_PK) violated 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) 10/21/2024 4:49:30 AM: Insert into TK_ILL_DOC_FUNDS (ORG_ID,BRANCH_ID,MAIN_PRODUCT_CODE,SUB_PRODUCT_CODE,TAKAFUL_TYPE,DOCUMENT_TYPE,RECORD_TYPE,DOCUMENT_YEAR,ISSUE_COUNT,ENDORSEMENT_NO,APPLICATION_ID,DOCUMENT_NO,FUND_CODE,FUND_SHARE,LAST_UPDATED_BY,LAST_UPDATE_DATE,RIDER_TERM,PAYMENT_TERM,SA_PERCENT,MONTHLY_AMOUNT,RIDER_RATE,FUNDS_AMOUNT,ALLOCATION_TAG,CASH_VALUE_DIFF_FINAL,FUND_SHARE_DIFF,FUND_SHARE_NEW,FUND_SHARE_OLD,NO_OF_UNITS,NO_OF_UNITS_OLD,NO_OF_UNITS_NEW,NO_OF_UNITS_DIFF,CASH_VALUE,CASH_VALUE_OLD,CASH_VALUE_NEW,CASH_VALUE_DIFF,BID_PRICE,SERIAL_NO,CREATED_BY,CREATION_DATE) select '8','14','2','11','D','Q','O','2024','1','0','13','000031',FUND_CODE,FUND_SHARE,LAST_UPDATED_BY,LAST_UPDATE_DATE,RIDER_TERM,PAYMENT_TERM,SA_PERCENT,MONTHLY_AMOUNT,RIDER_RATE,FUNDS_AMOUNT,ALLOCATION_TAG,CASH_VALUE_DIFF_FINAL,FUND_SHARE_DIFF,FUND_SHARE_NEW,FUND_SHARE_OLD,NO_OF_UNITS,NO_OF_UNITS_OLD,NO_OF_UNITS_NEW,NO_OF_UNITS_DIFF,CASH_VALUE,CASH_VALUE_OLD,CASH_VALUE_NEW,CASH_VALUE_DIFF,BID_PRICE,SERIAL_NO,'waada',sysdate from TK_ILL_DOC_FUNDS where ORG_ID='8' and BRANCH_ID='14' and MAIN_PRODUCT_CODE='2' and SUB_PRODUCT_CODE='11' and TAKAFUL_TYPE='D' and DOCUMENT_TYPE='Q' and DOCUMENT_NO='000024' and RECORD_TYPE='O' and DOCUMENT_YEAR='2024' and ISSUE_COUNT='1' and ENDORSEMENT_NO='0' and APPLICATION_ID='13' 10/21/2024 4:49:30 AM: ORA-00001: unique constraint (ZEAL_ERP.PK_ILL_DOC_FUND) violated Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00001: unique constraint (ZEAL_ERP.PK_ILL_DOC_FUND) violated 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) 10/21/2024 4:49:30 AM: Insert into IL_DOC_ILLUSTRATION_DTL_T (ORG_ID,BRANCH_ID,MAIN_PRODUCT_CODE,SUB_PRODUCT_CODE,TAKAFUL_TYPE,DOCUMENT_TYPE,RECORD_TYPE,DOCUMENT_YEAR,ISSUE_COUNT,ENDORSEMENT_NO,APPLICATION_ID,DOCUMENT_NO,ILLUSTRATION_ID,EFFECTIVE_AGE,POLICY_YEAR,BASIC_CONTRIBUTION,INVESTED_CONTRIBUTION,ALLOCATION_PERCENTAGE,ALLOCATION_CONTRIBUTION,MORTALITY_RATE1,MORTALITY_RATE2,SUM_ASSURED,SUM_ASSURED_AT_RISK,MORTALITY_CHARGES,PTF_SURPLUS,WAQALA_CHARGES,CONTINGENCY_MARGIN,REINS_AMOUNT,ADMIN_CHARGES,CASH_VALUE1,CASH_VALUE2,CASH_VALUE3,CREATED_BY,CREATION_DATE) select '8','14','2','11','D','Q','O','2024','1','0','13','000031',ILLUSTRATION_ID,EFFECTIVE_AGE,POLICY_YEAR,BASIC_CONTRIBUTION,INVESTED_CONTRIBUTION,ALLOCATION_PERCENTAGE,ALLOCATION_CONTRIBUTION,MORTALITY_RATE1,MORTALITY_RATE2,SUM_ASSURED,SUM_ASSURED_AT_RISK,MORTALITY_CHARGES,PTF_SURPLUS,WAQALA_CHARGES,CONTINGENCY_MARGIN,REINS_AMOUNT,ADMIN_CHARGES,CASH_VALUE1,CASH_VALUE2,CASH_VALUE3,'waada',sysdate from IL_DOC_ILLUSTRATION_DTL_T where ORG_ID='8' and BRANCH_ID='14' and MAIN_PRODUCT_CODE='2' and SUB_PRODUCT_CODE='11' and TAKAFUL_TYPE='D' and DOCUMENT_TYPE='Q' and DOCUMENT_NO='000024' and RECORD_TYPE='O' and DOCUMENT_YEAR='2024' and ISSUE_COUNT='1' and ENDORSEMENT_NO='0' and APPLICATION_ID='13' 10/21/2024 4:49:30 AM: ORA-00001: unique constraint (ZEAL_ERP.PK_IL_DOC_ILL_DTL) violated Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00001: unique constraint (ZEAL_ERP.PK_IL_DOC_ILL_DTL) violated 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) 10/21/2024 4:49:38 AM: Insert into TK_ILL_DOC_RIDERS (ORG_ID,BRANCH_ID,MAIN_PRODUCT_CODE,SUB_PRODUCT_CODE,TAKAFUL_TYPE,DOCUMENT_TYPE,RECORD_TYPE,DOCUMENT_YEAR,ISSUE_COUNT,ENDORSEMENT_NO,APPLICATION_ID,DOCUMENT_NO,BENEFIT_CODE,SUM_ASSURED,CONTRIBUTION,LAST_UPDATED_BY,LAST_UPDATE_DATE,RIDER_TERM,PAYMENT_TERM,SA_PERCENT,MONTHLY_AMOUNT,RIDER_RATE,REMARKS,DECISION_CODE,LOADING_CONTRIBUTION,LOADING_CONTRIBUTION_MODAL,CONTRIBUTION_MODAL,TOTAL_CONTRIBUTION,TOTAL_CONTRIBUTION_MODAL,RIDER_NET_RATE,NET_CONTRIBUTION_MODAL,NET_CONTRIBUTION,ENDORSEMENT_TAG,CREATED_BY,CREATION_DATE) select '8','14','2','11','D','Q','O','2024','1','0','13','000032',BENEFIT_CODE,SUM_ASSURED,CONTRIBUTION,LAST_UPDATED_BY,LAST_UPDATE_DATE,RIDER_TERM,PAYMENT_TERM,SA_PERCENT,MONTHLY_AMOUNT,RIDER_RATE,REMARKS,DECISION_CODE,LOADING_CONTRIBUTION,LOADING_CONTRIBUTION_MODAL,CONTRIBUTION_MODAL,TOTAL_CONTRIBUTION,TOTAL_CONTRIBUTION_MODAL,RIDER_NET_RATE,NET_CONTRIBUTION_MODAL,NET_CONTRIBUTION,ENDORSEMENT_TAG,'waada',sysdate from TK_ILL_DOC_RIDERS where ORG_ID='8' and BRANCH_ID='14' and MAIN_PRODUCT_CODE='2' and SUB_PRODUCT_CODE='11' and TAKAFUL_TYPE='D' and DOCUMENT_TYPE='Q' and DOCUMENT_NO='000024' and RECORD_TYPE='O' and DOCUMENT_YEAR='2024' and ISSUE_COUNT='1' and ENDORSEMENT_NO='0' and APPLICATION_ID='13' 10/21/2024 4:49:38 AM: ORA-00001: unique constraint (ZEAL_ERP.ILL_RIDER_PK) violated Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00001: unique constraint (ZEAL_ERP.ILL_RIDER_PK) violated 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) 10/21/2024 4:49:38 AM: Insert into TK_ILL_DOC_FUNDS (ORG_ID,BRANCH_ID,MAIN_PRODUCT_CODE,SUB_PRODUCT_CODE,TAKAFUL_TYPE,DOCUMENT_TYPE,RECORD_TYPE,DOCUMENT_YEAR,ISSUE_COUNT,ENDORSEMENT_NO,APPLICATION_ID,DOCUMENT_NO,FUND_CODE,FUND_SHARE,LAST_UPDATED_BY,LAST_UPDATE_DATE,RIDER_TERM,PAYMENT_TERM,SA_PERCENT,MONTHLY_AMOUNT,RIDER_RATE,FUNDS_AMOUNT,ALLOCATION_TAG,CASH_VALUE_DIFF_FINAL,FUND_SHARE_DIFF,FUND_SHARE_NEW,FUND_SHARE_OLD,NO_OF_UNITS,NO_OF_UNITS_OLD,NO_OF_UNITS_NEW,NO_OF_UNITS_DIFF,CASH_VALUE,CASH_VALUE_OLD,CASH_VALUE_NEW,CASH_VALUE_DIFF,BID_PRICE,SERIAL_NO,CREATED_BY,CREATION_DATE) select '8','14','2','11','D','Q','O','2024','1','0','13','000032',FUND_CODE,FUND_SHARE,LAST_UPDATED_BY,LAST_UPDATE_DATE,RIDER_TERM,PAYMENT_TERM,SA_PERCENT,MONTHLY_AMOUNT,RIDER_RATE,FUNDS_AMOUNT,ALLOCATION_TAG,CASH_VALUE_DIFF_FINAL,FUND_SHARE_DIFF,FUND_SHARE_NEW,FUND_SHARE_OLD,NO_OF_UNITS,NO_OF_UNITS_OLD,NO_OF_UNITS_NEW,NO_OF_UNITS_DIFF,CASH_VALUE,CASH_VALUE_OLD,CASH_VALUE_NEW,CASH_VALUE_DIFF,BID_PRICE,SERIAL_NO,'waada',sysdate from TK_ILL_DOC_FUNDS where ORG_ID='8' and BRANCH_ID='14' and MAIN_PRODUCT_CODE='2' and SUB_PRODUCT_CODE='11' and TAKAFUL_TYPE='D' and DOCUMENT_TYPE='Q' and DOCUMENT_NO='000024' and RECORD_TYPE='O' and DOCUMENT_YEAR='2024' and ISSUE_COUNT='1' and ENDORSEMENT_NO='0' and APPLICATION_ID='13' 10/21/2024 4:49:38 AM: ORA-00001: unique constraint (ZEAL_ERP.PK_ILL_DOC_FUND) violated Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00001: unique constraint (ZEAL_ERP.PK_ILL_DOC_FUND) violated 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) 10/21/2024 4:49:38 AM: Insert into IL_DOC_ILLUSTRATION_DTL_T (ORG_ID,BRANCH_ID,MAIN_PRODUCT_CODE,SUB_PRODUCT_CODE,TAKAFUL_TYPE,DOCUMENT_TYPE,RECORD_TYPE,DOCUMENT_YEAR,ISSUE_COUNT,ENDORSEMENT_NO,APPLICATION_ID,DOCUMENT_NO,ILLUSTRATION_ID,EFFECTIVE_AGE,POLICY_YEAR,BASIC_CONTRIBUTION,INVESTED_CONTRIBUTION,ALLOCATION_PERCENTAGE,ALLOCATION_CONTRIBUTION,MORTALITY_RATE1,MORTALITY_RATE2,SUM_ASSURED,SUM_ASSURED_AT_RISK,MORTALITY_CHARGES,PTF_SURPLUS,WAQALA_CHARGES,CONTINGENCY_MARGIN,REINS_AMOUNT,ADMIN_CHARGES,CASH_VALUE1,CASH_VALUE2,CASH_VALUE3,CREATED_BY,CREATION_DATE) select '8','14','2','11','D','Q','O','2024','1','0','13','000032',ILLUSTRATION_ID,EFFECTIVE_AGE,POLICY_YEAR,BASIC_CONTRIBUTION,INVESTED_CONTRIBUTION,ALLOCATION_PERCENTAGE,ALLOCATION_CONTRIBUTION,MORTALITY_RATE1,MORTALITY_RATE2,SUM_ASSURED,SUM_ASSURED_AT_RISK,MORTALITY_CHARGES,PTF_SURPLUS,WAQALA_CHARGES,CONTINGENCY_MARGIN,REINS_AMOUNT,ADMIN_CHARGES,CASH_VALUE1,CASH_VALUE2,CASH_VALUE3,'waada',sysdate from IL_DOC_ILLUSTRATION_DTL_T where ORG_ID='8' and BRANCH_ID='14' and MAIN_PRODUCT_CODE='2' and SUB_PRODUCT_CODE='11' and TAKAFUL_TYPE='D' and DOCUMENT_TYPE='Q' and DOCUMENT_NO='000024' and RECORD_TYPE='O' and DOCUMENT_YEAR='2024' and ISSUE_COUNT='1' and ENDORSEMENT_NO='0' and APPLICATION_ID='13' 10/21/2024 4:49:38 AM: ORA-00001: unique constraint (ZEAL_ERP.PK_IL_DOC_ILL_DTL) violated Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00001: unique constraint (ZEAL_ERP.PK_IL_DOC_ILL_DTL) violated 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) 10/21/2024 4:52:34 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) 10/21/2024 5:03:59 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) 10/21/2024 5:08:25 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) 10/21/2024 5:20: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) 10/21/2024 5:23:21 AM: Face value / Sum Assured cannot be less than Product Setup Main Plan Min SA 290000 ZealERP.ZealFramework.Utils.ZealException: Face value / Sum Assured cannot be less than Product Setup Main Plan Min SA 290000 at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculateContributionOnSA(CommonParamsDataModelForPost record) at ZealERP.ZealTakaful.Controllers.CommonParamsGLASController.<>c__DisplayClass32_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/21/2024 5:23:39 AM: Face value / Sum Assured cannot be less than Product Setup Main Plan Min SA 290000 ZealERP.ZealFramework.Utils.ZealException: Face value / Sum Assured cannot be less than Product Setup Main Plan Min SA 290000 at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculateContributionOnSA(CommonParamsDataModelForPost record) at ZealERP.ZealTakaful.Controllers.CommonParamsGLASController.<>c__DisplayClass32_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/21/2024 5:26:19 AM: delete from TK_ILLUSTRATIONHD_POS where ORG_ID = :ORG_ID and BRANCH_ID = :BRANCH_ID and MAIN_PRODUCT_CODE = :MAIN_PRODUCT_CODE and SUB_PRODUCT_CODE = :SUB_PRODUCT_CODE and DOCUMENT_NO = :DOCUMENT_NO and DOCUMENT_YEAR = :DOCUMENT_YEAR and ISSUE_COUNT = :ISSUE_COUNT and APPLICATION_ID = :APPLICATION_ID params: ORG_ID=8, BRANCH_ID=14, MAIN_PRODUCT_CODE=2, SUB_PRODUCT_CODE=11, DOCUMENT_NO=000049, DOCUMENT_YEAR=2024, ISSUE_COUNT=2, APPLICATION_ID=13 10/21/2024 5:26:19 AM: ORA-02292: integrity constraint (ZEAL_ERP.FK_ILL_POS_DOC_MED_HEADER) violated - child record found Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-02292: integrity constraint (ZEAL_ERP.FK_ILL_POS_DOC_MED_HEADER) violated - child record found 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) 10/21/2024 5:26:19 AM: ORA-02292: integrity constraint (ZEAL_ERP.FK_ILL_POS_DOC_MED_HEADER) violated - child record found Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-02292: integrity constraint (ZEAL_ERP.FK_ILL_POS_DOC_MED_HEADER) violated - child record found 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.DeleteRecord(String TableName, OracleParameter[] parameters, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.IllustrationHeaderUtility.DeleteIllustration(IllustrationHeaderDataModel Illustration, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.IllustrationHeaderUtility.RollbackIllustrationDocument(PostingDataModel model, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.DocHeaderUtilityILAS.<>c__DisplayClass111_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 10/21/2024 5:26:19 AM: ORA-02292: integrity constraint (ZEAL_ERP.FK_ILL_POS_DOC_MED_HEADER) violated - child record found Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-02292: integrity constraint (ZEAL_ERP.FK_ILL_POS_DOC_MED_HEADER) violated - child record found at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealTakaful.Services.ILAS.DocHeaderUtilityILAS.RollbackIllustration(DocumentHeaderModelILAS model) at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass22_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/21/2024 5:28:26 AM: Face value / Sum Assured cannot be less than Product Setup Main Plan Min SA 290000 ZealERP.ZealFramework.Utils.ZealException: Face value / Sum Assured cannot be less than Product Setup Main Plan Min SA 290000 at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculateContributionOnSA(CommonParamsDataModelForPost record) at ZealERP.ZealTakaful.Controllers.CommonParamsGLASController.<>c__DisplayClass32_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/21/2024 5:31:32 AM: Unable to Convert to Proposal, Illustration is Already Revised from Proposal ZealERP.ZealFramework.Utils.ZealException: Unable to Convert to Proposal, Illustration is Already Revised from Proposal at ZealERP.ZealTakaful.Services.ILAS.DocHeaderUtilityILAS.CheckIllustrationAlreadyConvertedToProposal(IllustrationHeaderDataModel Illustration, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.DocHeaderUtilityILAS.ConvertToProposal(PostingDataModel model, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.DocHeaderUtilityILAS.<>c__DisplayClass134_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 10/21/2024 5:31:32 AM: Error.. Unable to Convert to Proposal, Illustration is Already Revised from Proposal ZealERP.ZealFramework.Utils.ZealException: Error.. Unable to Convert to Proposal, Illustration is Already Revised from Proposal at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealTakaful.Services.ILAS.DocHeaderUtilityILAS.ConvertToProposal(PostingDataModel model) at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass19_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/21/2024 5:31:59 AM: Unable to Convert to Proposal, Illustration is Already Revised from Proposal ZealERP.ZealFramework.Utils.ZealException: Unable to Convert to Proposal, Illustration is Already Revised from Proposal at ZealERP.ZealTakaful.Services.ILAS.DocHeaderUtilityILAS.CheckIllustrationAlreadyConvertedToProposal(IllustrationHeaderDataModel Illustration, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.DocHeaderUtilityILAS.ConvertToProposal(PostingDataModel model, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.DocHeaderUtilityILAS.<>c__DisplayClass134_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 10/21/2024 5:31:59 AM: Error.. Unable to Convert to Proposal, Illustration is Already Revised from Proposal ZealERP.ZealFramework.Utils.ZealException: Error.. Unable to Convert to Proposal, Illustration is Already Revised from Proposal at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealTakaful.Services.ILAS.DocHeaderUtilityILAS.ConvertToProposal(PostingDataModel model) at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass19_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/21/2024 5:33:10 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) 10/21/2024 5:38:19 AM: Please Fill Profile Details on Owner Tab. ZealERP.ZealFramework.Utils.ZealException: Please Fill Profile Details on Owner Tab. at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.ValidateOwnerInformation(DocumentHeaderModelILAS doc, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.LockDocument(DocumentHeaderModelILAS doc, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.<>c__DisplayClass32_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 10/21/2024 5:38:19 AM: Error.. Please Fill Profile Details on Owner Tab. ZealERP.ZealFramework.Utils.ZealException: Error.. Please Fill Profile Details on Owner Tab. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.LockDocument(PostingDataModel model) 10/21/2024 5:38:19 AM: Unable to Lock Ref No. 2024000000033-1, Error.. Please Fill Profile Details on Owner Tab. ZealERP.ZealFramework.Utils.ZealException: Unable to Lock Ref No. 2024000000033-1, Error.. Please Fill Profile Details on Owner Tab. at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.LockDocument(PostingDataModel model) at ZealERP.ZealTakaful.Services.ILAS.ProposalEntryService.LockDocument(PostingDataModel model) at ZealERP.ZealTakaful.Controllers.ILAS.ProposalEntryController.<>c__DisplayClass31_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/21/2024 5:44:41 AM: Please fill Contact details. ZealERP.ZealFramework.Utils.ZealException: Please fill Contact details. at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.ValidateOwnerInformation(DocumentHeaderModelILAS doc, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.LockDocument(DocumentHeaderModelILAS doc, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.<>c__DisplayClass32_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 10/21/2024 5:44:41 AM: Error.. Please fill Contact details. ZealERP.ZealFramework.Utils.ZealException: Error.. Please fill Contact details. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.LockDocument(PostingDataModel model) 10/21/2024 5:44:41 AM: Unable to Lock Ref No. 2024000000033-1, Error.. Please fill Contact details. ZealERP.ZealFramework.Utils.ZealException: Unable to Lock Ref No. 2024000000033-1, Error.. Please fill Contact details. at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.LockDocument(PostingDataModel model) at ZealERP.ZealTakaful.Services.ILAS.ProposalEntryService.LockDocument(PostingDataModel model) at ZealERP.ZealTakaful.Controllers.ILAS.ProposalEntryController.<>c__DisplayClass31_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/21/2024 5:45:56 AM: Please fill Contact details. ZealERP.ZealFramework.Utils.ZealException: Please fill Contact details. at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.ValidateOwnerInformation(DocumentHeaderModelILAS doc, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.LockDocument(DocumentHeaderModelILAS doc, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.<>c__DisplayClass32_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 10/21/2024 5:45:56 AM: Error.. Please fill Contact details. ZealERP.ZealFramework.Utils.ZealException: Error.. Please fill Contact details. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.LockDocument(PostingDataModel model) 10/21/2024 5:45:56 AM: Unable to Lock Ref No. 2024000000033-1, Error.. Please fill Contact details. ZealERP.ZealFramework.Utils.ZealException: Unable to Lock Ref No. 2024000000033-1, Error.. Please fill Contact details. at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.LockDocument(PostingDataModel model) at ZealERP.ZealTakaful.Services.ILAS.ProposalEntryService.LockDocument(PostingDataModel model) at ZealERP.ZealTakaful.Controllers.ILAS.ProposalEntryController.<>c__DisplayClass31_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/21/2024 5:46:22 AM: Please fill Beneficiary details. ZealERP.ZealFramework.Utils.ZealException: Please fill Beneficiary details. at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.LockDocument(DocumentHeaderModelILAS doc, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.<>c__DisplayClass32_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 10/21/2024 5:46:22 AM: Error.. Please fill Beneficiary details. ZealERP.ZealFramework.Utils.ZealException: Error.. Please fill Beneficiary details. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.LockDocument(PostingDataModel model) 10/21/2024 5:46:22 AM: Unable to Lock Ref No. 2024000000033-1, Error.. Please fill Beneficiary details. ZealERP.ZealFramework.Utils.ZealException: Unable to Lock Ref No. 2024000000033-1, Error.. Please fill Beneficiary details. at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.LockDocument(PostingDataModel model) at ZealERP.ZealTakaful.Services.ILAS.ProposalEntryService.LockDocument(PostingDataModel model) at ZealERP.ZealTakaful.Controllers.ILAS.ProposalEntryController.<>c__DisplayClass31_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/21/2024 5:50:34 AM: Directory not found, creating directory.. D:\AAK\ZealERP\Uploads\ClientUploads\2024000000033-2 10/21/2024 5:53:34 AM: Invalid Credentials ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials 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) 10/21/2024 5:53:34 AM: **************************** Error at Login Request for User GBA.Admin, Message: Invalid Credentials **************************** 10/21/2024 5:53: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) 10/21/2024 5:59:37 AM: 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) 10/21/2024 6:58: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) 10/21/2024 7:32: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) 10/21/2024 8:38:31 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) 10/21/2024 11:30:15 AM: insert into SM_USER_LOGIN_HIST_T (SERIAL_NO,USERNAME,PASSWORD,IP_ADDRESS,OTHER_INFO,STATUS_TAG,STATUS_MESSAGE,CREATION_DATE) values (:SERIAL_NO,:USERNAME,:PASSWORD,:IP_ADDRESS,:OTHER_INFO,:STATUS_TAG,:STATUS_MESSAGE,:CREATION_DATE) params: SERIAL_NO=8992, USERNAME=global.tips, PASSWORD=NzQIV/3DhyDBOHQL99iW9nX7A2Nl7uVS/irlGhujDRJTt+nADsEq2Z+yvzbw2qBZyyxMYhyENwxG9b3f2ZriLWvLXi2DovTTlBDUXe8HPyRJu2077/sD45hH0jB/OuGf, IP_ADDRESS=116.90.110.236, OTHER_INFO={"Cache-Control":"max-age=0","Connection":"close","Content-Length":"449","Content-Type":"application/x-www-form-urlencoded","Accept":"text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7","Accept-Encoding":"gzip, deflate, br, zstd","Accept-Language":"en-PK,en-US;q=0.9,en;q=0.8","Host":"yoonek.thzeal.com","Referer":"https://yoonek.thzeal.com/ZealERP/Login.aspx","User-Agent":"Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Mobile Safari/537.36","sec-ch-ua":"\"Chromium\";v=\"130\", \"Google Chrome\";v=\"130\", \"Not?A_Brand\";v=\"99\"","sec-ch-ua-mobile":"?1","sec-ch-ua-platform":"\"Android\"","origin":"https://yoonek.thzeal.com","upgrade-insecure-requests":"1","sec-fetch-site":"same-origin","sec-fetch-mode":"navigate","sec-fetch-user":"?1","sec-fetch-dest":"document","priority":"u=0, i","APPL_MD_PATH":"/LM/W3SVC/1/ROOT/ZealERP","APPL_PHYSICAL_PATH":"D:\\AAK\\ZealERP\\","CERT_KEYSIZE":"256","CERT_SECRETKEYSIZE":"2048","CERT_SERVER_ISSUER":"C=US, S=Arizona, L=Scottsdale, O=\"GoDaddy.com, Inc.\", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2","CERT_SERVER_SUBJECT":"CN=yoonek.thzeal.com","CONTENT_LENGTH":"449","CONTENT_TYPE":"application/x-www-form-urlencoded","GATEWAY_INTERFACE":"CGI/1.1","HTTPS":"on","HTTPS_KEYSIZE":"256","HTTPS_SECRETKEYSIZE":"2048","HTTPS_SERVER_ISSUER":"C=US, S=Arizona, L=Scottsdale, O=\"GoDaddy.com, Inc.\", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2","HTTPS_SERVER_SUBJECT":"CN=yoonek.thzeal.com","INSTANCE_ID":"1","INSTANCE_META_PATH":"/LM/W3SVC/1","LOCAL_ADDR":"193.168.10.106","PATH_INFO":"/ZealERP/Login.aspx","PATH_TRANSLATED":"D:\\AAK\\ZealERP\\Login.aspx","REMOTE_ADDR":"116.90.110.236","REMOTE_HOST":"116.90.110.236","REMOTE_PORT":"7204","REQUEST_METHOD":"POST","SCRIPT_NAME":"/ZealERP/Login.aspx","SERVER_NAME":"yoonek.thzeal.com","SERVER_PORT":"443","SERVER_PORT_SECURE":"1","SERVER_PROTOCOL":"HTTP/1.1","SERVER_SOFTWARE":"Microsoft-IIS/10.0","URL":"/ZealERP/Login.aspx","HTTP_CACHE_CONTROL":"max-age=0","HTTP_CONNECTION":"close","HTTP_CONTENT_LENGTH":"449","HTTP_CONTENT_TYPE":"application/x-www-form-urlencoded","HTTP_ACCEPT":"text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7","HTTP_ACCEPT_ENCODING":"gzip, deflate, br, zstd","HTTP_ACCEPT_LANGUAGE":"en-PK,en-US;q=0.9,en;q=0.8","HTTP_HOST":"yoonek.thzeal.com","HTTP_REFERER":"https://yoonek.thzeal.com/ZealERP/Login.aspx","HTTP_USER_AGENT":"Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Mobile Safari/537.36","HTTP_SEC_CH_UA":"\"Chromium\";v=\"130\", \"Google Chrome\";v=\"130\", \"Not?A_Brand\";v=\"99\"","HTTP_SEC_CH_UA_MOBILE":"?1","HTTP_SEC_CH_UA_PLATFORM":"\"Android\"","HTTP_ORIGIN":"https://yoonek.thzeal.com","HTTP_UPGRADE_INSECURE_REQUESTS":"1","HTTP_SEC_FETCH_SITE":"same-origin","HTTP_SEC_FETCH_MODE":"navigate","HTTP_SEC_FETCH_USER":"?1","HTTP_SEC_FETCH_DEST":"document","HTTP_PRIORITY":"u=0, i","browser-type":"Chrome130","browser-version":"130.0","browser-platform":"Unknown"}, STATUS_TAG=S, STATUS_MESSAGE=success, CREATION_DATE=10/21/2024 11:30:14 PM 10/21/2024 11:30:15 AM: ORA-00001: unique constraint (ZEAL_ERP.PK_USER_LOGIN_HIST) violated Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00001: unique constraint (ZEAL_ERP.PK_USER_LOGIN_HIST) violated 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) 10/21/2024 11:30:15 AM: ORA-00001: unique constraint (ZEAL_ERP.PK_USER_LOGIN_HIST) violated Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00001: unique constraint (ZEAL_ERP.PK_USER_LOGIN_HIST) violated 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.ZealSecurity.Services.NewSecurity.UserService.InsertUserLoginHistory(String UserName, String Password, String StatusTag, String StatusMessage, OracleCommand command) 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) 10/21/2024 11:30:15 AM: **************************** Error at Login Request for User global.tips, Message: Application Error. Please Contact Vendor or Refer Logs. **************************** 10/21/2024 11:30:26 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) 10/21/2024 11:38: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) 10/21/2024 11:44: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) 10/21/2024 10:40:42 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) 10/21/2024 10:52:42 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) 10/21/2024 11:09:43 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) 10/21/2024 11:30: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) 10/21/2024 11:34: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)