Problem Updating with Merge Replication

Paul Chase — Wed, 31 May 2006 08:31:33 GMT

I have set up Merge Replication in Sql 2005. I am able to inset a record without any issues however when I update I get the following error. I am using a guid coluumn as my PK. Any Ideas?

BusinessLayerException
An error occurred while saving an the data to the server.
DataLayerSavingException
Updating columns with the rowguidcol property is not allowed.
The transaction ended in the trigger. The batch has been aborted.
SqlException
Updating columns with the rowguidcol property is not allowed.
The transaction ended in the trigger. The batch has been aborted.

Source : MicroFour StrataFrame Business

Stack Trace:
   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(TdsParserStateObject 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 MicroFour.StrataFrame.Data.SqlDataSourceItem.UpdateRow(QueryInformation QueryInfo, DataRow RowToUpdate, ConcurrencyExceptionHandler ConcurrencyHandler, AddRowErrorHandler RowErrorHandler, Boolean RecreateCommand)
   at MicroFour.StrataFrame.Data.DbDataSourceItem.UpdateRow(QueryInformation QueryInfo, DataRow RowToUpdate, ConcurrencyExceptionHandler ConcurrencyHandler, AddRowErrorHandler RowErrorHandler)
   at MicroFour.StrataFrame.Data.DataLayer.UpdateDataTableThread(Object ThreadParams)
   at MicroFour.StrataFrame.Data.DataLayer.SaveByForm(DataTable TableToSave, Boolean Transactional, String TransactionKey)
   at MicroFour.StrataFrame.Business.BusinessLayer.SaveByForm(Boolean Transactional, String TransactionKey)
   at MicroFour.StrataFrame.UI.Windows.Forms.BaseForm.Save(Boolean Transactional, String TransactionKey)
   at MicroFour.StrataFrame.UI.Windows.Forms.BaseForm.Save()
   at MicroFour.StrataFrame.UI.Windows.Forms.MaintenanceFormToolStrip.cmdSave_Click(Object sender, EventArgs e)
   at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
   at System.Windows.Forms.ToolStripButton.OnClick(EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
   at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
   at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
   at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.ToolStrip.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

RE: Problem Updating with Merge Replication

Paul Chase — Wed, 31 May 2006 08:31:33 GMT

Ben,

Were you able to include this change into the latest build?

thanks

Paul

RE: Problem Updating with Merge Replication

StrataFrame Team — Tue, 09 May 2006 15:51:57 GMT

No problem, Paul.

RE: Problem Updating with Merge Replication

Paul Chase — Tue, 09 May 2006 14:58:28 GMT

Thanks Ben

RE: Problem Updating with Merge Replication

StrataFrame Team — Tue, 09 May 2006 13:50:41 GMT

Well, right now, guid pks are configured to allow you to change their values, hence why we have parameters for PK and PK_ORG (_ORG for "original"). I'll looking at modifying the business objects to allow you to exclude fields from the updates (we some more users that need the same functionality), which won't be a drastic change, and will likely be included with the update next week (when we release the DevExpress wrapper, BOMapper changes, etc.).

RE: Problem Updating with Merge Replication

Paul Chase — Tue, 09 May 2006 13:08:39 GMT

The error comes from the update statement containing the guid field, this makes sense as you would not want this be able to change as it would really mess up replication.

For instance Update mytable set guidfld = 'whatever it was' , datafld = 1 where guidfld = 'whateverit was' would fail however, update mytable set datafld = 1 where guidfld = 'whateverit was' would be ok .

What would be the best way to handle this from Strataframe?

RE: Problem Updating with Merge Replication

Paul Chase — Tue, 09 May 2006 10:54:55 GMT

The Pk column.I figured since I needed it for replication why not use it as a PK

RE: Problem Updating with Merge Replication

StrataFrame Team — Tue, 09 May 2006 09:57:47 GMT

Does the table have another guid that the replication is using for synchronization, or is the pk column the guid column that is being used for replication?

StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Problem Updating with Merge Replication

Problem Updating with Merge Replication

RE: Problem Updating with Merge Replication

RE: Problem Updating with Merge Replication

RE: Problem Updating with Merge Replication

RE: Problem Updating with Merge Replication

RE: Problem Updating with Merge Replication

RE: Problem Updating with Merge Replication

RE: Problem Updating with Merge Replication