SAP Note 1473299 - Setting Maximum Concurrency and poolWaitingTime in File/Jdbc

Component : File Adapter - JDBC Adapter

Solution : https://service.sap.com/sap/support/notes/1473299 (SAP Service marketplace login required)

Summary :
In a scenario employing the FTP/JDBC Adapter for message processing, parallel database connections through the 'maximum Concurrency' Parameter lead to indefinite waiting when set at 1, due to a default 'poolWaitingTime' of 0. This requires channel configurations under advanced settings to specify a positive 'poolWaitingTime' to avoid perpetual runnable states in threads. This adjustment ensures more efficient message processing by preventing threads from indefinitely awaiting resources. For implementation, users must apply the relevant patch as per their Support package version, referencing the NetWeaver Support Package Stack guide on SAP Service Marketplace.

Key words :
acquire parallel ftp/db connections, netweaver support package stack guide, symptom ftp/jdbc adapter, prerequisites special development solution, receiver file/jdbc adapter, receiver ftp/jdbc channel, ftp/db connection, terms file adapter, support package version, runnable state leaving

Related Notes :

1604091Messages delivered by File/JDBC receiver stuck in DLNG state
1531912SAP EhP1 for XI on Netweaver 7.00 SP08
1530712NW04s XI Support Package Stack 23
1511517SAP EHP1 FOR SAP NETWEAVER PI 7.1 SP06
1511515SAP Netweaver for PI 7.10 Support Package 11
1459565SAP EHP1 FOR SAP NETWEAVER PI 7.1 SP05
821267FAQ: XI 3.0 / PI 7.0 / PI 7.1 / PI 7.3 File Adapter