3 Replies Latest reply: Jul 16, 2013 3:51 AM by DecaXD RSS

    Sunopsis Memory Engine Issue




      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 file was loaded to the staging area in the interface, if it had more than 210 records it would generate this error. I'm struggling to work out why this should be the case as I'm sure this isn't a restriction I have ever encountered before. Any ideas would be appreciated!!