Skip to Content
avatar image
Former Member

Tricky logic

HI experts,

I am having  an idoc to file scenario...and also, we are making use of ATP setting, where we would be sending only one FILE at the end of the day to the target.

we need to generate a UNIQUE seq number on a daily basis...it shoul be common for all the files which gets generated on  a particular day  and same is sent to target

means,

Monday seqnum: 100

Tuesday seqnum:102.

so on..

here generating uniq seq num is not an issue.

problem is Any gaps in the sequence of transmission number sent to the target  will result in breaking of the automatic process and need manual intervention.

the gaps can be due to data issue(mapping) and also could be from the connectivity issue from target side...means,in any case, the seq shouldnt get affected...

For ex, if the message failed in PI on wednesday  which has seq_id as 103...for which we had to resend the message from PI again, there by it's seq_id gets incremented to 104...but actually it was suppose to be 103..how do we take care of this.

can someone please provide me the best soluion wiht steps?

thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Aug 27, 2012 at 11:06 AM

    Need more clarity - How you are generating sequence id and taking reference in your interface , is it in mapping or outside of PI or ....

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Udo Martens

      Hi Udo,

      here we are making use of temp folder to collect all the files per day..it will append all the files.

      IDOC-->tempfolder(NFS)----> Final target file(FTP).

      temp folder will be keep appending the files as and when a new idoc is getting triggerd till night 7pm...we have set ATP here..at 7pm, the final file would be sent to target syste

  • Aug 27, 2012 at 10:40 AM

    Hi,

    the standard solution for this kind of requirements are EOIO queues (exactly once in order). This message queues will only deliver in sequence of sending, otherwise the queue will be stopped. In case of errors you need to correct the error and the messages are delivered in the right sequence.

    Regards,

    Udo

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 27, 2012 at 06:24 PM

    I worked on couple of time similar requirement , when you implement sequencing at mapping level then problem comes when message failed in PI.

    The solution for this kind of requirement is whenever place a file in FTP write some scritping mechanism to add sequence number to file name.

    this solves your probelm.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Raja,

      But scripting works only if it is NFS right? but we are placing a file in FTP. correct me if  i am wrong.

      and also, we should maintain a SIMILAR Sequence number for all the files which gets generated on a DAY wise..it should increment only  for the next day files.

      please advise.