Incorrect syntax error during delta membership update: Incorrect syntax near the keyword 'EXEC'.

Products

• IT Management Suite

Issue/Introduction

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)

Environment

ITMS 7.5 SP1

Cause

Product limitation.

Resolution

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:-

1. Extract files from the archive to NS machine. Make sure PointFix is not extracted to Altiris directory (or any subfolder to it).  
2. Execute PFInstaller.exe file with administrative privileges (right-click > Run as administrator).If UAC is enabled then accept UAC if prompted. Select ‘Install Files’ option.
3. Old files will be automatically backuped to the ‘Backup’ and ‘adds-Backup’ folders at the same location where PFInstaller is and replaced with the new ones. Log-file Log.txt will be created at the same location where PFInstaller is.
4. Close PFInstaller window.

 

THIS HOTFIX HAS THE FOLLOWING KNOWN ISSUES:
None.

HOW TO UNINSTALL THIS POINTFIX

On Server Side:-

1. Make sure that Backup and ‘adds-Backup’ subfolders is located in PFinstaller directory
2. Run PFinstaller with administrative privileges (right-click > Run as administrator). If UAC is enabled then accept UAC if prompted. Select ‘Uninstall Files’ option.
   Old files will be replaced from ‘Backup’ and ‘adds-Backup’ folders located at the same location where PFinstaller is. NS services should be started automatically. 
3. Close PFinstaller window.