Hi Team, We have a oracle Ds file which stops working time to time. T

gauravp over 10 years ago

Hi Team,

We have a oracle Ds file which stops working time to time. The error which user see on the screen is Details”. [Unable to connect to database: javax.resource.ResourceException: IJ000453: Unable to get managed connection for jdbc/ABC].
After we redeploy the DS file datasource starts working as expected but this is not a permanent soulution for us. I have checked the maximum pool size is already set to 250. Kinldy suggest

Thanks,
...

Discussion posts and replies are publicly visible

Parents

0 Eduardo Fuentes
Appian Employee
over 9 years ago

The relevant message seems to be

Caused by: javax.resource.ResourceException: IJ000655: No managed connections available within configured blocking timeout (5000 [ms])

so either one of your plug-ins is leaking connections or you are running long queries at a high volume making it run out of connections.

1. Do you use this data source inside a plug-in? Please check with all the developers to verify
2. What's the value of these properties in appian-ds.xml?

min-pool-size
max-pool-size
blocking-timeout-millis
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Eduardo Fuentes
Appian Employee
over 9 years ago

The relevant message seems to be

Caused by: javax.resource.ResourceException: IJ000655: No managed connections available within configured blocking timeout (5000 [ms])

so either one of your plug-ins is leaking connections or you are running long queries at a high volume making it run out of connections.

1. Do you use this data source inside a plug-in? Please check with all the developers to verify
2. What's the value of these properties in appian-ds.xml?

min-pool-size
max-pool-size
blocking-timeout-millis
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data