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

John Stretton over 9 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

Parents

0 John Stretton over 9 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

Reply

0 John Stretton over 9 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

Children

No Data