Andy, I don't really have a good answer for that.. except that it appears to be some sort of a software bug... I'd suggest you send your def file with your finding to Remedy Support and report your findings.. They might be interested to investigate it further with you..
Meanwhile just out of curiosity, did you ever update or redefine indexes on this form at some point and perhaps got a time out? Database timeouts seem to do a few funny things at times.. Do you have your arerror.log file over the period of time you might have done changes to this form? Might be useful to take a peek at what happened during that time. One way of correcting the definitions would be to delete all your indexes on this form, save the form, and recreate these indexes.. then take an export of the form and see if the duplicate indexes were removed.. Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Mayfield, Andy L. Sent: Tuesday, June 12, 2007 8:49 AM To: [email protected] Subject: Re: Duplicate Indexes ** OK, after comparing the def files I've found that my production server does have duplicate listings for the ID's I receive the errors (listed below). The entry below if from the source def file. Why would there be duplicate entries for those indexes? I've never had a problem like this before, so I am clueless (more so than usual). index : 1\7\0 index : 1\7\0 index : 1\536870913\0 index : 1\4\0 index : 1\4\0 index : 1\3\0 index : 1\3\0 index : 1\536870923\0 index : 1\536870923\0 Any help would be appreciated. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 8-226-1805 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, June 11, 2007 5:54 PM To: [email protected] Subject: Re: Duplicate Indexes Andy, Since you are uncomfortable, you could try taking a def file of the form that is now imported (after the import and the error) and compare it with the def file that exist on the original server.. do a text comparison and see if you can see any differences.. You just may learn something there.. If they both look the same, I guess you are good to go.. If they look significantly different.. panic.. :-) and then pass on the differences to the list and someone out here might just be able to throw some light.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Mayfield, Andy L. Sent: Monday, June 11, 2007 6:41 PM To: [email protected] Subject: Re: Duplicate Indexes I have tested a little and I do not see any obvious problems. It still makes me a little uneasy. I believe I will wind up just mirroring the production server and go from there. I use this server to test new features, then export the def files and import to the production server. So I usually start by exporting from the production server then importing to the backup server before starting to be sure I have everything synched before I make changes. Very strange. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 8-226-1805 Office: 8-226-1805 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.472 / Virus Database: 269.8.13/844 - Release Date: 6/11/2007 5:10 PM __________________________________________________________________________ _____ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" __20060125_______________________This posting was submitted with HTML in it___ No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.472 / Virus Database: 269.8.14/845 - Release Date: 6/12/2007 6:39 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
