Symptoms

When exposing Stored Procedure with following If Else Condition into SmartObject:-
IF
BEGIN
Select X, Y, Z from Table
END
Else
Begin
Select X, Y, Z From Table
End

It will throw the error that Duplicate properties are found although there is only one set of dataset returned from Query.

 

Diagnoses

Workaround:-
1) Comment out the if else statement,
2) Refresh SQL broker
3) Expose the stored procedure as SmartObject
4) Uncomment back the if else statement
 

Resolution

Logged as issue to be fixed.