Demantra Worksheet Never Returns Data If Temp Table Creation Takes Longer Than 5-10 Mins (Doc ID 1271729.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 12-Jun-2013***

Goal


=== ODM Question ===
How to resolve the issue where worksheet never returns data if the temporary table creation takes longer than 5-10 minutes?
Worksheets show "Loading Data" while the temp table is created, index added, analyzed, and the initial retrieval of the first combination takes place. However, if the creation of the temp table takes more than about 5-10 minutes the "Loading Data" message remains on the screen even after the temp table is created. Queries that run under 5 minutes work correctly and every query over 10 minutes fails to proceed.
If the worksheet is closed and reopened and rerun (the data seems to be cached in the Oracle DB and the temp table creation comes down to around 2-4 minute),  the worksheet would then be able to return the data correctly.


This happens on client machines where Symantec is installed.


Solution

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