Microsoft KB Archive/328314

Knowledge Base

FIX: Cannot upload null values in Sql_variant data type by using SQL Server CE merge replication

Article ID: 328314

Article Last Modified on 9/9/2005

---

APPLIES TO

• Microsoft SQL Server 2000 Windows CE Edition 1.1
• Microsoft SQL Server 2000 Windows CE Edition 2.0

---

This article was previously published under Q328314

Bug #: 4912 (SSCE)

SYMPTOMS

A Microsoft SQL Server 2000 Windows CE Edition Subscriber produces the following error message when you invoke the merge process:

Source: Microsoft SQL Server 2000 Windows CE Edition
Number: 80004005
NativeError: 29006
Description: A call to SQL Server Reconciler failed
                    

You also receive the following additional error messages:

Source: Merge Replication Provider
Number: 80045022
NativeError: 0
Description: The process could not deliver inserts at the 'publisher'
                    

-and-

Source: 'Publisher Server Name'
Number: 0
NativeError: 0
Description: Program type out of range
                    

CAUSE

The error messages listed in the "Symptoms" section may occur if you insert a NULL value into a SQL_VARIANT data type column on the SQL Server CE subscriber, and you then invoke the merge process to synchronize the subscription with the publisher.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce the Behavior

To reproduce the behavior, follow these steps:

1. On a SQL Server 2000 publisher, create a table with the following schema and configure a merge publication on it:

   CREATE TABLE [dbo].[variantprb] (
       [c1] [int] NULL ,
       [c2] [sql_variant] NULL ,
       [rowguid]  uniqueidentifier ROWGUIDCOL  NOT NULL 
   )
                       

2. Synchronize the publication with a SQL Server 2000 CE subscriber.

3. On the SQL Server CE subscriber, insert the following data to the variantprb table:

   insert into variantprb (c1) values (1)
                       

4. Invoke the merge process to synchronize the CE subscriber with the SQL Server 2000 publication created in step 1.

You will receive the error shown in the "Symptoms" section of this article.

Keywords: kbbug kbfix KB328314

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.