org.jumpmind.db.sql.SqlException: Conversion failed when converting the nvarchar value 'Conversion failed when converting the varchar value 'SQL' to data type int.;' to data type int.

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via symmetricds by im001
, 1 year ago
Conversion failed when converting the nvarchar value 'Conversion failed when converting the varchar value 'SQL' to data type int.;' to data type int.
via symmetricds by tenshimitsu
, 2 years ago
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '000', 1, 1, null, null, 'tw_ZdjecieTw', 'I', 'BASE64', 'zd_Id,zd_IdTowar,zd_Zdje' at line 1
via symmetricds by anshusachdeva
, 1 year ago
DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=SMIS.SYM_SYNC_NODE_DISABLED;VARIABLE, DRIVER=3.58.82
via symmetricds by joeblow68
, 2 years ago
The size (2147483647) given to the type 'nvarchar' exceeds the maximum allowed for any data type (8000).
via symmetricds by krivoz
, 10 months ago
DELETE on table 'SYM_NODE' caused a violation of foreign key constraint 'SYM_FK_SEC_2_NODE' for key (my-client-id). The statement has been rolled back.
via symmetricds.org by Unknown author, 1 year ago
ERROR: duplicate key value violates unique constraint "sym_incoming_batch_pkey"
java.sql.SQLException: Conversion failed when converting the nvarchar value 'Conversion failed when converting the varchar value 'SQL' to data type int.;' to data type int.	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2894)	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2334)	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:643)	at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:614)	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:573)	at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:761)	at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)	at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)	at org.jumpmind.db.sql.JdbcSqlTransaction$4.execute(JdbcSqlTransaction.java:293)	at org.jumpmind.db.sql.JdbcSqlTransaction$4.execute(JdbcSqlTransaction.java:285)	at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:336)	at org.jumpmind.db.sql.JdbcSqlTransaction.prepareAndExecute(JdbcSqlTransaction.java:285)	at org.jumpmind.symmetric.service.impl.OutgoingBatchService.updateOutgoingBatch(OutgoingBatchService.java:191)	at org.jumpmind.symmetric.service.impl.OutgoingBatchService.updateOutgoingBatch(OutgoingBatchService.java:171)	at org.jumpmind.symmetric.service.impl.DataExtractorService.extract(DataExtractorService.java:593)	at org.jumpmind.symmetric.service.impl.DataExtractorService.extract(DataExtractorService.java:454)	at org.jumpmind.symmetric.web.PullUriHandler.pull(PullUriHandler.java:121)	at org.jumpmind.symmetric.web.PullUriHandler.handleWithCompression(PullUriHandler.java:92)	at org.jumpmind.symmetric.web.AbstractCompressionUriHandler.handle(AbstractCompressionUriHandler.java:84)	at org.jumpmind.symmetric.web.SymmetricServlet.service(SymmetricServlet.java:103)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808)	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587)	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)	at org.eclipse.jetty.server.Server.handle(Server.java:499)	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)	at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)	at java.lang.Thread.run(Unknown Source)