Troubleshooting
Problem
When you try to upgrade the Maximo database to version 7.6.1.3, the configuration tool (ConfigUI) fails with the following error message:
The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "com.ibm.jsse2.util.j: PKIX path building failed: com.ibm.security.cert.IBMCertPathBuilderException: unable to find valid certification path to requested target".
The problem happens because Maximo 7.6.1.3 contains version 10.2 of the Microsoft JDBC driver for SQL Server. By default, this version has TLS encryption enabled.
Environment
This document applies only to Maximo Asset Management installations running on a Microsoft SQL Server database.
Resolving The Problem
To fix the issue, you must manually add the "encrypt=false" parameter to the maximo.properties file, and reencrypt the file before you upgrade the database to 7.6.1.3.
-
Rename or back up the existing maximo.properties file located in <installation directory>\maximo\applications\maximo\properties. The Windows default installation directory is C:\IBM\SMP. The Linux or UNIX default installation directory is /opt/IBM/SMP.
-
Copy the <installation directory>\etc\maximo.properties_orig file to <installation directory>\maximo\applications\maximo\properties\maximo.properties.
-
Edit the maximo.properties file located under directory <installation directory>\maximo\applications\maximo\properties, as follows:
- Locate the mxe.db.url entry in the file.
- Add the "encrypt=false" parameter at the end of the url, for example: jdbc:sqlserver://mymssql.server.ibm.com:1433;databaseName=maximo;integratedSecurity=false;sendStringParametersAsUnicode=false;electMethod=cursor;encrypt=false;
- Make any necessary changes to other properties, such as the passwords. Make sure the passwords match your previous database configuration. You can use the previous maximo.properties file as a reference.
- Save the changes.
-
From an Administrative command prompt, navigate to <installation directory>\maximo\tools\maximo directory and run encryptproperties.bat for Windows or ./encryptproperties.sh for UNIX or Linux. This command encrypts the database user password in maximo.properties.
- Go back to the configuration tool (ConfigUI) and start the configuration again.
For more information about the Microsoft JDBC driver version 10.2 for SQL Server, see the release notes at the following link:
https://docs.microsoft.com/en-us/sql/connect/jdbc/release-notes-for-the-jdbc-driver?view=sql-server-ver16#changes-in-102
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"ARM Category":[{"code":"a8m50000000ChzFAAS","label":"Install-\u003ESQL Server"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.6.1"}]
Was this topic helpful?
Document Information
Modified date:
22 September 2022
UID
ibm16615419