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
Alok Mohare
Appian Employee
over 10 years ago
Hi Gaurav,
You might want to review the logs on the Database server side to check why the connection between the Appian Server and the Database is being dropped. This could be a networking issue.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
gauravp
over 10 years ago
Hey thanks for turn around : I have checked erro in the log are as : ERROR com.appiancorp.database.ExecuteQuery - java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for jdbc/ABC
Thanks,
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Stefan Helzle
A Score Level 3
over 10 years ago
This looks like the Appian application logfile. Alok meant that you should check the logfiles of the Oracle DB server itself.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 10 years ago
If the database becomes unavailable for a certain period of time and your appian-ds.xml is not configured to automatically reconnect then you have to restart the application server /redeploy. You can add the following to make sure the app server will try to reconnect (replace the word DUAL with the name of any table in that DB)
<validation>
<check-valid-connection-sql>SELECT 1 FROM DUAL</check-valid-connection-sql>
</validation>
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rahulp
over 9 years ago
Hi Ed,Alok,Stefanh
Here are the logs I received from Oracle database team :
Mon Jul 21 02:28:22 2014
Thread 1 advanced to log sequence 702
Current log# 2 seq# 702 mem# 0: /cpac/oradata/redo02.log
Mon Jul 21 07:00:19 2014
Thread 1 advanced to log sequence 703
Current log# 3 seq# 703 mem# 0: /cpac/oradata/redo03.log
Mon Jul 21 15:00:28 2014
Thread 1 advanced to log sequence 704
Current log# 1 seq# 704 mem# 0: /cpac/oradata/redo01.log
Mon Jul 21 21:45:02 2014
alter database backup controlfile to trace
Mon Jul 21 21:45:02 2014
Completed: alter database backup controlfile to trace
Mon Jul 21 23:00:43 2014
Thread 1 advanced to log sequence 705
Current log# 2 seq# 705 mem# 0: /cpac/oradata/redo02.log
Tue Jul 22 03:00:14 2014
Thread 1 advanced to log sequence 706
Current log# 3 seq# 706 mem# 0: /cpac/oradata/redo03.log
Tue Jul 22 09:00:16 2014
Thread 1 advanced to log sequence 707
Current log# 1 seq# 707 mem# 0: /cpac/oradata/redo01.log
@ Ed - Also the I want to specify the database we are facing issue with is a secondary database. Do we need to add the line(mentioned in your comment above) to the DS file of this DB or to the primary primary ds?
Thanks,
Rahul
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 9 years ago
You add that line to all the data sources to make sure the reconnection is attempted.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
gauravp
over 9 years ago
Hello Ed,
THe problem is that we have an oracle secondary datasource and the problem is solely with this only. Rest all the datasources are working perfectly fine. Our developers query this oracle database via Appian but after sometime it gives error saying" javax.resource.ResourceException: IJ000453: Unable to get managed connection for jdbc" It seems we dont have any available connection to connect databse. I have also increased the pool size to 250 but problem still occurs.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 9 years ago
Did you add the suggested tag and restarted JBoss? If even with the tag you're seeing the issue they probably there's a plug-in not closing the connections to that secondary DS but I'd rather start by adding the suggested tag.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
gauravp
over 9 years ago
Just checking below property will work with oracle DS.?
(replace the word DUAL with the name of any table in that DB)
<validation>
<check-valid-connection-sql>SELECT 1 FROM DUAL</check-valid-connection-sql>
</validation>
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 9 years ago
Yes
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
>