Discussion

4
Replies
289
Views
SreelathaNara Member since 2015 1 post
Virtusa
Posted: 5 years ago
Last activity: 5 years ago
Closed

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)

Pega Academy
Moderation Team has archived post
Share this page LinkedIn