Log File Initialized... 1/9/2025 12:08:37 AM 1/9/2025 12:08:37 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/9/2025 12:47: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) 1/9/2025 12:49:16 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/9/2025 1:12:48 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/9/2025 1:46: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/9/2025 2:08: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/9/2025 3:30:18 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/2025/1/12/Doc-005948' and p.BRANCH_ID=1?PNo=SIL/P/2025/1/12/Doc-005948,1 1/9/2025 3:30:18 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) 1/9/2025 3:30:18 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() 1/9/2025 3:30:18 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() 1/9/2025 3:45:19 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) 1/9/2025 3:45:19 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) 1/9/2025 3:45:35 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/9/2025 4:00: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/9/2025 4:01: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/9/2025 4:13:45 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.AppSelection.btnLogin_Click(Object sender, EventArgs e) 1/9/2025 4:15: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/9/2025 4:22:40 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/9/2025 5:10:53 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/9/2025 5:56: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/9/2025 6:18: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) 1/9/2025 6:55:01 AM: WITH itemData1 AS (SELECT CCH.BATCH_NO BATCHNO, 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_CONT_AFTER_DISC),0) - nvl(sum(i.RECEIVED_AMOUNT),0) BalCont FROM tk_doc_header_t a LEFT OUTER JOIN COMM_CYCLE_HEADER_T cch ON (cch.ORG_ID = a.ORG_ID AND cch.BRANCH_ID = a.BRANCH_ID ) 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 cch.batch_no between '' AND '' AND re.PARTNER_REGION_ID = AND dc.CHANNEL_ID = AND b.client_code = AND ch.AGENT_CODE = AND a.MASTER_REF_NO ='' GROUP BY CCH.BATCH_NO,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 BATCHNO,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,BATCHNO 1/9/2025 6:55:01 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/9/2025 6:55:01 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.GroupCommissionSummary.GroupCommissionSummary.PrepareReport() 1/9/2025 6:55:01 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.GroupCommissionSummary.GroupCommissionSummary.PrepareReport() 1/9/2025 7:58: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) 1/9/2025 8:09: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) 1/9/2025 8:10: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.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 1/9/2025 8:10: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.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 1/9/2025 8:10:38 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/9/2025 1:09:15 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) 1/9/2025 8:32:38 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/9/2025 8:39:53 PM: The maximum allowed amount is 30000\. You have already Policies amount of 28850\. and adding more 1750\. will result in 30600\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 30000\. You have already Policies amount of 28850\. and adding more 1750\. will result in 30600\. 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) 1/9/2025 8:39:53 PM: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 28850\. and adding more 1750\. will result in 30600\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 28850\. and adding more 1750\. will result in 30600\. 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() 1/9/2025 8:40:16 PM: The maximum allowed amount is 30000\. You have already Policies amount of 28850\. and adding more 1750\. will result in 30600\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 30000\. You have already Policies amount of 28850\. and adding more 1750\. will result in 30600\. 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) 1/9/2025 8:40:16 PM: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 28850\. and adding more 1750\. will result in 30600\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 28850\. and adding more 1750\. will result in 30600\. 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() 1/9/2025 8:40:41 PM: The maximum allowed amount is 30000\. You have already Policies amount of 28850\. and adding more 1750\. will result in 30600\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 30000\. You have already Policies amount of 28850\. and adding more 1750\. will result in 30600\. 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) 1/9/2025 8:40:41 PM: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 28850\. and adding more 1750\. will result in 30600\. which is greater than 30000\. ZealERP.ZealFramework.Utils.ZealException: Error.. The maximum allowed amount is 30000\. You have already Policies amount of 28850\. and adding more 1750\. will result in 30600\. 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() 1/9/2025 10:25: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/9/2025 10:36:25 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/9/2025 11:26: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/9/2025 11:36:25 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/9/2025 11:45:09 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/9/2025 11:45:09 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/9/2025 11:45:22 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)