Kbase P123551: 4GL/ABL client hangs running stored procedure on the MS SQL Server
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/24/2007 |
|
Status: Unverified
SYMPTOM(s):
4GL/ABL client hangs running stored procedure on the MS SQL Server
The stored procedure runs fine from the MS SQL query analyzer tool
The stored procedure references tables on a linked server to another SQL Server 2000 on Windows 2003 machine
The following error is reported in the event viewer log file on the Primary SQL Server 2000 on Windows 20000 machine:
Event Type: Error
Event Source: MSDTC
Event Category: CM
Event ID: 4357
Date: <date>
Time: <time>
User: N/A
Computer: <server name>
Description:
MS DTC is unable to communicate with MS DTC on a remote system. No common RPC protocol is supported between the two systems. Please ensure that one or more of the following RPC protocols are common to both systems: TCP/IP, SPX, or NetBEUI. Error Specifics: .\iomgrclt.cpp:203, CmdLine: D:\WINNT\System32\msdtc.exe, Pid: 576
Data:
0000: 21 00 00 00 20 00 00 00 !... ...
No errors are reported on the dataserver log file
CAUSE:
By default the "Enable network COM+ access" and "Enable Network DTC access" is not installed in Windows Server 2003.
FIX:
In order to install and enable both components, follow the steps below:
1. On the desktop on Windows 2003, got to Start > Settings > Control Panel
2. Add or Remove Programs
3. Add/Remove Windows Components
4. Select Application Server and click Details
5. Place a check on each of two Application Server components - "Enable network COM+ access" and "Enable Network DTC(Distributed Transaction Coordinator) access"
6. Click OK and Next afterward to install
7. Click Finish.
7. Stop and then restart the Distributed Transaction Coordinator service.
8. Stop and then restart Microsoft SQL Server and the other resource manager services that participate in the distributed transaction, such as Microsoft Message Queuing.