Log File Initialized... 4/1/2024 1:18:13 AM 4/1/2024 1:18:13 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) 4/1/2024 1:18:13 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) 4/1/2024 1:18:33 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) 4/1/2024 1:18:33 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) 4/1/2024 2:37:21 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) 4/1/2024 2:37:21 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) 4/1/2024 3:08:28 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) 4/1/2024 3:08:28 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() 4/1/2024 3:08:51 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) 4/1/2024 3:08:51 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() 4/1/2024 3:10:38 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) 4/1/2024 3:10:38 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() 4/1/2024 3:24:28 AM: The maximum allowed amount is 100000\. You have already Policies amount of 92125\. and adding more 10400\. will result in 102525\. which is greater than 100000\. ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 100000\. You have already Policies amount of 92125\. and adding more 10400\. will result in 102525\. which is greater than 100000\. at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.ValidateAmounts(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) 4/1/2024 3:24:28 AM: Error.. The maximum allowed amount is 100000\. You have already Policies amount of 92125\. and adding more 10400\. will result in 102525\. which is greater than 100000\. ZealERP.ZealFramework.Utils.ZealException: Error.. The maximum allowed amount is 100000\. You have already Policies amount of 92125\. and adding more 10400\. will result in 102525\. which is greater than 100000\. 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() 4/1/2024 3:24:51 AM: The maximum allowed amount is 100000\. You have already Policies amount of 92125\. and adding more 10400\. will result in 102525\. which is greater than 100000\. ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 100000\. You have already Policies amount of 92125\. and adding more 10400\. will result in 102525\. which is greater than 100000\. at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.ValidateAmounts(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) 4/1/2024 3:24:51 AM: Error.. The maximum allowed amount is 100000\. You have already Policies amount of 92125\. and adding more 10400\. will result in 102525\. which is greater than 100000\. ZealERP.ZealFramework.Utils.ZealException: Error.. The maximum allowed amount is 100000\. You have already Policies amount of 92125\. and adding more 10400\. will result in 102525\. which is greater than 100000\. 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() 4/1/2024 4:17:51 AM: OB_UPLOAD_PATH not found in Reserve Words System.Exception: OB_UPLOAD_PATH not found in Reserve Words at ZealERP.ZealFramework.Utils.ZealCacheHelper.GetReserveWord(String name) at ZealERP.ZealTakaful.Controllers.NewSecurity.UserController.<>c__DisplayClass19_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetFile(FileDownload FileLogic) 4/1/2024 4:18:04 AM: select INDEX_CODE,INDEX_NAME from INDEX_SETUP_T order by INDEX_NAME 4/1/2024 4:18:04 AM: ORA-00942: table or view does not exist Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist 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) 4/1/2024 4:18:04 AM: ORA-00942: table or view does not exist Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist 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.ZealFramework.Services.DBService.GetData(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.PrepareAndGetData(String tn, String qei, String columns, String datefields) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass2_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 4/1/2024 4:18:12 AM: select distinct STandARD_TYPE from FORMULA_SETUP fs where STandARD_TYPE not in (select STYPE from USERSTandARDMAP where upper(USERID) = upper('global.tips')) 4/1/2024 4:18:12 AM: ORA-00942: table or view does not exist Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist 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) 4/1/2024 4:18:12 AM: ORA-00942: table or view does not exist Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist 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.ZealFramework.Services.DBService.GetData(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.PrepareAndGetData(String tn, String qei, String columns, String datefields) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass2_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 4/1/2024 4:18:12 AM: select a.INDEX_CODE,b.INDEX_NAME,a.ACTIVE,a.USER_NAME from USER_INDEX_MAPPING a, INDEX_SETUP_T b where a.INDEX_CODE = b.INDEX_CODE and upper(USER_NAME) = upper('global.tips') order by a.INDEX_CODE 4/1/2024 4:18:12 AM: ORA-00942: table or view does not exist Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist 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) 4/1/2024 4:18:12 AM: ORA-00942: table or view does not exist Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist 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.ZealFramework.Services.DBService.GetData(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.PrepareAndGetData(String tn, String qei, String columns, String datefields) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass3_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 4/1/2024 4:18:12 AM: select a.COUNTRY_CODE,c.COUNTRY_DESC,a.USER_NAME, a.REPORTING_STRUCTURE_CODE, a.USER_NAME, a.ACTIVE, a.USER_TYPE, b.STRUCTURE_NAME from USER_REPORTING_STRUCTURE_T a, REPORTING_STRUCTURE_MASTER b, COUNTRY c where a.REPORTING_STRUCTURE_CODE = b.STRUCTURE_CODE and a.COUNTRY_CODE = b.COUNTRY_CODE and b.COUNTRY_CODE = c.COUNTRY_CODE and upper(USER_NAME) = upper('global.tips') order by c.COUNTRY_DESC 4/1/2024 4:18:12 AM: ORA-00942: table or view does not exist Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist 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) 4/1/2024 4:18:12 AM: ORA-00942: table or view does not exist Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist 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.ZealFramework.Services.DBService.GetData(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.PrepareAndGetData(String tn, String qei, String columns, String datefields) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass3_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 4/1/2024 4:18:12 AM: select STRUCTURE_CODE,STRUCTURE_NAME from REPORTING_STRUCTURE_MASTER where COUNTRY_CODE = :COUNTRY_CODE order by structure_name params: COUNTRY_CODE= 4/1/2024 4:18:12 AM: ORA-00942: table or view does not exist Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist 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) 4/1/2024 4:18:12 AM: ORA-00942: table or view does not exist Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist 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.ZealFramework.Services.DBService.GetData(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.PrepareAndGetData(String tn, String qei, String columns, String datefields) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass2_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 4/1/2024 4:18:12 AM: select USER_TYPE,USERID,STYPE from USERSTANDARDMAP where upper(USERID) = upper('global.tips') order by USERID 4/1/2024 4:18:12 AM: ORA-00942: table or view does not exist Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist 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) 4/1/2024 4:18:12 AM: ORA-00942: table or view does not exist Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist 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.ZealFramework.Services.DBService.GetData(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.GetDataSecure(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.PrepareAndGetDataForDBControls(String tn, String qei, String columns, String datefields, String container_id) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass5_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 4/1/2024 4:18:12 AM: select a.USERID, to_char(ATTENDANCE_DATE,'dd/mm/yyyy hh24:mi:ss') ATTENDANCE_DATE, PRESENT_TAG, REASON_FOR_LEAVE, to_char(ATTENDANCE_DATE,'dd')||to_char(ATTENDANCE_DATE,'mm')||to_char(ATTENDANCE_DATE,'yyyy') SORT_ID from USER_ATTENDANCE_T a, SM_USERS_T b where b.USERNAME = 'global.tips' and a.USERID = b.USERID order by ATTENDANCE_DATE desc 4/1/2024 4:18:12 AM: ORA-00942: table or view does not exist Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist 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) 4/1/2024 4:18:12 AM: ORA-00942: table or view does not exist Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist 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.ZealFramework.Services.DBService.GetData(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.PrepareAndGetData(String tn, String qei, String columns, String datefields) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass2_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 4/1/2024 4:21:55 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.ProvisionalReportILAS.ProvisionalReport.Page_Load(Object sender, EventArgs e) 4/1/2024 4:22:45 AM: select INDEX_CODE,INDEX_NAME from INDEX_SETUP_T order by INDEX_NAME 4/1/2024 4:22:45 AM: ORA-00942: table or view does not exist Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist 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) 4/1/2024 4:22:45 AM: ORA-00942: table or view does not exist Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist 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.ZealFramework.Services.DBService.GetData(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.PrepareAndGetData(String tn, String qei, String columns, String datefields) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass2_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 4/1/2024 4:22:49 AM: select distinct STandARD_TYPE from FORMULA_SETUP fs where STandARD_TYPE not in (select STYPE from USERSTandARDMAP where upper(USERID) = upper('global.tips')) 4/1/2024 4:22:49 AM: ORA-00942: table or view does not exist Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist 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) 4/1/2024 4:22:49 AM: ORA-00942: table or view does not exist Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist 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.ZealFramework.Services.DBService.GetData(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.PrepareAndGetData(String tn, String qei, String columns, String datefields) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass2_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 4/1/2024 4:22:49 AM: select a.INDEX_CODE,b.INDEX_NAME,a.ACTIVE,a.USER_NAME from USER_INDEX_MAPPING a, INDEX_SETUP_T b where a.INDEX_CODE = b.INDEX_CODE and upper(USER_NAME) = upper('global.tips') order by a.INDEX_CODE 4/1/2024 4:22:49 AM: ORA-00942: table or view does not exist Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist 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) 4/1/2024 4:22:49 AM: select USER_TYPE,USERID,STYPE from USERSTANDARDMAP where upper(USERID) = upper('global.tips') order by USERID 4/1/2024 4:22:49 AM: ORA-00942: table or view does not exist Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist 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) 4/1/2024 4:22:49 AM: ORA-00942: table or view does not exist Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist 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.ZealFramework.Services.DBService.GetData(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.PrepareAndGetData(String tn, String qei, String columns, String datefields) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass3_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 4/1/2024 4:22:49 AM: select a.COUNTRY_CODE,c.COUNTRY_DESC,a.USER_NAME, a.REPORTING_STRUCTURE_CODE, a.USER_NAME, a.ACTIVE, a.USER_TYPE, b.STRUCTURE_NAME from USER_REPORTING_STRUCTURE_T a, REPORTING_STRUCTURE_MASTER b, COUNTRY c where a.REPORTING_STRUCTURE_CODE = b.STRUCTURE_CODE and a.COUNTRY_CODE = b.COUNTRY_CODE and b.COUNTRY_CODE = c.COUNTRY_CODE and upper(USER_NAME) = upper('global.tips') order by c.COUNTRY_DESC 4/1/2024 4:22:49 AM: ORA-00942: table or view does not exist Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist 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) 4/1/2024 4:22:49 AM: ORA-00942: table or view does not exist Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist 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.ZealFramework.Services.DBService.GetData(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.PrepareAndGetData(String tn, String qei, String columns, String datefields) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass3_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 4/1/2024 4:22:49 AM: ORA-00942: table or view does not exist Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist 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.ZealFramework.Services.DBService.GetData(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.GetDataSecure(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.PrepareAndGetDataForDBControls(String tn, String qei, String columns, String datefields, String container_id) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass5_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 4/1/2024 4:22:49 AM: select STRUCTURE_CODE,STRUCTURE_NAME from REPORTING_STRUCTURE_MASTER where COUNTRY_CODE = :COUNTRY_CODE order by structure_name params: COUNTRY_CODE= 4/1/2024 4:22:49 AM: ORA-00942: table or view does not exist Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist 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) 4/1/2024 4:22:49 AM: ORA-00942: table or view does not exist Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist 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.ZealFramework.Services.DBService.GetData(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.PrepareAndGetData(String tn, String qei, String columns, String datefields) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass2_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 4/1/2024 4:22:49 AM: select a.USERID, to_char(ATTENDANCE_DATE,'dd/mm/yyyy hh24:mi:ss') ATTENDANCE_DATE, PRESENT_TAG, REASON_FOR_LEAVE, to_char(ATTENDANCE_DATE,'dd')||to_char(ATTENDANCE_DATE,'mm')||to_char(ATTENDANCE_DATE,'yyyy') SORT_ID from USER_ATTENDANCE_T a, SM_USERS_T b where b.USERNAME = 'global.tips' and a.USERID = b.USERID order by ATTENDANCE_DATE desc 4/1/2024 4:22:49 AM: ORA-00942: table or view does not exist Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist 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) 4/1/2024 4:22:49 AM: ORA-00942: table or view does not exist Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist 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.ZealFramework.Services.DBService.GetData(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.PrepareAndGetData(String tn, String qei, String columns, String datefields) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass2_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 4/1/2024 10:51:03 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()