Exporting the data reads the form structure as seen in the meta database when the definitions of the forms etc. are loaded into the AR Server memory... Perhaps while importing the system compares the actual table structure rather than the loaded definitions in the memory??
If you do not see that field in the T table (or the B tables if it is an attachment pool or field) there must be a row in the fields table referencing that field ID that may be needed to be deleted manually.. Since this is a Date and time field you should see its ID in the T table.. If it is not seen there, it may have already been dropped from the T table. Somehow though possibly due to a time out, the fields table failed to drop the entry for that field. Delete just that one row from the T table that is tied to that field and schema: delete from fields where fieldid = m and schemaid in (select schemaid from arschema where name = ‘<FormNameCaseSensitive>’; commit; (if on oracle) If you already know the schemaid: delete from fields where fieldid = m and schemaid = n; commit; (if on oracle) Upon performing this you may have to restart the AR Server so it re-reads the definitions or if you are familiar with arsignal, run that with the –g option that reloads definitions into the server memory without the need to restart the server... The arsignal utility will be found in the AR Server Directory.. arsignal –g hostname<:PortNumber> Joe From: Wagner, Christoph Sent: Saturday, April 16, 2011 4:36 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: field not really deleted ** Hey Phil, I already tried that but I got an error “ You have specified a field already in use (ARERR 2326). I tried that what Misi told me to do, but when I re-import the form (BMC Remedy Administrator at Tools à Import Definition à From Definition File) the changes I made in the def-file were not excepted. When I export the Form after the re-import the def file is just like the first def-file before I made my changes. Do I made a wrong re-import for the form? I haven’t done this before I use Remedy 7.1 Patch 8 Thanks a lot Regards Christoph -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Friday, April 15, 2011 12:44 PM To: arslist@ARSLIST.ORG Subject: Re: field not really deleted Hi, 1. Export the form to a def-file. 2. Edit the def with notepad. 3. Search for the persistent field id. 4. Delete the field {..} from the def field { id : xxx ... } 5. Subtract one from the form-field-count near the beginning. num-fields : n 5. Import the changed def in place. 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. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Murnane, Phil Sent: Friday, April 15, 2011 12:49 PM To: arslist@ARSLIST.ORG Subject: Re: field not really deleted ** Christoph: If you haven’t already done this, try: delete the field save the form add a new field with same ID save the form What version of ARS are you using? --Phil From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Wagner, Christoph Sent: Friday, April 15, 2011 02:16 To: arslist@ARSLIST.ORG Subject: Re: field not really deleted ** Dear listers, at first thank you very much for your help. I deleted the field and then I saved the form. After that I wanted to create the same field with the same ID and I got an error. I have other views, but the field-ID doesn’t exist in any other view. Are there any other ideas? Thanks a lot. Regards Christoph From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller Sent: Tuesday, April 12, 2011 9:46 PM To: arslist@ARSLIST.ORG Subject: Re: field not really deleted ** Really? That that is one of the first things that bit me when I was just learning Remedy (v4 and have never forgotten). I deleted a field thinking it only removed the field from the view but actually delete the field and data in the database. Jason On Tue, Apr 12, 2011 at 6:11 AM, Grooms, Frederick W <frederick.w.gro...@xo.com> wrote: Do you have multiple views on this form? A field will not "delete" until it is removed from all views. Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Wagner, Christoph Sent: Monday, April 11, 2011 5:18 PM To: arslist@ARSLIST.ORG Subject: field not really deleted ** Dear ARS-List, my remedy makes some strange things. When I create a field (date, char, int, whatever) it gets a right database-id automatically. If I delete it, the field and the ID are deleted in BMC-Remedy-Administrator but not in database. If I want to create a new field with the deleted field-id, I get an error: Is there anyone who had the same problem or know anything to do? Thanks very much Regards Christoph _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"