Log File Initialized... 4/8/2024 2:13:54 AM 4/8/2024 2:13:54 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() 4/8/2024 2:34:17 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/8/2024 2:34:35 AM: select INDEX_CODE,INDEX_NAME from INDEX_SETUP_T order by INDEX_NAME 4/8/2024 2:34:35 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/8/2024 2:34:35 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/8/2024 2:34:41 AM: select distinct STandARD_TYPE from FORMULA_SETUP fs where STandARD_TYPE not in (select STYPE from USERSTandARDMAP where upper(USERID) = upper('bukharitrvl.services900')) 4/8/2024 2:34:41 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/8/2024 2:34:41 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/8/2024 2:34:41 AM: select USER_TYPE,USERID,STYPE from USERSTANDARDMAP where upper(USERID) = upper('bukharitrvl.services900') order by USERID 4/8/2024 2:34:41 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/8/2024 2:34:41 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/8/2024 2:34:41 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('bukharitrvl.services900') order by a.INDEX_CODE 4/8/2024 2:34:41 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/8/2024 2:34:41 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/8/2024 2:34:42 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('bukharitrvl.services900') order by c.COUNTRY_DESC 4/8/2024 2:34:42 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/8/2024 2:34:42 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/8/2024 2:34:42 AM: select STRUCTURE_CODE,STRUCTURE_NAME from REPORTING_STRUCTURE_MASTER where COUNTRY_CODE = :COUNTRY_CODE order by structure_name params: COUNTRY_CODE= 4/8/2024 2:34:42 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/8/2024 2:34:42 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/8/2024 2:34:42 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 = 'bukharitrvl.services900' and a.USERID = b.USERID order by ATTENDANCE_DATE desc 4/8/2024 2:34:42 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/8/2024 2:34:42 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/8/2024 2:39:29 AM: select INDEX_CODE,INDEX_NAME from INDEX_SETUP_T order by INDEX_NAME 4/8/2024 2:39:29 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/8/2024 2:39:29 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/8/2024 2:42:57 AM: select STRUCTURE_CODE,STRUCTURE_NAME from REPORTING_STRUCTURE_MASTER where COUNTRY_CODE = :COUNTRY_CODE order by structure_name params: COUNTRY_CODE= 4/8/2024 2:42:57 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/8/2024 2:42:57 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/8/2024 2:42:57 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 = '5PLR.ADMIN' and a.USERID = b.USERID order by ATTENDANCE_DATE desc 4/8/2024 2:42:57 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/8/2024 2:42:57 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/8/2024 2:42:57 AM: select distinct STandARD_TYPE from FORMULA_SETUP fs where STandARD_TYPE not in (select STYPE from USERSTandARDMAP where upper(USERID) = upper('5PLR.ADMIN')) 4/8/2024 2:42:57 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/8/2024 2:42:57 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/8/2024 2:42:57 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('5PLR.ADMIN') order by c.COUNTRY_DESC 4/8/2024 2:42:57 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/8/2024 2:42:57 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/8/2024 2:42:57 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('5PLR.ADMIN') order by a.INDEX_CODE 4/8/2024 2:42:57 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/8/2024 2:42:57 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/8/2024 2:42:57 AM: select USER_TYPE,USERID,STYPE from USERSTANDARDMAP where upper(USERID) = upper('5PLR.ADMIN') order by USERID 4/8/2024 2:42:57 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/8/2024 2:42:57 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/8/2024 2:43:16 AM: select distinct STandARD_TYPE from FORMULA_SETUP fs where STandARD_TYPE not in (select STYPE from USERSTandARDMAP where upper(USERID) = upper('SIC.ADMIN')) 4/8/2024 2:43:16 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/8/2024 2:43:16 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/8/2024 2:43:16 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('SIC.ADMIN') order by a.INDEX_CODE 4/8/2024 2:43:16 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/8/2024 2:43:16 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/8/2024 2:43:16 AM: select STRUCTURE_CODE,STRUCTURE_NAME from REPORTING_STRUCTURE_MASTER where COUNTRY_CODE = :COUNTRY_CODE order by structure_name params: COUNTRY_CODE= 4/8/2024 2:43:16 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/8/2024 2:43:16 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/8/2024 2:43:16 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('SIC.ADMIN') order by c.COUNTRY_DESC 4/8/2024 2:43:16 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/8/2024 2:43:16 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/8/2024 2:43:16 AM: select USER_TYPE,USERID,STYPE from USERSTANDARDMAP where upper(USERID) = upper('SIC.ADMIN') order by USERID 4/8/2024 2:43:16 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/8/2024 2:43:16 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/8/2024 2:43:16 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 = 'SIC.ADMIN' and a.USERID = b.USERID order by ATTENDANCE_DATE desc 4/8/2024 2:43:16 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/8/2024 2:43:16 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/8/2024 5:24:05 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.ILBulkReport.BulkORReport.PrepareReport()