Piers Collins

Hi, ignore this.. I managed to get it to start collecting. It was a latency issue with the collectors returning results. Regards Piers

Hi JP, we have several IQ 16.1 instances under asemon. However one of them I'm having issues getting all of the required statistical information. For example these are not being populated server1_AmStats server1_IQCnx server1_IQMPXInfo server1_IQSQL server1_IQStatus server1_IQSysmon1 server1_IQSysmon2 server1_IQSysmon3 server1_IQTblSize But these are server1_IQCtx server1_IQDbSpace server1_IQIdxUse server1_IQTblUse server1_IQXacts I see no errors in the logs explaining why and the logger has full...

Hi JP, we have several IQ 16.1 instances under asemon. However one of them I'm having issues getting all of the required statistical information. For example these are not being populated **server1_AmStats server1_IQCnx server1_IQMPXInfo server1_IQSQL server1_IQStatus server1_IQSysmon1 server1_IQSysmon2 server1_IQSysmon3 server1_IQTblSize ** But these are **server1_IQCtx server1_IQDbSpace server1_IQIdxUse server1_IQTblUse server1_IQXacts ** I see no errors in the logs explaining why and the logger...

Hi JP, yes that has fixed it. Great product and great support. Thanks Piers

Hi JP we upgraded to the latest asemon_logger and asemon_report v3.2.4 and I'm seeing this [Thu Feb 13 14:27:24.167947 2025] [php:error] [pid 5152:tid 1304] [client xx.xxx.xx:60797] PHP Fatal error: Uncaught PDOException: SQLSTATE[ZZZZZ]: <<Unknown error>>: 247 [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Arithmetic overflow during explicit conversion of INT NULL value '-9223372036854775799' to a NUMERIC field .\n (SQLExecute[247] at ext\\pdo_odbc\\odbc_stmt.c:254) in C:\\AsemonReportSRV_PHP8\\Asemon_report\\COMMON\\connectArchiveServer.php:237\nStack...

Hi JP, I have tested it for just over a week and it looks good. Thanks Piers

Thanks

Hi JP, we are seeing this on a fairly frequent basis. Error in loop. java.lang.StringIndexOutOfBoundsException: String index out of range: -11 java.lang.StringIndexOutOfBoundsException: String index out of range: -11 at java.lang.String.substring(String.java:2013) at asemon_logger.ASMUtils.normStr(ASMUtils.java:532) at asemon_logger.CollectorMonSQL$RunningStmt.retreivePlan(CollectorMonSQL.java:704) at asemon_logger.CollectorMonSQL$RunningStmt.access$3100(CollectorMonSQL.java:374) at asemon_logger.CollectorMonSQL.getMetrics(CollectorMonSQL.java:1669)...