WSWUI0331E error when running reports on an Oracle database

You try to run a report on an engine connection where an Oracle database has been referenced. The report task fails and the following error is displayed:

WSWUI0331E SQL validate failure.The database internal message is:ORA-00942: 
           table or view does not exist

If you try to run an SQL query statement in the Oracle database on the same table or view using the userid specified for the database connection in the engine connection properties, the query runs successfully.

On Oracle databases only, you must run these steps, as Oracle database administrator, to allow the database user specified in the engine connection properties to run reports from the Dynamic Workload Console:

1. Assign to the database user the "CREATE TABLE" Oracle System privilege.
2. Run the following script:

   On Windows™

   TWA_home\TWS\dbtools\oracle\script\dbgrant.bat

   On UNIX™:

   TWA_home/dbtools/oracle/script/dbgrant.sh