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|
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".
Application Metering 6.0.1024
Contract Management (either currently installed or previously installed and uninstalled)
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.
This issue has been resolved in the Application Metering 6.1.26 version that is available for download.
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>
Article URL http://www.symantec.com/docs/TECH24208