Microsoft KB Archive/873442

= FIX: Event ID 23 is repeatedly logged in the Application log on a computer that is running BizTalk Server 2004 =

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:

Time:

User: N/A

Computer:

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.



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

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:

Replace  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 &quot;Applies to&quot; section. This problem was corrected in BizTalk Server 2004 Service Pack 1.

<div class="moreinformation_section">

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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.