Symptoms After upgrading to Appian 24.1, users are unable to connect to the SQL Server data source in the Admin Console. The following error will be seen in the tomcat-stdOut.log : ERROR com.appiancorp.process.runtime.activities.QueryRdbmsActivity…

Symptoms Tomcat fails to start up with the following error in <APPIAN_HOME>/logs/tomcat-stdOut.log . Caused by: java.lang.NullPointerException at com.microsoft.sqlserver.jdbc.SQLServerClobBase.length(SQLServerClob.java:388) Cause This can result…

Symptoms From the Admin Console, a user is unable to add a SQL Server data source hosted in Microsoft Azure Cloud. The following error is printed in the tomcat-stdOut.log located in the <APPIAN_HOME>/logs directory: DEBUG com.appiancorp.rdbms.datasource…

Purpose There are two types of authentication for SQL Server: SQL Authentication and Windows Authentication. Windows Authentication is sometimes referred to as Integrated Authentication. Windows Authentication will use the same user who started the…

Symptoms When attempting to validate a SQL Server data source hosted on a Windows Server 2003 Operating System, the process will fail with the following error in the application server log: com.appiancorp.rdbms.datasource.DataSourceValidationException…

Integrated Windows authentication with a Microsoft SQL Server database is not supported in Appian Cloud. It requires the party making the request to be running as a Windows account or to use an open source driver, neither of which are supported in Appian…

Symptoms In the application server log you will see the following sets of errors indicating deadlocks: org.hibernate.util.JDBCExceptionReporter logExceptions SEVERE: Transaction (Process ID 56) was deadlocked on lock resources with another process…

This issue has been resolved in an Appian hotfix/new Appian version. Please apply the latest hotfix to your Appian installation or upgrade to the latest version of Appian. Symptoms Upgrading to 16.2 using Microsoft SQL Server as the Appian…

Symptoms Creating a data store and verifying the entity mappings fails with error message No matching tables found! after confirming that the tables do exist in the database table or view. Cause The schema defined in the XSD is lowercased by Appian…

Symptoms SQL Authentication is enabled on SQL Server yet Appian SQL Authentication fails. This can be seen in the application server log with a large stack trace, but it will contain the following important statements: java.sql.SQLException: javax…

Symptoms After configuring SQL Server as either a primary data source or business data source to use with Appian, users might encounter the following error during JBoss startup: org.hibernate.exception.GenericJDBCException: Cannot open connection…

Symptoms During JBoss startup, the following warning is shown (after startup this warning will be shown intermittently): 21:39:25,801 WARN [com.arjuna.ats.jta] (Periodic Recovery) ARJUNA016027: Local XARecoveryModule.xaRecovery got XA exception XAException…