Problem in InfluxDB query with DPE of String type

[aserov]

Hello Colleagues!

The problem appears when DPE (used in dpQuery against InfluxDB) is of String type.
dpQuery approximately in ~20% cases throws the following error:
WCCOAnextgenarch118:Assertion failed: IsObject(), file C:\work\WinCCOA\ExternLibs\rapidjson-1.1.0\rapidjson/document.h, line 1336

In ~80% cases it runs absolutely correct on absolutely the same data.

The query itself if very simple:
SELECT '_online.._value','_online.._stime' FROM 'Log1.text'

The string values (stored in Log1.text DPE) are short in size and very primitive.

Attached is a panel with a simple example.

Could you, please, advise what can be a reason of that unstable behaviour?

OS: Windows 10 Pro 21H1
WinCC OA: 3.18.003

Kind Regards,
Andrey Serov

[leoknipp]

The query string you have posted does not contain a TIMERANGE condition. Therefore, this query is answered by the Event Manager and not by the NGA manager.
Are you sure that this query causes the log message written by the NGA manager?

Best Regards
Leopold Knipp
Senior Support Specialist

[aserov]

I forgot to show TIMERANGE in a query.
This query causes errors:
"SELECT '_online.._value','_online.._stime' FROM 'Log1.text' TIMERANGE(\""+(string)testDateStart+"\",\""+(string)testDateEnd+"\",1,0)";

Kind Regards,
Andrey Serov

[leoknipp]

I have made a simple test with a query to read data for "string" elements from the database.
The query was executed more than 400 times without any error.

Can you reproduce this problem in every project using NGA + Influx?

Best Regards
Leopold Knipp
Senior Support Specialist

[aserov]

Hello Leopold,

The problem is gone after having uninstalled the ESET NOD32 antivirus software (version 14.2.24.0).
Thank you very much,

Kind Regards,
Andrey Serov