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.