Log File Initialized... 10/27/2024 2:58:03 AM 10/27/2024 2:58:03 AM: Invalid Credentials ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.LoginNew.btnLogin_Click(Object sender, EventArgs e) 10/27/2024 2:58:03 AM: **************************** Error at Login Request for User waqas.mehmood, Message: Invalid Credentials **************************** 10/27/2024 2:58:23 AM: Cache Cleared.... 10/27/2024 2:58:25 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 10/27/2024 4:40:07 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/27/2024 5:03:31 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 10/27/2024 5:37: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/27/2024 11:10:21 AM: Thread was being aborted. System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.End() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at System.Web.HttpResponse.Redirect(String url) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 10/27/2024 3:32:00 PM: select initcap(nvl(tp.PLAN_NAME, '-')) PLAN_NAME,d.description TRIP_TYPE,tp.GEOGRAPHICAL_MAPPING,r.CONTACT AGENT_PHONE,p.ADDRESS INSURED_ADDRESS,to_char(p.CREATION_DATE,'dd-Mon-yyyy') ISSUE_DATE,b.DESCRIPTION TRAVEL_PURPOSE,CASE p.PLAN_TYPE WHEN '15' THEN 'Family' WHEN '16' THEN 'Individual' ELSE '' END as PLAN_TYPE,nvl(TRIM(TO_CHAR(nvl(p.CONTRIBUTION_AMOUNT,0), '999,999,999,999,999')),0) CONTRIBUTION_AMOUNT, to_char(p.START_DATE,'dd-Mon-yyyy') START_DATE, p.MOBILE_NO, p.FULL_NAME as PARTICIPANT_NAME, p.EMAIL, to_char(p.DATE_OF_BIRTH,'dd-Mon-yyyy') DATE_OF_BIRTH, to_char(p.DATE_OF_BIRTH,'dd/MM/yyyy') DATE_OF_BIRTH2, p.CREATED_BY as AGENT,R.address as AGENT_ADDRESS, p.PASSPORT_NO, c.COUNTRY_DESC DESTINATION,cc.COUNTRY_DESC DESTINATION2, p.CNIC_NO,p.NM_OF_DAYS as TENURE, p.ORG_ID,p.DOCUMENT_NUMBER, p.POLICY_NUMBER,(p.AGE_AT_ENTRY||' '||case P.AGE_TYPE whEN 'M' then 'Month' when 'Y' then 'Year' else '' End ) AS AGE from TRAVLE_POLICY_T p left join TRAVEl_PLAN_T tp ON p.PLAN=tp.TP_ID and p.ORG_ID=tp.ORG_ID AND P.BRANCH_ID=TP.BRANCH_ID left join country c on (c.COUNTRY_CODE=p.DESTINATION_COUNTRY) left join country cc on (cc.COUNTRY_CODE=p.DESTINATION2) left join TRAVEL_PLAN_PRICE_T pp on (tp.ORG_ID=PP.ORG_ID AND TP.TP_ID=PP.TP_ID AND P.NM_OF_DAYS=PP.NM_OF_DAYS) left join GEN_PARAM_SETUPHD_T a on p.ORG_ID = a.ORG_ID and a.SETUP_NAME = 'TRAVEL PURPOSE' AND a.APPLICATION_ID =12,12 Left join GEN_PARAM_SETUP_DTL_T b on a.ORG_ID = b.ORG_ID and a.APPLICATION_ID = b.APPLICATION_ID and a.SETUP_ID = b.SETUP_ID and p.TRAVEL_PURPOSE = b.ABBREVIATION left join GEN_PARAM_SETUPHD_T C on p.ORG_ID = C.ORG_ID and C.SETUP_NAME = 'Trip Type' AND c.APPLICATION_ID =12,12 Left join GEN_PARAM_SETUP_DTL_T D on c.ORG_ID = d.ORG_ID and c.APPLICATION_ID = d.APPLICATION_ID and c.SETUP_ID = d.SETUP_ID and pp.TRIP_TYPE = D.ABBREVIATION left join AGENT_REGISTRATION_T r on (r.USERNAME=p.CREATED_BY) WHERE p.ORG_ID='6,6' and p.POLICY_NUMBER='SIL/P/2024/9/20/Doc-003934' and p.BRANCH_ID=1?PNo=SIL/P/2024/9/20/Doc-003934,1 10/27/2024 3:32:00 PM: ORA-00903: invalid table name Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00903: invalid table name 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/27/2024 3:32:00 PM: ORA-00903: invalid table name Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00903: invalid table name at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans, Boolean PrintLog) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query) at ZealERP.ZealTakaful.Reports.TravelPolicy.TravelPolicySD.PrepareReport() 10/27/2024 3:32:00 PM: ORA-00903: invalid table name Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00903: invalid table name at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans, Boolean PrintLog) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query) at ZealERP.ZealTakaful.Reports.TravelPolicy.TravelPolicySD.PrepareReport() 10/27/2024 10:37:56 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/27/2024 10:38: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/27/2024 10:53:02 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/27/2024 10:56:53 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/27/2024 11:02:07 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.TakafulTech.IllustrationService.CalculateContributionOnSA(CommonParamsDataModelForPost record) at ZealERP.ZealTakaful.Controllers.CommonParamsGLASController.<>c__DisplayClass32_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/27/2024 11:02:40 PM: Face value / Sum Assured cannot be less than Product Setup Main Plan Min SA 290000 ZealERP.ZealFramework.Utils.ZealException: Face value / Sum Assured cannot be less than Product Setup Main Plan Min SA 290000 at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculateContributionOnSA(CommonParamsDataModelForPost record) at ZealERP.ZealTakaful.Controllers.CommonParamsGLASController.<>c__DisplayClass32_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/27/2024 11:37:48 PM: Unable to Save/Update, Guardian Age is less than 18 ZealERP.ZealFramework.Utils.ZealException: Unable to Save/Update, Guardian Age is less than 18 at ZealERP.ZealTakaful.Services.DBServiceChildBeneficiaryChild.CheckForMinorGuardian(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildBeneficiaryChild.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/27/2024 11:37:48 PM: Error.. Unable to Save/Update, Guardian Age is less than 18 ZealERP.ZealFramework.Utils.ZealException: Error.. Unable to Save/Update, Guardian Age is less than 18 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/27/2024 11:48:13 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.ZealUtil.ZealReportRDLC.ExecuteReport(String ReportPath, NameValueCollection Form, ReportViewer ReportViewer1, HttpResponse Response) 10/27/2024 11:48:13 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.ZealUtil.ZealReportRDLC.ExecuteReport(String ReportPath, NameValueCollection Form, ReportViewer ReportViewer1, HttpResponse Response) 10/27/2024 11:48:23 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.DocMessagingService.GetDocPlaceHolders(DocumentHeaderModelILAS model, String title, DocMessagingInputDataModel input, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.DocMessagingService.SendDocSMSAndEmailGeneral(DocumentHeaderModelILAS model, String message, String OtherLangTag, OracleCommand command, Boolean HoldTag) at ZealERP.ZealTakaful.Services.ILAS.DocHeaderUtilityILAS.<>c__DisplayClass113_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 10/27/2024 11:48:23 PM: 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.ILAS.DocHeaderUtilityILAS.SendMessage(DocumentHeaderModelILAS model, String message, String OtherLangTag) at ZealERP.ZealTakaful.Controllers.ILAS.ProposalEntryController.<>c__DisplayClass18_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/27/2024 11:49:20 PM: Directory not found, creating directory.. D:\AAK\ZealERP\Uploads\ClientUploads\2024000000035-1 10/27/2024 11:49:37 PM: Please fill CNIC for the test Beneficiary ZealERP.ZealFramework.Utils.ZealException: Please fill CNIC for the test Beneficiary at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.LockDocument(DocumentHeaderModelILAS doc, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.<>c__DisplayClass32_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 10/27/2024 11:49:37 PM: Error.. Please fill CNIC for the test Beneficiary ZealERP.ZealFramework.Utils.ZealException: Error.. Please fill CNIC for the test Beneficiary at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.LockDocument(PostingDataModel model) 10/27/2024 11:49:37 PM: Unable to Lock Ref No. 2024000000035-1, Error.. Please fill CNIC for the test Beneficiary ZealERP.ZealFramework.Utils.ZealException: Unable to Lock Ref No. 2024000000035-1, Error.. Please fill CNIC for the test Beneficiary at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.LockDocument(PostingDataModel model) at ZealERP.ZealTakaful.Services.ILAS.ProposalEntryService.LockDocument(PostingDataModel model) at ZealERP.ZealTakaful.Controllers.ILAS.ProposalEntryController.<>c__DisplayClass31_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/27/2024 11:49:58 PM: Please fill CNIC for the test Beneficiary ZealERP.ZealFramework.Utils.ZealException: Please fill CNIC for the test Beneficiary at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.LockDocument(DocumentHeaderModelILAS doc, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.<>c__DisplayClass32_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 10/27/2024 11:49:58 PM: Error.. Please fill CNIC for the test Beneficiary ZealERP.ZealFramework.Utils.ZealException: Error.. Please fill CNIC for the test Beneficiary at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.LockDocument(PostingDataModel model) 10/27/2024 11:49:58 PM: Unable to Lock Ref No. 2024000000035-1, Error.. Please fill CNIC for the test Beneficiary ZealERP.ZealFramework.Utils.ZealException: Unable to Lock Ref No. 2024000000035-1, Error.. Please fill CNIC for the test Beneficiary at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.LockDocument(PostingDataModel model) at ZealERP.ZealTakaful.Services.ILAS.ProposalEntryService.LockDocument(PostingDataModel model) at ZealERP.ZealTakaful.Controllers.ILAS.ProposalEntryController.<>c__DisplayClass31_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/27/2024 11:58:48 PM: Rate not found in Rating Table for date 27/10/2024 and year 1 ZealERP.ZealFramework.Utils.ZealException: Rate not found in Rating Table for date 27/10/2024 and year 1 at ZealERP.ZealTakaful.Services.ILAS.RatingService.GetRateFromRatingTable(String FieldName, String FieldLabel, IllustrationCalculationDataModel model, Int32 PolicyYear, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.RatingService.GetRiderRate(IllustrationCalculationDataModel model, IllustrationRiderDataModel rider, OracleCommand command, Boolean IgnoreException) at ZealERP.ZealTakaful.Services.ILAS.DocAllocationService.GetRiderRateForMainPlan(DocumentHeaderModelILAS model, AllocationProcessDataModel ProcessModel, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.DocAllocationService.PrepareProcessModel(DocumentHeaderModelILAS model, AllocationProcessDataModel ProcessModel, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.DocAllocationService.PrepareAndInsertAllocations(DocumentHeaderModelILAS model, AllocationProcessDataModel ProcessModel, DocInstallmentDataModel installment, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.DocAllocationService.RunMonthlyProcessFinal(DocumentHeaderModelILAS model, AllocationProcessDataModel ProcessModel, DocInstallmentDataModel installment, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.DocAllocationService.RunMonthlyProcessAfterStatusChecking(DocumentHeaderModelILAS model, AllocationProcessDataModel ProcessModel, DocInstallmentDataModel installment, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.DocAllocationService.RunMonthlyProcessInternal(DocumentHeaderModelILAS model, AllocationProcessDataModel ProcessModel, DocInstallmentDataModel installment, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.DocAllocationService.RunMonthlyProcess(DocumentHeaderModelILAS model, String CurrentDueDate, Boolean FromPosting, OracleCommand command, Boolean FromTopUp) at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.CallPostingProcess(PostingDataModel model, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.Post(PostingDataModel model, DocumentHeaderModelILAS doc, Boolean RunWithoutAccounting, String PostingDate, OracleCommand command) at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.<>c__DisplayClass23_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 10/27/2024 11:58:48 PM: Error.. Rate not found in Rating Table for date 27/10/2024 and year 1 ZealERP.ZealFramework.Utils.ZealException: Error.. Rate not found in Rating Table for date 27/10/2024 and year 1 at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.Post(PostingDataModel model) 10/27/2024 11:58:48 PM: Unable to Post Ref No. 2024000000035-1, Error.. Rate not found in Rating Table for date 27/10/2024 and year 1 ZealERP.ZealFramework.Utils.ZealException: Unable to Post Ref No. 2024000000035-1, Error.. Rate not found in Rating Table for date 27/10/2024 and year 1 at ZealERP.ZealTakaful.Services.ILAS.PostingServiceILAS.Post(PostingDataModel model) at ZealERP.ZealTakaful.Services.ILAS.ProposalEntryService.PostPolicyDocument(PostingDataModel model) at ZealERP.ZealTakaful.Controllers.ILAS.ProposalEntryController.<>c__DisplayClass33_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService)