Microsoft KB Archive/904847

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

Article ID: 904847

Article Last Modified on 1/15/2007

-

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 [ ] by process [compeif], processid [ ]

Error message 2

Schema validation failed. Repository was locked on host [ ] 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:  Click Start, click Programs, click Microsoft SQL Server, and then click Query Analyzer. In the Connect to SQL Server dialog box, enter the SQL Server server name and the logon credentials.  In the Query window, type and then run the following Transact-SQL script. USE BizTalkEDIDb GO UPDATE parame SET repolock=null GO  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. After the Compeif command has finished, restart the BizTalk Base EDI service.

<div class="moreinformation_section">

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 &quot;Cause&quot; section, the EDI repository may remain locked.

Additional query words: EDI COMPEIF

Keywords: kbbtsorchestration kbinfo kbtshoot kbprb KB904847

-

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

© Microsoft Corporation. All rights reserved.