Log File Initialized... 12/14/2024 12:11:20 AM 12/14/2024 12:11:20 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/14/2024 12:35:27 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) 12/14/2024 12:44:50 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/14/2024 12:55:05 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) 12/14/2024 1:10:02 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) 12/14/2024 1:41:10 AM: User Profile is Inactive ZealERP.ZealFramework.Utils.ZealException: User Profile is Inactive 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) 12/14/2024 1:41:10 AM: **************************** Error at Login Request for User travel.designer128, Message: User Profile is Inactive **************************** 12/14/2024 1:41:24 AM: Please Enter Password ZealERP.ZealFramework.Utils.ZealException: Please Enter Password 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) 12/14/2024 1:41:24 AM: **************************** Error at Login Request for User travel.designer128, Message: Please Enter Password **************************** 12/14/2024 1:41:47 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/14/2024 1:42:30 AM: Record can't be updated. ZealERP.ZealFramework.Utils.ZealException: Record can't be updated. at ZealERP.ZealTakaful.Services.DBServiceChildAgentRegistration.BeforeUpdate(SaveDataModel record, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass25_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 12/14/2024 1:42:30 AM: Error.. Record can't be updated. ZealERP.ZealFramework.Utils.ZealException: Error.. Record can't be updated. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Update(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.UpdateSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass7_0.b__0() 12/14/2024 1:43:15 AM: User Profile is Inactive ZealERP.ZealFramework.Utils.ZealException: User Profile is Inactive 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) 12/14/2024 1:43:15 AM: **************************** Error at Login Request for User travel.designer128, Message: User Profile is Inactive **************************** 12/14/2024 1:43: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) 12/14/2024 1:44:42 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/14/2024 1:44: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) 12/14/2024 1:47:27 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) 12/14/2024 1:47: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) 12/14/2024 1:48:21 AM: select TP_ID FROM AGENT_PLAN_MAPPING WHERE ORG_ID=6 AND USER_ID='null' AND BRANCH_ID=1 12/14/2024 1:48:21 AM: ORA-01722: invalid number Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01722: invalid number 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) 12/14/2024 1:48:21 AM: ORA-01722: invalid number Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01722: invalid number 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.AgentAuthorityService.GetSavedPlanMapping(String ORG_ID, String USER_ID, String BRANCH_ID) at ZealERP.ZealTakaful.Controllers.TravelPolicy.AgentAuthorityController.<>c__DisplayClass3_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 12/14/2024 1:48:27 AM: select TP_ID FROM AGENT_PLAN_MAPPING WHERE ORG_ID=6 AND USER_ID='null' AND BRANCH_ID=1 12/14/2024 1:48:27 AM: ORA-01722: invalid number Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01722: invalid number 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) 12/14/2024 1:48:27 AM: ORA-01722: invalid number Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01722: invalid number 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.AgentAuthorityService.GetSavedPlanMapping(String ORG_ID, String USER_ID, String BRANCH_ID) at ZealERP.ZealTakaful.Controllers.TravelPolicy.AgentAuthorityController.<>c__DisplayClass3_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 12/14/2024 1:55:15 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) 12/14/2024 1:55:26 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/14/2024 1:58:57 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/14/2024 2:01:10 AM: The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.ValidateAmounts(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.BeforeSave(SaveDataModel record, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 12/14/2024 2:01:10 AM: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0() 12/14/2024 2:01:39 AM: The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.ValidateAmounts(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.BeforeSave(SaveDataModel record, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 12/14/2024 2:01:39 AM: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0() 12/14/2024 2:03:55 AM: The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.ValidateAmounts(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.BeforeSave(SaveDataModel record, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 12/14/2024 2:03:55 AM: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0() 12/14/2024 2:04: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.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 12/14/2024 2:04: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.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 12/14/2024 2:04:47 AM: The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.ValidateAmounts(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.BeforeSave(SaveDataModel record, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 12/14/2024 2:04:47 AM: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0() 12/14/2024 2:04:53 AM: The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.ValidateAmounts(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.BeforeSave(SaveDataModel record, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 12/14/2024 2:04:53 AM: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0() 12/14/2024 2:04:55 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/14/2024 2:05:41 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/14/2024 2:06:51 AM: The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.ValidateAmounts(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.BeforeSave(SaveDataModel record, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 12/14/2024 2:06:51 AM: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0() 12/14/2024 2:07:27 AM: The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.ValidateAmounts(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.BeforeSave(SaveDataModel record, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 12/14/2024 2:07:27 AM: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0() 12/14/2024 2:08:17 AM: The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.ValidateAmounts(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.BeforeSave(SaveDataModel record, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 12/14/2024 2:08:17 AM: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0() 12/14/2024 2:08:19 AM: The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.ValidateAmounts(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.BeforeSave(SaveDataModel record, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 12/14/2024 2:08:19 AM: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0() 12/14/2024 2:08:21 AM: The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.ValidateAmounts(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.BeforeSave(SaveDataModel record, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 12/14/2024 2:08:21 AM: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0() 12/14/2024 2:08:22 AM: The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.ValidateAmounts(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.BeforeSave(SaveDataModel record, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 12/14/2024 2:08:22 AM: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 25800\. and adding more 13950\. will result in 39750\. which is greater than 30000\. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0() 12/14/2024 2:44: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) 12/14/2024 2:56:41 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/14/2024 3:01:26 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/14/2024 3:09:29 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/14/2024 3:21:57 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/14/2024 3:25: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) 12/14/2024 4:45:57 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/14/2024 8:14:47 AM: 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) 12/14/2024 8:14:47 AM: 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) 12/14/2024 8:48:00 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) 12/14/2024 10:42:02 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) 12/14/2024 11:15:12 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) 12/14/2024 11:54:49 AM: 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/1/15/Doc-005224' and p.BRANCH_ID=1?PNo=SIL/P/2024/1/15/Doc-005224,1 12/14/2024 11:54:49 AM: 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) 12/14/2024 11:54:49 AM: 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() 12/14/2024 11:54:49 AM: 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() 12/14/2024 9:19: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)