Hyperion Essbase (MOSC)

MOSC Banner

ODI interface cannot load data into HPCM Calculation Essbase Cube

edited Dec 8, 2016 10:11AM in Hyperion Essbase (MOSC) 2 comments

Every time i attempt to load data using Sunopsis Engine to load data into Essbase i encounter the following message:

ODI-1226: Step LoadHPCMFromStaging fails after 1 attempt(s).

ODI-1240: Flow LoadHPCMFromStaging fails while performing a Loading operation. This flow loads target table HPCMAP_HPCMAPCData.

ODI-1228: Task SrcSet0 (Loading) fails on the target SUNOPSIS_ENGINE connection SUNOPSIS_MEMORY_ENGINE.

Caused By: java.sql.SQLException: statement is not in batch mode

at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

at org.hsqldb.jdbc.Util.sqlExceptionSQL(Unknown Source)

at org.hsqldb.jdbc.JDBCPreparedStatement.executeBatch(Unknown Source)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center