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

Database migration fails with legacy database

    Details

      Description

      Database Migration throws exception when customer uses tables from legacy database. Migration try to migrate legacy tables also, but does not find it.

      Error message :
      "user lacks privilege or object not found" when migrating from hsql

      steps to reproduce

      1. Create a service builder portlet that uses a legacy database or you can use the attached legacy-db-portlet-6.2.0.1.war portlet.
      2. If you are using the attached portlet:
        • create database "legacydb" in mysql with root, no password. If you use another credentials, modify ext-spring.xml in portlet.
        • you do not need any table in "legacydb"
      3. create a a database "migrateto" in mysql
      4. Start Liferay
      5. Deploy the portlet
      6. Migrate your database
        • go to Admin -> control panel -> server administration -> Data Migration tab
        • fill in the form:
          • JDBC Driver Class Name : com.mysql.jdbc.Driver
          • JDBC URL : jdbc:mysql://localhost:3306/migrateto
          • JDBC User Name : root
          • JDBC Password : leave empty
        • Click on Execute button

      Experienced behaviour

      Exception in logs, migration fails, portal shuts down.

      Expected behaviour

      Error/warning message, migration finishes.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                mark.jin Mark Jin (Inactive)
                Reporter:
                peter.borkuti Peter Borkuti (Inactive)
                Participants of an Issue:
                Recent user:
                Esther Sanz
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  6 years, 4 weeks ago

                  Packages

                  Version Package
                  6.1.X EE
                  6.2.0 CE RC5