Analytical Engine not Connecting after Demantra Upgrade (Doc ID 1384572.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 7.2 and later
Information in this document applies to any platform.
***Checked for relevance on 03-Sep-2013***

Symptoms


On 7.2.0.3:

When attempting to run the Analytical Engine
the following error occurs.

ERROR
-----------------------
File creation date time: Fri Sep 23 15:24:52 2011

15:24:52:496 [EngLogger.cpp,219] Logger General Level: message, UserLevel: message
15:24:52:496 Working with Oracle RDBMS
15:24:52:496 Database connection string: Provider=MSDAORA;Data Source=ebsdev User: MSDEM
15:24:52:558 ERROR ---------------------------------------------------------------
15:24:52:558 ERROR Database Error [db_win.cpp,137]
15:24:52:558 ERROR - Source: ADODB.Connection
15:24:52:558 ERROR - Description: Provider cannot be found. It may not be properly installed.
15:24:52:558 ERROR - Message: Unknown error 0x800A0E7A
15:24:52:558 ERROR - Error Number: 0x800a0e7a - Undefined Error.
15:24:52:558 ERROR ---------------------------------------------------------------


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. NAV: <Demantra_root_install_folder>\Demand Planner\Analytical Engine\bin
2. Log in to the Engine Administrator.
3. NAV: File -> Run Engine
4. Enter DB User and Password credentials and connect to the DB.
5. Run the Engine.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Cannot run the Analytical Engine and thus not able to create and publish a forecast.

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