Symptoms
I have a service object that is not showing a column in a SQL table. The column not showing has a data type of timestamp. The service object was first created when refreshing the SQL instance using a 4.6.7 smartobject tester connected to a 4.6.9 dev server. I have had the table dropped an recreated, but the column does not show up when refreshing the SQL instance in the smart object tester.
Diagnoses
The issue is related to the column types in the DB.
Resolution
http://help.k2.com/onlinehelp/k2blackpearl/userguide/4.6.9/webframe.html_ws_sql_01.html
According to the above link, the following SQL Data Types are also currently not supported:
- TimeStamp
- Image
- SQL_Variant
- Binary
- VarBinary
- Numeric (Use Decimal)