I Get an Invalid Object Error

Symptoms

When some AgilePoint NX components access the database while running or during installation, an invalid object error appears. For example, when you access Shadowing and Monitoring from Manage Center, the following error appears:

Invalid object name WF_SPOPERATIONS

Cause

This error occurs because the AgilePoint database is set to case sensitive (CS) collation mode, but AgilePoint requires the database collation to be set to case insensitive (CI) mode.

Resolution

To change the collation to CI mode, do the following.

  1. In SQL Management Studio, connect to the AgilePoint database.
  2. Enter the following SQL Query to change the database collation:

    ALTER DATABASE [database name] COLLATE [collation type]

    Example:

    ALTER DATABASE APDB COLLATE Latin1_General_CI_AS

To verify the collation type, run the following SQL query:
SELECT name, collation_name
FROM sys.databases
WHERE name = [database name]

More Information