OWB 11.2 Code Template Mapping Reports ORA-20000: Unable to analyze TABLE - insufficient privileges or does not exist (Doc ID 1323730.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

The execution of an OWB 11.2 Code Template Mapping executes well but the job finishes with status "OK with warning" and reports the following in the log:

[System.out ()] 10:29:01 AM: <DEBUG_ALL> RT-INFO:Message notification:java.sql.SQLException: ORA-20000: Unable to analyze TABLE "DWP"."", insufficient privileges or does not exist
ORA-06512: in "SYS.DBMS_STATS", li­ne 23143
ORA-06512: in "SYS.DBMS_STATS", line 23205
ORA-06512: in line 2 [10:29:01.676:Thread-11]
[System.out ()] 10:29:01 AM: <DEBUG_ALL> RT-INFO:Task notification null Finished FAILURE [10:29:01.894:Thread-11]

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms