4 Replies Latest reply: Sep 23, 2013 4:03 PM by $anty RSS

    Issues with procedures on ODI 11g

      Hello Gurus,

      We have an ODI environment, where we have migrated from ODI 10g to ODI 11g ( using Upgrade Assistant.

      Issue is that, the Procedures in our migrated packages show executed in Operator (by Green tickmark), but they are actually NOT executing the code. Means we are not able to see Code for the procedure steps, when that step is opened from operator. It does not even show Rows updated or other statistics. It shows 0 for all.

      We do not see any error in ODI studio for those steps. Thats why unable to figure out whats happening.

      Note: There is no issue with the SQL code. Its been tested on SQL Server.

      What could be cause behind this ?
      Please help.