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.
Solved
Stored Procedure not show in SmartObject Service Tester
+6Best answer by Kran
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".
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.
+9Hi 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".
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.