I have Apache Solr hosted on Tomcat 6.
There have been no changes to the code on Tomcat whatsoever nor SQL server configurations.I am using
sqljdbc4 and JRE version 1.6.0 .However for the last few days I now see this error in the Log files:
SEVERE: Full Import failed
Throwable occurred: org.apache.solr.handler.
dataimport.DataImportHandlerException: Unable to execute query: SELECT ID, ENTRY_TYPE_REF, PROFILE_REF, ITEM_REF, TITLE, ABSTRACT, SOLUTION, SOLUTION_HTML, FREE_TEXT, DATE_UPDATED, ENTRY_TYPE, PROFILE_TYPE,
SERVICE_TYPE FROM INFRA_KO_V Processing Document # 1
at org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:72)
at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:251)
at org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:208)
at org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:39)
at org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:58)
at org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:71)
at org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:233)
at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:579)
at org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:260)
at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:184)
at org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:334)
at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:392)
at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:373)
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.".
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1368)
at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1412)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1058)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:833)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:716)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:841)
at org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:160)
at org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:127)
at org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcDataSource.java:361)
at org.apache.solr.handler.dataimport.JdbcDataSource.access$200(JdbcDataSource.java:39)
at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:238)
... 11 more
Caused by: java.io.IOException: SQL Server did not return a response. The connection has been closed.
at com.microsoft.sqlserver.jdbc.TDSChannel$SSLHandshakeInputStream.ensureSSLPayload(IOBuffer.java:513)
at com.microsoft.sqlserver.jdbc.TDSChannel$SSLHandshakeInputStream.readInternal(IOBuffer.java:570)
at com.microsoft.sqlserver.jdbc.TDSChannel$SSLHandshakeInputStream.read(IOBuffer.java:562)
at com.microsoft.sqlserver.jdbc.TDSChannel$ProxyInputStream.readInternal(IOBuffer.java:757)
at com.microsoft.sqlserver.jdbc.TDSChannel$ProxyInputStream.read(IOBuffer.java:745)
at com.ibm.jsse2.b.a(b.java:286)
at com.ibm.jsse2.b.a(b.java:67)
at com.ibm.jsse2.SSLSocketImpl.a(SSLSocketImpl.java:313)
at com.ibm.jsse2.SSLSocketImpl.h(SSLSocketImpl.java:63)
at com.ibm.jsse2.SSLSocketImpl.a(SSLSocketImpl.java:316)
at com.ibm.jsse2.SSLSocketImpl.startHandshake(SSLSocketImpl.java:220)
at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1379)
... 20 more
I can confirm that there has been no change to firewall settings or changes to the JAVA version .
Need help on this.