Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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)
);


Suggest Edit

Published June 24, 2017 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

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

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us