I'm unable to create any new pages in one of my sites. It's the velopment version of a live site, and whenever I try to crate a new pag I get:
The INSERT statement conflicted with the CHECK constraint "repl_identity_range_tran_165575628". blah blah
Further investigation reveals a Constraint on dbo.cmsPropertyData: it's preventing inserts if ([id]>(8582) AND [id]<(20000)). The most recent id is 19999!
The live version of the site also has this constraint, but the expression is ([id]>(41000) AND [id]<(51000)).
I've no idea where these constraints come from, whether they are modified dynamically by the system, or whether it's safe to edit them. I need to create some more pages!
That's an identity replication constraint. Your databases are set up for replication and it involves putting some check constraints on identity columns. Personally I'm by no mean an expert in this, so you'd better ask some DBA for detailed info and possible ways of resolution.
Thanks. The SQL installation is enabled for replication, but the dev db isn't actually replicated, so I've gone ahead and increased the upper limit of the constraint expression, and everything seems to work fine now.
I'm curious to know how this works, though. The constraint expression's values must be updated dynamically somehow, as the dbo.cmsPropertyData table in the live db has it set between 21,000 and 51,000: as the ids start at 1, it must have changed at least once, and it certainly hasn't been done manually by ourselves or our hosts...
Can't create new pages: CHECK constraint problem
I'm unable to create any new pages in one of my sites. It's the velopment version of a live site, and whenever I try to crate a new pag I get:
Further investigation reveals a Constraint on dbo.cmsPropertyData: it's preventing inserts if ([id]>(8582) AND [id]<(20000)). The most recent id is 19999!
The live version of the site also has this constraint, but the expression is ([id]>(41000) AND [id]<(51000)).
I've no idea where these constraints come from, whether they are modified dynamically by the system, or whether it's safe to edit them. I need to create some more pages!
Can anyone help?
That's an identity replication constraint. Your databases are set up for replication and it involves putting some check constraints on identity columns. Personally I'm by no mean an expert in this, so you'd better ask some DBA for detailed info and possible ways of resolution.
Thanks. The SQL installation is enabled for replication, but the dev db isn't actually replicated, so I've gone ahead and increased the upper limit of the constraint expression, and everything seems to work fine now.
I'm curious to know how this works, though. The constraint expression's values must be updated dynamically somehow, as the dbo.cmsPropertyData table in the live db has it set between 21,000 and 51,000: as the ids start at 1, it must have changed at least once, and it certainly hasn't been done manually by ourselves or our hosts...
is working on a reply...