"Execute a SmartObject (stored procedure) method (List)" on the View executes stored procedure twice
kbt138513
PRODUCTIssue
"Execute a SmartObject (stored procedure) method (List)" rule on the View, executes the stored procedure twice.
This could lead to slowness if the method is used for basic data selection; or to duplicate rows being inserted into the table if it is being used for adding rows with data.
Symptoms
SQL server service instance based SmartObjects for Stored Procedures default List method is being executed twice when called from SmartForms after the upgrade to 4.7. This happens only if the RowCount setting in runtime web.config is enabled.
Applying August CU + FP14 does not solve this. The same SmartObject method called from the SmartObjects Services Tester Tool executes the stored procedure only once, i.e. issue occurs only when the method is called from form/view and only when RowCount option is enabled (more details about this setting can be found K2 Five Developers Reference).
In 4.6.11 there was no such behavior. This introduces issues when duplicate rows are being inserted when the stored procedure is used to add rows. It may also cause general slowness when simple List methods is used from forms - double execution delay becomes very noticeable for large data sets and complex filters.