Sybase Agent Logs report too many JZ0R2 error codes while executing the below Foglight store procedures
sp_fgl_index
sp_fgl_datacachesummary
sp_fgl_diskiosummary
sp_fgl_longruntrans
sp_fgl_enginesummary1
sp_fgl_networkiosummary
sp_fgl_userslogcache
sp_fgl_procedurecache
sp_fgl_parallelquery
ERROR [Sybase_TIMES-lowPriorityPool-1-[LongRunningTrans][xxxx/xx/xx xx:xx:xx]] com.quest.qsi.fason.core.collection.processor.InstanceProcessor - Failed to run LongRunningTransProcessor processor of LongRunningTrans collection. java.lang.RuntimeException: Failed to execute collection [LongRunningTrans], reason=com.quest.qsi.fason.framework.connections.common.exceptions.FrameworkQueryException: JZ0R2: 该查询无结果集。-
JZ0R2 error code is returned by the monitored database when there is no data returned after the query execution. When the database language is set to Chinese, the Foglight Sybase agent cannot match the message in the exception and it could not translate it into the expected warning message.
If the language of the monitored database is English, then the Sybase agent can catch this exception and translate it to a warning message in the agent log as below:
WARN [SAP_ASE_v_16-lowPriorityPool-1-[SybaseServerStatus][xxxx/xx/xx xx:xx:xx]] com.quest.qsi.fason.core.collection.processor.AbstractQueryProcessor - No data was obtained from the query of CheckNumberOfConnectionsProcessor processor of SybaseServerStatus collection.
