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

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