Replication: If sql_variant column includes a value with new datetime type, the value is replicated as base type nvarchar even if schema option 0x200000000 is not set

Problem: If sql_variant column includes a value with new datetime type, the value is replicated as base type nvarchar even if schema option 0x200000000 is not set during the application of the SNAPSHOT (only). After the snapshot has been applied, if you execute the command to verify the property of the sql_variant column: SELECT SQL_VARIANT_PROPERTY(column_name,’BaseType’),…

0

Replication: XML data loss occurs when Merge agent fails with Violation of Foreign Key

Problem: Consider the following scenario: You use a merge publication operation to replicate XML data in Microsoft SQL Server 2005, in Microsoft SQL Server 2008, or in Microsoft SQL Server 2008 R2. A foreign key violation error occurs in the same merge replication batch. In this scenario, you may find the merge replication fails and…

0

Replication: Error "You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels" generated when altering published table columns

Problem:   Error “You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels” generated when altering published table columns in a transactional replication. Cause:   Unable to alter columns on Published database if using any isolation level besides the READ COMMITTED or REPEATABLE READ isolation level. READPAST hint is not…

0

Replication: Fake Conflicts?

One problem that is hard to resolve / understand is fake conflicts within a merge replication topology.   Looking at a scenario in which fake conflicts were occurring, we saw that following:   Our affected subscriber is synchronizing with 2 publications that have retention=14. The publisher also has an additional publication with retention=30. All the…

0

Note to all Readers

Seems like there was an issue with the comments for this blog – I wasn’t getting notified and hence never got to respond. My apologies to all those that commented and never got a reply. If you do have a comment, please do not hesitate to e-mail me by selecting “e-mail Blog Author” Thanks!  

0

REPLICATION: My distribution agent generates a dump when replicating with my Oracle Subscriber

PROBLEM: I have a SQL Server 2005 replicating with an Oracle 11 subscriber. After installing the OLEDB driver for Oracle 11, a minidump is created every time the distributor tries to connect to Oracle: Distrib.exe crashes with STACK_OVERFLOW exception.  The issue occurs while initializing the subscriber therefore as soon as it tries to connect to…

0

Replication: Unable to Synchronize subscribers via Web Synchronization

Problem: The upload message to be sent to Publisher ‘XXX’ is being generated The merge process is using Exchange ID ‘XXXXX’ for this web synchronization session. No data needed to be merged. Request message generated, now making it ready for upload. Upload request size is 1024 bytes. Uploaded a total of 1 chunks. The request…

0