Simon Thackeray

Excellent point JP. You actually nailed it. That's the problem. I will check with the techies... Joyeux Noël et Bonne année 2025!

Hi JP, Thanks for the swift answer. I use both these ASE version: ASE Version = 16.0.03.03 ASE Version = 16.0.02.05 I confirm that I have the "switch" xml activated. I have attached my config file for reference. Could it be I need to be more granular on the versionSwitch instead of using the MAX?

Invalid column name 'QueryOptimizationTime' and 'NumAQTs'

Hi Jean-Paul, It was the Rowcnt column. Below are all the metrics. I only removed the name of the table ;) It belongs to a huge SAP R3 instance. pagecnt |leafcnt|emptypgcnt|Rowcnt |Forwardrowcnt|Delrowcnt|dpageCR|ipageCR|drowCR|page_utilization|space_utilization|largeIO_eff|actual_datapages|actual_indexpages|reserved_pages|Dpage_utilization|oamapgcnt|oampagecnt|---------+-------+----------+-----------+-------------+---------+-------+-------+------+----------------+-----------------+-----------+----------------+-----------------+--------------+-----------------+---------+----------+107475584|...

So far it seems to be collecting data smoothly :) simon@ynasrsr19901:~/asemon_logger/log> tail -f YEQ.log2022/10/15 13:31:46.054 YEQ_SysWaits - Start thread.2022/10/15 13:31:46.058 YEQ_Trends - Start thread.2022/10/15 13:31:46.059 YEQ_WClassInf - Start thread.2022/10/15 13:31:46.061 YEQ_WEvInf - Start thread.2022/10/15 13:32:01.859 YEQ_MonSQL - MonSQL BootID = 1000021 time_of_last_stmt_seen = 2022/10/15 12:51:20.6702022/10/15 14:01:46.062 Purge YEQ - Start thread.2022/10/15 14:01:46.062 Purge YEQ...

Hi Jean-Paul, it failed again ... 022/10/14 05:47:10.429 YEQ_Fragment - SamplingMetric ERROR : 247 Arithmetic overflow during explicit conversion of FLOAT NULL value '14494347965.0' to a NUMERIC field . 2022/10/14 05:47:10.430 YEQ_Fragment - Error in loop. Error=247 state=ZZZZZ SQL message=Arithmetic overflow during explicit conversion of FLOAT NULL value '14494347965.0' to a NUMERIC field . 2022/10/14 15:13:21.329 YEQ_CachedXML - Error in loop. Error=0 state=JZ006 SQL message=JZ006: Caught IOException:...

Hi again, I have modified the table as below: create table YEQ_Fragment ( Timestamp datetime not null, Interval int not null, dbname sysname not null, owner sysname not null, tabname varchar(255) not null, indname varchar(255) not null, indid int not null, lockmode varchar(10) not null, clu char(3) null, pagecnt bigint null, leafcnt bigint null, emptypgcnt bigint null, Rowcnt numeric(10,0) null, Forwardrowcnt numeric(10,0) null, Delrowcnt numeric(10,0) null, dpageCR numeric(14,2) null, ipageCR numeric(14,2)...

Hi, Thanks for your swift response. I am running Adaptive Server Enterprise/16.0 SP04. Will keep you posted on how things progress. Best regards Simon