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

Last updated on MARCH 08, 2017

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***


Symptoms


On : 7.3.0 version, Worksheet

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

ERROR
-----------------------
collaborator.log file shows:
'00:11:39,671 CDT [DataRunner_1] ERROR query.run: 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 "DEMMSD "."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 => 'DEMMSD ', tabname => 'T_COMB_13304_387_455443965', CASCADE => TRUE); END;') ORA-06512: at "DEMMSD.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


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

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