Skip to main content

Hi all,

 

I created a stored procedure. However, it was not shown in SmartObject Service Tester.

 

I need to publish it as a SmartObject to be use in my application.

 

Not sure what is going wrong here.

 

Kindly please advice.

 

Thank you.

Are you using temp tables in your query? The stored procedure has to be discoverable. This also means that the k2 service account has the necessary rights to both discover and execute the stores procedure.

Hi Foo_yk,

 

            Make Sure for your DataBase Service Instance is registred, if not then Create it.

 

Also note that  after adding any table or Stored procedure you need to refresh ServiceInstance for Database which will be available under Service Object Explorer in Smartobject Tester.

 

Same Can be done by Right Click on  Service Instance and click on "Refresh Service Type".

 

 

 

 

 

 


Reply