Log File Initialized... 1/21/2025 12:01:48 AM 1/21/2025 12:01:48 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) 1/21/2025 12:01:48 AM: **************************** Error at Login Request for User GBA.Admin, Message: Invalid Credentials **************************** 1/21/2025 12:01:54 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 1/21/2025 12:02:22 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) 1/21/2025 1:01: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) 1/21/2025 1:01:58 AM: Empty path name is not legal. System.ArgumentException: Empty path name is not legal. at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access) at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetImage(FileDownload FileLogic) 1/21/2025 1:02:04 AM: Empty path name is not legal. System.ArgumentException: Empty path name is not legal. at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access) at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetImage(FileDownload FileLogic) 1/21/2025 1:07: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) 1/21/2025 1:28:32 AM: Empty path name is not legal. System.ArgumentException: Empty path name is not legal. at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access) at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetImage(FileDownload FileLogic) 1/21/2025 1:28:45 AM: All Periods Must be Closed Before Running Year End Process. ZealERP.ZealFramework.Utils.ZealException: All Periods Must be Closed Before Running Year End Process. at ZealERP.ZealTakaful.Services.GLApp.GLService.<>c__DisplayClass31_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 1/21/2025 1:28:45 AM: Error.. All Periods Must be Closed Before Running Year End Process. ZealERP.ZealFramework.Utils.ZealException: Error.. All Periods Must be Closed Before Running Year End Process. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealTakaful.Services.GLApp.GLService.RunYearEndProcess(String OrgId, String FiscalYear) at ZealERP.ZealTakaful.Controllers.GLAPP.GLController.<>c__DisplayClass19_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 1/21/2025 1:29:03 AM: Empty path name is not legal. System.ArgumentException: Empty path name is not legal. at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access) at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetImage(FileDownload FileLogic) 1/21/2025 1:29:14 AM: Empty path name is not legal. System.ArgumentException: Empty path name is not legal. at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access) at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetImage(FileDownload FileLogic) 1/21/2025 1:29:56 AM: Empty path name is not legal. System.ArgumentException: Empty path name is not legal. at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access) at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetImage(FileDownload FileLogic) 1/21/2025 1:30:24 AM: Empty path name is not legal. System.ArgumentException: Empty path name is not legal. at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access) at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetImage(FileDownload FileLogic) 1/21/2025 1:40: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) 1/21/2025 1:43:36 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 1/21/2025 1:50:57 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.Reports.TravelPolicy.TravelPolicySD.PrepareReport() 1/21/2025 1:50:57 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.Reports.TravelPolicy.TravelPolicySD.PrepareReport() 1/21/2025 1:51:24 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 1/21/2025 1:53:19 AM: Number of days finished to make changes ZealERP.ZealFramework.Utils.ZealException: Number of days finished to make changes at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.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) 1/21/2025 1:53:19 AM: Error.. Number of days finished to make changes ZealERP.ZealFramework.Utils.ZealException: Error.. Number of days finished to make changes 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() 1/21/2025 2:00: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) 1/21/2025 2:04: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) 1/21/2025 2:07: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) 1/21/2025 2:19: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) 1/21/2025 2:27:13 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) 1/21/2025 2:35:58 AM: The maximum allowed amount is 600000\. You have already Policies amount of 595700\. and adding more 11400\. will result in 607100\. which is greater than 600000\. ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 600000\. You have already Policies amount of 595700\. and adding more 11400\. will result in 607100\. which is greater than 600000\. 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) 1/21/2025 2:35:58 AM: Error.. The maximum allowed amount is 600000\. You have already Policies amount of 595700\. and adding more 11400\. will result in 607100\. which is greater than 600000\. ZealERP.ZealFramework.Utils.ZealException: Error.. The maximum allowed amount is 600000\. You have already Policies amount of 595700\. and adding more 11400\. will result in 607100\. which is greater than 600000\. 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() 1/21/2025 2:58:58 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 1/21/2025 3:01:39 AM: WITH itemData1 AS (SELECT 0 PreviousBal, CASE WHEN a.ISSUE_COUNT = 1 then 'New Business' ELSE 'Renewal' END AS TypeofBusiness, app.APPLICATION_DESC LOB, i.SERIAL_NO InstallmentNo, a.MASTER_REF_NO PolicyNo, b.CLIENT_DESC as participantName, to_char(a.GDH_COMM_DATE,'dd-Mon-yyyy') AS PolStartDate, to_char(a.GDH_EXPIRY_DATE,'dd-Mon-yyyy') AS PolEndDate, initcap( nvl(nob3.description, '-')) PaymentMode, a.ORG_ID, a.BRANCH_ID, a.PRODUCT_CODE, a.SUB_PRODUCT_CODE, a.TAKAFUL_TYPE, a.DOCUMENT_TYPE, a.DOCUMENT_NO, a.RECORD_TYPE, a.DOCUMENT_YEAR, a.ISSUE_COUNT, a.APPLICATION_ID, nvl(sum(i.GROSS_CONTRIBUTION),0) BilledCont, nvl(sum(i.RECEIVED_AMOUNT),0) ReceivedCont, nvl(sum(i.GROSS_CONTRIBUTION),0) - nvl(sum(i.RECEIVED_AMOUNT),0) BalCont FROM tk_doc_header_t a LEFT OUTER JOIN am_partner_t ap ON (a.ORG_ID = ap.ORG_ID AND ap.is_partner = 0) LEFT OUTER JOIN AM_PARTNER_BRANCHES_T apbt ON (apbt.ORG_ID = ap.ORG_ID AND apbt.partner_id = ap.partner_id AND apbt.PARTNER_BRANCH_ID = 14) LEFT OUTER JOIN AM_PARTNER_REGION_T re ON (re.ORG_ID = a.ORG_ID AND re.PARTNER_ID = apbt.PARTNER_ID AND re.PARTNER_REGION_ID = APBT.REGION_ID) LEFT OUTER JOIN glas_doc_agent_t ch ON ( a.ORG_ID = ch.ORG_ID AND a.BRANCH_ID = ch.BRANCH_ID AND a.product_code = ch.product_code AND a.sub_product_code = ch.sub_product_code AND a.takaful_type = ch.takaful_type AND a.document_type = ch.document_type AND a.record_type = ch.record_type AND a.document_no = ch.document_no AND a.document_year = ch.document_year AND a.issue_count = ch.issue_count AND a.endorsement_no = ch.endorsement_no AND a.application_id = ch.application_id and ch.AGENCY_TYPE not in ('O1','O2') ) LEFT OUTER JOIN AM_AGENT_CHANNEL_MODEL_T acm ON (acm.ORG_ID = CH.ORG_ID AND ACM.AGENT_ID = CH.AGENT_CODE AND acm.PARTNER_ID = CH.PARTNER_ID AND acm.CHANNEL_ID = ch.CHANNEL_ID ) LEFT OUTER JOIN AM_DISTRIBUTION_CHANNEL_T dc ON (dc.ORG_ID = ACM.ORG_ID AND dc.CHANNEL_ID = ACM.CHANNEL_ID) LEFT OUTER JOIN (SELECT e.APPLICATION_ID,e.ORG_ID,ABBREVIATION,DESCRIPTION FROM GEN_PARAM_SETUPHD_T e, GEN_PARAM_SETUP_DTL_T f where e.ORG_ID=f.ORG_ID and e.APPLICATION_ID=f.APPLICATION_ID and e.SETUP_ID=f.SETUP_ID and e.SETUP_NAME='PAYMENT MODE' ) nob3 ON (nob3.ORG_ID = a.org_id AND nob3.APPLICATION_ID = '12' AND nob3.ABBREVIATION = a.payment_mode) LEFT OUTER JOIN GLAS_CLIENT_SETUP_T b ON (a.ORG_ID = b.ORG_ID AND a.PPS_PARTY_CODE = b.CLIENT_CODE) LEFT OUTER JOIN GLAS_DOC_INSTALLMENTS_T i ON (a.ORG_ID = i.ORG_ID AND a.BRANCH_ID = i.BRANCH_ID AND a.product_code = i.product_code AND a.sub_product_code = i.sub_product_code AND a.takaful_type = i.takaful_type AND a.document_type = i.document_type AND a.record_type = i.record_type AND a.document_no = i.document_no AND a.document_year = i.document_year AND a.issue_count = i.issue_count AND a.endorsement_no = i.endorsement_no AND a.application_id = i.application_id) LEFT OUTER JOIN SM_APPLICATION_SETUPHD_T app ON (app.APPLICATION_ID = a.APPLICATION_ID) WHERE i.POSTING_TAG = 'Y' AND a.Document_type = 'P' AND i.DUE_DATE BETWEEN '' AND '' AND a.RECORD_TYPE = 'O' AND re.PARTNER_REGION_ID = AND dc.CHANNEL_ID = AND b.client_code = AND ch.AGENT_CODE = AND a.MASTER_REF_NO ='' GROUP BY app.APPLICATION_DESC, i.SERIAL_NO, a.MASTER_REF_NO, b.CLIENT_DESC, a.GDH_COMM_DATE, a.GDH_EXPIRY_DATE, nob3.description, a.ORG_ID, a.BRANCH_ID, a.PRODUCT_CODE, a.SUB_PRODUCT_CODE, a.TAKAFUL_TYPE, a.DOCUMENT_TYPE, a.DOCUMENT_NO, a.RECORD_TYPE, a.DOCUMENT_YEAR, a.ISSUE_COUNT, a.APPLICATION_ID ), itemData2 AS (SELECT ch.AGENT_NAME AgentName, a.ORG_ID, a.BRANCH_ID, a.PRODUCT_CODE, a.SUB_PRODUCT_CODE, a.TAKAFUL_TYPE, a.DOCUMENT_TYPE, a.DOCUMENT_NO, a.RECORD_TYPE, a.DOCUMENT_YEAR, a.ISSUE_COUNT, --a.ENDORSEMENT_NO, a.APPLICATION_ID, c.AGENT_CODE AGENTCODE, c.INSTALLMENT_NO, sum(CASE WHEN c.AGENCY_TYPE NOT IN ('O1','O2') THEN nvl(c.COMMISSION_RATE,0) ELSE 0 END) AS PrimaryComm, sum(CASE WHEN c.AGENCY_TYPE IN ('O1','O2') THEN nvl(c.COMMISSION_RATE,0) ELSE 0 END) AS OverrideComm, sum(CASE WHEN c.AGENCY_TYPE NOT IN ('O1','O2') THEN nvl(c.COMMISSION_AMOUNT,0) ELSE 0 END) AS PrimaryCommAmt, sum(CASE WHEN c.AGENCY_TYPE IN ('O1','O2') THEN nvl(c.COMMISSION_AMOUNT,0) ELSE 0 END) AS OverrideCommAmt FROM tk_doc_header_t a LEFT OUTER JOIN GLAS_DOC_COMMISSION_CYCLE_T c ON (a.ORG_ID = c.ORG_ID AND a.BRANCH_ID = c.BRANCH_ID AND a.product_code = c.product_code AND a.sub_product_code = c.sub_product_code AND a.takaful_type = c.takaful_type AND a.document_type = c.document_type AND a.record_type = c.record_type AND a.document_no = c.document_no AND a.document_year = c.document_year AND a.issue_count = c.issue_count AND a.endorsement_no = c.endorsement_no AND a.application_id = c.application_id ) LEFT OUTER JOIN am_agent_t ch ON (ch.ORG_ID = c.ORG_ID AND ch.AGENT_ID = c.AGENT_CODE) WHERE a.Document_type = 'P' AND a.POSTING_TAG = 'Y' AND a.Document_type = 'P' AND a.RECORD_TYPE = 'O' AND a.MASTER_REF_NO ='' GROUP BY ch.AGENT_NAME, c.INSTALLMENT_NO, a.ORG_ID, a.BRANCH_ID, a.PRODUCT_CODE, a.SUB_PRODUCT_CODE, a.TAKAFUL_TYPE, a.DOCUMENT_TYPE, a.DOCUMENT_NO, a.RECORD_TYPE, a.DOCUMENT_YEAR, a.ISSUE_COUNT, a.APPLICATION_ID, c.AGENT_CODE ) SELECT TypeofBusiness,LOB,PolicyNo,participantName,PolStartDate,PolEndDate,PaymentMode, AGENTCODE,AgentName, PreviousBal, sum(PrimaryComm) PrimaryComm,sum(OverrideComm) OverrideComm,sum(PrimaryCommAmt) PrimaryCommAmt,sum(OverrideCommAmt) OverrideCommAmt,sum(BilledCont) BilledCont,sum(ReceivedCont) ReceivedCont,sum(BalCont) BalCont FROM itemData1 a LEFT JOIN itemData2 c on (a.ORG_ID = c.ORG_ID AND a.BRANCH_ID = c.BRANCH_ID AND a.product_code = c.product_code AND a.sub_product_code = c.sub_product_code AND a.takaful_type = c.takaful_type AND a.document_type = c.document_type AND a.record_type = c.record_type AND a.document_no = c.document_no AND a.document_year = c.document_year AND a.issue_count = c.issue_count AND a.application_id = c.application_id AND a.InstallmentNo = c.INSTALLMENT_NO) GROUP BY TypeofBusiness,LOB,PolicyNo,participantName,PolStartDate,PolEndDate,PaymentMode,AGENTCODE,AGENTNAME,PreviousBal 1/21/2025 3:01:39 AM: ORA-00936: missing expression Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00936: missing expression 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) 1/21/2025 3:01:39 AM: ORA-00936: missing expression Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00936: missing expression 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.GroupCommissionAgentWise.GroupCommissionAgentWise.PrepareReport() 1/21/2025 3:01:39 AM: ORA-00936: missing expression Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00936: missing expression 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.GroupCommissionAgentWise.GroupCommissionAgentWise.PrepareReport() 1/21/2025 3:04: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) 1/21/2025 4:14:17 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) 1/21/2025 4:35: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) 1/21/2025 4:42:19 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 1/21/2025 5:16: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) 1/21/2025 5:30:31 AM: Number of days finished to make changes ZealERP.ZealFramework.Utils.ZealException: Number of days finished to make changes at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.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) 1/21/2025 5:30:31 AM: Error.. Number of days finished to make changes ZealERP.ZealFramework.Utils.ZealException: Error.. Number of days finished to make changes 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() 1/21/2025 5:38: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) 1/21/2025 6:38:08 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) 1/21/2025 8:43:45 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) 1/21/2025 8:44:46 PM: Number of days finished to make changes ZealERP.ZealFramework.Utils.ZealException: Number of days finished to make changes at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.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) 1/21/2025 8:44:46 PM: Error.. Number of days finished to make changes ZealERP.ZealFramework.Utils.ZealException: Error.. Number of days finished to make changes 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() 1/21/2025 9:09: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) 1/21/2025 9:26:43 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) 1/21/2025 9:42:50 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) 1/21/2025 9:47:27 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.Reports.BulkPrintingGBAPSS.BulkGBAPSS.PrepareReport() 1/21/2025 9:47:27 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.Reports.BulkPrintingGBAPSS.BulkGBAPSS.PrepareReport() 1/21/2025 9:51:57 PM: Invalid Credentials ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 1/21/2025 9:51:57 PM: Invalid Credentials ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 1/21/2025 9:52:26 PM: Invalid Credentials ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 1/21/2025 9:52:26 PM: Invalid Credentials ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 1/21/2025 9:56:21 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) 1/21/2025 9:56:23 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) 1/21/2025 9:56:39 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) 1/21/2025 9:57:32 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) 1/21/2025 9:58:33 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) 1/21/2025 10:01: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) 1/21/2025 10:13:44 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) 1/21/2025 10:36:28 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) 1/21/2025 10:40:58 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) 1/21/2025 10:51: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) 1/21/2025 10:54:01 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) 1/21/2025 10:55:47 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) 1/21/2025 10:59:55 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) 1/21/2025 11:28:09 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) 1/21/2025 11:46:26 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) 1/21/2025 11:53: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)