Error when executing List method on a SQL Service SmartObject

  • 24 February 2022
  • 0 replies
  • 56 views

Userlevel 5
Badge +20
 

Error when executing a List method on a SQL Service SmartObject

kbt141383

PRODUCT
K2 blackpearl 4.7
BASED ON
K2 blackpearl 4.7
TAGS
K2 SmartObject Integration
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.
LEGACY/ARCHIVED CONTENT
This article has been archived, and/or refers to legacy products, components or features. The content in this article is offered "as is" and will no longer be updated. Archived content is provided for reference purposes only. This content does not infer that the product, component or feature is supported, or that the product, component or feature will continue to function as described herein.

Issue

The error below appears when executing a List method of a SQL Service SmartObject.

The OLE DB provider "SQLNCLI11" for linked server "[SERVER]" does not contain the table "[TABLE]". The table either does not exist or the current user does not have permissions on that table.

 

Symptoms

All other methods (eg. Create, Save, Delete) are able to be executed except for the List method.

Troubleshooting Steps

To resolve this issue, please complete the following from either of these components:
 
 
From the K2 Management Site:
      1. Go to Integration > Service Instances
      2. Select the service instance
      3. Click on Edit
      4. Under Service Keys, set Use Native SQL Execution to false
      5. Click on OK to update the service instance
 
 
From the SmartObject Service Tester:
      1. Go to ServiceObject Explorer > SQL Server Service > [Service Instance]
      2. Right-click on the service instance
      3. Select Edit Service Instance
      4. Set Use Native SQL Execution to false
      5. Click on Next to update the service instance

0 replies

Be the first to reply!

Reply