My Oracle Support Banner

Equipment Type Agent Action 'Increment Button' Fails to Run with "java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (GLOGOWNER.UK_SKU) violated" Exception (Doc ID 2676484.1)

Last updated on JUNE 24, 2020

Applies to:

Oracle Transportation Management - Version 6.4.3 and later
Oracle Fleet Management - Version 6.4.3 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
An equipment type automation agent is configured to use the 'Increment Bucket' action. When the 'Increment Bucket' equipment agent action is executed, OTM is inserting duplicate SQL insert statement . This results in a unique key constraint error) when creating a SKU that does not previously exist. When the agent executes this action, the action will fail with the following exception:

 

ERROR
---------------

 

EXPECTED BEHAVIOR
-----------------------
It is expected that the agent action execute successfully with no errors.

 

STEPS
-----------------------
The issue can be reproduced with the following steps:

1. Configure an equipment agent type with an agent action of 'Increment Bucket'
2. For the increment bucket agent action, ensure that the location ID specified as a parameter for this action does not currently exist in OTM as a location asset inventory.
3. Trigger the automation agent
4. The agent will fail with the above exception.



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
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.