Problems with flatfile parsing

Home Page Forums BizTalk 2004 – BizTalk 2010 Problems with flatfile parsing

Viewing 3 reply threads
  • Author
    Posts
    • #17283

      Hi everyboy,

       I have some problems getting BizTalk to work with my flatfiles… I already created a schema and validated it. The mapping also seems to work quiet right. When I validate an instance in the schema and put the generated .xml file to test the map it generates the desired output. Now i made a custom pipeline with a flatfile disassambler, deployed the solution and configured the ports. when I use the custom pipeline it will throw an error (Error Code 0xc0c01627) … If i use the XML pipeline and drop the generated xml file mentioned before to the receive location it'll work…

      Any ideas or suggestions what i'm doing wrong?

       

    • #17287

      Anon-Again,

      there is a further validation step you can try. Set the properties of the map to take a native file input and then point it at your flat-file. It will do both the conversion and the mapping in one step.

      You don't say what the error message means. What is the text you see in the event log?

      John D.

      • #17289

        Thanks for the quick answer.

         The test with the native file also succeeded…

         

        The error message reads : The Messaging Engine encountered an error during the processing of one or more inbound messages.

    • #17291
      • Have you configured the Flatfile Disassembler in the custom Pipeline with the correct schema?
      • Have you deployed the entire application from the Solution, and not from each Project?
      • Have you Selected the proper Pipeline from the drop down in your Receive Port configuration?
      • Have you restarted the Host Instance for the Application to be sure your changes have taken effect?

      I'd ask about Folder permissions, but apparently that's fine or you wouldn't get an XML file to work.

      • #17292
        • yes the custom Pipeline holds the flatfile disassembler which is configured with the proper schema
        • i did it like i learnd it from the microsoft tutorials so yes again
        • the custom Pipeline is selected in the Receive Port configuration
        • i also did that

        for the folder permission: i configured a ver unsecure version for testing where all services etc run under local admin…

        • #17294

          The only thing I can suggest now is to verify that all suspended messages are cleared out before trying each time and list here any BizTalk event messages that get generated.  Otherwise, it sounds like it should work.  Maybe you can list out your configuration, if its simple enough, to see if anyone has seen a problem before or some simple "gatchas".

          • #17297

            I cleared out the messages but the error is everytime the same. I now tried to go with the passThru pipeline and got 2 rooting error messages

             This service instance exists to help debug routing failures for instance "{C1B592AA-DF19-4465-AAF6-B3390C00BC7E}". The context of the message associated with this instance contains all the promoted properties at the time of the routing failure.

            and

            The published message could not be routed because no subscribers were found. This error occurs if the subscribing orchestration or send port has not been enlisted, or if some of the message properties necessary for subscription evaluation have not been promoted. Please use the Biztalk Administration console to troubleshoot this failure.

            Maybe this gives a hint what is wrong…

            Concerning the configuration, to be honest i don't know which information i should post…

            • #17299

              The Pass Thru won't work, so any error messages you receive are expected.

              • What do your flat file and flat file schema look like?
              • What are you doing with the results of your receive port?
              • Are you using an Orchestration, and if so, how?

              In other words, what did you build to get to the point you are at now?

              • #17301

                In simple form my Flatfile looks like this

                <CustomerID>;<ProductID>;<Productname>;<andSoOn>;

                <CustomerID>;<ProductID>;<Productname>;<andSoOn>;

                <CustomerID>;<ProductID>;<Productname>;<andSoOn>;

                my schema looks like this

                <Schema>

                    – ClaimList

                          – Claim

                                – CustomerID

                                – ProductID

                                – Producname

                                – andSoOn

                max occurs are set to 1 so it breaks down the flatfile to several messages.

                Then it comes to an orchestration where the values are mapped to another schema and then thex come to the sendport (also File)

                • #17302

                  So i played a littlebit around and get new error messages… the ones i got for the passThru pipeline …

                  i testet the flatfile disassembler with the pipeline tools and that worked so it seems like the schema and input file work correct together

                  • #17303

                    okay i promoted the values, enlisted the orchestration and BAM it works ^^ thanks for your help guys

                    • #20943

                      Hi,

                      I am a newbie learning Biztalk. 

                      My application goes as follows:

                      I have an input csv file with 4 rows. I put it in a input folder.  I need to split the message into 4 individual csv files (each row in a separate file) and the result should come in output folder.. I use receive and sent pipelines only. I also promoted all the fields using Property fields. i tried everything suggested above (except that i dont have an orchestration for my project as it is not needed in this case). 

                      The input message is being picked but I dont get output. The error is “The Messaging Engine encountered an error during the processing of one or more inbound messages. “

                      Can anyone help please?

    • #32895
      Saravana Kumar

        This is just a test reply to see BB forum functionality

    Viewing 3 reply threads
    • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.