Log File Initialized... 5/20/2024 5:11:54 AM
5/20/2024 5:11:54 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)
5/20/2024 5:11:54 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)
5/20/2024 5:47:43 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.<Update>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
5/20/2024 5:47:43 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.<UpdateDataSecure>b__0()
5/20/2024 9:09:39 AM: select H.INVOICE_NO,(D.TOTAL_CONTRIBUTION-D.AGENT_AMOUNT)AS PAYABLE_TO_INSURANCE_COMPANY,H.POST_FLAG,H.SETTLED_TAG,a.ORG_ID,a.branch_id ,B.PLAN_NAME,a.CANCEL_STATUS,a.DOCUMENT_NUMBER,a.EMAIL,a.ADDRESS,a.TRAVEL_PURPOSE,a.DESTINATION_COUNTRY,a.DESTINATION_CITY,a.DESTINATION_STATE ,a.CONTRIBUTION_AMOUNT,a.NM_OF_DAYS,a.POLICY_NUMBER ,a.POLICY_STATUS,a.FULL_NAME , a.MOBILE_NO ,a.PLAN,a.PLAN_TYPE,a.DESTINATION,to_char(a.START_DATE,'dd/MM/yyyy') START_DATE, to_char(a.DATE_OF_BIRTH,'dd/MM/yyyy')DATE_OF_BIRTH ,a.FILER , a.CNIC_NO ,to_char(a.CNIC_ISSUE_DATE,'dd/MM/yyyy')CNIC_ISSUE_DATE , a.PASSPORT_NO, a.AGE_AT_ENTRY,NVL(A.AGE_TYPE,'Y') AS AGE_TYPE,NVL(A.OVER_AGE,'N') AS OVER_AGE,NVL(A.ALLOW_OVER_AGE,'N')AS ALLOW_OVER_AGE,a.NO_OF_DEPENDENT, a.SPOUSE_NAME,a.CHILD_NAME_1,a.DESTINATION2, a.CHILD_NAME_2, a.CHILD_NAME_3,a.CREATED_BY,to_char(a.CREATION_DATE,'dd/MM/yyyy')CREATION_DATE from TRAVLE_POLICY_T a left join TRAVEL_PLAN_T b on(a.ORG_ID=b.ORG_ID AND a.PLAN=b.TP_ID and a.branch_id=b.branch_id)
            LEFT JOIN TRAVEL_INVOICE_DETAIL_T  D ON (A.ORG_ID=D.ORG_ID AND A.POLICY_NUMBER=D.POLICY_NUMBER AND A.BRANCH_ID=D.BRANCH_ID)
            LEFT JOIN travel_invoice_header_t H ON (D.ORG_ID=H.ORG_ID AND D.INVOICE_NO=H.INVOICE_NO AND D.BRANCH_ID=H.BRANCH_ID)  WHERE a.org_id=6 and a.BRANCH_ID=1 AND (a.CREATION_DATE>to_date('01','dd/MM/yyyy') or to_char(A.CREATION_DATE,'dd/MM/yyyy')='01') AND (a.CREATION_DATE<to_date('01/04/2024','dd/MM/yyyy') or to_char(A.CREATION_DATE,'dd/MM/yyyy')='01/04/2024') AND a.CREATED_BY='smartholidays.travel' 
5/20/2024 9:09:39 AM: ORA-01840: input value not long enough for date format
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01840: input value not long enough for date format
   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/20/2024 9:09:39 AM: ORA-01840: input value not long enough for date format
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01840: input value not long enough for date format
   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.Services.Travel.TravelPolicyService.GetLookUpForTravelPolicy(TravelModel model)
   at ZealERP.ZealTakaful.Controllers.TravelPolicy.TravelPolicyController.<>c__DisplayClass3_0.<GetLookUpForTravelPolicy>b__0()
   at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService)
5/20/2024 4:42:45 PM: Document Not Found
ZealERP.ZealFramework.Utils.ZealException: Document Not Found
   at ZealERP.ZealTakaful.Services.Reports.ReportsService.GetAddressAndName(DocumentHeaderModelILAS doc)
   at ZealERP.ZealTakaful.Reports.CSAdditionOfRider.CSAdditionOfRider.PrepareReport()