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 40870 error Caused By: java.sql.SQLException: a schema opened on this file with another name

user-kzjzmJun 7 2023 — edited Jun 7 2023

While executing XML TO TABLE mappings, i started getting this error in ODI 12C \

Caused By: java.sql.SQLException: ODI-40870: You already have a schema opened on this file with another name

Possibly because of the changes I did at XML Topology by giving different schema name in jdbc parameter from teh previous one.. And due to that , execution of mapping is failing now.

How can I remove this schema name from ODI or if it is memory engine.

Kindly advise.

Himanshu

Comments
Post Details
Added on Jun 7 2023
2 comments
595 views