Article ID: 328314 - Last Review: September 9, 2005 - Revision: 3.3

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

View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
This article was previously published under Q328314
Bug #: 4912 (SSCE)

On This Page

Expand all | Collapse all

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
Back to the top

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.
Back to the top

STATUS

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

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.
Back to the top
APPLIES TO
  • Microsoft SQL Server 2000 Windows CE Edition 1.1
  • Microsoft SQL Server 2000 Windows CE Edition 2.0
Back to the top
Keywords: 
kbbug kbfix KB328314
Back to the top