IBM Support

Upgrading InfoSphere MDM by using the upgrade_mdm target results in an error if the database is Microsoft SQL Sever

Troubleshooting


Problem

If you use the upgrade_mdm madconfig target to upgrade your deployment of InfoSphere MDM from versions 11.5 or 11.6 to InfoSphere MDM 14, the madconfig target upgrade-mdm-ae-db fails with the following exception message:

Upgrade Process is executing DML files
[2024-06-06T08:47:33,249] [main] ERROR com.ibm.mdm.de.ant.task.UpgradeDMLTask.execute(Line:161) [] - com.microsoft.sqlserver.jdbc.SQLServerException: "encrypt" property is set to "true" and "trustServerCertificate" property is set to "false" but the driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption: Error: IBMTrustManager: Problem accessing trust store java.lang.Exception: Truststore file does not exist: . ClientConnectionId:2d6d9639-d5f6-459d-aefa-849ae7127532

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSWSR9","label":"IBM InfoSphere Master Data Management"},"ARM Category":[{"code":"a8m500000008dDQAAY","label":"Install and Upgrade"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
26 June 2024

UID

ibm17157805