Forum Stats

  • 3,757,055 Users
  • 2,251,192 Discussions
  • 7,869,716 Comments

Discussions

ODI 12c XML Closed Connection Error

User_V8FRK
User_V8FRK Member Posts: 9 Green Ribbon

Hi,

I am using ODI 12.2.1c and as part of my project I need to generate complex XML file from database. it works fine without any issue but after running few weeks it continuously gives closed connection error until we restart ODI application server. After restarting I have to remove all temp tables created from XML DTD in my define database and perform test connection again to get those tables back and then it all work again.  Looking for a permanent solution.

ODI-1228: Task Create staging (C$) table-LKM SQL to SQL (Built-In)- fails on the target connection DS_XXX_YYYY.

Caused By: java.sql.SQLRecoverableException: Closed Connection

Any help will be greatly appreciated.

Thanks

Adil

Tagged:

Answers