This content has been marked as final. Show 8 replies
If you have used customized KM in your 10g interfaces, they will work on 11g BUT they won't support the new features of 11g (like "union/intersect/minus" support).
I recommand you to :
* backup your 10g work repository
* convert your 10g repository to 11g repository thanks to UA tool
* modify the standard 11g KM to "re-create" your customed KM
I agree, but I have a colleague who has been working on ODI migration from 10G to 11G using UA tool..but he is facing an issue during the upgrade as the KM's in the 10G repository has been customised. He is not able to perform the upgrade and hence I have a strong feeling that I might run into the same issue, which I want to avoid.
And I believe that UA tool is not able to recognize the customized KM's in 10G and hence it is failing.. Any thoughts as to why the customized KM's are not getting upgraded properly? And any workaround; apart from any manual work.
there is no real "upgrade" of KM.1 person found this helpful
actually, the "native ODI 10g IKM" are replaced by the "new native ODI 11g" IKM.
Because the code inside the KM steps is different.
The customised 10g KM won't be "converted" (I mean : the new features won't be added inside the KM steps) but you will be able to use them anyway in your 11g environment (without the new features).
My colleague was able to perform an upgrade successfully but now the issue is when he tries to execute a package, some of the procedure's doesn't execute. And the sad part is - ODI shows that the execution is successful but it never executes them.
We had a call with Oracle and the support agent is going to file a bug, and will be asking the developers to have a look.. Let's hope we get positive results from them..
And the issue occurs only with the migrated packages..If we recreate the same packages manually after the upgrade is done and then try to execute them...all the procedure's execute successfully.
We are using MS SQL queries. Any help will be highly appreciated.
very strange !!
they finish successful but do nothing.. and if you recreate them from scratch, it works.. ?
I have absolutely no idea why this occurs.. :-/
Yes, the status shows as successful, but in reality it does not execute...and on the other hand when we create a copy of the same and then create procedures manually..it executes them successfully and we get the result as expected..!!
Any thing that you might suggest we should try or maybe check?
if you just open the ODI procedure, then click on OK to save it (without modification), and try again ?
if you cannot save, just modify the description by adding some word or space.
Oracle SR is created and we are following up with Oracle on it.