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.

symmetricds | im001 | 9 months ago
  1. 0

    Synchronize stored procedures with comment," and ;

    symmetricds | 9 months ago | im001
    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.
  2. 0

    MSSQL Server 2005 integration with TC 4.0.0 - SQLException corrupting projects

    YouTrack | 8 years ago
    javax.el.ELException: Error reading 'pendingChanges' on type jetbrains.buildServer.serverSide.impl.BuildTypeImpl$$EnhancerByCGLIB$$beedcafa
  3. 0

    Primary key violation on insert into VCS_HISTORY

    YouTrack | 7 years ago
    java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__vcs_history__0EA330E9'. Cannot insert duplicate key in object 'dbo.vcs_history'.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    "Transaction was deadlocked" error under MS SQL

    YouTrack | 6 years ago
    java.sql.SQLException: Transaction (Process ID 98) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
  6. 0

    Error/Bug - (2) in SymDS 3.7.27

    symmetricds | 1 year ago | lluise
    org.jumpmind.db.sql.SqlException: Cannot insert the value NULL into column 'Quantità Articolo Consumato', table 'ITHK.dbo.Item to Transfer'; column does not allow nulls. INSERT fails.

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. jTDS
      JtdsPreparedStatement.execute
      1. net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
      2. net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2894)
      3. net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2334)
      4. net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:643)
      5. net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:614)
      6. net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:573)
      7. net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:761)
      7 frames
    3. Commons DBCP
      DelegatingPreparedStatement.execute
      1. org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
      2. org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
      2 frames
    4. org.jumpmind.db
      JdbcSqlTransaction.prepareAndExecute
      1. org.jumpmind.db.sql.JdbcSqlTransaction$4.execute(JdbcSqlTransaction.java:293)
      2. org.jumpmind.db.sql.JdbcSqlTransaction$4.execute(JdbcSqlTransaction.java:285)
      3. org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:336)
      4. org.jumpmind.db.sql.JdbcSqlTransaction.prepareAndExecute(JdbcSqlTransaction.java:285)
      4 frames
    5. org.jumpmind.symmetric
      SymmetricServlet.service
      1. org.jumpmind.symmetric.service.impl.OutgoingBatchService.updateOutgoingBatch(OutgoingBatchService.java:191)
      2. org.jumpmind.symmetric.service.impl.OutgoingBatchService.updateOutgoingBatch(OutgoingBatchService.java:171)
      3. org.jumpmind.symmetric.service.impl.DataExtractorService.extract(DataExtractorService.java:593)
      4. org.jumpmind.symmetric.service.impl.DataExtractorService.extract(DataExtractorService.java:454)
      5. org.jumpmind.symmetric.web.PullUriHandler.pull(PullUriHandler.java:121)
      6. org.jumpmind.symmetric.web.PullUriHandler.handleWithCompression(PullUriHandler.java:92)
      7. org.jumpmind.symmetric.web.AbstractCompressionUriHandler.handle(AbstractCompressionUriHandler.java:84)
      8. org.jumpmind.symmetric.web.SymmetricServlet.service(SymmetricServlet.java:103)
      8 frames
    6. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
      1 frame
    7. Jetty
      QueuedThreadPool$3.run
      1. org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808)
      2. org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587)
      3. org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
      4. org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
      5. org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
      6. org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
      7. org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
      8. org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
      9. org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
      10. org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
      11. org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
      12. org.eclipse.jetty.server.Server.handle(Server.java:499)
      13. org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
      14. org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
      15. org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
      16. org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
      17. org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
      17 frames
    8. Java RT
      Thread.run
      1. java.lang.Thread.run(Unknown Source)
      1 frame