Log File Initialized... 10/6/2024 12:44:15 AM
10/6/2024 12:44:15 AM: Invalid Credentials
ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials
   at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record)
   at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password)
   at ZealERP.ZealTakaful.LoginNew.btnLogin_Click(Object sender, EventArgs e)
10/6/2024 12:44:15 AM: **************************** Error at Login Request for User demo, Message: Invalid Credentials ****************************
10/6/2024 12:46:09 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/6/2024 12:46:09 AM: **************************** Error at Login Request for User waada, Message: Invalid Credentials ****************************
10/6/2024 12:46:30 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/6/2024 12:46:30 AM: **************************** Error at Login Request for User waada, Message: Invalid Credentials ****************************
10/6/2024 12:50:30 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/6/2024 12:50:30 AM: **************************** Error at Login Request for User waada, Message: Invalid Credentials ****************************
10/6/2024 2:02:34 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
10/6/2024 2:27:51 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/6/2024 2:27:51 AM: **************************** Error at Login Request for User waada, Message: Invalid Credentials ****************************
10/6/2024 2:28:49 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
10/6/2024 2:31:57 AM: Face value / Sum Assured cannot be less than Product Setup Main Plan Min SA 290000
ZealERP.ZealFramework.Utils.ZealException: Face value / Sum Assured cannot be less than Product Setup Main Plan Min SA 290000
   at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculateContributionOnSA(CommonParamsOrgDTO record)
   at ZealERP.ZealTakaful.Controllers.CommonParamsGLASController.<>c__DisplayClass32_0.<CalculateContributionOnSA>b__0()
   at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService)
10/6/2024 2:32:29 AM: Rate not found in Rating Table for date 06/10/2024 and year 1
ZealERP.ZealFramework.Utils.ZealException: Rate not found in Rating Table for date 06/10/2024 and year 1
   at ZealERP.ZealTakaful.Services.ILAS.RatingService.GetRateFromRatingTable(String FieldName, String FieldLabel, IllustrationCalculationDataModel model, Int32 RiderTerm, OracleCommand command)
   at ZealERP.ZealTakaful.Services.ILAS.RatingService.GetRiderRate(IllustrationCalculationDataModel model, IllustrationRiderDataModel rider, OracleCommand command, Boolean IgnoreException)
   at ZealERP.ZealTakaful.Services.ILAS.IllustrationHeaderUtility.GetBasicBenefit(IllustrationHeaderDataModel Illustration, OracleCommand command, Boolean IgnoreException)
   at ZealERP.ZealTakaful.Services.DBServiceChildPOSCreate.AfterSave(SaveDataModel record, OracleCommand command)
   at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.<Save>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
10/6/2024 2:32:29 AM: Error.. Rate not found in Rating Table for date 06/10/2024 and year 1
ZealERP.ZealFramework.Utils.ZealException: Error.. Rate not found in Rating Table for date 06/10/2024 and year 1
   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.<SaveDataSecure>b__0()
10/6/2024 2:32:42 AM: Rate not found in Rating Table for date 06/10/2024 and year 1
ZealERP.ZealFramework.Utils.ZealException: Rate not found in Rating Table for date 06/10/2024 and year 1
   at ZealERP.ZealTakaful.Services.ILAS.RatingService.GetRateFromRatingTable(String FieldName, String FieldLabel, IllustrationCalculationDataModel model, Int32 RiderTerm, OracleCommand command)
   at ZealERP.ZealTakaful.Services.ILAS.RatingService.GetRiderRate(IllustrationCalculationDataModel model, IllustrationRiderDataModel rider, OracleCommand command, Boolean IgnoreException)
   at ZealERP.ZealTakaful.Services.ILAS.IllustrationHeaderUtility.GetBasicBenefit(IllustrationHeaderDataModel Illustration, OracleCommand command, Boolean IgnoreException)
   at ZealERP.ZealTakaful.Services.DBServiceChildPOSCreate.AfterSave(SaveDataModel record, OracleCommand command)
   at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.<Save>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
10/6/2024 2:32:42 AM: Error.. Rate not found in Rating Table for date 06/10/2024 and year 1
ZealERP.ZealFramework.Utils.ZealException: Error.. Rate not found in Rating Table for date 06/10/2024 and year 1
   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.<SaveDataSecure>b__0()
10/6/2024 2:32:50 AM: Rate not found in Rating Table for date 06/10/2024 and year 1
ZealERP.ZealFramework.Utils.ZealException: Rate not found in Rating Table for date 06/10/2024 and year 1
   at ZealERP.ZealTakaful.Services.ILAS.RatingService.GetRateFromRatingTable(String FieldName, String FieldLabel, IllustrationCalculationDataModel model, Int32 RiderTerm, OracleCommand command)
   at ZealERP.ZealTakaful.Services.ILAS.RatingService.GetRiderRate(IllustrationCalculationDataModel model, IllustrationRiderDataModel rider, OracleCommand command, Boolean IgnoreException)
   at ZealERP.ZealTakaful.Services.ILAS.IllustrationHeaderUtility.GetBasicBenefit(IllustrationHeaderDataModel Illustration, OracleCommand command, Boolean IgnoreException)
   at ZealERP.ZealTakaful.Services.DBServiceChildPOSCreate.AfterSave(SaveDataModel record, OracleCommand command)
   at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.<Save>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
10/6/2024 2:32:50 AM: Error.. Rate not found in Rating Table for date 06/10/2024 and year 1
ZealERP.ZealFramework.Utils.ZealException: Error.. Rate not found in Rating Table for date 06/10/2024 and year 1
   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.<SaveDataSecure>b__0()
10/6/2024 2:34:23 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/6/2024 2:36:34 AM: Rate not found in Rating Table for date 06/10/2024 and year 1
ZealERP.ZealFramework.Utils.ZealException: Rate not found in Rating Table for date 06/10/2024 and year 1
   at ZealERP.ZealTakaful.Services.ILAS.RatingService.GetRateFromRatingTable(String FieldName, String FieldLabel, IllustrationCalculationDataModel model, Int32 RiderTerm, OracleCommand command)
   at ZealERP.ZealTakaful.Services.ILAS.RatingService.GetRiderRate(IllustrationCalculationDataModel model, IllustrationRiderDataModel rider, OracleCommand command, Boolean IgnoreException)
   at ZealERP.ZealTakaful.Services.ILAS.IllustrationHeaderUtility.GetBasicBenefit(IllustrationHeaderDataModel Illustration, OracleCommand command, Boolean IgnoreException)
   at ZealERP.ZealTakaful.Services.DBServiceChildPOSCreate.AfterSave(SaveDataModel record, OracleCommand command)
   at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.<Save>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
10/6/2024 2:36:34 AM: Error.. Rate not found in Rating Table for date 06/10/2024 and year 1
ZealERP.ZealFramework.Utils.ZealException: Error.. Rate not found in Rating Table for date 06/10/2024 and year 1
   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.<SaveDataSecure>b__0()
10/6/2024 2:36:43 AM: Rate not found in Rating Table for date 06/10/2024 and year 1
ZealERP.ZealFramework.Utils.ZealException: Rate not found in Rating Table for date 06/10/2024 and year 1
   at ZealERP.ZealTakaful.Services.ILAS.RatingService.GetRateFromRatingTable(String FieldName, String FieldLabel, IllustrationCalculationDataModel model, Int32 RiderTerm, OracleCommand command)
   at ZealERP.ZealTakaful.Services.ILAS.RatingService.GetRiderRate(IllustrationCalculationDataModel model, IllustrationRiderDataModel rider, OracleCommand command, Boolean IgnoreException)
   at ZealERP.ZealTakaful.Services.ILAS.IllustrationHeaderUtility.GetBasicBenefit(IllustrationHeaderDataModel Illustration, OracleCommand command, Boolean IgnoreException)
   at ZealERP.ZealTakaful.Services.DBServiceChildPOSCreate.AfterSave(SaveDataModel record, OracleCommand command)
   at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.<Save>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
10/6/2024 2:36:43 AM: Error.. Rate not found in Rating Table for date 06/10/2024 and year 1
ZealERP.ZealFramework.Utils.ZealException: Error.. Rate not found in Rating Table for date 06/10/2024 and year 1
   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.<SaveDataSecure>b__0()
10/6/2024 2:44:04 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/6/2024 2:51:00 AM: Rate not found in Rating Table for date 06/10/2024 and year 1
ZealERP.ZealFramework.Utils.ZealException: Rate not found in Rating Table for date 06/10/2024 and year 1
   at ZealERP.ZealTakaful.Services.ILAS.RatingService.GetRateFromRatingTable(String FieldName, String FieldLabel, IllustrationCalculationDataModel model, Int32 RiderTerm, OracleCommand command)
   at ZealERP.ZealTakaful.Services.ILAS.RatingService.GetRiderRate(IllustrationCalculationDataModel model, IllustrationRiderDataModel rider, OracleCommand command, Boolean IgnoreException)
   at ZealERP.ZealTakaful.Services.ILAS.IllustrationHeaderUtility.GetBasicBenefit(IllustrationHeaderDataModel Illustration, OracleCommand command, Boolean IgnoreException)
   at ZealERP.ZealTakaful.Services.DBServiceChildPOSCreate.AfterSave(SaveDataModel record, OracleCommand command)
   at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.<Save>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
10/6/2024 2:51:00 AM: Error.. Rate not found in Rating Table for date 06/10/2024 and year 1
ZealERP.ZealFramework.Utils.ZealException: Error.. Rate not found in Rating Table for date 06/10/2024 and year 1
   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.<SaveDataSecure>b__0()
10/6/2024 2:52:27 AM: Rate not found in Rating Table for date 06/10/2024 and year 1
ZealERP.ZealFramework.Utils.ZealException: Rate not found in Rating Table for date 06/10/2024 and year 1
   at ZealERP.ZealTakaful.Services.ILAS.RatingService.GetRateFromRatingTable(String FieldName, String FieldLabel, IllustrationCalculationDataModel model, Int32 RiderTerm, OracleCommand command)
   at ZealERP.ZealTakaful.Services.ILAS.RatingService.GetRiderRate(IllustrationCalculationDataModel model, IllustrationRiderDataModel rider, OracleCommand command, Boolean IgnoreException)
   at ZealERP.ZealTakaful.Services.ILAS.IllustrationHeaderUtility.GetBasicBenefit(IllustrationHeaderDataModel Illustration, OracleCommand command, Boolean IgnoreException)
   at ZealERP.ZealTakaful.Services.DBServiceChildPOSCreate.AfterSave(SaveDataModel record, OracleCommand command)
   at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.<Save>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
10/6/2024 2:52:27 AM: Error.. Rate not found in Rating Table for date 06/10/2024 and year 1
ZealERP.ZealFramework.Utils.ZealException: Error.. Rate not found in Rating Table for date 06/10/2024 and year 1
   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.<SaveDataSecure>b__0()
10/6/2024 2:53:06 AM: Rate not found in Rating Table for date 06/10/2024 and year 1
ZealERP.ZealFramework.Utils.ZealException: Rate not found in Rating Table for date 06/10/2024 and year 1
   at ZealERP.ZealTakaful.Services.ILAS.RatingService.GetRateFromRatingTable(String FieldName, String FieldLabel, IllustrationCalculationDataModel model, Int32 RiderTerm, OracleCommand command)
   at ZealERP.ZealTakaful.Services.ILAS.RatingService.GetRiderRate(IllustrationCalculationDataModel model, IllustrationRiderDataModel rider, OracleCommand command, Boolean IgnoreException)
   at ZealERP.ZealTakaful.Services.ILAS.IllustrationHeaderUtility.GetBasicBenefit(IllustrationHeaderDataModel Illustration, OracleCommand command, Boolean IgnoreException)
   at ZealERP.ZealTakaful.Services.DBServiceChildPOSCreate.AfterSave(SaveDataModel record, OracleCommand command)
   at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.<Save>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
10/6/2024 2:53:06 AM: Error.. Rate not found in Rating Table for date 06/10/2024 and year 1
ZealERP.ZealFramework.Utils.ZealException: Error.. Rate not found in Rating Table for date 06/10/2024 and year 1
   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.<SaveDataSecure>b__0()
10/6/2024 3:14:24 AM: Sum Covered % not found on rider, please re-check
ZealERP.ZealFramework.Utils.ZealException: Sum Covered % not found on rider, please re-check
   at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, OracleCommand command, Boolean fromPOS)
   at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.<>c__DisplayClass29_0.<CalculationProcess>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
10/6/2024 3:14:24 AM: Error.. Sum Covered % not found on rider, please re-check
ZealERP.ZealFramework.Utils.ZealException: Error.. Sum Covered % not found on rider, please re-check
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
   at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, Boolean fromPOS)
   at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass17_0.<CalculationProcess>b__0()
   at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService)
10/6/2024 3:19:10 AM: Sum Covered % not found on rider, please re-check
ZealERP.ZealFramework.Utils.ZealException: Sum Covered % not found on rider, please re-check
   at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, OracleCommand command, Boolean fromPOS)
   at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.<>c__DisplayClass29_0.<CalculationProcess>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
10/6/2024 3:19:10 AM: Error.. Sum Covered % not found on rider, please re-check
ZealERP.ZealFramework.Utils.ZealException: Error.. Sum Covered % not found on rider, please re-check
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
   at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, Boolean fromPOS)
   at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass17_0.<CalculationProcess>b__0()
   at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService)
10/6/2024 3:19:29 AM: Sum Covered % not found on rider, please re-check
ZealERP.ZealFramework.Utils.ZealException: Sum Covered % not found on rider, please re-check
   at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, OracleCommand command, Boolean fromPOS)
   at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.<>c__DisplayClass29_0.<CalculationProcess>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
10/6/2024 3:19:29 AM: Error.. Sum Covered % not found on rider, please re-check
ZealERP.ZealFramework.Utils.ZealException: Error.. Sum Covered % not found on rider, please re-check
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
   at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, Boolean fromPOS)
   at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass17_0.<CalculationProcess>b__0()
   at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService)
10/6/2024 3:19:33 AM: Sum Covered % not found on rider, please re-check
ZealERP.ZealFramework.Utils.ZealException: Sum Covered % not found on rider, please re-check
   at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, OracleCommand command, Boolean fromPOS)
   at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.<>c__DisplayClass29_0.<CalculationProcess>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
10/6/2024 3:19:33 AM: Error.. Sum Covered % not found on rider, please re-check
ZealERP.ZealFramework.Utils.ZealException: Error.. Sum Covered % not found on rider, please re-check
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
   at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, Boolean fromPOS)
   at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass17_0.<CalculationProcess>b__0()
   at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService)
10/6/2024 3:19:37 AM: Sum Covered % not found on rider, please re-check
ZealERP.ZealFramework.Utils.ZealException: Sum Covered % not found on rider, please re-check
   at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, OracleCommand command, Boolean fromPOS)
   at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.<>c__DisplayClass29_0.<CalculationProcess>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
10/6/2024 3:19:37 AM: Error.. Sum Covered % not found on rider, please re-check
ZealERP.ZealFramework.Utils.ZealException: Error.. Sum Covered % not found on rider, please re-check
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
   at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, Boolean fromPOS)
   at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass17_0.<CalculationProcess>b__0()
   at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService)
10/6/2024 3:24:20 AM: Document Not Found
ZealERP.ZealFramework.Utils.ZealException: Document Not Found
   at ZealERP.ZealTakaful.Services.ILAS.DocHeaderUtilityILAS.GetDocObj(String ReferenceKey, String RecordType, String DocType, OracleCommand transaction, Boolean FirstRecordOnly, Boolean UpdatedValuesOnly, Boolean isFromPMDUnderwiting, Boolean FromCurrentRecord)
   at ZealERP.ZealTakaful.Services.ILAS.DocAllocationService.GetAllocationPercentage(DocumentHeaderModelILAS model, AllocationProcessDataModel ProcessModel, OracleCommand command)
   at ZealERP.ZealTakaful.Reports.Illustration.Illustration.PrepareReport()
10/6/2024 3:24:20 AM: Document Not Found
ZealERP.ZealFramework.Utils.ZealException: Document Not Found
   at ZealERP.ZealTakaful.Services.ILAS.DocHeaderUtilityILAS.GetDocObj(String ReferenceKey, String RecordType, String DocType, OracleCommand transaction, Boolean FirstRecordOnly, Boolean UpdatedValuesOnly, Boolean isFromPMDUnderwiting, Boolean FromCurrentRecord)
   at ZealERP.ZealTakaful.Services.ILAS.DocAllocationService.GetAllocationPercentage(DocumentHeaderModelILAS model, AllocationProcessDataModel ProcessModel, OracleCommand command)
   at ZealERP.ZealTakaful.Reports.Illustration.Illustration.PrepareReport()
10/6/2024 3:26:26 AM: insert into IL_DOC_HEADER_T (ORG_ID,BRANCH_ID,MAIN_PRODUCT_CODE,SUB_PRODUCT_CODE,TAKAFUL_TYPE,DOCUMENT_TYPE,RECORD_TYPE,DOCUMENT_YEAR,ISSUE_COUNT,ENDORSEMENT_NO,APPLICATION_ID,DOCUMENT_NO,DOC_REFERENCE_KEY,PARTNER_BRANCH_ID,AGENT_BRANCH_ID, DOC_REFERENCE_NO,MASTER_REF_NO,CLIENT_CODE,FOLIO_CODE,CURRENCY_CODE,PAYMENT_MODE,PAYMENT_TERM,POLICY_TERM,NAME1,NAME2,DOB1,DOB2,AGE1,AGE2,GENDER1,GENDER2,CNIC_NO2,CNIC_ISSUE_DATE2,CNIC_EXPIRY_DATE2,RELATION_CODE2,SUM_COVERED,SUM_COVERED_INDEX,CONTRIBUTION_INDEX,BASIC_CONTRIBUTION,GROSS_CONTRIBUTION,NET_CONTRIBUTION,COVER_MULTIPLE,CONT_MARGIN,LAST_AGE_INDEX,EXPECTED_CLAIM,INVESTMENT_INCOME,SECOND_LIFE,BID_OFFER,ISSUE_DATE,COMM_DATE,EXPIRY_DATE,CONVERTED_DOC_NO,PROPOSAL_DATE,CNIC_NO,SUM_COVERED_MODAL,BASIC_CONTRIBUTION_MODAL,ILLUSTRATION_REF_NO,CHANNEL_ID,MODEL_ID,AGENT_ID,PARTNER_ID,TOTAL_CONTRIBUTION_MODAL,MIDDLE_NAME1,LAST_NAME1,OCCUPATION,OCCUPATIONAL_INDUSTRY,CREATED_BY,CREATION_DATE,INITIAL_TOPUP, nvl(SMOKER_TAG,'N') SMOKER_TAG)  select '8','14','2','11','D','Q','O','2024','1','0','13','000018','8,14,2,11,D,Q,O,2024,1,0,13,000018',PARTNER_BRANCH_ID,AGENT_BRANCH_ID, '2024000000018-1','2024000000018','13','13',CURRENCY_CODE,PAYMENT_MODE,PAYMENT_TERM,POLICY_TERM,NAME1,NAME2,DOB1,DOB2,AGE1,AGE2,GENDER1,GENDER2,CNIC_NO2,CNIC_ISSUE_DATE2 ,CNIC_EXPIRY_DATE2,RELATION_CODE,SUM_COVERED,SUM_COVERED_INDEX,CONTRIBUTION_INDEX,BASIC_CONTRIBUTION,GROSS_CONTRIBUTION,NET_CONTRIBUTION,COVER_MULTIPLE,CONT_MARGIN,LAST_AGE_INDEX,EXPECTED_CLAIM,INVESTMENT_INCOME,SECOND_LIFE,BID_OFFER,ISSUE_DATE,COMM_DATE,EXPIRY_DATE,CONVERTED_DOC_NO,sysdate,CNIC_NO,SUM_COVERED_MODAL,BASIC_CONTRIBUTION_MODAL,'ILL2024/0000023-1',CHANNEL_ID,MODEL_ID,AGENT_ID,PARTNER_ID,TOTAL_CONTRIBUTION_MODAL,MIDDLE_NAME1,LAST_NAME1,OCCUPATION,OCCUPATIONAL_INDUSTRY,'DEMO',sysdate,(SELECT FAP_AMOUNT FROM TK_ILL_POS_FAP WHERE ORG_ID = o.ORG_ID AND BRANCH_ID = o.BRANCH_ID AND MAIN_PRODUCT_CODE = o.MAIN_PRODUCT_CODE AND SUB_PRODUCT_CODE = o.SUB_PRODUCT_CODE AND DOCUMENT_NO = o.DOCUMENT_NO AND DOCUMENT_YEAR = o.DOCUMENT_YEAR AND ISSUE_COUNT = o.ISSUE_COUNT AND APPLICATION_ID = o.APPLICATION_ID AND FAP_YEAR = '1'), nvl(SMOKER_TAG,'N') SMOKER_TAG from TK_ILLUSTRATIONHD_POS o  where ORG_ID='8'  and BRANCH_ID='14'  and MAIN_PRODUCT_CODE='2'  and SUB_PRODUCT_CODE='11'  and DOCUMENT_NO='000023'  and DOCUMENT_YEAR='2024'  and ISSUE_COUNT='1'  and APPLICATION_ID='13' 
10/6/2024 3:26:26 AM: ORA-00917: missing comma
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00917: missing comma
   at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
   at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, OracleException& exceptionForArrayBindDML, OracleConnection connection, Boolean isFromEF)
   at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery()
   at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans)
10/6/2024 3:26:26 AM: ORA-00917: missing comma
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00917: missing comma
   at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans)
   at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleCommand command)
   at ZealERP.ZealTakaful.Services.ILAS.DocHeaderUtilityILAS.CreateDocHeaderFromIllustration(DocumentHeaderModelILAS NewDocObj, IllustrationHeaderDataModel Illustration, String BackLogEntry, String ClientCode, String ProposalEntryDate, String PKCols, String PKVals, OracleCommand command)
   at ZealERP.ZealTakaful.Services.ILAS.DocHeaderUtilityILAS.ConvertToProposal(PostingDataModel model, OracleCommand command)
   at ZealERP.ZealTakaful.Services.ILAS.DocHeaderUtilityILAS.<>c__DisplayClass134_0.<ConvertToProposal>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
10/6/2024 3:26:26 AM: ORA-00917: missing comma
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00917: missing comma
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
   at ZealERP.ZealTakaful.Services.ILAS.DocHeaderUtilityILAS.ConvertToProposal(PostingDataModel model)
   at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass19_0.<ConvertToProposal>b__0()
   at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService)
10/6/2024 3:26:36 AM: insert into IL_DOC_HEADER_T (ORG_ID,BRANCH_ID,MAIN_PRODUCT_CODE,SUB_PRODUCT_CODE,TAKAFUL_TYPE,DOCUMENT_TYPE,RECORD_TYPE,DOCUMENT_YEAR,ISSUE_COUNT,ENDORSEMENT_NO,APPLICATION_ID,DOCUMENT_NO,DOC_REFERENCE_KEY,PARTNER_BRANCH_ID,AGENT_BRANCH_ID, DOC_REFERENCE_NO,MASTER_REF_NO,CLIENT_CODE,FOLIO_CODE,CURRENCY_CODE,PAYMENT_MODE,PAYMENT_TERM,POLICY_TERM,NAME1,NAME2,DOB1,DOB2,AGE1,AGE2,GENDER1,GENDER2,CNIC_NO2,CNIC_ISSUE_DATE2,CNIC_EXPIRY_DATE2,RELATION_CODE2,SUM_COVERED,SUM_COVERED_INDEX,CONTRIBUTION_INDEX,BASIC_CONTRIBUTION,GROSS_CONTRIBUTION,NET_CONTRIBUTION,COVER_MULTIPLE,CONT_MARGIN,LAST_AGE_INDEX,EXPECTED_CLAIM,INVESTMENT_INCOME,SECOND_LIFE,BID_OFFER,ISSUE_DATE,COMM_DATE,EXPIRY_DATE,CONVERTED_DOC_NO,PROPOSAL_DATE,CNIC_NO,SUM_COVERED_MODAL,BASIC_CONTRIBUTION_MODAL,ILLUSTRATION_REF_NO,CHANNEL_ID,MODEL_ID,AGENT_ID,PARTNER_ID,TOTAL_CONTRIBUTION_MODAL,MIDDLE_NAME1,LAST_NAME1,OCCUPATION,OCCUPATIONAL_INDUSTRY,CREATED_BY,CREATION_DATE,INITIAL_TOPUP, nvl(SMOKER_TAG,'N') SMOKER_TAG)  select '8','14','2','11','D','Q','O','2024','1','0','13','000018','8,14,2,11,D,Q,O,2024,1,0,13,000018',PARTNER_BRANCH_ID,AGENT_BRANCH_ID, '2024000000018-1','2024000000018','13','13',CURRENCY_CODE,PAYMENT_MODE,PAYMENT_TERM,POLICY_TERM,NAME1,NAME2,DOB1,DOB2,AGE1,AGE2,GENDER1,GENDER2,CNIC_NO2,CNIC_ISSUE_DATE2 ,CNIC_EXPIRY_DATE2,RELATION_CODE,SUM_COVERED,SUM_COVERED_INDEX,CONTRIBUTION_INDEX,BASIC_CONTRIBUTION,GROSS_CONTRIBUTION,NET_CONTRIBUTION,COVER_MULTIPLE,CONT_MARGIN,LAST_AGE_INDEX,EXPECTED_CLAIM,INVESTMENT_INCOME,SECOND_LIFE,BID_OFFER,ISSUE_DATE,COMM_DATE,EXPIRY_DATE,CONVERTED_DOC_NO,sysdate,CNIC_NO,SUM_COVERED_MODAL,BASIC_CONTRIBUTION_MODAL,'ILL2024/0000023-1',CHANNEL_ID,MODEL_ID,AGENT_ID,PARTNER_ID,TOTAL_CONTRIBUTION_MODAL,MIDDLE_NAME1,LAST_NAME1,OCCUPATION,OCCUPATIONAL_INDUSTRY,'DEMO',sysdate,(SELECT FAP_AMOUNT FROM TK_ILL_POS_FAP WHERE ORG_ID = o.ORG_ID AND BRANCH_ID = o.BRANCH_ID AND MAIN_PRODUCT_CODE = o.MAIN_PRODUCT_CODE AND SUB_PRODUCT_CODE = o.SUB_PRODUCT_CODE AND DOCUMENT_NO = o.DOCUMENT_NO AND DOCUMENT_YEAR = o.DOCUMENT_YEAR AND ISSUE_COUNT = o.ISSUE_COUNT AND APPLICATION_ID = o.APPLICATION_ID AND FAP_YEAR = '1'), nvl(SMOKER_TAG,'N') SMOKER_TAG from TK_ILLUSTRATIONHD_POS o  where ORG_ID='8'  and BRANCH_ID='14'  and MAIN_PRODUCT_CODE='2'  and SUB_PRODUCT_CODE='11'  and DOCUMENT_NO='000023'  and DOCUMENT_YEAR='2024'  and ISSUE_COUNT='1'  and APPLICATION_ID='13' 
10/6/2024 3:26:36 AM: ORA-00917: missing comma
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00917: missing comma
   at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
   at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, OracleException& exceptionForArrayBindDML, OracleConnection connection, Boolean isFromEF)
   at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery()
   at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans)
10/6/2024 3:26:36 AM: ORA-00917: missing comma
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00917: missing comma
   at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans)
   at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleCommand command)
   at ZealERP.ZealTakaful.Services.ILAS.DocHeaderUtilityILAS.CreateDocHeaderFromIllustration(DocumentHeaderModelILAS NewDocObj, IllustrationHeaderDataModel Illustration, String BackLogEntry, String ClientCode, String ProposalEntryDate, String PKCols, String PKVals, OracleCommand command)
   at ZealERP.ZealTakaful.Services.ILAS.DocHeaderUtilityILAS.ConvertToProposal(PostingDataModel model, OracleCommand command)
   at ZealERP.ZealTakaful.Services.ILAS.DocHeaderUtilityILAS.<>c__DisplayClass134_0.<ConvertToProposal>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
10/6/2024 3:26:36 AM: ORA-00917: missing comma
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00917: missing comma
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
   at ZealERP.ZealTakaful.Services.ILAS.DocHeaderUtilityILAS.ConvertToProposal(PostingDataModel model)
   at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass19_0.<ConvertToProposal>b__0()
   at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService)
10/6/2024 4:43:18 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
10/6/2024 5:37:59 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.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e)
10/6/2024 5:37:59 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.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e)
10/6/2024 5:39:41 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.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e)
10/6/2024 5:39:41 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.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e)
10/6/2024 5:59:01 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
10/6/2024 9:57:09 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
10/6/2024 10:54:33 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/6/2024 11:02:56 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/6/2024 11:04:26 AM: Please Enter User Id
ZealERP.ZealFramework.Utils.ZealException: Please Enter User Id
   at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record)
   at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password)
   at ZealERP.ZealTakaful.LoginNew.btnLogin_Click(Object sender, EventArgs e)
10/6/2024 11:04:26 AM: **************************** Error at Login Request for User , Message: Please Enter User Id ****************************
10/6/2024 11:04:32 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/6/2024 11:05:29 AM: select H.INVOICE_NO,(D.TOTAL_CONTRIBUTION-D.AGENT_AMOUNT)AS PAYABLE_TO_INSURANCE_COMPANY,H.POST_FLAG,H.SETTLED_TAG,a.ORG_ID,a.branch_id ,B.PLAN_NAME,a.CANCEL_STATUS,a.DOCUMENT_NUMBER,a.EMAIL,a.ADDRESS,a.TRAVEL_PURPOSE,a.DESTINATION_COUNTRY,a.DESTINATION_CITY,a.DESTINATION_STATE ,a.CONTRIBUTION_AMOUNT,a.NM_OF_DAYS,a.POLICY_NUMBER ,a.POLICY_STATUS,a.FULL_NAME , a.MOBILE_NO ,a.PLAN,a.PLAN_TYPE,a.DESTINATION,to_char(a.START_DATE,'dd/MM/yyyy') START_DATE, to_char(a.DATE_OF_BIRTH,'dd/MM/yyyy')DATE_OF_BIRTH ,a.FILER , a.CNIC_NO ,to_char(a.CNIC_ISSUE_DATE,'dd/MM/yyyy')CNIC_ISSUE_DATE , a.PASSPORT_NO, a.AGE_AT_ENTRY,NVL(A.AGE_TYPE,'Y') AS AGE_TYPE,NVL(A.OVER_AGE,'N') AS OVER_AGE,NVL(A.ALLOW_OVER_AGE,'N')AS ALLOW_OVER_AGE,a.NO_OF_DEPENDENT, a.SPOUSE_NAME,a.CHILD_NAME_1,a.DESTINATION2, a.CHILD_NAME_2, a.CHILD_NAME_3,a.CREATED_BY,to_char(a.CREATION_DATE,'dd/MM/yyyy')CREATION_DATE from TRAVLE_POLICY_T a left join TRAVEL_PLAN_T b on(a.ORG_ID=b.ORG_ID AND a.PLAN=b.TP_ID and a.branch_id=b.branch_id)
            LEFT JOIN TRAVEL_INVOICE_DETAIL_T  D ON (A.ORG_ID=D.ORG_ID AND A.POLICY_NUMBER=D.POLICY_NUMBER AND A.BRANCH_ID=D.BRANCH_ID)
            LEFT JOIN travel_invoice_header_t H ON (D.ORG_ID=H.ORG_ID AND D.INVOICE_NO=H.INVOICE_NO AND D.BRANCH_ID=H.BRANCH_ID)  WHERE a.org_id=6 and a.BRANCH_ID=1 AND a.POLICY_NUMBER  like '%4790%' AND (a.CREATION_DATE<to_date('4790','dd/MM/yyyy') or to_char(A.CREATION_DATE,'dd/MM/yyyy')='4790')
10/6/2024 11:05:29 AM: ORA-01847: day of month must be between 1 and last day of month
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01847: day of month must be between 1 and last day of month
   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/6/2024 11:05:29 AM: ORA-01847: day of month must be between 1 and last day of month
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01847: day of month must be between 1 and last day of month
   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.Services.Travel.TravelPolicyService.GetLookUpForTravelPolicy(TravelModel model)
   at ZealERP.ZealTakaful.Controllers.TravelPolicy.TravelPolicyController.<>c__DisplayClass3_0.<GetLookUpForTravelPolicy>b__0()
   at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService)
10/6/2024 11:08:35 AM: Please Enter User Id
ZealERP.ZealFramework.Utils.ZealException: Please Enter User Id
   at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record)
   at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password)
   at ZealERP.ZealTakaful.LoginNew.btnLogin_Click(Object sender, EventArgs e)
10/6/2024 11:08:35 AM: **************************** Error at Login Request for User , Message: Please Enter User Id ****************************
10/6/2024 11:08:42 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
10/6/2024 11:09:11 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
10/6/2024 11:23:51 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
10/6/2024 10:44:49 PM: Thread was being aborted.
System.Threading.ThreadAbortException: Thread was being aborted.
   at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.AbortCurrentThread()
   at System.Web.HttpResponse.End()
   at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent)
   at System.Web.HttpResponse.Redirect(String url)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
10/6/2024 10:58:18 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.LoginNew.btnLogin_Click(Object sender, EventArgs e)
10/6/2024 10:58:18 PM: **************************** Error at Login Request for User demo, Message: Invalid Credentials ****************************
10/6/2024 10:58:36 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/6/2024 11:08:25 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.LoginNew.btnLogin_Click(Object sender, EventArgs e)
10/6/2024 11:08:25 PM: **************************** Error at Login Request for User GBA.Admin, Message: Invalid Credentials ****************************
10/6/2024 11:08:31 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)