Details

    • Branch Version/s:
      6.1.x
    • Backported to Branch:
      Committed

      Description

      If there are SQL Server System Tables present in a database, Liferay will sometimes try to upgrade the pseudo-system database table and will throw an error.

      Steps to reproduce:
      1. Need pseudo-system tables in the database System Tables section
      This can be done by setting up some kind of system database mail.
      2. Upgrade

      Liferay will try to upgrade it and get a messaged like:

      15:38:03,231 INFO [VerifySQLServer:130] Updating sysmail_mailitems.recipients to use nvarchar
      15:38:03,262 ERROR [VerifySQLServer:88] java.sql.SQLException: Incorrect syntax near ')'.
      java.sql.SQLException: Incorrect syntax near ')'.

      sysmail_mailitems is not a Liferay table.

      depending on the tables present, other sys tables will be upgraded.

      Possible solution is to update the filter that determines which tables to alter and have it include 'AND (sysobjects.category != 2)' as pseudo-system tables have that category value.

      http://social.msdn.microsoft.com/Forums/zh/sqlreplication/thread/135ec547-2214-4da3-bd42-5c458759e144

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                pani.gui Pani Gui (Inactive)
                Reporter:
                jonas.choi Jonas Choi
                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:
                  4 years, 49 weeks, 2 days ago