Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-65068

Upgrading from Portal 6.1 to 7 using Oracle 11/12 results in data loss for Blogs, MB

    Details

      Description

      Steps to reproduce:
      1. Set up upgrade bundle using the data folder and dump file attached to this ticket
      2. Run "ant upgrade"

      Expected result:
      Bundle upgrades successfully

      Actual result:
      Bundle upgrades successfully, but console errors are thrown.

       java.sql.SQLException: ORA-22858: invalid alteration of datatype_ 
       java.sql.SQLException: ORA-22859: invalid modification of columns_ 
       java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object_ 

      When running the upgrade bundle, portal is able to start and the site pages appear as expected.
      However,
      1. No portlet is found on any of the pages. Affected portlets are Blogs and Message Boards (and Alerts, Bookmarks - see LPS-65082).
      2. The entries from these portlets still appear in site administration

      The full stacktrace of ant upgrade and catalina run can be found in this gist.

      Reproduced on:
      Tomcat 8.0.32 + Oracle 11g R2
      Portal DXP B2

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  3 years, 31 weeks, 4 days ago

                  Packages

                  Version Package
                  7.0.1 CE GA2