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

Products

• DSERIES- SERVER
• CA Workload Automation DE - System Agent (dSeries)

Issue/Introduction

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

Release: DSWAHA01300-12-Workload Automation DE-High Availability
Component:

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.