Created On: 21 October 2010
Problem:
What is the best process for clearing out the activity log for Modernization Workbench when using a SQL Server repository?
Resolution:
The following query may be used to clean the activity log for SQL Server repositories:
CREATE OR REPLACE PROCEDURE Anchor1.DelActivityLog()
as
begin
DELETE FROM ActivityLog
WHERE "ID" NOT IN
(SELECT DISTINCT "LogRef"
FROM ActivityLogRecent);
Commit;
EXCEPTION WHEN OTHERS THEN NULL;
end;
CREATE OR REPLACE PROCEDURE Anchor1.DelActivityLog()
as
begin
DELETE FROM ActivityLog
WHERE "ID" NOT IN
(SELECT DISTINCT "LogRef"
FROM ActivityLogRecent);
Commit;
EXCEPTION WHEN OTHERS THEN NULL;
end;
Incident #2473671
Old KB# 32171
#EnterpriseAnalyzer
#SupportTip
#Activitylog
