2005404 - Deploying LM-SERVICE fails due to incorrect stream value length

While trying to deploy the LM-SERVICE SCA, independently of client (SUM, JSPM, SDM, etc), the deployment fails.

In the client deployment logs (i.e. sdmclxxxxxxx.log) you can see the following entry:

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The stream value is not the specified length. The specified length was 0, the actual length is 60,415.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeInterruptException(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSWriter.error(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSWriter.writeStream(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSWriter.writeRPCInputStream(Unknown Source)
at com.microsoft.sqlserver.jdbc.DTV$SendByRPCOp.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.DTV.executeOp(Unknown Source)
at com.microsoft.sqlserver.jdbc.DTV.sendByRPC(Unknown Source)
at com.microsoft.sqlserver.jdbc.Parameter.sendByRPC(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.sendParamsByRPC(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doPrepExec(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatementBatch(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtBatchExecCmd.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(Unknown Source)

In the defaultTrace.XX.trc traces you can see the following entry:

#Error#1#/System/Audit#Java###Exception {0}#1#com.sap.engine.services.deploy.exceptions.ServerDeploymentException: Exception in operation update with application sap.com/tc~smd~agent~application~flightrecorderdumpscan.
...
Caused by: com.sap.engine.services.deploy.exceptions.ServerDeploymentException: Cannot commit handler in operation update with application sap.com/tc~smd~agent~application~flightrecorderdumpscan.
...
Caused by: com.sap.engine.frame.core.configuration.ConfigurationException: Error occurred during DB access: ,
...
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The stream value is not the specified length. The specified length was 0, the actual length is 60,403.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeInterruptException(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSWriter.error(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSWriter.writeStream(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSWriter.writeRPCInputStream(Unknown Source)
at com.microsoft.sqlserver.jdbc.DTV$SendByRPCOp.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.DTV.executeOp(Unknown Source)
at com.microsoft.sqlserver.jdbc.DTV.sendByRPC(Unknown Source)
at com.microsoft.sqlserver.jdbc.Parameter.sendByRPC(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.sendParamsByRPC(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doPrepExec(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatementBatch(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtBatchExecCmd.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(Unknown Source)

• SAP NetWeaver Application Server Java
   
• Microsoft SQL Server

SUM, SDM, deploy, LM-SERVICE, stream value length , KBA , BC-JVM-VM , Virtual Machine , SV-SMG-INS-DIA , Configuration of Root Cause Analysis related infrastructure , Problem