SqlCommand.Prepare method requires all parameters to have an explicitly set type

IbaPDA SQL Server data store

Error:

SqlCommand.Prepare method requires all parameters to have an explicitly set type

Indicating the insert in the sql table is unsuccessful.

Logging shows connection lost every second -> not connected to the setting of timebase or write every x samples (in database configuration)

0 kB/s written to db

No relevant indication in logging or event log. 

During apply, the table has errors, no sure which. During check columns, all is good, except for some unused columns. ibaPDA give the suggestion to drop them, but we can ignore. This is not relevant. 

Solution:

In the data store configuration > signal selection > a certain signal was disabled. After this the db write continued and connection was restored. 

It’s not clear what the reason is this signal causes issues. Could be because it was a calculation that did not have a value (empty = null). In SQL null values were set to allowed. Unsure whether this issue is related to the empty value, or the calculation method (if the denominator is 0 > but in this case we expect ibaPDA to error during apply) > to check internally

In case of dividing by 0, no sample is returned. Unclear if this is the case or the signal value is null. For DB writes, a replacer could be used to check whether the signal has a value or not and write the If function to the DB.