What are the challenges you face when working across database platforms? Take the survey

Primary key error

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited June 20, 2003 1:02PM in Aardvark
Hi Larry,

Are there any problems updating issues on your system? Aardvark uses
this temporary table when it adds and updates issues through the UI as well.
If it's a database problem, you shouldn't be able to update any bugs,

Brian Donahue
Red Gate Technical Support

"Larry Paul" <DracoMagis@yahoo.com> wrote in message
> I have started receiving an email from Aarvark Errors with the following
> body:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
> constraint 'PK__#tmpChanges__0AA0F0D2'. Cannot insert duplicate key in
> object
> _________________________________________0000000EDF95'.
> Any ideas on how to clean this up. This also seems to kill the Aardvark
> Service as well after a while. I will get about 8 of these messages
> throughout the day, then the service dies. It has also stopped processing
> and rules or sending out user email notifications.
This discussion has been closed.