We are trying to do basic reporting off of who is running what reports and continually get this error message. Any clue ?
A database error occurred. The database error text is: [Microsoft][ODBC Sql Server Drive][SQL Server] Transaction (process ID 69) was deadlocked on lock / communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction (WIS 10901)
pullesb 
(BOB member since 2006-10-02)
Did you change your log ‘write back’ timings i.e. Events per file for Auditing etc
MikeD 
(BOB member since 2002-06-18)
Where would I find these and what settings would you recommend ?
pullesb (BOB member since 2006-10-02)
They are in the registry. HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.5 (or 12.0)\CMS\Instances<servername>.cms.
AuditBatchSize - number of text files to load during each run and
AuditInterval - minutes between polling files
We had the same problem so we resolved it using two tactics. 1. we only keep 7 months of data in the audit database and 2. set the auditinterval to 1 (minute). This seems counter-intuitive as the deadlocking occurs between the running report and the audit file polling process but it works!
tmcd (BOB member since 2005-10-02)
Are there any BO documents about the Acitivty universe out there?
lofty77 
(BOB member since 2009-06-09)