A SQL Time Out Error is Occurring On the Standard Agent Action -"Match Object by Tracking Number"
(Doc ID 3018320.1)
Last updated on APRIL 30, 2024
Applies to:
Oracle Transportation Management Cloud Service - Version 24.1 and laterInformation in this document applies to any platform.
Symptoms
Users have an automation agent setup as type = "TRACKING EVENT" and in the agent body the first action is to "MATCH OBJECT BY TRACKING NUMBER" using the field "ORDER RELEASE SHIP UNIT REFERENCE NUMBER" = a given static value.
Upon this tracking event being triggered- a SQL timeout is occurring and the users are being notified via the agent error email.
ERROR
-----------------------
Tracking Event 122460096 - ERROR IN AGENT XXX.XX-TRACKING-EVENT-MATCHING-V5 - line 1 - action MATCH OBJECT BY TRACKING NUMBER
java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation
Steps to Replicate the issue
- Setup an agent to use the action "MATCH OBJECT BY TRACKING NUMBER" using the field "ORDER RELEASE SHIP UNIT REFERENCE NUMBER" = a given static value.
- Create a tracking event via INTEGRATION or UI with the ORDER RELEASE SHIP UNIT REFERENCE NUMBER = the static value in the agent.
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |