Symptom
When running Database Setup, typically during an upgrade of OnGuard, you may encounter one or more of the following error messages:
"Cannot update identity column ID in table dbo.DEPT."
"Cannot update identity column ID in table dbo.TITLE."
"Cannot update identity column ID in table dbo.BUILDING."
"Cannot update identity column ID in table dbo.LOCATION."
"Cannot update identity column ID in table dbo.DIVISION."
1) Verify you have a recent backup of the AccessControl database, and verify the integrity of the backup.
2) Open Microsoft SQL Server Management Studio on the database server, and log in with administrative rights to the AccessControl database.
3) In the Object Explorer, expand Databases, expand AccessControl, and then expand Tables.
4) Right-click on dbo.DEPT item, and then select Modify.
5) Select the ID column. On the Column Properties tab, under the Table Designer section, expand the Identity Specification item.
6) Ensure the (Is Identity) value is set to "No."
7) Close the table and choose to save changes.
8) Repeat steps 4 - 7 for the following tables:
dbo.TITLE
dbo.BUILDING
dbo.LOCATION
dbo.DIVISION
9) Run Database Setup again. The errors should not display.
SQL Server 2005
"Cannot update identity column ID in table dbo.DEPT."
"Cannot update identity column ID in table dbo.TITLE."
"Cannot update identity column ID in table dbo.BUILDING."
"Cannot update identity column ID in table dbo.LOCATION."
"Cannot update identity column ID in table dbo.DIVISION."
Resolution
To resolve the issue, complete the following steps:1) Verify you have a recent backup of the AccessControl database, and verify the integrity of the backup.
2) Open Microsoft SQL Server Management Studio on the database server, and log in with administrative rights to the AccessControl database.
3) In the Object Explorer, expand Databases, expand AccessControl, and then expand Tables.
4) Right-click on dbo.DEPT item, and then select Modify.
5) Select the ID column. On the Column Properties tab, under the Table Designer section, expand the Identity Specification item.
6) Ensure the (Is Identity) value is set to "No."
7) Close the table and choose to save changes.
8) Repeat steps 4 - 7 for the following tables:
dbo.TITLE
dbo.BUILDING
dbo.LOCATION
dbo.DIVISION
9) Run Database Setup again. The errors should not display.
Applies To
OnGuard (All versions)SQL Server 2005
