4 Replies Latest reply: Oct 8, 2013 1:56 AM by 1a340e4b-3951-491c-ac00-f8bfcc74ab93 RSS

    ODI Interface is getting hang everytime executed on the same step




      One of the ODI Interface is getting hang every time when am executing and that too for large volume of data, for small data it is working fine. The LKM, IKM and CKM am using is LKM SQL to SQL, IKM SQL Increamental Update with Truncate True, CKM SQL. The Source and Target is on same database Oracle. The step on which interface it is hanging is Insert PK errors in which it is scanning I$ table in the database and taking so much time and not getting completed in even 12 hours.

      Tried bouncing database and executed same query directly on database also but same result.


      Thanks in Advance...