NDR Occurs with the Description "Routing Table Transaction Failure."

• Microsoft Commercial Internet System versions 2.0, 2.5

SYMPTOMS

When e-mail is not delivered to some recipients, the SMTP generates a non-delivery report (NDR) with the description "Routing table database transaction failed."

CAUSE

This problem may be caused by one of the following:

An error in the Mcis2upd.sql script that released with Site Server 3.0 Service Pack 2.

SQL Server 7.0 null-syntax handling is different than SQL Server 6.5.

RESOLUTION

To resolve this problem, obtain the latest service pack for Site Server 3.0. For additional information, please see the following article in the Microsoft Knowledge Base:

Q219292 How to Obtain the Latest Site Server 3.0 Service Pack

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was first corrected in Site Server 3.0 Service Pack 3.

MORE INFORMATION

Q214601 PRB: ANSI_NULLS OFF Behavior in SQL Server 6.x and 7.0

Additional query words:

Keywords : SS3SP3Fix
Version : winnt:2.0,2.5
Platform : winnt
Issue type : kbbug