Problem:

Why do some advanced queries fail after upgrading from SCIM 3.x to 4.x?

Resolution:

ANSWER
----------------------------------
It is possible you may see errors such as:

Syntax error converting datetime from character string. Incorrect syntax near `,?,

after upgrading to SCIM 4.x from earlier versions.

During the upgrade from SCIM 3.x a query transformer takes the query expression from one model and tries to intelligently rewrite it to another. Occasionally the transformer will be unable to convert advanced SQL queries, or those which use placeholders.

If this occurs it is necessary to identify the queries affected and manually rewrite / recreate the query.

See also: What should I consider when upgrading from Issue Manager 3.x to 4.x?