Issue with Sequence counter in PI mapping

[Former Member]

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!

[helmut_skolaut3 · Accepted solution]

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

[former_member385138]

Hello,

this has been solved by sharing directories of ECC with four nodes of PI

[former_member190293]

Hi Lisin!

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

Regards, Evgeniy.

[weberpat]

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.

[former_member385138]

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?