My Oracle Support Banner

Report Generation Features of SMS Screens Fail with ORA-29283 and ORA-06512 Errors (Doc ID 1571992.1)

Last updated on MARCH 04, 2019

Applies to:

Oracle Communications Network Charging and Control - Version 5.0.0 to 5.0.1 [Release 5.0]
Information in this document applies to any platform.

Symptoms

When running the following report :

Operator functions -> Report functions -> CCS -> Summary -> Account Balance Report -> Generate report

the report is not generated.

Corresponding SMS screen for the report :

Following error messages appear in a temporary file generated in /<DIR>/Summary/ :

05/31/13 16:06:53 No mailing list configured.
05/31/13 16:06:53 Producing report type: balancesCsv
05/31/13 16:06:53 Data Warehouse routine started
05/31/13 16:06:53 Connecting to Oracle to process data
05/31/13 16:06:53 /<DIR>//balanceSummary.csv.tmp does not exist
 DECLARE
*
ERROR at line 1:
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
ORA-06512: at line 31

However, running the report manually via the command line generates the correct report.

Example command below :

/<DIR>/Summary$ ./ccsAccountBalance.sh report=balancesTxt configFile=./<DIR>/dwsublist.cfg debug=no

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.