An error occurs when purging Application Metering data

Article:TECH24208

Created: 2005-08-31

Updated: 2006-09-07

Article URL http://www.symantec.com/docs/TECH24208

Article Type
Technical Solution

Languages

Show all

Problem

When purging Application Metering data, you receive the following error:

"An error occured doing data purge. Failed to perform data purge on the Aex AM Monthly Summary data class table. View or function 'Inv_Aex_AM_Monthly_Summary' is not updatable because the modification affects multiple base tables".

Environment

Application Metering 6.0.1024
Contract Management (either currently installed or previously installed and uninstalled)

Cause

Contract Management split the Aex_AM_Monthly_Summary table into two tables for data normalization. With this, a table was created with a new name, and a view with the name Aex_AM_Monthly_Summary.

Because you cannot delete data from the view, the error message occurs.

Solution

NEW RESOLUTION
This issue has been resolved in the Application Metering 6.1.26 version that is available for download.

OLD RESOLUTION
This is scheduled to be fixed in the next release of Application Metering which is currently scheduled to be released in the fourth quarter of 2005.

Until this is released, you can manually purge data with the following SQL query:

Replace <X> w/# of months

DELETE FROM [Inv_AeX_AM_Monthly_Summary_spt] WHERE DATEDIFF(mm, [Last Start], GetDate()) >= <X>

Legacy ID

2894