Article ID: 873442
Article Last Modified on 6/27/2005
APPLIES TO
- Microsoft BizTalk Server 2004 Standard Edition
- Microsoft BizTalk Server 2004 Partner Edition
- Microsoft BizTalk Server 2004 Enterprise Edition
- Microsoft BizTalk Server 2004 Developer Edition
SYMPTOMS
Event ID 23 is repeatedly logged in the Application log on a computer that is running Microsoft BizTalk Server 2004. You receive the following event message:
Event Type: Error
Event Source: EDI Subsystem
Event Category: BizTalk Server 2004
Event ID: 23
Date: date
Time: time
User: N/A
Computer: computername
Description: Error encountered: ERROR (44): A database error occurred. Contact the system administrator.
If you restart the BizTalk Base Electronic Data Interchange (EDI) Service, the event is no longer logged.
CAUSE
This problem occurs if the following conditions are true:
- You use the Base EDI Adapter with BizTalk Server 2004.
- BizTalk Server 2004 experiences a momentary loss of connectivity with a computer that is running Microsoft SQL Server 2000. For example, this problem occurs if BizTalk Server 2004 runs in a clustered environment, and BizTalk Server 2004 fails over to another cluster node.
RESOLUTION
Service pack information
To resolve this problem, obtain the latest service pack for Microsoft BizTalk Server 2004. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
888751 How to obtain the latest BizTalk Server 2004 service pack
Hotfix information
Prerequisites
No prerequisites are required to install this hotfix.
Restart requirement
You do not have to restart your computer after you apply this hotfix.
Hotfix replacement information
This hotfix does not replace any other hotfixes.
File information
The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in coordinated universal time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.
Date Time Version Size File name -------------------------------------------------------------- 28-Jul-2004 21:03 4.0.1125.0 94,208 Microsoft.biztalk.extension.edi.schemaeditor.dll 28-Jul-2004 21:03 4.0.1125.0 61,440 Microsoft.biztalk.adapter.edi.common.dll 28-Jul-2004 21:03 4.0.1125.0 110,592 Microsoft.biztalk.adapter.edi.manager.dll 28-Jul-2004 21:03 4.0.1125.0 32,768 Microsoft.biztalk.adapter.edi.receiver.dll 28-Jul-2004 21:03 4.0.1125.0 45,056 Microsoft.biztalk.adapter.edi.resourcer.dll 28-Jul-2004 21:03 4.0.1125.0 20,480 Microsoft.biztalk.adapter.edi.sspi.dll 28-Jul-2004 21:03 4.0.1125.0 36,864 Microsoft.biztalk.adapter.edi.transmitter.dll 18-Jun-2004 19:24 488,650 Live.eif 05-Feb-2004 18:25 82 Updateedi.bat 21-Jul-2004 00:19 321,170 Updateedi.sql 20-Jul-2004 21:31 143,208 Receivelocation.xsd.tmpl 21-Jul-2004 19:28 186,956 Sendporttransport.xsd.tmpl 28-Jul-2004 21:11 4.0.1125.5 24,064 Compeif.exe 28-Jul-2004 21:10 4.0.1125.11 188,416 Edimmcsnapin.dll 28-Jul-2004 21:10 4.0.1125.195 851,968 Esp.dll 28-Jul-2004 21:10 4.0.1125.13 172,032 Esproxy.dll 28-Jul-2004 21:09 4.0.1125.22 65,536 Esp_btsoma.dll 28-Jul-2004 21:09 4.0.1125.24 118,784 Esp_cli.dll 28-Jul-2004 21:11 4.0.1125.26 23,040 Esp_files.dll 28-Jul-2004 21:09 4.0.1125.49 86,016 Esp_gen.dll 28-Jul-2004 21:11 4.0.1125.28 22,016 Esp_sqlsrv2000.dll 28-Jul-2004 21:11 4.0.1125.25 22,528 Esp_srv.exe 28-Jul-2004 21:09 4.0.1125.185 368,640 Esp_trans.dll 28-Jul-2004 21:11 4.0.1125.16 32,768 Esp_voyager.dll 28-Jul-2004 21:11 4.0.1125.1 167,936 Genins.exe 28-Jul-2004 21:11 4.0.1125.5 7,680 Trigcon.exe 28-Jul-2004 21:10 4.0.1125.4 167,936 Validins.exe 28-Jul-2004 21:11 4.0.1125.34 1,228,800 Xsd2edi.exe 28-Jul-2004 21:10 4.0.1125.0 17,408 Edimmcresdll.dll 28-Jul-2004 21:11 4.0.1125.2 21,504 Esp_err.dll 28-Jul-2004 21:03 4.0.1125.0 11,264 Microsoft.biztalk.extension.edi.errortext.dll 28-Jul-2004 21:03 4.0.1125.0 643,072 Microsoft.biztalk.extension.edi.hatplugin.dll
Note Because of file dependencies, the most recent hotfix that contains these files may also contain additional files.
Hotfix installation information
After you extract this hotfix package, follow these steps to install this hotfix:
- Run the Setup program to install the main hotfix files.
- Copy the Genins.exe file from the location where you extracted the hotfix package to the following folder:
%ProgramFiles%\Microsoft BizTalk Server 2004\EDI\Subsystem
- Copy the Updateedi.bat file and the Updateedi.sql file from the location where you extracted the hotfix package to the following folder:
%ProgramFiles%\Microsoft BizTalk Server 2004\EDI\Adapter\Bin\Config
- Run the following batch file:
%ProgramFiles%\Microsoft BizTalk Server 2004\EDI\Adapter\Bin\Config\UpdateEDI.bat
Note After you complete these steps, you may have to restart the following services:
- BizTalk Base EDI Service
- BizTalk Service BizTalk Group:
BizTalkServerApplication
Replace BizTalkServerApplication
with the name of the default BizTalk Server host. This name may be different on your computer.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was corrected in BizTalk Server 2004 Service Pack 1.
MORE INFORMATION
For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates
Additional query words: EBiz BTS
Keywords: kbqfe kbbiztalk2004sp1fix kbclustering kbeventlog kbbtsadapters kbbiztalk2004presp1fix kbbug kbfix KB873442