Worksheet Retuns No Data - Error in PROCEDURE ANALYZE_TABLE_TMP
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***
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 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
The issue can be reproduced at will with the following steps:
1. run the worksheet
2. rerun the worksheet
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