Primary key error
Brian Donahue
Posts: 6,590 Bronze 1
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,
either.
Brian Donahue
Red Gate Technical Support
"Larry Paul" <DracoMagis@yahoo.com> wrote in message
news:u2WX2pnNDHA.1176@server53...
> 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
>
'#tmpChanges________________________________________________________________
> _________________________________________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.
>
>
>
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,
either.
Brian Donahue
Red Gate Technical Support
"Larry Paul" <DracoMagis@yahoo.com> wrote in message
news:u2WX2pnNDHA.1176@server53...
> 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
>
'#tmpChanges________________________________________________________________
> _________________________________________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.