Solved

Stored Procedure not show in SmartObject Service Tester

  • 27 January 2017
  • 2 replies
  • 29 views
F
Badge +6

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.

icon

Best answer by Kran 27 January 2017, 07:06

View original

2 replies

S
Userlevel 1
Badge +8
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.
K
Badge +9

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


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings