Microsoft KB Archive/295668

= FIX: Transaction Replication to DB2 Subscribers Incorrectly Map Tinyint Data Type if You Use DTS to Transform Published Data =

Article ID: 295668

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q295668



BUG #: 235175( SHILOH_BUGS)



SYMPTOMS
When you use SQL Server 2000, you can create Data Transformation Services (DTS) packages to transform the data at the publisher before replicating it to the subscribers. If any of the published tables have a column with the tinyint data type, and the subscriber is DB2 (heterogeneous subscriber), the tinyint column is incorrectly mapped on the subscriber.

If replication is set up without transforming the published data by using DTS, the problem with data type mapping does not occur.



CAUSE
Static data type mappings are used for data type name and precision matching (based on the data type name that should be the same and destination precision should also be the same or more than the source precision). If a strict match of static mappings (based on name and precision) is not found, the destination server is queried to obtain the mappings dynamically.

If you use the Transform Publish Data Wizard (in case of Transformable subscriptions), the static mapping fails due to a precision mismatch and the destination server (DB2) is not interrogated for precision, which may cause replication to fail.



RESOLUTION
To resolve this problem, obtain the latest service pack for SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack



WORKAROUND
To avoid the problem modify the destination table schema in the Transform Publish Data Wizard.



STATUS
Microsoft has confirmed that this is a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.

Keywords: kbbug kbfix kbsqlserv2000sp1fix KB295668

-

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

© Microsoft Corporation. All rights reserved.