#41 Various Problems
Hi,
i'm getting the message : when opening a PID Information from the Process View
ERROR
Module : refreshchart()
Chartname :graphPCache_cnx
Message :
Sybase error : 102 severity : 15 state : 181 line : 5 Msg : Incorrect syntax near '2016'.
Query:
select Ts=convert(varchar,ListTimestamp.Timestamp,109),
memusage
from (select distinct Timestamp from I01MXDS1_CnxActiv
where Timestamp >='invalid date: '2016/10/27 17:24:15.793''
and Timestamp <='10/27/2016 22:59'
) ListTimestamp
left outer join I01MXDS1_CnxActiv B on ListTimestamp.Timestamp = B.Timestamp and Loggedindatetime between dateadd(ss,-1,'2016/10/27 17:24:15.793') and dateadd(ss,+1,'2016/10/27 17:24:15.793') and B.Spid=218
order by ListTimestamp.Timestamp
Using your latest ASEMON on ASE 15.7.
Im also having problems with the CPU Graphs in the Summary Page and the "Range Selector"
Discussion
Anonymous
Hi, the date error is due to a incorrect input in the StartTimestamp field (not a bad input from user but the result of an bad convertion in Javascript. I already saw this error but cannot reproduce) Just erase the StartTimestamp field and enter a correct date.
For the RangeSelector not displaying data : it can be long to display if the Trends do not exist for this server (there is an optimization in the RangeSelector to first get data from xxx_Trends table and if no Trend exist, it get data for xxx_Engines which is much larger) So check if Trends have been activated for this server
I don't know why the Summary page does not display any data in your case, may be the range selected does not contains data (but Asemon should say there is no data) Can you check if there is any message in the Browser console (hit the F12 key if you use Chrome and see if there is a message in the console)
Hope this help
JPM