No Properties Under SQL Stored Procedure ServiceObject

  • 15 February 2022
  • 0 replies
  • 9 views

Userlevel 5
Badge +20
 

No Properties Under SQL Stored Procedure ServiceObject

kbt141880

PRODUCT
K2 Five
K2 blackpearl
TAGS
K2 SmartObject Integration
Service Broker
SmartObjects
This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice. This article is not considered official documentation for K2 software and is provided "as is" with no warranties.

Issue

There are no properties are listed under a SQL Stored Procedure ServiceObject.

Symptoms

The stored procedure references a table from a different SQL server instance. On Different SQL Server and Use Native SQL Execution are both set to true on the SQL Service Instance.

Troubleshooting Steps

If On Different SQL Server and Use Native SQL Execution are set to true, the sp_addlinkedserver must be executed by the K2 service account. Kindly refer to the documentation for more details.

0 replies

Be the first to reply!

Reply