none
BizTalk 2009 File Adapter Send with Append Locks Target File Indefinately

    Question

  • We have some EDI files coming in to our BizTalk server that we drop off on a file share for processing by an end system.  The files are dropped to the file share via a single File Send Port with a static file name.  The files are delivered with the Append option set as the end system only collects the files once a day.

    We're running with a single host instance for the send port.  The file share is located on a separate server.  When we go out to that server (Widnows 2008) and view the open files, we see two read locks on the file from the BizTalk host instance account.  The messages are suspending in BizTalk with Access Denied messages.  The files are written to the file share separated by minutes and sometimes in the same minute.  None of the files are large (all < 20K).  This happens maybe once a week and happens on different file drop locations on the target server.  Recycling the host instance does not release the locks.  Ordered delivery doesn't help.  On the file share server, we have to manually kill the locks from the BizTalk host instance to get it back up and running.

    Any thoughts or input to solving the problem or troubleshooting would be helpful.  Some things I have been considering:

    1. File adapter losing it's file handles?
    2. Anybody use append mode in the file adapter with no issues before?

    Thanks!

    6/27 - We also experienced this in our test environment.  This is a whole separate set of hardware. 

     


    http://www.implementsivillage.net
    Thursday, June 23, 2011 1:19 PM

Answers

  • Hello Christian,

    This is an issue with the append option because Biztalk reads to end of the file before appending.

    My recommendation would be to write separate files and then create a separate process/program to stitch them together if it needs to be in one file.

     

    Thanks,
    Belinda

    Friday, July 01, 2011 8:39 PM

All replies

  • Hi, 
     
    Thank you for your question. I am trying to involve someone familiar with this topic to further look at this issue. There might be some time delay. Appreciate your patience.

    Regards


    MSDN Community Support
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    This posting is provided "AS IS" with no warranties, and confers no rights. My Blog: http://xhinker.com
    Microsoft Windows Workflow Foundation 4.0 Cookbook
    Monday, June 27, 2011 3:27 AM
  • Hello Christian,

    This is an issue with the append option because Biztalk reads to end of the file before appending.

    My recommendation would be to write separate files and then create a separate process/program to stitch them together if it needs to be in one file.

     

    Thanks,
    Belinda

    Friday, July 01, 2011 8:39 PM
  • Thanks for the information.  This is kind of concerning news.  This has been a core adapter for almost a decade.  Is this an issue specific to BizTalk 2009?  Is there a hotfix?
    http://www.implementsivillage.net
    Tuesday, July 05, 2011 1:11 PM