RE: FYI: Duplicate Field Names in 9.1.00 201512160229 possible - view created "OK"

2018-02-01 Thread Gupta, Girish 
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 allowI, 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

100563

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 questionthis hasn't been possible since I started using remedy in v 
3.2not 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

Re: FYI: Duplicate Field Names in 9.1.00 201512160229 possible - view created "OK"

2018-02-01 Thread LJ LongWing 
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 allowI, 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> 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
>
> 100563
>
> 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]
> *Sent:* January-31-18 8:38 AM
> *To:* 'ARSList' <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
> <arslist-boun...@arslist.org>] *On Behalf Of *LJ LongWing
> *Sent:* January-31-18 8:06 AM
> *To:* ARSList <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 questionthis hasn't been possible since I started using
> remedy in v 3.2not sure how they got it done.
>
>
>
> On Wed, Jan 31, 2018 at 7:55 AM, Ben Chernys <Ben.Chernys@
> 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 surp

RE: FYI: Duplicate Field Names in 9.1.00 201512160229 possible - view created "OK"

2018-02-01 Thread Ben Chernys 
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

100563

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] 
Sent: January-31-18 8:38 AM
To: 'ARSList' <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 questionthis hasn't been possible since I started using remedy in v 
3.2not 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
  

Canada / Deutschland
Mobile:+49 171 380 2329 <tel:+49%20171%203802329>GMT - 7 + [ DST ]

Mobile +1 403 <tel:(403)%20554-0887>   554 0887
Email:   Ben.Chernys_AT_softwaretoolhouse.com 
<mailto:Ben.Chernys_AT_softwaretoolhouse.com> 
Web:  <http://www.softwaretoolhouse.com/> www.softwaretoolhouse.com

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 <http://www.softwaretoolhouse.com/product/SthMupd/index.html> , 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 <http://www.software

RE: FYI: Duplicate Field Names in 9.1.00 201512160229 possible

2018-01-31 Thread Ben Chernys 
Hi Jason,

 

I certainly recall many view generation failures at least until 7.6.04.  Back 
then if a view generation failed it did not throw an error.  That may still be 
the case.

 

Only if you used the views would you discover something amiss.  The viewname 
column was added to arschema in 7.1.  Prior to that if you needed a table’s 
viewname, you’d have to follow a DB dependent algorithm to generate it using 
the name and schemaid.

 

I’ve asked for a couple of queries to see what the view looks like.

 

Cheers,

Ben

 

From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Jason Miller
Sent: January-31-18 8:57 AM
To: ARSList <arslist@arslist.org>
Subject: Re: FYI: Duplicate Field Names in 9.1.00 201512160229 possible

 

A bit OT but I do remember a time when you could name a field with a DB keyword 
and the SQL view would not be generated. I Remember we a few forms with the 
field call "function" and the SQL view wouldn't build until we got smart and 
started naming the field something like "functionx". I think the last time I 
saw this was like in 6.x, maybe even 5.x.

 

Jason

 

On Wed, Jan 31, 2018 at 9:37 AM, Ben Chernys <ben.cher...@softwaretoolhouse.com 
<mailto:ben.cher...@softwaretoolhouse.com> > wrote:

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 
<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 questionthis hasn't been possible since I started using remedy in v 
3.2not 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
  

Canada / Deutschland
Mobile:+49 171 380 2329 <tel:+49%20171%203802329>GMT - 7 + [ DST ]

Mobile +1 403 <tel:(403)%20554-0887>   554 0887
Email:   Ben.Chernys_AT_softwaretoolhouse.com 
<mailto:Ben.Chernys_AT_softwaretoolhouse.com> 
Web:  <http://www.softwaretoolhouse.com/> www.softwaretoolhouse.com

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 <http://www.softwaretoolhouse.com/product/SthMupd/index.html> , 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 <http://www.softwaretoolhouse.com/product/SthArch/index.html>  
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 <http://www.softwaretoolhouse.com/product/Databot/index.html>  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 probl

Re: FYI: Duplicate Field Names in 9.1.00 201512160229 possible

2018-01-31 Thread Jason Miller 
A bit OT but I do remember a time when you could name a field with a DB
keyword and the SQL view would not be generated. I Remember we a few forms
with the field call "function" and the SQL view wouldn't build until we got
smart and started naming the field something like "functionx". I think the
last time I saw this was like in 6.x, maybe even 5.x.

Jason

On Wed, Jan 31, 2018 at 9:37 AM, Ben Chernys <
ben.cher...@softwaretoolhouse.com> wrote:

> 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>
> *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 questionthis hasn't been possible since I started using
> remedy in v 3.2not sure how they got it done.
>
>
>
> On Wed, Jan 31, 2018 at 7:55 AM, Ben Chernys <Ben.Chernys@
> 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
> [image: logoSthInc-sm]
>
> Canada / Deutschland
> Mobile:+49 171 380 2329 <+49%20171%203802329>   GMT - 7 + [ DST ]
>
> Mobile +1 403  554 0887 <(403)%20554-0887>
> Email:   Ben.Chernys_AT_softwaretoolhouse.com
> Web: www.softwaretoolhouse.com
>
> 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 <http://www.softwaretoolhouse.com/product/SthMupd/index.html>*
> *,* 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
> <http://www.softwaretoolhouse.com/product/SthArch/index.html>* 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
> <http://www.softwaretoolhouse.com/product/Databot/index.html>* 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/
>
>
>
>
>
>
>
>
>
>
> --
> ARSList mailing list
> ARSList@arslist.org
> https://mailman.rrr.se/cgi/listinfo/arslist
>
>
>
> --
> ARSList mailing list
> ARSList@arslist.org
> https://mailman.rrr.se/cgi/listinfo/arslist
>
>
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

RE: FYI: Duplicate Field Names in 9.1.00 201512160229 possible

2018-01-31 Thread Ben Chernys 
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>
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 questionthis hasn't been possible since I started using remedy in v 
3.2not 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
  

Canada / Deutschland
Mobile:+49 171 380 2329 <tel:+49%20171%203802329>GMT - 7 + [ DST ]

Mobile +1 403 <tel:(403)%20554-0887>   554 0887
Email:   Ben.Chernys_AT_softwaretoolhouse.com 
<mailto:Ben.Chernys_AT_softwaretoolhouse.com> 
Web:  <http://www.softwaretoolhouse.com/> www.softwaretoolhouse.com

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 <http://www.softwaretoolhouse.com/product/SthMupd/index.html> , 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 <http://www.softwaretoolhouse.com/product/SthArch/index.html>  
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 <http://www.softwaretoolhouse.com/product/Databot/index.html>  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/> http://www.softwaretoolhouse.com/  

 

 

 

 


--
ARSList mailing list
ARSList@arslist.org <mailto:ARSList@arslist.org> 
https://mailman.rrr.se/cgi/listinfo/arslist

 

-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

Re: FYI: Duplicate Field Names in 9.1.00 201512160229 possible

2018-01-31 Thread LJ LongWing 
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 questionthis hasn't been possible since I started using
remedy in v 3.2not sure how they got it done.

On Wed, Jan 31, 2018 at 7:55 AM, Ben Chernys <
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
> [image: logoSthInc-sm]
>
> Canada / Deutschland
> Mobile:+49 171 380 2329 <+49%20171%203802329>   GMT - 7 + [ DST ]
>
> Mobile +1 403  554 0887 <(403)%20554-0887>
> Email:   Ben.Chernys_AT_softwaretoolhouse.com
> Web: www.softwaretoolhouse.com
>
> 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 *
> *,* 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
> * 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
> * 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/
>
>
>
>
>
>
>
>
>
> --
> ARSList mailing list
> ARSList@arslist.org
> https://mailman.rrr.se/cgi/listinfo/arslist
>
>
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

FYI: Duplicate Field Names in 9.1.00 201512160229 possible

2018-01-31 Thread Ben Chernys 
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
  

Canada / Deutschland
Mobile:+49 171 380 2329   GMT - 7 + [ DST ]

Mobile +1 403  554 0887
Email:   Ben.Chernys_AT_softwaretoolhouse.com 
 
Web:   www.softwaretoolhouse.com

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  , 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   
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   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/  

 

 

 

 

-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist