We are getting the below error when starting the Demand Planner Server (v 6.0.2.9),
“Wednesday .05:52, October 18, 2023 Job started : Load Data from DB
Assert Failure in GlobalDatabase.cpp:6304”
We have tried the below to make it run,
- Checked the database tablespace free space, connection and disk free space - no issues
- Restarted the Demand Planner hosted server to see if there are any hanging sessions
- Restarted the database and application to make sure no issues
- Reinstalled the Demand Planner Server
- Reinstalled oracle client and DP server
- tried to connect from a different server installing same DP setup
When we give wrong credentials it prompts invalid username/password so we believe the normal process is working fine but during the database connection initialization stage an entry on the database/table level refusing the session to get connected. Please advise if you think you have encountered this issue on your environments.
We think we need to clear some entry on the database level to initialize the connection successful after the authentication. For example on IEE connection sometimes does not get established if we have an entry on the fnd_client_logon_tab likewise we need to know if some entry related to forecast server lies on the database end.
TIA.