Log File Initialized... 8/4/2024 4:53:21 AM 8/4/2024 4:53:21 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) 8/4/2024 4:53: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) 8/4/2024 6:04:11 AM: Cache Cleared.... 8/4/2024 6:04:27 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) 8/4/2024 6:04:50 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) 8/4/2024 6:06:19 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) 8/4/2024 6:09:31 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) 8/4/2024 6:10:13 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) 8/4/2024 6:13:16 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) 8/4/2024 6:13:16 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) 8/4/2024 6:14:29 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) 8/4/2024 6:14:58 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) 8/4/2024 6:19:29 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) 8/4/2024 6:19:35 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) 8/4/2024 6:30:34 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) 8/4/2024 6:30:41 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) 8/4/2024 6:47:02 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) 8/4/2024 6:47:07 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) 8/4/2024 6:53:02 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) 8/4/2024 6:53:08 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) 8/4/2024 6:57:31 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) 8/4/2024 6:57:43 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) 8/4/2024 7:01:01 AM: Reverse calculation process failed. Target value not found for target year: 2034 ZealERP.ZealFramework.Utils.ZealException: Reverse calculation process failed. Target value not found for target year: 2034 at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.GetTargetCashValue(IllustrationCalculationDataModel record, IllustrationHeaderDataModel model, OracleCommand command) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.RunReverseCalculationProcess(IllustrationCalculationDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.<>c__DisplayClass42_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 8/4/2024 7:01:01 AM: Error.. Reverse calculation process failed. Target value not found for target year: 2034 ZealERP.ZealFramework.Utils.ZealException: Error.. Reverse calculation process failed. Target value not found for target year: 2034 at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.RunReverseCalculationProcess(IllustrationCalculationDataModel record) at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass22_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 8/4/2024 7:01:14 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) 8/4/2024 7:01:59 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) 8/4/2024 7:02:32 AM: GENERATE_IL_DETAIL_POS_P params: @P_ORG_ID=8, @P_BRANCH_ID=14, @P_MAIN_PRODUCT_CODE=1, @P_SUB_PRODUCT_CODE=7, @P_ISSUE_COUNT=1, @P_DOCUMENT_NO=000001, @P_DOCUMENT_YEAR=2024, @P_APPLICATION_ID=13, @P_ILLUSTRATION_ID=1 8/4/2024 7:02:32 AM: 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 418 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 418 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) 8/4/2024 7:02:32 AM: 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 418 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 418 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) 8/4/2024 7:02:32 AM: 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 418 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 418 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) 8/4/2024 10:11:41 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) 8/4/2024 10:12:00 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) 8/4/2024 10:12:20 AM: GENERATE_IL_DETAIL_MONTHLY_P params: @P_ORG_ID=8, @P_BRANCH_ID=14, @P_MAIN_PRODUCT_CODE=1, @P_SUB_PRODUCT_CODE=7, @P_ISSUE_COUNT=1, @P_DOCUMENT_NO=000001, @P_DOCUMENT_YEAR=2024, @P_APPLICATION_ID=13, @P_ILLUSTRATION_ID=1 8/4/2024 10:12:20 AM: ORA-01403: no data found ORA-06512: at "ZEAL_ERP.UPDATE_ILLUST_CV_MONTHLY_P", line 69 ORA-06512: at "ZEAL_ERP.GENERATE_IL_DETAIL_MONTHLY_P", line 852 ORA-06512: at line 1 Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01403: no data found ORA-06512: at "ZEAL_ERP.UPDATE_ILLUST_CV_MONTHLY_P", line 69 ORA-06512: at "ZEAL_ERP.GENERATE_IL_DETAIL_MONTHLY_P", line 852 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) 8/4/2024 10:12:20 AM: ORA-01403: no data found ORA-06512: at "ZEAL_ERP.UPDATE_ILLUST_CV_MONTHLY_P", line 69 ORA-06512: at "ZEAL_ERP.GENERATE_IL_DETAIL_MONTHLY_P", line 852 ORA-06512: at line 1 Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01403: no data found ORA-06512: at "ZEAL_ERP.UPDATE_ILLUST_CV_MONTHLY_P", line 69 ORA-06512: at "ZEAL_ERP.GENERATE_IL_DETAIL_MONTHLY_P", line 852 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) 8/4/2024 10:12:20 AM: ORA-01403: no data found ORA-06512: at "ZEAL_ERP.UPDATE_ILLUST_CV_MONTHLY_P", line 69 ORA-06512: at "ZEAL_ERP.GENERATE_IL_DETAIL_MONTHLY_P", line 852 ORA-06512: at line 1 System.Exception: ORA-01403: no data found ORA-06512: at "ZEAL_ERP.UPDATE_ILLUST_CV_MONTHLY_P", line 69 ORA-06512: at "ZEAL_ERP.GENERATE_IL_DETAIL_MONTHLY_P", line 852 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) 8/4/2024 10:22:51 AM: No Underwriting Period found for date 04/08/2024 ZealERP.ZealFramework.Utils.ZealException: No Underwriting Period found for date 04/08/2024 at ZealERP.ZealTakaful.Services.GLAS.PeriodSetupService.GetPeriodInfoTakaful(Int32 OrgId, Int32 BranchId, Int32 ApplicationId, String IssueDate, OracleCommand command) at ZealERP.ZealTakaful.Services.GLAS.PeriodSetupService.GetAdviceDate(Int32 OrgId, Int32 BranchId, Int32 ApplicationId, String EntryDate, String query, OracleCommand command, Boolean isFromClaim) at ZealERP.ZealTakaful.Services.GLAS.PeriodSetupService.GetFreezedPeriodDateUnderwriting(Int32 OrgId, Int32 BranchId, Int32 ApplicationId, String EntryDate, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.DocHeaderUtilityILAS.GetFreezedPeriodDate(Int32 OrgId, Int32 BranchId, Int32 ApplicationId, String EntryDate, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.DocHeaderUtilityILAS.ConvertToProposal(PostingDataModel model, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.DocHeaderUtilityILAS.<>c__DisplayClass128_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 8/4/2024 10:22:51 AM: Error.. No Underwriting Period found for date 04/08/2024 ZealERP.ZealFramework.Utils.ZealException: Error.. No Underwriting Period found for date 04/08/2024 at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealTakaful.Services.ILAS.DocHeaderUtilityILAS.ConvertToProposal(PostingDataModel model) at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass18_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 8/4/2024 10:26:53 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) 8/4/2024 10:28:14 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) 8/4/2024 10:28:21 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) 8/4/2024 10:31:06 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) 8/4/2024 10:31:11 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) 8/4/2024 10:32:18 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) 8/4/2024 10:32:29 AM: There is no row at position 0. System.IndexOutOfRangeException: There is no row at position 0. at System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex) at System.Data.DataRowCollection.get_Item(Int32 index) at ZealERP.ZealTakaful.Services.ILAS.ProposalEntryService.GetDocSelectedInfo(DocumentHeaderModelILAS docObj, OracleCommand command, String UnderwritingProcessId, String SettlementDate, Boolean FetchReinstementAmounts, Boolean FromCurrentRecord, Boolean FromUnitSimulator) at ZealERP.ZealTakaful.Services.ILAS.ProposalEntryService.GetDocSelectedInfo(DocumentHeaderModelILAS docObj, String UnderwritingProcessId, String SettlementDate, Boolean FromCurrentRecord) at ZealERP.ZealTakaful.Controllers.ILAS.ProposalEntryController.<>c__DisplayClass67_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 8/4/2024 10:36:50 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) 8/4/2024 10:40:13 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) 8/4/2024 10:44:24 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) 8/4/2024 10:44:58 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) 8/4/2024 10:45:10 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) 8/4/2024 10:45:32 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) 8/4/2024 10:48:55 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) 8/4/2024 10:48:55 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) 8/4/2024 10:49:13 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) 8/4/2024 10:49:51 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) 8/4/2024 10:54:34 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) 8/4/2024 10:55:50 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) 8/4/2024 10:57:33 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) 8/4/2024 11:02:24 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) 8/4/2024 11:02:30 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) 8/4/2024 11:04:31 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) 8/4/2024 11:04:54 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) 8/4/2024 11:06:35 AM: delete from GLAS_SUB_PROD_BENEFIT_MAP_T where ORG_ID = :ORG_ID and MAIN_PRODUCT_CODE = :MAIN_PRODUCT_CODE and SUB_PRODUCT_CODE = :SUB_PRODUCT_CODE and BENEFIT_CODE = :BENEFIT_CODE params: ORG_ID=8, MAIN_PRODUCT_CODE=1, SUB_PRODUCT_CODE=8, BENEFIT_CODE=3 8/4/2024 11:06:35 AM: ORA-02292: integrity constraint (ZEAL_ERP.FK_SUB_PR_MORT_RT_BENEFIT) violated - child record found Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-02292: integrity constraint (ZEAL_ERP.FK_SUB_PR_MORT_RT_BENEFIT) 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) 8/4/2024 11:06:35 AM: ORA-02292: integrity constraint (ZEAL_ERP.FK_SUB_PR_MORT_RT_BENEFIT) violated - child record found Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-02292: integrity constraint (ZEAL_ERP.FK_SUB_PR_MORT_RT_BENEFIT) 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.ZealFramework.Services.DBService.<>c__DisplayClass27_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 8/4/2024 11:06:35 AM: ORA-02292: integrity constraint (ZEAL_ERP.FK_SUB_PR_MORT_RT_BENEFIT) violated - child record found Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-02292: integrity constraint (ZEAL_ERP.FK_SUB_PR_MORT_RT_BENEFIT) violated - child record found at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Delete(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.DeleteSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass8_0.b__0() 8/4/2024 11:29:25 AM: String was not recognized as a valid DateTime. System.FormatException: String was not recognized as a valid DateTime. at System.DateTimeParse.ParseExact(String s, String format, DateTimeFormatInfo dtfi, DateTimeStyles style) at System.DateTime.ParseExact(String s, String format, IFormatProvider provider) at ZealERP.ZealTakaful.ExtensionMethods.ZealExtensions.ToDateTime(String input, String format) at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.UploadProductWiseRatesSetup(String OrgId, String ExtraUploadValues, DataTable dt, Boolean AppendRecords, OracleCommand command) at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.UploadItems(UploadUtilityDataModel model, OracleCommand command) at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.<>c__DisplayClass158_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 8/4/2024 11:29:25 AM: Application Error. Please Contact Vendor or Refer Logs. System.Exception: Application Error. Please Contact Vendor or Refer Logs. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.UploadItems(UploadUtilityDataModel model) 8/4/2024 11:29:25 AM: Error.. in Sheet: Sheet1 at Row No:1 Application Error. Please Contact Vendor or Refer Logs. 8/4/2024 11:29:25 AM: Error.. in Sheet: Sheet1 at Row No:1 Application Error. Please Contact Vendor or Refer Logs. ZealERP.ZealFramework.Utils.ZealException: Error.. in Sheet: Sheet1 at Row No:1 Application Error. Please Contact Vendor or Refer Logs. at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.UploadItems(UploadUtilityDataModel model) at ZealERP.ZealTakaful.Controllers.GLAS.ZealUploadUtilityController.b__3_0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 8/4/2024 11:30:04 AM: String was not recognized as a valid DateTime. System.FormatException: String was not recognized as a valid DateTime. at System.DateTimeParse.ParseExact(String s, String format, DateTimeFormatInfo dtfi, DateTimeStyles style) at System.DateTime.ParseExact(String s, String format, IFormatProvider provider) at ZealERP.ZealTakaful.ExtensionMethods.ZealExtensions.ToDateTime(String input, String format) at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.UploadProductWiseRatesSetup(String OrgId, String ExtraUploadValues, DataTable dt, Boolean AppendRecords, OracleCommand command) at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.UploadItems(UploadUtilityDataModel model, OracleCommand command) at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.<>c__DisplayClass158_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 8/4/2024 11:30:04 AM: Application Error. Please Contact Vendor or Refer Logs. System.Exception: Application Error. Please Contact Vendor or Refer Logs. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.UploadItems(UploadUtilityDataModel model) 8/4/2024 11:30:04 AM: Error.. in Sheet: Sheet1 at Row No:1 Application Error. Please Contact Vendor or Refer Logs. 8/4/2024 11:30:04 AM: Error.. in Sheet: Sheet1 at Row No:1 Application Error. Please Contact Vendor or Refer Logs. ZealERP.ZealFramework.Utils.ZealException: Error.. in Sheet: Sheet1 at Row No:1 Application Error. Please Contact Vendor or Refer Logs. at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.UploadItems(UploadUtilityDataModel model) at ZealERP.ZealTakaful.Controllers.GLAS.ZealUploadUtilityController.b__3_0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 8/4/2024 11:31:35 AM: insert into ILAS_SUB_PROD_RATES_SETUP_T (ORG_ID,MAIN_PRODUCT_CODE,SUB_PRODUCT_CODE,BENEFIT_CODE,RATE_TYPE_ID,POLICY_TERM,RATE,EFFECTIVE_START_DATE,CREATED_BY,CREATION_DATE) values (:ORG_ID,:MAIN_PRODUCT_CODE,:SUB_PRODUCT_CODE,:BENEFIT_CODE,:RATE_TYPE_ID,:POLICY_TERM,:RATE,:EFFECTIVE_START_DATE,:CREATED_BY,:CREATION_DATE) params: ORG_ID=8, MAIN_PRODUCT_CODE=1, SUB_PRODUCT_CODE=8, BENEFIT_CODE=4, RATE_TYPE_ID=1, POLICY_TERM=26, RATE=1, EFFECTIVE_START_DATE=, CREATED_BY=wada, CREATION_DATE=8/4/2024 11:31:35 AM 8/4/2024 11:31:35 AM: ORA-01400: cannot insert NULL into ("ZEAL_ERP"."ILAS_SUB_PROD_RATES_SETUP_T"."EFFECTIVE_START_DATE") Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01400: cannot insert NULL into ("ZEAL_ERP"."ILAS_SUB_PROD_RATES_SETUP_T"."EFFECTIVE_START_DATE") 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) 8/4/2024 11:31:35 AM: ORA-01400: cannot insert NULL into ("ZEAL_ERP"."ILAS_SUB_PROD_RATES_SETUP_T"."EFFECTIVE_START_DATE") Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01400: cannot insert NULL into ("ZEAL_ERP"."ILAS_SUB_PROD_RATES_SETUP_T"."EFFECTIVE_START_DATE") 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.ZealTakaful.Services.GLAS.ZealUploadUtilityService.ExecuteQuery(String query, OracleParameter[] query_params, OracleCommand command) 8/4/2024 11:31:35 AM: ORA-01400: cannot insert NULL into ("ZEAL_ERP"."ILAS_SUB_PROD_RATES_SETUP_T"."EFFECTIVE_START_DATE") System.Exception: ORA-01400: cannot insert NULL into ("ZEAL_ERP"."ILAS_SUB_PROD_RATES_SETUP_T"."EFFECTIVE_START_DATE") at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.ExecuteQuery(String query, OracleParameter[] query_params, OracleCommand command) at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.UploadProductWiseRatesSetup(String OrgId, String ExtraUploadValues, DataTable dt, Boolean AppendRecords, OracleCommand command) at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.UploadItems(UploadUtilityDataModel model, OracleCommand command) at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.<>c__DisplayClass158_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 8/4/2024 11:31:35 AM: Application Error. Please Contact Vendor or Refer Logs. System.Exception: Application Error. Please Contact Vendor or Refer Logs. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.UploadItems(UploadUtilityDataModel model) 8/4/2024 11:31:35 AM: Error.. in Sheet: Sheet1 at Row No:1 Application Error. Please Contact Vendor or Refer Logs. 8/4/2024 11:31:35 AM: Error.. in Sheet: Sheet1 at Row No:1 Application Error. Please Contact Vendor or Refer Logs. ZealERP.ZealFramework.Utils.ZealException: Error.. in Sheet: Sheet1 at Row No:1 Application Error. Please Contact Vendor or Refer Logs. at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.UploadItems(UploadUtilityDataModel model) at ZealERP.ZealTakaful.Controllers.GLAS.ZealUploadUtilityController.b__3_0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 8/4/2024 11:33:17 AM: The DateTime represented by the string is not supported in calendar System.Globalization.GregorianCalendar. System.FormatException: The DateTime represented by the string is not supported in calendar System.Globalization.GregorianCalendar. at System.DateTimeParse.ParseExact(String s, String format, DateTimeFormatInfo dtfi, DateTimeStyles style) at System.DateTime.ParseExact(String s, String format, IFormatProvider provider) at ZealERP.ZealTakaful.ExtensionMethods.ZealExtensions.ToDateTime(String input, String format) at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.UploadProductWiseRatesSetup(String OrgId, String ExtraUploadValues, DataTable dt, Boolean AppendRecords, OracleCommand command) at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.UploadItems(UploadUtilityDataModel model, OracleCommand command) at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.<>c__DisplayClass158_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 8/4/2024 11:33:17 AM: Application Error. Please Contact Vendor or Refer Logs. System.Exception: Application Error. Please Contact Vendor or Refer Logs. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.UploadItems(UploadUtilityDataModel model) 8/4/2024 11:33:17 AM: Error.. in Sheet: Sheet1 at Row No:1 Application Error. Please Contact Vendor or Refer Logs. 8/4/2024 11:33:17 AM: Error.. in Sheet: Sheet1 at Row No:1 Application Error. Please Contact Vendor or Refer Logs. ZealERP.ZealFramework.Utils.ZealException: Error.. in Sheet: Sheet1 at Row No:1 Application Error. Please Contact Vendor or Refer Logs. at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.UploadItems(UploadUtilityDataModel model) at ZealERP.ZealTakaful.Controllers.GLAS.ZealUploadUtilityController.b__3_0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 8/4/2024 11:50: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) 8/4/2024 11:54:36 AM: with RATES_DATA_T as (select growth_rates.rate growth_rate, inf_rates.rate as inflation_rate from (select rownum RATE_ID, a.RATE from (SELECT RATE FROM TK_NOMINAL_RATE_SETUP_T WHERE ORG_ID='8' AND EFFECTIVE_END_DATE IS NULL ORDER BY RATE)a) growth_rates, (select rownum RATE_ID, a.RATE from (SELECT RATE FROM TK_INFLATION_RATE_SETUP_T WHERE ORG_ID='8' AND EFFECTIVE_END_DATE IS NULL ORDER BY RATE)a) inf_rates where growth_rates.RATE_ID=inf_rates.RATE_ID ) select ROWNUM,POLICY_YEAR,EFFECTIVE_AGE AGE ,round(INFLATION_ACCUMULATED_CONTRI ) INVESTED_CONTRI_INFLATION ,round(CASE ROWNUM WHEN 1 THEN DEATH_BENEFIT1 WHEN 2 THEN DEATH_BENEFIT2 WHEN 3 THEN DEATH_BENEFIT3 END * (1/power( (1+INFLATION_RATE/100),POLICY_YEAR) ) ) DEATH_BENEFIT_INFLATION ,round(CASE ROWNUM WHEN 1 THEN CASH_VALUE1 WHEN 2 THEN CASH_VALUE2 WHEN 3 THEN CASH_VALUE3 END * (1/power( (1+INFLATION_RATE/100),POLICY_YEAR) ) ) CASH_VALUE_INFLATION ,round(CASE ROWNUM WHEN 1 THEN DEATH_BENEFIT1 WHEN 2 THEN DEATH_BENEFIT2 WHEN 3 THEN DEATH_BENEFIT3 END * (1/power( ( 1+ round( ( (1+GROWTH_RATE/100)/(1+INFLATION_RATE/100))-1,8)),POLICY_YEAR) ) ) DEATH_BENEFIT_INFLATION_old ,round(CASE ROWNUM WHEN 1 THEN CASH_VALUE1 WHEN 2 THEN CASH_VALUE2 WHEN 3 THEN CASH_VALUE3 END * (1/power( ( 1+ round( ( (1+GROWTH_RATE/100)/(1+INFLATION_RATE/100))-1,8)),POLICY_YEAR) ) ) CASH_VALUE_INFLATION_old from ( SELECT POLICY_YEAR,EFFECTIVE_AGE ,CASE WHEN SUM_ASSURED > CASH_VALUE1 THEN SUM_ASSURED ELSE CASH_VALUE1 END DEATH_BENEFIT1 ,CASE WHEN SUM_ASSURED > CASH_VALUE2 THEN SUM_ASSURED ELSE CASH_VALUE2 END DEATH_BENEFIT2 ,CASE WHEN SUM_ASSURED > CASH_VALUE3 THEN SUM_ASSURED ELSE CASH_VALUE3 END DEATH_BENEFIT3 ,CASH_VALUE1 ,CASH_VALUE2 ,CASH_VALUE3 ,INVESTED_CONTRIBUTION,INFLATION_ACCUMULATED_CONTRI FROM TK_ILLUSTRATIONDTL_MONTHLY_T 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 order by POLICY_YEAR desc, POLICY_MONTH desc fetch next 1 rows only)LASTYEAR_ROW_T, RATES_DATA_T ORDER BY INFLATION_RATE params: ORG_ID=8, BRANCH_ID=14, MAIN_PRODUCT_CODE=1, SUB_PRODUCT_CODE=8, DOCUMENT_NO=000002, DOCUMENT_YEAR=2024, ISSUE_COUNT=1, APPLICATION_ID=13 8/4/2024 11:54:36 AM: Specified cast is not valid. System.InvalidCastException: Specified cast is not valid. at Oracle.ManagedDataAccess.Client.OracleDataReader.GetDecimal(Int32 i) at Oracle.ManagedDataAccess.Client.OracleDataReader.GetValue(Int32 i) at Oracle.ManagedDataAccess.Client.OracleDataReader.GetValues(Object[] values) at System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.GetValues(Object[] values) at System.Data.ProviderBase.SchemaMapping.LoadDataRow() at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) 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) 8/4/2024 11:54:36 AM: Specified cast is not valid. System.InvalidCastException: Specified cast is not valid. at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans, Boolean PrintLog) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, Boolean ExecuteSp) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.GetIllustrationInflationDataMonthWise(IllustrationHeaderDataModel model) at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass19_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 8/4/2024 11:55:58 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) 8/4/2024 11:56:04 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) 8/4/2024 11:56: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) 8/4/2024 11:57:02 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) 8/4/2024 11:57:25 AM: with RATES_DATA_T as (select growth_rates.rate growth_rate, inf_rates.rate as inflation_rate from (select rownum RATE_ID, a.RATE from (SELECT RATE FROM TK_NOMINAL_RATE_SETUP_T WHERE ORG_ID='8' AND EFFECTIVE_END_DATE IS NULL ORDER BY RATE)a) growth_rates, (select rownum RATE_ID, a.RATE from (SELECT RATE FROM TK_INFLATION_RATE_SETUP_T WHERE ORG_ID='8' AND EFFECTIVE_END_DATE IS NULL ORDER BY RATE)a) inf_rates where growth_rates.RATE_ID=inf_rates.RATE_ID ) select ROWNUM,POLICY_YEAR,EFFECTIVE_AGE AGE ,round(INFLATION_ACCUMULATED_CONTRI ) INVESTED_CONTRI_INFLATION ,round(CASE ROWNUM WHEN 1 THEN DEATH_BENEFIT1 WHEN 2 THEN DEATH_BENEFIT2 WHEN 3 THEN DEATH_BENEFIT3 END * (1/power( (1+INFLATION_RATE/100),POLICY_YEAR) ) ) DEATH_BENEFIT_INFLATION ,round(CASE ROWNUM WHEN 1 THEN CASH_VALUE1 WHEN 2 THEN CASH_VALUE2 WHEN 3 THEN CASH_VALUE3 END * (1/power( (1+INFLATION_RATE/100),POLICY_YEAR) ) ) CASH_VALUE_INFLATION ,round(CASE ROWNUM WHEN 1 THEN DEATH_BENEFIT1 WHEN 2 THEN DEATH_BENEFIT2 WHEN 3 THEN DEATH_BENEFIT3 END * (1/power( ( 1+ round( ( (1+GROWTH_RATE/100)/(1+INFLATION_RATE/100))-1,8)),POLICY_YEAR) ) ) DEATH_BENEFIT_INFLATION_old ,round(CASE ROWNUM WHEN 1 THEN CASH_VALUE1 WHEN 2 THEN CASH_VALUE2 WHEN 3 THEN CASH_VALUE3 END * (1/power( ( 1+ round( ( (1+GROWTH_RATE/100)/(1+INFLATION_RATE/100))-1,8)),POLICY_YEAR) ) ) CASH_VALUE_INFLATION_old from ( SELECT POLICY_YEAR,EFFECTIVE_AGE ,CASE WHEN SUM_ASSURED > CASH_VALUE1 THEN SUM_ASSURED ELSE CASH_VALUE1 END DEATH_BENEFIT1 ,CASE WHEN SUM_ASSURED > CASH_VALUE2 THEN SUM_ASSURED ELSE CASH_VALUE2 END DEATH_BENEFIT2 ,CASE WHEN SUM_ASSURED > CASH_VALUE3 THEN SUM_ASSURED ELSE CASH_VALUE3 END DEATH_BENEFIT3 ,CASH_VALUE1 ,CASH_VALUE2 ,CASH_VALUE3 ,INVESTED_CONTRIBUTION,INFLATION_ACCUMULATED_CONTRI FROM TK_ILLUSTRATIONDTL_MONTHLY_T 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 order by POLICY_YEAR desc, POLICY_MONTH desc fetch next 1 rows only)LASTYEAR_ROW_T, RATES_DATA_T ORDER BY INFLATION_RATE params: ORG_ID=8, BRANCH_ID=14, MAIN_PRODUCT_CODE=1, SUB_PRODUCT_CODE=8, DOCUMENT_NO=000002, DOCUMENT_YEAR=2024, ISSUE_COUNT=1, APPLICATION_ID=13 8/4/2024 11:57:25 AM: Specified cast is not valid. System.InvalidCastException: Specified cast is not valid. at Oracle.ManagedDataAccess.Client.OracleDataReader.GetDecimal(Int32 i) at Oracle.ManagedDataAccess.Client.OracleDataReader.GetValue(Int32 i) at Oracle.ManagedDataAccess.Client.OracleDataReader.GetValues(Object[] values) at System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.GetValues(Object[] values) at System.Data.ProviderBase.SchemaMapping.LoadDataRow() at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) 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) 8/4/2024 11:57:25 AM: Specified cast is not valid. System.InvalidCastException: Specified cast is not valid. at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans, Boolean PrintLog) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, Boolean ExecuteSp) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.GetIllustrationInflationDataMonthWise(IllustrationHeaderDataModel model) at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass19_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 8/4/2024 11:57:25 AM: with RATES_DATA_T as (select growth_rates.rate growth_rate, inf_rates.rate as inflation_rate from (select rownum RATE_ID, a.RATE from (SELECT RATE FROM TK_NOMINAL_RATE_SETUP_T WHERE ORG_ID='8' AND EFFECTIVE_END_DATE IS NULL ORDER BY RATE)a) growth_rates, (select rownum RATE_ID, a.RATE from (SELECT RATE FROM TK_INFLATION_RATE_SETUP_T WHERE ORG_ID='8' AND EFFECTIVE_END_DATE IS NULL ORDER BY RATE)a) inf_rates where growth_rates.RATE_ID=inf_rates.RATE_ID ) select ROWNUM,POLICY_YEAR,EFFECTIVE_AGE AGE ,round(INFLATION_ACCUMULATED_CONTRI ) INVESTED_CONTRI_INFLATION ,round(CASE ROWNUM WHEN 1 THEN DEATH_BENEFIT1 WHEN 2 THEN DEATH_BENEFIT2 WHEN 3 THEN DEATH_BENEFIT3 END * (1/power( (1+INFLATION_RATE/100),POLICY_YEAR) ) ) DEATH_BENEFIT_INFLATION ,round(CASE ROWNUM WHEN 1 THEN CASH_VALUE1 WHEN 2 THEN CASH_VALUE2 WHEN 3 THEN CASH_VALUE3 END * (1/power( (1+INFLATION_RATE/100),POLICY_YEAR) ) ) CASH_VALUE_INFLATION ,round(CASE ROWNUM WHEN 1 THEN DEATH_BENEFIT1 WHEN 2 THEN DEATH_BENEFIT2 WHEN 3 THEN DEATH_BENEFIT3 END * (1/power( ( 1+ round( ( (1+GROWTH_RATE/100)/(1+INFLATION_RATE/100))-1,8)),POLICY_YEAR) ) ) DEATH_BENEFIT_INFLATION_old ,round(CASE ROWNUM WHEN 1 THEN CASH_VALUE1 WHEN 2 THEN CASH_VALUE2 WHEN 3 THEN CASH_VALUE3 END * (1/power( ( 1+ round( ( (1+GROWTH_RATE/100)/(1+INFLATION_RATE/100))-1,8)),POLICY_YEAR) ) ) CASH_VALUE_INFLATION_old from ( SELECT POLICY_YEAR,EFFECTIVE_AGE ,CASE WHEN SUM_ASSURED > CASH_VALUE1 THEN SUM_ASSURED ELSE CASH_VALUE1 END DEATH_BENEFIT1 ,CASE WHEN SUM_ASSURED > CASH_VALUE2 THEN SUM_ASSURED ELSE CASH_VALUE2 END DEATH_BENEFIT2 ,CASE WHEN SUM_ASSURED > CASH_VALUE3 THEN SUM_ASSURED ELSE CASH_VALUE3 END DEATH_BENEFIT3 ,CASH_VALUE1 ,CASH_VALUE2 ,CASH_VALUE3 ,INVESTED_CONTRIBUTION,INFLATION_ACCUMULATED_CONTRI FROM TK_ILLUSTRATIONDTL_MONTHLY_T 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 order by POLICY_YEAR desc, POLICY_MONTH desc fetch next 1 rows only)LASTYEAR_ROW_T, RATES_DATA_T ORDER BY INFLATION_RATE params: ORG_ID=8, BRANCH_ID=14, MAIN_PRODUCT_CODE=1, SUB_PRODUCT_CODE=8, DOCUMENT_NO=000002, DOCUMENT_YEAR=2024, ISSUE_COUNT=1, APPLICATION_ID=13 8/4/2024 11:57:25 AM: Specified cast is not valid. System.InvalidCastException: Specified cast is not valid. at Oracle.ManagedDataAccess.Client.OracleDataReader.GetDecimal(Int32 i) at Oracle.ManagedDataAccess.Client.OracleDataReader.GetValue(Int32 i) at Oracle.ManagedDataAccess.Client.OracleDataReader.GetValues(Object[] values) at System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.GetValues(Object[] values) at System.Data.ProviderBase.SchemaMapping.LoadDataRow() at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) 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) 8/4/2024 11:57:25 AM: Specified cast is not valid. System.InvalidCastException: Specified cast is not valid. at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans, Boolean PrintLog) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, Boolean ExecuteSp) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.GetIllustrationInflationDataMonthWise(IllustrationHeaderDataModel model) at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass19_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 8/4/2024 11:58:24 AM: with RATES_DATA_T as (select growth_rates.rate growth_rate, inf_rates.rate as inflation_rate from (select rownum RATE_ID, a.RATE from (SELECT RATE FROM TK_NOMINAL_RATE_SETUP_T WHERE ORG_ID='8' AND EFFECTIVE_END_DATE IS NULL ORDER BY RATE)a) growth_rates, (select rownum RATE_ID, a.RATE from (SELECT RATE FROM TK_INFLATION_RATE_SETUP_T WHERE ORG_ID='8' AND EFFECTIVE_END_DATE IS NULL ORDER BY RATE)a) inf_rates where growth_rates.RATE_ID=inf_rates.RATE_ID ) select ROWNUM,POLICY_YEAR,EFFECTIVE_AGE AGE ,round(INFLATION_ACCUMULATED_CONTRI ) INVESTED_CONTRI_INFLATION ,round(CASE ROWNUM WHEN 1 THEN DEATH_BENEFIT1 WHEN 2 THEN DEATH_BENEFIT2 WHEN 3 THEN DEATH_BENEFIT3 END * (1/power( (1+INFLATION_RATE/100),POLICY_YEAR) ) ) DEATH_BENEFIT_INFLATION ,round(CASE ROWNUM WHEN 1 THEN CASH_VALUE1 WHEN 2 THEN CASH_VALUE2 WHEN 3 THEN CASH_VALUE3 END * (1/power( (1+INFLATION_RATE/100),POLICY_YEAR) ) ) CASH_VALUE_INFLATION ,round(CASE ROWNUM WHEN 1 THEN DEATH_BENEFIT1 WHEN 2 THEN DEATH_BENEFIT2 WHEN 3 THEN DEATH_BENEFIT3 END * (1/power( ( 1+ round( ( (1+GROWTH_RATE/100)/(1+INFLATION_RATE/100))-1,8)),POLICY_YEAR) ) ) DEATH_BENEFIT_INFLATION_old ,round(CASE ROWNUM WHEN 1 THEN CASH_VALUE1 WHEN 2 THEN CASH_VALUE2 WHEN 3 THEN CASH_VALUE3 END * (1/power( ( 1+ round( ( (1+GROWTH_RATE/100)/(1+INFLATION_RATE/100))-1,8)),POLICY_YEAR) ) ) CASH_VALUE_INFLATION_old from ( SELECT POLICY_YEAR,EFFECTIVE_AGE ,CASE WHEN SUM_ASSURED > CASH_VALUE1 THEN SUM_ASSURED ELSE CASH_VALUE1 END DEATH_BENEFIT1 ,CASE WHEN SUM_ASSURED > CASH_VALUE2 THEN SUM_ASSURED ELSE CASH_VALUE2 END DEATH_BENEFIT2 ,CASE WHEN SUM_ASSURED > CASH_VALUE3 THEN SUM_ASSURED ELSE CASH_VALUE3 END DEATH_BENEFIT3 ,CASH_VALUE1 ,CASH_VALUE2 ,CASH_VALUE3 ,INVESTED_CONTRIBUTION,INFLATION_ACCUMULATED_CONTRI FROM TK_ILLUSTRATIONDTL_MONTHLY_T 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 order by POLICY_YEAR desc, POLICY_MONTH desc fetch next 1 rows only)LASTYEAR_ROW_T, RATES_DATA_T ORDER BY INFLATION_RATE params: ORG_ID=8, BRANCH_ID=14, MAIN_PRODUCT_CODE=1, SUB_PRODUCT_CODE=8, DOCUMENT_NO=000002, DOCUMENT_YEAR=2024, ISSUE_COUNT=1, APPLICATION_ID=13 8/4/2024 11:58:24 AM: Specified cast is not valid. System.InvalidCastException: Specified cast is not valid. at Oracle.ManagedDataAccess.Client.OracleDataReader.GetDecimal(Int32 i) at Oracle.ManagedDataAccess.Client.OracleDataReader.GetValue(Int32 i) at Oracle.ManagedDataAccess.Client.OracleDataReader.GetValues(Object[] values) at System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.GetValues(Object[] values) at System.Data.ProviderBase.SchemaMapping.LoadDataRow() at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) 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) 8/4/2024 11:58:24 AM: Specified cast is not valid. System.InvalidCastException: Specified cast is not valid. at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans, Boolean PrintLog) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, Boolean ExecuteSp) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.GetIllustrationInflationDataMonthWise(IllustrationHeaderDataModel model) at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass19_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 8/4/2024 11:59:57 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) 8/4/2024 12:00:15 PM: 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) 8/4/2024 12:04:20 PM: 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) 8/4/2024 12:04:32 PM: with RATES_DATA_T as (select growth_rates.rate growth_rate, inf_rates.rate as inflation_rate from (select rownum RATE_ID, a.RATE from (SELECT RATE FROM TK_NOMINAL_RATE_SETUP_T WHERE ORG_ID='8' AND EFFECTIVE_END_DATE IS NULL ORDER BY RATE)a) growth_rates, (select rownum RATE_ID, a.RATE from (SELECT RATE FROM TK_INFLATION_RATE_SETUP_T WHERE ORG_ID='8' AND EFFECTIVE_END_DATE IS NULL ORDER BY RATE)a) inf_rates where growth_rates.RATE_ID=inf_rates.RATE_ID ) select ROWNUM,POLICY_YEAR,EFFECTIVE_AGE AGE ,round(INFLATION_ACCUMULATED_CONTRI ) INVESTED_CONTRI_INFLATION ,round(CASE ROWNUM WHEN 1 THEN DEATH_BENEFIT1 WHEN 2 THEN DEATH_BENEFIT2 WHEN 3 THEN DEATH_BENEFIT3 END * (1/power( (1+INFLATION_RATE/100),POLICY_YEAR) ) ) DEATH_BENEFIT_INFLATION ,round(CASE ROWNUM WHEN 1 THEN CASH_VALUE1 WHEN 2 THEN CASH_VALUE2 WHEN 3 THEN CASH_VALUE3 END * (1/power( (1+INFLATION_RATE/100),POLICY_YEAR) ) ) CASH_VALUE_INFLATION ,round(CASE ROWNUM WHEN 1 THEN DEATH_BENEFIT1 WHEN 2 THEN DEATH_BENEFIT2 WHEN 3 THEN DEATH_BENEFIT3 END * (1/power( ( 1+ round( ( (1+GROWTH_RATE/100)/(1+INFLATION_RATE/100))-1,8)),POLICY_YEAR) ) ) DEATH_BENEFIT_INFLATION_old ,round(CASE ROWNUM WHEN 1 THEN CASH_VALUE1 WHEN 2 THEN CASH_VALUE2 WHEN 3 THEN CASH_VALUE3 END * (1/power( ( 1+ round( ( (1+GROWTH_RATE/100)/(1+INFLATION_RATE/100))-1,8)),POLICY_YEAR) ) ) CASH_VALUE_INFLATION_old from ( SELECT POLICY_YEAR,EFFECTIVE_AGE ,CASE WHEN SUM_ASSURED > CASH_VALUE1 THEN SUM_ASSURED ELSE CASH_VALUE1 END DEATH_BENEFIT1 ,CASE WHEN SUM_ASSURED > CASH_VALUE2 THEN SUM_ASSURED ELSE CASH_VALUE2 END DEATH_BENEFIT2 ,CASE WHEN SUM_ASSURED > CASH_VALUE3 THEN SUM_ASSURED ELSE CASH_VALUE3 END DEATH_BENEFIT3 ,CASH_VALUE1 ,CASH_VALUE2 ,CASH_VALUE3 ,INVESTED_CONTRIBUTION,INFLATION_ACCUMULATED_CONTRI FROM TK_ILLUSTRATIONDTL_MONTHLY_T 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 order by POLICY_YEAR desc, POLICY_MONTH desc fetch next 1 rows only)LASTYEAR_ROW_T, RATES_DATA_T ORDER BY INFLATION_RATE params: ORG_ID=8, BRANCH_ID=14, MAIN_PRODUCT_CODE=1, SUB_PRODUCT_CODE=8, DOCUMENT_NO=000002, DOCUMENT_YEAR=2024, ISSUE_COUNT=1, APPLICATION_ID=13 8/4/2024 12:04:32 PM: Specified cast is not valid. System.InvalidCastException: Specified cast is not valid. at Oracle.ManagedDataAccess.Client.OracleDataReader.GetDecimal(Int32 i) at Oracle.ManagedDataAccess.Client.OracleDataReader.GetValue(Int32 i) at Oracle.ManagedDataAccess.Client.OracleDataReader.GetValues(Object[] values) at System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.GetValues(Object[] values) at System.Data.ProviderBase.SchemaMapping.LoadDataRow() at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) 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) 8/4/2024 12:04:32 PM: Specified cast is not valid. System.InvalidCastException: Specified cast is not valid. at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans, Boolean PrintLog) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, Boolean ExecuteSp) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.GetIllustrationInflationDataMonthWise(IllustrationHeaderDataModel model) at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass19_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 8/4/2024 12:04:33 PM: with RATES_DATA_T as (select growth_rates.rate growth_rate, inf_rates.rate as inflation_rate from (select rownum RATE_ID, a.RATE from (SELECT RATE FROM TK_NOMINAL_RATE_SETUP_T WHERE ORG_ID='8' AND EFFECTIVE_END_DATE IS NULL ORDER BY RATE)a) growth_rates, (select rownum RATE_ID, a.RATE from (SELECT RATE FROM TK_INFLATION_RATE_SETUP_T WHERE ORG_ID='8' AND EFFECTIVE_END_DATE IS NULL ORDER BY RATE)a) inf_rates where growth_rates.RATE_ID=inf_rates.RATE_ID ) select ROWNUM,POLICY_YEAR,EFFECTIVE_AGE AGE ,round(INFLATION_ACCUMULATED_CONTRI ) INVESTED_CONTRI_INFLATION ,round(CASE ROWNUM WHEN 1 THEN DEATH_BENEFIT1 WHEN 2 THEN DEATH_BENEFIT2 WHEN 3 THEN DEATH_BENEFIT3 END * (1/power( (1+INFLATION_RATE/100),POLICY_YEAR) ) ) DEATH_BENEFIT_INFLATION ,round(CASE ROWNUM WHEN 1 THEN CASH_VALUE1 WHEN 2 THEN CASH_VALUE2 WHEN 3 THEN CASH_VALUE3 END * (1/power( (1+INFLATION_RATE/100),POLICY_YEAR) ) ) CASH_VALUE_INFLATION ,round(CASE ROWNUM WHEN 1 THEN DEATH_BENEFIT1 WHEN 2 THEN DEATH_BENEFIT2 WHEN 3 THEN DEATH_BENEFIT3 END * (1/power( ( 1+ round( ( (1+GROWTH_RATE/100)/(1+INFLATION_RATE/100))-1,8)),POLICY_YEAR) ) ) DEATH_BENEFIT_INFLATION_old ,round(CASE ROWNUM WHEN 1 THEN CASH_VALUE1 WHEN 2 THEN CASH_VALUE2 WHEN 3 THEN CASH_VALUE3 END * (1/power( ( 1+ round( ( (1+GROWTH_RATE/100)/(1+INFLATION_RATE/100))-1,8)),POLICY_YEAR) ) ) CASH_VALUE_INFLATION_old from ( SELECT POLICY_YEAR,EFFECTIVE_AGE ,CASE WHEN SUM_ASSURED > CASH_VALUE1 THEN SUM_ASSURED ELSE CASH_VALUE1 END DEATH_BENEFIT1 ,CASE WHEN SUM_ASSURED > CASH_VALUE2 THEN SUM_ASSURED ELSE CASH_VALUE2 END DEATH_BENEFIT2 ,CASE WHEN SUM_ASSURED > CASH_VALUE3 THEN SUM_ASSURED ELSE CASH_VALUE3 END DEATH_BENEFIT3 ,CASH_VALUE1 ,CASH_VALUE2 ,CASH_VALUE3 ,INVESTED_CONTRIBUTION,INFLATION_ACCUMULATED_CONTRI FROM TK_ILLUSTRATIONDTL_MONTHLY_T 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 order by POLICY_YEAR desc, POLICY_MONTH desc fetch next 1 rows only)LASTYEAR_ROW_T, RATES_DATA_T ORDER BY INFLATION_RATE params: ORG_ID=8, BRANCH_ID=14, MAIN_PRODUCT_CODE=1, SUB_PRODUCT_CODE=8, DOCUMENT_NO=000002, DOCUMENT_YEAR=2024, ISSUE_COUNT=1, APPLICATION_ID=13 8/4/2024 12:04:33 PM: Specified cast is not valid. System.InvalidCastException: Specified cast is not valid. at Oracle.ManagedDataAccess.Client.OracleDataReader.GetDecimal(Int32 i) at Oracle.ManagedDataAccess.Client.OracleDataReader.GetValue(Int32 i) at Oracle.ManagedDataAccess.Client.OracleDataReader.GetValues(Object[] values) at System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.GetValues(Object[] values) at System.Data.ProviderBase.SchemaMapping.LoadDataRow() at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) 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) 8/4/2024 12:04:33 PM: Specified cast is not valid. System.InvalidCastException: Specified cast is not valid. at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans, Boolean PrintLog) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, Boolean ExecuteSp) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.GetIllustrationInflationDataMonthWise(IllustrationHeaderDataModel model) at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass19_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 8/4/2024 12:04:53 PM: with RATES_DATA_T as (select growth_rates.rate growth_rate, inf_rates.rate as inflation_rate from (select rownum RATE_ID, a.RATE from (SELECT RATE FROM TK_NOMINAL_RATE_SETUP_T WHERE ORG_ID='8' AND EFFECTIVE_END_DATE IS NULL ORDER BY RATE)a) growth_rates, (select rownum RATE_ID, a.RATE from (SELECT RATE FROM TK_INFLATION_RATE_SETUP_T WHERE ORG_ID='8' AND EFFECTIVE_END_DATE IS NULL ORDER BY RATE)a) inf_rates where growth_rates.RATE_ID=inf_rates.RATE_ID ) select ROWNUM,POLICY_YEAR,EFFECTIVE_AGE AGE ,round(INFLATION_ACCUMULATED_CONTRI ) INVESTED_CONTRI_INFLATION ,round(CASE ROWNUM WHEN 1 THEN DEATH_BENEFIT1 WHEN 2 THEN DEATH_BENEFIT2 WHEN 3 THEN DEATH_BENEFIT3 END * (1/power( (1+INFLATION_RATE/100),POLICY_YEAR) ) ) DEATH_BENEFIT_INFLATION ,round(CASE ROWNUM WHEN 1 THEN CASH_VALUE1 WHEN 2 THEN CASH_VALUE2 WHEN 3 THEN CASH_VALUE3 END * (1/power( (1+INFLATION_RATE/100),POLICY_YEAR) ) ) CASH_VALUE_INFLATION ,round(CASE ROWNUM WHEN 1 THEN DEATH_BENEFIT1 WHEN 2 THEN DEATH_BENEFIT2 WHEN 3 THEN DEATH_BENEFIT3 END * (1/power( ( 1+ round( ( (1+GROWTH_RATE/100)/(1+INFLATION_RATE/100))-1,8)),POLICY_YEAR) ) ) DEATH_BENEFIT_INFLATION_old ,round(CASE ROWNUM WHEN 1 THEN CASH_VALUE1 WHEN 2 THEN CASH_VALUE2 WHEN 3 THEN CASH_VALUE3 END * (1/power( ( 1+ round( ( (1+GROWTH_RATE/100)/(1+INFLATION_RATE/100))-1,8)),POLICY_YEAR) ) ) CASH_VALUE_INFLATION_old from ( SELECT POLICY_YEAR,EFFECTIVE_AGE ,CASE WHEN SUM_ASSURED > CASH_VALUE1 THEN SUM_ASSURED ELSE CASH_VALUE1 END DEATH_BENEFIT1 ,CASE WHEN SUM_ASSURED > CASH_VALUE2 THEN SUM_ASSURED ELSE CASH_VALUE2 END DEATH_BENEFIT2 ,CASE WHEN SUM_ASSURED > CASH_VALUE3 THEN SUM_ASSURED ELSE CASH_VALUE3 END DEATH_BENEFIT3 ,CASH_VALUE1 ,CASH_VALUE2 ,CASH_VALUE3 ,INVESTED_CONTRIBUTION,INFLATION_ACCUMULATED_CONTRI FROM TK_ILLUSTRATIONDTL_MONTHLY_T 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 order by POLICY_YEAR desc, POLICY_MONTH desc fetch next 1 rows only)LASTYEAR_ROW_T, RATES_DATA_T ORDER BY INFLATION_RATE params: ORG_ID=8, BRANCH_ID=14, MAIN_PRODUCT_CODE=1, SUB_PRODUCT_CODE=8, DOCUMENT_NO=000002, DOCUMENT_YEAR=2024, ISSUE_COUNT=1, APPLICATION_ID=13 8/4/2024 12:04:53 PM: Specified cast is not valid. System.InvalidCastException: Specified cast is not valid. at Oracle.ManagedDataAccess.Client.OracleDataReader.GetDecimal(Int32 i) at Oracle.ManagedDataAccess.Client.OracleDataReader.GetValue(Int32 i) at Oracle.ManagedDataAccess.Client.OracleDataReader.GetValues(Object[] values) at System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.GetValues(Object[] values) at System.Data.ProviderBase.SchemaMapping.LoadDataRow() at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) 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) 8/4/2024 12:04:53 PM: Specified cast is not valid. System.InvalidCastException: Specified cast is not valid. at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans, Boolean PrintLog) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, Boolean ExecuteSp) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.GetIllustrationInflationDataMonthWise(IllustrationHeaderDataModel model) at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass19_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 8/4/2024 12:09:34 PM: 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) 8/4/2024 12:09:40 PM: 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) 8/4/2024 12:12:49 PM: 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) 8/4/2024 12:12:55 PM: 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) 8/4/2024 12:13:53 PM: 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) 8/4/2024 12:14:03 PM: 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) 8/4/2024 11:19:27 PM: 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.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 8/4/2024 11:19:27 PM: 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.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 8/4/2024 11:19:37 PM: 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.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 8/4/2024 11:19:37 PM: 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.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e)