Easy Chart: error reading Database Pen

General Discussion
1

Hi,
I’d like to plot data from a SQL Server database table in an Easy Chart. I use a Database Pen for that.
The table is in a schema of its own named logs. The pen editor can see the table and the Run diagnostics validates my pen configuration correctly:


But as soon as the Easy Chart component gets running, I get the following error:

db_pen_error.jpg1076×325 87.5 KB


It seems that Ignition forgets that my table is not in the dbo default schema, hence the wrong query SELECT … FROM tbl_AuxHistory instead of FROM logs.tbl_AuxHistory .
Any suggestions, other then transfering the table in the default schema?

Thank you in advance,
regards

2

Have you tried adding the ‘logs.’ in the table name field without using the drop-down?