2020-02-05 09:53:43.705 Thread:Inm_Notas - Error executing select statement for update 2020-02-05 09:53:43.705 Error Executing Batch com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2887) at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:2031) at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:6465) at com.microsoft.sqlserver.jdbc.TDSReader.nextPacket(IOBuffer.java:6368) at com.microsoft.sqlserver.jdbc.TDSReader.ensurePayload(IOBuffer.java:6346) at com.microsoft.sqlserver.jdbc.TDSReader.readBytes(IOBuffer.java:6647) at com.microsoft.sqlserver.jdbc.TDSReader.readWrappedBytes(IOBuffer.java:6668) at com.microsoft.sqlserver.jdbc.TDSReader.readLong(IOBuffer.java:6641) at com.microsoft.sqlserver.jdbc.StreamDone.setFromTDS(StreamDone.java:156) at com.microsoft.sqlserver.jdbc.SQLServerStatement$1NextResult.onDone(SQLServerStatement.java:1432) at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:71) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1617) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatementBatch(SQLServerPreparedStatement.java:2798) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtBatchExecCmd.doExecute(SQLServerPreparedStatement.java:2673) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2930) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:248) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:223) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:2074) at com.grid_tools.products.datamasker.SQLUpdate.batchPreparedMasking(SQLUpdate.java:4789) at com.grid_tools.products.datamasker.SQLUpdate.run(SQLUpdate.java:5334) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.net.SocketException: Connection reset at java.net.SocketInputStream.read(Unknown Source) at java.net.SocketInputStream.read(Unknown Source) at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:2023) ... 22 more 2020-02-05 09:53:43.736 Thread:Inm_Notas - CURSOR COUNT:7710000 2020-02-05 09:53:43.736 Thread:Inm_Notas - Select SQL:select BDD_OFUS.dbo.fnTifon(substring(CE_CertificacionEmpresa,1,9))+(substring(CE_CertificacionEmpresa,10,6)),"CE_CertificacionEmpresa",BDD_OFUS.dbo.fnMASK_NOMBRE(Colabora_SolicitanteReq),"Colabora_SolicitanteReq",BDD_OFUS.dbo.fnMASK_NOMBRE(ContactoNombre),"ContactoNombre",BDD_OFUS.dbo.fnMASK_TELEFONO(ContactoTel),"ContactoTel",BDD_OFUS.dbo.fnTIFON(Factura_CIF),"Factura_CIF",BDD_OFUS.dbo.fnTIFON(PreC_CIF),"PreC_CIF",BDD_OFUS.dbo.fnMASK_NOMBRE(PreC_NombreSociedad),"PreC_NombreSociedad",BDD_OFUS.dbo.fnTIFON(TasacionCIF),"TasacionCIF",BDD_OFUS.dbo.fnTIFON(Plusvalia_CIF),"Plusvalia_CIF","Id" from "dbo"."Inm_Notas" order by "Id" 2020-02-05 09:53:43.736 Thread:Inm_Notas - UPDATESQL:update "dbo"."Inm_Notas" SET "CE_CertificacionEmpresa" = ?,"Colabora_SolicitanteReq" = ?,"ContactoNombre" = ?,"ContactoTel" = ?,"Factura_CIF" = ?,"PreC_CIF" = ?,"PreC_NombreSociedad" = ?,"TasacionCIF" = ?,"Plusvalia_CIF" = ? WHERE "Id" = ?