Question

5
Replies
137
Views
X
GOPESH SAHA Member since 2011 18 posts
Cognizant Technology Solutions
Posted: 9 months ago
Last activity: 9 months 2 weeks ago

Campaign failed with Exception in stage: Offer Flow Suspend and Update the campaign to resolve this issue

Hi,

We are running a campaign and getting error as below. Would you kindly help us to understand the root cause or what action we could take to resolve this?

Thank you!

Exception in stage: Offer Flow
Suspend and Update the campaign to resolve this issue. After updating, you can Restart or Skip this run

Checked in the log and below is the log message:

  api.dataflow.DataFlow) ERROR   - Supressing an exception from status subscriber onNext 
com.pega.dsm.dnode.api.DNodeException: Unable to release lock on [Data_Flow_Lock_For_ASSIGN-DDF PR-2938!DIST72STATUS_CHANGE] 
	at com.pega.dsm.dnode.impl.dataflow.manager.DataFlowLockManager.unlock(DataFlowLockManager.java:58) 
	at com.pega.dsm.dnode.impl.dataflow.manager.WorkPersistenceManager.saveWithStatusChange(WorkPersistenceManager.java:156) 
	at com.pega.dsm.dnode.impl.dataflow.manager.WorkPersistenceManager.save(WorkPersistenceManager.java:130) 
	at com.pega.dsm.dnode.impl.dataflow.manager.DataFlowMetricsSubscriber$AssignmentUpdater.updateWith(DataFlowMetricsSubscriber.java:156) 
	at com.pega.dsm.dnode.impl.dataflow.manager.DataFlowMetricsSubscriber.onNext(DataFlowMetricsSubscriber.java:55) 
	at com.pega.dsm.dnode.impl.dataflow.manager.DataFlowMetricsSubscriber.onNext(DataFlowMetricsSubscriber.java:25) 
	at com.pega.dsm.dnode.api.dataflow.DataFlow$1$2.onNext(DataFlow.java:234) 
	at com.pega.dsm.dnode.api.dataflow.DataFlow$1$2.onNext(DataFlow.java:228) 
	at com.pega.dsm.dnode.api.dataflow.DataFlow$1.emit(DataFlow.java:156) 
	at com.pega.dsm.dnode.impl.stream.DataObservableImpl.subscribe(DataObservableImpl.java:56) 
	at com.pega.dsm.dnode.impl.dataflow.manager.LocalRun.execute(LocalRun.java:149) 
	at com.pega.dsm.dnode.impl.dataflow.manager.LocalRun.lockAndRun(LocalRun.java:87) 
	at com.pega.dsm.dnode.impl.dataflow.manager.LocalRun.run(LocalRun.java:63) 
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) 
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) 
	at com.pega.dsm.dnode.impl.prpc.PrpcThreadFactory$PrpcThread.run(PrpcThreadFactory.java:81) 
Caused by: com.pega.pegarules.pub.database.LockGoneException: Database-LockFailure-LockLost	Data_Flow_Lock_For_ASSIGN-DDF PR-2938!DIST72STATUS_CHANGE 
From: (B17ABCCCF0E0040267BA0ECFB7F59B2CF)  
	SQL: select pxOwnerId as "pxOwnerId", pxUpdateOperator as "pxUpdateOperator", pxUpdateOpName as "pxUpdateOpName", pxExpireDateTime as "pxExpireDateTime", pxUpdateDateTime as "pxUpdateDateTime", pxLockHandle as "pxLockHandle", pxCreateDateTime as "pxCreateDateTime", pxUserHost as "pxUserHost" from PEGA_DATA.pr_sys_locks where pzInsKey = ? 
	SQL Inserts: <Data_Flow_Lock_For_ASSIGN-DDF PR-2938!DIST72STATUS_CHANGE>	 
 
	at com.pega.pegarules.data.internal.access.DBLockProviderImpl.releaseLock(DBLockProviderImpl.java:834) 
	at com.pega.dsm.dnode.impl.dataflow.manager.DataFlowLockManager.unlockWithLockProvider(DataFlowLockManager.java:82) 
	at com.pega.dsm.dnode.impl.dataflow.manager.DataFlowLockManager.unlock(DataFlowLockManager.java:56) 
	... 15 more 
2019-09-18 09:53:54,855 [-threads-1000418060)] [  STANDARD] [                    ] [      AAMKT:01.21.01] (PegaMKT_Work_ProgramRun.Action) ERROR   - Failure in ExecuteProgramRun: Exception in stage: Offer Flow
Pega Marketing System Administration
Reply
Posted: 9 months ago

What is your pega platform/marketing version? Is this happening sporadically or consistently? 

Posted: 9 months ago

Hi,


This is in Pega Marketing 7.13 version and this is happening continuously. Please let me know, if more details require on the same.


Thanks!


Gopesh

Posted: 9 months ago

Hi,


Does this exception happen for every campaign run or this particular item PR-2938 is continuously throwing the same exception ? are other campaign running in this system fine ?


Can you open the data flow work object item - PR-2938 (instance of Pega-DM-DDF-Work) in the designer portal and see what sort of errors are reported there ? there would also be a component level error reported and that would be useful to click on the link and get the status message of the failure.


Are there any campaign custom extension activities being called by taking over any Pega Marketing rules ?

Posted: 9 months ago

Hi,


This error was for every reschedule(i.e. multiple PR runs). After trying few times, gradually records processed, and after that no error reported. But, while we pick a new set of data, this happened again.


Regards,


Gopesh

Posted: 9 months ago

Hi All,


Just to confirm on this issue, I didn't find the exact root cause for this issue, but while we run campaign same as live configuration this works. So, we requested testing team to proceed with some more test based on Live configuration and see.


Thanks for your response!


Regards,


Gopesh
Share this page LinkedIn
Copied!