I exported the def from the production server (where I am getting the duplicate indexes) then turned around and re-imported back into the same server. I received the same errors about the duplicate indexes, but it appears to have cleaned them up. I exported again and the duplicate entries are now gone. I guess all is well that ends well, even though I still don't understand what happened.
Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 8-226-1805 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Tuesday, June 12, 2007 7: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___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
