My Oracle Support Banner

Troubleshooting Chaining Issues (Doc ID 2109499.1)

Last updated on AUGUST 17, 2022

Applies to:

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


 Investigating chaining process and issues.

Troubleshooting Steps

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
Troubleshooting Steps
  1. Introduction
 2. How to start it
 3. Scenarios
 Scenario 1: Copying at Lowest Level (No Similarity)
 Scenario 2: New Product (Location Similarity)
 Scenario 3: Merging Two Locations
 Scenario 4: Two New Products
 Scenario 5: Multiple Sources
 4. No error but wrong or no data is  copied to target series.
 No data is copied to target series
 Chaining operation applies the same aggregate value for all members when the “Same value for all members” box is not checked
 Status of the chaining is "ready in chain queue"
 5. Errors when opening Chaining Management
 1. Can's start the Chaining Management from Collaborator Workbench
 Error "cannot connect to database oracle library OCI.DLL or ORA803.DLL could not be loaded"
 ODPM-40713: Desktop Installer encountered an error while validating values
 2. Can't start the Chaining Management from icon and / or dp.exe from \Demand Planner\DeskTop folder
 Error "Can't connect to database DBMS is not supported in your current installation"
 Error: Items table is defined as 'active' in group_tables. Can't open the chaining management.
 Invalid Username or Password
 6. Errors on chaining execution
 ORA-00972: identifier is too long
 'No population for source'
 "No common population for filtered target and source"

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