0 Replies Latest reply on Mar 4, 2013 11:18 AM by jonathan.lehman

    6.0 to 6.0.1 upgrade - db script error forces "manually perform this upgrade task"

    jonathan.lehman

      I wanted to share a database script error in the database upgrade wizard that we ran into (able to fix, but I thought it be good to share out to the community).

       

      To note: we are on Oracle11g

       

      Solution:  add ";" at the end the insert statement.

       

      Wizard recommended scripts:

      EXCEPT SELECT  activity_type, activity_name, description FROM jivedw_activity_meta

      EXCEPT SELECT  object_type, object_name FROM jivedw_object_meta

       

      CORRECT scripts:

      EXCEPT SELECT  activity_type, activity_name, description FROM jivedw_activity_meta;

      EXCEPT SELECT  object_type, object_name FROM jivedw_object_meta;

       

      Wizard error message:

      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;

       

      Future upgrade tasks may depend on the success of this upgrade task. Do not click the finished button until you have successfully executed all the steps outlined in the instructions above. To return to the main upgrade page click the cancel button.