Crystal Enterprise 9 Cluster Shutdown

[ivankwk]

Hi all,

I've got 2 CE9 APS Clustered together in a two machine environment. The cluster is running on a MS SQL Server 2000 Database with a single Input and Output File Repository Server.

What i'm facing right now is every morning there seems to be a deadlock in SQL Server 2000 DB which shuts down the main APS.

The error message is as below:
13/11/2007 05:31:30 Crystal_CrystalAPS Error Database 33301 N/A CRYSTAL Info APS database connection is broken. Trying 3 time(s) to re-establish connection. Please check Info database machine status.
13/11/2007 05:31:30 Crystal_CrystalAPS Error Database 33300 N/A CRYSTAL Database access error. Reason [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 53) was deadlocked on {lock} resources with another process

Any idea why this is happening? I have checked the timing on both machines and they are the same.

Cheers,
Ivan

 

[groggle]

A couple of thoughts are:

1: Have you set the TempDB on the SQL Server database to automatically grow?

2: Is there a backup job occurring on this database at this time that is putting a lock on the database?

The problem is most likely at the SQL Server database end. Something is putting a lock on the database at that time of day.