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
4811 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
One of the developer confirmed they use the datasource as input to one of the funtion execuutequery...so the answer would be yes to the question #1 in post above .
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 9 years ago
It seems it could be a bug with that plug-in. Let's do this:
1. Update these settings to these values
min-pool-size : 5
max-pool-size: 400
2. Add the following tag below </timeout>
<statement>
<track-statements>true</track-statements>
</statement>
3. Restart JBoss and wait for the issue to re-occur
4. Stop JBoss and remove the tag added on step #2 (i.e. <track-statements>)
5. Start JBoss and attach the server log
6. Paste the <validation> section of your data source that is experiencing the behavior
7. Check what version of com.appiancorp.forms.ajax_*.jar you have under <APPIAN_HOME>\\_admin\\plugins
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rahulp
over 9 years ago
Hi Ed,
We will perform the above steps and will update you with the logs. Meanwhile for the step #7 - com.appiancorp.forms.ajax_1.6.6 this is version we have currently.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
<