When a user selects the Recent Edits (RED) icon, it just shows a flashlight looking and the DM becomes unresponsive.
After a good month with OpenText support trying various things to narrow down the problem, we finally determine its due to excessive activity by the user. They had so many entries in the table ACTIVITYLOG it surpassed the the size of a variable used in their program. Logging in as DOCSADM using the SQL Analyzer connected to the SQL server, we ran some SQL commands to move these activity logs to a bogus user. Here’s sample SQL commands that changes the all activitylog entries to a bogus system id of 1000001 where the typist’s System ID is 360035. You obtain the user’s system id by looking in the PEOPLE table.
update activitylog set typist = '1000001' where typist = '360035'
select * from activitylog where typist = ‘1000001’
