Discussion

1
Replies
377
Views
SKUMAR28 Member since 2012 14 posts
TCS
Posted: 5 years ago
Last activity: 5 years 2 months ago
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% 

 

Pega Academy
Moderation Team has archived post
Share this page LinkedIn