My Oracle Support Banner

JMS Messages Driven Into Limbo by SQL Errors (Doc ID 2074257.1)

Last updated on JUNE 15, 2022

Applies to:

Oracle Commerce Platform - Version 10.0 and later
Information in this document applies to any platform.

Symptoms

Application processing that is normally driven by JMS-based events becomes throttled and the number of rows in the DMS_LIMBO_MSG table begins to grow.

Application server logging shows database errors in the nature of "value too large for column" (ORA-12899, on an Oracle database) that names a SQL table used by the Oracle Commerce JMS impelementation: SQLDMS. The table named in the errors is DMS_MSG_PROPERTIES. It is the value column that lacks sufficient storage. The name of the property in the failed INSERT operation is "singularityheader".

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.