Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

statement is not in batch mode

1444576Jun 8 2015 — edited Jun 8 2015

Hi,

I recently started getting an the following error whilst executing an interface which uses the Sunopsi Memory Engine as the staging area -

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

The interface had previously been executing fine for a number of days. After some debugging I narrowed it down to the fact that when the source text file which is exctracted essbase outline was loaded to the staging area (MSSQL table) in the interface, if it had more than 1259 records it would generate this error. But 1259 or less records loads fine

Error Codes

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 6 2015

Added on Jun 8 2015

#business-intelligence-applications, #data-integrator, #system-management-and-integration

7 comments

654 views