Log File Initialized... 8/29/2024 12:23:47 AM 8/29/2024 12:23:47 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) 8/29/2024 12:23:47 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) 8/29/2024 12:24: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.LoginNew.btnLogin_Click(Object sender, EventArgs e) 8/29/2024 12:24: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.LoginNew.btnLogin_Click(Object sender, EventArgs e) 8/29/2024 3:03:38 AM: insert into TRAVLE_POLICY_T (ORG_ID,BRANCH_ID,OVER_AGE,ALLOW_OVER_AGE,CANCEL_STATUS,DOCUMENT_NUMBER,POLICY_NUMBER,Full_Name,Mobile_No,Email,DATE_OF_BIRTH,AGE_AT_ENTRY,Passport_No,CNIC_NO,ADDRESS,START_DATE,CONTRIBUTION_AMOUNT,PLAN_TYPE,AGE_TYPE,Filer,TRAVEL_PURPOSE,Plan,NM_OF_DAYS,DESTINATION_COUNTRY,DESTINATION2,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE) values (:ORG_ID,:BRANCH_ID,:OVER_AGE,:ALLOW_OVER_AGE,:CANCEL_STATUS,:DOCUMENT_NUMBER,:POLICY_NUMBER,:Full_Name,:Mobile_No,:Email,:DATE_OF_BIRTH,:AGE_AT_ENTRY,:Passport_No,:CNIC_NO,:ADDRESS,:START_DATE,:CONTRIBUTION_AMOUNT,:PLAN_TYPE,:AGE_TYPE,:Filer,:TRAVEL_PURPOSE,:Plan,:NM_OF_DAYS,:DESTINATION_COUNTRY,:DESTINATION2,:CREATED_BY,:CREATION_DATE,:LAST_UPDATED_BY,:LAST_UPDATE_DATE) params: ORG_ID=6, BRANCH_ID=1, OVER_AGE=, ALLOW_OVER_AGE=, CANCEL_STATUS=, DOCUMENT_NUMBER=004449, POLICY_NUMBER=SIL/P/2024/10/1/Doc-004449, Full_Name=MUHAMMAD SALMAN IQBAL, Mobile_No=+92 331 7535691, Email=SALMAN_ENGR@HOTMAIL.CC, DATE_OF_BIRTH=11/4/1984 3:03:38 AM, AGE_AT_ENTRY=39, Passport_No=FB1330333, CNIC_NO=4130661340331, ADDRESS=HOUSE-NO-B-24 MUHALLA CITIZEN HOUSING SOCIETY QASIMABAD HYDRABAD, START_DATE=10/1/2024 3:03:38 AM, CONTRIBUTION_AMOUNT=700, PLAN_TYPE=16, AGE_TYPE=Y, Filer=, TRAVEL_PURPOSE=L, Plan=3, NM_OF_DAYS=10, DESTINATION_COUNTRY=138, DESTINATION2=, CREATED_BY=globaltips.agent, CREATION_DATE=8/29/2024 3:03:35 PM, LAST_UPDATED_BY=globaltips.agent, LAST_UPDATE_DATE=8/29/2024 3:03:35 PM 8/29/2024 3:03:38 AM: ORA-12899: value too large for column "ZEAL_ERP"."TRAVLE_POLICY_T"."MOBILE_NO" (actual: 25, maximum: 20) Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-12899: value too large for column "ZEAL_ERP"."TRAVLE_POLICY_T"."MOBILE_NO" (actual: 25, maximum: 20) at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone) at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, OracleException& exceptionForArrayBindDML, OracleConnection connection, Boolean isFromEF) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery() at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans) 8/29/2024 3:03:38 AM: ORA-12899: value too large for column "ZEAL_ERP"."TRAVLE_POLICY_T"."MOBILE_NO" (actual: 25, maximum: 20) Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-12899: value too large for column "ZEAL_ERP"."TRAVLE_POLICY_T"."MOBILE_NO" (actual: 25, maximum: 20) at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans) at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, OracleCommand trans) at ZealERP.ZealFramework.Utils.DB.InsertRecord(String TableName, OracleParameter[] parameters, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 8/29/2024 3:03:38 AM: ORA-12899: value too large for column "ZEAL_ERP"."TRAVLE_POLICY_T"."MOBILE_NO" (actual: 25, maximum: 20) Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-12899: value too large for column "ZEAL_ERP"."TRAVLE_POLICY_T"."MOBILE_NO" (actual: 25, maximum: 20) 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() 8/29/2024 3:03:50 AM: insert into TRAVLE_POLICY_T (ORG_ID,BRANCH_ID,OVER_AGE,ALLOW_OVER_AGE,CANCEL_STATUS,DOCUMENT_NUMBER,POLICY_NUMBER,Full_Name,Mobile_No,Email,DATE_OF_BIRTH,AGE_AT_ENTRY,Passport_No,CNIC_NO,ADDRESS,START_DATE,CONTRIBUTION_AMOUNT,PLAN_TYPE,AGE_TYPE,Filer,TRAVEL_PURPOSE,Plan,NM_OF_DAYS,DESTINATION_COUNTRY,DESTINATION2,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE) values (:ORG_ID,:BRANCH_ID,:OVER_AGE,:ALLOW_OVER_AGE,:CANCEL_STATUS,:DOCUMENT_NUMBER,:POLICY_NUMBER,:Full_Name,:Mobile_No,:Email,:DATE_OF_BIRTH,:AGE_AT_ENTRY,:Passport_No,:CNIC_NO,:ADDRESS,:START_DATE,:CONTRIBUTION_AMOUNT,:PLAN_TYPE,:AGE_TYPE,:Filer,:TRAVEL_PURPOSE,:Plan,:NM_OF_DAYS,:DESTINATION_COUNTRY,:DESTINATION2,:CREATED_BY,:CREATION_DATE,:LAST_UPDATED_BY,:LAST_UPDATE_DATE) params: ORG_ID=6, BRANCH_ID=1, OVER_AGE=, ALLOW_OVER_AGE=, CANCEL_STATUS=, DOCUMENT_NUMBER=004449, POLICY_NUMBER=SIL/P/2024/10/1/Doc-004449, Full_Name=MUHAMMAD SALMAN IQBAL, Mobile_No=+92 331 7535691, Email=SALMAN_ENGR@HOTMAIL.CC, DATE_OF_BIRTH=11/4/1984 3:03:50 AM, AGE_AT_ENTRY=39, Passport_No=FB1330333, CNIC_NO=4130661340331, ADDRESS=HOUSE-NO-B-24 MUHALLA CITIZEN HOUSING SOCIETY QASIMABAD HYDRABAD, START_DATE=10/1/2024 3:03:50 AM, CONTRIBUTION_AMOUNT=700, PLAN_TYPE=16, AGE_TYPE=Y, Filer=, TRAVEL_PURPOSE=L, Plan=3, NM_OF_DAYS=10, DESTINATION_COUNTRY=138, DESTINATION2=, CREATED_BY=globaltips.agent, CREATION_DATE=8/29/2024 3:03:48 PM, LAST_UPDATED_BY=globaltips.agent, LAST_UPDATE_DATE=8/29/2024 3:03:48 PM 8/29/2024 3:03:50 AM: ORA-12899: value too large for column "ZEAL_ERP"."TRAVLE_POLICY_T"."MOBILE_NO" (actual: 25, maximum: 20) Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-12899: value too large for column "ZEAL_ERP"."TRAVLE_POLICY_T"."MOBILE_NO" (actual: 25, maximum: 20) at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone) at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, OracleException& exceptionForArrayBindDML, OracleConnection connection, Boolean isFromEF) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery() at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans) 8/29/2024 3:03:50 AM: ORA-12899: value too large for column "ZEAL_ERP"."TRAVLE_POLICY_T"."MOBILE_NO" (actual: 25, maximum: 20) Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-12899: value too large for column "ZEAL_ERP"."TRAVLE_POLICY_T"."MOBILE_NO" (actual: 25, maximum: 20) at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans) at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, OracleCommand trans) at ZealERP.ZealFramework.Utils.DB.InsertRecord(String TableName, OracleParameter[] parameters, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 8/29/2024 3:03:50 AM: ORA-12899: value too large for column "ZEAL_ERP"."TRAVLE_POLICY_T"."MOBILE_NO" (actual: 25, maximum: 20) Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-12899: value too large for column "ZEAL_ERP"."TRAVLE_POLICY_T"."MOBILE_NO" (actual: 25, maximum: 20) 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() 8/29/2024 4:15:02 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.application_id = a.application_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 8/29/2024 4:15:02 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) 8/29/2024 7:35:05 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.LoginNew.btnLogin_Click(Object sender, EventArgs e) 8/29/2024 7:35:05 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.LoginNew.btnLogin_Click(Object sender, EventArgs e) 8/29/2024 7:35:18 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.LoginNew.btnLogin_Click(Object sender, EventArgs e) 8/29/2024 7:35:18 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.LoginNew.btnLogin_Click(Object sender, EventArgs e) 8/29/2024 7:35:25 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.LoginNew.btnLogin_Click(Object sender, EventArgs e) 8/29/2024 7:35:25 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.LoginNew.btnLogin_Click(Object sender, EventArgs e) 8/29/2024 7:39:23 AM: 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) 8/29/2024 5:51:29 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.UnitReports.UnitReport.getdata() 8/29/2024 10:47:54 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) 8/29/2024 10:47:54 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) 8/29/2024 11:38:59 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) 8/29/2024 11:38:59 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) 8/29/2024 11:46:37 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.TravelPolicy.TravelPolicySD.PrepareReport() 8/29/2024 11:55:59 PM: SELECT AGE_FROM,AGE_FROM_TYPE,AGE_TO FROM TRAVEL_PLAN_T WHERE ORG_ID=6 AND TP_ID= AND BRANCH_ID=6 8/29/2024 11:55:59 PM: 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) 8/29/2024 11:55:59 PM: 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, OracleCommand trans) at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.ValidateAgeForPlan(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) 8/29/2024 11:55:59 PM: ORA-00936: missing expression Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00936: missing expression 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()