Appinternals Desktop Console displays 'Status 202' database exception when generating metric data

Categories:
Solution Number:
S28330
Last Modified:
2016-09-07
Issue

The desktop console displays the following error when opening metric data:

The following error may be found in webservice.txt - 

com.altaworks.smp.data.reader.RollupHistoricDataReader : Can't get to PDR com.altaworks.smp.client.AWDBException: [AWDBResultSet:executePreparedUpdated()][AWDBinternalAccess:executeUpdate()]SQLState: 40001

Message:  Transaction (Process ID 77) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction

This problem does not show an out of memory error in the logs, however is affected by the amount of memory allocated to the webservice process.

Solution

1. Stop the SMP service

2 Go to "<SMP install folder>\hedzup\smp\agents\webservice.properties"  

3.  Increase the Xmx to double the current value,  or max 1536m.

4.  Start the smp service and test 

 

Environment

 Appinternals 9

Attachments
NOTICE: Riverbed® product names have changed. Please refer to the Product List for a complete list of product names.
Can't find an answer? Create a case