RosettaNet PIP Tracking Service fails with Threshold Release Forecast Notification was expected on Inbound data

Technote (troubleshooting)


Problem(Abstract)

RosettaNet PIP Tracking Service fails with:

ERROR 000000000000 GLOBAL_SCOPE [RNPIPTracking] Step #1 - Threshold Release Forecast Notification Action for PIP instance ID 654292358:39451faff70de1100034c34b - PIP4A3 V02.02. Threshold Release Forecast Notification was expected.
[2012-06-21 08:03:13.288] DEBUG 000000000000 GLOBAL_SCOPE [RNPIPTracking] processData() complete

In rnif.log

Cause

There is a mismatch between the value that the Trading Partner is sending in the Global Business Action Code and what you have defined in the PIP_DEF and PIP_STEP tables. The 4A3 document shows:

<GlobalBusinessActionCode>Threshold Release Forecast Notification Action</GlobalBusinessActionCode>


Diagnosing the problem

Run the following database query to determine the value of PIP_BUS_ACTION:


select PIP_CODE, PIP_VERSION, STEP_ID, PIP_BUS_ACTION from PIP_STEP where PIP_CODE = '4A3' and PIP_VERSION = 'V02.02' and STEP_ID = 1;

Example:
+----------+-------------+---------+------------------------------------------------+

| PIP_CODE | PIP_VERSION | STEP_ID | PIP_BUS_ACTION |

+----------+-------------+---------+------------------------------------------------+

| 4A3 | V02.02 | 1 | Threshold Release Forecast Notification Action |

+----------+-------------+---------+------------------------------------------------+


Resolving the problem

If the value returned for PIP_BUS_ACTION is not 'Threshold Release Forecast Notification Action', then you (with a full backup of SI and the database on hand and under the supervision of the DBA) can run the following query on the database:


UPDATE PIP_STEP SET PIP_BUS_ACTION = 'Threshold Release Forecast Notification Action' WHERE PIP_CODE = '4A3' and PIP_VERSION = 'V02.02' and STEP_ID = '1';


Rate this page:

(0 users)Average rating

Document information


More support for:

Sterling B2B Integrator

Software version:

All

Operating system(s):

All

Software edition:

All Editions

Reference #:

1599701

Modified date:

2013-09-20

Translate my page

Machine Translation

Content navigation