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:
                  5 years, 39 weeks, 1 day ago

                  Packages

                  Version Package
                  6.1.X EE
                  6.2.0 CE RC5