Daily Alert from Performance Warehouse: Exception: ERROR: canceling statement due to user request
Hello,
I am getting an alert from my Performance Warehouse daily with the following exception:
Exception: ERROR: canceling statement due to user request
Has anyone ever run into this? I cannot seem to find it on the forums or in the documentation. Any clue how to fix this?
Thanks,
Annmarie
Annmarie,
It's possible this is being caused by running backups on the PW database against tables that don't need to be backed up. Here's some suggestions:
- Do not backup the tables measurement_temp1 and measurement_temp2 - these tables only contains data from max 30 min. These are the tables being used to write the data from DT server to the DB, after 30 min, the data is moved to the measurement_high table
- Try to reduce the priority or resource level of the backup (if possible), so that the normal DB operations to not have such a big delay
If this does not resolve your issue I suggest you open a support case and be sure to include a support archive. There is likely additional messages in the server.0.0.log file indicating further useful information.
Joe Hoffman
