Uploaded image for project: 'Ambari'
  1. Ambari
  2. AMBARI-5153

Column length too long for Oracle

    XMLWordPrintableJSON

Details

    • Task
    • Status: Resolved
    • Critical
    • Resolution: Fixed
    • None
    • 1.5.0
    • None
    • None

    Description

      Exception on Upgrade:

      18:51:05,653  WARN [main] DBAccessorImpl:419 - Error executing query: CREATE TABLE blueprint_configuration (blueprint_name VARCHAR2(255) NOT NULL, type_name VARCHAR2(255) NOT NULL, config_data VARCHAR2(32000) NOT NULL, PRIMARY KEY (blueprint_name, type_name))
      java.sql.SQLSyntaxErrorException: ORA-00910: specified length too long for its datatype
      
              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
              at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
              at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
              at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
              at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
              at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
              at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
              at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
              at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1909)
              at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871)
              at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
              at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:417)
              at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:403)
              at org.apache.ambari.server.orm.DBAccessorImpl.createTable(DBAccessorImpl.java:112)
              at org.apache.ambari.server.upgrade.UpgradeCatalog150.executeDDLUpdates(UpgradeCatalog150.java:206)
              at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:177)
              at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:177)
              at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:237)
      18:51:05,654 ERROR [main] SchemaUpgradeHelper:182 - Upgrade failed.
      

      Attachments

        Issue Links

          Activity

            People

              jspeidel John Speidel
              jspeidel John Speidel
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: