Smartobject method

does anyone have answer to this??

Your SmartObject should work just like any other SmartObject.  What service is it connecting to?

What Jonny has responding is absolutly right, if you have Stor proc that uses input parameter and column return param from Select statment are same, service broker will not work. I think, this case it's unable to fetch the information from DB and failing. 

Create the service instance through K2 workspace, you come to know where it was failing, do not use the Broker management.exe for createing the instance.

Hope you understand.

The reason is that in the code that adds the parameters, we first loop through all the SP params and add them as input params for the service method.  The second portion then does a DescribeSchema call to get the column information.  There is a loop that adds each column as a output param for the service method.

Now the problem is that if the same param name is the same, you will get a key error as the code tries to add a param with the same key (i.e. the name).  The correct thing would be to add the param and indicate that the direction is in/out.

As the broker was done pretty quickly (it was coded, tested and debugged in about 4-5 days if I recall correctly), so I guess we didn't take this into consideration.  i.e. populate the params and column names into an array before adding them.

If you have time, you are welcome to modify the code and get this working properly or you could wait for the final supported versions in the upcoming 090x release.