CCS Report Function Does Not Work with Error ORA-02019 (Doc ID 1364979.1)

Last updated on SEPTEMBER 12, 2016

Applies to:

Oracle Communications Network Charging and Control - Version: 4.3.0 and later   [Release: 4.3 and later ]
Information in this document applies to any platform.

Symptoms


The Service Management Screen has the Report Function which allows you to manage reports on which the data source can be based on various applications, one of them is CCS based report

The Report Function can be accessed via SMS Screen -> Operator Functions-> Report Functions

Note: The time and date used is the system date of the SMF database, which is not necessarily the same as the local time of the user scheduling the report.

On SMS Report Function Screen, you can schedule when that particular report should be generated, it is called Scheduled Report.

When the scheduled report is running, the process will be logged into specific trace file which is located in SMS server on /IN/service_packages/SMS/output directory. The file name will follow the following convention:

smsReport-[Scheduled Report Identity]-[nn].lst

Note:
- Scheduled Report Identity is based on the value of description of Scheduled Report in the screen.
such as TestRun2, SomeReportTest as presented by Image 01
- nn is the sequence number
For more details information about SMS Report Function please refer to SMS User Guide.


The Charging Control Services (CCS) Report Function process terminated with error ORA-02019 as seen by this following trace:

PL/SQL Failed with -2019 - ORA-02019: connection description for remote database not found
DECLARE
*
ERROR at line 1:
ORA-20101:
ORA-06512: at "CCS_ADMIN.DWSUBLIST", line 620
ORA-02019: connection description for remote database not found
ORA-06512: at line 17


Please review Doc Id. 19302.1 for more details about ORA-02019

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms