#36 "error in refreshAsemonRangesel()"

[Anonymous]

Hi JP, we're getting an error in asemon.widgets-min.js
"error in refreshAsemonRangesel()"
HAve you seen this?
I've tried date format mdy and dmy any thing else I should be checking?
Thanks

[Anonymous]

I enabled SQLText monitoring. I then clicked refresh. The SQL I retrieved ran fine but we're still getting the error. Wonder if the problem is on the webserver side with processing the data

[Anonymous]

We've now upgraded to latest release on logger and report and problem persists

[Anonymous]

This query returns 250,000 rows
select Ts=convert(varchar,Timestamp,109),
TotCpu=(case when d_ProcessCPUUser <0 then 0 else d_ProcessCPUUser end) + (case when d_ProcessCPUSystem <0 then 0 else d_ProcessCPUSystem end)
from xxx_IQAsaStat
where Timestamp >='01/01/1900'
and Timestamp <='01/01/2050'
order by Timestamp

[Anonymous]

This query
set dateformat mdy
if object_id('#tz') is not null drop table #tz
if object_id('#versions') is not null drop table #versions
if object_id('#ls0') is not null drop table #ls0
if object_id('#ls0bis') is not null drop table #ls0bis
if object_id('#ls1') is not null drop table #ls1
if object_id('#ls2') is not null drop table #ls2

      declare @SrvType char(5), @SrvName varchar(255), @tablename varchar(255), @archtimezone smallint, @srvtimezone smallint
      -- get archserver timezone

...
...
returns 19 rows

[Jean-Paul Martin]

Did you install the latest asemon_report version ?
I fixed some errors like this in previous version

[Anonymous]

Hi,

We're running Asemon Report V3.1.7 (210111) and asemon_logger_V3.1.7

Thanks

[Jean-Paul Martin]

Ok good, this is latest version. I have no time today to analyze that. Will keep you informed

Anyway, when I read your problem description I don't understand : can you be more precise and give an example

[Anonymous]

When looking at an IQ server, the grey range selector bar at the top of the screen says 'Loading', then it will fail with a pop up that says 'error in refreshAsemonRangesel()'. I then have to click OK to continue
Doesn't happen for all servers, so I'm guessing a data issue but can't find it

[Anonymous]

Screenshot

[Jean-Paul Martin]

Hi,
is your asemon database on ASE or on IQ ?
Do you have data in asemon tables for this IQ monitored server ?
What is your browser ? (Chrome, Firefox, Edge, and is it a recent version ?)

[Anonymous]

Hi,
asemon data is stored in ASE (16.0 SP03 PL08)
We have the following tables:-
table locking rows
xxx_AmStats Datapages 2673509
xxx_IQAsaStat Datapages 259546
xxx_IQCnx Datapages 2225755
xxx_IQCtx Datarows 3124082
xxx_IQDbSpace Datapages 73056
xxx_IQIdxUse Datapages 4720258
xxx_IQInfo Datapages 94
xxx_IQMPXInfo Datapages 0
xxx_IQSQL Datapages 3586265
xxx_IQStatus Datapages 259578
xxx_IQSysmon1 Datapages 28649
xxx_IQSysmon2 Datapages 3444687
xxx_IQSysmon3 Datapages 7575353
xxx_IQTblSize Datapages 67532
xxx_IQTblUse Datapages 7441103
xxx_IQVersUse Datapages 0
xxx_IQXacts Datapages 9175425

Using Chrome Version 88.0.4324.150 (Official Build) (64-bit)
internet explorer 1909
Edge Version 88.0.705.81 (Official build) (64-bit)
Don't have firefox

[Jean-Paul Martin]

Hi,you said the query on IQASAStats returns 250,000 rows (you currently have 259546 rows in this table from your last post) may be you encounter a memory limitation in PHP (the returned array is stored in memory during filtering and aggregation before returning far less data to the browser)
Do you have any error in your Apache error log ?

[Anonymous]

Looks like you've found the issue, thanks
[PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 32 bytes) in C:\AsemonReportSRV\Asemon_report\COMMON\getrangeseldata.php on line 139, referer: http://xxx/Asemon_report/Asemon_report.php

What's the best way to increase it?

[Anonymous]

Found it in php.ini, changed to 1024M and it's working. Thanks for your patience and help