Article - CS260642
Error "Timeout Waiting for Idle Object" Occurs When SQL Service Connects to PostgreSQL Persistence Provider in ThingWorx
Modified: 26-Nov-2025
Applies To
- ThingWorx Platform 7.1 SP2 to 9.6
Description
- SQL Service in ThingWorx throws error while attempting to connect to the Persistence Provider running on PostgreSQL 9.4
- Following is logged in Application.log for ThingWorx
Execution error in service script : Wrapped java.sql.SQLException: Cannot get a connection, pool error Timeout waiting for idle object Cause: Cannot get a connection, pool error Timeout waiting for idle object
....
S.c.t.d.e.DSLProcessor
WSExecutionProcessor-214
....
S.c.t.d.e.DSLProcessor
WSExecutionProcessor-214
- Error happens randomly and gets resolved automatically after a while
- This issue is more likely observed when multiple connections are initiated from device and from the users
- Default settings are used for the persistence provider in \\ThingworxPlatform\platform-settings.json
- Persistence provider is not configured for such an high usage
- DB Connector things are running out of Connections with following error-
[L: ERROR] [O: D.c.t.t.d.QueryHandler] [I: ] [U: <User>] [S: ] [P: <platform>] [T: https-jsse-nio-443-exec-5] Unable to Invoke Service <Service Name> on <Thing Name> : Execute Query failed. java.sql.SQLException: Cannot get a connection, general error
This is a printer-friendly version of Article 260642 and may be out of date. For the latest version click CS260642