Microsoft KB Archive/112000

{|
 * width="100%"|

BUG: Server to Server RPC Fails Using COMPUTE and COMPUTE BY

 * }

Q112000

-

The information in this article applies to:


 * Microsoft SQL Server for OS/2, version 4.2
 * Microsoft SQL Server version 4.2x

-

BUG# NT:  689 (4.2) OS/2: 1833 (4.2)

SYMPTOMS
When issuing a RPC to a remote NT SQL Server, the client application hangs. However, both the local and the remote server can be accessed normally, and server to server RPCs can still be executed between the two machines. Execution of the stored procedure locally, either by an EXEC statement or using DB-Library RPC functions, will return all results to the front-end without error.

CAUSE
If a stored procedure contains a SELECT statement that includes both a COMPUTE BY and a COMPUTE clause, and if that stored procedure is executed as a server to server RPC, the client workstation will hang after receiving all regular and COMPUTE BY results, but before receiving the grand total produced by the COMPUTE

WORKAROUND
The SELECT statement which produces the COMPUTE BY and COMPUTE results should be broken into two SELECTs. The first producing the COMPUTE BY results and the second producing the grand total.

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

Additional query words: calls proc Windows NT

Keywords : kbother

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbZNotKeyword3 kbSQLServ420OS2