Discussions
Categories
- 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
Inactive Session in ODI Repository
Hello,
We have developed 10 mappings. All of these mappings are one to one mapping. They are no expression or conversion. The data is in CSV file (i.e. source system) and target is oracle ADW (i.e. target system). We have create a simple load plan to trigger all the mapping in parallel mode to load the data.
Before start the load plan we have observed no of inactive session for ODI repository is 4. After trigger the load plan the no of inactive session increased to 30. Once the load plan successfully completed out of the 30 inactive session only 12 got closed , remaining 18 inactive session are still in inactive mode. Those are not closed at all.
The no of inactive session are getting increase every time we trigger the data load process,
Any idea on this issue.
ODI Version is ODI Market place V12.2.1.4.210321.
Thank you all in advance.
Answers
-
Hi,
Apply Patch 32708064: Inactive ODI sessions not releasing DB connections
Adrian