When using Appian to create database tables in SQL Server, sometimes the primary

John Stretton over 10 years ago

When using Appian to create database tables in SQL Server, sometimes the primary key field a_id is of type int, but other times it is of type numeric(19,0).

There are three data types in the attached zip file. OKS_NewsEntry and OKS_Platform have a_id fields of type int, but for OKS_Component Appian creates an a_id field of type numeric(19,0) in the database instead of type int as I would expect. Does anyone have any idea why this is happening?

OKS_data types.zip

Discussion posts and replies are publicly visible

0 John Stretton over 10 years ago

Problem solved. Despite checking several times, somehow my data store entity for OKS_Component did not reflect the latest version of the CDT. Dropped the tables, updated the data store entity, and all primary keys are now of type int.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel