Skip to Content
avatar image
Former Member

Issue with Sequence counter in PI mapping

Hello Experts,

We are facing an issue where sequence counter in file is not getting updated properly and resulting in incorrect data.

Requirement: Sequence number should be generated date wise for every file processed on same data.

Setup in PI : Using "sequence.properties" file for temporary storing count.

Problem: Sequence not generated properly.

Cause : At run time in PI server, we have 2 pair of nodes thus two different server, Ultimately four different folder locations named as below.

Node 1 : /usr/sap/<PI Server>/J11/j2ee/cluster/server1

/usr/sap/<PI Server>/J11/j2ee/cluster/server0

Node 2: /usr/sap/<PI Server>/J11/j2ee/cluster/server1

/usr/sap/P<PI Server>/J11/j2ee/cluster/server0

So we have four different temporary files, here logic fails and uniqueness is not achieved.

Please suggest, how to resolve this.

Thanks in advance!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Apr 21, 2017 at 06:35 PM

    Hi Lisin,

    Do I understand your problem like this: the message has a uniq number that is like a counter? If yes, you can solve this by:

    1) Using the B2B Add-on module to replace a counter in the receiver adapter just before the file is transferred through the channel

    2) Try to use an EOIO Scenario - that you don't have any parallel processing anymore

    Regards
    Helmut

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 13, 2017 at 08:00 AM

    Hi Helmut,

    Thank for suggestion,

    Sequence or count is generated at mapping level (UDF) where because of having four different server nodes we are not able to achieve uniqueness.

    Is there any way we can access ECC's folder location from UDF to have only one file instead of 4?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 15, 2017 at 12:53 PM

    Other members have already pointed out that you should use the Number Range Objects provided by the SAP B2B Addon or Seeburger Counter variables if you have either of the two addons installed. If neither is available you have two alternative options:

    - Create an ABAP Number Range Object and access it through RFC (I would not recommend to create it on the local PI machine if you're still on dual stack as you will run into problems once you try to migrate to PO)
    - Store counters in the local SQL database and access them using an SQL lookup in your mapping.

    Add comment
    10|10000 characters needed characters exceeded

  • May 15, 2017 at 01:39 PM

    Hi Lisin!

    Do you have multiple PI instances on the same physical server?

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded