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

ADM Snapshot agent fails with Underflow exception

SA-91354

Summary

The Adaptive Decision Manager (ADM) Snapshot agent fails with Underflow exception.


Error Messages

Exception 1

288[PegaRULES-Batch-5][STANDARD][][PegaDM](internal.mgmt.Executable)ERROR - Exception
pega.decision.adm.client.ADMException:Failed to complete ADM Data Mart snapshot 
at pega.decision.adm.client.ADMException.raise(ADMException.java:63)~[adm-api-jar:?]
at pega.decision.adm.datamart.DataMart.pzADMSnapshotInBatch(DataMart.java:28)~[adm-datamart]
pegarules.generated.activity.ra_action_pzgetallmodeldetails_9dd1ed966065e004e265ecf6ab119157.step14_circum0(ra_action_pzgetallmodeldetails_9dd1ed966065e004e265ecf6ab119157.java:1217) ~[?:?]
pegarules.generated.activity.ra_action_pzgetallmodeldetails_9dd1ed966065e004e265ecf6ab119157.perform(ra_action_pzgetallmodeldetails_9dd1ed966065e004e265ecf6ab119157.java:333)~[?:?]
at pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3421)~[prprivate.jar:?]
at pega.pegarules.session.internal.async.agent.QueueProcessor.runActivity(QueueProcessor.java:786)~[prprivate.jar:?]
at pega.jsr166backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:991) ~[prjsr]
at pega.jsr166backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:532) ~[prjsr166java6-3.0.jar:?]
at java.lang.Thread.run(Thread.java:748) [?:127.0.0.1]
Caused by: pega.decision.adm.client.ADMException: pega.pegarules.pub.database.DatabaseException: Problem performing an executeBatch for indexes [173]: code: 17001 SQLState: 99999 Message: Internal Error: Underflow Exception trying to bind 6.467579315208813E-134
DatabaseException caused by prior exception: java.sql.BatchUpdateException: Internal Error: Underflow Exception trying to bind 6.467579315208813E-134
| SQL Code: 17001 | SQL State: 99999

DatabaseException caused by prior exception: java.sql.SQLException: Internal Error: Underflow Exception trying to bind 6.467579315208813E-134
| SQL Code: 17001 | SQL State: 99999

at pega.decision.dsm.batch.ObjSaveBatchWriter.executeBatch(ObjSaveBatchWriter.java:49)~[prpublic.jar:?]
at pega.decision.adm.datamart.PredictorHandler.addToBatchAndWriteIfNeeded(PredictorHandler.java:70)~[adm-datamart-127.0.0.1jar:?]
at pega.decision.adm.datamart.PredictorHandler.writePredictor(PredictorHandler.java:212)~[adm-datamart-127.0.0.1.jar:?]
at pega.decision.adm.datamart.ADMSnapshotInBatchImpl.saveSnapshotsInDB(ADMSnapshotInBatchImpl.java:209)~[adm-datamart-127.0.0.1jar:?]
at pega.decision.adm.datamart.ADMSnapshotInBatchImpl.takeSnapshots(ADMSnapshotInBatchImpl.java:138)~[adm-datamart-127.0.0.1jar:?]
at pega.decision.adm.datamart.DataMart.pzADMSnapshotInBatch(DataMart.java:23)~[adm-datamart-127.0.0.1.jar:?]
... 13 more
Caused by: pega.decision.adm.client.ADMException:java.sql.BatchUpdateException:Internal Error: Underflow Exception trying to bind 6.467579315208813E-134
at pega.DatabasePreparedStatementImpl.executeBatch(DatabasePreparedStatementImpl.java:472)~[prprivate.jar:?]
at pega.decision.adm.datamart.PredictorHandler.addToBatchAndWriteIfNeeded(PredictorHandler.java:70) ~[adm-datamart-jar:?]
at pega.decision.adm.datamart.DataMart.pzADMSnapshotInBatch(DataMart.java:23~[adm-datamart-jar:?]
... 13 more

Exception 2

763[PegaRULES-Batch-5][STANDARD][][PegaDM](ernal.async.BatchRequestorTask)ERROR-Batch activity "Data-Decision-ADM-ModelSnapshot.pzGetAllModelDetails" threw:
pega.decision.adm.client.ADMException: Failed to complete ADM Data Mart snapshot  
at pega.decision.adm.client.ADMException.raise(ADMException.java:63)~[adm-api-]
at pega.decision.adm.datamart.DataMart.pzADMSnapshotInBatch(DataMart.java:28)~[adm-datamart?]
pegarules.generated.activity.ra_action_pzgetallmodeldetails_9dd1ed966065e004e265ecf6ab119157.step14_circum0(ra_action_pzgetallmodeldetails_9dd1ed966065e004e265ecf6ab119157.java:1217)~[?:?]
pegarules.generated.activity.ra_action_pzgetallmodeldetails_9dd1ed966065e004e265ecf6ab119157.perform(ra_action_pzgetallmodeldetails_9dd1ed966065e004e265ecf6ab119157.java:333)~[?:?]
at pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3421)~[prprivate.jar:?]
at pega.pegarules.session.internal.async.agent.QueueProcessor.runActivity(QueueProcessor.java:786)~[prprivate.jar:?]
at pega.pegarules.session.internal.async.agent.QueueProcessor.execute(QueueProcessor.java:655)~[prprivate.jar:?]
at pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:1057)~[prprivate.jar:?]
at pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1357)~[prprivate.jar:?]
at pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1105)~[prprivate.jar:?]
at pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:986)~[prprivate.jar:?]
at pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:763)~[prprivate.jar:?]
at pega.jsr166backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:991)
at pega.jsr166backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:532)
at java.lang.Thread.run(Thread.java:748) 
Caused by: pega.decision.adm.client.ADMException:pega.pegarules.pub.database.DatabaseException: Problem performing an executeBatch for indexes [0]: code: 1438 SQLState: 22003 Message: ORA-01438: value larger than specified precision allowed for this column
DatabaseException caused by prior exception: java.sql.BatchUpdateException: ORA-01438:value larger than specified precision allowed for this column
| SQL Code: 1438 | SQL State: 22003
DatabaseException caused by prior exception: java.sql.SQLDataException: ORA-01438: value larger than specified precision allowed for this column
| SQL Code: 1438 | SQL State: 22003
at pega.decision.dsm.batch.ObjSaveBatchWriter.executeBatch(ObjSaveBatchWriter.java:49)~[prpublic.jar:?]
at pega.decision.adm.datamart.PredictorHandler.addToBatchAndWriteIfNeeded(PredictorHandler.java:70)~[adm-datamart-jar:?]
at pega.decision.adm.datamart.ADMSnapshotInBatchImpl.takeSnapshots(ADMSnapshotInBatchImpl.java:138)~[adm-datamart-jar:?]
at pega.decision.adm.datamart.DataMart.pzADMSnapshotInBatch(DataMart.java:23)~[adm-datamart-jar:?]
... 13 more
Caused by: pega.decision.adm.client.ADMException:java.sql.BatchUpdateException: ORA-01438: value larger than specified precision allowed for this columnat driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10500)~[ojdbc6.jar:127.0.0.1]
at driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230)~[ojdbc6.jar:127.0.0.1]
at pega.pegarules.data.internal.store.DatabasePreparedStatementImpl.executeBatch(DatabasePreparedStatementImpl.java:472) ~[prprivate.jar:?]
at pega.decision.adm.datamart.PredictorHandler.writePredictor(PredictorHandler.java:212)~[adm-datamart-jar:?]
at pega.decision.adm.datamart.ADMSnapshotInBatchImpl.saveSnapshotsInDB(ADMSnapshotInBatchImpl.java:209) ~[adm-datamart-jar:?]
at pega.decision.adm.datamart.ADMSnapshotInBatchImpl.takeSnapshots(ADMSnapshotInBatchImpl.java:138)~[adm-datamart-jar:?]
at pega.decision.adm.datamart.DataMart.pzADMSnapshotInBatch(DataMart.java:23)~[adm-datamart-jar:?]
... 13 more


Steps to Reproduce



Run the ADM Snapshot agent. The exception occurs.


Root Cause



A defect in Pegasystems’ code or rules.

Resolution



Apply HFix-57112.



 
Suggest Edit

Published November 4, 2019 - Updated December 2, 2021

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