Log File Initialized... 12/9/2024 12:03:17 AM 12/9/2024 12:03: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) 12/9/2024 12:03:36 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) 12/9/2024 12:03:40 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) 12/9/2024 12:03:51 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) 12/9/2024 12:03:57 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) 12/9/2024 12:34:03 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/9/2024 2:27:30 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/9/2024 2:52: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/9/2024 3:25: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) 12/9/2024 3:25: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/9/2024 3:37: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/9/2024 3:44:46 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/9/2024 3:57: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/9/2024 3:58: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/9/2024 4:31:30 AM: Please Enter User Id ZealERP.ZealFramework.Utils.ZealException: Please Enter User Id at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 12/9/2024 4:31:30 AM: Please Enter User Id ZealERP.ZealFramework.Utils.ZealException: Please Enter User Id at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 12/9/2024 4:31:33 AM: Please Enter User Id ZealERP.ZealFramework.Utils.ZealException: Please Enter User Id at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 12/9/2024 4:31:33 AM: Please Enter User Id ZealERP.ZealFramework.Utils.ZealException: Please Enter User Id at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 12/9/2024 4:31: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) 12/9/2024 4:41: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/9/2024 4:43: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/9/2024 4:49:52 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/9/2024 4:57: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/9/2024 5:03:41 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) 12/9/2024 5:03:41 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() 12/9/2024 5:06: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/9/2024 5:19:13 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() 12/9/2024 5:19:13 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() 12/9/2024 5:37: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/9/2024 5:55:44 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/9/2024 5:55:44 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/9/2024 5:56: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.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 12/9/2024 5:56: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.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 12/9/2024 6:05:30 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/9/2024 6:08:10 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/9/2024 6:13: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/9/2024 6:37: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/9/2024 5:31:55 PM: WITH Endorsement_TABLE AS ( SELECT b.ORG_ID,b.BRANCH_ID,b.SUB_PRODUCT_CODE, b.TAKAFUL_TYPE, b.DOCUMENT_TYPE,b.DOCUMENT_NO, b.RECORD_TYPE, b.DOCUMENT_YEAR,b.ISSUE_COUNT, b.APPLICATION_ID, max(B.ENDORSEMENT_NO) AS End_No FROM TK_DOC_HEADER_T b where b.ORG_ID=5 AND B.DOCUMENT_TYPE ='P' AND B.RECORD_TYPE = CASE WHEN B.ENDORSEMENT_NO =0 THEN 'O' ELSE 'P' END GROUP BY b.ORG_ID,b.BRANCH_ID,b.SUB_PRODUCT_CODE, b.TAKAFUL_TYPE, b.DOCUMENT_TYPE,b.DOCUMENT_NO, b.RECORD_TYPE, b.DOCUMENT_YEAR,b.ISSUE_COUNT, b.APPLICATION_ID ) , CLAIM_INTIMATION AS( SELECT C_INT.ORG_ID,C_INT.BRANCH_ID,C_INT.SUB_PRODUCT_CODE,C_INT.APPLICATION_ID,C_INT.POLICY_HOLDER,C_INT.ENDORSEMENT_NO,C_INT.POLICY_NO, SUM(C_ASS.ASSESSMENT_AMOUNT)AS ASSESSMENT_AMOUNT FROM TK_CLAIM_INTIMATION_T C_INT LEFT OUTER JOIN TK_CLAIM_ASSESSMENT_T C_ASS ON(C_INT.ORG_ID=C_ASS.ORG_ID AND C_INT.BRANCH_ID=C_ASS.BRANCH_ID AND C_INT.SUB_PRODUCT_CODE=C_ASS.SUB_PRODUCT_CODE AND C_INT.APPLICATION_ID=C_ASS.APPLICATION_ID AND C_INT.CLAIM_NO=C_ASS.CLAIM_NO AND C_ASS.ASSESSMENT_STATUS IN ('A')) WHERE C_INT.ORG_ID=5 AND C_INT.BRANCH_ID=14 AND C_INT.SUB_PRODUCT_CODE=1 AND C_INT.APPLICATION_ID=11 GROUP BY(C_INT.ORG_ID,C_INT.BRANCH_ID,C_INT.SUB_PRODUCT_CODE,C_INT.APPLICATION_ID,C_INT.POLICY_HOLDER,C_INT.ENDORSEMENT_NO,C_INT.POLICY_NO)), DOC_INSTALLMENT AS (SELECT TO_CHAR(MAX(DUE_DATE), 'dd-Mon-yyyy')DUE_DATE,ORG_ID,BRANCH_ID,SUB_PRODUCT_CODE,DOCUMENT_TYPE,TAKAFUL_TYPE, RECORD_TYPE,DOCUMENT_YEAR,ISSUE_COUNT,ENDORSEMENT_NO,APPLICATION_ID,DOCUMENT_NO,POSTING_TAG FROM GLAS_DOC_INSTALLMENTS_T WHERE ORG_ID=5 AND BRANCH_ID=14 AND APPLICATION_ID=11 AND SUB_PRODUCT_CODE=1 GROUP BY(ORG_ID,BRANCH_ID,SUB_PRODUCT_CODE,DOCUMENT_TYPE,TAKAFUL_TYPE,RECORD_TYPE, DOCUMENT_TYPE,DOCUMENT_YEAR,ISSUE_COUNT,ENDORSEMENT_NO,APPLICATION_ID,DOCUMENT_NO,POSTING_TAG)), DOC_INSURED AS (SELECT count(*)totalLives,A.ORG_ID,A.BRANCH_ID,A.APPLICATION_ID,A.SUB_PRODUCT_CODE,A.ENDORSEMENT_NO,A.ISSUE_COUNT,A.PPS_PARTY_CODE,A.master_ref_no FROM TK_DOC_HEADER_T a left outer join GLAS_DOC_INSURED_ITEMS_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) GROUP BY(A.ORG_ID,A.BRANCH_ID,A.APPLICATION_ID,A.SUB_PRODUCT_CODE,A.ENDORSEMENT_NO,A.ISSUE_COUNT,A.PPS_PARTY_CODE,A.master_ref_no)) SELECT SUM (BR.SUM_INSURED)ReqTakSum, SUM (BR.APPROVED_SA)AppTakSum, BR.ENDORSEMENT_NO, TO_CHAR(HD.POST_DATE,'dd-Mon-yyyy') PolAppDate, com.COMM_PERCENT_SHARE, --BRS.SUM_INSURED, --BRS.APPROVED_SA, --NO OF LIVES, --HD.GDH_DOC_REFERENCE_NO PolicyNo, hd.pps_party_code, hd.master_ref_no PolicyNo, c_intm.assessment_amount, INST.DUE_DATE Renewal, INS.totalLives Live, hd.ENDORSEMENT_NO , hd.ISSUE_COUNT , CASE hd.PAYMENT_MODE WHEN 'M' THEN 'MONTHLY' WHEN 'Q' THEN 'QUATERLY' WHEN 'H' THEN 'HALF_YEARLY' ELSE 'ANUALLY' END AS PaymentMode, CLT.CLIENT_DESC Participant, TO_CHAR(HD.GDH_COMM_DATE,'dd-Mon-yyyy') PolStartDate, TO_CHAR(HD.GDH_EXPIRY_DATE,'dd-Mon-yyyy') PolEndDate, nvl(CLT.VAT_REG_NO,'-') ntnNo, AGT.AGENT_NAME AgentName, AGT.AGENT_ID AgentCode, nvl(HD.BASIC_CONTRIBUTION,0) currentt, nvl(HD.GDH_GROSS_PREMIUM,0) Annualized, HD.NET_CONTRIBUTION, c_intm.assessment_amount ClaimsAmount, ROUND (c_intm.assessment_amount/nvl(HD.GDH_GROSS_PREMIUM,0) * 100,2) AS GrossLoss, ROUND (c_intm.assessment_amount/nvl(HD.NET_CONTRIBUTION,0) * 100,2) AS NetLoss --SELECT * from tk_doc_header_t hd INNER JOIN Endorsement_TABLE ET ON (ET.ORG_ID = hd.ORG_ID AND ET.BRANCH_ID = hd.BRANCH_ID AND ET.SUB_PRODUCT_CODE = hd.SUB_PRODUCT_CODE AND ET.TAKAFUL_TYPE = hd.TAKAFUL_TYPE AND ET.DOCUMENT_TYPE = hd.DOCUMENT_TYPE AND ET.RECORD_TYPE = hd.RECORD_TYPE AND ET.DOCUMENT_YEAR = hd.DOCUMENT_YEAR AND ET.ISSUE_COUNT = hd.ISSUE_COUNT AND ET.APPLICATION_ID = hd.APPLICATION_ID AND ET.DOCUMENT_NO = hd.DOCUMENT_NO AND hd.ENDORSEMENT_NO = ET.End_No ) join claim_intimation c_intm on ( C_INTM.ORG_ID = HD.org_id AND C_INTM.BRANCH_ID = HD.BRANCH_ID AND C_INTM.SUB_PRODUCT_CODE = HD.SUB_PRODUCT_CODE AND C_INTM.APPLICATION_ID =HD.APPLICATION_ID AND C_INTM.POLICY_NO =hd.master_ref_no AND C_INTM.ENDORSEMENT_NO =HD.endorsement_no AND C_INTM.POLICY_HOLDER =HD.pps_party_code) LEFT JOIN DOC_INSTALLMENT INST ON INST.ORG_ID=HD.ORG_ID and INST.BRANCH_ID=HD.BRANCH_ID and INST.SUB_PRODUCT_CODE=HD.SUB_PRODUCT_CODE and INST.TAKAFUL_TYPE=HD.TAKAFUL_TYPE and INST.DOCUMENT_TYPE=HD.DOCUMENT_TYPE and INST.RECORD_TYPE=HD.RECORD_TYPE and INST.DOCUMENT_YEAR=HD.DOCUMENT_YEAR and INST.ISSUE_COUNT=HD.ISSUE_COUNT and INST.ENDORSEMENT_NO=HD.ENDORSEMENT_NO and INST.APPLICATION_ID=HD.APPLICATION_ID and INST.DOCUMENT_NO=HD.DOCUMENT_NO AND nvl(INST.POSTING_TAG, 'N') <> 'Y' LEFT JOIN DOC_INSURED INS ON (INS.ORG_ID=HD.ORG_ID AND INS.BRANCH_ID=HD.BRANCH_ID AND INS.SUB_PRODUCT_CODE=HD.SUB_PRODUCT_CODE AND INS.ENDORSEMENT_NO=HD.ENDORSEMENT_NO AND INS.APPLICATION_ID=HD.APPLICATION_ID AND INS.PPS_PARTY_CODE=HD.PPS_PARTY_CODE AND INS.master_ref_no=HD.MASTER_REF_NO) LEFT OUTER JOIN GLAS_DOC_INSURED_ITEMS_T BR ON (hd.ORG_ID = BR.ORG_ID and hd.BRANCH_ID = BR.BRANCH_ID and hd.product_code = BR.product_code AND hd.sub_product_code = BR.sub_product_code and hd.takaful_type = BR.takaful_type and hd.document_type = BR.document_type and hd.record_type = BR.record_type and hd.document_no = BR.document_no and hd.document_year = BR.document_year and hd.issue_count = BR.issue_count and BR.endorsement_no=hd.endorsement_no and hd.application_id = BR.application_id) LEFT OUTER JOIN GLAS_DOC_INSURED_ITEMS_T BRS ON (hd.ORG_ID = BRS.ORG_ID and hd.BRANCH_ID = BRS.BRANCH_ID and hd.product_code = BRS.product_code AND hd.sub_product_code = BRS.sub_product_code and hd.takaful_type = BRS.takaful_type and hd.document_type = BRS.document_type and hd.record_type = BRS.record_type and hd.document_no = BRS.document_no and hd.document_year = BRS.document_year and hd.issue_count = BRS.issue_count and BRS.endorsement_no=0 and hd.application_id = BRS.application_id) LEFT outer join GLAS_DOC_COMMISSION_CYCLE_T COM ON (hd.ORG_ID = COM.ORG_ID and hd.BRANCH_ID = COM.BRANCH_ID and hd.product_code = COM.product_code AND hd.sub_product_code = COM.sub_product_code and hd.takaful_type = COM.takaful_type and hd.document_type = COM.document_type and hd.record_type = COM.record_type and hd.document_no = COM.document_no and hd.document_year = COM.document_year and hd.issue_count = COM.issue_count and hd.endorsement_no = COM.endorsement_no and hd.application_id = COM.application_id AND COM.AGENCY_TYPE ='P') LEFT OUTER JOIN GLAS_CLIENT_SETUP_T CLT ON (HD.ORG_ID = CLT.ORG_ID AND HD.PPS_PARTY_CODE = CLT.CLIENT_CODE) LEFT OUTER JOIN am_agent_t AGT ON AGT.ORG_ID = HD.ORG_ID AND AGT.AGENT_ID = HD.PRODUCER_CODE WHERE HD.ORG_ID='' and HD.GDH_DOC_REFERENCE_NO IS NOT NULL AND HD.DOCUMENT_TYPE = 'P' AND HD.POSTING_TAG = 'Y' AND HD.ENDORSEMENT_NO = 0 AND HD.GDH_ISSUE_DATE BETWEEN '' AND ''and CHANN.CHANNEL_ID='' AND AGT.AGENT_ID ='' AND HD.GDH_DOC_REFERENCE_NO ='' Group by HD.POST_DATE,com.COMM_PERCENT_SHARE,hd.pps_party_code,hd.master_ref_no,c_intm.assessment_amount,INST.DUE_DATE,INS.totalLives,HD.BASIC_CONTRIBUTION,hd.ENDORSEMENT_NO ,hd.ISSUE_COUNT , hd.PAYMENT_MODE, CLT.CLIENT_DESC,HD.GDH_COMM_DATE,HD.GDH_EXPIRY_DATE,CLT.VAT_REG_NO,AGT.AGENT_NAME,AGT.AGENT_ID,HD.GDH_GROSS_PREMIUM,HD.NET_CONTRIBUTION,c_intm.assessment_amount,c_intm.assessment_amount,HD.GDH_GROSS_PREMIUM,c_intm.assessment_amount,HD.NET_CONTRIBUTION,BR.ENDORSEMENT_NO 12/9/2024 5:31:55 PM: ORA-00904: "CHANN"."CHANNEL_ID": invalid identifier Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00904: "CHANN"."CHANNEL_ID": invalid identifier 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/9/2024 5:31:55 PM: ORA-00904: "CHANN"."CHANNEL_ID": invalid identifier Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00904: "CHANN"."CHANNEL_ID": invalid identifier 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.PolicyActivationReports.PolicyActivationReport.PrepareReport() 12/9/2024 5:31:55 PM: ORA-00904: "CHANN"."CHANNEL_ID": invalid identifier Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00904: "CHANN"."CHANNEL_ID": invalid identifier 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.PolicyActivationReports.PolicyActivationReport.PrepareReport() 12/9/2024 8:35:40 PM: Object reference not set to an instance of an object. System.NullReferenceException: Object reference not set to an instance of an object. at ZealERP.ZealTakaful.ZealUtil.ZealReportRDLC.ExecuteReport(String ReportPath, NameValueCollection Form, ReportViewer ReportViewer1, HttpResponse Response) 12/9/2024 8:35:40 PM: Object reference not set to an instance of an object. System.NullReferenceException: Object reference not set to an instance of an object. at ZealERP.ZealTakaful.ZealUtil.ZealReportRDLC.ExecuteReport(String ReportPath, NameValueCollection Form, ReportViewer ReportViewer1, HttpResponse Response) 12/9/2024 10:14:54 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) 12/9/2024 11:40:17 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) 12/9/2024 11:42: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) 12/9/2024 11:58:40 PM: 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.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 12/9/2024 11:58:40 PM: 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.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 12/9/2024 11:59:02 PM: 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.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 12/9/2024 11:59:02 PM: 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.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e)