AAI 24.4 Upgrade Failure: java.util.MissingResourceException key dbms.mssql.url

Products

• Automation Analytics & Intelligence

Issue/Introduction

When upgrading Automation Analytics & Intelligence (AAI) from version 24.2 to 24.4.x on a Linux environment, the upgrade process fails during the run-create-upgrade-sql-script target.

The following error is observed in the upgrade.log or console output:

[java] Upgrade failed.[java] java.util.MissingResourceException: Can't find resource for bundle java.util.PropertyResourceBundle, key dbms.mssql.url[java] at java.base/java.util.ResourceBundle.getObject(ResourceBundle.java:564)[java] at java.base/java.util.ResourceBundle.getString(ResourceBundle.java:521)[java] at com.termalabs.common.config.JawsDbConnectionConfigParms.getUrl(JawsDbConnectionConfigParms.java:193)[java] at com.termalabs.common.config.JawsDbConnectionConfigParms.getUrl(JawsDbConnectionConfigParms.java:182)[java] at com.termalabs.common.db.DatabaseSchemaVersion.<init>(DatabaseSchemaVersion.java:66)[java] at com.termalabs.upgrade.main.CreateJawsDbUpgradeScriptMain.main(CreateJawsDbUpgradeScriptMain.java:266)

 

 

Cause

Starting with AAI version 24.4, the upgrade dispatcher requires specific Microsoft SQL Server JDBC driver properties to be present in the jaws.properties file to initialize the database schema generation tool.

Even in non-Windows/non-MSSQL environments, the upgrader validates these keys. If the keys are commented out or use the legacy jtds driver format, the application throws a MissingResourceException because it cannot find the required dbms.mssql.url resource bundle key.

Resolution

To resolve this issue, manually update the jaws.properties file to include the expected Microsoft JDBC driver strings.

1. Stop the upgrade process if it is still running.
2. Navigate to the configuration directory: cd /opt/Automic_Automation_Intelligence/jboss/standalone/configuration/ (or your specific installation path).
3. Backup the existing configuration file: cp jaws.properties jaws.properties.bak
4. Edit jaws.properties and locate the MSSQL section.
5. Comment out the legacy jtds lines if present:
    

   #dbms.mssql.url=jdbc:jtds:sqlserver://#dbms.mssql.extra=ssl=request

6. Add/Uncomment the following two lines to use the Microsoft JDBC driver format:
   dbms.mssql.url=jdbc:sqlserver://
   dbms.mssql.extra=trustServerCertificate=true;encrypt=true
7. Save the file and restart the upgrade process using upgrade.sh.