Environment
- App Control Console: 7.x - 8.x
Symptoms
- Searching for specific files, or filtering for different criteria results in a "Database timeout expired" error in Console.
- Example message from PHPErrors.log file:
API Error from page 502: GET parity.server.com/api/bit9platform/restricted/fileInstanceAll/ with params {"sort":"id DESC","q":["fileName:msiexec.exe"],"expand":["computerId","fileInstanceGroupId","fileInstanceId","fileCatalogId"],"offset":"0","limit":76} with options {"81":0,"64":0,"19913":1,"42":0,"156":61000,"10023":"[removed from logging]","10022":"[removed from logging]","10015":"[removed from logging]"} returned http code 408 and result in 60.685168027878 seconds
Cause
Query to database ran longer than the default timeout value specified by 'API_TimeoutS' parameter.
Resolution
- Open browser window
- Go to https://<ServerName>/shepherd_config.php
- Increase 'API_TimeoutS' parameter to 120 (Default=60)
- Open CMD prompt as administrator and run iisreset
Additional Notes
- Avoid setting 'API_TimeoutS' parameter higher than 120 as this could cause severe performance issues with Console