Inventory Collection fails with error -2147217900 - "Syntax error in string in query expression"
search cancel

Inventory Collection fails with error -2147217900 - "Syntax error in string in query expression"

book

Article ID: 339494

calendar_today

Updated On:

Products

VMware

Issue/Introduction

Inventory collection fails with an error during application inventory collection.
The following errors may appear:

  • ERROR: An unexpected error occurred! Module = vcpSysInv Function = DescAppOSDB.Modify:0 Source = Microsoft JET Database Engine Error = Syntax error in string in query expression 'DAPP_Producer='e-merge GmbH' AND DAPP_Name='WinAce Archiver' AND DAPP_Type='App' AND DAPP_DisplayVersion='2.65'.(-2147217900:0:5003000)
  • ERROR: An unexpected error occurred! Module = vcpSysInv Function = DescAppOSDB.Modify:0 Source = Microsoft JET Database Engine Error = Syntax error in string in query expression 'DAPP_Producer='Symantec' AND DAPP_Name='Symantec pcAnywhere' AND DAPP_Type='App' AND DAPP_DisplayVersion='11.0.1'.(-2147217900:0:5003000)
  • ERROR: An unexpected error occurred! Module = vcpSysInv Function = DescAppOSDB.Modify:0 Source = Microsoft JET Database Engine Error = Syntax error in string in query expression 'DAPP_Producer='Support.com, Inc.' AND DAPP_Name='Support.com Server - V56'.(-2147217900:0:5003000)


Environment

VMware Capacity Planner 2.5.x
VMware Capacity Planner 2.1.x

Resolution

This problem happens if an erroneous extra 'line feed' character is appended to the end of the string in the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\<application_name_or_GUID>\DisplayVersion . You encounter this error in Capacity Planner during inventory collection due to an issue in how the data is handled by the Collector.

To correct this issue, upgrade to Capacity Planner 2.6 or higher.