Discussion
Virtusa
IN
Last activity: 1 Oct 2015 3:14 EDT
Error while running a Distribution test for a Marketing Program
Getting the following errors while trying to run a "distribution test" for a Marketing Program. It would be great if someone can help me out. The log file shows the following:
2015-10-01 11:13:57,469 [ PegaRULES-Batch-5] [ STANDARD] [ ] [ NbamPOC:01.01.01] (able.Pega_DM_Batch_Work.Action) ERROR - Batch table creation failed reason :Database-General Problem executing SQL to update database schema 942 42000 ORA-00942: table or view does not exist
2015-10-01 11:13:57,469 [ PegaRULES-Batch-5] [ STANDARD] [ ] [ NbamPOC:01.01.01] (able.Pega_DM_Batch_Work.Action) ERROR - Batch table creation failed stack trace
com.pega.pegarules.pub.database.DatabaseException: Database-General Problem executing SQL to update database schema 942 42000 ORA-00942: table or view does not exist
From: (BA8ED3BC9C6C982BFB131DA31E124931A)
SQL: CREATE INDEX BatchOutPRTest13_IDX ON BatchOutPRTest13(pyWorkId,pxRank,CustomerID)
Caused by SQL Problems.
Problem #1, SQLState 42000, Error code 942: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:262)
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeDBSchemaDDL(DatabaseImpl.java:7255)
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeDBSchemaUpdates(DatabaseImpl.java:7165)
at com.pegarules.generated.activity.ra_action_pzcreatebatchtable_509d7a6cb241a3b8e0691a3f0261355f.step5_circum0(ra_action_pzcreatebatchtable_509d7a6cb241a3b8e0691a3f0261355f.java:590)
at com.pegarules.generated.activity.ra_action_pzcreatebatchtable_509d7a6cb241a3b8e0691a3f0261355f.perform(ra_action_pzcreatebatchtable_509d7a6cb241a3b8e0691a3f0261355f.java:143)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)
at com.pegarules.generated.activity.ra_action_pzcreatebatchdecisionoutput_c4e44ee59fc7651e9eca435645b87c6d.step24_circum0(ra_action_pzcreatebatchdecisionoutput_c4e44ee59fc7651e9eca435645b87c6d.java:2547)
at com.pegarules.generated.activity.ra_action_pzcreatebatchdecisionoutput_c4e44ee59fc7651e9eca435645b87c6d.perform(ra_action_pzcreatebatchdecisionoutput_c4e44ee59fc7651e9eca435645b87c6d.java:573)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)
at com.pegarules.generated.activity.ra_action_createbatchoutputconfig_364a3c546b37101bd741a364607c2774.step20_circum0(ra_action_createbatchoutputconfig_364a3c546b37101bd741a364607c2774.java:1802)
at com.pegarules.generated.activity.ra_action_createbatchoutputconfig_364a3c546b37101bd741a364607c2774.perform(ra_action_createbatchoutputconfig_364a3c546b37101bd741a364607c2774.java:469)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)
at com.pegarules.generated.activity.ra_action_executeprogramrun_42d49e1c353b088f68fd776659ea391a.step18_circum0(ra_action_executeprogramrun_42d49e1c353b088f68fd776659ea391a.java:2293)
at com.pegarules.generated.activity.ra_action_executeprogramrun_42d49e1c353b088f68fd776659ea391a.perform(ra_action_executeprogramrun_42d49e1c353b088f68fd776659ea391a.java:364)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)
at com.pegarules.generated.activity.ra_action_executetestrun_d982b36eb2819ba95c6e0d0b65881f16.step3_circum0(ra_action_executetestrun_d982b36eb2819ba95c6e0d0b65881f16.java:360)
at com.pegarules.generated.activity.ra_action_executetestrun_d982b36eb2819ba95c6e0d0b65881f16.perform(ra_action_executetestrun_d982b36eb2819ba95c6e0d0b65881f16.java:103)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pegarules.generated.flow.ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.RunTaskActivity(ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.java:2787)
at com.pegarules.generated.flow.ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.Task_Utility1_circum0(ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.java:1533)
at com.pegarules.generated.flow.ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.perform(ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.java:612)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pegarules.generated.StartFlow_071017_Y4eQmw0Y6OuVgKxzwKWCmA.StartFlow07_10_17(StartFlow_071017_Y4eQmw0Y6OuVgKxzwKWCmA.java:167)
at com.pegarules.generated.StartFlow_071017_Y4eQmw0Y6OuVgKxzwKWCmA.invoke(StartFlow_071017_Y4eQmw0Y6OuVgKxzwKWCmA.java:76)
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_procom_flow.StartFlow(pega_procom_flow.java:639)
at com.pegarules.generated.activity.ra_action_startflow_753a4497bcf8036b6d79bc7e3159e897.step6_circum0(ra_action_startflow_753a4497bcf8036b6d79bc7e3159e897.java:586)
at com.pegarules.generated.activity.ra_action_startflow_753a4497bcf8036b6d79bc7e3159e897.perform(ra_action_startflow_753a4497bcf8036b6d79bc7e3159e897.java:155)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)
at com.pegarules.generated.activity.ra_action_processprogramrun_30069e2c1f276eb2b51ac564f76d0459.step6_circum0(ra_action_processprogramrun_30069e2c1f276eb2b51ac564f76d0459.java:692)
at com.pegarules.generated.activity.ra_action_processprogramrun_30069e2c1f276eb2b51ac564f76d0459.perform(ra_action_processprogramrun_30069e2c1f276eb2b51ac564f76d0459.java:168)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pega.pegarules.session.internal.async.agent.QueueProcessor.runActivity(QueueProcessor.java:721)
at com.pega.pegarules.session.internal.async.agent.QueueProcessor.execute(QueueProcessor.java:602)
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:662)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:942)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1706)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1674)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:275)
at com.pega.pegarules.data.internal.access.GenericExecutor.execute(GenericExecutor.java:42)
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeDBSchemaDDL(DatabaseImpl.java:7243)
... 48 more
2015-10-01 11:13:59,103 [ PegaRULES-Batch-5] [ STANDARD] [ ] [ NbamPOC:01.01.01] (able.Pega_DM_Batch_Work.Action) ERROR - Batch table creation failed reason :Database-General Problem executing SQL to update database schema 942 42000 ORA-00942: table or view does not exist
2015-10-01 11:13:59,103 [ PegaRULES-Batch-5] [ STANDARD] [ ] [ NbamPOC:01.01.01] (able.Pega_DM_Batch_Work.Action) ERROR - Batch table creation failed stack trace
com.pega.pegarules.pub.database.DatabaseException: Database-General Problem executing SQL to update database schema 942 42000 ORA-00942: table or view does not exist
From: (BA8ED3BC9C6C982BFB131DA31E124931A)
SQL: CREATE INDEX BATCHOUTPRTest13_VC_IDX ON BATCHOUTPRTest13_VC(pyWorkId,pxRank,CustomerID)
Caused by SQL Problems.
Problem #1, SQLState 42000, Error code 942: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:262)
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeDBSchemaDDL(DatabaseImpl.java:7255)
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeDBSchemaUpdates(DatabaseImpl.java:7165)
at com.pegarules.generated.activity.ra_action_pzcreatebatchtable_509d7a6cb241a3b8e0691a3f0261355f.step5_circum0(ra_action_pzcreatebatchtable_509d7a6cb241a3b8e0691a3f0261355f.java:590)
at com.pegarules.generated.activity.ra_action_pzcreatebatchtable_509d7a6cb241a3b8e0691a3f0261355f.perform(ra_action_pzcreatebatchtable_509d7a6cb241a3b8e0691a3f0261355f.java:143)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)
at com.pegarules.generated.activity.ra_action_pzcreatebatchdecisionoutput_c4e44ee59fc7651e9eca435645b87c6d.step24_circum0(ra_action_pzcreatebatchdecisionoutput_c4e44ee59fc7651e9eca435645b87c6d.java:2547)
at com.pegarules.generated.activity.ra_action_pzcreatebatchdecisionoutput_c4e44ee59fc7651e9eca435645b87c6d.perform(ra_action_pzcreatebatchdecisionoutput_c4e44ee59fc7651e9eca435645b87c6d.java:573)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)
at com.pegarules.generated.activity.ra_action_createdecisionexecutionconfig_0b693f582c61d8180fe1a29e6410d971.step5_circum0(ra_action_createdecisionexecutionconfig_0b693f582c61d8180fe1a29e6410d971.java:515)
at com.pegarules.generated.activity.ra_action_createdecisionexecutionconfig_0b693f582c61d8180fe1a29e6410d971.perform(ra_action_createdecisionexecutionconfig_0b693f582c61d8180fe1a29e6410d971.java:143)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)
at com.pegarules.generated.activity.ra_action_createbatchoutputconfig_364a3c546b37101bd741a364607c2774.step22_circum0(ra_action_createbatchoutputconfig_364a3c546b37101bd741a364607c2774.java:1974)
at com.pegarules.generated.activity.ra_action_createbatchoutputconfig_364a3c546b37101bd741a364607c2774.perform(ra_action_createbatchoutputconfig_364a3c546b37101bd741a364607c2774.java:503)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)
at com.pegarules.generated.activity.ra_action_executeprogramrun_42d49e1c353b088f68fd776659ea391a.step18_circum0(ra_action_executeprogramrun_42d49e1c353b088f68fd776659ea391a.java:2293)
at com.pegarules.generated.activity.ra_action_executeprogramrun_42d49e1c353b088f68fd776659ea391a.perform(ra_action_executeprogramrun_42d49e1c353b088f68fd776659ea391a.java:364)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)
at com.pegarules.generated.activity.ra_action_executetestrun_d982b36eb2819ba95c6e0d0b65881f16.step3_circum0(ra_action_executetestrun_d982b36eb2819ba95c6e0d0b65881f16.java:360)
at com.pegarules.generated.activity.ra_action_executetestrun_d982b36eb2819ba95c6e0d0b65881f16.perform(ra_action_executetestrun_d982b36eb2819ba95c6e0d0b65881f16.java:103)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pegarules.generated.flow.ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.RunTaskActivity(ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.java:2787)
at com.pegarules.generated.flow.ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.Task_Utility1_circum0(ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.java:1533)
at com.pegarules.generated.flow.ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.perform(ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.java:612)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pegarules.generated.StartFlow_071017_Y4eQmw0Y6OuVgKxzwKWCmA.StartFlow07_10_17(StartFlow_071017_Y4eQmw0Y6OuVgKxzwKWCmA.java:167)
at com.pegarules.generated.StartFlow_071017_Y4eQmw0Y6OuVgKxzwKWCmA.invoke(StartFlow_071017_Y4eQmw0Y6OuVgKxzwKWCmA.java:76)
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_procom_flow.StartFlow(pega_procom_flow.java:639)
at com.pegarules.generated.activity.ra_action_startflow_753a4497bcf8036b6d79bc7e3159e897.step6_circum0(ra_action_startflow_753a4497bcf8036b6d79bc7e3159e897.java:586)
at com.pegarules.generated.activity.ra_action_startflow_753a4497bcf8036b6d79bc7e3159e897.perform(ra_action_startflow_753a4497bcf8036b6d79bc7e3159e897.java:155)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)
at com.pegarules.generated.activity.ra_action_processprogramrun_30069e2c1f276eb2b51ac564f76d0459.step6_circum0(ra_action_processprogramrun_30069e2c1f276eb2b51ac564f76d0459.java:692)
at com.pegarules.generated.activity.ra_action_processprogramrun_30069e2c1f276eb2b51ac564f76d0459.perform(ra_action_processprogramrun_30069e2c1f276eb2b51ac564f76d0459.java:168)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pega.pegarules.session.internal.async.agent.QueueProcessor.runActivity(QueueProcessor.java:721)
at com.pega.pegarules.session.internal.async.agent.QueueProcessor.execute(QueueProcessor.java:602)
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:662)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:942)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1706)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1674)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:275)
at com.pega.pegarules.data.internal.access.GenericExecutor.execute(GenericExecutor.java:42)
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeDBSchemaDDL(DatabaseImpl.java:7243)
... 52 more
2015-10-01 11:13:59,212 [ PegaRULES-Batch-5] [ STANDARD] [ ] [ NbamPOC:01.01.01] (PegaMKT_Work_ProgramRun.Action) ERROR - Batch table INDEX creation failed. Reason :Database-General Problem executing SQL to update database schema 942 42000 ORA-00942: table or view does not exist
2015-10-01 11:13:59,212 [ PegaRULES-Batch-5] [ STANDARD] [ ] [ NbamPOC:01.01.01] (PegaMKT_Work_ProgramRun.Action) ERROR - Batch table INDEX creation failed stack trace
com.pega.pegarules.pub.database.DatabaseException: Database-General Problem executing SQL to update database schema 942 42000 ORA-00942: table or view does not exist
From: (BA8ED3BC9C6C982BFB131DA31E124931A)
SQL: CREATE INDEX BatchOutPRTest13_BAT ON BatchOutPRTest13(CustomerID, BUNDLENAME, BUNDLEPARENT DESC, PXRANK )
Caused by SQL Problems.
Problem #1, SQLState 42000, Error code 942: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:262)
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeDBSchemaDDL(DatabaseImpl.java:7255)
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeDBSchemaUpdates(DatabaseImpl.java:7165)
at com.pegarules.generated.activity.ra_action_createbatchoutputconfig_364a3c546b37101bd741a364607c2774.step25_circum0(ra_action_createbatchoutputconfig_364a3c546b37101bd741a364607c2774.java:2145)
at com.pegarules.generated.activity.ra_action_createbatchoutputconfig_364a3c546b37101bd741a364607c2774.perform(ra_action_createbatchoutputconfig_364a3c546b37101bd741a364607c2774.java:561)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)
at com.pegarules.generated.activity.ra_action_executeprogramrun_42d49e1c353b088f68fd776659ea391a.step18_circum0(ra_action_executeprogramrun_42d49e1c353b088f68fd776659ea391a.java:2293)
at com.pegarules.generated.activity.ra_action_executeprogramrun_42d49e1c353b088f68fd776659ea391a.perform(ra_action_executeprogramrun_42d49e1c353b088f68fd776659ea391a.java:364)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)
at com.pegarules.generated.activity.ra_action_executetestrun_d982b36eb2819ba95c6e0d0b65881f16.step3_circum0(ra_action_executetestrun_d982b36eb2819ba95c6e0d0b65881f16.java:360)
at com.pegarules.generated.activity.ra_action_executetestrun_d982b36eb2819ba95c6e0d0b65881f16.perform(ra_action_executetestrun_d982b36eb2819ba95c6e0d0b65881f16.java:103)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pegarules.generated.flow.ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.RunTaskActivity(ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.java:2787)
at com.pegarules.generated.flow.ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.Task_Utility1_circum0(ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.java:1533)
at com.pegarules.generated.flow.ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.perform(ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.java:612)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pegarules.generated.StartFlow_071017_Y4eQmw0Y6OuVgKxzwKWCmA.StartFlow07_10_17(StartFlow_071017_Y4eQmw0Y6OuVgKxzwKWCmA.java:167)
at com.pegarules.generated.StartFlow_071017_Y4eQmw0Y6OuVgKxzwKWCmA.invoke(StartFlow_071017_Y4eQmw0Y6OuVgKxzwKWCmA.java:76)
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_procom_flow.StartFlow(pega_procom_flow.java:639)
at com.pegarules.generated.activity.ra_action_startflow_753a4497bcf8036b6d79bc7e3159e897.step6_circum0(ra_action_startflow_753a4497bcf8036b6d79bc7e3159e897.java:586)
at com.pegarules.generated.activity.ra_action_startflow_753a4497bcf8036b6d79bc7e3159e897.perform(ra_action_startflow_753a4497bcf8036b6d79bc7e3159e897.java:155)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)
at com.pegarules.generated.activity.ra_action_processprogramrun_30069e2c1f276eb2b51ac564f76d0459.step6_circum0(ra_action_processprogramrun_30069e2c1f276eb2b51ac564f76d0459.java:692)
at com.pegarules.generated.activity.ra_action_processprogramrun_30069e2c1f276eb2b51ac564f76d0459.perform(ra_action_processprogramrun_30069e2c1f276eb2b51ac564f76d0459.java:168)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pega.pegarules.session.internal.async.agent.QueueProcessor.runActivity(QueueProcessor.java:721)
at com.pega.pegarules.session.internal.async.agent.QueueProcessor.execute(QueueProcessor.java:602)
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:662)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:942)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1706)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1674)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:275)
at com.pega.pegarules.data.internal.access.GenericExecutor.execute(GenericExecutor.java:42)
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeDBSchemaDDL(DatabaseImpl.java:7243)
... 40 more
2015-10-01 11:14:04,478 [ PegaRULES-Batch-5] [ STANDARD] [ ] [ NbamPOC:01.01.01] ( internal.mgmt.Executable) ERROR - Exception
com.pega.pegarules.pub.PRAppRuntimeException: The flow ExecuteProgramRun had a problem on step Utility1 of: com.pega.pegarules.pub.generator.UnresolvedAssemblyError: ** 1367470394§GetNumericSystemSettingValue§PegaEL-InvalidExpression No candidates found [possible function name, ruleset/version or number of parameter problem] for Rule-Utility-Function in ruleset list <null> expected since isEditing is false ruleset = PegaMKT-PushNotification library = PushNotification functionName = GetNumericSystemSettingValue parameters = [ Item: "PegaMKT-PushNotification" Pega type = text Java data type = String, Item: "NumberOfPartitions" Pega type = text Java data type = String, Item: 5 Pega type = integer Java data type = int] @(PegaMKT-PushNotification:PushNotification).GetNumericSystemSettingValue("PegaMKT-PushNotification","NumberOfPartitions",5)
From: (BA8ED3BC9C6C982BFB131DA31E124931A)
at com.pegarules.generated.activity.ra_action_problemflowthrowexception_0287af95244464eee8a78ef088ca28e4.step3_circum0(ra_action_problemflowthrowexception_0287af95244464eee8a78ef088ca28e4.java:269)
at com.pegarules.generated.activity.ra_action_problemflowthrowexception_0287af95244464eee8a78ef088ca28e4.perform(ra_action_problemflowthrowexception_0287af95244464eee8a78ef088ca28e4.java:103)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pegarules.generated.flow.ra_action_flowproblems_082e122ca3ac7453c435359f419716bd.RunTaskActivity(ra_action_flowproblems_082e122ca3ac7453c435359f419716bd.java:4811)
at com.pegarules.generated.flow.ra_action_flowproblems_082e122ca3ac7453c435359f419716bd.Task_ThrowException_circum0(ra_action_flowproblems_082e122ca3ac7453c435359f419716bd.java:1762)
at com.pegarules.generated.flow.ra_action_flowproblems_082e122ca3ac7453c435359f419716bd.perform(ra_action_flowproblems_082e122ca3ac7453c435359f419716bd.java:638)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pegarules.generated.StartFlow_071017_Y4eQmw0Y6OuVgKxzwKWCmA.StartFlow07_10_17(StartFlow_071017_Y4eQmw0Y6OuVgKxzwKWCmA.java:167)
at com.pegarules.generated.StartFlow_071017_Y4eQmw0Y6OuVgKxzwKWCmA.invoke(StartFlow_071017_Y4eQmw0Y6OuVgKxzwKWCmA.java:76)
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_procom_flow.StartFlow(pega_procom_flow.java:639)
at com.pegarules.generated.activity.ra_action_problemflow_ea0bd1326c3baf9cafd066e81e6970ad.step3_circum0(ra_action_problemflow_ea0bd1326c3baf9cafd066e81e6970ad.java:320)
at com.pegarules.generated.activity.ra_action_problemflow_ea0bd1326c3baf9cafd066e81e6970ad.perform(ra_action_problemflow_ea0bd1326c3baf9cafd066e81e6970ad.java:103)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pegarules.generated.flow.ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.ProblemFlow(ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.java:3469)
at com.pegarules.generated.flow.ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.ProblemFlow(ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.java:3385)
at com.pegarules.generated.flow.ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.RunTaskActivity(ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.java:2808)
at com.pegarules.generated.flow.ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.Task_Utility1_circum0(ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.java:1533)
at com.pegarules.generated.flow.ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.perform(ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.java:612)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pegarules.generated.StartFlow_071017_Y4eQmw0Y6OuVgKxzwKWCmA.StartFlow07_10_17(StartFlow_071017_Y4eQmw0Y6OuVgKxzwKWCmA.java:167)
at com.pegarules.generated.StartFlow_071017_Y4eQmw0Y6OuVgKxzwKWCmA.invoke(StartFlow_071017_Y4eQmw0Y6OuVgKxzwKWCmA.java:76)
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_procom_flow.StartFlow(pega_procom_flow.java:639)
at com.pegarules.generated.activity.ra_action_startflow_753a4497bcf8036b6d79bc7e3159e897.step6_circum0(ra_action_startflow_753a4497bcf8036b6d79bc7e3159e897.java:586)
at com.pegarules.generated.activity.ra_action_startflow_753a4497bcf8036b6d79bc7e3159e897.perform(ra_action_startflow_753a4497bcf8036b6d79bc7e3159e897.java:155)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)
at com.pegarules.generated.activity.ra_action_processprogramrun_30069e2c1f276eb2b51ac564f76d0459.step6_circum0(ra_action_processprogramrun_30069e2c1f276eb2b51ac564f76d0459.java:692)
at com.pegarules.generated.activity.ra_action_processprogramrun_30069e2c1f276eb2b51ac564f76d0459.perform(ra_action_processprogramrun_30069e2c1f276eb2b51ac564f76d0459.java:168)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pega.pegarules.session.internal.async.agent.QueueProcessor.runActivity(QueueProcessor.java:721)
at com.pega.pegarules.session.internal.async.agent.QueueProcessor.execute(QueueProcessor.java:602)
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:662)
2015-10-01 11:14:04,494 [ PegaRULES-Batch-5] [ STANDARD] [ ] [ NbamPOC:01.01.01] ( FlowProblems.Work_.Action) ERROR - Problem flow abort due to system flow FlowProblems being the issue
com.pega.pegarules.pub.PRAppRuntimeException: The flow ExecuteProgramRun had a problem on step Utility1 of: com.pega.pegarules.pub.generator.UnresolvedAssemblyError: ** 1367470394§GetNumericSystemSettingValue§PegaEL-InvalidExpression No candidates found [possible function name, ruleset/version or number of parameter problem] for Rule-Utility-Function in ruleset list <null> expected since isEditing is false ruleset = PegaMKT-PushNotification library = PushNotification functionName = GetNumericSystemSettingValue parameters = [ Item: "PegaMKT-PushNotification" Pega type = text Java data type = String, Item: "NumberOfPartitions" Pega type = text Java data type = String, Item: 5 Pega type = integer Java data type = int] @(PegaMKT-PushNotification:PushNotification).GetNumericSystemSettingValue("PegaMKT-PushNotification","NumberOfPartitions",5)
From: (BA8ED3BC9C6C982BFB131DA31E124931A)
at com.pegarules.generated.activity.ra_action_problemflowthrowexception_0287af95244464eee8a78ef088ca28e4.step3_circum0(ra_action_problemflowthrowexception_0287af95244464eee8a78ef088ca28e4.java:269)
at com.pegarules.generated.activity.ra_action_problemflowthrowexception_0287af95244464eee8a78ef088ca28e4.perform(ra_action_problemflowthrowexception_0287af95244464eee8a78ef088ca28e4.java:103)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pegarules.generated.flow.ra_action_flowproblems_082e122ca3ac7453c435359f419716bd.RunTaskActivity(ra_action_flowproblems_082e122ca3ac7453c435359f419716bd.java:4811)
at com.pegarules.generated.flow.ra_action_flowproblems_082e122ca3ac7453c435359f419716bd.Task_ThrowException_circum0(ra_action_flowproblems_082e122ca3ac7453c435359f419716bd.java:1762)
at com.pegarules.generated.flow.ra_action_flowproblems_082e122ca3ac7453c435359f419716bd.perform(ra_action_flowproblems_082e122ca3ac7453c435359f419716bd.java:638)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pegarules.generated.StartFlow_071017_Y4eQmw0Y6OuVgKxzwKWCmA.StartFlow07_10_17(StartFlow_071017_Y4eQmw0Y6OuVgKxzwKWCmA.java:167)
at com.pegarules.generated.StartFlow_071017_Y4eQmw0Y6OuVgKxzwKWCmA.invoke(StartFlow_071017_Y4eQmw0Y6OuVgKxzwKWCmA.java:76)
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_procom_flow.StartFlow(pega_procom_flow.java:639)
at com.pegarules.generated.activity.ra_action_problemflow_ea0bd1326c3baf9cafd066e81e6970ad.step3_circum0(ra_action_problemflow_ea0bd1326c3baf9cafd066e81e6970ad.java:320)
at com.pegarules.generated.activity.ra_action_problemflow_ea0bd1326c3baf9cafd066e81e6970ad.perform(ra_action_problemflow_ea0bd1326c3baf9cafd066e81e6970ad.java:103)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pegarules.generated.flow.ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.ProblemFlow(ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.java:3469)
at com.pegarules.generated.flow.ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.ProblemFlow(ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.java:3385)
at com.pegarules.generated.flow.ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.RunTaskActivity(ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.java:2808)
at com.pegarules.generated.flow.ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.Task_Utility1_circum0(ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.java:1533)
at com.pegarules.generated.flow.ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.perform(ra_action_executeprogramrun_28e77e5ea2c4703e702c78d99e1b025e.java:612)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pegarules.generated.StartFlow_071017_Y4eQmw0Y6OuVgKxzwKWCmA.StartFlow07_10_17(StartFlow_071017_Y4eQmw0Y6OuVgKxzwKWCmA.java:167)
at com.pegarules.generated.StartFlow_071017_Y4eQmw0Y6OuVgKxzwKWCmA.invoke(StartFlow_071017_Y4eQmw0Y6OuVgKxzwKWCmA.java:76)
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_procom_flow.StartFlow(pega_procom_flow.java:639)
at com.pegarules.generated.activity.ra_action_startflow_753a4497bcf8036b6d79bc7e3159e897.step6_circum0(ra_action_startflow_753a4497bcf8036b6d79bc7e3159e897.java:586)
at com.pegarules.generated.activity.ra_action_startflow_753a4497bcf8036b6d79bc7e3159e897.perform(ra_action_startflow_753a4497bcf8036b6d79bc7e3159e897.java:155)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)
at com.pegarules.generated.activity.ra_action_processprogramrun_30069e2c1f276eb2b51ac564f76d0459.step6_circum0(ra_action_processprogramrun_30069e2c1f276eb2b51ac564f76d0459.java:692)
at com.pegarules.generated.activity.ra_action_processprogramrun_30069e2c1f276eb2b51ac564f76d0459.perform(ra_action_processprogramrun_30069e2c1f276eb2b51ac564f76d0459.java:168)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pega.pegarules.session.internal.async.agent.QueueProcessor.runActivity(QueueProcessor.java:721)
at com.pega.pegarules.session.internal.async.agent.QueueProcessor.execute(QueueProcessor.java:602)
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:662)