Hi,
We recently updated one of our selfmade protocols and it broke a low-code app. The table started showing the message "Error trapped: Unable to cast object of type 'System.Double' to type 'System.String'."
I'm trying to re-create the query for the table but when selecting which columns from the table to use in the low-code app it only shows the old (pre-update) columns so it seems the low-code app is stuck using the old version of the protocol? My guess is that since we added columns in the middle of the table, the low-code app is looking at a column index which no longer contains the data type that it expects.
Hi Robin,
For performance reasons, GQI caches the protocols in the DMS. If you change a protocol, you should restart SLHelper to rebuild this cache. You can find more info here. Does this fix your issue?
PS. GQI does not use the index of the columns for identification, but uses a unique key.
Hi Miguel,
Each SLHelper process has its own version of the cache. You will have to restart all SLHelpers that were running at the time of the update.
Hi Wout,
If we have a cluster with multiple DMAs and each node is running SLHelper, is it possible to know which SLHelper should be restarted?