Question
CTS
IN
Last activity: 3 Feb 2021 3:45 EST
ERROR - Exception while defragmenting System-Message-QueueProcessor-DelayedItem
Hi All,
We're observing the following exception repeatedly in prod environment LOG:
| Exception while defragmenting System-Message-QueueProcessor-DelayedItem table |
| com.pega.pegarules.pub.database.DatabaseException: Exception while defragmenting Table::pr_sys_delayed_queue associated with class::System-Message-QueueProcessor-DelayedItem: code: 955 SQLState: 42000 Message: ORA-00955: name is already used by an existing object |
Appreciate if anyone can help me on this exception.
Updated: 3 Feb 2021 3:45 EST
AI4Process Ltd
GB
Hi, Recently, we are also getting very similar error in our SIT environment(Pega 8.3.1).
Hi, Recently, we are also getting very similar error in our SIT environment(Pega 8.3.1).
2021-02-03 00:00:02,377 [EDULER_THREAD_POOL_2] [ STANDARD] [ ] [ ] ( JobScheduler) ERROR - Exception in executing Job[pyClusterAndDBCleaner] com.pega.platform.executor.jobscheduler.scheduler.JobExecutionException: Activity execution failed with [User marked activity execution to failed with message [ Exception while defragmenting Table::pr_sys_delayed_queue associated with class::System-Message-QueueProcessor-DelayedItem: code: 1031 SQLState: 42000 Message: ORA-01031: insufficient privileges ORA-06512: at "PEGADATA.SPPR_DEFRAGMENT_TABLE", line 54 ORA-06512: at "PEGADATA.SPPR_DEFRAGMENT_TABLE", line 48 ORA-06512: at line 1 ]] at com.pega.platform.executor.jobscheduler.internal.JobSchedulerProcessor.execute(JobSchedulerProcessor.java:54) ~[pega-executor.jar:?] at com.pega.platform.executor.jobscheduler.scheduler.internal.JobRunTimeImpl.execute(JobRunTimeImpl.java:67) ~[executor.jar:?] at com.pega.platform.executor.jobscheduler.scheduler.internal.JobRunTimeDecorator.execute(JobRunTimeDecorator.java:57) ~[executor.jar:?] at com.pega.platform.executor.jobscheduler.scheduler.internal.JobRunTimeDecorator.execute(JobRunTimeDecorator.java:57) ~[executor.jar:?] at com.pega.platform.executor.jobscheduler.scheduler.internal.JobExecutionTemplate.executeJob(JobExecutionTemplate.java:45) ~[executor.jar:?] at com.pega.platform.executor.jobscheduler.scheduler.internal.JobExecutionTemplate.run(JobExecutionTemplate.java:35) ~[executor.jar:?] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_272] at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_272] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) ~[?:1.8.0_272] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) ~[?:1.8.0_272] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_272] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_272] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_272] Caused by: com.pega.platform.executor.jobscheduler.scheduler.JobExecutionException: User marked activity execution to failed with message [ Exception while defragmenting Table::pr_sys_delayed_queue associated with class::System-Message-QueueProcessor-DelayedItem: code: 1031 SQLState: 42000 Message: ORA-01031: insufficient privileges ORA-06512: at "PEGADATA.SPPR_DEFRAGMENT_TABLE", line 54 ORA-06512: at "PEGADATA.SPPR_DEFRAGMENT_TABLE", line 48 ORA-06512: at line 1 ] at com.pega.platform.executor.jobscheduler.internal.JobSchedulerProcessor.identifyUserMarkedFailure(JobSchedulerProcessor.java:68) ~[pega-executor.jar:?] at com.pega.platform.executor.jobscheduler.internal.JobSchedulerProcessor.execute(JobSchedulerProcessor.java:51) ~[pega-executor.jar:?] ... 12 more