#16 Asemon V3.0.2 don´t work and fail with RS

[Anonymous]

Hello people, I´m testing the new asemon version and have some problems:

1.- The display RS summary statistics not response (attach file.jpg), the screen remains loading.

2.- Error in display stable device usage:

ERROR
Module : refreshgrid()
Gridname : RS_devices_statistics

Message :
Sybase error : 156 severity : 15 state : 2 line : 17 Msg : Incorrect syntax near the keyword 'and'.

Query:
set rowcount 200
select
from
(
select
PartId,
Part_name,
Logical,
State,
CapacityAvg_Mb=convert(integer,avg(Total_segs)64/1024),
UsedAvg_Mb=convert(integer,avg(Used_segs)64/1024),
UsedMax_Mb=convert(integer,max(Used_segs)64/1024),
UsedLast_Mb=(select convert(integer,Used_segs64*/1024)
from PRSC_DISKSPCE
where Timestamp =
(select max(Timestamp) from PRSC_DISKSPCE where Timestamp <='11/21/2016 23:59')
and PartId = D.PartId
)
from PRSC_DISKSPCE D
where Timestamp >='11/21/2016 00:00'
and Timestamp <='11/21/2016 23:59'
group by PartId, Part_name, Logical, State
) data
where 1=1
set rowcount 0

3.- Error in display stable queues statistics:

ERROR
Module : refreshgrid()
Gridname : RS_Queues_statistics

Message :
Sybase error : 102 severity : 15 state : 181 line : 74 Msg : Incorrect syntax near ')'.

Query:
set rowcount 200
select *
from
(

select
[Queue]=statqueues.Info,

AVG_active_queue_sz_Mb=statqueues.AVG_active_queue_sz_Mb,
MAX_active_queue_sz_Mb=statqueues.MAX_active_queue_sz_Mb,
LAST_active_queue_sz_Mb=(
(
convert(numeric(9,0), substring(Last_Seg_Block, 1, patindex('%.%',Last_Seg_Block)))64.+
(convert(numeric(9,0), substring(Last_Seg_Block, patindex('%.%',Last_Seg_Block)+1, datalength(Last_Seg_Block))))1.)
-
(
convert(numeric(9,0), substring(First_Seg_Block, 1, patindex('%.%',First_Seg_Block)))64.+
(convert(numeric(9,0), substring(First_Seg_Block, patindex('%.%',First_Seg_Block)+1, datalength(First_Seg_Block)))-1)1.)
)*/1024,

sav_int_mn=statqueues.sav_int_mn,

AVG_saved_queue_sz_Mb=statqueues.AVG_saved_queue_sz_Mb,
MAX_saved_queue_sz_Mb=statqueues.MAX_saved_queue_sz_Mb,
LAST_saved_queue_sz_Mb=(
(convert(numeric(9,0), substring(First_Seg_Block, 1, patindex('%.%',First_Seg_Block)))) -
convert(numeric(9,0), substring(Save_Int_Seg, patindex('%:%',Save_Int_Seg)+1, datalength(Save_Int_Seg)))
)64./1024

from (
select Info,
sav_int_mn=max(case when lower(Save_Int_Seg) like 'strict%' then 'strict' else substring(Save_Int_Seg, 1, patindex('%:%',Save_Int_Seg)-1) end),

AVG_saved_queue_sz_Mb=avg(
(convert(numeric(9,0), substring(First_Seg_Block, 1, patindex('%.%',First_Seg_Block)))) -
convert(numeric(9,0), substring(Save_Int_Seg, patindex('%:%',Save_Int_Seg)+1, datalength(Save_Int_Seg)))
)64./1024,

AVG_active_queue_sz_Mb=avg(
(
convert(numeric(9,0), substring(Last_Seg_Block, 1, patindex('%.%',Last_Seg_Block)))64.+
(convert(numeric(9,0), substring(Last_Seg_Block, patindex('%.%',Last_Seg_Block)+1, datalength(Last_Seg_Block))))1.)
-
(
convert(numeric(9,0), substring(First_Seg_Block, 1, patindex('%.%',First_Seg_Block)))64.+
(convert(numeric(9,0), substring(First_Seg_Block, patindex('%.%',First_Seg_Block)+1, datalength(First_Seg_Block)))-1)1.)
)*/1024,

MAX_saved_queue_sz_Mb=max(
(convert(numeric(9,0), substring(First_Seg_Block, 1, patindex('%.%',First_Seg_Block)))) -
convert(numeric(9,0), substring(Save_Int_Seg, patindex('%:%',Save_Int_Seg)+1, datalength(Save_Int_Seg)))
)64./1024,

MAX_active_queue_sz_Mb=max(
(
convert(numeric(9,0), substring(Last_Seg_Block, 1, patindex('%.%',Last_Seg_Block)))64.+
(convert(numeric(9,0), substring(Last_Seg_Block, patindex('%.%',Last_Seg_Block)+1, datalength(Last_Seg_Block))))1.)
-
(
convert(numeric(9,0), substring(First_Seg_Block, 1, patindex('%.%',First_Seg_Block)))64.+
(convert(numeric(9,0), substring(First_Seg_Block, patindex('%.%',First_Seg_Block)+1, datalength(First_Seg_Block)))-1)1.)
)*/1024

       from PRSC_RSWhoSQM
       where  
            Timestamp >='11/21/2016 00:00'
        and Timestamp <='11/21/2016 23:59'

group by Info
) statqueues, PRSC_RSWhoSQM lastqueues
where convert(varchar,statqueues.Info) = convert(varchar,lastqueues.Info)
and lastqueues.Timestamp=(select max(Timestamp) from PRSC_RSWhoSQM where Timestamp <='11/21/2016 23:59')
) data
where 1=1
set rowcount 0

Thanks for your help.

Kind regards
Leandro Ferreira

[Jean-Paul Martin]

Hi, what is your browser and which version ? Can you hit the F12 key and see if you have any errors in the browser's console ?

Do you use the AsemonReportSRV package on windows or do you use your own Apache install ?
In that case what is the PHP version ?

You can check in the Apache error log if you get some messages (on windows : apache\logs\error.log)

I have used this version for RS monitoring recently and had not these problems

Best regards
JPM