Support Article

UsageDaemonImpl ORA-01438: value larger than specified precision

SA-38281

Summary



Running a bix extraction throws the following error. Although the extraction actually completes successfully the extraction execution history tab has an error instead of 100% success.

Error Messages



2017-05-18 04:03:01,531 [egaRULES UsageDaemon] [ STANDARD] [ ] [ ] (nitor.internal.UsageDaemonImpl) ERROR - Unable to save usage data to the database; verify that the table for Log-Usage has the correct schema
2017-05-18 04:03:01,531 [egaRULES UsageDaemon] [ STANDARD] [ ] [ ] (nitor.internal.UsageDaemonImpl) ERROR - Error occurred while attempting to commit
2017-05-18 04:03:01,533 [egaRULES UsageDaemon] [ STANDARD] [ ] [ ] (nitor.internal.UsageDaemonImpl) ERROR - Usage Failure Reason 1: ORA-01438: value larger than specified precision allowed for this column


Steps to Reproduce

  1. Run BIX extraction


Root Cause



A defect in Pegasystems’ code or rules Some pr_perf_stats columns are inappropriately sized.

Resolution



Perform the following local-change:

alter table yourDATASchema.pr_perf_stats
modify ( pxDecryptCount numeric(18,6),
pxDecryptCPU numeric(18,6),
pxDecryptElapsed numeric(18,6),
pxEncryptElapsed numeric(18,6),
pxEncryptCPU numeric(18,6),
pxEncryptCount numeric(18,6)
);


Published May 19, 2017 - Updated June 24, 2017

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.