Commerce Predictor: SQL Server Timeouts Occur

Retired KB Content Disclaimer

View products that this article applies to.

This article was previously published under Q188247

Expand all | Collapse all

SYMPTOMS

SQL Server timeouts may occur on Commerce Server sites whose databases contain a very large number of orders, and which use the Predictor component. The timeout can occur when calling InitPredictor.

Back to the top

ActiveX Data Objects (ADO) imposes a default 30-second timeout limit per command. The Predictor component does not allow this default to be changed, and InitPredictor can reach this limit with large data sets. The updated Predictor component in the service pack increases the timeout value.

Back to the top

RESOLUTION

To resolve this problem, apply the latest Site Server 3.0 service pack.

Back to the top

STATUS

Microsoft has confirmed this to be a problem in Site Server version 3.0. This problem has been corrected in the latest U.S. service pack for Microsoft Site Server version 3.0. For information on obtaining the service pack, query on the following word in the Microsoft Knowledge Base (without the spaces):

   S E R V P A C K

Back to the top

APPLIES TO

Microsoft Site Server 3.0 Commerce Edition

Back to the top

kbbug kbfix kbsiteserv300sp1fix KB188247

Back to the top

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top