Submit a ticketCall us

Announcing NPM 12.2
With NPM 12.2 you can monitor your Cisco ASA firewalls, to monitor VPN tunnels for basic visibility and troubleshooting tunnels. NPM 12.2 also uses the SolarWinds Orion Installer so you can easily install and upgrade one or more Orion Platform products simultaneously.
See new features and improvements.

Home > Success Center > Server & Application Monitor (SAM) > AppInsight for IIS - Site monitor displays an error Incorrect syntax near ','

AppInsight for IIS - Site monitor displays an error Incorrect syntax near ','

Created by Wendell Bazile, last modified by Rodim Suarez on Jan 19, 2017

Views: 17 Votes: 0 Revisions: 4

Updated January 20, 2017

Overview

When polling an IIS Web Server using AppInsight for IIS, the following error is thrown when attempting to poll the Log Parsing Monitor:

Unexpected error occurred. Error while processing component ABIM:xxx,
error details: Incorrect syntax near ','.

Environment

SAM 6.2 and later

Cause 

The cause of this issue is due to the Logging Level on the website not having all the required fields selected.

Resolution

  1. Open a Remote Desktop to the target Web Server.
  2. Open IIS Manager with the Server Manager OR via Run > inetmgr.
  3. Select the affected web site in the left-hand pane.
  4. Double-click "Logging" in the right-hand pane.
  5. Click Select Fields.
  6. Ensure all of the following fields are selected:
    1. Date
    2. Time
    3. URI Stem
    4. URI Query
    5. Method
    6. Client IP Address
    7. Time Taken
  7. Click OK.
  8. Click Apply in the right hand pane under Actions.
  9. AppInsight for IIS should now be able to poll correctly. It may take a day to poll correctly depending on the Log File Rollover settings in IIS.

 

Last modified
17:38, 19 Jan 2017

Tags

Classifications

Public