Kim, I would recommend switching to Base Development mode, delete and then re-create all of the indexes there..it should correct your situation.
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kim Ericsson Sent: Thursday, June 30, 2011 5:34 AM To: arslist@ARSLIST.ORG Subject: Not able to delete a form Overlay ** Greetings! I got an issue with deletering a overlay for a form. Please see below for a detailed description of the problem. Environment Win 2008 R2 64-bit servers SQL 2008 SP1 64-bit Problem description Have upgraded the staging server from: AR Server 7.5 patch 004 > 7.6.04 SP1 CMDB 7.6 > 7.6.04 SP1 ITSM 7.6 > 7.6.04 SP1 SLM 7.6 > 7.6.04 SP1 I've run the BPCU and converted to overlays etc. Am now trying to remove an Overlay for a form but are not able to and need assistance. I want to remove the Overlay for the form "SLM:ConfigGoalType" but when I try to do this I receive this error message: "ERROR (382): The value(s) for this entry violate a unique index that has been defined for this form; ERROR (552): The SQL database operation failed.; Cannot drop the index 'T1990.I1990_8_1', because it does not exist or you do not have permission." I've tried to remove all indexes on the Overlay form but was not able to remove the unique index for the Status field, since the remove button is grey. The other indexes I removed successfully but still get the same error message when trying to delete the Overlay. If I run this query in the db: select schemaId,name from arschema where name like '%SLM_ConfigGoalType%' I get the result: 1990 SLM:ConfigGoalType 2304 SLM:ConfigGoalType__o This query: select indexname from schema_index where schemaid = 2304 Get this result: I1990_300905300_1 This query: select indexname from schema_index where schemaid = 1990 Get this result. I1990_300473700_1 I1990_300695300_1 I1990_300905300_1 I1990_8_1 Seems to me Dev Studio tries to remove an index that is not present for some reason. Any ideas on how to solve this one is much appreciated! _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"