Re: More FUN with 7.6.04 Form Overlays

[Ben Chernys]

Hi Christopher,

 

Since 7.0 (one of the patches) there has been a “viewname” column in arschema.  
This should be used in SQL scripts.  

 

The algorithm to truncate a form name to a view name is quite simple and is 
available as a sample script (AR Table Report) in the Meta-Update Learning, 
Script Library section of www.softwaretoolhouse.com.  You can download the 
script and read it for the algorithm of you’re interested.  That script assumes 
7.1+ has the viewname column and uses that algorithm for server < 7.1.  Thanks 
goes to Mark Walters for help with that algorithm especially for other 
databases.

 

This is nothing new and not related to all the troubles you’ve been having with 
7.6.04.

 

It is simply dependent on the order of population of arschema.  The first table 
encountered (being created) that is unique in the 30 characters of its name 
gets the table’s view name truncated from its table name (with character 
xlates) and every subsequent table that has its name matched in the first 30 
characters gets truncated a bit more (depending on the length of the schema id) 
and gets its schema id as part of its view name

 

That is why since the addition of the viewname field, it is always better to 
base your scripts on the value in that fields.

 

Cheers

 

Ben Chernys

Senior Software Architect
Software Tool House Inc.

Canada / Deutschland / Germany
Mobile:  +49 171 380 2329GMT + 1 + [ DST ]
Email: Ben.Chernys _AT_ 
softwaretoolhouse.com
Web:   www.softwaretoolhouse.com

Check out Software Tool House's free Diary Editor.

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. 
  http://www.softwaretoolhouse.com/  

 

 

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of strauss
Sent: April-29-11 23:37
To: arslist@ARSLIST.ORG
Subject: Re: More FUN with 7.6.04 Form Overlays

 

Ah, part of the problem is that the viewName for any schema with a name or 
(resolvedName) over 30 characters gets truncated and appended with 
differentiating characters, primarily where the first 25 or so characters are 
NOT UNIQUE between multiple forms.  The trouble is that each server creates 
different viewNames, so…

 

on one server, upgraded from 7.1/2.1/7.0 to 7.6.04:

select count(*) as "BMC.CORE.CONFIG:BMC_ConfigBaseElement" from 
BMC_CORE_CONFIG_BMC_ConfigBase

select count(*) as "BMC.CORE.CONFIG:BMC_ConfigBaseRelationship" from 
BMC_CORE_CONFIG_BMC_ConfigB159

 

and on another, clean install of 7.6.04:

select count(*) as "BMC.CORE.CONFIG:BMC_ConfigBaseElement" from 
BMC_CORE_CONFIG_BMC_ ConfigB456

select count(*) as "BMC.CORE.CONFIG:BMC_ConfigBaseRelationship" from 
BMC_CORE_CONFIG_BMC_ConfigBase 

 

Yes, they are reversed; beware!  The same viewName on different server may 
point at completely a different form from within the set of those with common 
name elements.  You will have to edit some of the sql scripts in \BMC 
Software\Migrator\migrator\DeltaDataMigration\Utilities to fit EVERY server 
that you use them on – in my case there were differences in 
AR_7604_Forms_Count.sql, Atrium_7604_Forms_Count.sql, and 
RKM_7604_Forms_Count.sql.

 

Why am I this far down in the weeds on a Friday afternoon???

 

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing & IT Center
http://itsm.unt.edu/ 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of strauss
Sent: Friday, April 29, 2011 11:48 AM
To: arslist@ARSLIST.ORG
Subject: More FUN with 7.6.04 Form Overlays

 

Here’s one for you.  I was poking around in the Delta Data Migration 
directories this morning, and found the sql scripts for counting records in 
forms for each of the applications.  Some of them have more errors than correct 
lines, but that can be fixed; maybe the form names are instantiated differently 
on other SQL systems (maybe they were created against oracle?), but they were 
dead wrong for SQL Server 2008 (many form names too long and therefore 
unrecognized).  Also, a lot of the form names were invalid because they were 
missing underscores – I’m not sure how anyone could have compiled these scripts 
without ever testing them.  If this is what the DDM uses to run queries, there 
is no chance of it ever working correctly.

 

Anyway, I tried to run a select statement in SQL for a custom integer field on 
my HPD:Help Desk form to see if it has negative number entries that need to be 
reset to “0” (see DDM doc pg 19), and found that I could not select that field 
because it exists only in the overlay.  In fact, you cannot select ANY of your 
custom fields from HPD_Help_Desk, and there is no HPD_Help_Desk__o in the form 
list, so I wonder where yo

Re: 7.6.4 ARS Install, Email Engine Issue

[Kevin Begosh]

LJ,
The email engine itself is not an entry in the add remove programs but I did
run the uninstall for ARS and chose email and then re-installed it and I got
the same result.  Maybe I could try for a third time :).

Thanks for the response.

Kevin

On Sun, May 1, 2011 at 9:26 PM, LJ LongWing  wrote:

> **
>
> Kevin,
>
> In both 7.5 and 7.6.4 installs I found that the Email engine and the
> Flashboard server didn’t install, I had to go into the add/remove programs,
> uninstall those components, and re-run the install to get them installed
> properly.
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Kevin Begosh
> *Sent:* Sunday, May 01, 2011 4:26 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* 7.6.4 ARS Install, Email Engine Issue
>
>
>
> **
>
> List,
>
> I am installing ARS, ITSM CMDB etc... 7.6.4.  I went to install the
> ASServer peice first on a windows 2008 64 bit server and a SQL 2008 DB.  The
> install appear to work okay expect the email engine failed the sanity check,
> it said Email Engine is down.  When I went to services to try and start it,
> it does not exist.  I went to the registry and there is an entry there but
> no service.  Has anyone seen this?
>
> --
> Kevin Begosh
>
> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_




-- 
Kevin Begosh

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: More FUN with 7.6.04 Form Overlays

[strauss]

That sounds correct – based on what I was seeing last week.  The problem here 
is that since the viewname gets determined differently on each db server, the 
scripts provided by BMC with their delta data migration are invariably 
incorrect.  I was simply editing them to see if I could get them to run to 
compare the reference, staging, and pre-production server record counts – 
something I usually have to do by writing the script to draw directly from the 
t-tables, which also differ between servers.

I still was not able to return any of the custom fields that reside in the 
overlays using viewname; I had to use the t-table to find them and query their 
values.

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing & IT Center
http://itsm.unt.edu/
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Ben Chernys
Sent: Monday, May 02, 2011 3:36 AM
To: arslist@ARSLIST.ORG
Subject: Re: More FUN with 7.6.04 Form Overlays

**
Hi Christopher,

Since 7.0 (one of the patches) there has been a “viewname” column in arschema.  
This should be used in SQL scripts.

The algorithm to truncate a form name to a view name is quite simple and is 
available as a sample script (AR Table Report) in the Meta-Update Learning, 
Script Library section of 
www.softwaretoolhouse.com.  You can download 
the script and read it for the algorithm of you’re interested.  That script 
assumes 7.1+ has the viewname column and uses that algorithm for server < 7.1.  
Thanks goes to Mark Walters for help with that algorithm especially for other 
databases.

This is nothing new and not related to all the troubles you’ve been having with 
7.6.04.

It is simply dependent on the order of population of arschema.  The first table 
encountered (being created) that is unique in the 30 characters of its name 
gets the table’s view name truncated from its table name (with character 
xlates) and every subsequent table that has its name matched in the first 30 
characters gets truncated a bit more (depending on the length of the schema id) 
and gets its schema id as part of its view name

That is why since the addition of the viewname field, it is always better to 
base your scripts on the value in that fields.

Cheers

Ben Chernys

Senior Software Architect
Software Tool House Inc.

Canada / Deutschland / Germany
Mobile:  +49 171 380 2329GMT + 1 + [ DST ]
Email:   Ben.Chernys _AT_ 
softwaretoolhouse.com
Web: www.softwaretoolhouse.com

Check out Software Tool House's free Diary Editor.

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.
http://www.softwaretoolhouse.com/



From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of strauss
Sent: April-29-11 23:37
To: arslist@ARSLIST.ORG
Subject: Re: More FUN with 7.6.04 Form Overlays

Ah, part of the problem is that the viewName for any schema with a name or 
(resolvedName) over 30 characters gets truncated and appended with 
differentiating characters, primarily where the first 25 or so characters are 
NOT UNIQUE between multiple forms.  The trouble is that each server creates 
different viewNames, so…

on one server, upgraded from 7.1/2.1/7.0 to 7.6.04:
select count(*) as "BMC.CORE.CONFIG:BMC_ConfigBaseElement" from 
BMC_CORE_CONFIG_BMC_ConfigBase
select count(*) as "BMC.CORE.CONFIG:BMC_ConfigBaseRelationship" from 
BMC_CORE_CONFIG_BMC_ConfigB159

and on another, clean install of 7.6.04:
select count(*) as "BMC.CORE.CONFIG:BMC_ConfigBaseElement" from 
BMC_CORE_CONFIG_BMC_ ConfigB456
select count(*) as "BMC.CORE.CONFIG:BMC_ConfigBaseRelationship" from 
BMC_CORE_CONFIG_BMC_ConfigBase

Yes, they are reversed; beware!  The same viewName on different server may 
point at completely a different form from within the set of those with common 
name elements.  You will have to edit some of the sql scripts in \BMC 
Software\Migrator\migrator\DeltaDataMigration\Utilities to fit EVERY server 
that you use them on – in my case there were differences in 
AR_7604_Forms_Count.sql, Atrium_7604_Forms_Count.sql, and 
RKM_7604_Forms_Count.sql.

Why am I this far down in the weeds on a Friday afternoon???

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing & IT Center
http://itsm.unt.edu/
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of strauss
Sent: Friday, April 29, 2011 11:48 AM
To: arslist@ARSLIST.ORG
Subject: More FUN with 7.6.04 Form Overlays

Here’s one for you.  I was poking around in the Delta Data Migration 
directories this morning, and found the sql scripts for counting records in 
forms for each of the applications.  Some of them have more errors tha

Re: More FUN with 7.6.04 Form Overlays

[Axton]

Yuck.  Would be nicer if the method used to generate the view names worked
consistently, regardless of the order in which the forms were created.

Axton

On Mon, May 2, 2011 at 3:36 AM, Ben Chernys <
ben.cher...@softwaretoolhouse.com> wrote:

> **
>
> Hi Christopher,
>
>
>
> Since 7.0 (one of the patches) there has been a “viewname” column in
> arschema.  This should be used in SQL scripts.
>
>
>
> The algorithm to truncate a form name to a view name is quite simple and is
> available as a sample script (AR Table Report) in the Meta-Update Learning,
> Script Library section of www.softwaretoolhouse.com.  You can download the
> script and read it for the algorithm of you’re interested.  That script
> assumes 7.1+ has the viewname column and uses that algorithm for server <
> 7.1.  Thanks goes to Mark Walters for help with that algorithm especially
> for other databases.
>
>
>
> This is nothing new and not related to all the troubles you’ve been having
> with 7.6.04.
>
>
>
> It is simply dependent on the order of population of arschema.  The first
> table encountered (being created) that is unique in the 30 characters of its
> name gets the table’s view name truncated from its table name (with
> character xlates) and every subsequent table that has its name matched in
> the first 30 characters gets truncated a bit more (depending on the length
> of the schema id) and gets its schema id as part of its view name
>
>
>
> That is why since the addition of the viewname field, it is always better
> to base your scripts on the value in that fields.
>
>
>
> Cheers
>
>
>
> Ben Chernys
>
> Senior Software Architect
> Software Tool House Inc.
>
> Canada / Deutschland / Germany
> Mobile:  +49 171 380 2329GMT + 1 + [ DST ]
> Email:   Ben.Chernys _AT_ 
> softwaretoolhouse.com
> Web: www.softwaretoolhouse.com
>
> Check out Software Tool House's free Diary Editor.
>
> *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.
> http://www.softwaretoolhouse.com/
>
>
>
>
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *strauss
> *Sent:* April-29-11 23:37
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: More FUN with 7.6.04 Form Overlays
>
>
>
> Ah, part of the problem is that the viewName for any schema with a name or
> (resolvedName) over 30 characters gets truncated and appended with
> differentiating characters, primarily where the first 25 or so characters
> are NOT UNIQUE between multiple forms.  The trouble is that each server
> creates different viewNames, so…
>
>
>
> on one server, upgraded from 7.1/2.1/7.0 to 7.6.04:
>
> select count(*) as "BMC.CORE.CONFIG:BMC_ConfigBaseElement" from
> BMC_CORE_CONFIG_BMC_ConfigBase
>
> select count(*) as "BMC.CORE.CONFIG:BMC_ConfigBaseRelationship" from
> BMC_CORE_CONFIG_BMC_ConfigB159
>
>
>
> and on another, clean install of 7.6.04:
>
> select count(*) as "BMC.CORE.CONFIG:BMC_ConfigBaseElement" from
> BMC_CORE_CONFIG_BMC_ ConfigB456
>
> select count(*) as "BMC.CORE.CONFIG:BMC_ConfigBaseRelationship" from
> BMC_CORE_CONFIG_BMC_ConfigBase
>
>
>
> Yes, they are reversed; beware!  The same viewName on different server may
> point at completely a different form from within the set of those with
> common name elements.  You will have to edit some of the sql scripts in \BMC
> Software\Migrator\migrator\DeltaDataMigration\Utilities to fit EVERY server
> that you use them on – in my case there were differences in
> AR_7604_Forms_Count.sql, Atrium_7604_Forms_Count.sql, and
> RKM_7604_Forms_Count.sql.
>
>
>
> Why am I this far down in the weeds on a Friday afternoon???
>
>
>
> Christopher Strauss, Ph.D.
> Call Tracking Administration Manager
> University of North Texas Computing & IT Center
> http://itsm.unt.edu/
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *strauss
> *Sent:* Friday, April 29, 2011 11:48 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* More FUN with 7.6.04 Form Overlays
>
>
>
> Here’s one for you.  I was poking around in the Delta Data Migration
> directories this morning, and found the sql scripts for counting records in
> forms for each of the applications.  Some of them have more errors than
> correct lines, but that can be fixed; maybe the form names are instantiated
> differently on other SQL systems (maybe they were created against oracle?),
> but they were dead wrong for SQL Server 2008 (many form names too long and
> therefore unrecognized).  Also, a lot of the form names were invalid because
> they were missing underscores – I’m not sure how anyone could have compiled
> these scripts without ever testing them.  If this is what the DDM uses to
> run queries, there is no chance of it ever working correctly.
>
>
>
> Anyway, I tried to run a select statement in SQL for a custom integer field
> on my HPD:Help Desk form to 

Re: More FUN with 7.6.04 Form Overlays

[patrick zandi]

Ya know this is kinda sad,, and funny...
You guys are figuring out the problems BMC has with their code, which shows
the Q&A/dysfunctional or they are dependent on you for your due diligence to
isolate their problems..
How come there are so many release problems? just wondering..


On Mon, May 2, 2011 at 10:11 AM, strauss  wrote:

> That sounds correct – based on what I was seeing last week.  The problem
> here is that since the viewname gets determined differently on each db
> server, the scripts provided by BMC with their delta data migration are
> invariably incorrect.  I was simply editing them to see if I could get them
> to run to compare the reference, staging, and pre-production server record
> counts – something I usually have to do by writing the script to draw
> directly from the t-tables, which also differ between servers.
>
>
>
> I still was not able to return any of the custom fields that reside in the
> overlays using viewname; I had to use the t-table to find them and query
> their values.
>
>
>
> Christopher Strauss, Ph.D.
> Call Tracking Administration Manager
> University of North Texas Computing & IT Center
> http://itsm.unt.edu/
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Ben Chernys
> *Sent:* Monday, May 02, 2011 3:36 AM
> *To:* arslist@ARSLIST.ORG
>
> *Subject:* Re: More FUN with 7.6.04 Form Overlays
>
>
>
> **
>
> Hi Christopher,
>
>
>
> Since 7.0 (one of the patches) there has been a “viewname” column in
> arschema.  This should be used in SQL scripts.
>
>
>
> The algorithm to truncate a form name to a view name is quite simple and is
> available as a sample script (AR Table Report) in the Meta-Update Learning,
> Script Library section of www.softwaretoolhouse.com.  You can download the
> script and read it for the algorithm of you’re interested.  That script
> assumes 7.1+ has the viewname column and uses that algorithm for server <
> 7.1.  Thanks goes to Mark Walters for help with that algorithm especially
> for other databases.
>
>
>
> This is nothing new and not related to all the troubles you’ve been having
> with 7.6.04.
>
>
>
> It is simply dependent on the order of population of arschema.  The first
> table encountered (being created) that is unique in the 30 characters of its
> name gets the table’s view name truncated from its table name (with
> character xlates) and every subsequent table that has its name matched in
> the first 30 characters gets truncated a bit more (depending on the length
> of the schema id) and gets its schema id as part of its view name
>
>
>
> That is why since the addition of the viewname field, it is always better
> to base your scripts on the value in that fields.
>
>
>
> Cheers
>
>
>
> Ben Chernys
>
> Senior Software Architect
> Software Tool House Inc.
>
> Canada / Deutschland / Germany
> Mobile:  +49 171 380 2329GMT + 1 + [ DST ]
> Email:   Ben.Chernys _AT_ 
> softwaretoolhouse.com
> Web: www.softwaretoolhouse.com
>
> Check out Software Tool House's free Diary Editor.
>
> *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.
> http://www.softwaretoolhouse.com/
>
>
>
>
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *strauss
> *Sent:* April-29-11 23:37
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: More FUN with 7.6.04 Form Overlays
>
>
>
> Ah, part of the problem is that the viewName for any schema with a name or
> (resolvedName) over 30 characters gets truncated and appended with
> differentiating characters, primarily where the first 25 or so characters
> are NOT UNIQUE between multiple forms.  The trouble is that each server
> creates different viewNames, so…
>
>
>
> on one server, upgraded from 7.1/2.1/7.0 to 7.6.04:
>
> select count(*) as "BMC.CORE.CONFIG:BMC_ConfigBaseElement" from
> BMC_CORE_CONFIG_BMC_ConfigBase
>
> select count(*) as "BMC.CORE.CONFIG:BMC_ConfigBaseRelationship" from
> BMC_CORE_CONFIG_BMC_ConfigB159
>
>
>
> and on another, clean install of 7.6.04:
>
> select count(*) as "BMC.CORE.CONFIG:BMC_ConfigBaseElement" from
> BMC_CORE_CONFIG_BMC_ ConfigB456
>
> select count(*) as "BMC.CORE.CONFIG:BMC_ConfigBaseRelationship" from
> BMC_CORE_CONFIG_BMC_ConfigBase
>
>
>
> Yes, they are reversed; beware!  The same viewName on different server may
> point at completely a different form from within the set of those with
> common name elements.  You will have to edit some of the sql scripts in \BMC
> Software\Migrator\migrator\DeltaDataMigration\Utilities to fit EVERY server
> that you use them on – in my case there were differences in
> AR_7604_Forms_Count.sql, Atrium_7604_Forms_Count.sql, and
> RKM_7604_Forms_Count.sql.
>
>
>
> Why am I this far down in the weeds on a Friday afternoon???
>
>
>
> Christopher Strauss, Ph.D.
> Call Tracking Administration Manager
> Univer

7.6.04 Overlays

[Grooms, Frederick W]

I have a question about the overlays...  How will this affect me since I work 
on all 100% home grown custom (no BMC applications at all) systems?  The only 
forms from BMC are the ARS system core forms (User, Group, DSO, Email Engine, 
...).   My systems are ARS 7.1 (I was in the process of upgrading to 7.6.03 
when we found a bug that caused us to hold and wait for a patch from BMC).  I 
have zero use for the overlays.  

Fred

Re: 7.6.04 Overlays

[strauss]

Just work entirely in Base Development mode in Developer Studio - it is 
_supposed_ to be the same as working in Dev Studio 7.6.03 or earlier, or the 
Admin Tool.

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing & IT Center
http://itsm.unt.edu/

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Monday, May 02, 2011 9:39 AM
To: arslist@ARSLIST.ORG
Subject: 7.6.04 Overlays

I have a question about the overlays...  How will this affect me since I work 
on all 100% home grown custom (no BMC applications at all) systems?  The only 
forms from BMC are the ARS system core forms (User, Group, DSO, Email Engine, 
...).   My systems are ARS 7.1 (I was in the process of upgrading to 7.6.03 
when we found a bug that caused us to hold and wait for a patch from BMC).  I 
have zero use for the overlays.  

Fred

Re: More FUN with 7.6.04 Form Overlays

[strauss]

Hah – I think I figured one of these out.  I remembered that Matt - posting on 
BMCDN – had told me that the BPCU strips all of the permissions from custom 
fields when it moves them to the overlay layer (not documented).  I had 
forgotten that it ALSO strips all of the enumerations/attributes from custom 
selection fields (also not documented).  In order to restore your custom fields 
after running BPCU, there has to be a new step PRIOR to Step 11 where you 
compare every custom field to the originals on your 7.1 or other pre-7.6.04 
server that you are upgrading from, and you have to restore all of the 
permissions to every field, AND all of the selection values.  Otherwise you get 
to the point where I am, with a reference server, staging server, and 
pre-production server (where the latter lacks overlays and custom fields 
entirely), and the reference server and staging server BOTH have the custom 
fields MINUS their permissions and enumerations, so the problem isn’t obvious 
in migrator when you are working through Step 14.  I’m having to go back and 
audit all of the custom fields between my 7.1 server and the staging server, 
and manually correct each one, before I can migrate them to the pre-production 
server.

The BPCU really IS a complete piece of crap, isn’t it?

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing & IT Center
http://itsm.unt.edu/
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of strauss
Sent: Friday, April 29, 2011 2:45 PM
To: arslist@ARSLIST.ORG
Subject: Re: More FUN with 7.6.04 Form Overlays

Both schemas – HPD:Help Desk, and there is no HPD:Help Desk__o - have the same 
viewName and shViewName - HPD_Help_Desk and SH_HPD_Help_Desk, respectively, and 
both resolve to T table 993.  The only differences I see in arschema between 
the two are:

The overlay has an overlayProp of 2 (origin or base form has 1) and the overlay 
has overlayGroup = 1 instead of NULL
The overlay has a different schemaId and value in maxStatEnums (whatever that 
is)
The overlay has 26 more fields than the base form

…it _should_ have 29 more fields, but there are three selection fields that 
absolutely refuse to migrate from the staging server.  They all throw this 
error in migrator:

47

Errors results for Fields

48

Source Name

Type

Number

Message

49

70831

Migration Error

3700

Unable to create field : 70831

50

70831

AR System Error

113

Name list parameter is empty


I’m almost to the point where I re-create the custom fields that won’t migrate 
by hand…

7.6.04 seems to pop new errors up daily.  The “AR System Error 113 Name list 
parameter is empty” is a favorite of Migrator.  DevStudio is regaling me with a 
continuous stream of “Required name parameter (or name field in a parameter) is 
empty  - Code 102” errors when I try to save the HPD:Help Desk form on the 
staging server.  This is after every successful save, after it has created a 
bizarre Custom Audit form (with no name) at the top of the Forms list.  If you 
close the form without saving (your changes were committed to the db), and 
reload the forms list it goes away, and then you get one more edit and save in 
before doing it all again.

This _could_ be construed as Friday humor, but I haven’t been laughing.

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing & IT Center
http://itsm.unt.edu/
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Friday, April 29, 2011 12:20 PM
To: arslist@ARSLIST.ORG
Subject: Re: More FUN with 7.6.04 Form Overlays

**
Chris,
I don’t run OOTB, so I can’t look specifically…but if you check in arschema, 
there is a column that defines the ‘view’ that is created for the T table.  Is 
the view for the overlay different than the view for the base object?  If it 
is, see if you can query out of the alternate view name properly…..

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of strauss
Sent: Friday, April 29, 2011 10:48 AM
To: arslist@ARSLIST.ORG
Subject: More FUN with 7.6.04 Form Overlays

Here’s one for you.  I was poking around in the Delta Data Migration 
directories this morning, and found the sql scripts for counting records in 
forms for each of the applications.  Some of them have more errors than correct 
lines, but that can be fixed; maybe the form names are instantiated differently 
on other SQL systems (maybe they were created against oracle?), but they were 
dead wrong for SQL Server 2008 (many form names too long and therefore 
unrecognized).  Also, a lot of the form names were invalid because they were 
missing underscores – I’m not sure how anyone could have compiled these scripts 
without ever testing them.  If this is what the DDM uses to run queries, there 
is no chance of it ever working correctly.

Anyway, I tried to run 

mid-tier work detail entry getting cut off

[Michael]

Hi everyone,

First:
7.6.03 Build 001 201008170035
Linux 2.6.18-194.26.1.el5
Mid Tier Version7.6.04 Build 002 201101141059

I have an interesting problem that I am going to open a support
request for, but was hoping someone here has seen this and knows the
fix.  I can reproduce this on demand in an Incident ticket in ITSM,
though only in Mid-tier.

1.  Open an Incident ticket in new mode.

2.  Create a Work Detail entry by doing the following:

 2a.  In the notes field enter:
 line 1

 line 2

 line 3

 line 4


3.  Save and close the work detail entry.

4.  Reopen the same work detail, and the notes field is missing
anywhere form lines 2-4 or 3-4 depending on the browser.

Note this does not happen in IE, but in any version of firefox.  Also
Chrome and Safari will not let me type past line 2, which makes me
think it might be a length issue, but I can't find anything set for
the notes field except 0 length at the moment.

Any ideas?

thank you,
-- 
Michael Hirst
University of Arizona,
UITS
520-621-0867

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: 7.6.04 Overlays

[Noppadol Chaloempanpipat]

Dear Sirs,

Please remove my email from the list.
Thank you.

Best Regards,

nchaloem...@yahoo.com

--- On Mon, 5/2/11, Grooms, Frederick W  wrote:

> From: Grooms, Frederick W 
> Subject: 7.6.04 Overlays
> To: arslist@ARSLIST.ORG
> Date: Monday, May 2, 2011, 9:39 PM
> I have a question about the
> overlays...  How will this affect me since I work on
> all 100% home grown custom (no BMC applications at all)
> systems?  The only forms from BMC are the ARS system
> core forms (User, Group, DSO, Email Engine,
> ...).   My systems are ARS 7.1 (I was in the
> process of upgrading to 7.6.03 when we found a bug that
> caused us to hold and wait for a patch from BMC).  I
> have zero use for the overlays.  
> 
> Fred
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: unsubscribe

[Noppadol Chaloempanpipat]

Dear sirs,
 
Please remove my email from the list.
Thank you.
 
Regards,
 
nchaloem...@yahoo.com

--- On Sat, 4/30/11, Bhakta, Anita  wrote:


From: Bhakta, Anita 
Subject: unsubscribe
To: arslist@ARSLIST.ORG
Date: Saturday, April 30, 2011, 2:54 AM


** 



 _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: 7.6.4 ARS Install, Email Engine Issue

[Joe Martin D'Souza]

You could also try looking into the Events Viewer to see if it tells you 
anything under the Application Event Logs or System Events Logs...

Before installing also make sure you have a compatible Java. I have installed 
on a similar configuration as yours and have had no problems. I had used 64 bit 
Java of the latest available version during the 2nd week of the release of AR 
System 7.6.04..

Joe

From: Kevin Begosh 
Sent: Monday, May 02, 2011 9:06 AM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG 
Subject: Re: 7.6.4 ARS Install, Email Engine Issue

** 
LJ,
The email engine itself is not an entry in the add remove programs but I did 
run the uninstall for ARS and chose email and then re-installed it and I got 
the same result.  Maybe I could try for a third time :).

Thanks for the response.

Kevin


On Sun, May 1, 2011 at 9:26 PM, LJ LongWing  wrote:

  ** 
  Kevin,

  In both 7.5 and 7.6.4 installs I found that the Email engine and the 
Flashboard server didn’t install, I had to go into the add/remove programs, 
uninstall those components, and re-run the install to get them installed 
properly.



  From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kevin Begosh
  Sent: Sunday, May 01, 2011 4:26 PM
  To: arslist@ARSLIST.ORG
  Subject: 7.6.4 ARS Install, Email Engine Issue



  ** 

  List,

  I am installing ARS, ITSM CMDB etc... 7.6.4.  I went to install the ASServer 
peice first on a windows 2008 64 bit server and a SQL 2008 DB.  The install 
appear to work okay expect the email engine failed the sanity check, it said 
Email Engine is down.  When I went to services to try and start it, it does not 
exist.  I went to the registry and there is an entry there but no service.  Has 
anyone seen this?

  -- 
  Kevin Begosh

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: mid-tier work detail entry getting cut off

[Joe Martin D'Souza]

Did you try clicking on the Expand Box to the right of the field to see if 
you can see the remainder of the lines? If you do not, try resizing the 
expand box manually by pulling its left bottom corner. I have seen a few 
funny behaviors while editing from Expand Boxes where you need to pull at 
that corner to see the entire field content.. I'm doubting it’s a related 
problem but still worth a try..


Joe

-Original Message- 
From: Michael
Sent: Monday, May 02, 2011 12:00 PM Newsgroups: 
public.remedy.arsystem.general

To: arslist@ARSLIST.ORG
Subject: mid-tier work detail entry getting cut off

Hi everyone,

First:
7.6.03 Build 001 201008170035
Linux 2.6.18-194.26.1.el5
Mid Tier Version 7.6.04 Build 002 201101141059

I have an interesting problem that I am going to open a support request for, 
but was hoping someone here has seen this and knows the fix.  I can 
reproduce this on demand in an Incident ticket in ITSM, though only in 
Mid-tier.


1.  Open an Incident ticket in new mode.

2.  Create a Work Detail entry by doing the following:

2a.  In the notes field enter:
line 1

line 2

line 3

line 4


3.  Save and close the work detail entry.

4.  Reopen the same work detail, and the notes field is missing anywhere 
form lines 2-4 or 3-4 depending on the browser.


Note this does not happen in IE, but in any version of firefox.  Also Chrome 
and Safari will not let me type past line 2, which makes me think it might 
be a length issue, but I can't find anything set for the notes field except 
0 length at the moment.


Any ideas?

thank you,
--
Michael Hirst
University of Arizona,
UITS
520-621-0867 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: 7.6.4 ARS Install, Email Engine Issue

[Kevin Begosh]

Joe,
I will look at the events viewer to see.  I actually have a 64bit and 32 bit
JRE because they want to use MAPI.  I used 64 bit for the plugin and 32 bit
for the email engine per the documentation.

On Mon, May 2, 2011 at 1:49 PM, Joe Martin D'Souza wrote:

> **
>
> You could also try looking into the Events Viewer to see if it tells you
> anything under the Application Event Logs or System Events Logs...
>
> Before installing also make sure you have a compatible Java. I have
> installed on a similar configuration as yours and have had no problems. I
> had used 64 bit Java of the latest available version during the 2nd week of
> the release of AR System 7.6.04..
>
> Joe
>
>  *From:* Kevin Begosh 
> *Sent:* Monday, May 02, 2011 9:06 AM
> *Newsgroups:* public.remedy.arsystem.general
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: 7.6.4 ARS Install, Email Engine Issue
>
> **
>  LJ,
> The email engine itself is not an entry in the add remove programs but I
> did run the uninstall for ARS and chose email and then re-installed it and I
> got the same result.  Maybe I could try for a third time :).
>
> Thanks for the response.
>
> Kevin
>
> On Sun, May 1, 2011 at 9:26 PM, LJ LongWing  wrote:
>
>> **
>>
>> Kevin,
>>
>> In both 7.5 and 7.6.4 installs I found that the Email engine and the
>> Flashboard server didn’t install, I had to go into the add/remove programs,
>> uninstall those components, and re-run the install to get them installed
>> properly.
>>
>>
>>
>> *From:* Action Request System discussion list(ARSList) [mailto:
>> arslist@ARSLIST.ORG] *On Behalf Of *Kevin Begosh
>> *Sent:* Sunday, May 01, 2011 4:26 PM
>> *To:* arslist@ARSLIST.ORG
>> *Subject:* 7.6.4 ARS Install, Email Engine Issue
>>
>>
>>
>> **
>>
>> List,
>>
>> I am installing ARS, ITSM CMDB etc... 7.6.4.  I went to install the
>> ASServer peice first on a windows 2008 64 bit server and a SQL 2008 DB.  The
>> install appear to work okay expect the email engine failed the sanity check,
>> it said Email Engine is down.  When I went to services to try and start it,
>> it does not exist.  I went to the registry and there is an entry there but
>> no service.  Has anyone seen this?
>>
>> --
>> Kevin Begosh
>>
>  _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
>



-- 
Kevin Begosh

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: mid-tier work detail entry getting cut off

[Michael]

Hi Joe,

Yes I tried that, and just went and double checked to make sure...it
appears to be cutting of the text after a set amount, although it does
not do this in IE.

And yes, definitely worth a try, but no luck.

thanks!
Michael



On Mon, May 2, 2011 at 10:57 AM, Joe Martin D'Souza  wrote:
> Did you try clicking on the Expand Box to the right of the field to see if
> you can see the remainder of the lines? If you do not, try resizing the
> expand box manually by pulling its left bottom corner. I have seen a few
> funny behaviors while editing from Expand Boxes where you need to pull at
> that corner to see the entire field content.. I'm doubting it’s a related
> problem but still worth a try..
>
> Joe
>
> -Original Message-
> From: Michael
> Sent: Monday, May 02, 2011 12:00 PM Newsgroups:
> public.remedy.arsystem.general
> To: arslist@ARSLIST.ORG
> Subject: mid-tier work detail entry getting cut off
>
> Hi everyone,
>
> First:
> 7.6.03 Build 001 201008170035
> Linux 2.6.18-194.26.1.el5
> Mid Tier Version 7.6.04 Build 002 201101141059
>
> I have an interesting problem that I am going to open a support request for,
> but was hoping someone here has seen this and knows the fix.  I can
> reproduce this on demand in an Incident ticket in ITSM, though only in
> Mid-tier.
>
> 1.  Open an Incident ticket in new mode.
>
> 2.  Create a Work Detail entry by doing the following:
>
>     2a.  In the notes field enter:
>         line 1
>
>         line 2
>
>         line 3
>
>         line 4
>
>
> 3.  Save and close the work detail entry.
>
> 4.  Reopen the same work detail, and the notes field is missing anywhere
> form lines 2-4 or 3-4 depending on the browser.
>
> Note this does not happen in IE, but in any version of firefox.  Also Chrome
> and Safari will not let me type past line 2, which makes me think it might
> be a length issue, but I can't find anything set for the notes field except
> 0 length at the moment.
>
> Any ideas?
>
> thank you,
> --
> Michael Hirst
> University of Arizona,
> UITS
> 520-621-0867
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>
>



-- 
Michael Hirst
University of Arizona,
UITS
520-621-0867

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: More FUN with 7.6.04 Form Overlays

[Jason Miller]

Chris, are you suggesting: *B*ig *P*iece of *C*rap *U*tility?

Jason

On Mon, May 2, 2011 at 8:59 AM, strauss  wrote:

> Hah – I think I figured one of these out.  I remembered that Matt - posting
> on BMCDN – had told me that the BPCU strips all of the permissions from
> custom fields when it moves them to the overlay layer (not documented).  I
> had forgotten that it ALSO strips all of the enumerations/attributes from
> custom selection fields (also not documented).  In order to restore your
> custom fields after running BPCU, there has to be a new step PRIOR to Step
> 11 where you compare every custom field to the originals on your 7.1 or
> other pre-7.6.04 server that you are upgrading from, and you have to restore
> all of the permissions to every field, AND all of the selection values.
> Otherwise you get to the point where I am, with a reference server, staging
> server, and pre-production server (where the latter lacks overlays and
> custom fields entirely), and the reference server and staging server BOTH
> have the custom fields MINUS their permissions and enumerations, so the
> problem isn’t obvious in migrator when you are working through Step 14.  I’m
> having to go back and audit all of the custom fields between my 7.1 server
> and the staging server, and manually correct each one, before I can migrate
> them to the pre-production server.
>
>
>
> The BPCU really IS a complete piece of crap, isn’t it?
>
>
>
> Christopher Strauss, Ph.D.
> Call Tracking Administration Manager
> University of North Texas Computing & IT Center
> http://itsm.unt.edu/
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *strauss
> *Sent:* Friday, April 29, 2011 2:45 PM
>
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: More FUN with 7.6.04 Form Overlays
>
>
>
> Both schemas – HPD:Help Desk, and there is no HPD:Help Desk__o - have the
> same viewName and shViewName - HPD_Help_Desk and SH_HPD_Help_Desk,
> respectively, and both resolve to T table 993.  The only differences I see
> in arschema between the two are:
>
>
>
> The overlay has an overlayProp of 2 (origin or base form has 1) and the
> overlay has overlayGroup = 1 instead of NULL
>
> The overlay has a different schemaId and value in maxStatEnums (whatever
> that is)
>
> The overlay has 26 more fields than the base form
>
>
>
> …it _*should*_ have 29 more fields, but there are three selection fields
> that absolutely refuse to migrate from the staging server.  They all throw
> this error in migrator:
>
>
>
> *47***
>
> *Errors results for Fields*
>
> *48***
>
> Source Name
>
> Type
>
> Number
>
> Message
>
> *49***
>
> 70831
>
> Migration Error
>
> 3700
>
> Unable to create field : 70831
>
> *50***
>
> 70831
>
> AR System Error
>
> 113
>
> Name list parameter is empty
>
>
>
> I’m almost to the point where I re-create the custom fields that won’t
> migrate by hand…
>
>
>
> 7.6.04 seems to pop new errors up daily.  The “AR System Error 113 Name
> list parameter is empty” is a favorite of Migrator.  DevStudio is regaling
> me with a continuous stream of “Required name parameter (or name field in a
> parameter) is empty  - Code 102” errors when I try to save the HPD:Help Desk
> form on the staging server.  This is after every successful save, after it
> has created a bizarre Custom Audit form (with no name) at the top of the
> Forms list.  If you close the form without saving (your changes were
> committed to the db), and reload the forms list it goes away, and then you
> get one more edit and save in before doing it all again.
>
>
>
> This _*could*_ be construed as Friday humor, but I haven’t been laughing.
>
>
>
> Christopher Strauss, Ph.D.
> Call Tracking Administration Manager
> University of North Texas Computing & IT Center
> http://itsm.unt.edu/
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *LJ LongWing
> *Sent:* Friday, April 29, 2011 12:20 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: More FUN with 7.6.04 Form Overlays
>
>
>
> **
>
> Chris,
>
> I don’t run OOTB, so I can’t look specifically…but if you check in
> arschema, there is a column that defines the ‘view’ that is created for the
> T table.  Is the view for the overlay different than the view for the base
> object?  If it is, see if you can query out of the alternate view name
> properly…..
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *strauss
> *Sent:* Friday, April 29, 2011 10:48 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* More FUN with 7.6.04 Form Overlays
>
>
>
> Here’s one for you.  I was poking around in the Delta Data Migration
> directories this morning, and found the sql scripts for counting records in
> forms for each of the applications.  Some of them have more errors than
> correct lines, but that can be fixed; maybe the form names are instantiated
> differently on other SQL systems (maybe they were create

Relating multiple CI's to a change template results in production AND discovery datasets

[Chris Danaceau]

ITSM 7.6.03
ARS 7.6.03
 
I have a customer who wants a Change Template for Windows Server patches.   The 
template would include all matching windows servers.   When I relate them one 
at a time things work just fine.  When I select more than one to relate, the 
application creates CHG:Template Association records for the BMC.ASSET dataset 
AND my staging Dataset.   Ran AL and filter logs on this and did not see the 
second create.  
 
Has anyone else run into this?
 
 
-- 
Chris Danaceau
AttivaSoft Solutions Architect

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Setting Application-Generate-GUID via SQL

[Pruitt, Christopher (Bank of America Account)]

Does anyone on the list know how to perform this process via SQL Update 
statement.

$PROCESS$ Application-Generate-GUID

We have been trying to do it via a filter for thousands of records to generate 
a GUID value into a field where it is missing.

We can do it in very small batches, 10-20 records at a time but like I seen we 
have over 1000 to update and wanted to know if anyone had a way of doing it via 
a SQL Update statement.

Our environment.
ARS v 7.1 patch 9
Oracle 10g
SunOS 5.9


Christopher Pruitt
Business Consulting III
HP Enterprises Services
christopher.pru...@hp.com
www.hp.com


Confidentiality Notice: This message and any files transmitted with it are 
intended for the sole use of the entity or individual to whom it is addressed, 
and may contain information that is confidential, privileged, and exempt from 
disclosure under applicable law. If you are not the intended addressee for this 
e-mail, you are hereby notified that any copying, distribution, or 
dissemination of this e-mail is strictly prohibited. If you have received this 
e-mail in error, please immediately destroy, erase, or discard this message. 
Please notify the sender immediately by return e-mail if you have received this 
e-mail by mistake.




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
<>

WWWRUG 11 - Hotel Expense

[Peter Romain]

For anyone knowing the area of the conference centre that the RUG is being
held in, is there a cheaper hotel option?

 

The conference is £1250, flight from the UK ~ $950 but the hotel is $1311 !

 

As I’m paying myself I’d be happy with a Days Inn or other cheap and
cheerful chain. However, I don’t intend getting a car so walking distance
would be good.

 

I’ve done some searching and the conference centre is a bit out of the way
so maybe that’s why the hotel can charge this much.

 

Cheers

 

Peter

 

 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Setting Application-Generate-GUID via SQL

[Peter Romain]

Do you need a 36 character GUID or just a unique ID?

If the latter why not update the GUID field with the RequestID field
appended with some other characters to make it unique?

Cheers

Peter

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Pruitt, Christopher (Bank of
America Account)
Sent: 02 May 2011 20:31
To: arslist@ARSLIST.ORG
Subject: Setting Application-Generate-GUID via SQL

Does anyone on the list know how to perform this process via SQL Update
statement.

$PROCESS$ Application-Generate-GUID

We have been trying to do it via a filter for thousands of records to
generate a GUID value into a field where it is missing.

We can do it in very small batches, 10-20 records at a time but like I seen
we have over 1000 to update and wanted to know if anyone had a way of doing
it via a SQL Update statement.

Our environment.
ARS v 7.1 patch 9
Oracle 10g
SunOS 5.9


Christopher Pruitt
Business Consulting III
HP Enterprises Services
christopher.pru...@hp.com
www.hp.com


Confidentiality Notice: This message and any files transmitted with it are
intended for the sole use of the entity or individual to whom it is
addressed, and may contain information that is confidential, privileged, and
exempt from disclosure under applicable law. If you are not the intended
addressee for this e-mail, you are hereby notified that any copying,
distribution, or dissemination of this e-mail is strictly prohibited. If you
have received this e-mail in error, please immediately destroy, erase, or
discard this message. Please notify the sender immediately by return e-mail
if you have received this e-mail by mistake.





___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11
www.wwrug.com ARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Setting Application-Generate-GUID via SQL

[Andrew C Goodall]

Perhaps - http://www.dbasupport.com/forums/showthread.php?t=23871


Regards,
 
Andrew Goodall
Software Engineer 2 | Development Services |  jcpenney . www.jcp.com  

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Pruitt, Christopher (Bank of
America Account)
Sent: Monday, May 02, 2011 2:31 PM
To: arslist@ARSLIST.ORG
Subject: Setting Application-Generate-GUID via SQL

Does anyone on the list know how to perform this process via SQL Update
statement.

$PROCESS$ Application-Generate-GUID

We have been trying to do it via a filter for thousands of records to
generate a GUID value into a field where it is missing.

We can do it in very small batches, 10-20 records at a time but like I
seen we have over 1000 to update and wanted to know if anyone had a way
of doing it via a SQL Update statement.

Our environment.
ARS v 7.1 patch 9
Oracle 10g
SunOS 5.9


Christopher Pruitt
Business Consulting III
HP Enterprises Services
christopher.pru...@hp.com
www.hp.com


Confidentiality Notice: This message and any files transmitted with it
are intended for the sole use of the entity or individual to whom it is
addressed, and may contain information that is confidential, privileged,
and exempt from disclosure under applicable law. If you are not the
intended addressee for this e-mail, you are hereby notified that any
copying, distribution, or dissemination of this e-mail is strictly
prohibited. If you have received this e-mail in error, please
immediately destroy, erase, or discard this message. Please notify the
sender immediately by return e-mail if you have received this e-mail by
mistake.





___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged 
material.  If the reader of this message is not the intended recipient,
you are hereby notified that your access is unauthorized, and any review,
dissemination, distribution or copying of this message including any 
attachments is strictly prohibited.  If you are not the intended
recipient, please contact the sender and delete the material from any
computer.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: mid-tier work detail entry getting cut off

[Joe Martin D'Souza]

It appears to be a bug. You may want to report this behavior.

You may want to turn on mid-tier logging for a user and see what you see in 
that logging just in case there is workflow somehow truncating the field..


Its probably what Remedy Support may ask you to do anyways - turn on 
mid-tier logging and maybe even run fiddler logs..


Joe

-Original Message- 
From: Michael
Sent: Monday, May 02, 2011 2:34 PM Newsgroups: 
public.remedy.arsystem.general

To: arslist@ARSLIST.ORG
Subject: Re: mid-tier work detail entry getting cut off

Hi Joe,

Yes I tried that, and just went and double checked to make sure...it appears 
to be cutting of the text after a set amount, although it does not do this 
in IE.


And yes, definitely worth a try, but no luck.

thanks!
Michael



On Mon, May 2, 2011 at 10:57 AM, Joe Martin D'Souza  
wrote:

Did you try clicking on the Expand Box to the right of the field to see if
you can see the remainder of the lines? If you do not, try resizing the
expand box manually by pulling its left bottom corner. I have seen a few
funny behaviors while editing from Expand Boxes where you need to pull at
that corner to see the entire field content.. I'm doubting it’s a related
problem but still worth a try..

Joe

-Original Message-
From: Michael
Sent: Monday, May 02, 2011 12:00 PM Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: mid-tier work detail entry getting cut off

Hi everyone,

First:
7.6.03 Build 001 201008170035
Linux 2.6.18-194.26.1.el5
Mid Tier Version 7.6.04 Build 002 201101141059

I have an interesting problem that I am going to open a support request 
for,

but was hoping someone here has seen this and knows the fix.  I can
reproduce this on demand in an Incident ticket in ITSM, though only in
Mid-tier.

1.  Open an Incident ticket in new mode.

2.  Create a Work Detail entry by doing the following:

2a.  In the notes field enter:
line 1

line 2

line 3

line 4


3.  Save and close the work detail entry.

4.  Reopen the same work detail, and the notes field is missing anywhere
form lines 2-4 or 3-4 depending on the browser.

Note this does not happen in IE, but in any version of firefox.  Also 
Chrome

and Safari will not let me type past line 2, which makes me think it might
be a length issue, but I can't find anything set for the notes field 
except

0 length at the moment.

Any ideas?

thank you,
--
Michael Hirst
University of Arizona,
UITS
520-621-0867 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

What has happened to the ARSlist archives?

[Martin, Dwayne - martinrd]

Dear List,

For years I've been using 
http://listserv.rbugs.com/cgi-bin/wa.exe?S1=arslist&X=- to see the ARSList 
archives.  But now I am getting:

"The connection to the server was reset while the page was loading."

Has something changed  or is something wrong at my end?

Dwayne Martin
James Madison University

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Server name in notification

[Joe Martin D'Souza]

William,

The ARS has a few places where even though you configure the short name (as you 
are supposed to), the engine queries for the domain name and appends it to the 
server name you provide. In such cases if you configure the FQDN, the resulting 
name would be myserver.domain.com.domain.com which is worse..

What generally works well is configuring short names everywhere at ARS level, 
and then configuring the mid tier configuration with the long name..

Joe

From: William Rentfrow 
Sent: Monday, May 02, 2011 2:58 PM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG 
Subject: Server name in notification

** 
If you check the checkbox to include a URL to the entry in the email – where 
does it get the AR Server name from?

 

For example, our URL looks like this:

 

http://midtier/arsys/servlet/ViewFormServlet?form=NTE%3aNotifier&server=Myserver.Domain.Com&eid=NTS0383

 

myserver.domain.com isn’t configured in the mid-tier and consequently we get an 
error.

 

How the “myserver.domain.com” part is goes into the URL is a mystery to me.  
All of our servers are currently configured with a short name (e.g., myserver 
instead of myserver.domain.com) and the only place the FQDN exists is as an 
IP-Name entry in the ar.conf file.

 

The actual server name is the short name.  Everything else I can find is the 
short name.

 

Thanks in advance…

 

 

William Rentfrow

Principal Consultant, StrataCom

www.stratacominc.com

715-410-8056 (C)

Personal Blog: www.williamrentfrow.com

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Setting Application-Generate-GUID via SQL

[Pruitt, Christopher (Bank of America Account)]

Thanks Andrew,

That is just want I needed.

Christopher Pruitt 
Business Consulting III 
HP Enterprises Services
christopher.pru...@hp.com
www.hp.com 


Confidentiality Notice: This message and any files transmitted with it are 
intended for the sole use of the entity or individual to whom it is addressed, 
and may contain information that is confidential, privileged, and exempt from 
disclosure under applicable law. If you are not the intended addressee for this 
e-mail, you are hereby notified that any copying, distribution, or 
dissemination of this e-mail is strictly prohibited. If you have received this 
e-mail in error, please immediately destroy, erase, or discard this message. 
Please notify the sender immediately by return e-mail if you have received this 
e-mail by mistake.
-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew C Goodall
Sent: Monday, May 02, 2011 2:36 PM
To: arslist@ARSLIST.ORG
Subject: Re: Setting Application-Generate-GUID via SQL

Perhaps - http://www.dbasupport.com/forums/showthread.php?t=23871


Regards,
 
Andrew Goodall
Software Engineer 2 | Development Services |  jcpenney . www.jcp.com  

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Pruitt, Christopher (Bank of
America Account)
Sent: Monday, May 02, 2011 2:31 PM
To: arslist@ARSLIST.ORG
Subject: Setting Application-Generate-GUID via SQL

Does anyone on the list know how to perform this process via SQL Update
statement.

$PROCESS$ Application-Generate-GUID

We have been trying to do it via a filter for thousands of records to
generate a GUID value into a field where it is missing.

We can do it in very small batches, 10-20 records at a time but like I
seen we have over 1000 to update and wanted to know if anyone had a way
of doing it via a SQL Update statement.

Our environment.
ARS v 7.1 patch 9
Oracle 10g
SunOS 5.9


Christopher Pruitt
Business Consulting III
HP Enterprises Services
christopher.pru...@hp.com
www.hp.com


Confidentiality Notice: This message and any files transmitted with it
are intended for the sole use of the entity or individual to whom it is
addressed, and may contain information that is confidential, privileged,
and exempt from disclosure under applicable law. If you are not the
intended addressee for this e-mail, you are hereby notified that any
copying, distribution, or dissemination of this e-mail is strictly
prohibited. If you have received this e-mail in error, please
immediately destroy, erase, or discard this message. Please notify the
sender immediately by return e-mail if you have received this e-mail by
mistake.





___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged 
material.  If the reader of this message is not the intended recipient,
you are hereby notified that your access is unauthorized, and any review,
dissemination, distribution or copying of this message including any 
attachments is strictly prohibited.  If you are not the intended
recipient, please contact the sender and delete the material from any
computer.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: WWWRUG 11 - Hotel Expense

[Warren R. Baltimore II]

Peter,

While DC is in no way as expensive as say London, it still isn't cheap.  You
might want to take a look at Hotels.com or priceline.  You may be able to
find something a bit less pricey.

Maybe I should rent out space in my basement!  I could make a fortune
The only problem is getting everyone to and from my house in Maryland...
especially after a happy hours!

Good luck!

On Mon, May 2, 2011 at 3:31 PM, Peter Romain <
p.romain.arsl...@parsolutions.co.uk> wrote:

> **
>
> For anyone knowing the area of the conference centre that the RUG is being
> held in, is there a cheaper hotel option?
>
>
>
> The conference is £1250, flight from the UK ~ $950 but the hotel is $1311 !
>
>
>
> As I’m paying myself I’d be happy with a Days Inn or other cheap and
> cheerful chain. However, I don’t intend getting a car so walking distance
> would be good.
>
>
>
> I’ve done some searching and the conference centre is a bit out of the way
> so maybe that’s why the hotel can charge this much.
>
>
>
> Cheers
>
>
>
> Peter
>
>
>
>
> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_




-- 
Warren R. Baltimore II
Remedy Developer
410-533-5367

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Server name in notification

[Danny Kellett]

Hi,

 

I think this is the value that's in the Server-Name in the ar.cfg files. 

 

If you change this to the short name e.g. myserver then do two things:

 

1 - Make sure the local arserver can ping that name and that the reply IP is
the actual local machine. Normally I add this to the local hosts (windows)
or /etc/hosts on *NIX

2 - in the ar.cfg file add the following line 

IP-Name: myserver.domain.com

 

Kind regards

Danny

 

Single Sign On (SSO) for the BMC Remedy AR System and ITSM

http://www.javasystemsolutions.com/jss/ssoplugin

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow
Sent: 02 May 2011 19:58
To: arslist@ARSLIST.ORG
Subject: Server name in notification

 

** 

If you check the checkbox to include a URL to the entry in the email - where
does it get the AR Server name from?

 

For example, our URL looks like this:

 

http://midtier/arsys/servlet/ViewFormServlet?form=NTE%3aNotifier

&server=Myserver.Domain.Com&eid=NTS0383

 

myserver.domain.com isn't configured in the mid-tier and consequently we get
an error.

 

How the "myserver.domain.com" part is goes into the URL is a mystery to me.
All of our servers are currently configured with a short name (e.g.,
myserver instead of myserver.domain.com) and the only place the FQDN exists
is as an IP-Name entry in the ar.conf file.

 

The actual server name is the short name.  Everything else I can find is the
short name.

 

Thanks in advance.

 

 

William Rentfrow

Principal Consultant, StrataCom

www.stratacominc.com

715-410-8056 (C)

Personal Blog: www.williamrentfrow.com

 

_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"