OFSAAI Create Cube Errors When Attempting to Run Create Cube for PFT BI (Doc ID 1333825.1)

Last updated on JUNE 28, 2011

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version: 7.2.7 and later   [Release: 7 and later ]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.2
PFT BI
Essbase 1030723 Error

Symptoms

On Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) 7.2.7 when attempting to create an Essbase cube for Oracle Financial Services Profitability Analytics (PFTBI) 5.1, the following error occurs:

ERROR
2011-05-13 | 14:11:02 | olapengine | INFO | | | Server IPAddress dlofsatestappl.hq.icbv.com
2011-05-13 | 14:11:02 | olapengine | INFO | | | Admin User Name admin
2011-05-13 | 14:11:02 | olapengine | INFO | | | Config Path /u01/ofsa72/ftpshare/OFSATEST/scripts/cube
2011-05-13 | 14:11:02 | olapengine | INFO | | | DataFile Path /u01/ofsa72/ftpshare/OFSATEST/scripts/cube/20100531/PFTLDGMA
2011-05-13 | 14:11:02 | olapengine | INFO | | | BackUp Path /u01/ofsa72/ftpshare/OFSATEST/scripts/cube/20100531/PFTLDGMA
2011-05-13 | 14:11:02 | olapengine | INFO | | | Trying to login...
2011-05-13 | 14:11:02 | olapengine | INFO | | | API Version -- 39000b1130
2011-05-13 | 14:11:02 | olapengine | SEVERE | | | Error : API Initialization failed : 1008156
2011-05-13 | 14:11:02 | olapengine | INFO | | | ClsUEssServer - Login
2011-05-13 | 14:11:02 | olapengine | INFO | | | Instance 0
2011-05-13 | 14:11:02 | olapengine | INFO | | | Server - dlofsatestappl.hq.icbv.com
2011-05-13 | 14:11:02 | olapengine | INFO | | | UserName - admin
2011-05-13 | 14:11:02 | olapengine | INFO | | | Context - 0
2011-05-13 | 14:11:02 | olapengine | SEVERE | | | Error : Login Unsuccessful : 1030000
2011-05-13 | 14:11:02 | olapengine | SEVERE | | | Error : Could not login
2011-05-13 | 14:11:02 | olapengine | INFO | | | Destroying server.....
2011-05-13 | 14:11:02 | olapengine | SEVERE | | | Error while execution : Execution Stopped

STEPS
The issue can be reproduced at will with the following steps:
1. Create a BATCH ID with 2 tasks. 1. AGGREGATE DATA, 2. CREATE CUBE
2. See the attached for the task parameters
3. Execute the BATCH ID
4. The task CREATE CUBE is failed.

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