StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Cannot insert explicit value for identity column

Cannot insert explicit value for identity column

Buluc Celik — Tue, 16 Feb 2010 07:39:23 GMT

Hi,

I am getting the following error while trying to insert a record using businessObject1.save():

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

I tracked the problem and found out that the SQL generated to insert the record has the auto-increment primary id field set to NULL.

Things I tried:

1. I setted the ID field to readonly from the Business Object Mapper -> same error
2. I captured the exact SQL, removed the ID field and run it on SQL Server Management Studio -> worked at that run
3. I added the ID field to FieldsToExcludeFromInsert property of the business object -> the application gave the error: Cannot create INSERT command because the updating DataTable does not contain columns for all PrimaryKeyFields.

I compared the business object I created for that application with a business object from the samples - which also has a auto-increment primary key field (cust_pk), and it seems to have the same structure. I didn't see any difference that could be the reason of the problem I am having.

I am still trying to find the problem, but any help would be very much appreciated.

Thanks,

Buluc

RE: Cannot insert explicit value for identity column

Trent L. Taylor — Tue, 16 Feb 2010 07:39:23 GMT

Glad you got it figured out :)

RE: Cannot insert explicit value for identity column

Buluc Celik — Tue, 16 Feb 2010 00:31:13 GMT

Thanks Trent, you pointed to the right direction. I have removed the PK from the FieldsToExcludeFromInsert property, then set PrimaryKeyIsAutoIncremented to TRUE and PrimaryKeyIsUpdatable to FALSE. It is working now :)

RE: Cannot insert explicit value for identity column

Trent L. Taylor — Mon, 15 Feb 2010 08:49:07 GMT

If you are doing this through a BO, then you need to set the PrimaryKeyIsUpdatable property to True and the PrimaryKeyIsAutoIncremented to False.