Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. You may receive a "Repository was locked on host" error message when you try to validate an EDI schema in BizTalk Server 2004

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

View products that this article applies to.

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 [###]

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

Keywords: KB904847, kbprb, kbtshoot, kbinfo, kbbtsorchestration

↑ Back to the top

Article Info
Article ID : 904847
Revision : 3
Created on : 1/15/2007
Published on : 1/15/2007
Exists online : False
Views : 340