When performing operations that access an SQL server database from Appian, the following error may be encountered:
org.hibernate.exception.GenericJDBCException: Cannot open connection: java.sql.SQLException: javax.resource.ResourceException: IJ000456: Unchecked throwable in ManagedConnection.getConnection()
Caused by: javax.resource.ResourceException: No matching credentials in Subject!
The error is typically seen in the application server log or as part of an alert that is generated when the process is paused by exception.
This error is due to a known issue with JBoss EAP 6 and occurs when two or more configured data sources use the same security domain.
See: Bug 1103684 - Unable to share Identity Security Domain across datasources
Starting with Appian 16.1, users have the ability to configure business data sources in the Admin Console. This is the recommended approach for configuring business data sources.
If you are on a version that supports configuring business data sources in the Admin Console, follow the steps above. After JBoss starts, reconfigure all data sources in the Admin Console instead using the same names and connection strings. After all business data sources have been tested and verified, remove them from the *-ds.xml file.
If you are not on a version that supports configuring business data sources in the Admin Console, follow the steps above only. Appian Technical Support recommends upgrading to a more recent version of Appian that contains this functionality.
This article applies to all versions of Appian.
Last Reviewed: February 2017
© 2019 Appian. All rights reserved.