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

When creating an SQL Service Instance based on a SQL database, with a table containing a column of type datetimeoffset(7), the column is not returned in the Service Instance properties.

Symptoms

The column of type datetimeoffset(7) is not returned in the SQL Server Service Instance properties.

Looking at the example below, you will notice that only id column is returned.

Image

Resolution

This is resolved in the K2 Five RTM FixPack 10 which can be obtained from K2 support.