Troubleshooting / I Need Help with AgilePoint Installation |
When some AgilePoint components access the database while running or during installation, an invalid object error appears. For example, when you access Shadowing and Monitoring from Enterprise Manager, the following error appears:
Invalid object name WF_SPOPERATIONS
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.
To change the collation to CI mode, do the following.
ALTER DATABASE [database name] COLLATE [collation type]
Example:
ALTER DATABASE APDB COLLATE Latin1_General_CI_AS
SELECT name, collation_name FROM sys.databases WHERE name=[database name]