KB-1140 Errors upgrading Appian to 16.2 using SQL Server as the Appian datasource

Upgrading to 16.2 using Microsoft SQL Server as the Appian datasource fails with the following error in the application server log:

Error creating bean with name 'keyStoreConfig' defined in class com.appiancorp.common.crypto.CryptoSpringConfig: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.appiancorp.common.crypto.KeyStoreConfig]: Factory method 'keyStoreConfig' threw exception; nested exception is org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of com.appiancorp.common.config.persistence.Config.isDefault

Cause

This issue has been addressed via AN-69760 in the following hotfixes/versions:

• Appian 16.2 Hotfix Package A
• Appian 16.3

Action

Apply the latest hotfix to your Appian installation or upgrade to the latest version of Appian

Workaround

To workaround this issue, follow the steps below:

1. Login to the SQL Server and access the Appian datasource.
2. Execute the following query:
   UPDATE cfg SET is_default=0;
3. Restart the application server.

Affected Versions

This article applies to Appian 16.2 using Microsoft SQL Server 2008 or 2012 as the Appian datasource.