View Issue Details

IDProjectCategoryView StatusLast Update
0002540SymmetricDSBugpublic2019-08-26 08:45
ReporterDavid OrtegaAssigned Toelong 
Status closedResolutionopen 
Product Version3.7.30 
Target VersionFixed in Version 
Summary0002540: Error during Insert or update with MS SQL Server 2014
DescriptionWe have a weird error, when we try to update a row with PK(1,1,24) it fails but when we update row PK(1,1,99) it works. All data are the same except the row autogenerated ID ( 24 or 99)



1,1,24,RA,016501305200312,"IBERIA ",2016-03-28,10:07:32,"itFails "
1,1,99,RA,016501305200312,"IBERIA ",2016-03-28,10:07:32,"itWorks "
Steps To Reproduce1º update ATRIUM.TRANSAC SET AAUSUMOD = 'itWorks' where agnumage = 1 and honumfic = 1 and genumtra = 24

2º update ATRIUM.TRANSAC SET AAUSUMOD = 'itFails' where agnumage = 1 and honumfic = 1 and genumtra = 99

AAUSUMOD is just a text field
Additional Information2016-03-29 12:25:25,220 DEBUG [sqlserver-001] [YRCH] [sqlserver-001-pull-1] Añadiendo {itWorks ,1,1,99}
2016-03-29 12:25:25,234 INFO [as400-000] [RouterService] [as400-000-job-5] Routed 1 data events in 689 ms
2016-03-29 12:25:25,397 INFO [sqlserver-001] [PullService] [sqlserver-001-pull-1] Pull data received from as400:000:000. 1 rows and 1 batches were processed
2016-03-29 12:25:30,672 DEBUG [as400-000] [YRCH] [as400-000-job-6] Añadiendo {1630,293,as400_2_sqlserver} in batch mode
2016-03-29 12:25:30,988 INFO [as400-000] [RouterService] [as400-000-job-6] Routed 1 data events in 712 ms
2016-03-29 12:25:35,271 DEBUG [sqlserver-001] [YRCH] [sqlserver-001-pull-1] Añadiendo {itFails ,1,1,24}
2016-03-29 12:25:35,287 ERROR [sqlserver-001] [YRCH] [sqlserver-001-pull-1] Error en tranlsate I/O Error: Connection reset
java.sql.SQLException: I/O Error: Connection reset
    at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(
    at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(
    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(
    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(
    at org.jumpmind.db.sql.JdbcSqlTransaction$5.execute(
    at org.jumpmind.db.sql.JdbcSqlTransaction$5.execute(
    at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(
    at org.jumpmind.db.sql.JdbcSqlTransaction.prepareAndExecute(
    at org.jumpmind.symmetric.db.mssql.MsSqlSymmetricDialect.enableSyncTriggers(
    at org.jumpmind.symmetric.service.impl.DataLoaderService$ManageIncomingBatchListener.enableSyncTriggers(
    at org.jumpmind.symmetric.service.impl.DataLoaderService$ManageIncomingBatchListener.beforeBatchEnd(
    at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener.end(
    at org.jumpmind.symmetric.service.impl.DataLoaderService.loadDataFromTransport(
    at org.jumpmind.symmetric.service.impl.DataLoaderService.loadDataFromPull(
    at org.jumpmind.symmetric.service.impl.PullService.execute(
    at org.jumpmind.symmetric.service.impl.NodeCommunicationService$
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$ Source)
    at Source)
Caused by: Connection reset
    at Source)
    at Source)
    at Source)
    at Source)
    at net.sourceforge.jtds.jdbc.SharedSocket.readPacket(
    at net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(
    at net.sourceforge.jtds.jdbc.ResponseStream.getPacket(
TagsNo tags attached.



2019-04-24 08:27

developer   ~0001425

The "connection reset" is when the network connection is knocked down unexpectedly. It would be unusual for a SQL statement to cause that error. Are you able to run the update manually from an interactive SQL query tool?


2019-08-26 08:45

administrator   ~0001588

Auto closing all issues waiting for feedback after 4 months. We don't have enough information to take any action.

Issue History

Date Modified Username Field Change
2016-03-29 06:38 David Ortega New Issue
2019-04-24 08:27 elong Assigned To => elong
2019-04-24 08:27 elong Status new => feedback
2019-04-24 08:27 elong Note Added: 0001425
2019-08-26 08:45 admin Note Added: 0001588
2019-08-26 08:45 admin Status feedback => closed