Return
-
Title
Alarm error after upgrade: "Collection Agent Jobs Failed Internal limit of 10000." -
Description
The following error occurs after upgrade of Spotlight:
"Getting Monitored Server - SQL Server Collection Execution Failure - Collection Agent Jobs Failed Internal limit of 10000."
-
Resolution
Spotlight versions 11.x and below:1. Go to default installation of Spotlight Diagnostic Server: C:\Program Files\Quest Software\Diagnostic Server\Agent\bin folder2. Copy SpotlightDiagnosticServer.ini file to another path outside of here like you Desktop. Important not to rename or make a backup in the same folder.3. Open file with Notepad.4. Change this line and increase it's value, i.e. 30000:"-Dcom.quest.adk.rowLimit=10000"5. Save file and close6. Restart Diagnostic Server servicesSpotlight version 12.0 and above:1. Go to default installation of Spotlight Diagnostic Server: C:\Program Files\Quest Software\Diagnostic Server\Agent\conf folder2. Copy DiagnosticServer.Properties file to another path outside of here like you Desktop. Important not to rename or make a backup in the same folder.3. Open file with Notepad.4. Change this line and increase it's value, i.e. 30000:"-Dcom.quest.adk.rowLimit=10000"5. Save file and close6. Restart Diagnostic Server services