Unable To Access Business Modeler Via Collaborator Workbench Connection To Database Failed Error (Doc ID 989722.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 7.2 to 7.2 [Release 7.2]
Information in this document applies to any platform.
***Checked for relevance on 03-Jul-2014***


Symptoms

On : 7.2.0 version, Technical

When attempting to access Business Modeler from Collaborator Workbench
the following error occurs.

ERROR
-----------------------
Can't connect to database ORA-12154: TNS: could not resolve the connect identifier specified


The following error occurs in the Modeler.log file
ERROR
-----------------------
App name : Management Tools
Process name : Connection to database has failed.
Error description: Tns Configuration is corrupted or missing for the following connection parameters:
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to Demantra Collaborator Workbench
2. Nav: Planning Applications -> Business Modeler
(same issue for the other planning applications)
3. Followed the solution described in Note 461778.1 but the same error still appears.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot access Business Modeler from Collaborator Workbench.

Cause

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