You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ambari.apache.org by "John Speidel (JIRA)" <ji...@apache.org> on 2014/03/20 00:57:47 UTC

[jira] [Resolved] (AMBARI-5153) Column length too long for Oracle

     [ https://issues.apache.org/jira/browse/AMBARI-5153?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

John Speidel resolved AMBARI-5153.
----------------------------------

    Resolution: Fixed

merged to trunk

> Column length too long for Oracle
> ---------------------------------
>
>                 Key: AMBARI-5153
>                 URL: https://issues.apache.org/jira/browse/AMBARI-5153
>             Project: Ambari
>          Issue Type: Task
>            Reporter: John Speidel
>            Assignee: John Speidel
>            Priority: Critical
>             Fix For: 1.5.0
>
>
> Exception on Upgrade:
> {code}
> 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.
> {code}



--
This message was sent by Atlassian JIRA
(v6.2#6252)