< class="prominent-subhead ">

SQL Server Service: - SQL table with a dot in the name only shows List method

~~repeating-content.html~~
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

When create a SQL Server Service Instance SmartObject from a table in SQL with a dot in the name, the SmartObject only has a List method available.

Symptoms

Example: The SmartObject based off a table with the name [dbo].[My.Test.Table] will only expose the List method.

Image

Resolution

To resolve this issue, complete the following steps:

 

  1. Rename the Table in SQL and use underscore instead of dots in the table names. ([dbo].[ My_Test_Table] for the example above)
  2. Using the SmartObject Services Tester Tool, refresh the SQL Server Service Instance.
  3. Recreate the SmartObject

Should the old SmartObject already be used as part of a project, the SmartObject will need to be published with the same GUID to retain the functionality and only expose the additional Methods.