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


The information in this article 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:
  1. Run the Setup program to install the main hotfix files.
  2. 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

  3. 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

  4. 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

Modification Type:MajorLast Reviewed:6/27/2005
Keywords:kbQFE kbBizTalk2004sp1fix kbClustering kbEventLog kbBTSAdapters kbBizTalk2004preSP1fix kbbug kbfix KB873442 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.