My Oracle Support Banner

Demantra Engine Is Not Completing In 12.2.11 Version - Sales_data Shows All Indexes Are In "UNUSABLE" State (Doc ID 2912865.1)

Last updated on JUNE 21, 2023

Applies to:

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

Symptoms

On : 12.2.11 version, Engine

ACTUAL BEHAVIOR
---------------

Upgraded recently Demantra from 7.3.1.5 older version to 12.2.11 version, when executing Demantra batch engine, engine is running
 so long like more than 48 hours and not completing.

Engine is running with elapsed time and not completing.

EXPECTED BEHAVIOR
-----------------------
Engine has to complete in all instance in expected normal time as before upgrade

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. upgrade from 7.3.1.4 to 12.2.11
2. Run Proport
3. Run Engine
4. Performance issue , Engine is running for more than 48 hours


Customer has Performance Issue.

Changes

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.