Skip to Main Content

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!

[ODI] ODI query perfomance issue in ODI but nor in SQL Dev

4238063Apr 23 2020 — edited Apr 29 2020

Hello,

I've been using ODI for a few months and I'm facing issues with the perfomance.

Indeed, when I go to OPERATOR and try to select a session, whenever it's running or not, I have an error message saying : ODI-26066 : An unexepcted erro has occured

But right after I clicked OK, the session opens.

When I try to stop the session, I can't, even by changing the status.

The other issue, more important that I'm facin, is that I made a mapping, I tried to run eat in ODI. The session is taking hours and doenst even return any result.

But when I try to run the ODI query in SQL Dev, it's takes less than 1 minute and I do get an answer.

this issue started when I started using IKM : IKM Oracle Control Append

Can you please help me with this,

Regards,

R

Comments
Post Details