Hi ,
In version Version 4.1.5.21
A report ( Bar - vertical stack ) using the query above
select to_char(trunc(a.end_time,'MI'),'HH24:MI') end_time,
b.wait_class wait_class,
round((sum(a.time_waited) / 10),2) sample_count
from gv$waitclassmetric_history a,
gv$system_wait_class b
where a.wait_class# = b.wait_class# and
b.wait_class != 'Idle'
and a.inst_id = b.inst_id
group by trunc(a.end_time,'MI'), b.wait_class
order by trunc(a.end_time,'MI'),2
Is working without problem.
But in version 17.2.0.188 the report stop with the following details.
java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
at java.sql.Timestamp.valueOf(Timestamp.java:204)
at oracle.jdbc.driver.CharCommonAccessor.getTimestamp(CharCommonAccessor.java:544)
at oracle.jdbc.driver.T4CVarcharAccessor.getTimestamp(T4CVarcharAccessor.java:959)
at oracle.jdbc.driver.OracleResultSetImpl.getTimestamp(OracleResultSetImpl.java:1422)
at oracle.dbtools.raptor.controls.display.DisplaySimpleChart.getTabularDataValue(DisplaySimpleChart.java:525)
at oracle.dbtools.raptor.controls.display.DisplaySimpleChart.populateTabularData(DisplaySimpleChart.java:392)
at oracle.dbtools.raptor.controls.display.DisplaySimpleChart.access$600(DisplaySimpleChart.java:61)
at oracle.dbtools.raptor.controls.display.DisplaySimpleChart$3.loadData(DisplaySimpleChart.java:214)
at oracle.dbtools.raptor.controls.display.CancellableQuery.processWork(CancellableQuery.java:132)
at oracle.dbtools.raptor.controls.display.CancellableQuery.access$100(CancellableQuery.java:22)
at oracle.dbtools.raptor.controls.display.CancellableQuery$1.doWork(CancellableQuery.java:107)
at oracle.dbtools.raptor.controls.display.CancellableQuery$1.doWork(CancellableQuery.java:99)
at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:193)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:629)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:748)
What is wrong?
I have missed something?
Thanks