Log File Initialized... 10/4/2024 1:15:09 AM 10/4/2024 1:15: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) 10/4/2024 1:32:49 AM: The maximum allowed amount is 30000\. You have already Policies amount of 23300\. and adding more 11400\. will result in 34700\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 30000\. You have already Policies amount of 23300\. and adding more 11400\. will result in 34700\. which is greater than 30000\. at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.ValidateAmounts(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.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) 10/4/2024 1:32:49 AM: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 23300\. and adding more 11400\. will result in 34700\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 23300\. and adding more 11400\. will result in 34700\. which is greater than 30000\. 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() 10/4/2024 1:33:36 AM: The maximum allowed amount is 30000\. You have already Policies amount of 23300\. and adding more 11400\. will result in 34700\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 30000\. You have already Policies amount of 23300\. and adding more 11400\. will result in 34700\. which is greater than 30000\. at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.ValidateAmounts(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.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) 10/4/2024 1:33:36 AM: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 23300\. and adding more 11400\. will result in 34700\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 23300\. and adding more 11400\. will result in 34700\. which is greater than 30000\. 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() 10/4/2024 1:39:20 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/4/2024 1:42: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/4/2024 1:54:16 AM: Minimum Payment Term Allowed on Selected Product Rider Terminal Illness Benefit is 5 ZealERP.ZealFramework.Utils.ZealException: Minimum Payment Term Allowed on Selected Product Rider Terminal Illness Benefit is 5 at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.ValidateFinancialValuesFromProduct(IllustrationHeaderDataModel doc, OracleCommand command, Boolean fromPOS) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, OracleCommand command, Boolean fromPOS) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.<>c__DisplayClass29_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 10/4/2024 1:54:16 AM: Error.. Minimum Payment Term Allowed on Selected Product Rider Terminal Illness Benefit is 5 ZealERP.ZealFramework.Utils.ZealException: Error.. Minimum Payment Term Allowed on Selected Product Rider Terminal Illness Benefit is 5 at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, Boolean fromPOS) at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass17_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/4/2024 1:54:58 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/4/2024 1:54:59 AM: Minimum Payment Term Allowed on Selected Product Rider Terminal Illness Benefit is 5 ZealERP.ZealFramework.Utils.ZealException: Minimum Payment Term Allowed on Selected Product Rider Terminal Illness Benefit is 5 at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.ValidateFinancialValuesFromProduct(IllustrationHeaderDataModel doc, OracleCommand command, Boolean fromPOS) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, OracleCommand command, Boolean fromPOS) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.<>c__DisplayClass29_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 10/4/2024 1:54:59 AM: Error.. Minimum Payment Term Allowed on Selected Product Rider Terminal Illness Benefit is 5 ZealERP.ZealFramework.Utils.ZealException: Error.. Minimum Payment Term Allowed on Selected Product Rider Terminal Illness Benefit is 5 at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, Boolean fromPOS) at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass17_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/4/2024 2:25: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/4/2024 2:26: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) 10/4/2024 2:43:19 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/4/2024 3:26: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/4/2024 3:32: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/4/2024 4:46:11 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/4/2024 5:01:36 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/4/2024 5:13: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/4/2024 5:15:23 AM: Rate not found in Rating Table for date 04/10/2024 and year 1 ZealERP.ZealFramework.Utils.ZealException: Rate not found in Rating Table for date 04/10/2024 and year 1 at ZealERP.ZealTakaful.Services.ILAS.RatingService.GetRateFromRatingTable(String FieldName, String FieldLabel, IllustrationCalculationDataModel model, Int32 RiderTerm, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.RatingService.GetRiderRate(IllustrationCalculationDataModel model, IllustrationRiderDataModel rider, OracleCommand command, Boolean IgnoreException) at ZealERP.ZealTakaful.Services.ILAS.RatingService.GetRiderRate(IllustrationCalculationDataModel model, IllustrationRiderDataModel rider) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, OracleCommand command, Boolean fromPOS) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.<>c__DisplayClass29_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 10/4/2024 5:15:23 AM: Error.. Rate not found in Rating Table for date 04/10/2024 and year 1 ZealERP.ZealFramework.Utils.ZealException: Error.. Rate not found in Rating Table for date 04/10/2024 and year 1 at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, Boolean fromPOS) at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass17_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/4/2024 5:16:21 AM: Rate not found in Rating Table for date 04/10/2024 and year 10 ZealERP.ZealFramework.Utils.ZealException: Rate not found in Rating Table for date 04/10/2024 and year 10 at ZealERP.ZealTakaful.Services.ILAS.RatingService.GetRateFromRatingTable(String FieldName, String FieldLabel, IllustrationCalculationDataModel model, Int32 RiderTerm, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.RatingService.GetRiderRate(IllustrationCalculationDataModel model, IllustrationRiderDataModel rider, OracleCommand command, Boolean IgnoreException) at ZealERP.ZealTakaful.Services.ILAS.RatingService.GetRiderRate(IllustrationCalculationDataModel model, IllustrationRiderDataModel rider) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, OracleCommand command, Boolean fromPOS) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.<>c__DisplayClass29_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 10/4/2024 5:16:21 AM: Error.. Rate not found in Rating Table for date 04/10/2024 and year 10 ZealERP.ZealFramework.Utils.ZealException: Error.. Rate not found in Rating Table for date 04/10/2024 and year 10 at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, Boolean fromPOS) at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass17_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/4/2024 5:16: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) 10/4/2024 5:16:28 AM: Empty path name is not legal. System.ArgumentException: Empty path name is not legal. at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access) at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetImage(FileDownload FileLogic) 10/4/2024 5:16:47 AM: Empty path name is not legal. System.ArgumentException: Empty path name is not legal. at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access) at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetImage(FileDownload FileLogic) 10/4/2024 5:23:52 AM: Empty path name is not legal. System.ArgumentException: Empty path name is not legal. at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access) at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetImage(FileDownload FileLogic) 10/4/2024 5:37:23 AM: Empty path name is not legal. System.ArgumentException: Empty path name is not legal. at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access) at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetImage(FileDownload FileLogic) 10/4/2024 6:11:16 AM: insert into IL_RATING_TABLE_BANDS_T (ORG_ID,SUB_PRODUCT_CODE,MAIN_PRODUCT_CODE,HD_RATE_ID,HD_RATE_BAND_ID,BENEFIT_CODE,VAL_FROM,VAL_TO,BANDS_DESCRIPTION,EFFECTIVE_FROM,EFFECTIVE_TO,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE) values (:ORG_ID,:SUB_PRODUCT_CODE,:MAIN_PRODUCT_CODE,:HD_RATE_ID,:HD_RATE_BAND_ID,:BENEFIT_CODE,:VAL_FROM,:VAL_TO,:BANDS_DESCRIPTION,:EFFECTIVE_FROM,:EFFECTIVE_TO,:CREATED_BY,:CREATION_DATE,:LAST_UPDATED_BY,:LAST_UPDATE_DATE) params: ORG_ID=8, SUB_PRODUCT_CODE=11, MAIN_PRODUCT_CODE=2, HD_RATE_ID=1, HD_RATE_BAND_ID=1, BENEFIT_CODE=7, VAL_FROM=0, VAL_TO=9999999999, BANDS_DESCRIPTION=Critical illness Rates band, EFFECTIVE_FROM=1/1/2024 6:11:16 AM, EFFECTIVE_TO=, CREATED_BY=waada, CREATION_DATE=10/4/2024 6:11:15 PM, LAST_UPDATED_BY=waada, LAST_UPDATE_DATE=10/4/2024 6:11:15 PM 10/4/2024 6:11:16 AM: ORA-00001: unique constraint (ZEAL_ERP.IL_RATING_TABLE_BANDS_T_PK) violated Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00001: unique constraint (ZEAL_ERP.IL_RATING_TABLE_BANDS_T_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/4/2024 6:11:16 AM: ORA-00001: unique constraint (ZEAL_ERP.IL_RATING_TABLE_BANDS_T_PK) violated Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00001: unique constraint (ZEAL_ERP.IL_RATING_TABLE_BANDS_T_PK) 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.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) 10/4/2024 6:11:16 AM: ORA-00001: unique constraint (ZEAL_ERP.IL_RATING_TABLE_BANDS_T_PK) violated Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00001: unique constraint (ZEAL_ERP.IL_RATING_TABLE_BANDS_T_PK) violated 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() 10/4/2024 6:11:33 AM: insert into IL_RATING_TABLE_BANDS_T (ORG_ID,SUB_PRODUCT_CODE,MAIN_PRODUCT_CODE,HD_RATE_ID,HD_RATE_BAND_ID,BENEFIT_CODE,VAL_FROM,VAL_TO,BANDS_DESCRIPTION,EFFECTIVE_FROM,EFFECTIVE_TO,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE) values (:ORG_ID,:SUB_PRODUCT_CODE,:MAIN_PRODUCT_CODE,:HD_RATE_ID,:HD_RATE_BAND_ID,:BENEFIT_CODE,:VAL_FROM,:VAL_TO,:BANDS_DESCRIPTION,:EFFECTIVE_FROM,:EFFECTIVE_TO,:CREATED_BY,:CREATION_DATE,:LAST_UPDATED_BY,:LAST_UPDATE_DATE) params: ORG_ID=8, SUB_PRODUCT_CODE=11, MAIN_PRODUCT_CODE=2, HD_RATE_ID=1, HD_RATE_BAND_ID=1, BENEFIT_CODE=7, VAL_FROM=0, VAL_TO=9999999999, BANDS_DESCRIPTION=Critical illness Rates band, EFFECTIVE_FROM=1/1/2024 6:11:33 AM, EFFECTIVE_TO=, CREATED_BY=waada, CREATION_DATE=10/4/2024 6:11:33 PM, LAST_UPDATED_BY=waada, LAST_UPDATE_DATE=10/4/2024 6:11:33 PM 10/4/2024 6:11:33 AM: ORA-00001: unique constraint (ZEAL_ERP.IL_RATING_TABLE_BANDS_T_PK) violated Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00001: unique constraint (ZEAL_ERP.IL_RATING_TABLE_BANDS_T_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/4/2024 6:11:33 AM: ORA-00001: unique constraint (ZEAL_ERP.IL_RATING_TABLE_BANDS_T_PK) violated Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00001: unique constraint (ZEAL_ERP.IL_RATING_TABLE_BANDS_T_PK) 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.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) 10/4/2024 6:11:33 AM: ORA-00001: unique constraint (ZEAL_ERP.IL_RATING_TABLE_BANDS_T_PK) violated Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00001: unique constraint (ZEAL_ERP.IL_RATING_TABLE_BANDS_T_PK) violated 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() 10/4/2024 6:12:09 AM: insert into IL_RATING_TABLE_BANDS_T (ORG_ID,SUB_PRODUCT_CODE,MAIN_PRODUCT_CODE,HD_RATE_ID,HD_RATE_BAND_ID,BENEFIT_CODE,VAL_FROM,VAL_TO,BANDS_DESCRIPTION,EFFECTIVE_FROM,EFFECTIVE_TO,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE) values (:ORG_ID,:SUB_PRODUCT_CODE,:MAIN_PRODUCT_CODE,:HD_RATE_ID,:HD_RATE_BAND_ID,:BENEFIT_CODE,:VAL_FROM,:VAL_TO,:BANDS_DESCRIPTION,:EFFECTIVE_FROM,:EFFECTIVE_TO,:CREATED_BY,:CREATION_DATE,:LAST_UPDATED_BY,:LAST_UPDATE_DATE) params: ORG_ID=8, SUB_PRODUCT_CODE=11, MAIN_PRODUCT_CODE=2, HD_RATE_ID=1, HD_RATE_BAND_ID=1, BENEFIT_CODE=7, VAL_FROM=0, VAL_TO=9999999999, BANDS_DESCRIPTION=Critical illness Rates band, EFFECTIVE_FROM=1/1/2024 6:12:09 AM, EFFECTIVE_TO=, CREATED_BY=waada, CREATION_DATE=10/4/2024 6:12:09 PM, LAST_UPDATED_BY=waada, LAST_UPDATE_DATE=10/4/2024 6:12:09 PM 10/4/2024 6:12:09 AM: ORA-00001: unique constraint (ZEAL_ERP.IL_RATING_TABLE_BANDS_T_PK) violated Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00001: unique constraint (ZEAL_ERP.IL_RATING_TABLE_BANDS_T_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/4/2024 6:12:09 AM: ORA-00001: unique constraint (ZEAL_ERP.IL_RATING_TABLE_BANDS_T_PK) violated Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00001: unique constraint (ZEAL_ERP.IL_RATING_TABLE_BANDS_T_PK) 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.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) 10/4/2024 6:12:09 AM: ORA-00001: unique constraint (ZEAL_ERP.IL_RATING_TABLE_BANDS_T_PK) violated Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00001: unique constraint (ZEAL_ERP.IL_RATING_TABLE_BANDS_T_PK) violated 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() 10/4/2024 6:21: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/4/2024 6:27: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/4/2024 7:44: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/4/2024 8:08:50 AM: Rate not found in Rating Table for date 04/10/2024 and year 1 ZealERP.ZealFramework.Utils.ZealException: Rate not found in Rating Table for date 04/10/2024 and year 1 at ZealERP.ZealTakaful.Services.ILAS.RatingService.GetRateFromRatingTable(String FieldName, String FieldLabel, IllustrationCalculationDataModel model, Int32 RiderTerm, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.RatingService.GetRiderRate(IllustrationCalculationDataModel model, IllustrationRiderDataModel rider, OracleCommand command, Boolean IgnoreException) at ZealERP.ZealTakaful.Services.ILAS.RatingService.GetRiderRate(IllustrationCalculationDataModel model, IllustrationRiderDataModel rider) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, OracleCommand command, Boolean fromPOS) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.<>c__DisplayClass29_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 10/4/2024 8:08:50 AM: Error.. Rate not found in Rating Table for date 04/10/2024 and year 1 ZealERP.ZealFramework.Utils.ZealException: Error.. Rate not found in Rating Table for date 04/10/2024 and year 1 at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, Boolean fromPOS) at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass17_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/4/2024 8:16:48 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=8354, USERNAME=alasrtravel.tours, PASSWORD=GhZ9Ge/3M4M1pS9LQe+o5IYnmI/6a7cZEseaJVcseRo4GiHED6nm86rmx2d6tJmdcs+JogLfnHRaN6OecGagCGob+4lRt7HHaad8vXoz+yI5bHWhtk3Msl+nip+/K1WQ, IP_ADDRESS=39.48.128.213, OTHER_INFO={"Cache-Control":"max-age=0","Connection":"close","Content-Length":"450","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","Accept-Language":"en-US,en;q=0.9","Host":"yoonek.thzeal.com","Referer":"https://yoonek.thzeal.com/ZealERP/Login.aspx","User-Agent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36","sec-ch-ua":"\"Google Chrome\";v=\"129\", \"Not=A?Brand\";v=\"8\", \"Chromium\";v=\"129\"","sec-ch-ua-mobile":"?0","sec-ch-ua-platform":"\"Windows\"","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\\","AUTH_TYPE":"Forms","AUTH_USER":"alasrtravel.tours","LOGON_USER":"alasrtravel.tours","REMOTE_USER":"alasrtravel.tours","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":"450","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":"39.48.128.213","REMOTE_HOST":"39.48.128.213","REMOTE_PORT":"50014","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":"450","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","HTTP_ACCEPT_LANGUAGE":"en-US,en;q=0.9","HTTP_HOST":"yoonek.thzeal.com","HTTP_REFERER":"https://yoonek.thzeal.com/ZealERP/Login.aspx","HTTP_USER_AGENT":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36","HTTP_SEC_CH_UA":"\"Google Chrome\";v=\"129\", \"Not=A?Brand\";v=\"8\", \"Chromium\";v=\"129\"","HTTP_SEC_CH_UA_MOBILE":"?0","HTTP_SEC_CH_UA_PLATFORM":"\"Windows\"","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":"Chrome129","browser-version":"129.0","browser-platform":"WinNT"}, STATUS_TAG=S, STATUS_MESSAGE=success, CREATION_DATE=10/4/2024 8:16:48 PM 10/4/2024 8:16:48 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/4/2024 8:16:48 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/4/2024 8:16:48 AM: **************************** Error at Login Request for User alasrtravel.tours, Message: Application Error. Please Contact Vendor or Refer Logs. **************************** 10/4/2024 8:16: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/4/2024 8:28:16 AM: The maximum allowed amount is 250000\. You have already Policies amount of 246450\. and adding more 11400\. will result in 257850\. which is greater than 250000\. ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 250000\. You have already Policies amount of 246450\. and adding more 11400\. will result in 257850\. which is greater than 250000\. at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.ValidateAmounts(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.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) 10/4/2024 8:28:16 AM: Error.. The maximum allowed amount is 250000\. You have already Policies amount of 246450\. and adding more 11400\. will result in 257850\. which is greater than 250000\. ZealERP.ZealFramework.Utils.ZealException: Error.. The maximum allowed amount is 250000\. You have already Policies amount of 246450\. and adding more 11400\. will result in 257850\. which is greater than 250000\. 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() 10/4/2024 8:28:25 AM: The maximum allowed amount is 250000\. You have already Policies amount of 246450\. and adding more 11400\. will result in 257850\. which is greater than 250000\. ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 250000\. You have already Policies amount of 246450\. and adding more 11400\. will result in 257850\. which is greater than 250000\. at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.ValidateAmounts(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.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) 10/4/2024 8:28:25 AM: Error.. The maximum allowed amount is 250000\. You have already Policies amount of 246450\. and adding more 11400\. will result in 257850\. which is greater than 250000\. ZealERP.ZealFramework.Utils.ZealException: Error.. The maximum allowed amount is 250000\. You have already Policies amount of 246450\. and adding more 11400\. will result in 257850\. which is greater than 250000\. 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() 10/4/2024 8:32: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) 10/4/2024 9:05:10 AM: Sum Covered % not found on rider, please re-check ZealERP.ZealFramework.Utils.ZealException: Sum Covered % not found on rider, please re-check at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, OracleCommand command, Boolean fromPOS) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.<>c__DisplayClass29_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 10/4/2024 9:05:10 AM: Error.. Sum Covered % not found on rider, please re-check ZealERP.ZealFramework.Utils.ZealException: Error.. Sum Covered % not found on rider, please re-check at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, Boolean fromPOS) at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass17_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/4/2024 9:10:41 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(CommonParamsOrgDTO record) at ZealERP.ZealTakaful.Controllers.CommonParamsGLASController.<>c__DisplayClass32_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/4/2024 9:10:41 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(CommonParamsOrgDTO record) at ZealERP.ZealTakaful.Controllers.CommonParamsGLASController.<>c__DisplayClass32_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/4/2024 9:10:42 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(CommonParamsOrgDTO record) at ZealERP.ZealTakaful.Controllers.CommonParamsGLASController.<>c__DisplayClass32_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/4/2024 9:11:06 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(CommonParamsOrgDTO record) at ZealERP.ZealTakaful.Controllers.CommonParamsGLASController.<>c__DisplayClass32_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/4/2024 9:12:31 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(CommonParamsOrgDTO record) at ZealERP.ZealTakaful.Controllers.CommonParamsGLASController.<>c__DisplayClass32_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/4/2024 9:14:14 AM: Sum Covered % not found on rider, please re-check ZealERP.ZealFramework.Utils.ZealException: Sum Covered % not found on rider, please re-check at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, OracleCommand command, Boolean fromPOS) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.<>c__DisplayClass29_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 10/4/2024 9:14:14 AM: Error.. Sum Covered % not found on rider, please re-check ZealERP.ZealFramework.Utils.ZealException: Error.. Sum Covered % not found on rider, please re-check at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, Boolean fromPOS) at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass17_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/4/2024 9:20:45 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/4/2024 11:00:41 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/4/2024 12:54:29 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/4/2024 1:18:23 PM: GENERATE_IL_DETAIL_POS_P params: @P_ORG_ID=8, @P_BRANCH_ID=14, @P_MAIN_PRODUCT_CODE=2, @P_SUB_PRODUCT_CODE=11, @P_ISSUE_COUNT=1, @P_DOCUMENT_NO=000021, @P_DOCUMENT_YEAR=2024, @P_APPLICATION_ID=13, @P_ILLUSTRATION_ID=1 10/4/2024 1:18:23 PM: ORA-01403: no data found ORA-06512: at "ZEAL_ERP.UPDATE_ILLUST_CASHVALUE_POS_P", line 105 ORA-06512: at "ZEAL_ERP.GENERATE_IL_DETAIL_POS_P", line 618 ORA-06512: at line 1 Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01403: no data found ORA-06512: at "ZEAL_ERP.UPDATE_ILLUST_CASHVALUE_POS_P", line 105 ORA-06512: at "ZEAL_ERP.GENERATE_IL_DETAIL_POS_P", line 618 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(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) 10/4/2024 1:18:23 PM: ORA-01403: no data found ORA-06512: at "ZEAL_ERP.UPDATE_ILLUST_CASHVALUE_POS_P", line 105 ORA-06512: at "ZEAL_ERP.GENERATE_IL_DETAIL_POS_P", line 618 ORA-06512: at line 1 Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01403: no data found ORA-06512: at "ZEAL_ERP.UPDATE_ILLUST_CASHVALUE_POS_P", line 105 ORA-06512: at "ZEAL_ERP.GENERATE_IL_DETAIL_POS_P", line 618 ORA-06512: at line 1 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.SelectSp(String SpName, OracleParameter[] commandParameters) at ZealERP.ZealFramework.Utils.DB.ExecuteSP(String SpName, OracleParameter[] oracleParameters, String CRUDType) 10/4/2024 1:18:23 PM: ORA-01403: no data found ORA-06512: at "ZEAL_ERP.UPDATE_ILLUST_CASHVALUE_POS_P", line 105 ORA-06512: at "ZEAL_ERP.GENERATE_IL_DETAIL_POS_P", line 618 ORA-06512: at line 1 System.Exception: ORA-01403: no data found ORA-06512: at "ZEAL_ERP.UPDATE_ILLUST_CASHVALUE_POS_P", line 105 ORA-06512: at "ZEAL_ERP.GENERATE_IL_DETAIL_POS_P", line 618 ORA-06512: at line 1 at ZealERP.ZealFramework.Utils.DB.ExecuteSP(String SpName, OracleParameter[] oracleParameters, String CRUDType) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.GenerateIllustrationDataForPOS(IllustrationDataModel record) at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass4_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/4/2024 7:50:50 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.Services.ILAS.IllustrationHeaderUtility.GetDocObjFromReferenceKey(String key) at ZealERP.ZealTakaful.Services.ILAS.IllustrationHeaderUtility.GetDocObj(String ReferenceKey, OracleCommand transaction) at ZealERP.ZealTakaful.Reports.Illustration.Illustration.PrepareReport() 10/4/2024 7:50:50 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.Services.ILAS.IllustrationHeaderUtility.GetDocObjFromReferenceKey(String key) at ZealERP.ZealTakaful.Services.ILAS.IllustrationHeaderUtility.GetDocObj(String ReferenceKey, OracleCommand transaction) at ZealERP.ZealTakaful.Reports.Illustration.Illustration.PrepareReport() 10/4/2024 9:03:07 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)