While Exporting Archive UCM works best with case-insensitive MSSQL server

Error:

 [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid column name 'dRevClassId'. Unable to create the result set for query 'SELECT DISTINCT Revisions.dRevClassID

Cause:

It usaually occurs when using an MS SQL Server database.

UCM works best with case-insensitive MSSQL server, not with case-sensitive MS SQL Server.

Solution:

Check the output of below query:

SELECT name, collation_name
FROM sys.databases
WHERE name = 'test2'   -- put your database name here

You should see a result like this SQL_Latin1_General_CP1_CS_AS


The substring CS denotes case sensitivity and CI denotes case insensitive.

So if the above query result showing you are using case sensitive (CS) in db then use the following SQL command to alter your db collate:

ALTER DATABASE mds COLLATE SQL_Latin1_General_CP1_CI_AS
For example:

ALTER DATABASE test ----> put your database name here
   COLLATE Latin1_General_CI_AS   -----> replace with whatever collation you need. In this case you want CI.

So if your db is CS then alter your db to CI for case insensitive then retest the issue. Then try to executive the query again.