In looking further I found this on BMC site: It seems the nextFieldID field is in the arschema table but serves no purpose. I think it would be great if it was used as a source of the field ID's added.
Knowledge Article ID: KA331759 Version: 1.0 Status: Published Published date: 01/20/2011 ..... It is also important to mention that while there is a column called nextfieldid in arschema, and it is updated, it is not used to determine the next fieldid. This column may be used in future but is not utilized at this time. Thanks, Bob https://kb.bmc.com/infocenter/index?page=content&id=KA331759&actp=search&viewlocale=en_US&searchid=1320867086164 https://kb.bmc.com/infocenter/index?page=content&id=KA331759&actp=search&viewlocale=en_US&searchid=1320867086164 Misi Mladoniczky wrote: > > Hi, > > Normally most fields starts at 536870913 and increases from there. > > Some fields, I do not remember exactly which ones, goes from 536870912 and > continues down instead. > > I presume that the nextFieldId is for the types of fields going upwards > from 536870913... > > Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) > > Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): > * 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. > >> Check on the fields meta table if there is already a entry with that >> number >> for that form that may have somehow got there - magically.. I don't >> expect >> that, as I think if it had you would have got a unique index violated >> type >> of an error as I think there is an internal constraint on that form with >> a >> unique index on the schemaid and fieldid column but it never hurts >> checking.. >> >> Joe >> >> -----Original Message----- >> From: Bob S >> Sent: Wednesday, November 09, 2011 2:07 PM Newsgroups: >> public.remedy.arsystem.general >> To: [email protected] >> Subject: New fields: set nextfieldid >> >> Conny, >> >> I set the nextFieldId to 777110000, for a specific form, restart >> ARServer, >> but when I add a new field to that form, it comes in with a number such >> as >> 536870912. Shouldnt new fields now come in incrementing from 777110000? >> >> >> >> Kali, >> >> with the following sql statement you can set nextfieldid to a safe >> number. >> >> UPDATE arschema SET nextfieldid = (SELECT MAX(fieldid) FROM field WHERE >> field.schemaid =arschema.schemaid) + 1 where name = '<Name of your >> form>' >> >> After that you must restart your arserver. >> >> Kind Regards Conny >> >> -- >> View this message in context: >> http://old.nabble.com/New-fields-added-becomes-Core-fields-tp25234917p32813409.html >> Sent from the ARS (Action Request System) mailing list archive at >> Nabble.com. >> >> _______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" >> >> _______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" >> > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > > -- View this message in context: http://old.nabble.com/New-fields-added-becomes-Core-fields-tp25234917p32814209.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
