Analytics Software

HI,

I am trying to load member data from an Oracle view into an Essbase Dimension. The reverse engineering worked fine and I created an interface to execute the load. It errored out at stage 6 doing these tasks:

from com.hyperion.odi.common import ODIConstants
from com.hyperion.odi.connection import HypAppConnectionFactory
from java.lang import Class
from java.lang import Boolean
from java.sql import *
from java.util import HashMap
#
# Get the select statement on the staging area:
#
sql= """select C2_ORG_PARENT_CODE "ParentName",C3_ORG_CODE "MemberName",SUBSTR(C1_DESCR, 1, 80) "Alias" from DR_STAGING.C$_0ORG where (1=1) """

srcCx = odiRef.getJDBCConnection("SRC")

stmt = srcCx.createStatement()

srcFetchSize=30

stmt.setFetchSize(srcFetchSize)

rs = stmt.executeQuery(sql)

#load the data
stats = pWriter.loadData(rs)

#close the database result set, connection
rs.close()
stmt.close()

I even tried upgraded to the latest ODI 10.1.3.5.6 and still did not resolve my issues. Any help would be great. Error log contains this:


2010-01-29 15:35:00,672 INFO [DwgCmdExecutionThread:null:5]: ODI Hyperion Essbase Adapter Version 9.3.1.1
2010-01-29 15:35:00,672 INFO [DwgCmdExecutionThread:null:5]: Connecting to Essbase application [tcdr-bl] on [hyp-asw]:[1423] using username [admin].
2010-01-29 15:35:01,156 INFO [DwgCmdExecutionThread:null:5]: Successfully connected to the Essbase application.
2010-01-29 15:35:01,156 INFO [DwgCmdExecutionThread:null:5]: Essbase Load IKM option RULES_FILE = C:\oracle\odi10g\oracledi\bin\hisdld.rul
2010-01-29 15:35:01,156 INFO [DwgCmdExecutionThread:null:5]: Essbase Load IKM option RULE_SEPARATOR = ,
2010-01-29 15:35:01,156 INFO [DwgCmdExecutionThread:null:5]: Essbase Load IKM option PRE_LOAD_MAXL_SCRIPT =
2010-01-29 15:35:01,156 INFO [DwgCmdExecutionThread:null:5]: Essbase Load IKM option POST_LOAD_MAXL_SCRIPT =
2010-01-29 15:35:01,156 INFO [DwgCmdExecutionThread:null:5]: Essbase Load IKM option ABORT_ON_PRE_MAXL_ERROR = true
2010-01-29 15:35:01,156 INFO [DwgCmdExecutionThread:null:5]: Essbase Load IKM option RESTRUCTURE_DATABASE = KEEP_ALL_DATA
2010-01-29 15:35:01,219 INFO [DwgCmdExecutionThread:null:5]: Begining the load process.
2010-01-29 15:35:01,297 ERROR [DwgCmdExecutionThread:null:5]: Error occured during load process com.essbase.api.base.EssException: Cannot build dimension. Essbase Error(1007083): Dimension build failed. Error code [1090022]. Check the server log file and the dimension build error file for possible additional info..
2010-01-29 15:35:01,297 INFO [DwgCmdExecutionThread:null:5]: Load process completed.
2010-01-29 15:35:01,297 INFO [DwgCmdExecutionThread:null:5]: Logging out and disconnecting from the essbase application.


Thanks,
Andrew

Edited by: andrewly on Jan 29, 2010 2:52 PM