Easy Chart not connecting to Database

Ignition
1

I have created an Easy Chart in Vision and dropped a History tag onto the chart.
The chart works fine in designer, however when I run the vision project, chart is shaded red with DB fault indication in top left corner.

  • Legacy DB Connection is enabled for the vision client
  • MySQL database is connection is "valid" with 0.9 queries/s
  • Tag is History Enabled and quality is good

Any points to investigate would be very appreciated!

2

Look in the diagnostics console in the client (via the help menu). It might show errors with clues.

3

Thanks for that pturmel! I have only been using Perspective so far (Maker Edition) so i didnt know about the diag console...

On: sensors.Root Container.Easy Chart
	at com.inductiveautomation.factorypmi.application.gateway.QueryManager$QueryExecutor.run(QueryManager.java:311)
	at java.base/java.lang.Thread.run(Unknown Source)
Caused by: com.inductiveautomation.ignition.client.gateway_interface.GatewayException: Error executing function 'QueryTagDensity': The current user does not have the required roles for this operation.

Ill dig deeper into the client permissions tonight.

4

It's probably the new Tag History client permission:
https://docs.inductiveautomation.com/display/DOC81/New+in+this+Version#NewinthisVersion-Vision.1
https://docs.inductiveautomation.com/display/DOC81/Vision+Project+Properties#VisionProjectProperties-VisionPermissionsProperties

1 Like
5

That was exactly the issue..
Thanks @PGriffith :ok_hand:

I ended up enabling all permissions which worked, then deselecting one-by-one to find it. I should have just read the label..