0 Replies Latest reply on Apr 23, 2013 9:12 PM by jonathan.lehman

    ORA 6.x upgrade - Error Details: java.sql.SQLException: ORA-00933

    jonathan.lehman

      I wanted to share a database error during an ORA 11g we ran into (able to fix, but I thought it be good to share out to the community).

       

      Solution:  simply add ; at the end of the insert statement (corrections in bold).

       

      INSERT INTO jivedw_activity_meta VALUES (330, 'Mention', 'Fires when content, people, or places are @mentioned.');

      INSERT INTO jivedw_object_meta VALUES (1464927464, 'Status Update');


      Error message during upgrade (to 6.x)

      Error Details: java.sql.SQLException: ORA-00933: SQL command not properly ended at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:676) at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:602) at oracle.jdbc.driver.T2CStatement.executeForDescribe(T2CStatement.java:778) at oracle.jdbc.driver.T2CStatement.executeForRows(T2CStatement.java:971) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1696) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1662) at org.jivesoftware.sqlgen.DatabaseSQLWriter.write(DatabaseSQLWriter.java:78) at org.jivesoftware.sqlgen.SQLGen.applySQLToDatabase(SQLGen.java:196) at com.jivesoftware.community.analytics.AnalyticsUpgradeUtils.executeSQLGenFile(AnalyticsUpgradeUtils.java:96) at com.jivesoftware.community.upgrade.tasks.analytics.AnalyticsMetaTablesTask2.doTask(AnalyticsMetaTablesTask2.java:47) at com.jivesoftware.community.upgrade.UpgradeTaskExecutor.executeUpgrade(UpgradeTaskExecutor.java:124) at com.jivesoftware.community.upgrade.UpgradeTaskExecutor.run(UpgradeTaskExecutor.java:88) at org.springframework.core.task.SimpleAsyncTaskExecutor$ConcurrencyThrottlingRunnable.run(SimpleAsyncTaskExecutor.java:229) at java.lang.Thread.run(Thread.java:662)

      Follow the instructions below to manually perform this upgrade task. If you have any questions regarding this upgrade task, please contact support@jivesoftware.com.

      To augment the tables, execute the following script...

       

      -- ---------------------------------------------------------------------------

      -- Schema generated Feb 13, 2013 12:09:28 PM by SQLGen, ver SQLGen 1.1.0, freemarker 2.3.15

      -- ---------------------------------------------------------------------------

       

      -- Schema for Oracle

       

       

       

      -- ---------------------------------------------------------------------------

      -- SQL sections

      -- ---------------------------------------------------------------------------

       

      -- metadata inserts

      -- ---------------------------------------------------------------------------

       

       

              INSERT INTO jivedw_activity_meta VALUES (330, 'Mention', 'Fires when content, people, or places are @mentioned.')

              EXCEPT SELECT  activity_type, activity_name, description FROM jivedw_activity_meta;

       

              INSERT INTO jivedw_object_meta VALUES (1464927464, 'Status Update')

              EXCEPT SELECT  object_type, object_name FROM jivedw_object_meta;