My Oracle Support Banner

EngineAdministrator.exe From Windows Immediately Errors Upon Launch with Error Message "Provider cannot be found" (Doc ID 2054263.1)

Last updated on FEBRUARY 12, 2019

Applies to:

Oracle Demantra Demand Management - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

Demand Planning executable immediately errors upon launch:
<DIR>\..\..\Demand Planner\Analytical Engines>.\bin\EngineManager.exe 1 1

16:31:29:794 [EngLogger.cpp,220] Logger General Level: message, UserLevel: messa
ge
16:31:29:794 Working with Oracle RDBMS
16:31:29:806 Database connection string: Provider=MSDAORA;Data Source= User:
DEM
16:31:30:724 ERROR -------------------------------------------------------------
--
16:31:30:826 ERROR Database Error [db_win.cpp,135]
16:31:30:927 ERROR - Source: ADODB.Connection
16:31:31:028 ERROR - Description: Provider cannot be found. It may not be prop
erly installed.
16:31:31:129 ERROR - Message: Unknown error 0x800A0E7A
16:31:31:230 ERROR - Error Number: 0x800a0e7a - Undefined Error.
16:31:31:331 ERROR -------------------------------------------------------------

Customer has OLEDB and ODBC installed
Has 32bit Engine
Tried with Oracle client 11.2.0.1 32 bit

Same error :
Right click on the EngineAdministrator.exe from Windows and say run as administrator. The application opens,connect to the database which is successful and then click run engine, same error occurs.

EngineManagerPreRunLog.txt shows:


Current Working Directory is : <DIR>\..\..\Demand Planner\Analytical Engines\bin
EngDatabase::EngDatabase ==> Initialization Started ...
EngDatabase::EngDatabase ==> Database Descriptor :
O;XXX
EngDatabase::EngDatabase ==> Database Connection String :
O;XXX
EngDatabase::EngDatabase ==> Schema Name :
<SCHEMA NAME>
EngDatabase::EngDatabase ==> Oracle Connection Strings :
Provider=MSDAORA;Data Source=XXXX
Provider=OraOLEDB.Oracle.1;Data Source=XXXX
EngDatabase::EngDatabase ==> Initialization Succeeded ...
EngineManager::EngineManager ==> Starting ...

Changes

 

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


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