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
, 1 year 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
, 11 months ago
DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=SMIS.SYM_SYNC_NODE_DISABLED;VARIABLE, DRIVER=3.58.82
via symmetricds by joeblow68
, 1 year ago
The size (2147483647) given to the type 'nvarchar' exceeds the maximum allowed for any data type (8000).
via symmetricds by krivoz
, 5 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"
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.
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 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 java.lang.Thread.run(Unknown Source)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
4 times, 6 months ago
Samebug visitor profile picture
Unknown user
Once, 6 months ago
3 times, 6 months ago
Samebug visitor profile picture
Unknown user
Once, 9 months ago
22 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.