This discussion is archived
4 Replies Latest reply: Oct 7, 2013 11:56 PM by 1a340e4b-3951-491c-ac00-f8bfcc74ab93 RSS

ODI Interface is getting hang everytime executed on the same step

1a340e4b-3951-491c-ac00-f8bfcc74ab93 Newbie
Currently Being Moderated

Hi,

 

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...

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points