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



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.


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 June 24, 2017 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

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