Question

4
Replies
316
Views
VenkataK2753 Member since 2014 1 post
Pegasystems Inc.
Posted: 3 years ago
Last activity: 3 years 6 months ago
Closed

BIX error: permission denied for relation pr_log

We are trying to send an BIX extract to a remote FTP server. While running a BIX extract in Pega 7.2.1, we are getting sequenceNumberERROR. Below is the content from bix log file. Please advice if anyone encountered this error and managed to resolve.

2017-03-14 08:32:09,378 [ PegaRULES-Batch-20] [ ] [ Sprout:01.01.01] ( internal.access.ExtractImpl) ERROR x.y@z.com - Error while getting the sequenceNumberERROR: permission denied for relation pr_log

2017-03-14 08:32:09,395 [ PegaRULES-Batch-20] [ ] [ Sprout:01.01.01] ( internal.access.ExtractImpl) ERROR x.y@z.com - Unable to process SG-Sprout-Data-InteractionHistory: 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)

at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1290)

at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1038)

at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:847)

at com.pega.pegarules.data.internal.access.ExtractImpl.runEngineExtract(ExtractImpl.java:973)

at com.pega.pegarules.data.internal.access.DatabaseImpl.executeExtract(DatabaseImpl.java:5662)

at com.pega.pegarules.session.internal.mgmt.Executable.executeExtract(Executable.java:8395)

at com.pegarules.generated.activity.ra_action_runextract_7eb17a5ada24845605c3d982093ca8a6.step1_circum0(ra_action_runextract_7eb17a5ada24845605c3d982093ca8a6.java:169)

at com.pegarules.generated.activity.ra_action_runextract_7eb17a5ada24845605c3d982093ca8a6.perform(ra_action_runextract_7eb17a5ada24845605c3d982093ca8a6.java:69)

at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3527)

at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:646)

at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivities(ThreadRunner.java:572)

at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.runActivities(PRThreadImpl.java:459)

at com.pega.pegarules.session.internal.async.agent.QueueProcessor.executeBatchTask(QueueProcessor.java:257)

at com.pega.pegarules.session.internal.async.agent.QueueProcessor.execute(QueueProcessor.java:321)

at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:980)

at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1290)

at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1038)

at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:920)

at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:697)

at com.pega.jsr166backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:991)

at com.pega.jsr166backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:532)

at java.lang.Thread.run(Thread.java:745)

2017-03-14 08:32:09,396 [ PegaRULES-Batch-20] [ ] [ Sprout:01.01.01] ( internal.access.ExtractImpl) ALERT x.y@z.com - 2017-03-14 08:32:09,395 GMT*8*EXCP0001*0*0*web_10.123.0.27_i-080c36d40aa7c389a*NA*NA*B6941F1C29C0F9B734100E3477D1FEF07*x.y@z.com*SG-Sprout-Work*Sprout:01.01.01*c646b6bd132c845136aaf8ae961bb197*Y*1*B6941F1C29C0F9B734100E3477D1FEF07*362*PegaRULES-Batch-20*STANDARD*com.pega.pegarules.data.internal.access.ExtractImpl*NA*Rule-Admin-Extract.runExtract*Rule-Obj-Activity:InitialProfileSetup*RULE-ADMIN-EXTRACT RUNEXTRACT #20140528T064333.576 GMT Step: 1 Circum: 0*****NA*NA*NA*NA*NA*NA*java;RULE-OBJ-ACTIVITY RULE-ADMIN-EXTRACT RUNEXTRACT #20140528T064333.576 GMT Step: 1 Circum: 0;doActivity Rule-Obj-Activity:runExtract;initial Executable;0 additional frames in stack;*pzActionID=;pzUseCurrentAccessGroupForChild=true;pzHarnessID=HID942B771B16D16BB339BB29C29B41479E;pzFromFrame=;pzActivityParams=ClassNameEQUALSSG-Sprout-Data-InteractionHistory&purposeEQUALSInteractionHistoryExtract&rowNumberEQUALS30&IDNumberEQUALSInteractionHistoryExtract&schemaFileEQUALS&manifestSchemaFileEQUALS;schemaFile=;rowNumber=30;purpose=InteractionHistoryExtract;AJAXTrackID=2;pyCreateDateTime=20170314T083209.333 GMT;manifestSchemaFile=;inStandardsMode=true;pzTransactionId=;IDNumber=InteractionHistoryExtract;pxCreateDateTime=20170314T083209.333 GMT;target=popup;ClientLoadDuration=2016;ClassName=SG-Sprout-Data-InteractionHistory;pzActivity=queueRunExtract;pzPrimaryPageName=runRulePage;*[MSG][Unable to process SG-Sprout-Data-InteractionHistory: null][STACK][java.lang.NullPointerException<CR> at com.pega.pegarules.data.internal.access.ExtractImpl.processSequenceNumber(ExtractImpl.java:5202)<CR> at com.pega.pegarules.data.internal.access.ExtractImpl.doExtract(ExtractImpl.java:1524)<CR> at com.pega.pegarules.data.internal.access.ExtractImpl.runExtract(ExtractImpl.java:1149)<CR> at com.pega.pegarules.data.internal.access.ExtractImpl.run(ExtractImpl.java:990)<CR> at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1290)<CR> at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1038)<CR> at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:847)<CR> at com.pega.pegarules.data.internal.access.ExtractImpl.runEngineExtract(ExtractImpl.java:973)<CR> at com.pega.pegarules.data.internal.access.DatabaseImpl.executeExtract(DatabaseImpl.java:5662)<CR> at com.pega.pegarules.session.internal.mgmt.Executable.executeExtract(Executable.java:8395)<CR> at com.pegarules.generated.activity.ra_action_runextract_7eb17a5ada24845605c3d982093ca8a6.step1_circum0(ra_action_runextract_7eb17a5ada24845605c3d982093ca8a6.java:169)<CR> at com.pegarules.generated.activity.ra_action_runextract_7eb17a5ada24845605c3d982093ca8a6.perform(ra_action_runextract_7eb17a5ada24845605c3d982093ca8a6.java:69)<CR> at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3527)<CR> at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:646)<CR> at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivities(ThreadRunner.java:572)<CR> at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.runActivities(PRThreadImpl.java:459)<CR> at com.pega.pegarules.session.internal.async.agent.QueueProcessor.executeBatchTask(QueueProcessor.java:257)<CR> at com.pega.pegarules.session.internal.async.agent.QueueProcessor.execute(QueueProcessor.java:321)<CR> at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:980)<CR> at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1290)<CR> at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1038)<CR> at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:920)<CR> at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:697)<CR> at com.pega.jsr166backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:991)<CR> at com.pega.jsr166backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:532)<CR> at java.lang.Thread.run(Thread.java:745)<CR>]*

2017-03-14 08:32:09,416 [ PegaRULES-Batch-20] [ ] [ Sprout:01.01.01] ( internal.access.ExtractImpl) INFO x.y@z.com - PAL Statistics for BIX Extract run :

Non-rule-resolved instances accessed from the database: 3

CPU time accessing non-rule-resolved instances from the database: 0

Elapsed Time accessing non-rule-resolved instances from the database: 0.007

CPU time retrieving rule-resolved Rules from the database: 0

Rule-resolved rules requested from database or cache: 4

Bytes read from database Storage Streams (uncompressed): 39920

Number of database requests that exceeded the time threshold: 0

CPU time spent performing BLOB decryption: 0

Elapsed time spent performing BLOB decryption: 0

BLOB decryption: 0

2017-03-14 08:32:09,416 [ PegaRULES-Batch-20] [ ] [ Sprout:01.01.01] ( internal.access.ExtractImpl) INFO x.y@z.com - # Total Instances retrieved: 0

***Updated by Moderator: Marissa to update categories***

Data Integration Reporting
Moderation Team has archived post
Share this page LinkedIn