Hello to all, We have a random problem in Appian 7.8 on jboss (and MS

nikolaosm over 9 years ago

Hello to all,

We have a random problem in Appian 7.8 on jboss (and MSSQL) that sometimes appears when we try to use the Query Database Smart Service
forum.appian.com/.../Query_Database_Smart_Service.html

In the vast majority of cases the update query we are running works. But sometimes we get this error
---
Problem: An error occurred in executing an Activity Class.
Details: There was a problem executing the SQL query. SQL Message : javax.resource.ResourceException: IJ000456: Unchecked throwable in ManagedConnection.getConnection() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@4c7409ee[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@56380f78 connection handles=0 lastUse=1444920886943 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.PoolBySubject@35aaf147 pool internal context=SemaphoreArrayListManagedConnectionPool@5440a83f[pool=SqlServerDS] xaR...

Discussion posts and replies are publicly visible

0 nikolaosm over 9 years ago

...esource=XAResourceWrapperImpl@7a7fbb80[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@56380f78 pad=false overrideRmValue=null productName=Microsoft SQL Server productVersion=10.50.1600 jndiName=java:/AppianProcDS] txSync=null]
Recommended Action: Examine the activity class to correct the error and then resume.
Priority of this problem: High Priority
----

The problem is
a) If the administrator retries the activity it works
b) that this particular error of not getting a managed connection is not reported by the activity in ErrorOccured, ErrorText. The activity fails and the flow stops. This means that we cannot rerun it

The question is how do we resolve it. Can we catch these kind of errors in the flow and rerun them?

Regards,

Nikos
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Stefan Helzle
A Score Level 3
over 9 years ago

I checked google for the error message which led me to this discussion (developer.jboss.org/.../727962). Googling again for "allow-multiple-users" and mssql led me to stackoverflow.com/.../set-database-from-single-user-mode-to-multi-user. Maybe this helps you to solve the underlaying problem.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel