Knowledge Base

BUG: SQLExecutive, CmdExec Task Output Is Not Properly Reported

Article ID: 197243

Article Last Modified on 10/3/2003

Microsoft SQL Server 6.5 Standard Edition

This article was previously published under Q197243

SYMPTOMS

The SQLExecutive, CmdExec task opens a file and redirects the stdout and stderr to it. When the task is complete SQLExecutive reads through the file in 231 byte increments. If the output is not on a boundary, > 231 bytes, the data is not reported.

For example, 245 bytes causes a second read loop to take place but the bytes read does not equal the requested buffer size of 231 bytes. The task ignores the second read and reports the first 231 bytes instead of the last 231 bytes.

WORKAROUND

To avoid the problem you can attempt to ensure that the output of the task is less than 231 bytes total or that the task output ends on a 231 byte boundary.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.5.

MORE INFORMATION

You can start SQLExecutive from the Windows NT command prompt using the following command

 sqlexec -c [ASCII 150]v

to see the actual output. However, the final output will not be reported in the task history correctly.

Additional query words: prodsql

Keywords: kbbug KB197243