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

Last updated on SEPTEMBER 17, 2015

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:
C:\ORACLE\demantra\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=VCPD 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 : C:\ORACLE\demantra\Demand Planner\Analytical Engines\bin
EngDatabase::EngDatabase ==> Initialization Started ...
EngDatabase::EngDatabase ==> Database Descriptor :
O;VCPB
EngDatabase::EngDatabase ==> Database Connection String :
O;VCPB
EngDatabase::EngDatabase ==> Schema Name :
DEM
EngDatabase::EngDatabase ==> Oracle Connection Strings :
Provider=MSDAORA;Data Source=VCPB
Provider=OraOLEDB.Oracle.1;Data Source=VCPB
EngDatabase::EngDatabase ==> Initialization Succeeded ...
EngineManager::EngineManager ==> Starting ...

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