Log File Initialized... 5/5/2024 3:21:36 AM 5/5/2024 3:21:36 AM: select a.ORG_ID,a.BRANCH_ID,a.MAIN_PRODUCT_CODE,a.SUB_PRODUCT_CODE,a.TAKAFUL_TYPE,DOCUMENT_TYPE,DOCUMENT_NO,RECORD_TYPE,a.NON_FINANCIAL_SUB_ACTIVITY,a.NON_FINANCIAL_ACTIVITY ,DOCUMENT_YEAR,ISSUE_COUNT,APPLICATION_ID,ENDORSEMENT_NO,a.CLIENT_CODE,DOC_REFERENCE_NO,ADVANCE_AMOUNT,a.COVER_MULTIPLE ,a.AGE1_OLD,to_char(a.DOB1_OLD,'dd/mm/yyyy') DOB1_OLD,a.GENDER1_OLD,a.POLICY_TERM_OLD,a.PAYMENT_TERM_OLD,a.PAYMENT_MODE_OLD ,a.SUM_COVERED_MODAL_OLD,a.COVER_MULTIPLE_OLD,a.BASIC_CONTRIBUTION_MODAL_OLD,a.FUND_SWITCH_CHARGES,a.FUND_CHANGE_TAG,a.UNDERWRITING_IL_CREATE ,a.CNIC_NO_OLD,a.NAME1_OLD, a.MIDDLE_NAME1_OLD, a.LAST_NAME1_OLD, a.IL_REVISE_TAG ,to_char(ISSUE_DATE,'dd/mm/yyyy') ISSUE_DATE ,to_char(COMM_DATE,'dd/mm/yyyy') COMM_DATE ,to_char(ALTERATION_DATE,'dd/mm/yyyy') ALTERATION_DATE ,to_char(DOC_DISPATCH_DATE,'dd/mm/yyyy') DOC_DISPATCH_DATE ,to_char(DOC_RECEIVE_DATE,'dd/mm/yyyy') DOC_RECEIVE_DATE ,to_char(RECEIVE_ACK_DATE,'dd/mm/yyyy') RECEIVE_ACK_DATE ,to_char(CANCELLATION_DATE,'dd/mm/yyyy') CANCELLATION_DATE ,to_char(DOB1,'dd/mm/yyyy') DOB1 ,to_char(EXPIRY_DATE,'dd/mm/yyyy') EXPIRY_DATE,COST_CENTER_CODE,CONVERT_TAG,REVISED_TAG,PAYMENT_MODE, ILLUSTRATION_REF_NO ,OCCUPATIONAL_CLASS,MASTER_REF_NO,BASE_DOC_NO,ALTERATION_TYPE,SUM_COVERED_MODAL,POSTING_TAG,AGE1, GENDER1 ,UNDWT_STATUS,UNDWT_DECISION,BASIC_CONTRIBUTION_MODAL,SUBMIT_TAG,POLICY_TERM,PAYMENT_TERM ,RISK_PROFILE, CONTRIBUTION_TYPE, RISK_PROFILE_COMMENTS, CUSTOMER_PROFILE_COMMENTS,BASIC_CONTRIBUTION,CONVERT_PROPOSAL ,AGENT_ID,CHANNEL_ID,MODEL_ID,PARTNER_ID,CONTRIBUTION_INDEX,SUM_COVERED_INDEX,SUM_COVERED,TOTAL_CONTRIBUTION_MODAL,TOPUP_AMOUNT ,CANCELLATION_TYPE,CHARGEABLE_FROM,CHARGEABLE_AMOUNT, NAME1, MIDDLE_NAME1, LAST_NAME1, a.CNIC_NO, a.BASE_DOC_NO_KEY, a.ILLUSTRATION_REF_NO_KEY, a.CONVERTED_DOC_NO_KEY, a.AGENT_BRANCH_ID ,CONVERTED_POLICY_NO, UNDWT_DECISION_REASON ,'PKR' CURRENCY_CODE, f.client_desc, CANCEL_TAG, REJECTED_TAG, CONSIGNMENT_NO, CANCELLATION_REMARKS ,POLICY_POSTED,UNDWT_DECISION_SYSTEM, PAYER_SAME_TAG, PROPOSAL_APPROVED_BY,a.AUTO_RENEWAL_TOPUP_TAG,a.AUTO_RENEWAL_TOPUP_TAG_OLD,CONTRIBUTION_INDEX_OLD,SUM_COVERED_INDEX_OLD, TOTAL_SCORE from IL_DOC_HEADER_T a left join GLAS_CLIENT_SETUP_T f on a.ORG_ID = f.ORG_ID and a.CLIENT_CODE = f.CLIENT_CODE where a.ORG_ID = :ORG_ID and a.BRANCH_ID = :BRANCH_ID and a.MAIN_PRODUCT_CODE = :MAIN_PRODUCT_CODE and a.SUB_PRODUCT_CODE = :SUB_PRODUCT_CODE and a.TAKAFUL_TYPE = :TAKAFUL_TYPE and a.DOCUMENT_TYPE = :DOCUMENT_TYPE and a.DOCUMENT_NO = :DOCUMENT_NO and a.RECORD_TYPE = :RECORD_TYPE and a.DOCUMENT_YEAR = :DOCUMENT_YEAR and a.ISSUE_COUNT = :ISSUE_COUNT and a.ENDORSEMENT_NO = :ENDORSEMENT_NO and a.APPLICATION_ID = :APPLICATION_ID params: ORG_ID=0, BRANCH_ID=0, MAIN_PRODUCT_CODE=0, SUB_PRODUCT_CODE=0, TAKAFUL_TYPE=, DOCUMENT_TYPE=, DOCUMENT_NO=, RECORD_TYPE=, DOCUMENT_YEAR=, ISSUE_COUNT=, ENDORSEMENT_NO=, APPLICATION_ID= 5/5/2024 3:21:36 AM: ORA-00904: "TOTAL_SCORE": invalid identifier Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00904: "TOTAL_SCORE": 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) 5/5/2024 3:21:36 AM: ORA-00904: "TOTAL_SCORE": invalid identifier Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00904: "TOTAL_SCORE": 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, OracleParameter[] commandParameters, Boolean ExecuteSp) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters) at ZealERP.ZealTakaful.Services.Reports.ReportsService.GetAddressAndName(DocumentHeaderModelILAS doc) at ZealERP.ZealTakaful.Reports.CSBenificiaryDetailsUpdate.CSBenificiaryDetailsUpdate.PrepareReport() 5/5/2024 7:21:40 AM: WITH CommmissionTab (Master_ref_No,org_id,PRIMARY_COMMISION,OVERIDING_COMMISION ) as ( select MASTER_REF_nO, orG_ID, nvl(pRIMARY,0) pRIMARY, nvl(Overriding ,0) Overriding FROM ( SELECT a.MASTER_REF_nO,a.org_id,COMMISSION_RATE, COMMISION_TYPE FROM TK_DOC_HEADER_T a LEFT outer join GLAS_DOC_AGENT_T gda on gda.org_id = a.org_id and gda.PRODUCT_CODE = a.PRODUCT_CODE and a.BRANCH_ID = gda.BRANCH_ID and gda.SUB_PRODUCT_CODE = a.SUB_PRODUCT_CODE and gda.TAKAFUL_TYPE = a.TAKAFUL_TYPE and gda.DOCUMENT_TYPE = a.DOCUMENT_TYPE and gda.DOCUMENT_NO = a.DOCUMENT_NO and gda.RECORD_TYPE = a.RECORD_TYPE and gda.DOCUMENT_YEAR= a.DOCUMENT_YEAR AND gdA.ENDORSEMENT_NO = 0 and gda.ISSUE_COUNT = a.ISSUE_COUNT and gda.ENDORSEMENT_NO = a.ENDORSEMENT_NO and gda.APPLICATION_ID = a.APPLICATION_ID ) PIVOT ( SUM(COMMISSION_RATE) FOR COMMISION_TYPE IN ( 'C' Primary, 'O' Overriding ) ) ) select distinct ROW_NUMBER() OVER (ORDER BY A.GDH_COMM_DATE, a.MASTER_REF_NO) SrNo , MAX(GPS.DESCRIPTION) LOB, nod4.DESCRIPTION PAYMENT_MODE, case when MAX(a.ISSUE_COUNT) =1 then 'New Business' else 'Renewal' end BUSINESS_TYPE, MAX(BUS_UNIT_DESC), MAX(cs.CLIENT_DESC) ContactPerson, AGENT_ID AGENT_CODE, AGENT_NAME , nvl(SUM(instl.RECEIVED_AMOUNT),0) RECEIVED_CONTRIBUTION, nob3.Description RiskCategorization, to_char(GDH_EXPIRY_DATE, 'dd-Mon-yyyy') END_DATE, to_CHAR(GDH_COMM_DATE,'dd-Mon-yyyy') START_DATE, to_char(GDH_COMM_DATE,'dd-Mon-yyyy') FirstStartDate, 0 PREVIOUS_BALANCE, sum(instl.GROSS_CONTRIBUTION) BILLED_CONTRIBUTION, ct.CONTACT_NAME , a.MASTER_REF_NO POLICY , cs.CLIENT_DESC PARTICIPANT_NAME , OVERIDING_COMMISION OVERIDING_COMMISION, PRIMARY_COMMISION PRIMARY_COMMISION FROM TK_DOC_HEADER_T a INNER JOIN AM_AGENT_T agt ON (agt.ORG_ID = a.ORG_ID AND agt.AGENT_ID = a.PRODUCER_CODE) Inner join CommmissionTab gda on a.org_id = gda.org_id and a.Master_ref_no = gda.Master_ref_No Left outer join GLAS_SUB_PRODUCT_SETUP_T gps on gps.org_id = a.org_id and gps.MAIN_PRODUCT_CODE= a.PRODUCT_CODE and gps.SUB_PRODUCT_CODE =a.SUB_PRODUCT_CODE left outer join GLAS_DOC_INSTALLMENTS_T instl on instl.ORG_ID = a.ORG_ID AND instl.BRANCH_ID= a.BRANCH_ID and instl.PRODUCT_CODE = a.PRODUCT_CODE and instl.SUB_PRODUCT_CODE = a.SUB_PRODUCT_CODE and instl.TAKAFUL_TYPE= a.TAKAFUL_TYPE and instl.DOCUMENT_TYPE = a.DOCUMENT_TYPE and instl.DOCUMENT_NO = a.DOCUMENT_NO and instl.RECORD_TYPE= a.RECORD_TYPE and instl.DOCUMENT_YEAR= a.DOCUMENT_YEAR and instl.ISSUE_COUNT= a.ISSUE_COUNT and instl.ENDORSEMENT_NO= a.ENDORSEMENT_NO and instl.APPLICATION_ID = a.APPLICATION_ID 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 (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 f.APPLICATION_ID = '12' and e.SETUP_NAME='OCCUPATIONAL CLASS' ) nob3 ON (nob3.ORG_ID = a.org_id AND nob3.ABBREVIATION = a.OCCUPATIONAL_CLASS) 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 f.APPLICATION_ID = '12' and e.SETUP_NAME='PAYMENT MODE' ) nod4 ON (nod4.ORG_ID = a.org_id AND nod4.ABBREVIATION = a.PAYMENT_MODE) LEFT OUTER JOIN GLAS_CLIENT_SETUP_T cs on A.PPS_PARTY_CODE = cs.CLIENT_CODE and a.org_id = cs.org_id LEFT OUTER JOIN GLAS_CLIENT_BUS_UNIT_T BU on BU.ORG_ID=A.ORG_ID and BU.CLIENT_CODE =cs.CLIENT_CODE lEFT OUTER JOIN GLAS_CLIENT_CONTACTPERSON_T CT on CT.ORG_ID=cs.ORG_ID and CT.CLIENT_CODE =cs.CLIENT_CODE and ct.BUS_UNIT_CODE = Bu.BUS_UNIT_CODE and ct.CONTACT_TYPE = 'P' and ct.CATEGORY = 'P' LEFT OUTER JOIN ENTITY_ADDRESS_T EA on EA.ORG_ID=ct.ORG_ID and EA.ENTITY_CODE =BU.BUS_UNIT_CODE and ENTITY_TYPE='CLTBR' LEFT OUTER JOIN GLAS_ALTERATION_TYPE_SETUP_T T on (T.ORG_ID=a.ORG_ID and t.ALTERATION_TYPE=a.ALTERATION_TYPE) LEFT OUTER JOIN COUNTRY_CITY_T CCT on EA.COUNTRY_CODE = cct.COUNTRY_CODE AND EA.STATE_CODE = CCT.STATE_CODE AND EA.CITY_CODE = CCT.CITY_CODE where a.org_id= and a.document_type='P' and ct.CONTACT_TYPE = 'P' and ct.CATEGORY = 'P' and a.record_type ='O' and nvl(instl.POSTING_TAG,'N') = 'Y' AND trunc(a.GDH_COMM_DATE) between '' AND '' GROUP BY AGENT_NAME ,AGENT_ID, GDH_EXPIRY_DATE , GDH_COMM_DATE,nod4.description, ct.CONTACT_NAME, a.MASTER_REF_NO, cs.CLIENT_DESC, nob3.description , a.GDH_COMM_DATE, A.GDH_EXPIRY_DATE, OVERIDING_COMMISION, PRIMARY_COMMISION ORDER BY A.MASTER_REF_NO 5/5/2024 7:21:40 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) 5/5/2024 11:19:08 PM: Invalid Credentials ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.LoginNew.btnLogin_Click(Object sender, EventArgs e) 5/5/2024 11:19:08 PM: Invalid Credentials ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.LoginNew.btnLogin_Click(Object sender, EventArgs e)