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".
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."
"ORA-01438: value larger than specified precision allowed for this column."
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.
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,
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.