[bug-16729]Equipment Schedule MSSQL binding error

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

Error1 Error2


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.

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

Great. Thank you!