Invalid character in data element with EDI X12

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Invalid character in data element with EDI X12

Viewing 1 reply thread
  • Author
    Posts
    • April 22, 2010 at 11:20 AM #24618
      community-content

        Hi,

        I have a Biztalk solution using EDI 214.  In short, I receive files in this format that I insert into a SQL DB (after some transfomrations).

        But nevertheless the multiple steps involved, some messages containing special characters (like ” ï ” ) generates the message “Invalid character in data element “.

        This is for a receive location, no parties defined in the solution.  What property should be modified to accept these international characters?

        Thanks,

        Martin

      • April 22, 2010 at 12:44 PM #24619
        community-content

          Hi Martin,

           

             See if the discussion from this BizTalkGurus thread provides you the solution to your problem:

          http://www.biztalkgurus.com/forums/p/2239/8618.aspx#8618

           

             Daniel.

           

          • April 22, 2010 at 2:47 PM #24621
            community-content

              Well, seems like a good fit. I need to re-arrange my solution in order to test it though, I’ll confirm later.

              Thanks!

              Martin

              • April 22, 2010 at 4:08 PM #24622
                community-content

                  Well no lock..  Whatever the encoding I select, still the same output.

                  I set the custom tool in the DECODE node, and a EDI disassembler in the DISSAMBLE one.  Is there any option other than gettin grid of EDI and transform to pure XML?

                  Martin

                  • April 23, 2010 at 2:13 PM #24623
                    community-content

                      All right,  I resolved the issue by using the custom pipeline to encode the file in UTF8, and then set the character set to UTF8 (which makes sense) in the receive pipeline as well as global EDI properties. I have to encode the file on receive since I am receiving the file from a customer and the encoding can’t be changed there.

                      Thanks for your help!!

                      Martin

            • Author
              Posts
            Viewing 1 reply thread
            • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.