IBM Support

Double Records in yfs_export table when PUBLISH_SHIP_ADVICE in Send Advice Tran

Troubleshooting


Problem

Double Records in yfs_export table when PUBLISH_SHIP_ADVICE in Send Advice Tran

Symptom

After introducing a new ship node into their production system, they noticed that the every time the Send Advice Agent ran, two entries got created in the yfs_export table, although only one action was configured.
The two entries are exactly same except the export_key is off by 1. VERY CLOSE to each other in time.

PART: Platform-Config 5.0 SP1 Platform
PRODUCT: Distributed Order Management

Cause

Resolving The Problem

It was diagnosed that this was because of in the Node setup, and event was configured, which incidentally was the same action as this action, so it got fired off twice.

[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Historical Number

PRI49299

Product Synonym

[<p><b>]Fact[</b><p>];

Document Information

Modified date:
16 June 2018

UID

swg21522977