My Oracle Support Banner

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

Last updated on DECEMBER 18, 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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.