#51 Numeric overflow in MonSQL

[Anonymous]

Hi JPM!

We've got a numeric overflow in collector MonSQL:

2021/02/18 13:09:12.852 <instance>_MonSQL    - Error in loop. Error=0 state=JZ00B SQL message=JZ00B: Numeric overflow.
java.sql.SQLException: JZ00B: Numeric overflow.
        at com.sybase.jdbc4.jdbc.ErrorMessage.raiseError(ErrorMessage.java:832)
        at com.sybase.jdbc4.jdbc.Convert.checkIntOflo(Convert.java:1820)
        at com.sybase.jdbc4.tds.TdsInt.getInt(TdsInt.java:106)
        at com.sybase.jdbc4.jdbc.SybResultSet.getInt(SybResultSet.java:482)
        at asemon_logger.CollectorMonSQL.getMetrics(CollectorMonSQL.java:1797)
        at asemon_logger.Collector.run(Collector.java:380)

The documented restriction for MonSQL_V157.xml is not applicable. There are no error messages in the ASE errorlog. ASE is version 16 SP03 PL08 HF2, Asemon_logger is the most current 3.1.7.

Thank you very much in advance!

Best regards,
Kai

[Jean-Paul Martin]

Hi Kai,
thank you I didn't see this bug
Overflow is on retreiving PhysicalReads from monSysStatement
I fixed it in V3.1.7a
You can donwload this new version
Best regards
Jpm

[Anonymous]

Salut Jean-Paul,

thank you very much for your prompt reply and the fix!