BUG: Concurrent Distribution Tasks May Cause an Unhandled Error

 Last reviewed: December 23, 1997
Article ID: Q178473
The information in this article applies to:
  • Microsoft SQL Server, version 6.5
BUG #: 16535 (6.5)

SYMPTOMS

Concurrent execution of distribution tasks on a scheduled frequency (not Autostart) may result in an unhandled exception in SQL Executive. If Dr. Watson is your default debugger, you may receive a Dr. Watson message on SQL Executive.

This problem occurs on SQL Server 6.5 using the ODBC Driver Manager 3.0, SQL Server ODBC Driver 2.65.201 or higher, and Windows NT 4.0. To check the version of either the ODBC Driver Manager or the SQL Server ODBC Driver, you can use the ODBC icon in Control Panel.

WORKAROUND

To work around this problem, do either of the following:

  • Change the frequency of your distribution tasks to be Autostart.

    -or-

  • Add an "-o" parameter to each distribution task. To add an -o parameter, perform the following steps:

    1. Double-click the task in Task Scheduling.

    2. In the Command dialog box, add "-o <file_name>" after the last 

          command, where <file_name> is the name of an optional output file.

This outputs some debug information into the specified file as the distribution task executes. If an output file is not specified and SQL Executive is started as a service, this information will be written to a virtual desktop. Therefore, not specifying an output file after the -o parameter will save disk space.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: applet option switch
Keywords : kbbug6.50
Version : WINNT:6.5
Platform : winnt
Issue type : kbbug
Solution Type : kbworkaround

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: December 23, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.