OSB Reporting Failed with ORA-01461 (Doc ID 2683339.1)

Last updated on AUGUST 06, 2023

Applies to:

Symptoms

Seeing below error in OSB log:


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

DDL of table: WLI_QS_REPORT_ATTRIBUTE

CREATE TABLE OSBPR01.WLI_QS_REPORT_ATTRIBUTE
(
MSG_GUID VARCHAR2(64 BYTE) NOT NULL,
DB_TIMESTAMP DATE DEFAULT SYSDATE NOT NULL,
LOCALHOST_TIMESTAMP DATE NOT NULL,
HOST_NAME VARCHAR2(50 BYTE) NOT NULL,
STATE VARCHAR2(8 BYTE) NOT NULL,
NODE VARCHAR2(128 BYTE),
PIPELINE_NAME VARCHAR2(128 BYTE),
STAGE_NAME VARCHAR2(128 BYTE),
INBOUND_SERVICE_NAME VARCHAR2(256 BYTE) NOT NULL,
INBOUND_SERVICE_URI VARCHAR2(128 BYTE) NOT NULL,
INBOUND_OPERATION VARCHAR2(64 BYTE),
OUTBOUND_SERVICE_NAME VARCHAR2(256 BYTE),
OUTBOUND_SERVICE_URI VARCHAR2(256 BYTE),
OUTBOUND_OPERATION VARCHAR2(64 BYTE),
MSG_LABELS VARCHAR2(3999 BYTE),
ERROR_CODE VARCHAR2(64 BYTE),
ERROR_REASON VARCHAR2(3999 BYTE),
ERROR_DETAILS VARCHAR2(3999 BYTE)
)

Cause

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