You may receive a "Repository was locked on host" error message when you try to validate an EDI schema in BizTalk Server 2004 (904847)



The information in this article applies to:

  • Microsoft BizTalk Server 2004 Enterprise Edition
  • Microsoft BizTalk Server 2004 Standard Edition
  • Microsoft BizTalk Server 2004 Partner Edition
  • Microsoft BizTalk Server 2004 Developer Edition

SYMPTOMS

In Microsoft BizTalk Server 2004, when you try to validate an Electronic Data Interchange (EDI) schema in Microsoft Visual Studio .NET 2003, you may receive an error message that is similar to one of the following error messages:

Error message 1
Schema validation failed. Repository was locked on host [host name] by process [compeif], processid [###]
Error message 2
Schema validation failed. Repository was locked on host [host name] by process [xsd2edi], processid [###]

CAUSE

This problem occurs when the Compeif command or the Xsd2edi command runs and the EDI repository is locked in the BizTalkEDIDb database.

The EDI repository may remain locked when one of the following conditions is true:
  • The Compeif command, the Xsd2edi command, or the Visual Studio .NET Devenv process (Devenv.exe) exits when the Compeif command, the Xsd2edi command, or the Devenv process validates an EDI schema.
  • The BizTalk Base EDI service stops when you try to validate an EDI schema.

RESOLUTION

To resolve this problem, unlock the EDI repository in the BizTalkEDIDb database. To do this, follow these steps:
  1. Click Start, click Programs, click Microsoft SQL Server, and then click Query Analyzer.
  2. In the Connect to SQL Server dialog box, enter the SQL Server server name and the logon credentials.
  3. In the Query window, type and then run the following Transact-SQL script.
    USE BizTalkEDIDb
    GO
    UPDATE parame SET repolock=null
    GO
  4. At a command prompt, type the following command to generate the .eif file that is used by the BizTalk Base EDI service:

    Compeif

    Note By default, the Compeif.exe file is installed in the Program Files\Microsoft BizTalk Server 2004\EDI\Subsystem\ folder.
  5. After the Compeif command has finished, restart the BizTalk Base EDI service.

MORE INFORMATION

Typically, the EDI repository is locked when you compile an EDI schema and then unlocked when the compilation is completed. Under the conditions that are described in the "Cause" section, the EDI repository may remain locked.

Modification Type:MajorLast Reviewed:9/28/2005
Keywords:kbBTSOrchestration kbinfo kbtshoot kbprb KB904847 kbAudDeveloper kbAudITPRO