SQL Server Home
Violation of PRIMARY KEY constraint 'PK_ScheduleID'. Cannot insert duplicate key in object 'dbo.Schedule'.
as Won't Fix
1/28/2009 10:38:29 PM
User(s) can reproduce this bug
I've got a SQL 2005 Reporting Services database that has been migrated from SQL 2000. On creating a custom subscription on any report i get the following message:
"Violation of PRIMARY KEY constraint 'PK_ScheduleID'. Cannot insert duplicate key in object 'dbo.Schedule'. The statement has been terminated." Shared subscriptions do not give this error. I have deleted all subscriptions, effectively emptying the table, yet i still get the same error? I can get this error on the console as 'sa', 'admin' or a 'user' All the columns concerned seem to be uniqueidentifier type. Any ideas on why this error is occurring?? or how to re-seed/reset this GUID, given it's not an identity??? or how i can trap the details of this insert (wizard) to track down the duplicate??? I cannot find this issue reported anywhere. All other RS functions work fine??
SQL Server 2005 SP2 - Standard Edition
Windows Server 2003 (all Win32 editions)
Operating System Language
Steps to Reproduce
Migrate DB from SQL2000 to SQL 2005
Create a subscription using custom schedule from SSMS or 'http://<servername>/Reports' interface
"Violation of PRIMARY KEY constraint 'PK_ScheduleID'. Cannot insert duplicate key in object 'dbo.Schedule'. The statement has been terminated."
Subscription should be created
to post a comment.
Please enter a comment.
on 8/17/2010 at 4:22 PM
To work around the problem, you may manually delete the offending row in table. To find out which row to delete, use SQL Profiler to trace the statements sent from RS server to the RS catalog DB server.
After investigation, it is not clear what caused the system to get into this state. If you have addition information, please provide it to us.
on 2/24/2009 at 9:37 AM
Thank you for filing this issue. We have assigned it to a developer to investigate.
to post a workaround.
Please enter a workaround.
© 2014 Microsoft