OSM Compliance Command Is Failing On One Managed Server or Order creation failed (Doc ID 2573150.1)

Last updated on MARCH 31, 2023

Applies to:

Symptoms

OSM compliance command is failing on managed_server2

wls:/offline> connect('<USER>', '<PASSWORD>', 't3://<IP>:<PORT>')
Connecting to t3://<IP>:<PORT> with userid <USER> ...
Successfully connected to managed Server "managed_server2" that belongs to domain "osm_domain".

Warning: An insecure protocol was used to connect to the server.
To ensure on-the-wire security, the SSL port or Admin port should be used instead.

wls:/osm_domain/serverConfig/> osmCompliance("osm_compliance","osm_compliance/compliance-config-override-v2.0.0.xml")
Location changed to custom tree. This is a writable tree with No root.
For more help, use help('custom')

Executing compliance() method.
Output directory set to [osm_compliance].
Compliance configuration override path set to [osm_compliance/compliance-config-override-v2.0.0.xml].
Method returned the following code: FAILED

(or)

Order creation getting failed with more than one order trying to fetch the same OSM Sequence ID, resulting in the following exceptions

WARN AbstractOrderCacheManager:1580 - Order creation failed for order id [xxxxxxx]. OSM will attempt to create order with new order id.
INFO OrderIdGenerator:228 - Order id generator #0: Loaded order Id block (xxxxxx, xxxxxx). The next available order Id is xxxxxx.
WARN AbstractOrderCacheManager:1583 - Reseeding the order id generator for order creation: Original Order ID: [xxxxxx] Reset Order ID: [xxxxx]
WARN AbstractProxy:271 - SQL Exception ORA-00001: unique constraint (xxxx.XPKOM_ORDER_HEADER) violated
ORA-06512: at "xxxx.OM_WF_API", line 4572
ORA-06512: at "xxxx.OM_WF_API", line 4488
ORA-06512: at "xxxx.OM_HANDLER_PKG", line 1747
ORA-06512: at "xxxx.OM_HANDLER_PKG", line 1790
ORA-06512: at line 1
: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (xxxx.XPKOM_ORDER_HEADER) violated
ORA-06512: at "xxxx.OM_WF_API", line 4572
ORA-06512: at "xxxx.OM_WF_API", line 4488
ORA-06512: at "xxxx.OM_HANDLER_PKG", line 1747
ORA-06512: at "xxxx.OM_HANDLER_PKG", line 1790

Cause

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