Hi,

I'm working with DNN 4.4.0.

This morning I solved my hosting issues with synchronising dev DB and Remote Prod. DB with Red Gate's Data Compare.

As the afternoon progressed I came across an intersting one.  I had been inserting html and links on the dev. install and periodically updating the remote prod. to test my best new tool... :-)

After an hour or so I hit a roadblock on db synchronization.

The tables that is causing me an issue is : dbo.SearchItemWord

The error message basically states: Violation of Unique Key Constraint 'IX_SearchItemWord'. Cannot insert duplicate key in object 'dbo.SearchItemWord.

Is it possible to flush the table in question?

Any ideas what I can do to resolve the synch situation?

Thanks for any help.

Colin

I've searched high and low for this... does anyone actually know what causes this exception and how to stop it happening? I've cleared my tables over and over but it keeps coming back. There's usually some Transaction Process deadlocks around the same time.

What is actually happening when this error happens?

Rob

I'm afraid I never really figured out any of that, but what I can state is that moving to a VPS helped and also that recent DNN upgrades seemed to reduce the appearance of a variety of errors. I'm not getting all those process deadlocks like I used to. I spent some time in Enterprise Manager looking at all the threads on the server and I believe that other sites sharing the db may well be part of the issue.

Oh.. one thing that might help is that I altered all the scheduler timings to reduce the likelihood that they start at the same time.. (Though surely that can't be the actual cause of a deadlock in a modern computing system?)

I set the standard scheduled items up like this:

The big one was to change the search engine to just under once per day, which is plenty in my situation. I can't specifically say if it works (because of the already mentioned updates and upgrades I also made at the time) but maybe it helps.

Currently I only have one fairly regular grouping of errors.. the same old:

InnerException: Add failed. Duplicate key value supplied.

Message: System.ArgumentException: Add failed. Duplicate key value supplied. at Microsoft.VisualBasic.Collection.Add(Object Item, String Key, Object Before, Object After) at DotNetNuke.Services.Scheduling.DNNScheduling.Scheduler.CoreScheduler.AddToScheduleInProgress(ScheduleHistoryItem objScheduleHistoryItem) at DotNetNuke.Services.Scheduling.DNNScheduling.Scheduler.CoreScheduler.WorkStarted(SchedulerClient& objSchedulerClient)

I'd love to know if the error has any relevance or not.

I'm now also more able to sift out meaningless errors than I used to be, so even though there's often a lot of red in there, I know why it's there.

That's about everything I can say about it really.

Regards,
Rob