Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Venkata Krishna (VenkataK2753)
Pegasystems Inc.

Pegasystems Inc.
IN
VenkataK2753 Member since 2014 1 post
Pegasystems Inc.
Posted: Mar 16, 2017
Last activity: Apr 14, 2017
Posted: 16 Mar 2017 5:57 EDT
Last activity: 14 Apr 2017 10:24 EDT
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 [email protected] - 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 [email protected] - 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)

Show More

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 [email protected] - 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 [email protected] - 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 [email protected] - 2017-03-14 08:32:09,395 GMT*8*EXCP0001*0*0*web_ Proprietary information hidden_i-080c36d40aa7c389a*NA*NA*B6941F1C29C0F9B734100E3477D1FEF07*[email protected]*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 [email protected] - 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 [email protected] - # Total Instances retrieved: 0

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


Show Less
To see attachments, please log in.
Data Integration
Reporting

Posted: 7 years ago
Posted: 16 Mar 2017 10:44 EDT
Shanthini Charles (ShanthiniC)
Techmahindra

Techmahindra
IN

Hello Venkata,

Could you please confirm if your running this extract via command line or studio? If command line please share the complete command used to run.

Regards,

Shanthini Charles

To see attachments, please log in.
Posted: 7 years ago
Posted: 31 Mar 2017 0:28 EDT
Shanthini Charles (ShanthiniC)
Techmahindra

Techmahindra
IN

Hello Maruthi,

Sorry for the late response however could you confirm this issue only for a specific extract or for all the extracts?

Regards,

Shanthini Charles

To see attachments, please log in.
Posted: 7 years ago
Posted: 31 Mar 2017 3:02 EDT
Akshay Kumar Sinha (AkshaySinha07)
Blue Rose Technologies GmbH

Blue Rose Technologies GmbH
BE

Hello Maruthi,

Please have a look on the below article which talks about your use-case.

https://community.pega.com/support/support-articles/permission-denied-relation-prlog-when-running-extract-rule

Please let me know if it helps.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice