Support Article
ADMSnapshot agent displays an error post Pega 7.4 update
SA-76259
Summary
Post Pega 7.4 update, the out-of-the-box ADMSnapshot agent displays an exception.
Error Messages
[PegaRULES-Batch-30] [STANDARD] [ ] [PegaDM:07.10] (internal.mgmt.Executable) ERROR - Exception
com.pega.decision.adm.client.ADMException: Failed to complete ADM Data Mart snapshot at Thu Mar 07 00:03:32 CST 2019at com.pega.decision.adm.client.ADMException.raise(ADMException.java:63) ~[adm-api-7.4.0.jar:?]at com.pega.decision.adm.datamart.DataMart.pzADMSnapshotInBatch(DataMart.java:28) ~[adm-datamart-7.4.0.jar:?]at com.pegarules.generated.activity.ra_action_pzgetallmodeldetails_9dd1ed966065e004e265ecf6ab119157.step14_circum0(ra_action_pzgetallmodeldetails_9dd1ed966065e004e265ecf6ab119157.java:1217) ~[?:?]at com.pegarules.generated.activity.ra_action_pzgetallmodeldetails_9dd1ed966065e004e265ecf6ab119157.perform(ra_action_pzgetallmodeldetails_9dd1ed966065e004e265ecf6ab119157.java:333) ~[?:?]at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3421) ~[prprivate.jar:?]at com.pega.pegarules.session.internal.async.agent.QueueProcessor.runActivity(QueueProcessor.java:786) ~[prprivate.jar:?]at java.lang.Thread.run(Thread.java:748) [?:1.8.0_181]Caused by: com.pega.decision.adm.client.ADMException: com.pega.pegarules.pub.database.DatabaseException: Problem performing an executeBatch for indexes [96]: code: 17001 SQLState: 99999 Message: Internal Error: Underflow Exception trying to bind 2.2771610385067125E-182DatabaseException caused by prior exception: java.sql.BatchUpdateException: Internal Error: Underflow Exception trying to bind 2.2771610385067125E-182| SQL Code: 17001 | SQL State: 99999DatabaseException caused by prior exception: java.sql.SQLException: Internal Error: Underflow Exception trying to bind 2.2771610385067125E-182| SQL Code: 17001 | SQL State: 99999at com.pega.pegarules.data.internal.access.ExceptionInformation.createAppropriateExceptionDueToDBFailure(ExceptionInformation.java:379) ~[prprivate.jar:?]Caused by: com.pega.decision.adm.client.ADMException: java.sql.BatchUpdateException: Internal Error: Underflow Exception trying to bind 2.2771610385067125E-182at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10500) ~[ojdbc6.jar:11.2.0.4.0]at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230) ~[ojdbc6.jar:11.2.0.4.0]at com.pega.pegarules.data.internal.store.DatabasePreparedStatementImpl.executeBatch(DatabasePreparedStatementImpl.java:472) ~[prprivate.jar:?]
Steps to Reproduce
- Update Pega 7.2 to Pega 7.4.
- Schedule the ADMSnapshot agent to run on a node, once everyday.
Root Cause
A defect in Pegasystems’ code or rules.
Resolution
Apply HFix-51764.
Published April 4, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.