Forum Stats

  • 3,723,865 Users
  • 2,244,636 Discussions
  • 7,850,739 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

XML tables schema/tables are throwing error - no changes made

User_LG45K
User_LG45K Member Posts: 1 Green Ribbon

I have a package with procedures to truncate and load XML schema from different XML files, and then use the mapping to load from XML connection, which was working absolutely fine.

But the procedure throws error as  "ODI-40706: This schema doesn't exist", mapping throws error as "user lacks privilege or object not found".

Oracle support says its because the ODI memory engine which stores the XML data is not added to the memory engine which gets removed by studio restart.

can someone help me with this? How to i ensure XML data gets added to memory engine?

Sign In or Register to comment.