Microsoft KB Archive/328314

= 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 &quot;Symptoms&quot; 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.



Steps to Reproduce the Behavior
To reproduce the behavior, follow these steps:   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 )  Synchronize the publication with a SQL Server 2000 CE subscriber.  On the SQL Server CE subscriber, insert the following data to the variantprb table: insert into variantprb (c1) values (1)  Invoke the merge process to synchronize the CE subscriber with the SQL Server 2000 publication created in step 1.</li></ol>

You will receive the error shown in the &quot;Symptoms&quot; section of this article.

Keywords: kbbug kbfix KB328314

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.