Direct link to fix
APAR status
Closed as program error.
Error description
During an upgrade to IBM Business Automation Workflow, the DBUpgrade command fails because the DBUpgrade JVM doesn't connect to the database that is configured to support only TLSv1.2 protocol connections. The following errors are written to the DBUpgrade log: [Sep 13, 2020 11:42:12 AM] 00000001 FINE: com.lombardisoftware.tools.dbupgrade.UpgradeDatabase.main - java.lang.RuntimeException: Could not connect to your Process Server database.Check the cause of the exception for more information. Make sure the database server is connected and the JDBC driver files are in your JDBC driver path, which is specified in the deployment environment (DE) properties file. ... Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server did not return a response. The connection has been closed. ClientConnectionId:.. Stack includes jsse2 messages: at com.ibm.jsse2.b.a(b.java:262) at com.ibm.jsse2.b.a(b.java:33) at com.ibm.jsse2.av.a(av.java:579) at com.ibm.jsse2.av.i(av.java:574) at com.ibm.jsse2.av.a(av.java:280) at com.ibm.jsse2.av.startHandshake(av.java:431
Local fix
Add the following setting to the ${BAW_INSTALL_ROOT}/util/dbUpgrade/upgrade.properties file: com.ibm.jsse2.overrideDefaultTLS=true
Problem summary
This error occurs because the DBUpgrade JVM uses the default TLSv1 protocol to connect to the database.
Problem conclusion
A fix is available or will be available that ensures the DBUpgrade command connects to the database by using only the TLS1.2 protocol.
Temporary fix
Comments
APAR Information
APAR number
JR62856
Reported component name
BUS AUTO WORKFL
Reported component ID
5737H4100
Reported release
J00
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-09-25
Closed date
2020-09-30
Last modified date
2020-10-09
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
BUS AUTO WORKFL
Fixed component ID
5737H4100
Applicable component levels
[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS8JB4","label":"IBM Business Automation Workflow"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"19.0.0.1"}]
Document Information
Modified date:
14 December 2020