Essbase MaxL Error “Warning(1040156) – SSL initialization failed with error code [1040132]”


The following warning message is displayed when running MaxL statement:

Warning(1040132) – Opening a wallet(D:\Oracle\Middleware\user_projects\eem2\EssbaseServer\essbaseserver\bin\wallet) failed(28759)
Warning(1040156) – SSL initialization failed with error code [1040132]

 

Reason being – 

One of the following Environment Variables is not set:

  • ARBORPATH
  • ESSBASEPATH
  • ORACLE_INSTANCE
  • ORACLE_HOME

Make sure the following Paths are set in the Environment Variables. Example:

ORACLE_HOME=C:\Oracle\Middleware\ohs
ORACLE_INSTANCE=C:\Oracle\Middleware\user_projects\epmsystem1
ARBORPATH=C:\Oracle/Middleware/user_projects/epmsystem1/EssbaseServer/essbaseserver1
ESSBASEPATH=C:\Oracle/Middleware/EPMSystem11R1/products/Essbase/EssbaseServer

Where “C” is your installation Path.

In order to remove the warning message copy environment variables from $ORACLE_INSTANCE\config\Opmn\opmn\wallet directory along with the cwallet.sso to the ARBORPATH\bin directory.

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s