My Oracle Support Banner

2.4 Error While Printing Certain Switch Sheet (Doc ID 2597640.1)

Last updated on OCTOBER 09, 2019

Applies to:

Oracle Utilities Network Management System - Version 2.3.0.2.0 to 2.4.0.1.0 [Release 2.3 to 2.4]
Oracle Network Management for Utilities - DMS - Version 2.3.0.2.0 to 2.4.0.1.0 [Release 2.3 to 2.4]
Information in this document applies to any platform.

Symptoms

On : 2.4.0.0.0 version, Web Switching

2.4 Error while printing certain switch sheet

Web Switching shows an error when attempting to print certain switch plans.

Failed to generate report [...],

Cause: Client received SOAP Fault from server:
oracle.xdo.webservice.exception.OperationFailedException:
PublicReportService::generateReport for reportAbsolutePath
[/NMS_BI/WebSwitching/Templates.xdo] failed: due to oracle.xdo.server.ServerException:
oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException:
oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLException:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "PGE_NMS.FN_GET_LONG_DESC", line 22
Please see the server log to find more detail regarding exact cause of the failure.





The issue can be reproduced at will with the following steps:
NOTE: This is only an issue when your project has control_act records with switching_desc entries that are more than 100 characters.

1. Record a step into a switching sheet that is tied to a control_act record that has a long switching_desc value.
2. Attempt to do a Print Preview for that sheet.



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
References


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