Comment by Olivier Suc, PMP on "Query and Visualise AVEVA Historian on Grafana Dashboard"

CommentQuery and Visualise AVEVA Historian on Grafana Dashboard

Olivier Suc, PMP

Apr 29, 2022

Bill, great tutorial. I've managed to get the trend to work but I'm having an issue with the taglist. I get an error after copying your code verbatim (upper right hand corner copy option). I'm using Wonderware 2014 R2 SP1 P2 and Grafana 8.4.5 i'm getting "db query error: mssql: Incorrect syntax near ')'. "

Bill Liu

Industry 4.0, IIoT

Apr 30, 2022

Hi Olivier, thanks for your comment. I would find the exact query that Grafana sends to MSSQL. You can either do it in Grafana using the "Query Inspector", or get the query history from MSSQL server. This might be an issue with Grafana templating.

Bill Liu DECLARE @TSQL varchar(8000), @DATE_FROM char(19), @DATE_TO char(19)

SELECT @DATE_FROM = REPLACE('2022-04-28T01:07:35Z', 'T', ' ') SELECT @DATE_TO = REPLACE('2022-04-30T01:07:35Z', 'T', ' ') SELECT @TSQL = ' SELECT DateTime AS time, K12-1STAT.CPV,K12-2STAT.CPV,K12-3STAT.CPV,K12-4STAT.CPV,K12-5STAT.CPV,K12-6STAT.CPV FROM OPENQUERY( INSQL, '' SELECT DateTime, K12-1STAT.CPV,K12-2STAT.CPV,K12-3STAT.CPV,K12-4STAT.CPV,K12-5STAT.CPV,K12-6STAT.CPV FROM Runtime.dbo.WideHistory WHERE wwResolution = 120000 AND wwRetrievalMode = "Average" AND DateTime >= ''''' + @DATE_FROM + ''''' AND DateTime <= ''''' + @DATE_TO + ''''' AND wwTimeZone = ''''UTC'''' ORDER BY DateTime ASC '') ' EXEC (@TSQL)

error: " db query error: mssql: Incorrect syntax near '.'. "

I dont see the '.'. anywhere

Search Hashnode