none
Log of successful processed files RRS feed

  • Question

  •  

    In processing the EDI messages and sending the information to Oracle DB, I need to store log and file details of all the successfully processed files based on the response received from the Oracle DB. Kindly advice how the same can be done.

    The failed message routing is enabled in the send and receive port for capturing the exceptions in the receive or send port. Also kindly provide a workaround for capturing the exceptions in the orchestration (i,e. the processing failed at the orchestration level).


    Regards, Vivin.

    Friday, May 23, 2014 10:36 AM

Answers

  • That's not very many data points.  Why not just create an entry when an interchange is received then 'close' it when 'processing' is done.

    Then consider any interchange that's been in 'received' state for an unusually long time to be an error state.

    • Marked as answer by Vivin Muthu Tuesday, June 3, 2014 6:40 AM
    Friday, May 23, 2014 12:42 PM

All replies

  • For Catching Exception you can set orchestration transaction scope = None and add Exception Block. There you can Throw new Exception, or promote properties etc.. to route messages to some other application.

    Didn't get you when you say, log details, messages. Log where? Database or FiileArchive?


    Friday, May 23, 2014 11:31 AM
  • Since I am new BizTalk could you explain about the scope and exception block more. The log details needs to be written to the database for each and every file processed.

    Regards, Vivin.

    Friday, May 23, 2014 11:53 AM
  • Adding to the above, the fields that will be required are file name, location, processed status, processed date/time.


    Regards, Vivin.

    Friday, May 23, 2014 12:24 PM
  • That's not very many data points.  Why not just create an entry when an interchange is received then 'close' it when 'processing' is done.

    Then consider any interchange that's been in 'received' state for an unusually long time to be an error state.

    • Marked as answer by Vivin Muthu Tuesday, June 3, 2014 6:40 AM
    Friday, May 23, 2014 12:42 PM
  • Since I am new BizTalk could you explain about the scope and exception block more. The log details needs to be written to the database for each and every file processed.

    Regards, Vivin.

    Here is a very basic example of Exception handling:

    http://www.enterpriseapplicationsdevelopment.com/2010/07/exception-handling-in-orchestrations.html

    Regarding logging, Create a table which has few columns like, CreateDate, UserID, FileName, Status

    while first 3 columns are good for tracking file process times etc, Status column you can update at several places, for eg when your are loading file related information, set status = "Started" , once your last stored proc is executing or know when processing is done, you can make another call that updates to "Completed". And in your exception block, you can make one call to update status = "Errored" etc.. depending whatever you like.

    Once you have all status tracked, you will know what the current status is for particluar file.

    Saturday, May 24, 2014 3:20 AM
  • We already have a table for the log details. Is there any possibility to update the log details based on the response from the Oracle DB in the orchestration.

    Regards, Vivin.

    Monday, May 26, 2014 4:56 AM