My Oracle Support Banner

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

Last updated on NOVEMBER 15, 2018

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

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
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.