jetbrains.buildServer.serverSide.db.DBStringValueIsTooLongException: ORA-01461: can bind a LONG value only for insert into a LONG column SQL query: insert into build_problem (build_state_id, problem_id, problem_description) values (?, ?, ?) SQL exception: ORA-01461: can bind a LONG value only for insert into a LONG column

YouTrack | 4 months ago
  1. 0

    DBStringValueIsTooLongException on attempt to store build problem in database

    YouTrack | 4 months ago
    jetbrains.buildServer.serverSide.db.DBStringValueIsTooLongException: ORA-01461: can bind a LONG value only for insert into a LONG column SQL query: insert into build_problem (build_state_id, problem_id, problem_description) values (?, ?, ?) SQL exception: ORA-01461: can bind a LONG value only for insert into a LONG column

    Root Cause Analysis

    1. jetbrains.buildServer.serverSide.db.DBStringValueIsTooLongException

      ORA-01461: can bind a LONG value only for insert into a LONG column SQL query: insert into build_problem (build_state_id, problem_id, problem_description) values (?, ?, ?) SQL exception: ORA-01461: can bind a LONG value only for insert into a LONG column

      at jetbrains.buildServer.serverSide.db.SQLExceptionConvertorForOracle.processSQLException()
    2. TeamCity Build Server
      GenericQuery.executeUpdate
      1. jetbrains.buildServer.serverSide.db.SQLExceptionConvertorForOracle.processSQLException(SQLExceptionConvertorForOracle.java:33)
      2. jetbrains.buildServer.serverSide.db.SQLExceptionConvertorBase.convertSQLException(SQLExceptionConvertorBase.java:66)
      3. jetbrains.buildServer.serverSide.db.DBFunctions.convertSQLException(DBFunctions.java:2364)
      4. jetbrains.buildServer.serverSide.db.DBFunctions.executeDmlInternal(DBFunctions.java:934)
      5. jetbrains.buildServer.serverSide.db.DBFunctions.executeDml(DBFunctions.java:876)
      6. jetbrains.buildServer.serverSide.db.queries.GenericQuery$3.run(GenericQuery.java:139)
      7. jetbrains.buildServer.serverSide.db.queries.GenericQuery$3.run(GenericQuery.java:137)
      8. jetbrains.buildServer.serverSide.db.DBFacade.withDB(DBFacade.java:234)
      9. jetbrains.buildServer.serverSide.db.queries.GenericQuery.executeUpdate(GenericQuery.java:137)
      9 frames
    3. jetbrains.buildServer.serverSide
      RunningBuildImpl.addBuildProblem
      1. jetbrains.buildServer.serverSide.impl.BuildPromotionProblems.insertBuildProblem(BuildPromotionProblems.java:126)
      2. jetbrains.buildServer.serverSide.impl.BuildPromotionProblems.updateBuildProblemInDatabase(BuildPromotionProblems.java:32)
      3. jetbrains.buildServer.serverSide.impl.BuildPromotionProblems.addBuildProblem(BuildPromotionProblems.java:51)
      4. jetbrains.buildServer.serverSide.impl.BuildPromotionImpl.addBuildProblem(BuildPromotionImpl.java:1226)
      5. jetbrains.buildServer.serverSide.impl.BaseBuild.addBuildProblem(BaseBuild.java:16)
      6. jetbrains.buildServer.serverSide.impl.RunningBuildImpl.addBuildProblem(RunningBuildImpl.java:432)
      6 frames
    4. TeamCity Build Server
      BaseMessageProcessor.processMessage
      1. jetbrains.buildServer.serverSide.stat.DefaultMessagesProcessor$BuildProblemProcessor.processMessage(DefaultMessagesProcessor.java:4)
      2. jetbrains.buildServer.serverSide.stat.DefaultMessagesProcessor.doProcessMessage(DefaultMessagesProcessor.java:112)
      3. jetbrains.buildServer.serverSide.stat.BaseMessageProcessor.processMessage(BaseMessageProcessor.java:26)
      3 frames
    5. jetbrains.buildServer.serverSide
      RunningBuildImpl$2.doInTransactionWithoutResult
      1. jetbrains.buildServer.serverSide.impl.RunningBuildImpl.doProcessMessage(RunningBuildImpl.java:480)
      2. jetbrains.buildServer.serverSide.impl.RunningBuildImpl.processMessage(RunningBuildImpl.java:730)
      3. jetbrains.buildServer.serverSide.impl.RunningBuildImpl.addBuildMessages(RunningBuildImpl.java:595)
      4. jetbrains.buildServer.serverSide.impl.RunningBuildImpl.access$100(RunningBuildImpl.java:553)
      5. jetbrains.buildServer.serverSide.impl.RunningBuildImpl$2.doInTransactionWithoutResult(RunningBuildImpl.java)
      5 frames
    6. Spring Tx
      TransactionTemplate.execute
      1. org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:34)
      2. org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)
      2 frames
    7. jetbrains.buildServer.serverSide
      BuildAgentMessagesQueue$BuildMessagesQueue$1.run
      1. jetbrains.buildServer.serverSide.impl.RunningBuildImpl.addAgentBuildMessages(RunningBuildImpl.java:52)
      2. jetbrains.buildServer.serverSide.impl.BuildAgentMessagesQueue.doProcessMessages(BuildAgentMessagesQueue.java:13)
      3. jetbrains.buildServer.serverSide.impl.BuildAgentMessagesQueue.access$700(BuildAgentMessagesQueue.java:64)
      4. jetbrains.buildServer.serverSide.impl.BuildAgentMessagesQueue$BuildMessagesQueue$1.run(BuildAgentMessagesQueue.java:2)
      4 frames
    8. TeamCity Build Server
      NamedThreadFactory.executeWithNewThreadName
      1. jetbrains.buildServer.util.NamedThreadFactory.executeWithNewThreadName(NamedThreadFactory.java:89)
      1 frame
    9. jetbrains.buildServer.serverSide
      BuildAgentMessagesQueue$2.run
      1. jetbrains.buildServer.serverSide.impl.BuildAgentMessagesQueue$BuildMessagesQueue.processMessages(BuildAgentMessagesQueue.java:14)
      2. jetbrains.buildServer.serverSide.impl.BuildAgentMessagesQueue$2.run(BuildAgentMessagesQueue.java:15)
      2 frames
    10. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame