Microsoft KB Archive/887481

= The BizTalk Deployment Wizard does not update the destination BizTalk EDI database when you deploy EDI schemas =

Article ID: 887481

Article Last Modified on 4/18/2005

-

APPLIES TO


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

-





SYMPTOMS
If you use the BizTalk Deployment Wizard to deploy an assembly that contains one or more Electronic Data Interchange (EDI) schemas to a computer that is running Microsoft BizTalk Server 2004, the EDI database on the target computer is not updated to include the deployed EDI schemas.



CAUSE
This problem occurs because the BizTalk Deployment Wizard does not implement functionality to update the destination BizTalk EDI database with the information in the deployed EDI schemas.



RESOLUTION
To resolve this problem, manually update the destination BizTalk EDI database by using the information in the deployed schemas. To do this, follow these steps:   Run the Xsd2edi.exe command at a command prompt:

XSD2EDI -c[Location of EDICodelists.mdb] -i[Base EDI schema] -t -f

For example, run the Xsd2edi command at a command prompt if the EDICodeLists.mdb file is in the default directory and you are updating the BizTalk EDI database with the 850Schema.xsd schema file:

XSD2EDI -c&quot;C:\Program Files\Microsoft BizTalk Server 2004\EDI\Adapter\CodeLists\EDICodeLists.mdb&quot; -i&quot;C:\Program Files\Microsoft BizTalk Server 2004\EDI\Adapter\EDI Schemas\X12\4010\850Schema.xsd&quot; -t -f

Note If you receive a &quot;The input file is not present!&quot; error message or a &quot;The codelist database is not valid!&quot; error message when you run the Xsd2edi command, make sure that there are no spaces between the Xsd2edi switches and their arguments.   Generate the EIF file that is used by the BizTalk Base EDI Service at run time by running the COMPEIF command at a command prompt:

COMPEIF

Note You must start the BizTalk Base EDI Service before you run the COMPEIF command.  After the COMPEIF command has completed, restart the BizTalk Base EDI Service on the destination computer.



MORE INFORMATION
The Xsd2edi.exe command converts an XSD file into the required EDI schema format and then stores it in the BizTalk EDI database. To see a list of all the switches that are available for the Xsd2edi command, run the Xsd2edi command at a command prompt:

<pre class="fixed_text">XSD2EDI ?

By default, the Xsd2edi.exe file is installed in the Program Files\Microsoft BizTalk Server 2004\EDI\Subsystem folder.

Important The arguments to the Xsd2edi.exe command may be different for different versions of the Xsd2edi.exe command. To determine what parameters are required, run the following command at a command prompt:

<pre class="fixed_text">XSD2EDI ?

Also note that if you do not have Microsoft SQL Server 2000 installed on the BizTalk Server 2004 server, you must install the SQL Client tools for the Xsd2edi command to work.

The Compeif.exe command uses the information in the BizTalk EDI database to generate an Engine Input File (EIF) to be used by the BizTalk Base EDI Service to parse and serialize EDI documents. The default location for the EDI EIF is C:\Documents and Settings\All Users\Application Data\Microsoft\BizTalk Server 2004\EDI\Subsystem\EIF\live.eif. By default, the Compeif.exe file is installed in the Program Files\Microsoft BizTalk Server 2004\EDI\Subsystem\ directory.

<div class="status_section">

STATUS
This behavior is by design.

Keywords: kbprb KB887481

-

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

© Microsoft Corporation. All rights reserved.