Symptoms
After installing the EdgeSight Server and several EdgeSight Agents, the agents do not report up to the server even after waiting for more than 24 hours.
You receive an operational email that contains the following error message:
"EdgeSight - DataUpload: Error loading payload for instance “Number_Of_the_Instance” on server “SQL_Server_Name”
zpd_loader.RunCmdLineApp (WshShell.Exec) : Error executing command. The system cannot find the file specified."
The following error message regarding the EdgeSight RSSH process appears in the Event Log:
"Event ID: 1115
Source: RSSH
Description: Failed to enumerate all shares on local computer. NetApi Error: 2114."
The following two server pages display NO devices:
• Company Settings > Server > Device Management > Devices
• Server Settings > Configuration > Unmanaged Devices
Cause
The SQL Server Client Tools are not installed on the EdgeSight Web Server system. The EdgeSight RSSH process is trying to call the SQL bcp.exe process, which is not installed on the EdgeSight Web Server system.
The RSSH process is a critical process that processes all of the incoming payloads and alerts from the agents. If this process fails (as it does without access to bcp.exe), none of the agents can properly report up and are not visible in the EdgeSight Server Console.
This problem most commonly occurs when the EdgeSight Server configuration includes two separate systems—one acting as the SQL server and the other as the Internet Information Services (IIS) Web server. In this configuration, you must remember to install the SQL Server Client Tools on the IIS Web server.
Resolution
Install the SQL Server Management Tools on the EdgeSight Web Server system. This in turn installs the executable (bcp.exe) required by RSSH to process incoming agent performance payloads.
If you are running SQL Server 2005, install the following components:
• Workstation Components
• Books Online
• Development Tools
If you are running SQL Server 2000, install the following components:
• Client Add-on Tools (including SQL DMO)
More Information
CTX111082 – EdgeSight 4.2 Installation Guide
CTX111895 – SQL Server 2005 Required Components for EdgeSight
