SAP Knowledge Base Article - Preview

3195253 - Error: "com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset" when execute task through MssqlLogReaderAdapter

Symptom

  • Create remote source connection through MssqlLogReaderAdapter to Serverless MSSQL, test connection without error.
  • Try to build BW datasource to extract data through the remote source, failed with error
    "Failed to execute query ***
                                    com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset
                                     at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:3422)
                                     at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:2066)
                                     at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:6616)
                                     at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:7802)
                                     at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:613)
                                     at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:537)
                                     at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7417)
                                     at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3488)
                                     at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:262)
                                     at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:237)
                                     at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:456)
                                     at com.sap.hana.dp.mssqllogreaderadapter.MssqlLogReaderAdapter.executeSelectStatement(MssqlLogReaderAdapter.java:1207)
                                     at com.sap.hana.dp.mssqllogreaderadapter.MssqlLogReaderAdapter.executeStatement(MssqlLogReaderAdapter.java:1117)
                                     at com.sap.hana.dp.cdcadaptercommons.logreader.SeparateClassloaderAdapterCDC.executeStatement(SeparateClassloaderAdapterCDC.java:207)


Read more...

Environment

SAP HANA Smart Data Integration

Product

SAP HANA smart data integration 2.0

Keywords

server less, serverless, MSSQL, SDI, connection reset , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.