Log File Initialized... 5/27/2024 5:40:59 AM 5/27/2024 5:40:59 AM: SELECT nvl(e.firstname, '') || ' ' || (CASE WHEN nvl(e.middlename, '') IS NULL THEN '' ELSE e.middlename || ' ' END) || nvl(e.lastname, '') AS USERNAME, u.username AS Login_Id, u.email, e.employeenumber HRMS_empid, ( SELECT LISTAGG( R.ROLE_DESC , ', ') FROM SM_USER_ROLE_MAPPING_T UR , SM_ROLE_SETUP_T R WHERE UR.ROLE_ID = R.ROLE_ID AND UR.USERID = U.USERID) UserRoles, u.active, u.creation_date, u.last_login, u.PASSWORD_LAST_CHANGE_DATE, u.LAST_UPDATE_DATE AS Deactivation_Date, u.LAST_LOCK_DATE AS Last_Lockout_Date FROM SM_USERS_T u LEFT OUTER JOIN employee e ON trim(u.email)= trim(e.officialemail) 5/27/2024 5:40:59 AM: ORA-02000: missing WITHIN keyword Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-02000: missing WITHIN keyword 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/27/2024 5:40:59 AM: ORA-02000: missing WITHIN keyword Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-02000: missing WITHIN keyword 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.UserAuditReport.UserAudit.PrepareReport() 5/27/2024 8:55: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.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 5/27/2024 8:55: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.b__0() 5/27/2024 8:56:03 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) 5/27/2024 8:56:03 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() 5/27/2024 8:57:27 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) 5/27/2024 8:57:27 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() 5/27/2024 10:24:21 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) 5/27/2024 10:24:21 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) 5/27/2024 11:50:06 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()