Filters allow raw SQL query as a filter definition. If query contains non standard SELECT (e.g. EXECUTE stored_procedure, WITH common_table_expression, etc. ), delta membership update may fail with a warning and full update runs instead.
Unexpected exception has occurred during the execution of the SQL for delta collection update for 'New Filter' (4207e326-6cd5-46cf-b7bb-3fa6fa0a3e4f).
Full update is run instead.
Incorrect syntax near the keyword 'EXEC'.
[System.Data.SqlClient.SqlException @ .Net SqlClient Data Provider]
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
ITMS 7.5 SP1
Product limitation.
This issue has been addressed under ITMS 8.0 Release.
This product limitation for customers using ITMS 7.5 SP1 HF5 has been addressed by hot fix attached to this article. See below for more details:
APPLICABILITY REQUIREMENT
ITMS 7.5 SP1 HF5
HOW TO INSTALL THIS POINTFIX
On Server Side:-
THIS HOTFIX HAS THE FOLLOWING KNOWN ISSUES:
None.
HOW TO UNINSTALL THIS POINTFIX
On Server Side:-