[bug-16729]Equipment Schedule MSSQL binding error

Ignition
, ,
1

Ignition 8.0.9
MSSQL Express

Hi All

I have 4 SQL tables which are read by an Equipment Schedule component. Eventually, these tables will be populated by our ERP/MES system. The tables are bound to “Items”, “Scheduled Events”, “Downtime Events” and “Break Events”.

The binding for “Scheduled Events” causes a null pointer error.

I have checked the structure of the SQL table and it appears to be OK. The correct data is shown in the datatable (within ignition). I have copied this to another Equipment Schedule control (without the binding) and it worked perfectly. I have tried with, and without an index column in the SQL structure.

Please see attached for images.

Please can someone explain what I have done wrong?

SQL table structure

SQL data
SQL data1920×1200 193 KB

Query binding
Query binding786×593 37.5 KB

diagnostics
Error1 Error2
Error3
Error31201×781 117 KB

Datatable
Datatable1113×639 55.4 KB

Thanks

2

Further to this - If I add the erroneous SQL query binding to another Equipment Schedule control, without any other bindings my CPU usage goes very high and locks up the Ignition Designer forcing me to shut it down with task manager.

3

pctDone is expected to be a numeric value, and cannot be null. Set a default value for the column, or coerce it in the query.

EDIT: The same applies to leadTime.

1 Like
4

Great. Thank you!