importURLMappings fails with CRJAZ2654E SQLServerException
We are performing server rename in our staging environment and noticed the following error message during the importURLMappings step:
CRJAZ1365I The server is attempting to connect to the following database: "//mydatabase:myport;databaseName=myuser;user=xxxxxxxx;password=xxxxxxxx" CRJAZ2654E The server was unable to connect to the database because the database connection settings are invalid or because database is unreachable (SQLSTATE: 08S01, SQLCODE: 0). Verify the connection settings in your teamserver.properties file. See the Jazz Team Server log for more information. 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:xyz". at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1749) at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1704) ... Caused by: java.io.IOException: SQL Server did not return a response. The connection has been closed. ClientConnectionIdxyz at com.microsoft.sqlserver.jdbc.TDSChannel$SSLHandshakeInputStream.ensureSSLPayload(IOBuffer.java:653) ... 188 more
What could be the reason?
|
One answer
From the stack trace it seems to be related to SSL configuration.
Following line was commented in the repotools-jts.bat file that caused the error
set DEFINE="$DEFINE -Dcom.ibm.jsse2.overrideDefaultTLS=true"
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.