Unable to start the Spotfire server after upgrade from 10.x to 11.x. It fails with "Error loading the keystore password for CT_CERTS"

Product:TIBCO Spotfire Server
Versions:Tibco Spotfire server 11.x and later

Summary:
Unable to start the Spotfire server after upgrade from 10.x to 11.x. It fails with "Error loading the keystore password for CT_CERTS"

Details:

Description - When using SQL server integrated authentication and after upgrading Tibco Spotfire server from 10.x to Spotfire version 11.x and later the Spotfire server service fails to start. The catalina.log shows the below error.

ERROR 2021-05-14T13:30:07,256-0400 [] [Spotfire].[localhost].[/spotfire]: Exception sending context initialized event to listener instance of class [com.spotfire.server.lifecycle.SpotfireServerInitializer]
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'addUserModificationListener' defined in class path resource [applicationContext.xml]: Cannot resolve reference to bean 'codeTrustManager' while setting bean property 'arguments' with key [0] with key [2]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'codeTrustManager' defined in class path resource [applicationContext.xml]: Cannot resolve reference to bean 'codeTrustKeyStore' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'codeTrustKeyStore' defined in class path resource [applicationContext.xml]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.spotfire.server.security.codetrust.CodeTrustKeyStore]: Constructor threw exception; nested exception is com.spotfire.server.security.trust.CAException: Error loading the keystore password for CT_CERTS
Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.spotfire.server.security.codetrust.CodeTrustKeyStore]: Constructor threw exception; nested exception is com.spotfire.server.security.trust.CAException: Error loading the keystore password for CT_CERTS.

Cause: When using SQL server integrated authentication and the Tibco Spotfire server is upgraded to version 11.x or above new tables "CT_CERTS" and "KEYSTORE_PASSWORDS" are added in the database. These tables have owners other than "dbo". Example "domain\user.CT_CERTS" and "domain\user.KEYSTORE_PASSWORDS". It should be as follows "dbo.CT_CERTS" and "dbo.KEYSTORE_PASSWORDS".

Resolution:

The DBA needs to fix the newly created tables to default owner as "dbo.CT_CERTS" and "dbo.KEYSTORE_PASSWORDS".