My Oracle Support Banner

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

Last updated on DECEMBER 04, 2019

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***



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

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

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.

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


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

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