Failed to replicate row with geomentry column
in [Replication]
|
Prev: Merge replication: syncing data from the subscriber to the publis
Next: Replication from 2005 to 2000 fails because of CREATE TYPE command
From: fw190 on 18 Mar 2010 12:22 Did you ever get a reply to this question ? I'm seeing the same problem Sergii Kryshtop wrote: Failed to replicate row with geomentry column 27-Jul-09 I have a problem with replicating table that have 1 geometry column. Environment: 1. Publisher - MS SQL Server 2008 Standard 2. Subscriber - MS SQL Server 2008 Express (or MS SQL Server 2008 Standard) Issue description: 1) I can create Publication and Subscription 2) Subscriber can apply snapshot 3) Subscriber can replicate Delete operation and Update. 4) Once Merge Agent need to insert new record (not from snapshot) - Replication error occures: The Merge Agent failed because the schema of the article at the Publisher does not match the schema of the article at the Subscriber. This can occur when there are pending DDL changes waiting to be applied at the Subscriber. Restart the Merge Agent to apply the DDL changes and synchronize the subscription. Error converting data type varchar to geometry. (Quelle: MSSQLServer, Fehlernummer: 8114) Using SQL Profiler I found that this error caused by proc "dbo.MSmerge_ins_sp_[ArticleGUID]". SP inserts empty string '' to a geometry parameter (column). I am using SQL Server 2008 compatibility level on both databases and in the Publication properties. The only way that I found to replicate INSERT operation is to convert geometry to varbinary(max) on Subscriber. But why I cannot replicate new SQL Server 2008 data type between two SQL Server 2008 servers? Previous Posts In This Thread: On Monday, July 27, 2009 6:20 AM Sergii Kryshtop wrote: Failed to replicate row with geomentry column I have a problem with replicating table that have 1 geometry column. Environment: 1. Publisher - MS SQL Server 2008 Standard 2. Subscriber - MS SQL Server 2008 Express (or MS SQL Server 2008 Standard) Issue description: 1) I can create Publication and Subscription 2) Subscriber can apply snapshot 3) Subscriber can replicate Delete operation and Update. 4) Once Merge Agent need to insert new record (not from snapshot) - Replication error occures: The Merge Agent failed because the schema of the article at the Publisher does not match the schema of the article at the Subscriber. This can occur when there are pending DDL changes waiting to be applied at the Subscriber. Restart the Merge Agent to apply the DDL changes and synchronize the subscription. Error converting data type varchar to geometry. (Quelle: MSSQLServer, Fehlernummer: 8114) Using SQL Profiler I found that this error caused by proc "dbo.MSmerge_ins_sp_[ArticleGUID]". SP inserts empty string '' to a geometry parameter (column). I am using SQL Server 2008 compatibility level on both databases and in the Publication properties. The only way that I found to replicate INSERT operation is to convert geometry to varbinary(max) on Subscriber. But why I cannot replicate new SQL Server 2008 data type between two SQL Server 2008 servers? Submitted via EggHeadCafe - Software Developer Portal of Choice DataContractSerializer Basics http://www.eggheadcafe.com/tutorials/aspnet/ad947ce6-cd3e-4647-b69c-94d2f3b1b265/datacontractserializer-ba.aspx |