Question

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 

Comments

Keep up to date on this post and subscribe to comments

September 18, 2019 - 7:34am

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

September 18, 2019 - 8:03am
Response to KevinZheng_GCS

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

September 19, 2019 - 2:14pm
Response to GOPESH SAHA

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 ?

September 23, 2019 - 10:59am
Response to Sriram Krishnan

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

September 23, 2019 - 11:02am

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