Uploaded image for project: 'PUBLIC - Liferay Documentation'
  1. PUBLIC - Liferay Documentation
  2. LRDOCS-6995

Document that customers should remove certain virtual columns prior the upgrade from 6210 using Oracle

    Details

    • Type of Documentation:
      Deployment

      Description

      HI James Hinkey,

      In the last months we have found two customers with problems upgrading to 7.x using Oracle because the use of virtual columns. Here you have the explanation:
      https://issues.liferay.com/browse/LPP-34063?focusedCommentId=1855327&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-1855327

      Could we add a section in the upgrade documentation to check this before the upgrade to be able to remove those virtual columns and recreate them after the process?

      This is only for customers upgrading from 6210

      For now I think it is ok to just check the JournalArticle table executing this query in the database before the upgrade:

      select column_name, data_default, hidden_column from user_tab_cols where table_name = 'JOURNALARTICLE';
      

      And check if there are virtual columns which include the fields STRUCTUREID or TEMPLATEID.

      What do you think?

      Thanks!

        Attachments

          Activity

            People

            • Assignee:
              james.hinkey James Hinkey
              Reporter:
              alberto.chaparro Alberto Chaparro
              Subject Matter Expert:
              Alberto Chaparro
              Participants of an Issue:
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:

                Packages

                Version Package
                7.0.x
                7.1.x
                7.2.x