My Oracle Support Banner

Demantra Worksheet Never Returns Data If Temp Table Creation Takes Longer Than 5-10 Mins (Doc ID 1271729.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Demantra Demand Management - Version 7.3.0 and later
Information in this document applies to any platform.


=== 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.


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.