Outlook 2007 BCM - Going online has been cancelled

Running Outlook 2007 with BCM on Windows XP Pro, using a central SQL Server database.  One of the clients has offline access enabled, and started getting a message saying "Going online has been cancelled, but you can continue to work in the offline database." whenever he'd try to connect.  I've enabled logging in Outlook, and the BCMLog_V3.log file includes the following text:

[E] [23:34:20.3818027]BCMRes: Text:Duplicate GUID Found.
[E] [23:34:20.3818027]Microsoft.Iris.ImportExport: Duplicate GUID Found.
[E] [23:34:20.3818027]Microsoft.Iris.ImportExport: Duplicate GUID Found.
[V] [23:34:20.3818027]Microsoft.BusinessSolutions.eCRM.DataSync: SyncManager.Synchronize: Exit
[V] [23:34:20.3818027]Microsoft.BusinessSolutions.eCRM.DataSync: IrisException in GoOnline, message is Duplicate GUID Found.,stackTrace is    at Microsoft.BusinessSolutions.eCRM.ImportExportBase.ExportManager.DoExportAll(ExcludeNodes en, EventsManager eventsMgr)
   at Microsoft.BusinessSolutions.eCRM.ImportExportBase.SqlChangeListProducer.Microsoft.BusinessSolutions.eCRM.DataSync.IChangeListProducer.GetChanges(ChangeList cl, EventsManager eventsMgr)
   at Microsoft.BusinessSolutions.eCRM.DataSync.SyncManager.Synchronize(SyncPoint sp, IContext producerContext, IContext consumerContext, SyncLog syncLog)
   at Microsoft.BusinessSolutions.eCRM.DataSync.SyncManager.Synchronize(String outlookProfileName, String syncPointName, IContext producerContext, IContext consumerContext)
   at Microsoft.BusinessSolutions.eCRM.DataSync.OfflineManager.GoOnline(IContext context)
[V] [23:34:20.3818027]Microsoft.BusinessSolutions.eCRM.DataSync: OfflineManager.DoCancelUpdateDuringGoOnline: Entry
[V] [23:34:20.3818027]Microsoft.BusinessSolutions.eCRM.DataSync: OfflineManager.DoCancelUpdateDuringGoOnline: Exit

The duplicate GUID seems to be my problem, but I'm not sure where to go from here.  Is there any way to tell which table contains the records with duplicate GUID, or anywhere else to get more details?

Thanks very much!
ccmadminsAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

HelHolCommented:
I have the same problem.  I work remotely and when I try to 'work online' with the BCM I get the error "Going online has been cancelled, but you can continue to work in the offline database".  Does anyone have any ideas?
ccmadminsAuthor Commented:
I gave up - just dropped the user's offline database and recreated it, and the problem is gone.  Of course, he has to re-enter whatever he'd put in while he was stuck offline....

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Outlook

From novice to tech pro — start learning today.