RNCpm files fail during processing with ORA-01438 error

Technote (troubleshooting)


Problem(Abstract)

RNCpm file processing is failing and moved to the fail directory, and the log file shows messages like this: "ORA-01438: value larger than specified precision allowed for this column".

Symptom

The RNCpm file (example: <marketname>.201106082100.30.RNCpm) has been moved to the fail directory and the corresponding log file contains errors like these:


"The <marketname>.201106082100.30.RNCpm has been moved to the fail directory and gzipped. File processed failed for some reason."

and

"ORA-01438: value larger than specified precision allowed for this column."

Cause

This issue is caused by the value of some of the Peg counters exceeding the number of digits in the corresponding table in the database.

Environment

Prospect for Nortel CDMA

Diagnosing the problem

Check the corresponding log file for errors like these:


23:49:40,718 ERROR [DataHandler] Error executing SQL: INSERT INTO
NOR_TF_EMS_RCARDRESRC_LTM (RESOURCECOUNTMINORPREVIOUS, RESOURCENAME,
RESOURCESECONDSCRITICALPREVIOU, RESOURCESECONDSHEALTHYPREVIOUS,
RESOURCESECONDSMAJORPREVIOUS, RESOURCESECONDSMINORPREVIOUS,
RESOURCETIMEINTERVAL, RESOURCETIMEINTERVALTHRESHOLD,
RESOURCEWATERMARKPREVIOUS, RESOURCECOUNTCRITICALPREVIOUS,
RESOURCECOUNTHEALTHYPREVIOUS, RESOURCECOUNTMAJORPREVIOUS, ID, TSTAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), Error executing batch
for table: NOR_TF_EMS_RCARDRESRC_LTM, ORA-01438: value larger than
specified precision allowed for this column.


Resolving the problem

This issue needs further investigation by Prospect support.

Please open a PMR and provide an example of an affected RNCpm and raw data file, plus the corresponding log file.


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Prospect

Software version:

8.0.7

Operating system(s):

Solaris

Reference #:

1503347

Modified date:

2013-05-17

Translate my page

Machine Translation

Content navigation