- 17.9K All Categories
- 3.3K Industry Applications
- 3.2K Intelligent Advisor
- 59 Insurance
- 534.1K On-Premises Infrastructure
- 137.6K Analytics Software
- 38.5K Application Development Software
- 5.2K Cloud Platform
- 109.1K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.8K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
ODI 12c XML Closed Connection Error
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.