MSSQL 2014 monitoring breaks

[Andre Nobre]

Hi there,

I migrated my database from MSSQL 2012 to MSSQL 2014, and a Zabbix graph based on a SQL query stopped working with the following error.

Is this a known problem? Can anyone suggest a solution?

Zabbix Item:
Total Users Online mssql.wgmonline


Agent Config

Server=######

ServerActive=######

Hostname=######

UserParameter=mssql.wgmonline,sqlcmd -h -1 -U ###### -P ###### -d ###### -Q "select count(distinct(profileid)) from sessions"


Error:

Received value [43371(1 rows affected)] is not suitable for value type [Numeric (float)]

PS: Zabbix version is 2.4.7.

Thanks

[Atsushi]

Message "(1 rows affected)" is unnecessary.
It would had been determined not to be a numeric value because the it contains this query results.

If you can run the SQL of multiple lines by script file,
it might be good when you run the following line first.

SET NOCOUNT ON

[Andre Nobre]

:d

Many thanks Atsushi! Your suggestion solve my problem.