Thanks Nathan and Coby
I have 2 ignition licenses also, but currently we dont plan to upgrade from FactorySQL to ignition. So am I to udnerstand that my stored procedure groups which do not have any SQL Action items will not be cached even after some time, if the database is down? cause when i tested with a sotred procedure, yes there was dataloss in between but stored procedure executions were cached and wirtten to database later on.
Since stored procedure groups aren’t buffered before execution in either products, I will have to work around it somehow. One method could be to write stored procedure parameter values to a table with a “unexecuted flag” and then read that table and execute procedures with the corresponding parameter values. Anyway, just kindly clarify the behaviour of the Stored Procedure Group in FactorySQL with regards to database downtime.
Thanks