My Oracle Support Banner

" ORA-01489 SQLException: String Concatenation Result Too Long" Occurs During NMS Operations (Doc ID 2962342.1)

Last updated on AUGUST 17, 2023

Applies to:

Oracle Utilities Network Management System - Version 2.5.0.2.0 to 2.6.0.0.0 [Release 2.5 to 2.6]
Oracle Network Management for Utilities - DMS - Version 2.5.0.2.0 to 2.6.0.0.0 [Release 2.5 to 2.6]
Information in this document applies to any platform.

Symptoms

On : 2.5.0.2.0 version,

ORA-01489 SQLException: String Concatenation Result Too Long in Oracle NMS

We are encountering an ORA-01489 error in Oracle NMS during operations. The log from the managed server displays an SQL Exception due to "result of string concatenation is too long".


The SQL query attempted is:



ERROR
-----------------------
ERROR crew.MobileOperationsBean: internalQuerySwitchSheets: ORA-01489: result of string concatenation is too long

Changes

 

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
Changes
Cause
Solution
 Fix Description
 Migration
References


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