I think the duplicate field name would be possible only when we update field meta data from the database directly bypassing AR APIs. Only a guess, but archgid is one tool that updates field-ids directly in database, so some scenario could have caused it to mis-behave causing inconsistenty that you are referring to below.
Thanks & Regards Girish From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of LJ LongWing Sent: 02 February 2018 12:27 AM To: ARSList <arslist@arslist.org> Subject: Re: FYI: Duplicate Field Names in 9.1.00 201512160229 possible - view created "OK" well, the obvious thing is to change one to a different name and hit save, then try to change it back...which it won't allow....I, like you, have no idea how they would have gotten into that situation in the first place. On Thu, Feb 1, 2018 at 11:10 AM, Ben Chernys <ben.cher...@softwaretoolhouse.com<mailto:ben.cher...@softwaretoolhouse.com>> wrote: The 9.1.04 Dev Studio does not permit a duplicate field name to be entered. Dev Studio is enhanced so that a red small msg is displayed saying duplicate field – nice improvement over only replacing your typing with what was there before. I note that I tried this on a regular form. Perhaps there are some special rules on a join? No matter how (though I am curious), they do have a duplicate field name: HPD:IncidentInterface 536870923 Last Resolved Date HPD:IncidentInterface 1000000563 Last Resolved Date It looks like they put it in as one field id and then decided using the BMC field id was better. If they have “matching fields” or even shared workflow, they would still work if the BMC field was the populated one. Interestingly, the view was created with both fields by appending “001” and “002”. I do not know which is which. I’d expect it to be in Id order but it could also be in when created order. Last_Resolved_Date001 Last_Resolved_Date002 Which begs the question: will BMC add a viewname column to arfield as well? (It would be nice.) How was one to expect the above two view column names from the field names that ARS knows about? (ie what order?). And how was the inclusion of two identically named fields possible? I could not do it with the 8.0.0 and 9.1.04 Dev Studio. The fact that there is code for handling duplicate fields when generating a view presumably does not mean that this is a new direction for schemas and fields – that duplicate named fields will be allowed? Besides, the clients disallow it. Any responses from BMC would be most appreciated. Cheers Ben From: Ben Chernys [mailto:ben.cher...@softwaretoolhouse.com<mailto:ben.cher...@softwaretoolhouse.com>] Sent: January-31-18 8:38 AM To: 'ARSList' <arslist@arslist.org<mailto:arslist@arslist.org>> Subject: RE: FYI: Duplicate Field Names in 9.1.00 201512160229 possible As I said, “I’m curious as to what field names were generated for the view.” I have no idea how they got it done. I have an older dev studio and it prevented that action from going to the server (as it should). Remember that Remedy has code for generating a field’s viewname. There’s a couple of fields in ITSM that have names ending in a space for example (xxx_ in the view). A field could be a reserved word in the db. Cheers Ben From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of LJ LongWing Sent: January-31-18 8:06 AM To: ARSList <arslist@arslist.org<mailto:arslist@arslist.org>> Subject: Re: FYI: Duplicate Field Names in 9.1.00 201512160229 possible Ben, I'm not sure how exactly that can happen because the 'name', assuming we are talking about the DB name of the field is used in the View creation, and you obviously can't have two columns with the same name in the DB view, so you can't do it in Dev Studio either...I would be curious to see a def of the form in question....this hasn't been possible since I started using remedy in v 3.2....not sure how they got it done. On Wed, Jan 31, 2018 at 7:55 AM, Ben Chernys <ben.cher...@softwaretoolhouse.com<mailto:ben.cher...@softwaretoolhouse.com>> wrote: Hi Folks, Just ran into an odd issue. A customer has created a field twice in the same form with the same name (but different ids). I tried to do the same on my 9.1.02 server using the 8.0 Developer Studio but the client prevented a duplicate entry into the name field. I remember the old admin tool returning a duplicate field error at some point. I’m curious as to what field names were generated for the view. All workflow is keyed to field ids so it is not surprising that the Remedy application still functions – though I wonder which field is selected in dev studio. I have downloaded the 9.1.04 clients et al and will give its dev studio and RDP a try if I can put in a Java it thinks is higher than 1.4 😊 Alas this is mere curiosity as Meta-Update/Meta-Archive is only affected in that the field cache for this form is not used (a minor slow-down in performance when dealing with this form). This is not a question; it just surprised me. Cheers, Ben Chernys Senior Software Architect [logoSthInc-sm] Canada / Deutschland Mobile: +49 171 380 2329<tel:+49%20171%203802329> GMT - 7 + [ DST ] Mobile +1 403 554 0887<tel:(403)%20554-0887> Email: Ben.Chernys_AT_softwaretoolhouse.com<mailto:Ben.Chernys_AT_softwaretoolhouse.com> Web: www.softwaretoolhouse.com<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.softwaretoolhouse.com_&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=kkVVqXzJ1pJzbLhG9j836_rUIVcaozMFzz01cZxeQ14&m=OlxusTTFOTRBoA89KAWMA02yYDpKGiUnHrnK7n_Pq34&s=INYxS6FEAIfUNEGfQihXIjn6pg2r1BPZ9-8mvk29bjk&e=> We are a BMC Technology Alliance Partner Check out Software Tool House's free Diary Editor and our Freebies Section for ITSM Forms and Fields spreadsheet. Meta-Update<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.softwaretoolhouse.com_product_SthMupd_index.html&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=kkVVqXzJ1pJzbLhG9j836_rUIVcaozMFzz01cZxeQ14&m=OlxusTTFOTRBoA89KAWMA02yYDpKGiUnHrnK7n_Pq34&s=3BzHTjkrM11DeDKHGZwObCoHq4uPrUlYHKF3U1ePbRY&e=>, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. Meta-Archive<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.softwaretoolhouse.com_product_SthArch_index.html&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=kkVVqXzJ1pJzbLhG9j836_rUIVcaozMFzz01cZxeQ14&m=OlxusTTFOTRBoA89KAWMA02yYDpKGiUnHrnK7n_Pq34&s=Xtstjzzb7Bjao51Cuj3sH3AOg0Na-HQHuDQh4FkLo_o&e=> does ITSM Archiving your way: with your forms and your multi-tenant rules, treating each root request as a complete tree and checking associatuions. Archive output to different servers, HTML pages with links to attachments or archive forms. Meta-Databot<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.softwaretoolhouse.com_product_Databot_index.html&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=kkVVqXzJ1pJzbLhG9j836_rUIVcaozMFzz01cZxeQ14&m=OlxusTTFOTRBoA89KAWMA02yYDpKGiUnHrnK7n_Pq34&s=pgSWAfIJYbjXwa7LU0r3lKL-gu8x78QfWElAD2JyVGs&e=> is an automated, extensible BMC Data Wizard. It reads a file of data changes and sports an Undo feature. Pre ITSM 9.1.04? Clarify? HP? Roll your own? No problem! You can keep your valuable data! http://www.softwaretoolhouse.com/<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.softwaretoolhouse.com_&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=kkVVqXzJ1pJzbLhG9j836_rUIVcaozMFzz01cZxeQ14&m=OlxusTTFOTRBoA89KAWMA02yYDpKGiUnHrnK7n_Pq34&s=INYxS6FEAIfUNEGfQihXIjn6pg2r1BPZ9-8mvk29bjk&e=> -- ARSList mailing list ARSList@arslist.org<mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist<https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=kkVVqXzJ1pJzbLhG9j836_rUIVcaozMFzz01cZxeQ14&m=OlxusTTFOTRBoA89KAWMA02yYDpKGiUnHrnK7n_Pq34&s=ujLCjgs5JZLUzBlPPS-Cy13SVAvVrh7eBdHMxZbYfRY&e=> -- ARSList mailing list ARSList@arslist.org<mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist<https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=kkVVqXzJ1pJzbLhG9j836_rUIVcaozMFzz01cZxeQ14&m=OlxusTTFOTRBoA89KAWMA02yYDpKGiUnHrnK7n_Pq34&s=ujLCjgs5JZLUzBlPPS-Cy13SVAvVrh7eBdHMxZbYfRY&e=>
-- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
