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.