Activity for asemon
-
Jean-Paul Martin modified a wiki page
asemon what is new
-
asemon updated /ChangeLog.txt
-
-
-
-
-
Anonymous created ticket #22
Update PHO Version to 8.4
-
elovelo posted a comment on discussion Help
ok, JP. thank you, I will give ot a try with shorter deleteSleep
-
no, sorry, I didn't create a parameter for that Anyway with deletesleep=1 the purge should be considerably faster
-
Thank you. And I suppose there is no way to increase the packet size of these 1000 rows?
-
Hi elovelo, you can change the parameter deleteSleep and set it to "1" rather than "100" It 'll wait 1 ms between each delete packet of 1000 rows Restart asemon_logger to make this change effective Regards Jpm
-
Hello JP, so, I restarted the logger with flag 113 and the Purge task works indeed, but apparently it's very slow as it deletes 1000 rows at a time every 100 ms as per the attached ss with logs. It started with the biggest table for the monitored instance, XXX_OpObjAct. It's over 71 GB in size and has over 220 000 000 rows and there are over 40 000 000 rows with Timestamp < '2025/08/08 15:40:03' that are to be deleted as per daysToKeep=31 Is there a way to speed up this purging, e.g. deleting the...
-
Hello, JP, thank you for a fast response. I will indeed restart that particular logger with the provided traceflag and post any findings worth sharing. will these extra statements be logged in the logger's log file or echoed to the terminal ? I will also try to delete rows from xxx_TrendsCfg table and restart asemon_logger to see if this helps. as for the data dependency between mentioned tables , if StmtPlan, StmObj, StmtPlnHK and StmtSQLHK depend on StmtStat, then this does not make sense to me...
-
I see you had an error purging the OpObjAct. This purge is very basic : delete ?SERVERNAME?_OpObjAct where Timestamp < ?DATE? may be this table is corrupted. Check it
-
I didn't see you get error in the purge thread Do a delete of all rows in xxx_TrendsCfg table and restart asemon_logger Tell me if you still have error during next purge
-
Hi elovelo, these tables are never purged : AseParams SysMonFld2 TrendProc Trends TrendStmt WClassInf WEvInf They are not big tables and keeping this info is interesting Some tables keeps data if depending data still exists in other table (for exemple StmtPlan, StmObj, StmtPlnHK and StmtSQLHK depend on StmtStat) If you suspect any problem with the purge process , you can start asemon_logger with debug flag 113 (asemon_logger .... -d 113) and see all statements executed by purge thread Regards Jp...
-
Hello JPM, I am using Asemon v3.2.3 to monitor ASE instances in version 16.0 SP02 PL07 and 16.0 SP04 PL06 HF1. Both Asemon and ASE run on AIX 7.2 For all the instances some of the data for certain tables are kept way over the 'daysToKeep' parameter. For example, for one asemon logger, the 'daysToKeep' is set to 31 days, the 'deleteSleep' is set to default 100, but for all of the tables, the retention period has been crossed by a week now (38 days), and for some by six months already (since enabling...
-
Hello JPM, I am using Asemon v3.2.3 to monitor ASE instances in version 16.0 SP02 PL07 and 16.0 SP04 PL06 HF1. Both Asemon and ASE run on AIX 7.2 For all the instances some of the data for certain tables are kept way over the 'daysToKeep' parameter. For example, for one asemon logger, the 'daysToKeep' is set to 31 days, the 'deleteSleep' is set to default 100, but for all of the tables, the retention period has been crossed by a week now (38 days), and for some by six months already (since enabling...
-
Hello JPM, I am using Asemon v3.2.3 to monitor ASE instances in version 16.0 SP02 PL07 and 16.0 SP04 PL06 HF1. Both Asemon and ASE run on AIX 7.2 For all the instances some of the data for certain tables are kept way over the 'daysToKeep' parameter. For example, for one asemon logger, the 'daysToKeep' is set to 31 days, the 'deleteSleep' is set to default 100, but for all of the tables, the retention period has been crossed by a week now (38 days), and for some by six months already (since enabling...
-
-
Hello JPM, I am using Asemon v3.2.3 to monitor ASE instances in version 16.0 SP02 PL07 and 16.0 SP04 PL06 HF1. Both Asemon and ASE run on AIX 7.2 For all the instances some of the data for certain tables are kept way over the 'daysToKeep' parameter. For example, for one asemon logger, the 'daysToKeep' is set to 31 days, the 'deleteSleep' is set to default 100, but for all of the tables, the retention period has been crossed by a week now, and for some by six months already. See attached ss. I check...
-
Piers Collins posted a comment on discussion Help
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 Albin if you do not want install V16.1 for asemon repository, then, you can manually create the sysmon_xxx_PDO_V161 procs in the asemon database I think I remember that there are not a lot of differences with V16SP3 Regards JP
-
Albin Rosberg posted a comment on discussion Help
Hi Jean-Paul, Sorry for the delay. Yes, we have sysmon_xxx_PDO_V161 procs under asemon/asemon_logger_V3.2.5/proc/ at the server where asemon_logger installed. Our ASE used for asemon database however is version V16.04.06 version We do not have any issue to get a Sysmon Statistics for ASE V16.0. We can see:” Archive server ASE version : Adaptive Server Enterprise/16.0 SP04 PL06 HF1/EBF 31044 SMP/P/x86_64/SLES 12.4/ase160sp04pl06x/3636/64-bit/FBO/Thu Jun 27 20:17:29 2024 Procedures used : sp_sysmon_xxx_PDO_V16SP3”...
-
Hi Albin, new sysmon_xxx_PDO_V161 exist in asemon/proc Asemon_logger should have created then at startup. Do you have any trace ? Is your ASE used for your asemon database also at V16.1 version ? Else, you can create the sysmon_xxx_PDO_V161 procs manually but you may encounter problems since these procs are for V16.1 version Regards JPM
-
Hi We recently replaced the asemon report server to a V3.2.5. We have upgraded from asemon_logger_V3.1.9 to asemon_logger_V3.2.5 as well. At the same time we have upgraded the ASE instance from 16.0 SP4 PL06 to 16.1 SP00 PL00 (in-place upgrade) We have got some issue to get a Sysmon Statistics for ASE 16.1. It has given as error: Module: refresh_Sysmon_data with Message: Procedures: sp_sysmon_XXX_PDO_V161 missing in asemon database. It seems like we have missed something. Any insights?
-
cmesnil modified a comment on discussion Help
Hello Jean-Paul, This part : If selinux is activated : 1) authorize httpd to acces to Sybase files and asemon_report : chcon -t httpd_sys_rw_content_t /your_sybase_home_dir/ -R chcon -t httpd_sys_rw_content_t /var/www/html/asemon_report/ -R or (on RedHat 9) : (check SELinux alerts with : sealert -l "*" and apply recommended actions) For example : semanage fcontext -a -t httpd_sys_content_t "/your_asemon_report_dir/.*)?"` restorecon -R -v /your_asemon_report_dir 2) authorize httpd to use sockets :...
-
Hello Jean-Paul, This part : If selinux is activated : 1) authorize httpd to acces to Sybase files and asemon_report : chcon -t httpd_sys_rw_content_t /your_sybase_home_dir/ -R chcon -t httpd_sys_rw_content_t /var/www/html/asemon_report/ -R or (on RedHat 9) : (check SELinux alerts with : sealert -l "*" and apply recommended actions) For example : semanage fcontext -a -t httpd_sys_content_t "/your_asemon_report_dir/.*)?"` restorecon -R -v /your_asemon_report_dir 2) authorize httpd to use sockets :...
-
Hi Catherine ???? I don't understand your question JP
-
Hello Jean-Paul, Can you please explain how to configure (especially path to Sybase Client and asemon report) on Redhat9 when SE Linux is not enabled ? Best Regards, Catherine
-
Thank you very much, it solved the issue!
-
Hi, very strange try deleting all rows in ASE1_TrendsCfg Asemon will repopulate this table during the next purge with V3.2.5 data config Hope this will solve your pb Regards JP
-
Hi We just changed a couple of things in our setup. 1) we replaced the asemon report server to a new server and bcp:d over the old data 2) we changed the ASE instance name; e.g. MonitoredSrv.name from ASE1NEW to ASE1 3) we have upgraded from asemon_logger_V3.1.9 to asemon_logger_V3.2.5 when starting up, data is being sent correctly and things seem to be working; except purge which oddly enough still shows the old name somehow. Is there any data we have missed to update? 2025/07/29 14:36:25.124 Purge...
-
Hello Jean-Paul, The server name in the /etc/odbc.ini was incorrect. my bad ! Best Regards, Catherine
-
Hello Catherine I also had a lot of problems to setup odbc connection Did you configured your ODBC dSybase driver and DSN as specified in the Sybase doc ? To summaries, do for example : cd /home/sybase/SDK16SP04PL04/DataAccess64/ODBC/sample cp drivertemplate.txt mydrivertemplate.txt cat mydrivertemplate.txt : [Adaptive Server Enterprise] Description = Sybase ODBC Driver Driver = /home/sybase/SDK16SP04PL04/DataAccess64/ODBC/lib/libsybdrvodb.so FileUsage = -1 odbcinst -i -d -f mydrivertemplate.txt...
-
Hello Jean-Paul, Selinus is not enabled and odbc isql does not work either initiated by root... [08001][unixODBC][SAP][ASE ODBC Driver]Client unable to establish a connection [ISQL]ERROR: Could not SQLConnect Best Regards, Catherine
-
Hello Catherine did you allow httpd access to ports ? Example of commands I had to execute : ausearch -c 'httpd' --raw | audit2allow -M my-httpd semodule -i my-httpd.pp As root (not sybase), can you establish a connection with the "isql" included with the unixodbc package (in /usr/bin) ? Best regards JP
-
Hello Jean-Paul, At linux side it is not clear what they did with SElinux. But I now get this message. [08001][unixODBC][SAP][ASE ODBC Driver]Client unable to establish a connection [ISQL]ERROR: Could not SQLConnect Sybase isql connection works well. Best Reagards, Catherine
-
Hello Catherine is SE LInux active ??? I had this problem and had to grant SE rights to the Syb libraries and directories above Or it may be just a pb on rights on directories accessing the Syb libs (I also had that in the past) By the way : don't forget to add **"UseCursor=0" ** in your ODBC DSN, else your asemon_report grids will not be populated Hope this will help you setup asemon Best regards JP
-
Hello, While trying to install asemon report 3.2.5, I receive the following message when trying to connect to the archive server with Unix odbc (though the library exist): $ /usr/bin/isql ALT14011 sa XXXXXX -v [01000][unixODBC][Driver Manager]Can't open lib '/slucfrnxsgb9128/sybase/ASE161SP00PL00/DataAccess64/ODBC/lib/libsybdrvodb.so' : file not found [ISQL]ERROR: Could not SQLConnect $ ls -lah /slucfrnxsgb9128/sybase/ASE161SP00PL00/DataAccess64/ODBC/lib/libsybdrvodb.so -rwxrwxrwx. 1 sybase dba 3.6M...
-
Hello, While trying to install asemon report 3.2.5, I receive the following message when trying to connect to the archive server with Unix odbc (though the library exist): $ /usr/bin/isql ALT14011 sa rEj5_QbdwEaF -v [01000][unixODBC][Driver Manager]Can't open lib '/slucfrnxsgb9128/sybase/ASE161SP00PL00/DataAccess64/ODBC/lib/libsybdrvodb.so' : file not found [ISQL]ERROR: Could not SQLConnect $ ls -lah /slucfrnxsgb9128/sybase/ASE161SP00PL00/DataAccess64/ODBC/lib/libsybdrvodb.so -rwxrwxrwx. 1 sybase...
-
JHC posted a comment on discussion Help
awesome : many thanks !
-
Hi Jeremy, Apache has a "TimeOut" parameter set to 60 s by default. You can increase it. By default Asemon set the PHP "max_execution_time" param to 3600s by executing the : set_time_limit(3600); instruction. You can also increase the PHP param "post_max_size" It is set to 8 M by default. You can increase it to 32 M or 0 to disable the limit. Hope this will solve your problems Regards JP
-
Just wanted to confirm that i now have this working in podman container using php 8.4. Happy to share Dockerfile if this is of interest. Only thing i have noticed is that i sometimes get Gateway Timeout (EG when looking at 'Process' for a large range. I also get a '413 : request entity too large' error when trying to export a smaller sample of 'Process' to XLS . Are there any configuration parameters that i can change to try and get this working?
-
going to upgrade container to php 8 and will let you know how i get on :) Mamy thanks
-
Think you are right : just created new container and ran php in foreground [Wed Jul 9 14:48:31 2025] PHP Warning: odbc_exec(): SQL error: [FreeTDS][SQL Server]Invalid cursor state, SQL state 24000 in SQLExecDirect in /var/www/html/COMMON/connectArchiveServer.php on line 239 [Wed Jul 9 14:48:31 2025] PHP Warning: odbc_exec(): SQL error: [FreeTDS][SQL Server]Invalid cursor state, SQL state 24000 in SQLExecDirect in /var/www/html/COMMON/connectArchiveServer.php on line 239 [Wed Jul 9 14:48:31 2025]...
-
Sorry, UseCursor must be 0 !!! I did many tests in the past, and only 0 allow refresh of grids
-
How did you configure your ODBC DSN ? You must add : UseCursor=1
-
By the way, you should install PHP 8. I didn't test Asemon with PHP 7. Errors should appear in Apache log. Don't you have this file /var/log/httpd/error_log ?
-
I think the associated log is actually below and can see nothing of note Wed Jul 9 08:25:38 UTC 2025 ps -fe | grep php root 8 1 0 Jul08 ? 00:00:01 php-fpm: master process (/etc/php/7.4/fpm/php-fpm.conf) www-data 531 8 0 07:52 ? 00:00:00 php-fpm: pool www www-data 532 8 0 07:54 ? 00:00:00 php-fpm: pool www www-data 533 8 0 08:04 ? 00:00:00 php-fpm: pool www grep error_log /etc/php/7.4/fpm/php-fpm.conf error_log = /var/log/php7.4-fpm.log cat php7.4-fpm.log [08-Jul-2025 13:26:32] NOTICE: fpm is running,...
-
Hi Jeremy, can you check if you have any error message in Apache (/var/log/httpd/error_log) ? Regards JP
-
Hi I have installed ASEmon v3.2.5 and have collectors running against 2 ASEs. I can see that the tables have been created in the repository database and that MDA data is getting inserted. When i try to login via the Report, also v3.2.5 It connects and i can see the list of databases on the repository ASE. I can also see the 'ALLDBs' section populated. However, the registered servers are not listed in the dropdown box on the top bar, or visible in the 'Stat Servers' section. I am running the PHP report...
-
Hi Onkar I think it is due to some fields not reset to blank OR because there are two sections <SrvDescriptors>where ASEV15 is defined twice Find attached a corrected config file Regards JPM
-
Onkar posted a comment on discussion Help
I am in the stage of installing asemon_logger on sybase server. However I am getting below error while setting and starting asemon logger on solaris. Setting java_home doesn't working --> set JAVA_HOME=... %ASEMON_LOGGER_HOME%\asemon_logger..sh -c ''conf/your_config_file''.xml export JAVA_HOME=...$ASEMON_LOGGER_HOME/asemon_logger.sh -c "conf/BETAUAT1".xml -bash: export: `-c': not a valid identifier asemon_logger.sh -c BETAUAT1.conf throwing below error --> -bash-5.2$ asemon_logger.sh -c /syb16/asemon/asemon_logger_V3.2.5/conf/BETAUAT1.xml...
-
Hi, you have to manually drop corresponding tables in asemon database Regard Jpm
-
Anonymous created ticket #51
remove old servers from monitored list
-
Hi, can you run this displayed SQL manually under isql and see if you get more info I have never seen this type of error Regards JP
-
Hello JPM, I am running Asemon v 3.2.3 on ASE 16.0 SP02 PL07. Today MonSQL collector reported this kind 'null error' followed by an icomplete, but long query text: Any idea what is the cause ? Maybe the query was to long to fit into a column of one of the MonSQL tables ?
-
Hi Mark, Cnx contains info about connections. A connection is identifyed by its SPID, KPID and Loggedindatetime. It contains the UserName, program_name, DBName, ipaddr, ... It is captured only one time, just when asemon see it the first time CnxActiv contains activity for the connections : CPUTime, LogicalReads, PhysicalReads, ... Asemon checks activity of connections every 30 s (by default) and inserts a row in CnxActiv table only if the connection did some work during this interval of 30 s (so,...
-
Mark Bersales modified a comment on discussion Open Discussion
Hi, I would just like to ask what is the difference between the <server>__Cnx table and the <server>__CnxActiv table. Reason being is that i noticed that the <server>__Cnx table contains entries that are not in the <server>__CnxActiv for a specific Loggedindatetime range. What instance does this occur usually? Does that mean mean that the user was only able to connect but did not perform any transactions during the time interval? Could it also be that the process has already completed before the...
-
Hi, I would just like to ask what is the difference between the <server>__Cnx table and the <server>__CnxActiv table. Reason being is that i noticed that the <server>__Cnx table contains entries that are not in the <server>__CnxActiv for a specific Loggedindatetime range. What instance does this occur usually? Does that mean mean that the user was only able to connect but did not perform any transactions during the time interval?</server></server></server></server> Regards, Mark
-
asemon what is new
-
-
-
-
-
-
Hi this is classic, many sp_sysmon counters are still INT, not all are BIGINT, this is not a asemon problem I tested with V16SP02PL07 on a short interval and I have no problem You should reduce your interval Regards JP
-
Hello JP, I am running Asemon V3.2.3 that monitors ASE 16.0 SP02 PL07. If I access Sysmon's 'dcache_dtl' section I see this error ( see sysmon_dchace_dtl_overflow.png ) Can you advise where can this be corrected ? I suppose it's the proc 'sp_sysmon_dcache_dtl_V16' and from this output it looks like it failed to display maybe the 'Found in wash' figure ? In the procedure I find these variables: declare @tmpint bigint / temp var for integer storage / declare @tmpint2 int / temp var for integer storage...
-
Hello JP, I am running Asemon V3.2.3 that monitors ASE 16.0 SP02 PL07. If I access Sysmon's 'dcache_dtl' section I see this error ( see sysmon_dchace_dtl_overflow.png ) Can you advise where can this be corrected ? I suppose it's the proc 'sp_sysmon_dcache_dtl_V16' and from this output it looks like it failed to display maybe the 'Found in wash' figure ? In the procedure I find these variables: declare @tmpint bigint / temp var for integer storage / declare @tmpint2 int / temp var for integer storage...
-
Hello JP, I am running Asemon V3.2.3 that monitors ASE 16.0 SP02 PL07. If I access Sysmon's 'dcache_dtl' section I see this error: Can you advise where can this be corrected ? I suppose it's the proc 'sp_sysmon_dcache_dtl_V16' and from this output it looks like it failed to display maybe the 'Found in wash' figure ? In the procedure I find these variables: declare @tmpint bigint / temp var for integer storage / declare @tmpint2 int / temp var for integer storage / ~~~* Further down I find this: /...
-
Hi JP, yes that has fixed it. Great product and great support. Thanks Piers
-
Anonymous posted a comment on ticket #33
Hi Piers, since the bad value is negative the case should be : PgRead=sum(convert(numeric(16,0),case when PagesRead<0 then 0 when PagesRead > 2000000000 then 0 else PagesRead end)), and I think I should raise the filter for LogicalReads to 2 000 000 000 000 since theis Sybase counter is a BIGINT and it can really value more than 2 billion during a sampling of this column over 30s (the default sapling period for this collector) Anyway, in a first time add the filter on PgRead col and tell me if it...
-
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...
-
install asemon_report on Linux with PHP8
-
asemon what is new
-
-
-
-
-
-
-
Hello JP, thank you very much. This new schema solved the problem. I don't see any new numeric overflow errors pertaining to this table now.
-
Good, thank you et bonnes fêtes
-
Simon Thackeray posted a comment on ticket #50
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!
-
May be it's because you didn't run the "installmaster" script when you migrated to SP03 (you should run "updatease" after patching ASE) You can check by executing "sp_version" on this SP03 server You should get "installmaster 16.0 SP03 PL03 ..." Regards JPM
-
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?
-
Hi Simon what do you have in your config file ? For StmtCache : you should have StmtCcahe_switch.xml whil will redirect to StmtCache_V16SP03.xml For MonSQL : MonSQL_switch.xml redirects to MonSQL_V16SP03.xml You should take a look at sampleConfig.xml who shows which collector should be used Best regards JPM
-
Invalid column name 'QueryOptimizationTime' and 'NumAQTs'
-
Hi, in DataCache_V16SP02.xml collector can you replace the table definition by this : create table ?SERVERNAME?_DataCache ( Timestamp datetime not null, Interval int not null, CacheName varchar(30) null, CacheSearches bigint null, PhysicalReads int null, LogicalReads bigint null, PhysicalWrites int null, Stalls int null, CacheID int null, RelaxedReplacement bigint null, BufferPools bigint null, APFReads bigint null, CachePartitions int null, CacheSize bigint null, Overhead int null, CASGrabs bigint...
-
Hello Jean-Paul, I run Asemon 3.2.3. on ASE 16.0 SP02 PL07. The logger log showed this error: <server>_DataCache - Error in loop on table '<server>_DataCache' on connection : 'ARCH'. Error=0 state=JZ00B. SQL message=JZ00B: Numeric over flow. asemon_logger.AsemonSQLException: JZ00B: Numeric overflow. at asemon_logger.Archive_ASE.saveValues(Archive_ASE.java:373) at asemon_logger.CollectorGeneric.saveValues(CollectorGeneric.java:475) at asemon_logger.CollectorGeneric.getMetrics(CollectorGeneric.java:276)...
-
Hello Jean-Paul, I run Asemon 3.2.2. on ASE 16.0 SP02 PL07. The logger log showed this error: <server>_DataCache - Error in loop on table '<server>_DataCache' on connection : 'ARCH'. Error=0 state=JZ00B. SQL message=JZ00B: Numeric over flow. asemon_logger.AsemonSQLException: JZ00B: Numeric overflow. at asemon_logger.Archive_ASE.saveValues(Archive_ASE.java:373) at asemon_logger.CollectorGeneric.saveValues(CollectorGeneric.java:475) at asemon_logger.CollectorGeneric.getMetrics(CollectorGeneric.java:276)...
-
Hello Jean-Paul, I run Asemon 3.2.2. on ASE 16.0 SP02 PL07. The logger log showed this error: <server>_DataCache - Error in loop on table '<server>_DataCache' on connection : 'ARCH'. Error=0 state=JZ00B. SQL message=JZ00B: Numeric over flow. asemon_logger.AsemonSQLException: JZ00B: Numeric overflow. at asemon_logger.Archive_ASE.saveValues(Archive_ASE.java:373) at asemon_logger.CollectorGeneric.saveValues(CollectorGeneric.java:475) at asemon_logger.CollectorGeneric.getMetrics(CollectorGeneric.java:276)...
-
Hello Jean-Paul, I run Asemon 3.2.2. on ASE 16.0 SP02 PL07. The logger log showed this error: <server>_DataCache - Error in loop on table '<server>_DataCache' on connection : 'ARCH'. Error=0 state=JZ00B. SQL message=JZ00B: Numeric over flow. asemon_logger.AsemonSQLException: JZ00B: Numeric overflow. at asemon_logger.Archive_ASE.saveValues(Archive_ASE.java:373) at asemon_logger.CollectorGeneric.saveValues(CollectorGeneric.java:475) at asemon_logger.CollectorGeneric.getMetrics(CollectorGeneric.java:276)...
-
Hello Jean-Paul, I run Asemon 3.2.2. on ASE 16.0 SP02 PL07. The logger log showed this error: <server>_DataCache - Error in loop on table '<server>_DataCache' on connection : 'ARCH'. Error=0 state=JZ00B. SQL message=JZ00B: Numeric over flow. asemon_logger.AsemonSQLException: JZ00B: Numeric overflow. at asemon_logger.Archive_ASE.saveValues(Archive_ASE.java:373) at asemon_logger.CollectorGeneric.saveValues(CollectorGeneric.java:475) at asemon_logger.CollectorGeneric.getMetrics(CollectorGeneric.java:276)...
-
Hello Jean-Paul, I run Asemon 3.2.2. on ASE 16.0 SP02 PL07. The logger log showed this error: <server>_DataCache - Error in loop on table '<server>_DataCache' on connection : 'ARCH'. Error=0 state=JZ00B. SQL message=JZ00B: Numeric over flow. asemon_logger.AsemonSQLException: JZ00B: Numeric overflow. at asemon_logger.Archive_ASE.saveValues(Archive_ASE.java:373) at asemon_logger.CollectorGeneric.saveValues(CollectorGeneric.java:475) at asemon_logger.CollectorGeneric.getMetrics(CollectorGeneric.java:276)...
-
Hello Jean-Paul, I run Asemon 3.2.2. on ASE 16.0 SP02 PL07. The logger log showed this error: <server>_DataCache - Error in loop on table '<server>_DataCache' on connection : 'ARCH'. Error=0 state=JZ00B. SQL message=JZ00B: Numeric over flow. asemon_logger.AsemonSQLException: JZ00B: Numeric overflow. at asemon_logger.Archive_ASE.saveValues(Archive_ASE.java:373) at asemon_logger.CollectorGeneric.saveValues(CollectorGeneric.java:475) at asemon_logger.CollectorGeneric.getMetrics(CollectorGeneric.java:276)...
-
Hello Jean-Paul, I run Asemon 3.2.2. on ASE 16.0 SP02 PL07. The logger log showed this error: <server>_DataCache - Error in loop on table '<server>_DataCache' on connection : 'ARCH'. Error=0 state=JZ00B. SQL message=JZ00B: Numeric over flow. asemon_logger.AsemonSQLException: JZ00B: Numeric overflow. at asemon_logger.Archive_ASE.saveValues(Archive_ASE.java:373) at asemon_logger.CollectorGeneric.saveValues(CollectorGeneric.java:475) at asemon_logger.CollectorGeneric.getMetrics(CollectorGeneric.java:276)...
