BizTalk Server EDI and AS2 Forum

EDI receive Pipeline Fails for EDIFACT Message

Mon, 30 Nov 2009 20:39:25 Z

Hi All,

I am using a EDI Receive Pipeline to receive EDIFACT files.
Receive pipelines fails and error i get is

"Microsoft.BizTalk.Edi.DefaultPipelines.EdiReceive, Microsoft.BizTalk.Edi.EdiPipelines, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" is suspended due to the following error:
Error: 1 (Miscellaneous error)
47: Envelope functionality not supported

Error: 2 (Field level error)
SegmentID: UNB
Position in TS: 1
Data Element ID: UNB3.2
Position in Segment: 4
Position in Field: 2
Data Value: 01
12: Invalid value in data element

Error: 3 (Field level error)
SegmentID: UNB
Position in TS: 1
Data Element ID:
Position in Segment: 6
Data Value:
12: Invalid value in data element.
The sequence number of the suspended message is 1.

Am i using the wrong pipeline?How does this work.

Migrating 2002 EDI Schema in 2006 R2

Tue, 10 Nov 2009 07:14:37 Z

Hello,

Is there any way to convert 2002 XDR Schema (which of "LOGMES" EDI Message type) in 2006 R2.
With the help of VS.net, I've got the Schema but it is not of EDI Type.

Then I tried the below tool. But it looks for only ".xsd" and not ".xml"
C:\Program Files\Microsoft BizTalk Server 2006\SDK\Utilities\MicrosoftEDI\BTS06EdiSchemaMigrator.exe

I tried to give my converted xsd (thru VS.Net) as input to BTS06EdiSchemaMigrator.exe
"
Unable to migrate schema C:\LORIS\LoRIS_SourceCode\From Dev machine\BizTalk\SourceCode\Sygma\Code\Biztalk2002\DocSpecs\Loris\EDI_LOGMES_Schema.xsd. Error returned: 'XmlSchemaSet' can load only W3C XML Schemas.
"

Can you pls suggest ways to proceed.

How to create Custom EDI Schema in BTS 2006 R2

Wed, 25 Nov 2009 07:00:43 Z

Hello all,

I need to create schema from customized EDI file.

UNB+UNOA:1+sss+zzz+080925:0704+6932'UNH+1+LOGMES:1:0:BM'BGM+997'DTM+243:0809241748:201'NAD+MS+FWRAPPLICATION'NAD+MR+BM*DRIVE'SEQ++000001'LOC+8+PTAZACD'GIN+CN+W0L0XCF2594039564'DLM++Y:DC:Z06:ZGM'DTM+Z05:0809241628:201'GIR+1+0083LPKR:VV'LOC+Z0+PT0999:Z07:ZGM'LOC+Z04+PTAZACD'LOC+Z05+PT0035:Z07:ZGM'SEQ++000002'LOC+8+PTAZACD'GIN+CN+W0L0AHM758G178466'DLM++N:DC:Z06:ZGM'DTM+Z05:0809241638:201'GIR+1+0034LD9T:VV'LOC+Z0+PT0999:Z07:ZGM'LOC+Z04+PTAZACD'LOC+Z05+PT0053:Z07:ZGM'UNT+24+1'UNZ+1+6932'

I tried to treat it as a flatfile and created FF schema out it. but ended up with "Unrecognized data in remaining stream."

can anyone guide to create customised EDI schema

Many thanks,
Vidhya

Biztalk map : How to sort the destination schema loop in a custom order

Mon, 30 Nov 2009 20:49:09 Z

Hi,

I am working on a 810 map and one of our customer insisting on the order of the N1Loop values.

They want the loop to be sorted by the N101 value and the order is BY, SU, ST, II.
But my source schema comes in a different order.

Example :

Source :
- <Addresses>

- <Address>

<Address_Type>RS</Address_Type>

<Address_Number />

<Duns_Code>2001312739</Duns_Code>

<Name>Company</Name>

<Street1>Street</Street1>

<State_Province>ST</State_Province>

<Postal_Code>12345</Postal_Code>

</Address>

- <Address>

<Address_Type>AG</Address_Type>

<Address_Number>2001543778</Address_Number>

<Duns_Code />

<Name>Customer</Name>

<Street1>Street</Street1>

<State_Province>ST</State_Province>

<Postal_Code>12345</Postal_Code>

</Address>

..
..
..
..
</Addresses>

Destination:

- <ns0:N1Loop1>

- <ns0:N1>

<N102>Company</N102>

</ns0:N1>

- <ns0:N3>

<N301>Street</N301>

</ns0:N3>

- <ns0:N4>

</ns0:N4>

</ns0:N1Loop1>

- <ns0:N1Loop1>

- <ns0:N1>

<N102>Customer</N102>

</ns0:N1>

- <ns0:N3>

<N301>Street</N301>

</ns0:N3>

- <ns0:N4>

</ns0:N4>

</ns0:N1Loop1>

..
..
..
..

How can I sort the destination loop by the above custom values?

Thank you!

The Developer

Error Handling into EDI Disassembler

Wed, 25 Nov 2009 16:07:27 Z

I have an issue where I need to catch the exception that happen into Receive Pipeline more specific in EDI Disasembler. and send the Error Description and the body of EDI File (flat file) to another orchestration.

I tried with one Send port that is suscribed to the Receive port and applied the filter BTS.AckReceivePortName == ReceivePort but this option only catch the Xml with NACK and there I get the Error Descrption. Then...

I tried other option Activating Enable Routing for Failed Messages in ReceivePort and into Send Port I filter by ErrorReport.ReceivePortName == ReceivePort but this option only catch the original copy from EDI File

then I tried to combine them both options but doesnt work....

anyone have any idea?

thanks in advanced

UN/EDIFACT D01B Message (CNTCND)

Mon, 30 Nov 2009 12:37:13 Z

Hi, I got a document from the trading partner which discribes the message structure same as this link ("http://www.stylusstudio.com/EDIFACT/D01B/CNTCND.htm#part4.3"). How do i configure "Parties" in Biztalk according to the given message structure? I did some X12 samples and its hard to find EDIFACT samples. I've been struglling for last 7 days and still not worked out. Pls provide me guidence/help to overcome the problem. I got some sample edi files from the partner too. I'm looking forward to help from you guys. Thank u

filename of a batch

Mon, 30 Nov 2009 10:47:46 Z

Hi

In my project I have to batch edifact messages. The filename of the batched message should contain the sender and the receiver of the data. How can I achive that?

Klaus Weber

EDIFACT : INOVERT & TRADACOM support in BizTalk 2009 or vNext ?

Fri, 27 Nov 2009 09:06:22 Z

Does the subset of EDIFACT named "INOVERT" is supported in BizTalk Server 2009 ? Or plan to be in 2009 R2 ?
Same question about the subset "TRADACOM".
Thanks.

David Grospelier
blog.noveli.fr

Configure HTTP recevie location on different IIS web site outside the default web site?

Thu, 26 Nov 2009 06:38:45 Z

Hi,
Can we configure the HTTP receive location on new IIS web site, which located outside the IIS default web site?

rgds,
Emil

Prerequests for EDI Implementation

Fri, 13 Nov 2009 07:49:09 Z

Hi, I got one implementation as a free lancing. My client need to enhancement for existing application. The present environment is BizTalk 2004, .Net 2003. My client need to Implement EDI 810 Invoice Implementation. What are the prerequisites to implement this? Thanks in Adance. Mike Doobay.

Modifying EDI Schema X12 214-3050

Thu, 26 Nov 2009 15:23:10 Z

Hello

We have to add customized segments in standard 214-3050.

Few of them have to appear after N9 segment as ZN9PU, ZN9DEL, ZN9SERV ....

Few of them just need N901 & N902.

Tried to copy N9 segment details and changed the ref to ZN9PU.

When i try to validate the instance getting error Unrecognized data.

And other error that shows ZN9 having first value as U when it finds ZN9PU.

Is there any limitations on character in ref / tag_name?

Here is the instance i am trying to validate in VS2005

ST*214*000000001~
B10*PCT0124553*36264088*CCSL~
B2A*00~
N9*CR*36063362~
N9*PO*S52*BOL~
N9*PO*S5PU3*BOL~
N9*OR*OCT0078308~
N9*BM*36264088~
N9*LO*TCT0059954~
N9*S5*6~
ZN9PU*S5*2~
N1*ZSF*J C INC*91*JCI5536~
N2*FL22343~
N3*2330 LAKE ROAD~
N4*Saint os*MO*62304*US~
G61*SH*Shipper Contact*TE*81612452600*FX*~
N1*ZST*T M LTD*91*JCI1000124095~
N2*FL22344~
N3*1000 A AVENUE~
N4*Txxxxx*xx*A1R 5L8*CA~
N1*ST*T M LTD*91*JCI1000124095~
N2*FL22344~
N3*1000 A AVENUE~
N4*Txxx*XX*A1R 5L8*CA~
N1*CA*D Trans*91*CCSL~
N2*DIRCGY~
N3*Unit 121 xxxxxxxx Ave. S.E.~
N4*Calgary*AB*F2C 5Y2*CA~
G61*CN*Carrier Contact*TE*999960290~
MS2*UNKN*13069*TL~
LX*1~
Q5*X1*091124*1947**NS~
Q6*4272*L*G*108*PCS~
Q6B**SKD**CUBE~
SE*35*000000001~

SegmentID: CTT, SII

Tue, 27 Oct 2009 19:35:34 Z

Hi All,

I am trying to generate 844 EDI.

But Everytime I am geting below error.

--------------------------------------

Error: 1 (Segment level error)

SegmentID: CTT

Position in TS: 150

3: Mandatory Segment Missing

Error: 2 (Segment level error)

SegmentID: SII

Position in TS: 150

2: Unexpected segment

--------------------------------------

I have mapped all element of CTT with Some dummy string value(also updated its type to string in schema) and also mapped element 1,2,3,4,5,6 of SII segment with some value.

Help!!!(F1)

Any Information on Covast Accelerator with BTS 2006?

Thu, 19 Nov 2009 18:46:33 Z

Is there any articles/tutorials on How to confidure Schemas/Send/Receive ports in Covast..any examples....with BTS 2006..I know there are some whitepapers on Covast Site...But apart from that is anywhere else I can get more info on Covast...I had to use EDI with Covast Accelerator and Biztalk 2006

Does anybody worked on BizTalk 2006 with Covast EDI Accelerator for EDI Solutions.I could not find any useful articles on BizTalk 2006 with Covast EDI Accelerator. Please let me know if anybdy know or anybody have one ..I appreciate your help..

EDIFACT Service Schema not found

Wed, 18 Nov 2009 10:18:52 Z

Hi all.

I try to receive an EDIFACT-Message in my orchestration.
I read data from a file in a receive location. When I put my EDI File into that location I get an error message in the eventlog (translated from german):

EDIFACT-Serviceschema not found.

In my iroject I included the EDIFACT_ServiceSchemaExtension.xsd. What else is missing to make it work?

Thanks for your answers,

Marcel

HIPAA 837 Mapping issue

Fri, 20 Nov 2009 21:35:03 Z

Hi,
Have any one faced a situation in which, while mapping data to 837P schema, have to group the data at Provider level, so that there will be only one 2000A loop for a given provider. Then at the 2000B loop level if there are different client for the same provider then there will be multiple 2000B loops. If there is new provider available, then once again a 2000A loop will start with its 2000B loops. Had any one faced a similar situation? How was it achieved?

Thanks,

Ram

Can the test-indicator element be suppressed?

Mon, 07 Apr 2008 14:54:46 Z

Is it possible to suppress the test-indicator element? (if it's not a test ofcourse)

So the UNB looks like this

UNB+UNOA:1+AAAAA+BBBBB+080407:1631+16

not like this

UNB+UNOA:1+AAAAA+BBBBB+080407:1631+16++++0

Isabelle

EDI 834 to FlatFile

Sat, 21 Nov 2009 03:53:33 Z

I am wrestling with a flatfile output behaving badly - to begin it was working fine except the edi transactions, being debatched were creating in the flat file output one record per file (alternately I could tell the send pipeline to append but then the records had no CRLF delimiter). So, next I went back to my party/receive pipeline and rewired it to keep the EDI batched. Now, I need to figure out how to use loops in the map to tell it to process all the 2000Loops, each one as a record. I have looked online/in the Biztalk R2 ProMapper book but there is not an example I can see of looping with a map destination to a flat file. Would appreciate any help - my head is getting sore and the wall I am banging it on is suffering some too.

EDIFACT CONTRL Acknowledgment Error 26 - What happens to the message?

Thu, 19 Nov 2009 06:52:51 Z

Hi all.

I sent the same message to BizTalk twice and got the EDIFACT CONTRL Acknowledgment Error 26 (duplicate detected) as expected.
But what happens to the message sent? Is it deleted from the system or stored in a database. And if it is stored, in which database?

I did not build any error handling into my application, so it still uses standard settings for failed messages.

Any help would be fine,

Marcel

Accessing UNA,UNB in Orchestration EDIFACT IFCSUM Schema

Sun, 15 Nov 2009 13:29:18 Z

Hi
Can you let me know how can I access the UNA_segment and UNB_segment inside an Orchestration?
As of my understanding UNB segment is stripped off from the actual XML before it is send to Message box.
I think UNB_Segment is available in context property of the message.
WHat is the data type of UNB_Segment?
Can I create a string variable in Orchestration and assign
strUNB = Msg1(EDI.UNB_Segment);

Is there a default schema for UNB Segment?

Regards, NISHIL Http://BiztalkForums.com

Help on setup AS2 on EDIFACT D97A ORDERS type

Tue, 17 Nov 2009 09:17:33 Z

Hi,
i was being assigned a project to implement and EDI to exchange EDIFACT 'ORDERS' message with customer. I found that BTS was able to do the EDI over AS2 on EDIFACT. However, i have read through the BTS help file and have few things need the experts to clarify:

1) Is BTS 2009 support EDIFACT D97A 'ORDERS' message? If yes, any way to check? If no, how to make it supported?
2) Is that anyway to convert the sample EDIFACT file to XML file using BTS 2009?

Your valued answer is very appreciated, thks!
rgds,
Emil

[Biztalk 2009 Beta] EDI tracking features

Tue, 17 Feb 2009 21:27:46 Z

Has anybody found out or blogged about any new features to the Biztalk 2009 EDI tracking abilites? Like on failed message routing is the ISA and GS information or other message properties retained with the message? Or perhaps a tracking DB for messages sent and received so that we can query interchange data for our trading partners.

Thanks In advance,

Jim Wood

BizTalk 2009 - Store Subdocument as EDI in Database

Fri, 13 Nov 2009 17:48:45 Z

I am working with a client using BizTalk Server 2009 Standard edition that processes 837 claims using the 4010 Multiple schema X12. The process uses the EDIReceive pipeline to import the data. Once the data is "split" into the XML message, they would like to store the "split" message as a field in the database, but they want to store the "split" message in the EDI format, not the XML format.
Is it possible to convert the XML message back into EDI so that the EDI formatted message can be stored in the database?
Also, I should mention that we are not using maps in the orchestration. We are using .Net to persist to the database, so we need to associate the EDI message with the persisted data before inserting into the database. Does anyone have any information they could share?

BizTalk Server 2009 - Sub Document Processing Hot Fixes

Fri, 13 Nov 2009 17:55:41 Z

I am working on a BizTalk Server 2009 project using the Muliptle Schema for 4010 X12 837 claims processing. I am using the EDIReceive pipeline to "split" the document into multiple messages and then writting the "split" messages in XML to a Receive port. When I look at the XML messages that are created, it appears that there is additional information in the messages. Information from other claims appears to have been associated with the claim I am trying to view. I believe that this is similar to the hot fixes for "bloated XML" in BizTalk Server 2006 R2 [http://support.microsoft.com/kb/967945 ]. Does anyone know if there is a hot fix for this in BizTalk Server 2009?

When processing an 837i file that contains one (1) Transaction Set with multiple claims. We are processing an EDI file against the 837I Multiple schema to create separate messages for each claim. We are using the EDIReceive pipeline to process the file. The EDI pipeline splits the document into multiple messages and outputs the information into XML documents. The XML documents appear to have information from both claims in each document.

Example:

Claim 1 has all of the information associated with Claim 1 but also includes some of the information associated with Claim 2

Claim 2 has all of the information associated with Claim 2 but also includes some of the information associated with Claim 1

I would expect that the message for Claim 1 would only have information associated with Claim 1 and that the message for claim 2 would only have information associated with claim 2.

How do I override the UNB sender id segment in an EDIFACT message at runtime??

Mon, 16 Nov 2009 10:48:17 Z

I have a requirement to configure UNB sender segment i.e UNB5,UNB6 and UNB7 at runtime.

I understand that biztalk 2009 had been enhanced with the edioverridden to achieve this easily.

Can anyone sahre how to achive the same in BizTalk 2006 in detail?

Thanks a lot!

EDIFECS hipaa 5010 version support in BizTalk 2009?

Thu, 12 Nov 2009 16:10:50 Z

Do we have any EDIFECS adapter or support available for BizTalk 2009? EDIFECs for HIPAA EDI 5010 version. Please provide any guidance or link.
I have sent this question to EDIFECS also but i am posting the same question here, In case some one already has exprienced working with EDIFECs with BizTalk in 4010/5010.

Moonis Tahir MVP, MCPD, MCSD.net, MCTS BizTalk 2006/SQL 2005/SharePoint Server 2007 (Dev & Config)

How do I override the UNB sender id segment in an EDIFACT message at runtime

Mon, 04 May 2009 10:05:36 Z

Hi,

I want to reade the EAN ident from the source XML document in BizTalk, and use it as the sender id in the UNB sebment of the EDIFACT message (ORDERS). The EAN ident is promoted, and is available in the send pipeline.
I have tried to make a custom pipeline, where I read the promoted property, and as far as I can see, I must put it in the propery "SenderID" with the name space "http://schemas.microsoft.com/BizTalk/2006/edi-properties". But when I try to promote the property, I get the exception "Loading property information list by namespace failed or property not found in the list". It seems like the property schema for the namespace "http://schemas.microsoft.com/BizTalk/2006/edi-properties" is missing.

Her is the code for the custom send pipeline:

private IBaseMessage ExecuteInternal(IPipelineContext pContext, IBaseMessage pInMsg)
  {
      WriteToTrace("Begin ExecuteInternal()");

      string ReadContextPropName = "EANIdent";
      string ReadContextPropNamespace = "http://LV_EDI.PropertySchema.PropertySchema";
      string SetContextPropName = "SenderID";
      string SetContextPropNamespace = http://schemas.microsoft.com/BizTalk/2006/edi-properties;
  
 
      try
      {

          WriteToTrace(string.Format("Reading property {0}:{1}", ReadContextPropName, ReadContextPropNamespace));

          //Read from context                  
          object val = pInMsg.Context.Read(ReadContextPropName, ReadContextPropNamespace);

          //Write to the context
          if (val != null)
          {
              WriteToTrace(string.Format("Property Exists {0}:{1}", ReadContextPropName, val.ToString()));

              WriteToTrace(string.Format("Writing {0}:{1}:{2}", SetContextPropName, SetContextPropNamespace, val.ToString()));

              pInMsg.Context.Write(SetContextPropName, SetContextPropNamespace, val.ToString());
              pInMsg.Context.Promote(SetContextPropName, SetContextPropNamespace, val.ToString());
          }
          else
              WriteToTrace(string.Format("{0} Property Does not exist.", ReadContextPropName));
      }
      catch (Exception ex)
      {
          // Do not fail the pipeline if we cannot archive
          // Just log the failure to the trace listener
          WriteToTrace(ex);
      }
  
      WriteToTrace("End   ExecuteInternal()");
  
      //Clone the message and return
      return pInMsg;
  
  }

Where can I get the property schema for this name space? Or should I solve it using another method?

Thanks.

Question regarding EDIFACT MAPPING in BizTalk Server 2006 R2

Fri, 13 Nov 2009 07:03:05 Z

Hi All,

I have a project where the data i get is EDIFACT document and one of field is having data like HDR*5+10+20*

I want that these different data 5,10,20 should map in different destination field ..

How can i achieve this..

Thanks

Sandeep

BizTalk 2009 Mapping Issue

Thu, 12 Nov 2009 21:19:22 Z

Hi,
I have a specific design issue in mapping two seperate records to one in the destination schema. I have to compare the present record child element with the previous record and say if they are same then, I have to group them under one parent node in destination schema, else they will appear in seperate records. I had thought about looping here, but Im not sure on whether its possible to compare the records.

If any one has faced similar issues, let me know!

Thanks,

Ram

HIPPA EDI 837 Professional to a flat file

Wed, 11 Feb 2009 16:29:21 Z

I am struggling to get my map works for an EDI 837 PROF to Flat file. The output created with all the claims first then the services lines. But I need like Claim then all the services like below. How do I do this? Is it something wrong with my loops?
I have looping functoid with CLAIM’s TS837Q1_2300_Loop and Patient’s TS837Q1_2300_Loop going in to the “looping” functoid and mapped to my output Claim record
TS837Q1_2400_Loop and TS837Q1_2400_Loop looping for services.

CLAIM1
services1
services2
services3
CLAIM2
Services1
Services2

Migration of EDI Application from BizTalk Server 2006 R2 to 2009

Tue, 10 Nov 2009 17:17:05 Z

Hi,

We need to migrate our application from 2006 R2 to 2009. We are currently using X12 standard of 00401 version. We use around 10 diffirent messages.
Have someone been involved in such kind of activity. If yes then please :
1-Any suggestion
2-Estimated time
3-What artifacts we can migrate and what we can not. as we also have some custom component such as custom disassembler and custom exception component.

Regards
Vishnu

Vishnu

AS2 Synchronous MDN with Orchestration

Thu, 12 Nov 2009 17:03:48 Z

Hi All,

I'm working on Biztalk server as2. I want to receive as2 message from my partner and send synchronous mdn to my partner. I know i need to use a two-way receive port and party configuration. Also i know how i can configure party and port.

But i want to use orchestration. I create a two-way receive port, a receive shape and a send shape. But what should be mdn send shape's message type?

Any idea?

Thanks,

Zeliha

Getting error: It could not be classified as an X12 or Edifact message

Tue, 10 Nov 2009 14:15:45 Z

Tag: Configure dynamic output file name from multiple source/input file name.

I am getting target namespace error while processing through party.

I have modified X12 base template of X12_00401_210 and added Root node DS_RHW_210. Schema target namespace given as http://schemas.microsoft.com/BizTalk/EDI/X12/2006Custom and selected “DS_RHW_210” as Root node.

Map works perfectly, I have created an Orchestration to transform through mapping, created send port as edisend which is assigned to a party. Messages were passing through Orchestration and getting error as

Error 1:

"A message sent to adapter "FILE" on send port "SendPortEDI" with URI "E:\Project Files\BIZTALK\210-RESTORATION HARDWARE\FinalTest\EDIOut\%MessageID%.txt" is suspended.

Error details: There was a failure executing the send pipeline: "Microsoft.BizTalk.Edi.DefaultPipelines.EdiSend, Microsoft.BizTalk.Edi.EdiPipelines, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" Source: "EDI assembler" Send Port: "SendPortEDI" URI: "E:\Project Files\BIZTALK\210-RESTORATION HARDWARE\FinalTest\EDIOut\%MessageID%.txt" Reason: A message was encountered with root element name of DS_RHW_210. It could not be classified as an X12 or Edifact message. The root namespace was http://schemas.microsoft.com/BizTalk/EDI/X12/2006Custom

MessageId: {6F2D1E93-F02C-4DC7-8782-962BD8B96854}

InstanceID: {730709F9-7C99-41E0-99BC-04DF76141C1D}"

Error 2:

"There was a failure executing the send pipeline: "Microsoft.BizTalk.Edi.DefaultPipelines.EdiSend, Microsoft.BizTalk.Edi.EdiPipelines, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" Source: "EDI assembler" Send Port: "SendPortEDI" URI: "E:\Project Files\BIZTALK\210-RESTORATION HARDWARE\FinalTest\EDIOut\%MessageID%.txt" Reason: A message was encountered with root element name of DS_RHW_210. It could not be classified as an X12 or Edifact message. The root namespace was http://schemas.microsoft.com/BizTalk/EDI/X12/2006Custom"

Thanks.

EDI Reporting again

Thu, 05 Nov 2009 15:29:01 Z

I posted a question about EDI reporting before and received some suggestions. I have been working on this for a while now and I can’t seem to come up with a solution to my problem.

I need the ability to track the following from out bound invoices (810), invoice number (BIG02), invoice date (BIG01) and acknowledgement status (997). I have tried promoting properties (distinguished and with property schemas) with no success. When I reached the conclusion that the EDI pipeline on my send port will not promote properties I decided to try and create a custom pipeline component to promote my properties. This failed as my custom pipeline needs to use the EDI assembler which I found out does not promote any of the message context properties associated with an EDI message (ISA segment, GS Segment, etc..) and does not give me a message that I could use XPATH queries to get my required values.

I need similar tracking for outbound 850 and 860’s and I can get everything I need because the EDI dis-assembler I use in my custom outbound pipeline promotes all the EDI message context properties and allows me to do XPATH queries.

If anyone has a possible solution or something to try I would appreciate it greatly. But for now I have to believe that the above EDI invoice tracking scenario is impossible in BizTalk 2006 R2.

Thanks

Create multiple ST_SE segments within one ISA_IEA envelope using BizTalk 2009

Sat, 07 Nov 2009 00:08:39 Z

Hi,
I am using BizTalk server 2009 for 837 outbound file generation. My 837 file should have one ISA_IEA segments in a file and the claims submitted by each provider should be created within each ST_SE segment. From the SQL DB I am receiving the claims information for each provider and trying to append them in a single file after the HIPAA assembler. The HIPAA assembler is creating ISA_IEA for each ST_SE and appending it in the file. How can I create multiple ST_SE segments within a single ISA_IEA segment.

HIPAA EDI Document Splitting - 837D

Tue, 21 Oct 2008 20:33:05 Z

Hey everybody,

We are encountering a problem with BizTalk Server 2006 R2 with regards to document splitting in the 837D EDI schema. In our current environment, we are running BizTalk Server 2006 and are attempting to move to BizTalk Server 2006 R2 for a new project we have underway.

The problem we are seeing is in how the EDI Engine in R2 is splitting up our EDI 837D files when they are picked up by BizTalk through a Receive Location that utilizes the EdiReceive Pipeline. In 2006, once an 837D EDI file was received, the HIPAA Accelerator would split the file into messages where each Claim (2300 Loop) was its own Message. I looked at the 837D schema (multiple) that came with 2006, and it appears this document splitting was based on the attribute subdocument_creation_break="yes" being speficied in the 2300 Loop XML node.

The 837D multiple schema that came with R2 also has subdocument_creation_break="yes" specified at the 2300 Loop, but it generates drastically different results than what we are seeing in 2006. In 2006, the 837D file, once translated to XML and split, would give us one Message per Claim where the information in the XML Message included only that information that pertained to the Claim. This would include information from the ISA segment, GS segment, ST segment, 2000A Loop, 2000B Loop, 2300 Loop, etc., all the way down to the most granular level of detail that pertained to the Claim, but would not include any information that did not pertain to the Claim.

Now, in R2, if this document splitting attribute is specified in the 2300 Loop, in each Message we still get only that information from the 2300 Loop on down that pertains to the Claim. However, we get all of the information from the higher levels in every Message generated by the EDI Engine. For example, if we have an 837D EDI file that has 3 Claims in it (3 2300 Loops), and each 2300 Loop has its own 2000B Loop as a parent (3 2000B Loops), each Message generated by the EDI Engine will contain only one 2300 Loop, but it was also contain all 3 2000B Loops. We have tried moving the attribute subdocument_creation_break="yes" to other higher levels in the 837D schema, but that can result in more than one 2300 Loop being included in each Message.

Basically, I'm trying to duplicate the processing output we are seeing in 2006, but I can't make it work in R2. We either get lots of unnecessary data in each Message, or we get multiple 2300 Loops in each Message.

Have any of you seen or experienced this same problem, and can help us achieve the desired result? Even if it is not possible in R2, that would be good to know. Every post I've read about the subdocument_creation_break="yes" attribute makes it sound like it works great, but it is not giving us the results we are looking for.

Thank you.

AS2 Messages bigger than 1 MB makes a MIC not verified failure

Thu, 05 Nov 2009 11:58:22 Z

Hi all,

if we receive messages bigger than 1 MB via AS2, the sender get the error "MIC not verified"

(Though UPXI has sent it successfully there have been some problems with regards its message integrity checking.

Upon investigation the message is experiencing a "MIC not verified" issue. )

The message itself is correctly processed on our side, but the sender side get everytime an error message.

Now I am not sure if it is a BizTalk problem while generating the MDNs for those messages or if it is a problem on the sender side.
Because this side says http://msdn.microsoft.com/en-us/library/bb226414(BTS.20).aspx messages up to 96 MB could be processed.

Kind regards
Peter

BizTalk 2009 support for EDIFACT messages ORDERS S93A and INSDES D96A

Sat, 31 Oct 2009 08:52:50 Z

Is there any way to get support for these EDIFACT message types in BizTalk?
I know there is support for this if I by the "Covast EDI Accelerator". But that seems to be overkill in my case.

Thanks,

/ola

Flat File Debatching

Wed, 04 Nov 2009 22:28:39 Z

Hi

I have to debatch a flat File with the following structure

UN1
.
.
.
UN1
.
.
.
etc.

I would like to do the devbatching with a pipeline.

My Schema has a root node and a record with an element inside

root
record
element (where the data is inside)

I cannot use a fully strutured schema because the the incoming flatfile have a different structure. The only characterisitca they have in common is the header record UN1.

I tired a lot but I did not succeed. How do I have to configure the child order and the child order delimiter type for this flat file?

Thanks for your help

Klaus Weber

Use of "Batches" Option in EDI properties of Party in BTS 2009

Wed, 11 Nov 2009 06:22:06 Z

Hi,

In the EDI properties of the Party, there is one option called "Batches". Please explain the use of this. In the Batches Option we can create new batch and we have to give the number of "Groups" and "Interchanges". What is the use of these settings. Will this helps to create more than one group in the EDI file. If so how will be create the groups?

BizTalk - EDI Batching per interchange

Tue, 03 Nov 2009 15:56:08 Z

Hello all,

I'm having a problem with the EDI batching in BizTalk 2009 (and BizTalk 2006 R2 for that matter).

My situation is the following:

I have one specific FF message which I map into one or more (EDIFACT) DESADV messages and always one (EDIFACT) IFCSUM message.

These messages need to be combined into one and the same EDI interchange, so I'm using the Batching orchestration built-in into BizTalk 2009.

As a result I need to get one EDIFACT interchange with the IFCSUM always as the last within the interchange.

My solution so far:

I have one orchestration which splits (and maps) the incoming FF into one or more DESADV messages and into one IFCSUM message.

These are put on the message box and picked up by a send port to the FILE system (EDISend pipeline).

From there, they are picked up again by a FILE receive location (EDIReceive) *

* Reason for this is that apparently it is impossible to call the EDI send/receive pipelines from within an orchestration?

I need to do this, because the batching orchestration only batches with complete EDI messages (meaning that they need to have UNH for example filled in).

From there, I use another orchestration that activates on the receive of a DESADV and will then listen for more DESADV messages until a timer of 15 seconds is ended as of which it then listens for the IFCSUM.

After each receive of a message that validates these rules, I send it to the Batching orchestration (which is setup in my Party setup).

Then an external release trigger message is sent to complete the interchange and send it out to a send port.

My questions:

1) Is there any way to call the EDI Send/Receive pipeline from within my orchestration?

I have searched A LOT and found nothing useful.

2) Now, when 2 FF messages are received within a short time frame (few seconds), these are mixed up between the interchanges and completely invalidates my output.

Is there any way to solve this? (also see http://social.msdn.microsoft.com/forums/en-US/biztalkediandas2/thread/ea6bb531-d095-47d5-a51b-b4c892553eec/ for the same issue)

3) Any pointers as to where I can improve the solution? I don't feel comfortable with the 15 second timer for example...

All help is really appreciated!

Kind regards,

Pieter