My Oracle Support Banner

Worksheet Retuns No Data - Error in PROCEDURE ANALYZE_TABLE_TMP (Doc ID 1129885.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Oracle Demantra Demand Management - Version 7.3.0 and later
Information in this document applies to any platform.
***Checked for relevance on 08-Aug-2013***


On : 7.3.0 version, Worksheet

When attempting to run a worksheet sometime returns no data, sometimes return data,
the following error occurs.

collaborator.log file shows:
'00:11:39,671 CDT [DataRunner_1] ERROR ODPM-70016: Error loading query from Application Server:com.demantra.applicationServer.appServerExceptions.FailedToExcuteBatch: java.sql.BatchUpdateException: error occurred during batching: ORA-20002: -20000 ORA-20000: Unable to analyze TABLE "DEMANTRA SCHEMA> "."T_COMB_13304_387_455443965", insufficient privileges or does not exist Error in PROCEDURE ANALYZE_TABLE_TMP line 41 dynamic_ddl( 'BEGIN SYS.DBMS_STATS.GATHER_TABLE_STATS (ownname => '<DEMANTRA SCHEMA> ', tabname => 'T_COMB_13304_387_455443965', CASCADE => TRUE); END;') ORA-06512: at "<DEMANTRA SCHEMA>.SEND_ERR_MESSAGE", '

java console output is returning sometime 0 combinations , sometime return a number of combination for the same worksheet just by rerunning it

The issue can be reproduced at will with the following steps:
1. run the worksheet
2. rerun the worksheet




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.