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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 5.1 EE SP2 (5.1.5), 5.2 EE (5.2.4)
• Fix Version/s: 5.1 EE SP3 (5.1.6), 5.2 EE SP1 (5.2.5)
• Component/s: Environments > Databases
• Labels: None
• Environment: SQL Server 2000

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.