No ratings

SmartObject contains a Property with the same name




Symptoms



When trying to create new SmartObject from a SQL Stored Procedure in K2 blackpearl 4.6.7 and 4.6.8 the following error message appears: [Stored_Procedure_Name] contains a Property with the same name 'Column_name'. 


 


3541i982D82DD6DBDD28A.png



Diagnoses


 


The Stored Procedure looks like a simple IF/ELSE statement that outputs either all or some columns:


3542i48FB30137260DEEA.png


 


This happens when a duplicate property is created. Then the property name does not get differentiated by implementing an incremental value. In other words IF and ELSE statements SELECT the same columns.


 


Resolution

There is no fix for that, but currently the item is being worked on for 4.7.0. With that being said there are two workarounds. One being inserting the data into a table variable and querying the table variable:


 


3544iC2FD4B72C6E0743C.png


 


Another one is inserting extra code underneath the AS keyword after variables are declared as shown below:


3545i4629E8BD2FF77473.png


 




Labels: (1)
Version history
Last update:
‎08-26-2021 04:59 PM
Updated by:
Contributors