Uploaded image for project: 'PUBLIC - Liferay Portal Enterprise Edition'
  1. PUBLIC - Liferay Portal Enterprise Edition
  2. LPE-1152

"Invalid object name" error occurs if using SQL Server 2000

    Details

      Description

      Using SQL Server 2000 with Liferay portal 5.1.5, 5.2.4 or 5.2.5 will cause the following SQL Server error when the portal starts:

      java.sql.SQLException: Invalid object name 'sys.indexes'

      The above error occurs because the sys.indexes table only exist in SQL Server 2005 and SQL Server 2008.

      To address this bug, the portal will no longer attempt to select from the sys.indexes table if the database is SQL Server 2000 or earlier.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              support-ee EE Support
              Reporter:
              samuel.kong Samuel Kong
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Packages

                  Version Package
                  5.1 EE SP3 (5.1.6)
                  5.2 EE SP1 (5.2.5)