AnsweredAssumed Answered

Issue in Wily console

Question asked by vrf684 on Dec 11, 2013
Latest reply on Dec 29, 2015 by Hiko_Davis

Hi,

Wily console was disconnected some times and  data is not showing properly(discounitnue graph) in wily intrascope(9.0.6.0) console. Observed below errors in logs Any suggitions.

 

AM UTC [ERROR] [QuartzScheduler_Worker-1] [org.quartz.core.JobRunShell] Job DEFAULT.jobDetailBean threw an unhandled Exception:
org.springframework.scheduling.quartz.JobMethodInvocationFailedException: Invocation of method 'pruneData' on target class [class com.wily.apm.model.pruning.DataPruner] failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: CallableStatementCallback; uncategorized SQLException for SQL [{? = call PRUNE_APM_DATA(?, ?)}]; SQL state [72000]; error code [20999]; ORA-20999: An error - -60 Error Msg - ORA-00060: deadlock detected while waiting for resource
ORA-06512: at "WILYADMIN.PRUNE_APM_DATA", line 71
ORA-06512: at line 1
; nested exception is java.sql.SQLException: ORA-20999: An error - -60 Error Msg - ORA-00060: deadlock detected while waiting for resource
ORA-06512: at "WILYADMIN.PRUNE_APM_DATA", line 71
ORA-06512: at line 1

        at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:269)
        at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.springframework.jdbc.UncategorizedSQLException: CallableStatementCallback; uncategorized SQLException for SQL [{? = call PRUNE_APM_DATA(?, ?)}]; SQL state [72000]; error code [20999]; ORA-20999: An error - -60 Error Msg - ORA-00060: deadlock detected while waiting for resource
ORA-06512: at "WILYADMIN.PRUNE_APM_DATA", line 71
ORA-06512: at line 1
; nested exception is java.sql.SQLException: ORA-20999: An error - -60 Error Msg - ORA-00060: deadlock detected while waiting for resource
ORA-06512: at "WILYADMIN.PRUNE_APM_DATA", line 71
ORA-06512: at line 1

        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)

Outcomes