> On May 25, 10:10 pm, Baytech discussions.microsoft.com>
> wrote:

>> Hi,
>>
>> We have been having a problem with BCM2k7 for a while now where some of our
>> users would get pop ups whilst saving a new contact, saying stuff along the
>> lines of: "UPDATE permission denied on column 'OfficeLocation' of object
>> 'ContactMainTable', database 'MSBusinessContactManager'" etc..
>> This would be a random occurance and would not show up every time. But when
>> it did it would not allow the user to add contacts into the shared database.
>> Now one of our users is unable to add users while off line. What happens is
>> when the user is off line and adds a contact or two into his bcm2007 he is
>> unable to rejoin our shared database as the re-sync gets canceled mid way. So
>> the only way he can rejoin is to drop his current offline database and rejoin
>> with a servers copy (this kinda beats the point of going offline if you cant
>> do anything with it).
>> So I turned on bcm logging and took a look and this is what I found:
>>
>> [I] [11:30:06.2473360]BusinessLayer: DoSavePropertyBag
>> [E] [11:30:06.2785362]BusinessLayer: UPDATE permission denied on column
>> 'OfficeLocation' of object 'ContactMainTable', database
>> 'MSBusinessContactManager', schema 'dbo'.
>> [E] [11:30:06.2785362]BusinessLayer: at
>> System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean
>> breakConnection)
>> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
>> exception, Boolean breakConnection)
>> at
>> System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObje­ct
>> stateObj)
>> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
>> SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
>> bulkCopyHandler, TdsParserStateObject stateObj)
>> at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
>> at System.Data.SqlClient.SqlDataReader.get_MetaData()
>> at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
>> RunBehavior runBehavior, String resetOptionsString)
>> at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
>> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
>> at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
>> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
>> DbAsyncResult result)
>> at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
>> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
>> at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
>> behavior, String method)
>> at System.Data.SqlClient.SqlCommand.ExecuteReader()
>> at
>> Microsoft.BusinessSolutions.eCRM.BusinessLayer.BcmReadingTransaction.BcmTex­tCommandImpl.ExecuteReader()
>> at
>> Microsoft.BusinessSolutions.eCRM.BusinessLayer.BusinessEntity.DoSavePropert­yBag(BcmWritingTransaction transaction)
>> at Microsoft.BusinessSolutions.eCRM.BusinessLayer.BusinessEntity._Save()
>> [E] [11:30:06.2785362]BCMRes: Text:
>> [E] [11:30:06.2785362]BCMRes: Message:UPDATE permission denied on column
>> 'OfficeLocation' of object 'ContactMainTable', database
>> 'MSBusinessContactManager', schema 'dbo'.
>> [V] [11:30:06.2785362]Iris.Mapi.MessageStore: MAPIProp::SaveChanges:Return:
>> 0x1f5555e0, 0x80040a00
>> [V] [11:30:06.2785362]Iris.Mapi.MessageStore: IMAPIProp::GetLastError:Enter:
>> 0x1f5555e0
>> [V] [11:30:06.2785362]Iris.Mapi.MessageStore: MAPIProp::GetLastError:Return:
>> 0x1f5555e0, 0x00000000
>> [E] [11:30:06.2785362]Microsoft.Iris.ImportExportDataAccess: Exception
>> saving new account: UPDATE permission denied on column 'OfficeLocation' of
>> object 'ContactMainTable', database 'MSBusinessContactManager', schema 'dbo'.
>> [E] [11:30:06.2785362]Microsoft.Iris.ImportExportDataAccess: Text:Unable to
>> save the Account object, UPDATE permission denied on column 'OfficeLocation'
>> of object 'ContactMainTable', database 'MSBusinessContactManager', schema
>> 'dbo'..
>> [E] [11:30:06.2785362]Microsoft.Iris.ImportExportDataAccess: Message:UPDATE
>> permission denied on column 'OfficeLocation' of object 'ContactMainTable',
>> database 'MSBusinessContactManager', schema 'dbo'.
>> [E] [11:30:06.2785362]Microsoft.Iris.ImportExport: Unable to save the
>> Account object, UPDATE permission denied on column 'OfficeLocation' of object
>> 'ContactMainTable', database 'MSBusinessContactManager', schema 'dbo'..
>> [E] [11:30:06.2785362]Microsoft.Iris.ImportExport: ImportFatalException
>> during syncing, Unable to save the Account object, UPDATE permission denied
>> on column 'OfficeLocation' of object 'ContactMainTable', database
>> 'MSBusinessContactManager', schema 'dbo'..
>> [E] [11:30:06.2785362]BCMRes: Text:
>> [V] [11:30:06.2785362]Microsoft.BusinessSolutions.eCRM.DataSync:
>> SyncManager.Synchronize: Exit
>> [V] [11:30:06.2785362]Microsoft.BusinessSolutions.eCRM.DataSync:
>> DataSyncException in GoOnline, message is BCM Error #7009 :,stackTrace is
>> at
>> Microsoft.BusinessSolutions.eCRM.ImportExportBase.OutlookChangeListConsumer­.Microsoft.BusinessSolutions.eCRM.DataSync.IChangeListConsumer.ApplyChanges­(ChangeList changes, 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] [11:30:06.2785362]Microsoft.BusinessSolutions.eCRM.DataSync:
>> OfflineManager.DoCancelUpdateDuringGoOnline: Entry
>> [V] [11:30:06.3253365]Microsoft.BusinessSolutions.eCRM.DataSync:
>> SyncManager.SynchronizationScheduled: Entry
>> [V] [11:30:06.3253365]Microsoft.BusinessSolutions.eCRM.DataSync:
>> SyncManager.SynchronizationScheduled: Entry
>> [V] [11:30:06.3253365]Microsoft.BusinessSolutions.eCRM.DataSync:
>> SyncManager.SynchronizationScheduled: Entry
>> [V] [11:30:06.3253365]Microsoft.BusinessSolutions.eCRM.DataSync:
>> SyncManager.SynchronizationScheduled: Entry
>>
>> It is the same 'UPDATE permission denied' error everyone has getting
>> occasionally, but with some more details. So I had a look at the SQL server
>> that holds our DB. Our authenticate permissions to make changes to the BCM DB
>> are all fine (as it has a Domain Group that has authority to make changes and
>> everyone is on that group).
>> Also had a look at the SQL Server Profiler and took a snapshot of one of
>> these failed syncs. There is a lot of low level stuff happening so fiddling
>> with it wouldn't be wise. But something fundamental must have defiantly
>> messed itself up.
>>
>> If there is any advice or solution available it would be much appreciated
>> because this problem is making our BCM2007 unrealistic to work with.
>>
>> Thanks in advance
>> -Baytech

>
> Sound like GRANT UPDATE ON OfficeLocation.ContactMainTable TO
> db_SharedUsers might fix the problem.
>
> Did you upgrade this database from an earlier version of BCM?
> Did BCM create the database, or did you use the server Database Tool
> to create it?
>