My Oracle Support Banner

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

Last updated on JUNE 23, 2021

Applies to:

Oracle Service Bus - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

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

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.