1 Reply Latest reply on Jul 9, 2013 9:11 AM by Fr4nk

    Unable to start Analytical Engine on Windows Server 2008 64bit


      We have recently installed Demantra 12.2.1 on a Windows Server 2008 R2 64 bit machine (DB is running on another Linux machine). I was already aware of the 32bit Oracle client requirement from previous releases so I've installed Oracle Client 11g 32bit (as clearly requested in the installation documentation), then I've configured tnsnames.ora to point to my DB instance and I can successfully connect to the database from the Windows machine. Overall the installation process went fine with no errors.


      When I try to start the Analytical Engine I'm getting the following error:


      D:\demantra\DemantraSpectrum\Demand Planner\Analytical Engines>.\bin\EngineManager.exe 1 1

      16:53:14:925 [EngLogger.cpp,220] Logger General Level: message, UserLevel: message

      16:53:14:940 Working with Oracle RDBMS

      16:53:14:940 Database connection string: Provider=MSDAORA;Data Source=STG User:DEMANTRA

      16:53:15:096 ERROR ---------------------------------------------------------------

      16:53:15:206 ERROR Database Error [db_win.cpp,137]

      16:53:15:315 ERROR   - Source: ADODB.Connection

      16:53:15:424 ERROR   - Description: Provider cannot be found. It may not be properly installed.

      16:53:15:533 ERROR   - Message: Unknown error 0x800A0E7A

      16:53:15:642 ERROR   - Error Number: 0x800a0e7a - Undefined Error.

      16:53:15:752 ERROR ---------------------------------------------------------------


      D:\demantra\DemantraSpectrum\Demand Planner\Analytical Engines>Pause

      Press any key to continue . . .


      Which is the typical error you would get when using a 64bit Oracle Client instead of the required 32bit client. The same issue is documented in many MOS notes but they all advice to install the 32bit client, which I've already done...


      Help on this issue will be much appreciated!