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

Article translations Article translations
Article ID: 295668 - View products that this article applies to.
This article was previously published under Q295668
BUG #: 235175( SHILOH_BUGS)
Expand all | Collapse all

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.

Properties

Article ID: 295668 - Last Review: November 5, 2003 - Revision: 3.2
APPLIES TO
  • Microsoft SQL Server 2000 Standard Edition
Keywords: 
kbbug kbfix kbsqlserv2000sp1fix KB295668

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com