#52 <servername>_MonSQL - Error in loop. java.lang.NullPointerException

[cmesnil]

Hello,

In an asemon report version 3.2.5, at some times, I have the following errors:

2026/02/24 01:42:29.753 ALP13005_MonSQL - MonSQL BootID = 1000032 time_of_last_stmt_seen = 2026/02/24 01:41:58.883
2026/02/24 01:45:50.554 ALP13005_MonSQL - Error in loop. java.lang.NullPointerException: while trying to invoke the method java.lang.String.length() of a null object returned from asemon_logger.CollectorMonSQL$RowOfSqlText.access$700(asemon_logger.CollectorMonSQL$RowOfSqlText)
java.lang.NullPointerException: while trying to invoke the method java.lang.String.length() of a null object returned from asemon_logger.CollectorMonSQL$RowOfSqlText.access$700(asemon_logger.CollectorMonSQL$RowOfSqlText)
at asemon_logger.CollectorMonSQL$RunningStmt.saveStmtSQL(CollectorMonSQL.java:1214)
at asemon_logger.CollectorMonSQL$RunningStmt.access$4100(CollectorMonSQL.java:374)
at asemon_logger.CollectorMonSQL.getMetrics(CollectorMonSQL.java:2011)
at asemon_logger.Collector.run(Collector.java:380)
2026/02/24 01:45:55.669 ALP13005_MonSQL - MonSQL BootID = 1000032 time_of_last_stmt_seen = 2026/02/24 01:45:18.400
Can you please advise ?

Best regards,
Catherine

[Jean-Paul Martin]

Salut Catherine,

I changed a lot of things in this collector since V3.2.5
It seems the SQL you are retreiving is NULL
It seems also you activated debug trace 104 (the line 1214 in this asemon version is a debug line)

Test with a more recent version (last one in V3.2.6b)

Sorry, cannot help more
Regards
Jean Paul