Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Simulation execution fails

SA-16513

Summary



Simulation Execution fails with an error message on screen. Batch DSM user is trying to execute a simulation run, but it is failing to execute


Error Messages

2015-11-03 09:21:37,993 [   PegaRULES-Batch-4] [  STANDARD] [        NGD:01.01.01] (a_decisionengine_batchdecision) DEBUG  [email protected] -  fields to write : [pyPartitionKey, FlowErrorDetail, FlowStatus, LastFlowStep, ParentGroup, ParentIssue, ParentOffer, ProgramKeyCode, StatusWork, TreatmentKeyCode, WaitExpirationTime, pyPartitionKey, pyWorkID, pyOriginalComponent, pxSegment, pxPriority, BundleType, pxInteractionID, pyTreatment, BundleHead, KeyCode, pyGroup, pyDivision, pyName, BudgetedCost, StartDate, ExpectedResponseRate, pxOutcomeTime, pyPropensity, pyCategory, Type, BundleName, pyChannel, ClickThroughURL, EndDate, pyApplicationVersion, pyOriginalStrategy, URI, pyMaxBudget, pyBehaviour, ControlGroupValidityStart, pyOutcome, pyApplication, pyStrategy, pyGroupID, pxDecisionTime, Status, ControlGroupValidityEnd, pyUnit, pxFactID, pyCustomerSubSegment, pyCustomerSegment, MktValue, pyLongitude, pyWeight, pyComponent, pyDirection, ExpectedRevenue, MktType, pyTargetBudget, IPAddress, pxOriginalRank, pyPreviousComponent, ImageURL, pyInteraction, pyOriginalInteraction, pxRank, BundleParent, pyReason, pyLatitude, pyIssue, pxIdentifier, UserAgent, pxDecisionReference, SerialNumber, DeviceType, pySubjectID, InboundTreatment, pyOrganization, pyExternalID, pyOperator, RevokedOutcome, SimulationName, OfferName, ApplicableSubChannel]
2015-11-03 09:21:38,034 [   PegaRULES-Batch-4] [  STANDARD] [        NGD:01.01.01] (a_decisionengine_batchdecision) DEBUG  [email protected] -  fields to write : [pyPartitionKey]
2015-11-03 09:21:38,034 [   PegaRULES-Batch-4] [  STANDARD] [        NGD:01.01.01] (a_decisionengine_batchdecision) DEBUG  [email protected] -  PartitionKey available : false
2015-11-03 09:21:38,034 [   PegaRULES-Batch-4] [  STANDARD] [        NGD:01.01.01] (a_decisionengine_batchdecision) DEBUG  [email protected] -  is PartitionKey is Valuenull
2015-11-03 09:21:38,034 [   PegaRULES-Batch-4] [  STANDARD] [        NGD:01.01.01] (a_decisionengine_batchdecision) DEBUG  [email protected] -  Batch Writer summary..
2015-11-03 09:21:38,034 [   PegaRULES-Batch-4] [  STANDARD] [        NGD:01.01.01] (a_decisionengine_batchdecision) DEBUG  [email protected] -  pyToDatabaseTable:true
2015-11-03 09:21:38,034 [   PegaRULES-Batch-4] [  STANDARD] [        NGD:01.01.01] (a_decisionengine_batchdecision) DEBUG  [email protected] -  pyToDataSource:true
2015-11-03 09:21:38,034 [   PegaRULES-Batch-4] [  STANDARD] [        NGD:01.01.01] (a_decisionengine_batchdecision) DEBUG  [email protected] -  pyToIH:false
2015-11-03 09:21:38,077 [   PegaRULES-Batch-4] [  STANDARD] [        NGD:01.01.01] (l.access.ConnectionManagerImpl) ERROR  [email protected] -  Not returning connection 63 for database "ciparty" to the pool as it previously encountered the following error
User ID: [email protected]
Last SQL: SELECT "PC0".UCRN AS "UCRN", "PC0".LAST_NAME AS "LAST_NAME", "PC0".PARTY_DATA_REFRESH_DT AS "PARTY_DATA_REFRESH_DT", "PC0".PARTY_ID AS "CUSTOMER_ID", "PC0".REFUSED_TEL_FLG AS "REFUSED_TEL_FLG", "PC0".FUTURE_PARTY_FLG AS "FUTURE_PARTY_FLG", "PC0".HAS_TEL_NO_FLG AS "HAS_TEL_NO_FLG", "PC0".PAYMENT_TYPES_USED AS "PAYMENT_TYPES_USED", "PC0".M_40004 AS "M_40004", "PC0".LAST_ENGR_VISIT_DT AS "LAST_ENGR_VISIT_DT", "PC0".LAST_ENGR_VISIT_REASON_VAL AS "LAST_ENGR_VISIT_REASON_VAL", "PC0".PARTITIONKEY AS "PartitionKey", "PC0".LIVE_PARTY_FLG AS "LIVE_PARTY_FLG", "PC0".DECEASED_FLG AS "DECEASED_FLG", "PC0".BP_ID AS "BP_ID", "PC0".HAS_EMAIL_FLG AS "HAS_EMAIL_FLG", "PC0".M_40008 AS "M_40008", "PC0".M_40009 AS "M_40009", "PC0".NECTAR_ENROLLED_FLG AS "NECTAR_ENROLLED_FLG", "PC0".DISCONNECT_NOTICE_FLG AS "DISCONNECT_NOTICE_FLG", "PC0".MIDDLE_NAME AS "MIDDLE_NAME", "PC0".PAST_ENERGY_PARTY_FLG AS "PAST_ENERGY_PARTY_FLG", "PC0".MKT_CONSENT_1Y AS "MKT_CONSENT_1Y", "PC0".FIRST_NAME AS "FIRST_NAME", "PC0".SRVC_ENERGY_TENURE AS "SRVC_ENERGY_TENURE", "PC0".M_40007 AS "M_40007", "PC0".LAST_COMPLAINT AS "LAST_COMPLAINT", "PC0".PREMISES_CNT AS "PREMISES_CNT", "PC0".BIRTH_DT AS "BIRTH_DT", "PC0".TITLE AS "TITLE", "PC0".SAINSBURYS_ENERGY_FLG AS "SAINSBURYS_ENERGY_FLG", "PC0".M_40005 AS "M_40005", "PC0".MKT_CONSENT_STATUS_CD AS "MKT_CONSENT_STATUS_CD", "PC0".OAM_LAST_LOGIN_DT AS "OAM_LAST_LOGIN_DT", "PC0".LOAD_DT AS "LOAD_DT" FROM CIPARTY.V_PARTY_SPINE "PC0"  WHERE ( ("PC0".DECEASED_FLG = ?) ) AND ("PC0".PARTITIONKEY = )
java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
 at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
 at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
 at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
 at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
 at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
 at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
 at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
 at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
 at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3685)
 at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1376)
 at com.pega.pegarules.data.internal.access.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:581)
 at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:6139)
 at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:5916)
 at com.pega.decision.dsm.batch.RDBListBatchReader.<init>(RDBListBatchReader.java:74)
 at com.pega.decision.dsm.structureddata.datasource.RDBListDataProvider.iterator(RDBListDataProvider.java:322)
 at com.pega.decision.dsm.structureddata.caseid.CaseidBasedReader.readAll(CaseidBasedReader.java:80)
 at com.pegarules.generated.executeBatch_071017_hTOP21LC7m8uNG4Xsw3jLQ.executeBatch07_10_17(executeBatch_071017_hTOP21LC7m8uNG4Xsw3jLQ.java:215)
 at com.pegarules.generated.executeBatch_071017_hTOP21LC7m8uNG4Xsw3jLQ.invoke(executeBatch_071017_hTOP21LC7m8uNG4Xsw3jLQ.java:106)
 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:8954)
 at com.pega.pegarules.priv.generator.LibrarySupport.resolveAndInvokeFunctionViaReflection(LibrarySupport.java:181)
 at com.pegarules.generated.pega_decisionengine_batchdecision.executeBatch(pega_decisionengine_batchdecision.java:497)
 at com.pegarules.generated.executeBatchFromParameterPage_071017_KY0dwDEye9XYEFcNlHmtbA.executeBatchFromParameterPage07_10_17(executeBatchFromParameterPage_071017_KY0dwDEye9XYEFcNlHmtbA.java:136)
 at com.pegarules.generated.executeBatchFromParameterPage_071017_KY0dwDEye9XYEFcNlHmtbA.invoke(executeBatchFromParameterPage_071017_KY0dwDEye9XYEFcNlHmtbA.java:106)
 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:8954)
 at com.pega.pegarules.priv.generator.LibrarySupport.resolveAndInvokeFunctionViaReflection(LibrarySupport.java:181)
 at com.pegarules.generated.pega_decisionengine_batchdecision.executeBatchFromParameterPage(pega_decisionengine_batchdecision.java:505)
 at com.pegarules.generated.interaction.ra_action_simulationinteraction_6f54b991d3610c96d65e889f31a999b2.runBatch(ra_action_simulationinteraction_6f54b991d3610c96d65e889f31a999b2.java:114)
 at com.pegarules.generated.interaction.ra_action_simulationinteraction_6f54b991d3610c96d65e889f31a999b2.perform(ra_action_simulationinteraction_6f54b991d3610c96d65e889f31a999b2.java:78)
 at com.pega.pegarules.session.internal.mgmt.Executable.doAction(Executable.java:3305)
 at com.pegarules.generated.activity.ra_action_pzexecutestrategyfromagent_a05f6715f920f5a8dab2fd617198386a.step12_circum0(ra_action_pzexecutestrategyfromagent_a05f6715f920f5a8dab2fd617198386a.java:1131)
 at com.pegarules.generated.activity.ra_action_pzexecutestrategyfromagent_a05f6715f920f5a8dab2fd617198386a.perform(ra_action_pzexecutestrategyfromagent_a05f6715f920f5a8dab2fd617198386a.java:291)
 at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
 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:453)
 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:320)
 at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:945)
 at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1259)
 at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1008)
 at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:901)
 at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:670)
 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)


Steps to Reproduce



1. Configure Interaction Rule with strategy and Database through Class
2. Configure Simulation with Input Definition and Interaction Rule configured above
3. Execute the simulation


Root Cause



An issue in the custom application code or rules. The user is trying to run a Large Scale Batch simulation, (setting a Partition Key in Input Configuration). This needs additional configuration to make it work.

Resolution



Perform the following local-change:

In the Report Definition used in the Input Configuration. Set the following:
 
1. Add a parameter named PartitionKey.
​2. Add the filter on Partitionkey under Query tab.



3. Rerun the simulation.
Suggest Edit

Published January 31, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

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

Pega Community 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
Contact us