You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ambari.apache.org by Sid Wagle <sw...@hortonworks.com> on 2015/05/05 02:54:42 UTC

Review Request 33832: Ambari with DB as oracle is failing to deploy

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/33832/
-----------------------------------------------------------

Review request for Ambari, Jonathan Hurley, Mahadev Konar, and Yusaku Sako.


Bugs: AMBARI-10918
    https://issues.apache.org/jira/browse/AMBARI-10918


Repository: ambari


Description
-------

Stack trace:

{code}

04 May 2015 18:05:13,404 ERROR [qtp-client-22] AmbariJpaLocalTxnInterceptor:114 - [DETAILED ERROR] Rollback reason: 
Local Exception Stack: 
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column

Error Code: 24816
Call: INSERT INTO widget (id, author, cluster_id, description, display_name, metrics, properties, scope, time_created, widget_name, widget_type, widget_values) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
	bind => [12 parameters bound]
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331)
{code}


Diffs
-----

  ambari-server/src/main/java/org/apache/ambari/server/orm/dao/ServiceConfigDAO.java 8f8e196 
  ambari-server/src/main/java/org/apache/ambari/server/orm/entities/WidgetEntity.java 397d845 
  ambari-server/src/main/java/org/apache/ambari/server/upgrade/UpgradeCatalog210.java dc7f7a9 
  ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql 7f00b10 
  ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql c0313e5 
  ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql 94e4884 
  ambari-server/src/main/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql 54c8c40 

Diff: https://reviews.apache.org/r/33832/diff/


Testing
-------

Manually verified.


Thanks,

Sid Wagle


Re: Review Request 33832: Ambari with DB as oracle is failing to deploy

Posted by Sid Wagle <sw...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/33832/
-----------------------------------------------------------

(Updated May 5, 2015, 12:56 a.m.)


Review request for Ambari, Jonathan Hurley, Mahadev Konar, and Yusaku Sako.


Bugs: AMBARI-10918
    https://issues.apache.org/jira/browse/AMBARI-10918


Repository: ambari


Description
-------

Stack trace:

{code}

04 May 2015 18:05:13,404 ERROR [qtp-client-22] AmbariJpaLocalTxnInterceptor:114 - [DETAILED ERROR] Rollback reason: 
Local Exception Stack: 
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column

Error Code: 24816
Call: INSERT INTO widget (id, author, cluster_id, description, display_name, metrics, properties, scope, time_created, widget_name, widget_type, widget_values) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
	bind => [12 parameters bound]
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331)
{code}


Diffs
-----

  ambari-server/src/main/java/org/apache/ambari/server/orm/dao/ServiceConfigDAO.java 8f8e196 
  ambari-server/src/main/java/org/apache/ambari/server/orm/entities/WidgetEntity.java 397d845 
  ambari-server/src/main/java/org/apache/ambari/server/upgrade/UpgradeCatalog210.java dc7f7a9 
  ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql 7f00b10 
  ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql c0313e5 
  ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql 94e4884 
  ambari-server/src/main/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql 54c8c40 

Diff: https://reviews.apache.org/r/33832/diff/


Testing (updated)
-------

Manually verified. UpgradeCatalog210Test and ServiceConfigDAOTest passed.


Thanks,

Sid Wagle