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.

Discussion

 Kumar Sourabh (Sourabh)
Capgemini
Lead System Architect
Capgemini
SE
Sourabh Member since 2012 22 posts
Capgemini
Posted: Aug 17, 2015
Last activity: Aug 17, 2015
Posted: 17 Aug 2015 3:44 EDT
Last activity: 17 Aug 2015 5:26 EDT
Closed

Program Distribution test failing while doing the exercise as given in Pega Marketing Essentials Exercise

 

 

Hi,

I am getting "Pending-Failed" Status while running the Program Distribution test .

Attaching the Log files and snapshot of screen for the same.

Getting the below message :

Your Test Run has failed with the following message:
Batch strategy execution failed: Batch execution failed. Batch execution failed
To resolve the issue, go to Next Steps, suspend the program, and update it. You can also go to the failed Program Run and attempt to restart or ignore it.

 

 

2015-08-17 02:27:26,420 [   PegaRULES-Batch-4] [  STANDARD] [                    ] [      PegaNBAM:07.11] 

(a_decisionengine_batchdecision) ERROR   - Batch execution failed. Batch execution failed 
com.pega.pegarules.pub.PRRuntimeException: Batch execution failed 
    at com.pegarules.generated.executeBatch_071005_TccWGV_QkH34LqdBwZStSA$1.handleException

(executeBatch_071005_TccWGV_QkH34LqdBwZStSA.java:260) 
    at com.pega.decision.dsm.structureddata.caseid.CaseidBasedReader.readAll(CaseidBasedReader.java:86) 
    at com.pegarules.generated.executeBatch_071005_TccWGV_QkH34LqdBwZStSA.executeBatch07_10_05

(executeBatch_071005_TccWGV_QkH34LqdBwZStSA.java:198) 
    at com.pegarules.generated.executeBatch_071005_TccWGV_QkH34LqdBwZStSA.invoke

(executeBatch_071005_TccWGV_QkH34LqdBwZStSA.java:97) 
    at com.pega.pegarules.generation.internal.library.LibraryRuntime.resolveAndinvokeFunctionViaReflection

(LibraryRuntime.java:133) 
    at com.pega.pegarules.generation.internal.library.LibraryRuntime.invokeLibraryRuntime(LibraryRuntime.java:110) 
    at com.pega.pegarules.session.internal.mgmt.Executable.invokeLibraryRuntime(Executable.java:8545) 
    at com.pega.pegarules.priv.generator.LibrarySupport.resolveAndInvokeFunctionViaReflection(LibrarySupport.java:181) 
    at com.pegarules.generated.pega_decisionengine_batchdecision.executeBatch(pega_decisionengine_batchdecision.java:430) 
    at com.pegarules.generated.executeBatchFromParameterPage_071001_DU__CoGaNZqWW$JPpy_wqA.executeBatchFromParameterPage07_10_01

(executeBatchFromParameterPage_071001_DU__CoGaNZqWW$JPpy_wqA.java:127) 
    at com.pegarules.generated.executeBatchFromParameterPage_071001_DU__CoGaNZqWW$JPpy_wqA.invoke

(executeBatchFromParameterPage_071001_DU__CoGaNZqWW$JPpy_wqA.java:97) 
    at com.pega.pegarules.generation.internal.library.LibraryRuntime.resolveAndinvokeFunctionViaReflection

(LibraryRuntime.java:133) 
    at com.pega.pegarules.generation.internal.library.LibraryRuntime.invokeLibraryRuntime(LibraryRuntime.java:110) 
    at com.pega.pegarules.session.internal.mgmt.Executable.invokeLibraryRuntime(Executable.java:8545) 
    at com.pega.pegarules.priv.generator.LibrarySupport.resolveAndInvokeFunctionViaReflection(LibrarySupport.java:181) 
    at com.pegarules.generated.pega_decisionengine_batchdecision.executeBatchFromParameterPage

(pega_decisionengine_batchdecision.java:438) 
    at com.pegarules.generated.interaction.ra_action_pztemplateinteraction_e63abf9599a2c8d9b0f74da24ed933a9.runBatch

(ra_action_pztemplateinteraction_e63abf9599a2c8d9b0f74da24ed933a9.java:113) 
    at com.pegarules.generated.interaction.ra_action_pztemplateinteraction_e63abf9599a2c8d9b0f74da24ed933a9.perform

(ra_action_pztemplateinteraction_e63abf9599a2c8d9b0f74da24ed933a9.java:77) 
    at com.pega.pegarules.session.internal.mgmt.Executable.doAction(Executable.java:3076) 
    at com.pegarules.generated.activity.ra_action_pzexecutestrategyfromagent_6d0533ad18c8b3da5558a6d7a6c41e1a.step12_circum0

(ra_action_pzexecutestrategyfromagent_6d0533ad18c8b3da5558a6d7a6c41e1a.java:1117) 
    at com.pegarules.generated.activity.ra_action_pzexecutestrategyfromagent_6d0533ad18c8b3da5558a6d7a6c41e1a.perform

(ra_action_pzexecutestrategyfromagent_6d0533ad18c8b3da5558a6d7a6c41e1a.java:291) 
    at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3265) 
    at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:640) 
    at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivities(ThreadRunner.java:567) 
    at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.runActivities(PRThreadImpl.java:453) 
    at com.pega.pegarules.session.internal.async.agent.QueueProcessor.executeBatchTask(QueueProcessor.java:259) 
    at com.pega.pegarules.session.internal.async.agent.QueueProcessor.execute(QueueProcessor.java:322) 
    at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:884) 
    at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1192) 
    at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:930) 
    at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:829) 
    at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:617) 
    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) 
Caused by: com.pega.pegarules.pub.PRRuntimeException: Cannot list the database 
    at com.pega.decision.dsm.batch.RDBListBatchReader.<init>(RDBListBatchReader.java:77) 
    at com.pega.decision.dsm.structureddata.datasource.RDBListDataProvider.iterator(RDBListDataProvider.java:302) 
    at com.pega.decision.dsm.structureddata.caseid.CaseidBasedReader.readAll(CaseidBasedReader.java:60) 
    ... 33 more 
Caused by: com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: -104 SQLState: 42601 Message: 

DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=);CUSTOMER "MCDB" ON (;<search_condition>, DRIVER=3.63.75 
From: (B7A4572545B586582F6860C4AF64BDFC3)  
    SQL: SELECT "PC0".CUSTOMERID AS "CustomerID", "MCDB".EMAIL_OPT_IN AS "EmailOptIn", "MCDB".SMS_OPT_IN AS "SmsOptIn", 

"MCDB".DM_OPT_IN AS "DmOptIn", "PC0".CUSTOMERID AS "CustomerID", "CONTSUM".CHANNEL3ALLPERIODCOUNT AS "Channel3AllPeriodCount", 

"CONTSUM".CHANNEL10LASTUPDATEDDATE AS "Channel10LastUpdatedDate", "CONTSUM".CHANNEL4ALLPERIODCOUNT AS "Channel4AllPeriodCount", 

"CONTSUM".CHANNEL5ALLPERIODCOUNT AS "Channel5AllPeriodCount", "CONTSUM".CHANNEL9ALLPERIODCOUNT AS "Channel9AllPeriodCount", 

"CONTSUM".CHANNEL3LASTUPDATEDDATE AS "Channel3LastUpdatedDate", "CONTSUM".CHANNEL6ALLPERIODCOUNT AS "Channel6AllPeriodCount", 

"CONTSUM".CHANNEL1ALLPERIODCOUNT AS "Channel1AllPeriodCount", "CONTSUM".CHANNEL1LASTUPDATEDDATE AS "Channel1LastUpdatedDate", 

"CONTSUM".CHANNEL9LASTUPDATEDDATE AS "Channel9LastUpdatedDate", "CONTSUM".CHANNEL8ALLPERIODCOUNT AS "Channel8AllPeriodCount", 

"CONTSUM".CHANNEL7LASTUPDATEDDATE AS "Channel7LastUpdatedDate", "CONTSUM".CHANNEL10ALLPERIODCOUNT AS "Channel10AllPeriodCount", 

"CONTSUM".CHANNEL7ALLPERIODCOUNT AS "Channel7AllPeriodCount", "CONTSUM".CHANNEL2LASTUPDATEDDATE AS "Channel2LastUpdatedDate", 

"CONTSUM".CHANNEL5LASTUPDATEDDATE AS "Channel5LastUpdatedDate", "CONTSUM".CHANNEL4LASTUPDATEDDATE AS "Channel4LastUpdatedDate", 

"CONTSUM".CHANNEL2ALLPERIODCOUNT AS "Channel2AllPeriodCount", "CONTSUM".CHANNEL6LASTUPDATEDDATE AS "Channel6LastUpdatedDate", 

"CONTSUM".CHANNEL8LASTUPDATEDDATE AS "Channel8LastUpdatedDate" FROM NBAM71.MKTSEGIPhoneSegment "PC0"  INNER JOIN NBAM71.MKT_CUSTOMER 

"MCDB" ON () LEFT OUTER JOIN NBAM71.MKT_CONTACT_SUMMARY "CONTSUM" ON () 
    SQL Inserts:  
 
Caused by SQL Problems. 
Problem #1, SQLState 42601, Error code -104: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, 

SQLERRMC=);CUSTOMER "MCDB" ON (;<search_condition>, DRIVER=3.63.75 
Problem #2, SQLState 42601, Error code -104: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, 

SQLERRMC=);CUSTOMER "MCDB" ON (;<search_condition>, DRIVER=3.63.75 
Problem #3, SQLState 56098, Error code -727: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, 

SQLERRMC=2;-104;42601;)|CUSTOMER "MCDB" ON (|<search_condition>, DRIVER=3.63.75 
    at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:167) 
    at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:6271) 
    at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:5995) 
    at com.pega.decision.dsm.batch.RDBListBatchReader.<init>(RDBListBatchReader.java:69) 
    ... 35 more 
Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=);CUSTOMER "MCDB" ON 

(;<search_condition>, DRIVER=3.63.75 
    at com.ibm.db2.jcc.am.fd.a(fd.java:679) 
    at com.ibm.db2.jcc.am.fd.a(fd.java:60) 
    at com.ibm.db2.jcc.am.fd.a(fd.java:127) 
    at com.ibm.db2.jcc.am.yn.c(yn.java:2644) 
    at com.ibm.db2.jcc.am.yn.d(yn.java:2632) 
    at com.ibm.db2.jcc.am.yn.a(yn.java:2097) 
    at com.ibm.db2.jcc.am.zn.a(zn.java:7197) 
    at com.ibm.db2.jcc.t4.cb.h(cb.java:141) 
    at com.ibm.db2.jcc.t4.cb.b(cb.java:41) 
    at com.ibm.db2.jcc.t4.q.a(q.java:32) 
    at com.ibm.db2.jcc.t4.sb.i(sb.java:135) 
    at com.ibm.db2.jcc.am.yn.gb(yn.java:2066) 
    at com.ibm.db2.jcc.am.zn.pc(zn.java:3446) 
    at com.ibm.db2.jcc.am.zn.b(zn.java:4236) 
    at com.ibm.db2.jcc.am.zn.fc(zn.java:2670) 
    at com.ibm.db2.jcc.am.zn.execute(zn.java:2654) 
    at com.pega.pegarules.data.internal.access.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:990) 
    at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:6194) 
    ... 37 more 
2015-08-17 02:27:28,532 [   PegaRULES-Batch-3] [  STANDARD] [                    ] [      PegaNBAM:07.11] 

(PegaMKT_Work_ProgramRun.Action) ERROR   - Failure in ExecuteProgramRun: Batch strategy execution failed:  Batch execution failed. 

Batch execution failed 
2015-08-17 02:27:28,535 [   PegaRULES-Batch-3] [  STANDARD] [                    ] [      PegaNBAM:07.11] 

(PegaMKT_Work_ProgramRun.Action) ERROR   - ExecuteProgramRun error from batch strategy execution PRTest-5 
2015-08-17 02:30:28,164 [egaRULES-MasterAgent] [  STANDARD] [                    ] [                    ] (          

internal.async.Agent) INFO    - System date: Mon Aug 17 02:30:28 EDT 2015 Total memory: 1,238,368,256 Free memory: 442,883,384 

Requestor Count: 18 Shared Pages memory usage: 0% 

 

To see attachments, please log in.
Pega Academy

Posted: 9 years ago
Posted: 17 Aug 2015 5:26 EDT
Guru Deshkulkarni (Guru Deshkulkarni)
PEGA
Director, Technical Documentation, Applications
Pegasystems Inc.
NL
Hi Kumar Thank you sharing the details about the error. From the screen-shot, it looks like the Strategy is not identifying offers for any of the 714 customers in the Segment. Can you please confirm if you have made any additional changes to the exercise system other than what was specified in the Exercise instructions? Can you also confirm that you are using the exercise system that was downloaded for the Pega Marketing Essentials course (not the one downloaded for the Pega Decision Management Essentials course, as they are different systems). Can you also test the marketing strategy using different values for the dummy customers (steps 4, 5 and 20 in the 'Designing the Marketing Strategy' exercise) and ensure that it works as expected. Regards Guru
To see attachments, please log in.

Related content:

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