SQLServerException

Hi,
I've been using the hg plugin for a month or so and recently started getting:

-


Problems with VCS connection:

ConnectionCallback; SQL []; String or binary data would be truncated.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated.

org.springframework.dao.DataIntegrityViolationException: ConnectionCallback; SQL []; String or binary data would be truncated.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated.
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:111)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:324)
at jetbrains.buildServer.serverSide.impl.DBFacade._runSql(DBFacade.java:51)
at jetbrains.buildServer.serverSide.impl.DBFacade.runSql(DBFacade.java:91)
at jetbrains.buildServer.serverSide.impl.query.GenericQuery.execute(GenericQuery.java:27)
at jetbrains.buildServer.serverSide.impl.query.InsertVcsModficationQuery$2.doInTransaction(InsertVcsModficationQuery.java:5)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128)
at jetbrains.buildServer.serverSide.impl.query.InsertVcsModficationQuery.insert(InsertVcsModficationQuery.java:17)
at jetbrains.buildServer.vcs.impl.DBVcsModificationHistory.addModification(DBVcsModificationHistory.java:73)
at jetbrains.buildServer.serverSide.impl.auth.SecuredVcsModificationHistory.addModification(SecuredVcsModificationHistory.java:22)
at jetbrains.buildServer.serverSide.impl.VcsModificationCreatorWrapper.createModification(VcsModificationCreatorWrapper.java:6)
at jetbrains.buildServer.buildTriggers.vcs.VcsChangesLoader.addModification(VcsChangesLoader.java:50)
at jetbrains.buildServer.buildTriggers.vcs.VcsChangesLoader.loadChanges(VcsChangesLoader.java:91)
at jetbrains.buildServer.vcs.impl.VcsManagerImpl.loadChanges(VcsManagerImpl.java:305)
at jetbrains.buildServer.vcs.impl.VcsManagerImpl.checkForModifications(VcsManagerImpl.java:400)
at jetbrains.buildServer.serverSide.impl.auth.SecuredVcsManager.checkForModifications(SecuredVcsManager.java:85)
at jetbrains.buildServer.serverSide.impl.VcsModificationChecker$1.run(VcsModificationChecker.java:5)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
at java.util.concurrent.FutureTask.run(FutureTask.java:123)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(Unknown Source)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
at jetbrains.buildServer.serverSide.impl.query.GenericQuery.doExecuteQuery(GenericQuery.java:49)
at jetbrains.buildServer.serverSide.impl.query.GenericQuery.access$100(GenericQuery.java:39)
at jetbrains.buildServer.serverSide.impl.query.GenericQuery$3.run(GenericQuery.java)
at jetbrains.buildServer.serverSide.impl.DBFacade$3.doInConnection(DBFacade.java)
at jetbrains.buildServer.serverSide.impl.DBFacade$4.doInConnection(DBFacade.java:2)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:317)
... 21 more
com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(Unknown Source)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
at jetbrains.buildServer.serverSide.impl.query.GenericQuery.doExecuteQuery(GenericQuery.java:49)
at jetbrains.buildServer.serverSide.impl.query.GenericQuery.access$100(GenericQuery.java:39)
at jetbrains.buildServer.serverSide.impl.query.GenericQuery$3.run(GenericQuery.java)
at jetbrains.buildServer.serverSide.impl.DBFacade$3.doInConnection(DBFacade.java)
at jetbrains.buildServer.serverSide.impl.DBFacade$4.doInConnection(DBFacade.java:2)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:317)
at jetbrains.buildServer.serverSide.impl.DBFacade._runSql(DBFacade.java:51)
at jetbrains.buildServer.serverSide.impl.DBFacade.runSql(DBFacade.java:91)
at jetbrains.buildServer.serverSide.impl.query.GenericQuery.execute(GenericQuery.java:27)
at jetbrains.buildServer.serverSide.impl.query.InsertVcsModficationQuery$2.doInTransaction(InsertVcsModficationQuery.java:5)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128)
at jetbrains.buildServer.serverSide.impl.query.InsertVcsModficationQuery.insert(InsertVcsModficationQuery.java:17)
at jetbrains.buildServer.vcs.impl.DBVcsModificationHistory.addModification(DBVcsModificationHistory.java:73)
at jetbrains.buildServer.serverSide.impl.auth.SecuredVcsModificationHistory.addModification(SecuredVcsModificationHistory.java:22)
at jetbrains.buildServer.serverSide.impl.VcsModificationCreatorWrapper.createModification(VcsModificationCreatorWrapper.java:6)
at jetbrains.buildServer.buildTriggers.vcs.VcsChangesLoader.addModification(VcsChangesLoader.java:50)
at jetbrains.buildServer.buildTriggers.vcs.VcsChangesLoader.loadChanges(VcsChangesLoader.java:91)
at jetbrains.buildServer.vcs.impl.VcsManagerImpl.loadChanges(VcsManagerImpl.java:305)
at jetbrains.buildServer.vcs.impl.VcsManagerImpl.checkForModifications(VcsManagerImpl.java:400)
at jetbrains.buildServer.serverSide.impl.auth.SecuredVcsManager.checkForModifications(SecuredVcsManager.java:85)
at jetbrains.buildServer.serverSide.impl.VcsModificationChecker$1.run(VcsModificationChecker.java:5)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
at java.util.concurrent.FutureTask.run(FutureTask.java:123)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)
-



Is there a field in the db I should try to make bigger or something?

Cheers,
Miika

1 comment
Comment actions Permalink

Sorry for delay. What version of TeamCity server do you use?

--
Pavel Sher

0

Please sign in to leave a comment.