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.
- In SQL Management Studio, connect to the AgilePoint database.
- 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]