SQL Exception for query: TRUNCATE TABLE < > the exception is: ORA-00942: table or view does not exist

Document ID : KB000046923
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem: 

After performing a cold start of DE Server, the server failed to cleanup the active data in the database. The server tracelog reported relational database exceptions like;

Log message, loggerName: relationaldatabase, level: ERROR, threadName: HAC, message: SQL Exception for query: TRUNCATE TABLE ESP_S2O_MAP; the exception is: ORA-00942: table or view does not exist

Environment:  

Any supported platforms

Cause: 

The database user does not have the required privileges on the database tables.

Resolution:

The Database Administrator (DBA) should remove any restrictions on the database user to perform truncate operations on the database tables.