Hi,
The server apparently thinks that the index should be there, but it is
not. Something has probably failed somewhere, but the rollback was not
complete, leaving a discrepancy between the database and the
arsystem-repository-tables. Maybe a random timeout issue or something like
that.
You may need to manually create an index with that name, to allow the
system to continue. By manually I mean through SQL inside the database.
You can always turn on SQL logging, and then create an index via
dev-studio, to find the exact syntax.
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> 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:[email protected]] On Behalf Of Kim Ericsson
> Sent: Thursday, June 30, 2011 5:34 AM
> To: [email protected]
> 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"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
