SAP Note 719778 - DataSource fails to return connection

Component : Transactions and Resource Handling - Enterprise Runtime, Core J2EE FrameworkBC-UPG-ADDON Upgrade

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

Summary :
SAP Note addresses an error where connections to a DataSource via ConnectionFactoryImpl fail to establish in a SAP J2EE Engine. Identification of this issue hinges on three primary causes: cached connections within system threads, insufficient pool sizes of specific adapters due to high system load, and inadequate waiting times for connection availability relative to current pool sizes. Solutions include using Connector Service commands to check cached connections, adjusting pool sizes, and increasing connection wait times. Techniques such as switching to debug mode and using "list_conns" command are suggested for diagnosis and troubleshooting. Performance improvements may involve telnet connections to SAP J2EE Engine, employing DBPool Service commands, and configuring DataSource properties based on observed connection utilizations and system load impacts.

Key words :
stack trace      transaction status        cci transaction status          started, trace  transaction status    spi transaction status      started, stack trace    xa transaction status      started, select server <number> -> services -> jdbc connector, select server <number> -> services -> jms connector, cci/spi transaction invokations, id  resref transaction status, connector service list-conns command, modified rar/ear file, id ofthe problematic server

Related Notes :

1482484System becomes unresponsive when syncing roles and users
1142017Error "Failed to run Risk Analysis" in the CC Background job