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

• Type: Regression Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.1 CE GA2
• Fix Version/s: 7.0.1 CE GA2
• Component/s: Core Infrastructure, Core Infrastructure > Upgrade Framework
• Labels:
  • EE-Only
  • EXP7
  • KNOWNISSUES_DE70
  • LR7UPGRADE
  • collab-upgrades
• Fix Priority: 5
• Databases:
  Oracle Database 11.2, Oracle Database 12c Release 1
• Sprint: Bixbite
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/39110

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