Hi All,
We have recently migrated our ODI 12.1.3 Repository from On-Premise to OCI cloud environment . We basically cloned the Repository from on-premise and configured it with new setup on Cloud.
Now while review the mappings i found that one of the mapping which is using LKM SQL to Oracle is failing on Cloud environment after seeing the execution log i found that the LKM steps are executing in wrong sequence. I opened the LKM on cloud and saw the task sequence it looks wrong like below :-
I open the same LKM on -premise and i found the correct sequence like shown below:-
Now i was trying to correct the sequence on Oracle Cloud environment as per the correct one on on-premise but after correcting it and closing it it gets change to wrong sequence again when i open it next time. Why is this happening where does the sequence order of LKM steps saved if it saved in REPO table is that causing the issue ?
I compared the xml files of LKM from both On-premise as well as OCI they are identical. so not sure why it is not allowing me to change the sequence and keeping the change.
Is there something to do with database schema rights ?
Please help me on this.
Thanks
Regards