Unable To Login To Business Modeller After Creating New Instance (Doc ID 864564.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Predictive Trade Planning - Version 6.1 and later
Information in this document applies to any platform.
This problem can occur on any platform.

***Checked for relevance on 29-Jan-2014***

Symptoms

On 7.2.0.1 in Production:
When the customer uses the installer to create an instance they do not have any issues However,
when they create an instance by way of imaging(copy the files from one instance to another machine..cloning), they get the following error message when trying to access the Business Modeller (modeller.exe)


SQLSTATE=42000 Microsoft OLE DB Provider for SQL Server
Could not find stored procedure 'pre_logon'.

Once they click "ok" here is the next error message that comes up:

 application_cache_error Time
Scale

Also when they try to point the encryption.exe file to a working instance, the business modeller
works. When, from a working instance, they point the the encryption.exe to this database, it does
not work.


STEPS
The issue can be reproduced at will with the following steps:
1) Backup Demantra on a fully functioning test system
2) Upload Demantra schema to new instance
3) Try to open Business Modeler




.

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