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

Root Cause

Resolution