The special character '�' was observed with an error when using the metrics.

[janithcmw]

Description: An error is thrown when using metrics because of a NaN value.Following error was observed with the subjected special character when using the metrics.

ERROR {org.wso2.carbon.metrics.jdbc.reporter.JdbcReporter} - Error when reporting timers java.sql.SQLException: '�' is not a valid numeric or approximate numeric value at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:85) at com.mysql.cj.jdbc.ClientPreparedStatement.setDouble(ClientPreparedStatement.java:1593) at com.zaxxer.hikari.proxy.HikariPreparedStatementProxy.setDouble(HikariPreparedStatementProxy.java) at org.wso2.carbon.metrics.jdbc.reporter.JdbcReporter.reportTimer(JdbcReporter.java:415) at org.wso2.carbon.metrics.jdbc.reporter.JdbcReporter.reportTimers(JdbcReporter.java:389) at org.wso2.carbon.metrics.jdbc.reporter.JdbcReporter.report(JdbcReporter.java:199) at com.codahale.metrics.ScheduledReporter.report(ScheduledReporter.java:235) at com.codahale.metrics.ScheduledReporter$1.run(ScheduledReporter.java:174) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: com.mysql.cj.exceptions.WrongArgumentException: '�' is not a valid numeric or approximate numeric value at sun.reflect.GeneratedConstructorAccessor106.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85) at com.mysql.cj.ClientPreparedQueryBindings.setDouble(ClientPreparedQueryBindings.java:427) at com.mysql.cj.jdbc.ClientPreparedStatement.setDouble(ClientPreparedStatement.java:1591) ... 13 more

Affected Product Version: WSO2SP-4.4.0