default Identity column to read only

Matthew Woolnough 12 years ago updated by anonymous 9 years ago 3

When creating SQL connector: If there is an IDENTITY column in schema and 'IDENTITY_INSERT' is set to 'OFF' (not sure if it is possible to query table for current IDENTITY_INSERT config), create the attribute as read only.

When it is not read only, the error below is reported.

Cannot insert explicit value for identity column in table 'FIMEmployee' when IDENTITY_INSERT is set to OFF.

I agree with this, and as you mentioned not sure if it's possible to find out this information, but definitely worth looking at for 4.0.2.


The has been fixed and will be available in the next release.

Confirmed or migrated to VSO.