Support Article
permission denied for relation pr_log when running extract rule
SA-35444
Summary
Running an extract rule from the UI is failing.
Class trying to extract is a data class in an external database.
Error Messages
2017-03-17 14:24:11,461 [ PegaRULES-Batch-47] [ ] [ Sprout:01.01.01] ( internal.access.ExtractImpl) ERROR - Error while getting the sequenceNumberERROR: permission denied for relation pr_log
2017-03-17 14:24:11,497 [ PegaRULES-Batch-47] [ ] [ Sprout:01.01.01] ( internal.access.ExtractImpl) ERROR - Unable to process YourClass: null
java.lang.NullPointerException
at com.pega.pegarules.data.internal.access.ExtractImpl.processSequenceNumber(ExtractImpl.java:5202)
at com.pega.pegarules.data.internal.access.ExtractImpl.doExtract(ExtractImpl.java:1524)
at com.pega.pegarules.data.internal.access.ExtractImpl.runExtract(ExtractImpl.java:1149)
at com.pega.pegarules.data.internal.access.ExtractImpl.run(ExtractImpl.java:990)
Steps to Reproduce
Run extract rule.
Root Cause
A defect in Pegasystems’ code or rules . Sequence number generator was not using connection of pr_log table but instead was using connection of class on which extract is defined.
Resolution
Apply HFix-33268
Published March 26, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.