In Manufacturing Operations Center - Concurrent Program Error When Have A Negative Value For An Unmapped Tag
(Doc ID 2099503.1)
Last updated on MARCH 16, 2020
Applies to:Oracle Manufacturing Operations Center - Version 12.2.4 and later
Information in this document applies to any platform.
On a 12.2.4 Instance in Manufacturing Operations Center
Concurrent Program Error when have a negative value for an undefined tag
When loading a csv file (MTH_TAG_READINGS_RAW.csv) which has a tag reading record for a tag that has not been created and has a negative value, the concurrent program ends with an error of "No Data Found".
MTHPTXN: MTH: Process Transactions
Exception OTHERS in INCR_READINGS_FROM_RAW
ORA-01403: no data found
Root Cause: This happens when we have defined the tag and miss to map to attribute, and try to pass negative value in mth_tag_readings_raw.
Expected behavior: The CP should write a message in log file
and complete with warning.STEPS
The issue can be reproduced at will with the following steps:
(1) Create a CSV (MTH_TAG_READINGS_RAW.csv) with an invalid tag, I.E. tag which does not exist in the MOC instance, and give it a negative value.
(2) Run the Scenario MTH_PKG_TAG_READINGS_RAW
(3) Run the concurrent program "MTH: PROCESS TRANSACTIONS".
(4) The request will end with a staus = 'ERROR'.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document