Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
23 replies
Subscribers
9 subscribers
Views
4806 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Administration
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,
...
OriginalPostID-116728
OriginalPostID-116728
Discussion posts and replies are publicly visible
0
rahulp
over 9 years ago
Hi Ed,
We implemented the change and addes the above suggested tag in ds file changing the Word DUAL with one of the table name. But after few hours we faced the same issue and the we redeployed the ds.
Can you please help to trouble shoot taking into consideraion the other possiblity you mentioned that some plugin not working poperly or not closing all the connection properly..Please suggest the next steps towards the solution.
Thanks,
Rahul
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
gauravp
over 9 years ago
HI Ed,
We are still getting the below error after adding the mentioned property.
javax.resource.ResourceException: IJ000453: Unable to get managed connection for jdbc
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 9 years ago
May I see the whole server.log of when this happened? I'd like to see the entire log if possible.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rahulp
over 9 years ago
Hi Ed,
Please find the attached server.log
Thanks,
Rahul
server.log.zip
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 9 years ago
I thought you said this was happning for an Oracle data source but the stack trace shows the issue is with jdbc/CMS_CN which is MS SQL Server and indicates a login issue:
Cannot open database "XXXX" requested by the login. The login failed.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 9 years ago
Or maybe I was looking at a different issue. The one for the Oracle data source shows the following:
Caused by: oracle.net.ns.NetException: Socket read timed out
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 9 years ago
Is jdbc/IDAM the one showing this behavior?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rahulp
over 9 years ago
Yes. it is only database we are getting issues with all other database are ok.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
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
0
rahulp
over 9 years ago
jdbc/IDAM is our secondary database we are facing issue with. I am giving properties from primary-ds.xml as well.
Please find the IDAM ds porperties:
min-pool-size : 5
max-pool-size: 250
blocking-timeout-millis:5000
appian-ds properties below
min-pool-size : 5
max-pool-size: 100
blocking-timeout-millis:5000
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
<
>