Re: Help with odd set of SQL operations by ARS

[Charlie Lotridge]

Great suggestion, thank you. That revealed the misbehaving mid-tier.

Unfortunately I don't have access to the machine and my colleague, who set
it up (as a test bed for something) is out of town, but I'm going to have
him shut it down to resolve this issue.

Thanks again!

On Mon, Jun 18, 2018 at 8:51 AM, LJ LongWing  wrote:

> It MIGHT be useful if we also had API loggingAPI logging would tell us
> definitively if it was Mid-Tier doing the call (which is what it looks
> like)...but it would also tell you the source IP of the machine making the
> callI have never seen this behavior before but I suspect it might be
> related to caching somehowonce you know which of your mid-tier servers
> is causing it you can shut it down to verify that it stops when it's not
> running, and maybe do a hard cache flush to try and clean up whatever might
> be wonky.
>
> On Mon, Jun 18, 2018 at 8:47 AM Charlie Lotridge 
> wrote:
>
>> Hi,
>>
>> I'm not exactly sure when this started, but within the past few weeks my
>> production ARS has started repeatedly issuing the following three SQL
>> statements:
>>
>>
>> *SELECT  TOP 2  T127.C1,C124 FROM T127 WHERE (T127.C101 = N'MidTier
>> Service') ORDER BY 1 ASC*
>>
>> *SELECT MAX(timestamp) FROM user_cache*
>>
>> *SELECT MAX(timestamp) FROM group_cache*
>>
>> T127 is the User form.
>>
>> It's doing this about 10 times per second.
>>
>> Can anyone shed any light on what it's doing and how I can stop it? Any
>> help would be appreciated.
>>
>> Here is the raw SQL logging should the additional detail be useful:
>>
>>
>>  > Service -->  /* Mon Jun 18 2018 07:34:34.8220
>> */SELECT  TOP 2  T127.C1,C124 FROM T127 WHERE (T127.C101 = N'MidTier
>> Service') ORDER BY 1 ASC
>>
>>  > Service -->  /* Mon Jun 18 2018 07:34:34.8230
>> */OK
>>
>>  > >  /* Mon Jun 18 2018 07:34:34.8570 */SELECT
>> MAX(timestamp) FROM user_cache
>>
>>  > >  /* Mon Jun 18 2018 07:34:34.8580 */OK
>>
>>  > >  /* Mon Jun 18 2018 07:34:34.8580 */SELECT
>> MAX(timestamp) FROM group_cache
>>
>>  > >  /* Mon Jun 18 2018 07:34:34.8580 */OK
>>
>> Thanks,
>> Charlie
>> --
>> 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: Help with odd set of SQL operations by ARS

[LJ LongWing]

It MIGHT be useful if we also had API loggingAPI logging would tell us
definitively if it was Mid-Tier doing the call (which is what it looks
like)...but it would also tell you the source IP of the machine making the
callI have never seen this behavior before but I suspect it might be
related to caching somehowonce you know which of your mid-tier servers
is causing it you can shut it down to verify that it stops when it's not
running, and maybe do a hard cache flush to try and clean up whatever might
be wonky.

On Mon, Jun 18, 2018 at 8:47 AM Charlie Lotridge 
wrote:

> Hi,
>
> I'm not exactly sure when this started, but within the past few weeks my
> production ARS has started repeatedly issuing the following three SQL
> statements:
>
>
> *SELECT  TOP 2  T127.C1,C124 FROM T127 WHERE (T127.C101 = N'MidTier
> Service') ORDER BY 1 ASC*
>
> *SELECT MAX(timestamp) FROM user_cache*
>
> *SELECT MAX(timestamp) FROM group_cache*
>
> T127 is the User form.
>
> It's doing this about 10 times per second.
>
> Can anyone shed any light on what it's doing and how I can stop it? Any
> help would be appreciated.
>
> Here is the raw SQL logging should the additional detail be useful:
>
>
>   Service -->  /* Mon Jun 18 2018 07:34:34.8220
> */SELECT  TOP 2  T127.C1,C124 FROM T127 WHERE (T127.C101 = N'MidTier
> Service') ORDER BY 1 ASC
>
>   Service -->  /* Mon Jun 18 2018 07:34:34.8230
> */OK
>
>   >  /* Mon Jun 18 2018 07:34:34.8570 */SELECT
> MAX(timestamp) FROM user_cache
>
>   >  /* Mon Jun 18 2018 07:34:34.8580 */OK
>
>   >  /* Mon Jun 18 2018 07:34:34.8580 */SELECT
> MAX(timestamp) FROM group_cache
>
>   >  /* Mon Jun 18 2018 07:34:34.8580 */OK
>
> Thanks,
> Charlie
> --
> 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: Help please Rest Sharp and Remedy REST API?

[LJ LongWing]

Mark,
I would recommend you take a look at a conversation that happened a few
weeks ago regarding integration of Remedy withSlack I think the app
was...the answers provided there are similar to what you can get here.

The difficulty that you will have in this is that the plugin I wrote
doesn't as of yet support OAUTH, so it might not be a solution that's ready
made for you at the moment, but if someone wanted to extend it to support
OAUTH, or if you were willing to wait for me to add it at some point in the
future...then it might serve the need.

On Wed, May 17, 2017 at 12:30 AM, Mark Christian Bautista <
mark.bauti...@macquarie.com> wrote:

> **
>
> Hi *Guys*,
>
> I’m currently working on a REST API Integration for our .net applications
> and I would like to ask if anyone has any experience working on REST
> Sharp/Remedy before?
>
> I would need to get some samples on how to use  Oauth implementation and
> then call another REST API to do POST.
>
>
> Appreciate your help, Thank you!
>
>
>
> Regards,
> Mark Bautista
>
> This email and any attachment is confidential. If you are not the intended
> recipient, please delete this message. Macquarie does not guarantee the
> integrity of any emails or attachments. For important disclosures and
> information about the incorporation and regulated status of Macquarie Group
> entities please see: www.macquarie.com/disclosures
> _ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Help with AIE

[Grooms, Frederick W]

I would be very afraid of a customer still on a 3.x or older version.
Think of trying to keep hardware that old running

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of David Charters
Sent: Friday, January 29, 2016 8:08 AM
To: arslist@ARSLIST.ORG
Subject: Re: Help with AIE

**
Ya, just an FYI for everyone, you can download documentation going back to 4.x 
including the original CRM product that is long since retired (sadly, because I 
really liked the CRM product). The only versions I have not been able to find 
is 3.x and back, but I can't say that I have even heard of a customer being on 
a 3.x version in at least 12 or 13 years.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Bala iLink
Sent: Friday, January 29, 2016 2:59 AM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: Help with AIE

**

Thanks Carl for pointing it out. I acknowledge the mistake..


From: Action Request System discussion list(ARSList) 
<arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>> on behalf of Carl Wilson 
<carlbwil...@gmail.com<mailto:carlbwil...@gmail.com>>
Sent: Friday, January 29, 2016 7:47 AM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: Help with AIE

**

Hi Bala,



> During data exchange, field mappings between remedy & the source system will 
> be defined. Since AIE is no longer available in the latest versions, you 
> cannot see the documents .



Incorrect, all legacy documentation is still available on the docs site:



https://docs.bmc.com/docs/display/public/ac7604/PDFs







Kind Regards,



Carl Wilson





From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of David Charters
Sent: 28 January 2016 16:26
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: Help with AIE



**

9.x no longer uses AIE, that is correct, however the 7.6.04 Admin Guide 
contains information about AIE. If you want me to send it to you off List just 
let me know, but you probably already have it I am guessing.



From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Bala iLink
Sent: Thursday, January 28, 2016 5:22 AM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: Help with AIE



**

Mark,



You need to define the data source & data exchanges for creating AIE jobs.



During data exchange, field mappings between remedy & the source system will be 
defined. Since AIE is no longer available in the latest versions, you cannot 
see the documents .

Thanks,

Bala



From: Action Request System discussion list(ARSList) 
<arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>> on behalf of Brittain, Mark 
<mbritt...@navisite.com<mailto:mbritt...@navisite.com>>
Sent: Friday, January 22, 2016 5:17 PM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Help with AIE



**

Hi All & TGIF,



I need to set an AIE job to get data from an external source each night and 
don't know where to start. I know what the external data is and where I want to 
put it.  I have looked at some of the AIE jobs previously set up and it's not 
jumping out at me how to get started. I did look for documentation at BMC but 
came up empty there. If anyone knows where I can find the documentation to get 
started, that would be much appreciated



ARS 7.6.04 SP5

ITSM 7.6.04 SP2



Thanks

Mark



Mark Brittain

Sr. OSD Systems Engineer

ITILv3 Foundation, Continual Service Improvement

NaviSite, Inc. - A Time Warner Cable Company

mbritt...@navisite.com<mailto:mbritt...@navisite.com>

Office: 315.634.9337

Mobile: 315.882.5360

[navsig]





___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Help with AIE

[David Charters]

Ya, just an FYI for everyone, you can download documentation going back to 4.x 
including the original CRM product that is long since retired (sadly, because I 
really liked the CRM product). The only versions I have not been able to find 
is 3.x and back, but I can't say that I have even heard of a customer being on 
a 3.x version in at least 12 or 13 years.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Bala iLink
Sent: Friday, January 29, 2016 2:59 AM
To: arslist@ARSLIST.ORG
Subject: Re: Help with AIE

**

Thanks Carl for pointing it out. I acknowledge the mistake..


From: Action Request System discussion list(ARSList) 
<arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>> on behalf of Carl Wilson 
<carlbwil...@gmail.com<mailto:carlbwil...@gmail.com>>
Sent: Friday, January 29, 2016 7:47 AM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: Help with AIE

**

Hi Bala,



> During data exchange, field mappings between remedy & the source system will 
> be defined. Since AIE is no longer available in the latest versions, you 
> cannot see the documents .



Incorrect, all legacy documentation is still available on the docs site:



https://docs.bmc.com/docs/display/public/ac7604/PDFs







Kind Regards,



Carl Wilson





From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of David Charters
Sent: 28 January 2016 16:26
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: Help with AIE



**

9.x no longer uses AIE, that is correct, however the 7.6.04 Admin Guide 
contains information about AIE. If you want me to send it to you off List just 
let me know, but you probably already have it I am guessing.



From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Bala iLink
Sent: Thursday, January 28, 2016 5:22 AM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: Help with AIE



**

Mark,



You need to define the data source & data exchanges for creating AIE jobs.



During data exchange, field mappings between remedy & the source system will be 
defined. Since AIE is no longer available in the latest versions, you cannot 
see the documents .

Thanks,

Bala



From: Action Request System discussion list(ARSList) 
<arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>> on behalf of Brittain, Mark 
<mbritt...@navisite.com<mailto:mbritt...@navisite.com>>
Sent: Friday, January 22, 2016 5:17 PM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Help with AIE



**

Hi All & TGIF,



I need to set an AIE job to get data from an external source each night and 
don't know where to start. I know what the external data is and where I want to 
put it.  I have looked at some of the AIE jobs previously set up and it's not 
jumping out at me how to get started. I did look for documentation at BMC but 
came up empty there. If anyone knows where I can find the documentation to get 
started, that would be much appreciated



ARS 7.6.04 SP5

ITSM 7.6.04 SP2



Thanks

Mark



Mark Brittain

Sr. OSD Systems Engineer

ITILv3 Foundation, Continual Service Improvement

NaviSite, Inc. - A Time Warner Cable Company

mbritt...@navisite.com<mailto:mbritt...@navisite.com>

Office: 315.634.9337

Mobile: 315.882.5360

[navsig]







This E-mail and any of its attachments may contain Time Warner Cable 
proprietary information, which is privileged, confidential, or subject to 
copyright belonging to Time Warner Cable. This E-mail is intended solely for 
the use of the individual or entity to which it is addressed. If you are not 
the intended recipient of this E-mail, you are hereby notified that any 
dissemination, distribution, copying, or action taken in relation to the 
contents of and attachments to this E-mail is strictly prohibited and may be 
unlawful. If you have received this E-mail in error, please notify the sender 
immediately and permanently delete the original and any copy of this E-mail and 
any printout.
_ARSlist: "Where the Answers Are" and have been for 20 years_

_ARSlist: "Where the Answers Are" and have been for 20 years_

_ARSlist: "Where the Answers Are" and have been for 20 years_
_ARSlist: "Where the Answers Are" and have been for 20 years_
_ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Help with AIE

[David Charters]

9.x no longer uses AIE, that is correct, however the 7.6.04 Admin Guide 
contains information about AIE. If you want me to send it to you off List just 
let me know, but you probably already have it I am guessing.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Bala iLink
Sent: Thursday, January 28, 2016 5:22 AM
To: arslist@ARSLIST.ORG
Subject: Re: Help with AIE

**

Mark,



You need to define the data source & data exchanges for creating AIE jobs.


During data exchange, field mappings between remedy & the source system will be 
defined. Since AIE is no longer available in the latest versions, you cannot 
see the documents .

Thanks,
Bala

From: Action Request System discussion list(ARSList) 
<arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>> on behalf of Brittain, Mark 
<mbritt...@navisite.com<mailto:mbritt...@navisite.com>>
Sent: Friday, January 22, 2016 5:17 PM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Help with AIE

**

Hi All & TGIF,



I need to set an AIE job to get data from an external source each night and 
don't know where to start. I know what the external data is and where I want to 
put it.  I have looked at some of the AIE jobs previously set up and it's not 
jumping out at me how to get started. I did look for documentation at BMC but 
came up empty there. If anyone knows where I can find the documentation to get 
started, that would be much appreciated



ARS 7.6.04 SP5

ITSM 7.6.04 SP2



Thanks

Mark



Mark Brittain

Sr. OSD Systems Engineer

ITILv3 Foundation, Continual Service Improvement

NaviSite, Inc. - A Time Warner Cable Company

mbritt...@navisite.com<mailto:mbritt...@navisite.com>

Office: 315.634.9337

Mobile: 315.882.5360

[navsig]





This E-mail and any of its attachments may contain Time Warner Cable 
proprietary information, which is privileged, confidential, or subject to 
copyright belonging to Time Warner Cable. This E-mail is intended solely for 
the use of the individual or entity to which it is addressed. If you are not 
the intended recipient of this E-mail, you are hereby notified that any 
dissemination, distribution, copying, or action taken in relation to the 
contents of and attachments to this E-mail is strictly prohibited and may be 
unlawful. If you have received this E-mail in error, please notify the sender 
immediately and permanently delete the original and any copy of this E-mail and 
any printout.
_ARSlist: "Where the Answers Are" and have been for 20 years_
_ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Help with AIE

[Carl Wilson]

Hi Bala,

 

> During data exchange, field mappings between remedy & the source system
will be defined. Since AIE is no longer available in the latest versions,
you cannot see the documents .

 

Incorrect, all legacy documentation is still available on the docs site:

 

https://docs.bmc.com/docs/display/public/ac7604/PDFs

 

  _  

 

Kind Regards,

 

Carl Wilson

 

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of David Charters
Sent: 28 January 2016 16:26
To: arslist@ARSLIST.ORG
Subject: Re: Help with AIE

 

** 

9.x no longer uses AIE, that is correct, however the 7.6.04 Admin Guide
contains information about AIE. If you want me to send it to you off List
just let me know, but you probably already have it I am guessing. 

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Bala iLink
Sent: Thursday, January 28, 2016 5:22 AM
To: arslist@ARSLIST.ORG
Subject: Re: Help with AIE

 

** 

Mark,

 

You need to define the data source & data exchanges for creating AIE jobs.

 

During data exchange, field mappings between remedy & the source system will
be defined. Since AIE is no longer available in the latest versions, you
cannot see the documents .

Thanks, 

Bala

  _  

From: Action Request System discussion list(ARSList) <arslist@ARSLIST.ORG>
on behalf of Brittain, Mark <mbritt...@navisite.com>
Sent: Friday, January 22, 2016 5:17 PM
To: arslist@ARSLIST.ORG
Subject: Help with AIE 

 

** 

Hi All & TGIF,

 

I need to set an AIE job to get data from an external source each night and
don't know where to start. I know what the external data is and where I want
to put it.  I have looked at some of the AIE jobs previously set up and it's
not jumping out at me how to get started. I did look for documentation at
BMC but came up empty there. If anyone knows where I can find the
documentation to get started, that would be much appreciated

 

ARS 7.6.04 SP5

ITSM 7.6.04 SP2

 

Thanks

Mark

 

Mark Brittain

Sr. OSD Systems Engineer

ITILv3 Foundation, Continual Service Improvement

NaviSite, Inc. - A Time Warner Cable Company

mbritt...@navisite.com

Office: 315.634.9337

Mobile: 315.882.5360

navsig

 

 

  _  


This E-mail and any of its attachments may contain Time Warner Cable
proprietary information, which is privileged, confidential, or subject to
copyright belonging to Time Warner Cable. This E-mail is intended solely for
the use of the individual or entity to which it is addressed. If you are not
the intended recipient of this E-mail, you are hereby notified that any
dissemination, distribution, copying, or action taken in relation to the
contents of and attachments to this E-mail is strictly prohibited and may be
unlawful. If you have received this E-mail in error, please notify the
sender immediately and permanently delete the original and any copy of this
E-mail and any printout.
_ARSlist: "Where the Answers Are" and have been for 20 years_ 

_ARSlist: "Where the Answers Are" and have been for 20 years_ 

_ARSlist: "Where the Answers Are" and have been for 20 years_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Help with AIE

[Bala iLink]

Thanks Carl for pointing it out. I acknowledge the mistake..



From: Action Request System discussion list(ARSList) <arslist@ARSLIST.ORG> on 
behalf of Carl Wilson <carlbwil...@gmail.com>
Sent: Friday, January 29, 2016 7:47 AM
To: arslist@ARSLIST.ORG
Subject: Re: Help with AIE

**

Hi Bala,



> During data exchange, field mappings between remedy & the source system will 
> be defined. Since AIE is no longer available in the latest versions, you 
> cannot see the documents .



Incorrect, all legacy documentation is still available on the docs site:



https://docs.bmc.com/docs/display/public/ac7604/PDFs







Kind Regards,



Carl Wilson





From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of David Charters
Sent: 28 January 2016 16:26
To: arslist@ARSLIST.ORG
Subject: Re: Help with AIE



**

9.x no longer uses AIE, that is correct, however the 7.6.04 Admin Guide 
contains information about AIE. If you want me to send it to you off List just 
let me know, but you probably already have it I am guessing.



From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Bala iLink
Sent: Thursday, January 28, 2016 5:22 AM
To: arslist@ARSLIST.ORG
Subject: Re: Help with AIE



**

Mark,



You need to define the data source & data exchanges for creating AIE jobs.



During data exchange, field mappings between remedy & the source system will be 
defined. Since AIE is no longer available in the latest versions, you cannot 
see the documents .

Thanks,

Bala



From: Action Request System discussion list(ARSList) 
<arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>> on behalf of Brittain, Mark 
<mbritt...@navisite.com<mailto:mbritt...@navisite.com>>
Sent: Friday, January 22, 2016 5:17 PM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Help with AIE



**

Hi All & TGIF,



I need to set an AIE job to get data from an external source each night and 
don't know where to start. I know what the external data is and where I want to 
put it.  I have looked at some of the AIE jobs previously set up and it's not 
jumping out at me how to get started. I did look for documentation at BMC but 
came up empty there. If anyone knows where I can find the documentation to get 
started, that would be much appreciated



ARS 7.6.04 SP5

ITSM 7.6.04 SP2



Thanks

Mark



Mark Brittain

Sr. OSD Systems Engineer

ITILv3 Foundation, Continual Service Improvement

NaviSite, Inc. - A Time Warner Cable Company

mbritt...@navisite.com<mailto:mbritt...@navisite.com>

Office: 315.634.9337

Mobile: 315.882.5360

[navsig]







This E-mail and any of its attachments may contain Time Warner Cable 
proprietary information, which is privileged, confidential, or subject to 
copyright belonging to Time Warner Cable. This E-mail is intended solely for 
the use of the individual or entity to which it is addressed. If you are not 
the intended recipient of this E-mail, you are hereby notified that any 
dissemination, distribution, copying, or action taken in relation to the 
contents of and attachments to this E-mail is strictly prohibited and may be 
unlawful. If you have received this E-mail in error, please notify the sender 
immediately and permanently delete the original and any copy of this E-mail and 
any printout.
_ARSlist: "Where the Answers Are" and have been for 20 years_

_ARSlist: "Where the Answers Are" and have been for 20 years_

_ARSlist: "Where the Answers Are" and have been for 20 years_

_ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Help with AIE

[Bala iLink]

Mark,


You need to define the data source & data exchanges for creating AIE jobs.


During data exchange, field mappings between remedy & the source system will be 
defined. Since AIE is no longer available in the latest versions, you cannot 
see the documents .

Thanks,
Bala

From: Action Request System discussion list(ARSList)  on 
behalf of Brittain, Mark 
Sent: Friday, January 22, 2016 5:17 PM
To: arslist@ARSLIST.ORG
Subject: Help with AIE

**

Hi All & TGIF,



I need to set an AIE job to get data from an external source each night and 
don't know where to start. I know what the external data is and where I want to 
put it.  I have looked at some of the AIE jobs previously set up and it's not 
jumping out at me how to get started. I did look for documentation at BMC but 
came up empty there. If anyone knows where I can find the documentation to get 
started, that would be much appreciated



ARS 7.6.04 SP5

ITSM 7.6.04 SP2



Thanks

Mark



Mark Brittain

Sr. OSD Systems Engineer

ITILv3 Foundation, Continual Service Improvement

NaviSite, Inc. - A Time Warner Cable Company

mbritt...@navisite.com

Office: 315.634.9337

Mobile: 315.882.5360

[navsig]





This E-mail and any of its attachments may contain Time Warner Cable 
proprietary information, which is privileged, confidential, or subject to 
copyright belonging to Time Warner Cable. This E-mail is intended solely for 
the use of the individual or entity to which it is addressed. If you are not 
the intended recipient of this E-mail, you are hereby notified that any 
dissemination, distribution, copying, or action taken in relation to the 
contents of and attachments to this E-mail is strictly prohibited and may be 
unlawful. If you have received this E-mail in error, please notify the sender 
immediately and permanently delete the original and any copy of this E-mail and 
any printout.
_ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Help with AIE

[David Charters]

It's in the 7.6.4 admin doc. It might be grouped with CMDB stuff, I have not 
looked it in a while.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark
Sent: Friday, January 22, 2016 12:18 PM
To: arslist@ARSLIST.ORG
Subject: Help with AIE

**
Hi All & TGIF,

I need to set an AIE job to get data from an external source each night and 
don't know where to start. I know what the external data is and where I want to 
put it.  I have looked at some of the AIE jobs previously set up and it's not 
jumping out at me how to get started. I did look for documentation at BMC but 
came up empty there. If anyone knows where I can find the documentation to get 
started, that would be much appreciated

ARS 7.6.04 SP5
ITSM 7.6.04 SP2

Thanks
Mark

Mark Brittain
Sr. OSD Systems Engineer
ITILv3 Foundation, Continual Service Improvement
NaviSite, Inc. - A Time Warner Cable Company
mbritt...@navisite.com
Office: 315.634.9337
Mobile: 315.882.5360
[navsig]




This E-mail and any of its attachments may contain Time Warner Cable 
proprietary information, which is privileged, confidential, or subject to 
copyright belonging to Time Warner Cable. This E-mail is intended solely for 
the use of the individual or entity to which it is addressed. If you are not 
the intended recipient of this E-mail, you are hereby notified that any 
dissemination, distribution, copying, or action taken in relation to the 
contents of and attachments to this E-mail is strictly prohibited and may be 
unlawful. If you have received this E-mail in error, please notify the sender 
immediately and permanently delete the original and any copy of this E-mail and 
any printout.
_ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: help in runif

[Grooms, Frederick W]

Try using the number of seconds instead of the string

(16 * 3600)

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Luisa Clotilde Carena
Sent: Wednesday, September 16, 2015 8:52 AM
To: arslist@ARSLIST.ORG
Subject: help in runif

**

Hi all,

I've a filter and i want to run it only after 16:00 o' clock.
Can you help me to write the correct Run if?  I  receive this errors:

$TIME$ > "16.00.00"  arerror 313 - Incompatible data types for intended 
relational operation.,
$TIME$ > "16:00:00"  arerror 313 - Incompatible data types for intended 
relational operation.,

$TIME$  > "04:00:00 PM"arerror 8957

$TIME$ > 576000  filtre run everytime


thank you

Luisa Carena



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: help in runic

[Reiser, John J]

Shouldn’t it be $TIMESTAMP$ > 57600


Thank you,
---
John J. Reiser
Building 760-J202
Remedy Developer/Administrator
Senior Software Development Analyst
Lockheed Martin - MST Moorestown Region
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased by me

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Wednesday, September 16, 2015 10:00 AM
To: arslist@ARSLIST.ORG
Subject: EXTERNAL: Re: help in runif

**
Try using the number of seconds instead of the string

(16 * 3600)

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Luisa Clotilde Carena
Sent: Wednesday, September 16, 2015 8:52 AM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: help in runif

**

Hi all,

I've a filter and i want to run it only after 16:00 o' clock.
Can you help me to write the correct Run if?  I  receive this errors:

$TIME$ > "16.00.00"  arerror 313 - Incompatible data types for intended 
relational operation.,
$TIME$ > "16:00:00"  arerror 313 - Incompatible data types for intended 
relational operation.,

$TIME$  > "04:00:00 PM"arerror 8957

$TIME$ > 576000  filtre run everytime


thank you

Luisa Carena


_ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: help in runic

[John Sundberg]

My playing with this stuff before required something like

($TIME$ - 0) > (14*3600)

It was the "- 0" that allowed the stuff to happen.

-John




On Wed, Sep 16, 2015 at 9:17 AM, Reiser, John J <john.j.rei...@lmco.com>
wrote:

> **
>
> Shouldn’t it be $TIMESTAMP$ > 57600
>
>
>
>
>
> Thank you,
>
> ---
> John J. Reiser
> Building 760-J202
> Remedy Developer/Administrator
>
> Senior Software Development Analyst
> Lockheed Martin - MST Moorestown Region
> The star that burns twice as bright burns half as long.
> Pay close attention and be illuminated by its brilliance. - paraphrased by
> me
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W
> *Sent:* Wednesday, September 16, 2015 10:00 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* EXTERNAL: Re: help in runif
>
>
>
> **
>
> Try using the number of seconds instead of the string
>
>
>
> (16 * 3600)
>
>
>
> Fred
>
>
>
> *From:* Action Request System discussion list(ARSList) [
> mailto:arslist@ARSLIST.ORG <arslist@ARSLIST.ORG>] *On Behalf Of *Luisa
> Clotilde Carena
> *Sent:* Wednesday, September 16, 2015 8:52 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* help in runif
>
>
>
> **
>
> Hi all,
>
> I've a filter and i want to run it only after 16:00 o' clock.
> Can you help me to write the correct Run if?  I  receive this errors:
>
> $TIME$ > "16.00.00"  arerror 313 - Incompatible data types for intended
> relational operation.,
> $TIME$ > "16:00:00"  arerror 313 - Incompatible data types for intended
> relational operation.,
>
> $TIME$  > "04:00:00 PM"arerror 8957
>
> $TIME$ > 576000  filtre run everytime
>
>
> thank you
>
> Luisa Carena
>
>
>
>
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_
> _ARSlist: "Where the Answers Are" and have been for 20 years_




-- 

*John Sundberg*
Kinetic Data, Inc.
"Your business. Your process."

651-556-0930 I john.sundb...@kineticdata.com
www.kineticdata.com I community.kineticdata.com

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: help in runic

[Ken Pritchard]

If you use TIMESTAMP wouldn’t you  need to do a calc to remove the date portion.

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J
Sent: Wednesday, September 16, 2015 10:17 AM
To: arslist@ARSLIST.ORG
Subject: Re: help in runic

 

** 

Shouldn’t it be $TIMESTAMP$ > 57600

 

 

Thank you,

--- 
John J. Reiser 
Building 760-J202
Remedy Developer/Administrator 

Senior Software Development Analyst 
Lockheed Martin - MST Moorestown Region
The star that burns twice as bright burns half as long. 
Pay close attention and be illuminated by its brilliance. - paraphrased by me 

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Wednesday, September 16, 2015 10:00 AM
To: arslist@ARSLIST.ORG <mailto:arslist@ARSLIST.ORG> 
Subject: EXTERNAL: Re: help in runif

 

** 

Try using the number of seconds instead of the string

 

(16 * 3600)

 

Fred

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Luisa Clotilde Carena
Sent: Wednesday, September 16, 2015 8:52 AM
To: arslist@ARSLIST.ORG <mailto:arslist@ARSLIST.ORG> 
Subject: help in runif

 

** 

Hi all,

I've a filter and i want to run it only after 16:00 o' clock.
Can you help me to write the correct Run if?  I  receive this errors:

$TIME$ > "16.00.00"  arerror 313 - Incompatible data types for intended 
relational operation.,  
$TIME$ > "16:00:00"  arerror 313 - Incompatible data types for intended 
relational operation.,  

$TIME$  > "04:00:00 PM"arerror 8957

$TIME$ > 576000  filtre run everytime


thank you

Luisa Carena

 

 

_ARSlist: "Where the Answers Are" and have been for 20 years_ 

_ARSlist: "Where the Answers Are" and have been for 20 years_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: EXTERNAL: Re: help in runic

[Reiser, John J]

Yeah, I jumped the gun
$TIMESTAMP$ > $DATE$ +(16 * 3600)

Thank you,
---
John J. Reiser
Building 760-J202
Remedy Developer/Administrator
Senior Software Development Analyst
Lockheed Martin - MST Moorestown Region
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased by me

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Ken Pritchard
Sent: Wednesday, September 16, 2015 10:19 AM
To: arslist@ARSLIST.ORG
Subject: EXTERNAL: Re: help in runic

**
If you use TIMESTAMP wouldn’t you  need to do a calc to remove the date portion.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J
Sent: Wednesday, September 16, 2015 10:17 AM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: help in runic

**
Shouldn’t it be $TIMESTAMP$ > 57600


Thank you,
---
John J. Reiser
Building 760-J202
Remedy Developer/Administrator
Senior Software Development Analyst
Lockheed Martin - MST Moorestown Region
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased by me

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Wednesday, September 16, 2015 10:00 AM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: EXTERNAL: Re: help in runif

**
Try using the number of seconds instead of the string

(16 * 3600)

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Luisa Clotilde Carena
Sent: Wednesday, September 16, 2015 8:52 AM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: help in runif

**

Hi all,

I've a filter and i want to run it only after 16:00 o' clock.
Can you help me to write the correct Run if?  I  receive this errors:

$TIME$ > "16.00.00"  arerror 313 - Incompatible data types for intended 
relational operation.,
$TIME$ > "16:00:00"  arerror 313 - Incompatible data types for intended 
relational operation.,

$TIME$  > "04:00:00 PM"arerror 8957

$TIME$ > 576000  filtre run everytime


thank you

Luisa Carena


_ARSlist: "Where the Answers Are" and have been for 20 years_
_ARSlist: "Where the Answers Are" and have been for 20 years_
_ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: help in runic

[Grooms, Frederick W]

Yes … If you do some math on the Date or time it converts the value to a number 
and you can work with it

If you work with $TIMESTAMP$ you have to remove the date   (The % is the MOD 
operator so this removes the date and leaves only the seconds past midnight)
   ((($TIMESTAMP$ - "1/1/70") % 86400) >= (16 * 3600))

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of John Sundberg
Sent: Wednesday, September 16, 2015 9:24 AM
To: arslist@ARSLIST.ORG
Subject: Re: help in runic

**
My playing with this stuff before required something like

($TIME$ - 0) > (14*3600)

It was the "- 0" that allowed the stuff to happen.

-John




On Wed, Sep 16, 2015 at 9:17 AM, Reiser, John J 
<john.j.rei...@lmco.com<mailto:john.j.rei...@lmco.com>> wrote:
**
Shouldn’t it be $TIMESTAMP$ > 57600


Thank you,
---
John J. Reiser
Building 760-J202
Remedy Developer/Administrator
Senior Software Development Analyst
Lockheed Martin - MST Moorestown Region
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased by me

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Grooms, 
Frederick W
Sent: Wednesday, September 16, 2015 10:00 AM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: EXTERNAL: Re: help in runif

**
Try using the number of seconds instead of the string

(16 * 3600)

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Luisa Clotilde Carena
Sent: Wednesday, September 16, 2015 8:52 AM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: help in runif

**

Hi all,

I've a filter and i want to run it only after 16:00 o' clock.
Can you help me to write the correct Run if?  I  receive this errors:

$TIME$ > "16.00.00"  arerror 313 - Incompatible data types for intended 
relational operation.,
$TIME$ > "16:00:00"  arerror 313 - Incompatible data types for intended 
relational operation.,

$TIME$  > "04:00:00 PM"arerror 8957

$TIME$ > 576000  filtre run everytime


thank you

Luisa Carena





___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: help in runic

[John Sundberg]

Funny … I know I answered this before. (I am guessing it was in 1997) …

Check this post:
http://www.javasystemsolutions.com/arslist/view/52078443

-John




On Wed, Sep 16, 2015 at 10:12 AM, Grooms, Frederick W <
frederick.w.gro...@xo.com> wrote:

> **
>
> Yes … If you do some math on the Date or time it converts the value to a
> number and you can work with it
>
>
>
> If you work with $TIMESTAMP$ you have to remove the date   (The % is the
> MOD operator so this removes the date and leaves only the seconds past
> midnight)
>
>((($TIMESTAMP$ - "1/1/70") % 86400) >= (16 * 3600))
>
>
>
> Fred
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *John Sundberg
> *Sent:* Wednesday, September 16, 2015 9:24 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: help in runic
>
>
>
> **
>
> My playing with this stuff before required something like
>
>
>
> ($TIME$ - 0) > (14*3600)
>
>
>
> It was the "- 0" that allowed the stuff to happen.
>
>
>
> -John
>
>
>
>
>
>
>
>
>
> On Wed, Sep 16, 2015 at 9:17 AM, Reiser, John J <john.j.rei...@lmco.com>
> wrote:
>
> **
>
> Shouldn’t it be $TIMESTAMP$ > 57600
>
>
>
>
>
> Thank you,
>
> ---
> John J. Reiser
> Building 760-J202
> Remedy Developer/Administrator
>
> Senior Software Development Analyst
> Lockheed Martin - MST Moorestown Region
> The star that burns twice as bright burns half as long.
> Pay close attention and be illuminated by its brilliance. - paraphrased by
> me
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W
> *Sent:* Wednesday, September 16, 2015 10:00 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* EXTERNAL: Re: help in runif
>
>
>
> **
>
> Try using the number of seconds instead of the string
>
>
>
> (16 * 3600)
>
>
>
> Fred
>
>
>
> *From:* Action Request System discussion list(ARSList) [
> mailto:arslist@ARSLIST.ORG <arslist@ARSLIST.ORG>] *On Behalf Of *Luisa
> Clotilde Carena
> *Sent:* Wednesday, September 16, 2015 8:52 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* help in runif
>
>
>
> **
>
> Hi all,
>
> I've a filter and i want to run it only after 16:00 o' clock.
> Can you help me to write the correct Run if?  I  receive this errors:
>
> $TIME$ > "16.00.00"  arerror 313 - Incompatible data types for intended
> relational operation.,
> $TIME$ > "16:00:00"  arerror 313 - Incompatible data types for intended
> relational operation.,
>
> $TIME$  > "04:00:00 PM"arerror 8957
>
> $TIME$ > 576000  filtre run everytime
>
>
> thank you
>
> Luisa Carena
>
>
>
>
>
>
>
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_
>



-- 

*John Sundberg*
Kinetic Data, Inc.
"Your business. Your process."

651-556-0930 I john.sundb...@kineticdata.com
www.kineticdata.com I community.kineticdata.com

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: help in runic

[John Sundberg]

thx - I’ll tell my kids - I am sure they will be impressed !

:)

-John

On Wed, Sep 16, 2015 at 6:38 PM, Carl Wilson <carlbwil...@gmail.com> wrote:

> **
>
> You’re a rock star John!
>
>
> --
>
>
>
> Kind Regards,
>
>
>
> *Carl Wilson*
>
>
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *John Sundberg
> *Sent:* 16 September 2015 17:04
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: help in runic
>
>
>
> **
>
> Funny … I know I answered this before. (I am guessing it was in 1997) …
>
>
>
> Check this post:
>
> http://www.javasystemsolutions.com/arslist/view/52078443
>
>
>
> -John
>
>
>
>
>
>
>
>
>
> On Wed, Sep 16, 2015 at 10:12 AM, Grooms, Frederick W <
> frederick.w.gro...@xo.com> wrote:
>
> **
>
> Yes … If you do some math on the Date or time it converts the value to a
> number and you can work with it
>
>
>
> If you work with $TIMESTAMP$ you have to remove the date   (The % is the
> MOD operator so this removes the date and leaves only the seconds past
> midnight)
>
>((($TIMESTAMP$ - "1/1/70") % 86400) >= (16 * 3600))
>
>
>
> Fred
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *John Sundberg
> *Sent:* Wednesday, September 16, 2015 9:24 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: help in runic
>
>
>
> **
>
> My playing with this stuff before required something like
>
>
>
> ($TIME$ - 0) > (14*3600)
>
>
>
> It was the "- 0" that allowed the stuff to happen.
>
>
>
> -John
>
>
>
>
>
>
>
>
>
> On Wed, Sep 16, 2015 at 9:17 AM, Reiser, John J <john.j.rei...@lmco.com>
> wrote:
>
> **
>
> Shouldn’t it be $TIMESTAMP$ > 57600
>
>
>
>
>
> Thank you,
>
> ---
> John J. Reiser
> Building 760-J202
> Remedy Developer/Administrator
>
> Senior Software Development Analyst
> Lockheed Martin - MST Moorestown Region
> The star that burns twice as bright burns half as long.
> Pay close attention and be illuminated by its brilliance. - paraphrased by
> me
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W
> *Sent:* Wednesday, September 16, 2015 10:00 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* EXTERNAL: Re: help in runif
>
>
>
> **
>
> Try using the number of seconds instead of the string
>
>
>
> (16 * 3600)
>
>
>
> Fred
>
>
>
> *From:* Action Request System discussion list(ARSList) [
> mailto:arslist@ARSLIST.ORG <arslist@ARSLIST.ORG>] *On Behalf Of *Luisa
> Clotilde Carena
> *Sent:* Wednesday, September 16, 2015 8:52 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* help in runif
>
>
>
> **
>
> Hi all,
>
> I've a filter and i want to run it only after 16:00 o' clock.
> Can you help me to write the correct Run if?  I  receive this errors:
>
> $TIME$ > "16.00.00"  arerror 313 - Incompatible data types for intended
> relational operation.,
> $TIME$ > "16:00:00"  arerror 313 - Incompatible data types for intended
> relational operation.,
>
> $TIME$  > "04:00:00 PM"arerror 8957
>
> $TIME$ > 576000  filtre run everytime
>
>
> thank you
>
> Luisa Carena
>
>
>
>
>
>
>
>
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_
>
>
>
>
>
> --
>
> *John Sundberg*
>
> *Kinetic Data, Inc.*
>
> *"Your business. Your process."*
>
>
>
> 651-556-0930 I john.sundb...@kineticdata.com
>
> www.kineticdata.com I community.kineticdata.com
>
>
>
>
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_
> _ARSlist: "Where the Answers Are" and have been for 20 years_




-- 

*John Sundberg*
Kinetic Data, Inc.
"Your business. Your process."

651-556-0930 I john.sundb...@kineticdata.com
www.kineticdata.com I community.kineticdata.com

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: help in runic

[Carl Wilson]

You’re a rock star John!

 

  _  

 

Kind Regards,

 

Carl Wilson

 

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of John Sundberg
Sent: 16 September 2015 17:04
To: arslist@ARSLIST.ORG
Subject: Re: help in runic

 

** 

Funny … I know I answered this before. (I am guessing it was in 1997) …

 

Check this post:

http://www.javasystemsolutions.com/arslist/view/52078443

 

-John

 

 

 

 

On Wed, Sep 16, 2015 at 10:12 AM, Grooms, Frederick W 
<frederick.w.gro...@xo.com> wrote:

** 

Yes … If you do some math on the Date or time it converts the value to a number 
and you can work with it

 

If you work with $TIMESTAMP$ you have to remove the date   (The % is the MOD 
operator so this removes the date and leaves only the seconds past midnight)   

   ((($TIMESTAMP$ - "1/1/70") % 86400) >= (16 * 3600))

 

Fred

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of John Sundberg
Sent: Wednesday, September 16, 2015 9:24 AM
To: arslist@ARSLIST.ORG
Subject: Re: help in runic

 

** 

My playing with this stuff before required something like 

 

($TIME$ - 0) > (14*3600)

 

It was the "- 0" that allowed the stuff to happen.

 

-John

 

 

 

 

On Wed, Sep 16, 2015 at 9:17 AM, Reiser, John J <john.j.rei...@lmco.com> wrote:

** 

Shouldn’t it be $TIMESTAMP$ > 57600

 

 

Thank you,

--- 
John J. Reiser 
Building 760-J202
Remedy Developer/Administrator 

Senior Software Development Analyst 
Lockheed Martin - MST Moorestown Region
The star that burns twice as bright burns half as long. 
Pay close attention and be illuminated by its brilliance. - paraphrased by me 

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Wednesday, September 16, 2015 10:00 AM
To: arslist@ARSLIST.ORG
Subject: EXTERNAL: Re: help in runif

 

** 

Try using the number of seconds instead of the string

 

(16 * 3600)

 

Fred

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Luisa Clotilde Carena
Sent: Wednesday, September 16, 2015 8:52 AM
To: arslist@ARSLIST.ORG
Subject: help in runif

 

** 

Hi all,

I've a filter and i want to run it only after 16:00 o' clock.
Can you help me to write the correct Run if?  I  receive this errors:

$TIME$ > "16.00.00"  arerror 313 - Incompatible data types for intended 
relational operation.,  
$TIME$ > "16:00:00"  arerror 313 - Incompatible data types for intended 
relational operation.,  

$TIME$  > "04:00:00 PM"arerror 8957

$TIME$ > 576000  filtre run everytime


thank you

Luisa Carena

 

 

 

 

_ARSlist: "Where the Answers Are" and have been for 20 years_ 





 

-- 

John Sundberg

Kinetic Data, Inc.

"Your business. Your process."

 

651-556-0930 I john.sundb...@kineticdata.com 

 <http://www.kineticdata.com/> www.kineticdata.com I  
<http://community.kineticdata.com/> community.kineticdata.com 

 

 

_ARSlist: "Where the Answers Are" and have been for 20 years_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Help: Impacted Area Associations Deleted on Change Tickets

[Jamie]

I had my DBAs restore the CHG:Impacted Areas table from a database backup to a 
separate location so that I could 1.) Re-import these entries back into my 
table, and 2.) investigate the data that was deleted.  What I have found is 
that all of the data that was deleted did NOT have a value within the 
reconciliationID field.  In face, the impacted area entries that had a reconID, 
did NOT get deleted, while the ones without a value did. This doesn't seem in 
alignment with the content in BMC's knowledge article, so I'm pushing them to 
understand why my entries without a reconID got deleted while the ones with one 
did not.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help: Impacted Area Associations Deleted on Change Tickets

[Terry Bootsma]

Hi Jamie:

Yes, we saw the same behavior.  Thankful that we were able to catch this in
the test environment prior to moving this into production.  Once they are
gone, they are gone... :-( 

The key here is this:

If you have a CI related to a change request and you have impacted areas

When you delete an impacted area from that change request, it deletes the
impacted areas from ALL change requests that had that CI related to it
previously.  Yes, that is right.  The one you just modified plus all
previous change requests have their impacted areas deleted.

We tracked it down to the following code that was incorrect:

Filter: CHG:CRQ:DeleteImpactedArea

On the push action, it should read:

('ReconciliationIdentity' = $Request ID01$) AND ('Infrastructure Change ID'
= $Request ID02$) . (I typed this, so the format might not be exact)

That's the fix, we found.  As far as your missing impacted areas
Unfortunately they are gone.  To manage this until you can make the above
change, don't let anyone remove any impacted areas from any change requests
until you implement the above fix. Otherwise the problem gets worse.. 



Terry

 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Jamie
Sent: June-11-15 12:38 PM
To: arslist@ARSLIST.ORG
Subject: Help: Impacted Area Associations Deleted on Change Tickets

We currently have a Change Rule in place that requires a technician to add
an impacted area to the change before they can submit it or modify it.
Yesterday (6/10) our changes were fine and had the impacted areas associated
with them.  Early this morning we identified that some how our impacted
areas were deleted on at least hundreds of change tickets (possibly more).
I was able to do a query that found for changes created since June 1st, the
following change tickets no longer have impacted areas associated with them:
 
54  Completed
32  Scheduled
29  Planning In Progress
16  Scheduled For Approval
11  Scheduled For Review
7   Draft
6   Cancelled
3   Implementation In Progress
2   Closed

However, not all changes lost their impacted area associated.  I personally
had a couple of changes assigned to me with impacted areas.  One of them
still has the impacted areas, while the other does not.

I have reviewed our escalations and the escalations and nothing really jumps
out.  Has anyone else see this happen?

ARS: 8.1.01
ITSM: 8.1.01
CMDB: 8.1.01

Midtier: Windows 2008 R2
ARS App: Sun Solaris
Database: Oracle


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers
Are, and have been for 20 years

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help: Impacted Area Associations Deleted on Change Tickets

[Jamie]

Thanks Terry.  I found a BMC knowledge article below that I think you are 
referring to which is tied to SW00465360

https://kb.bmc.com/infocenter/index?page=contentid=KA410393

Is this correct?

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help out a fellow lister...

[William Rentfrow]

Sorry I didn't get back to this until now -

Our customer in this case a large US federal agency.  Their regulations say 
they must be on a supported configuration.  Whether or not I can make it work 
on another OS that is related to SuSe but different doesn't matter - I'd never 
get the requests for new machines past the first level of approvers.  SuSe is 
the OS of choice for Linux there.

All of our machines are VM's by the way - which doesn't really matter too much 
for this conversation.

As far as the project itself - I wasn't exaggerating when I said we'd need a 
thousand + hours to move to a different OS.  We have 4 environments (dev, test, 
cat, prod), all of which are server groups, all of which use remote Oracle 
databases.  On top of that the network is largely secured and segmented, so you 
have to identify every possible connection point and put in requests to have 
the connectivity allowed.

Once you add the actual install/config/test/customer test time plus all of the 
other stuff that goes along with it - we'd need a rather large budget to switch.

William Rentfrow
wrentf...@stratacominc.com
Office: 715-204-3061 or 701-232-5697x25
Cell: 715-498-5056

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller
Sent: Wednesday, June 10, 2015 2:02 PM
To: arslist@ARSLIST.ORG
Subject: Re: Help out a fellow lister...

**
I think to Misi's point the installer might say not going to do it, wouldn't 
be prudent based on the OS alone. I remember before the newer family of gui 
installers that we used to be able to adjust those lines of the install scripts 
but I am not sure if there is still a way to make adjustments. Of course you 
probably could install on a supported platform and then copy the 
directories/binaries to the OS the installer doesn't like. But the more you 
have to fudge with it the further away you get from supported.

William,

Does your organization only use SUSE?

You mentioned it would take thousands of hours of work to switch OSes? Is that 
an exaggeration? That must be a monster system, wrapped in red tape? I am 
having a hard time envisioning an OS change taking that much effort, but then 
again I have never worked on one of those massive systems.

It seems to me that new AR Servers on a supported OS could be brought up into a 
server group then start removing the SUSE ones. I am figuring with an large 
environment you already have servers groups.

Are all of the server on physical machines, even non-prod? If so, is it time to 
look at virtualizing some of them? If not I would think a server could be 
removed from the group, the new OS installed on the hardware, install AR and 
put back in the group.

Once the SUSE boxes are removed then you are clear to upgrade to 9.0. That 
might be over simplified but seams feasible.

Jason

On Wed, Jun 10, 2015 at 5:56 AM, LJ LongWing 
lj.longw...@gmail.commailto:lj.longw...@gmail.com wrote:
**
According to the Wiki I was reading...while not the same...they come from a 
common parent...which would make them brothers of sorts...not the same...yet 
similar :)

On Wed, Jun 10, 2015 at 1:54 AM, Misi Mladoniczky 
m...@rrr.semailto:m...@rrr.se wrote:
Hi,

CentOS and RHEL are supposed to be the exact same thing. I have no real
experience to speak of with SUSE, but it is not the same as RHEL.

The main problem will probably be to get the installer to accept the
environment, and not actually running the AR Server...

Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)

Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.

 William,
 Countless thousands (my own personal estimate) of Remedy systems are
 running in 'unsupported configurations'...including many that people on
 this list support daily.  I know this is something that some customers will
 not like, but others happily go down un-maintained roadsUnsupported
 doesn't mean doesn't work by any means...now, mind you that the change from
 8.x to 9.x is unlike any other version change I have ever supported because
 they are going from C based server to Java based server...so...some of the
 'I'm sure it'll be ok' types of rules are out the window...but, the fact
 that 9.x lists both RHEL and CentOS as being on the support matrix, I'm not
 seeing SuSe as being all that 'out there' and not working at all...it may
 just require a bit more effort

 On Tue, Jun 9, 2015 at 2:59 PM, William Rentfrow 
 wrentf...@stratacominc.commailto:wrentf...@stratacominc.com
 wrote:

 **

 Here's some more information now that it's later in the day.



 We've been on SuSe Linux for a couple of years and we've been asked to
 evaluate the upgrade to Remedy 9.  Imagine our surprise when Remedy 9 no
 longer

Re: Help out a fellow lister...

[LJ LongWing]

According to the Wiki I was reading...while not the same...they come from a
common parent...which would make them brothers of sorts...not the
same...yet similar :)

On Wed, Jun 10, 2015 at 1:54 AM, Misi Mladoniczky m...@rrr.se wrote:

 Hi,

 CentOS and RHEL are supposed to be the exact same thing. I have no real
 experience to speak of with SUSE, but it is not the same as RHEL.

 The main problem will probably be to get the installer to accept the
 environment, and not actually running the AR Server...

 Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)

 Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
 * RRR|License - Not enough Remedy licenses? Save money by optimizing.
 * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
 Find these products, and many free tools and utilities, at http://rrr.se.

  William,
  Countless thousands (my own personal estimate) of Remedy systems are
  running in 'unsupported configurations'...including many that people on
  this list support daily.  I know this is something that some customers
 will
  not like, but others happily go down un-maintained roadsUnsupported
  doesn't mean doesn't work by any means...now, mind you that the change
 from
  8.x to 9.x is unlike any other version change I have ever supported
 because
  they are going from C based server to Java based server...so...some of
 the
  'I'm sure it'll be ok' types of rules are out the window...but, the fact
  that 9.x lists both RHEL and CentOS as being on the support matrix, I'm
 not
  seeing SuSe as being all that 'out there' and not working at all...it may
  just require a bit more effort
 
  On Tue, Jun 9, 2015 at 2:59 PM, William Rentfrow 
 wrentf...@stratacominc.com
  wrote:
 
  **
 
  Here's some more information now that it's later in the day.
 
 
 
  We've been on SuSe Linux for a couple of years and we've been asked to
  evaluate the upgrade to Remedy 9.  Imagine our surprise when Remedy 9 no
  longer supports SuSe.
 
 
  We are under strict guidelines - one of which is using a supported
  configuration for any/all software.  Having to switch our entire system
 to
  new hardware/OS/unknown configuration problems etc X 7 environments
 would
  be thousands of hours of work.
 
 
  At a time when other solutions have made their way in door at this
  customer there's simply no way we are going to get funding for that.
  The
  entire conversation will be something like Well, if we have to switch
  everything anyway.why not just go with product B?
 
 
 
  William Rentfrow
 
  wrentf...@stratacominc.com
 
  Office: 715-204-3061 or 701-232-5697x25
 
  Cell: 715-498-5056
 
 
 
  *From:* William Rentfrow
  *Sent:* Tuesday, June 09, 2015 7:46 AM
  *To:* arslist@ARSLIST.ORG
  *Subject:* Help out a fellow lister...
 
 
 
  Hi listers -
 
 
 
  SuSe Linux has been dropped from the compatibility matrix for version 9.
  We are in talks with BMC to have it re-added but at this point it's up
 in
  the air.
 
 
 
  It would help us out if you could up-vote the idea on the BMC
  Communities.  Here's the page:
 
 
 
  https://communities.bmc.com/ideas/10430
 
 
 
  Thanks ahead of time!
 
 
 
  William Rentfrow
 
  wrentf...@stratacominc.com
 
  Office: 715-204-3061 or 701-232-5697x25
 
  Cell: 715-498-5056
 
 
   _ARSlist: Where the Answers Are and have been for 20 years_
 
 
 
 ___
  UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
  Where the Answers Are, and have been for 20 years
 


 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Where the Answers Are, and have been for 20 years


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help out a fellow lister...

[Misi Mladoniczky]

Hi,

CentOS and RHEL are supposed to be the exact same thing. I have no real
experience to speak of with SUSE, but it is not the same as RHEL.

The main problem will probably be to get the installer to accept the
environment, and not actually running the AR Server...

Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)

Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.

 William,
 Countless thousands (my own personal estimate) of Remedy systems are
 running in 'unsupported configurations'...including many that people on
 this list support daily.  I know this is something that some customers will
 not like, but others happily go down un-maintained roadsUnsupported
 doesn't mean doesn't work by any means...now, mind you that the change from
 8.x to 9.x is unlike any other version change I have ever supported because
 they are going from C based server to Java based server...so...some of the
 'I'm sure it'll be ok' types of rules are out the window...but, the fact
 that 9.x lists both RHEL and CentOS as being on the support matrix, I'm not
 seeing SuSe as being all that 'out there' and not working at all...it may
 just require a bit more effort

 On Tue, Jun 9, 2015 at 2:59 PM, William Rentfrow wrentf...@stratacominc.com
 wrote:

 **

 Here's some more information now that it's later in the day.



 We've been on SuSe Linux for a couple of years and we've been asked to
 evaluate the upgrade to Remedy 9.  Imagine our surprise when Remedy 9 no
 longer supports SuSe.


 We are under strict guidelines - one of which is using a supported
 configuration for any/all software.  Having to switch our entire system to
 new hardware/OS/unknown configuration problems etc X 7 environments would
 be thousands of hours of work.


 At a time when other solutions have made their way in door at this
 customer there's simply no way we are going to get funding for that.   The
 entire conversation will be something like Well, if we have to switch
 everything anyway.why not just go with product B?



 William Rentfrow

 wrentf...@stratacominc.com

 Office: 715-204-3061 or 701-232-5697x25

 Cell: 715-498-5056



 *From:* William Rentfrow
 *Sent:* Tuesday, June 09, 2015 7:46 AM
 *To:* arslist@ARSLIST.ORG
 *Subject:* Help out a fellow lister...



 Hi listers -



 SuSe Linux has been dropped from the compatibility matrix for version 9.
 We are in talks with BMC to have it re-added but at this point it's up in
 the air.



 It would help us out if you could up-vote the idea on the BMC
 Communities.  Here's the page:



 https://communities.bmc.com/ideas/10430



 Thanks ahead of time!



 William Rentfrow

 wrentf...@stratacominc.com

 Office: 715-204-3061 or 701-232-5697x25

 Cell: 715-498-5056


  _ARSlist: Where the Answers Are and have been for 20 years_


 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Where the Answers Are, and have been for 20 years


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help out a fellow lister...

[Jason Miller]

Oh, I forgot to include... this might be more fruitful than trying to get
BMC to support SUSE again?.?.?

On Wed, Jun 10, 2015 at 12:01 PM, Jason Miller jason.mil...@gmail.com
wrote:

 I think to Misi's point the installer might say not going to do it,
 wouldn't be prudent based on the OS alone. I remember before the newer
 family of gui installers that we used to be able to adjust those lines of
 the install scripts but I am not sure if there is still a way to make
 adjustments. Of course you probably could install on a supported platform
 and then copy the directories/binaries to the OS the installer doesn't
 like. But the more you have to fudge with it the further away you get from
 supported.

 William,

 Does your organization only use SUSE?

 You mentioned it would take thousands of hours of work to switch OSes? Is
 that an exaggeration? That must be a monster system, wrapped in red tape? I
 am having a hard time envisioning an OS change taking that much effort, but
 then again I have never worked on one of those massive systems.

 It seems to me that new AR Servers on a supported OS could be brought up
 into a server group then start removing the SUSE ones. I am figuring with
 an large environment you already have servers groups.

 Are all of the server on physical machines, even non-prod? If so, is it
 time to look at virtualizing some of them? If not I would think a server
 could be removed from the group, the new OS installed on the hardware,
 install AR and put back in the group.

 Once the SUSE boxes are removed then you are clear to upgrade to 9.0. That
 might be over simplified but seams feasible.

 Jason

 On Wed, Jun 10, 2015 at 5:56 AM, LJ LongWing lj.longw...@gmail.com
 wrote:

 **
 According to the Wiki I was reading...while not the same...they come from
 a common parent...which would make them brothers of sorts...not the
 same...yet similar :)

 On Wed, Jun 10, 2015 at 1:54 AM, Misi Mladoniczky m...@rrr.se wrote:

 Hi,

 CentOS and RHEL are supposed to be the exact same thing. I have no real
 experience to speak of with SUSE, but it is not the same as RHEL.

 The main problem will probably be to get the installer to accept the
 environment, and not actually running the AR Server...

 Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP
 2011)

 Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
 * RRR|License - Not enough Remedy licenses? Save money by optimizing.
 * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
 Find these products, and many free tools and utilities, at http://rrr.se
 .

  William,
  Countless thousands (my own personal estimate) of Remedy systems are
  running in 'unsupported configurations'...including many that people on
  this list support daily.  I know this is something that some customers
 will
  not like, but others happily go down un-maintained roadsUnsupported
  doesn't mean doesn't work by any means...now, mind you that the change
 from
  8.x to 9.x is unlike any other version change I have ever supported
 because
  they are going from C based server to Java based server...so...some of
 the
  'I'm sure it'll be ok' types of rules are out the window...but, the
 fact
  that 9.x lists both RHEL and CentOS as being on the support matrix,
 I'm not
  seeing SuSe as being all that 'out there' and not working at all...it
 may
  just require a bit more effort
 
  On Tue, Jun 9, 2015 at 2:59 PM, William Rentfrow 
 wrentf...@stratacominc.com
  wrote:
 
  **
 
  Here's some more information now that it's later in the day.
 
 
 
  We've been on SuSe Linux for a couple of years and we've been asked to
  evaluate the upgrade to Remedy 9.  Imagine our surprise when Remedy 9
 no
  longer supports SuSe.
 
 
  We are under strict guidelines - one of which is using a supported
  configuration for any/all software.  Having to switch our entire
 system to
  new hardware/OS/unknown configuration problems etc X 7 environments
 would
  be thousands of hours of work.
 
 
  At a time when other solutions have made their way in door at this
  customer there's simply no way we are going to get funding for that.
  The
  entire conversation will be something like Well, if we have to switch
  everything anyway.why not just go with product B?
 
 
 
  William Rentfrow
 
  wrentf...@stratacominc.com
 
  Office: 715-204-3061 or 701-232-5697x25
 
  Cell: 715-498-5056
 
 
 
  *From:* William Rentfrow
  *Sent:* Tuesday, June 09, 2015 7:46 AM
  *To:* arslist@ARSLIST.ORG
  *Subject:* Help out a fellow lister...
 
 
 
  Hi listers -
 
 
 
  SuSe Linux has been dropped from the compatibility matrix for version
 9.
  We are in talks with BMC to have it re-added but at this point it's
 up in
  the air.
 
 
 
  It would help us out if you could up-vote the idea on the BMC
  Communities.  Here's the page:
 
 
 
  https://communities.bmc.com/ideas/10430
 
 
 
  Thanks ahead of time!
 
 
 
  William Rentfrow
 
  

Re: Help out a fellow lister...

[Jason Miller]

I think to Misi's point the installer might say not going to do it,
wouldn't be prudent based on the OS alone. I remember before the newer
family of gui installers that we used to be able to adjust those lines of
the install scripts but I am not sure if there is still a way to make
adjustments. Of course you probably could install on a supported platform
and then copy the directories/binaries to the OS the installer doesn't
like. But the more you have to fudge with it the further away you get from
supported.

William,

Does your organization only use SUSE?

You mentioned it would take thousands of hours of work to switch OSes? Is
that an exaggeration? That must be a monster system, wrapped in red tape? I
am having a hard time envisioning an OS change taking that much effort, but
then again I have never worked on one of those massive systems.

It seems to me that new AR Servers on a supported OS could be brought up
into a server group then start removing the SUSE ones. I am figuring with
an large environment you already have servers groups.

Are all of the server on physical machines, even non-prod? If so, is it
time to look at virtualizing some of them? If not I would think a server
could be removed from the group, the new OS installed on the hardware,
install AR and put back in the group.

Once the SUSE boxes are removed then you are clear to upgrade to 9.0. That
might be over simplified but seams feasible.

Jason

On Wed, Jun 10, 2015 at 5:56 AM, LJ LongWing lj.longw...@gmail.com wrote:

 **
 According to the Wiki I was reading...while not the same...they come from
 a common parent...which would make them brothers of sorts...not the
 same...yet similar :)

 On Wed, Jun 10, 2015 at 1:54 AM, Misi Mladoniczky m...@rrr.se wrote:

 Hi,

 CentOS and RHEL are supposed to be the exact same thing. I have no real
 experience to speak of with SUSE, but it is not the same as RHEL.

 The main problem will probably be to get the installer to accept the
 environment, and not actually running the AR Server...

 Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)

 Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
 * RRR|License - Not enough Remedy licenses? Save money by optimizing.
 * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
 Find these products, and many free tools and utilities, at http://rrr.se.

  William,
  Countless thousands (my own personal estimate) of Remedy systems are
  running in 'unsupported configurations'...including many that people on
  this list support daily.  I know this is something that some customers
 will
  not like, but others happily go down un-maintained roadsUnsupported
  doesn't mean doesn't work by any means...now, mind you that the change
 from
  8.x to 9.x is unlike any other version change I have ever supported
 because
  they are going from C based server to Java based server...so...some of
 the
  'I'm sure it'll be ok' types of rules are out the window...but, the fact
  that 9.x lists both RHEL and CentOS as being on the support matrix, I'm
 not
  seeing SuSe as being all that 'out there' and not working at all...it
 may
  just require a bit more effort
 
  On Tue, Jun 9, 2015 at 2:59 PM, William Rentfrow 
 wrentf...@stratacominc.com
  wrote:
 
  **
 
  Here's some more information now that it's later in the day.
 
 
 
  We've been on SuSe Linux for a couple of years and we've been asked to
  evaluate the upgrade to Remedy 9.  Imagine our surprise when Remedy 9
 no
  longer supports SuSe.
 
 
  We are under strict guidelines - one of which is using a supported
  configuration for any/all software.  Having to switch our entire
 system to
  new hardware/OS/unknown configuration problems etc X 7 environments
 would
  be thousands of hours of work.
 
 
  At a time when other solutions have made their way in door at this
  customer there's simply no way we are going to get funding for that.
  The
  entire conversation will be something like Well, if we have to switch
  everything anyway.why not just go with product B?
 
 
 
  William Rentfrow
 
  wrentf...@stratacominc.com
 
  Office: 715-204-3061 or 701-232-5697x25
 
  Cell: 715-498-5056
 
 
 
  *From:* William Rentfrow
  *Sent:* Tuesday, June 09, 2015 7:46 AM
  *To:* arslist@ARSLIST.ORG
  *Subject:* Help out a fellow lister...
 
 
 
  Hi listers -
 
 
 
  SuSe Linux has been dropped from the compatibility matrix for version
 9.
  We are in talks with BMC to have it re-added but at this point it's up
 in
  the air.
 
 
 
  It would help us out if you could up-vote the idea on the BMC
  Communities.  Here's the page:
 
 
 
  https://communities.bmc.com/ideas/10430
 
 
 
  Thanks ahead of time!
 
 
 
  William Rentfrow
 
  wrentf...@stratacominc.com
 
  Office: 715-204-3061 or 701-232-5697x25
 
  Cell: 715-498-5056
 
 
   _ARSlist: Where the Answers Are and have been for 20 years_
 
 
 
 

Re: Help out a fellow lister...

[William Rentfrow]

Here's some more information now that it's later in the day.

We've been on SuSe Linux for a couple of years and we've been asked to evaluate 
the upgrade to Remedy 9.  Imagine our surprise when Remedy 9 no longer supports 
SuSe.

We are under strict guidelines - one of which is using a supported 
configuration for any/all software.  Having to switch our entire system to new 
hardware/OS/unknown configuration problems etc X 7 environments would be 
thousands of hours of work.

At a time when other solutions have made their way in door at this customer 
there's simply no way we are going to get funding for that.   The entire 
conversation will be something like Well, if we have to switch everything 
anyway.why not just go with product B?

William Rentfrow
wrentf...@stratacominc.com
Office: 715-204-3061 or 701-232-5697x25
Cell: 715-498-5056

From: William Rentfrow
Sent: Tuesday, June 09, 2015 7:46 AM
To: arslist@ARSLIST.ORG
Subject: Help out a fellow lister...

Hi listers -

SuSe Linux has been dropped from the compatibility matrix for version 9.  We 
are in talks with BMC to have it re-added but at this point it's up in the air.

It would help us out if you could up-vote the idea on the BMC Communities.  
Here's the page:

https://communities.bmc.com/ideas/10430

Thanks ahead of time!

William Rentfrow
wrentf...@stratacominc.com
Office: 715-204-3061 or 701-232-5697x25
Cell: 715-498-5056


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help out a fellow lister...

[LJ LongWing]

William,
Countless thousands (my own personal estimate) of Remedy systems are
running in 'unsupported configurations'...including many that people on
this list support daily.  I know this is something that some customers will
not like, but others happily go down un-maintained roadsUnsupported
doesn't mean doesn't work by any means...now, mind you that the change from
8.x to 9.x is unlike any other version change I have ever supported because
they are going from C based server to Java based server...so...some of the
'I'm sure it'll be ok' types of rules are out the window...but, the fact
that 9.x lists both RHEL and CentOS as being on the support matrix, I'm not
seeing SuSe as being all that 'out there' and not working at all...it may
just require a bit more effort

On Tue, Jun 9, 2015 at 2:59 PM, William Rentfrow wrentf...@stratacominc.com
 wrote:

 **

 Here's some more information now that it's later in the day.



 We've been on SuSe Linux for a couple of years and we've been asked to
 evaluate the upgrade to Remedy 9.  Imagine our surprise when Remedy 9 no
 longer supports SuSe.


 We are under strict guidelines - one of which is using a supported
 configuration for any/all software.  Having to switch our entire system to
 new hardware/OS/unknown configuration problems etc X 7 environments would
 be thousands of hours of work.


 At a time when other solutions have made their way in door at this
 customer there's simply no way we are going to get funding for that.   The
 entire conversation will be something like Well, if we have to switch
 everything anyway.why not just go with product B?



 William Rentfrow

 wrentf...@stratacominc.com

 Office: 715-204-3061 or 701-232-5697x25

 Cell: 715-498-5056



 *From:* William Rentfrow
 *Sent:* Tuesday, June 09, 2015 7:46 AM
 *To:* arslist@ARSLIST.ORG
 *Subject:* Help out a fellow lister...



 Hi listers -



 SuSe Linux has been dropped from the compatibility matrix for version 9.
 We are in talks with BMC to have it re-added but at this point it's up in
 the air.



 It would help us out if you could up-vote the idea on the BMC
 Communities.  Here's the page:



 https://communities.bmc.com/ideas/10430



 Thanks ahead of time!



 William Rentfrow

 wrentf...@stratacominc.com

 Office: 715-204-3061 or 701-232-5697x25

 Cell: 715-498-5056


  _ARSlist: Where the Answers Are and have been for 20 years_


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help with upgrade path

[Hullule, Kiran]

Can you think about staged upgrade, this may take care of missing 
forms/fields/indexes in the later versions before you move to 8.1.2? just a 
thought.


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Carina Burns
Sent: 3 January 2015 05:53
To: arslist@ARSLIST.ORG
Subject: Re: Help with upgrade path

I did have to apply the fix on the Schema_Archive table not because we had data 
but because it was the wrong field type (Varchar2 instead of Number) and was 
throwing errors.  Interestingly, yours is the second post I've found about 
deleting the Flashboard forms (if you don't use them) in order to upgrade to 
7.64.  

I'm trying to upgrade to 8.1.2  from 7.1, and it's throwing an error about not 
being able to update the FB:User Privilege form.  It says the form doesn't 
exist (and sure enough, it isn't there when looking with Developer Studio).  I 
am starting to think that with the ARS Server upgrade option, it expects 
certain forms to be there from earlier upgrades and hence doesn't import them.  
I will try deleting the flash board forms and running the upgrade again to see 
if it loads them all.

Another point is that I get unique index errors in the upgrade logs about the 
ADF_ServerApps and ADF_GroupUser forms...Neither of those forms show up when 
looking with Developer Studio either.   I find it amusing that it gives index 
violation errors since I don't have these forms on my 7.1 install meaning 
clearly I can't have duplicate records!

It's really looking like I may have to stair step my upgrade from 7.1 to 7.5 to 
7.64 and then to 8.1.2.   Although support at BMC is convinced that I should be 
able to go from 7.1 to 8.1.2 because I have only custom forms and no mods to 
the stock ARS forms.

I have a crazy idea that I may try.  Before I went down the thorny upgrade 
path, I did a new install of the 8.1.2 server to get all the binaries onto 
the new machine.  Before truncating everything and importing my 7.1 ARADMIN 
schema, I did a database export of the pristine ARADMIN schema. I'm really 
tempted to export off my upgraded 7.1 ARADMIN schema then reload that pristine 
ARADMIN schema.  I would then export the definitions for the forms the upgrade 
installer thinks I am missing and then bring the upgraded 7.1 ARADMIN schema 
back in, import the definitions for those forms, and then run the upgrade 
installer for ARS 8.1.2 again.  

Yup, crazy.  But my other alternatives if I can't straight upgrade is to SLOWLY 
go thru each upgrade or do a new install and import my custom forms and data 
with migrator.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers 
Are, and have been for 20 years

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help with upgrade path

[Sanford, Claire]

Your last line is the answer!!  If you can do that, you will save yourself 
quite a bit of pain!!

...do a new install and import my custom forms and data with migrator.


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Carina Burns
Sent: 3 January 2015 05:53
To: arslist@ARSLIST.ORG
Subject: Re: Help with upgrade path

I did have to apply the fix on the Schema_Archive table not because we had data 
but because it was the wrong field type (Varchar2 instead of Number) and was 
throwing errors.  Interestingly, yours is the second post I've found about 
deleting the Flashboard forms (if you don't use them) in order to upgrade to 
7.64.  

I'm trying to upgrade to 8.1.2  from 7.1, and it's throwing an error about not 
being able to update the FB:User Privilege form.  It says the form doesn't 
exist (and sure enough, it isn't there when looking with Developer Studio).  I 
am starting to think that with the ARS Server upgrade option, it expects 
certain forms to be there from earlier upgrades and hence doesn't import them.  
I will try deleting the flash board forms and running the upgrade again to see 
if it loads them all.

Another point is that I get unique index errors in the upgrade logs about the 
ADF_ServerApps and ADF_GroupUser forms...Neither of those forms show up when 
looking with Developer Studio either.   I find it amusing that it gives index 
violation errors since I don't have these forms on my 7.1 install meaning 
clearly I can't have duplicate records!

It's really looking like I may have to stair step my upgrade from 7.1 to 7.5 to 
7.64 and then to 8.1.2.   Although support at BMC is convinced that I should be 
able to go from 7.1 to 8.1.2 because I have only custom forms and no mods to 
the stock ARS forms.

I have a crazy idea that I may try.  Before I went down the thorny upgrade 
path, I did a new install of the 8.1.2 server to get all the binaries onto 
the new machine.  Before truncating everything and importing my 7.1 ARADMIN 
schema, I did a database export of the pristine ARADMIN schema. I'm really 
tempted to export off my upgraded 7.1 ARADMIN schema then reload that pristine 
ARADMIN schema.  I would then export the definitions for the forms the upgrade 
installer thinks I am missing and then bring the upgraded 7.1 ARADMIN schema 
back in, import the definitions for those forms, and then run the upgrade 
installer for ARS 8.1.2 again.  

Yup, crazy.  But my other alternatives if I can't straight upgrade is to SLOWLY 
go thru each upgrade or do a new install and import my custom forms and data 
with migrator.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers 
Are, and have been for 20 years

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help with upgrade path

[Jason Miller]

I absolutely agree with Claire!  With a non-ITSM system building a new
environment and migrating your definitions/data (via the API) is likely
*way* easier than going through an upgrade(s).  Not only will this very
likely save you time, frustration and hair on your head but you will end up
with a cleaned up environment because you will find things that are no
longer relevant and leave those out of the new system.

For example in 2009 we moved our custom system from AR 7.0.01 to AR 7.5 by
building a new 7.5 system and importing defs/data.  Since then we have
upgraded that same database to 7.6.04 and now 8.1.02.001.  Along the way we
have changed to new app/db servers and have upgraded SQL as well.  My team
recently started the discussion of building a new AR DB from a fresh
install the next time we upgrade a major AR version, just like we did in
2009.

In our case we are currently using Help Desk 6 and everything else custom
(ok so it isn't a completely custom system however HD had been so
customized and so far out of support we consider it ours now.  We even
converted the HD objects to Custom.).  This year we are starting the
process of building a custom app to replace HD6.  With HD6 we have a *ton* of
CMDB objects that have never been used.  Also at one point we had SLA
installed.  Instead of surgically removing the CMDB/SLA objects from our DB
we'll likely build a new DB from a fresh install and just leave all the
stuff we no longer want behind.  We'll use the API for *everything* that we
move to make sure all definitions and data are check against the current
version as they are brought in.

HTH,
Jason

On Mon, Jan 5, 2015 at 8:39 AM, Sanford, Claire 
claire.sanf...@memorialhermann.org wrote:

 Your last line is the answer!!  If you can do that, you will save yourself
 quite a bit of pain!!

 ...do a new install and import my custom forms and data with migrator.


 -Original Message-
 From: Action Request System discussion list(ARSList) [mailto:
 arslist@ARSLIST.ORG] On Behalf Of Carina Burns
 Sent: 3 January 2015 05:53
 To: arslist@ARSLIST.ORG
 Subject: Re: Help with upgrade path

 I did have to apply the fix on the Schema_Archive table not because we had
 data but because it was the wrong field type (Varchar2 instead of Number)
 and was throwing errors.  Interestingly, yours is the second post I've
 found about deleting the Flashboard forms (if you don't use them) in order
 to upgrade to 7.64.

 I'm trying to upgrade to 8.1.2  from 7.1, and it's throwing an error about
 not being able to update the FB:User Privilege form.  It says the form
 doesn't exist (and sure enough, it isn't there when looking with Developer
 Studio).  I am starting to think that with the ARS Server upgrade option,
 it expects certain forms to be there from earlier upgrades and hence
 doesn't import them.  I will try deleting the flash board forms and running
 the upgrade again to see if it loads them all.

 Another point is that I get unique index errors in the upgrade logs about
 the ADF_ServerApps and ADF_GroupUser forms...Neither of those forms show up
 when looking with Developer Studio either.   I find it amusing that it
 gives index violation errors since I don't have these forms on my 7.1
 install meaning clearly I can't have duplicate records!

 It's really looking like I may have to stair step my upgrade from 7.1 to
 7.5 to 7.64 and then to 8.1.2.   Although support at BMC is convinced that
 I should be able to go from 7.1 to 8.1.2 because I have only custom forms
 and no mods to the stock ARS forms.

 I have a crazy idea that I may try.  Before I went down the thorny upgrade
 path, I did a new install of the 8.1.2 server to get all the binaries
 onto the new machine.  Before truncating everything and importing my 7.1
 ARADMIN schema, I did a database export of the pristine ARADMIN schema. I'm
 really tempted to export off my upgraded 7.1 ARADMIN schema then reload
 that pristine ARADMIN schema.  I would then export the definitions for the
 forms the upgrade installer thinks I am missing and then bring the upgraded
 7.1 ARADMIN schema back in, import the definitions for those forms, and
 then run the upgrade installer for ARS 8.1.2 again.

 Yup, crazy.  But my other alternatives if I can't straight upgrade is to
 SLOWLY go thru each upgrade or do a new install and import my custom
 forms and data with migrator.


 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the
 Answers Are, and have been for 20 years


 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Where the Answers Are, and have been for 20 years


 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Where the Answers Are, and have been for 20 years

Re: Help with upgrade path

[Carina Burns]

I did have to apply the fix on the Schema_Archive table not because we had data 
but because it was the wrong field type (Varchar2 instead of Number) and was 
throwing errors.  Interestingly, yours is the second post I've found about 
deleting the Flashboard forms (if you don't use them) in order to upgrade to 
7.64.  

I'm trying to upgrade to 8.1.2  from 7.1, and it's throwing an error about not 
being able to update the FB:User Privilege form.  It says the form doesn't 
exist (and sure enough, it isn't there when looking with Developer Studio).  I 
am starting to think that with the ARS Server upgrade option, it expects 
certain forms to be there from earlier upgrades and hence doesn't import them.  
I will try deleting the flash board forms and running the upgrade again to see 
if it loads them all.

Another point is that I get unique index errors in the upgrade logs about the 
ADF_ServerApps and ADF_GroupUser forms...Neither of those forms show up when 
looking with Developer Studio either.   I find it amusing that it gives index 
violation errors since I don't have these forms on my 7.1 install meaning 
clearly I can't have duplicate records!

It's really looking like I may have to stair step my upgrade from 7.1 to 7.5 to 
7.64 and then to 8.1.2.   Although support at BMC is convinced that I should be 
able to go from 7.1 to 8.1.2 because I have only custom forms and no mods to 
the stock ARS forms.

I have a crazy idea that I may try.  Before I went down the thorny upgrade 
path, I did a new install of the 8.1.2 server to get all the binaries onto 
the new machine.  Before truncating everything and importing my 7.1 ARADMIN 
schema, I did a database export of the pristine ARADMIN schema. I'm really 
tempted to export off my upgraded 7.1 ARADMIN schema then reload that pristine 
ARADMIN schema.  I would then export the definitions for the forms the upgrade 
installer thinks I am missing and then bring the upgraded 7.1 ARADMIN schema 
back in, import the definitions for those forms, and then run the upgrade 
installer for ARS 8.1.2 again.  

Yup, crazy.  But my other alternatives if I can't straight upgrade is to SLOWLY 
go thru each upgrade or do a new install and import my custom forms and data 
with migrator.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help with upgrade path

[Theo Fondse (GMail)]

Hi Scott,

 

We have a large Custom-Only installation – no ITSM or any other OOTB apps, 
thus – ARS only.

 

I suggest not to skip the x or x.y  major versions of the base AR System. The 
x.y.z minor versions generally do not have a notable design change on the DB – 
with the exception of 7.6.04, which introduced overlays (Don’t understand why 
BMC did not release this as a Major version???).

 

This comes out of previous experience with having been called in to “fix” a 
number of failed upgrades in the past, amplified by a recent round of failed 
upgrade attempts.

 

You could try to skip one or two of these versions – that’s up to you – YMMD – 
but no guarantees.

 

You might be lucky when going directly from 7.0.1 to 8.1…. but I would not 
advise doing it to your Prod environment before doing some extensive testing on 
a duplicate test bed  environment.

 

We had the before-last round of upgrade attempts directly from 7.1.0 to 7.6.04 
fail repeatedly on colleagues, a local support vendor and myself. 

We were desperate to get to a currently supported version of ARS, so I decided 
not to give up and find out why it fails….. Eventually got it sorted out safely 
using the steps I outlined before.

 

We decided not to go to 8.0 or 8.1 as 7.6.04 is the last version that is 
shipped with the User Tool. Our user base are still making extensive use of the 
User tool and are reluctant to use Mid-Tier because of it’s lack of performance 
and because of the limitations it imposes on you as opposed to the User Tool.

 

I would suggest using the ARS upgrade path with each of the versions I 
mentioned as I outlined it in my previous mail, (however you might want to 
upgrade to ARS 7.1.0 first), just to be on the safe side, because it is known 
to work that way. A single ARS Base upgrade does not take very long. We had a 
Saturday morning and afternoon change window to do the ARS Base upgrade from 
7.1 to 7.6.04 SP5 and that was enough time to get it done.

 

As far as the OOTB modules are concerned, I have not yet tried to use the 7.x 
ITSM modules on the 8.x AR Server, but logic dictates that it should still work 
if the 7.x ITSM libraries are still intact after the ARS upgrade, as the ARS 
API is backwards compatible.

 

 

HTH.

 

Best Regards,

Theo

 

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Scott Hallenger
Sent: 18 December 2014 18:41
To: arslist@ARSLIST.ORG
Subject: Re: Help with upgrade path

 

** 

Theo.. was this an ARS upgrade only, or were you upgrading the whole ITSM 
suite. I'm looking into an upgrading of only my ARS 7.0.01 base, which has ITSM 
running on top of it, to to 8.1 or 7.6. We would leave the ITSM portion as is 
for now. Are you saying to do this we need to install every version of ARS 
until we get to 8.1

 

On Monday, December 15, 2014 2:11 PM, Theo Fondse (GMail) 
theo.fon...@gmail.com mailto:theo.fon...@gmail.com  wrote:

 

** 

Hi Carina,

We upgraded our Custom-Only 7.1/10g/Slolaris server recently to 
7.6.4/11g/RedHat.

I always suggest NOT to skip a major version when doing an upgrade, due to the 
fact that BMC only supports the last 3 versions, and therefore, might not test 
their software during development for upgrades from unsupported versions at the 
time. (I seriously doubt that BMC would have tested a straight upgrade from 7.1 
to 7.6.04 or much less 8.0 or 8.1, due to their version support policies).

Before I started my current stint at the company where I am working now, they 
attempted an upgrade from 7.1 to 7.6.4 and failed several times.

Even with the assistance of a local support partner, the upgrade failed and 
they eventually gave up.

The solution to the problem later turned out to be that you should not skip any 
major versions and go through the installer logs to find out what went wrong if 
the installer fails.

We found a caveat with some of the AR System forms and tables which had to be 
addressed manually before the upgrade in order to get the upgrade to work.

I suggest the following steps which worked for us to do a successful upgrade 
(please test it first on a development/test environment before doing this on 
prod):

1.  Back up the current DB (full DB export dump).

2.  Export and delete all records from the AR System User Central File form.

3.  Export and delete all records from the AR System User Preference form.

4.  Temporary Disable Automatic Processes (performance tuning to make 
upgrade complete faster):

Escalations 

Alerts

Archive

Log Files

Server Events

5.  Temporary Decrease Threads count (max 2 each) to enable faster 
re-caching during upgrade.

6.  Shut Down AR System.

7.  Verify that the Oracle 11g 64 bit client has been installed on the 
server and update the tnsnames file for this client.

8.  Verify that at least java 1.6 32 and 64 bit has been installed.

9.  Comment out Db

Re: Help with upgrade path

[Carina Burns]

Thanks for the info Theo.  One more question.  Did you migrate the 3rd party 
pieces to 64bit as well?  We are using Exchange/Outlook for our mail server so 
we are using the MAPI protocol for the email engine.  This means we have to use 
the 32bit JRE.  I'm wondering whether I need to use the 32bit 2.4.x Apache 
HTTPD or whether I can use the 64bit.


On Mon, 15 Dec 2014 21:10:37 +0200, Theo Fondse (GMail) theo.fon...@gmail.com 
wrote:

Hi Carina,

We upgraded our Custom-Only 7.1/10g/Slolaris server recently to 
7.6.4/11g/RedHat.

I always suggest NOT to skip a major version when doing an upgrade, due to the 
fact that BMC only supports the last 3 versions, and therefore, might not test 
their software during development for upgrades from unsupported versions at 
the time. (I seriously doubt that BMC would have tested a straight upgrade 
from 7.1 to 7.6.04 or much less 8.0 or 8.1, due to their version support 
policies).

Before I started my current stint at the company where I am working now, they 
attempted an upgrade from 7.1 to 7.6.4 and failed several times.
Even with the assistance of a local support partner, the upgrade failed and 
they eventually gave up.

The solution to the problem later turned out to be that you should not skip 
any major versions and go through the installer logs to find out what went 
wrong if the installer fails.

We found a caveat with some of the AR System forms and tables which had to be 
addressed manually before the upgrade in order to get the upgrade to work.

I suggest the following steps which worked for us to do a successful upgrade 
(please test it first on a development/test environment before doing this on 
prod):

1. Back up the current DB (full DB export dump).
2. Export and delete all records from the AR System User Central File form.
3. Export and delete all records from the AR System User Preference form.
4. Temporary Disable Automatic Processes (performance tuning to make 
upgrade complete faster):
   Escalations 
   Alerts
   Archive
   Log Files
   Server Events
5. Temporary Decrease Threads count (max 2 each) to enable faster 
re-caching during upgrade.
6. Shut Down AR System.
7. Verify that the Oracle 11g 64 bit client has been installed on the 
server and update the tnsnames file for this client.
8. Verify that at least java 1.6 32 and 64 bit has been installed.
9. Comment out Db-Character-Set: UTF-8 parameter in ar.conf file if using 
UTF-8.
10.Run the following script on Oracle (fix for SW00327170):

CREATE TABLE SCHEMA_ARCHIVE_BACKUP
 AS
 SELECT SCHEMAID, ARCHIVEFROMFORM FROM SCHEMA_ARCHIVE;
COMMIT;

UPDATE SCHEMA_ARCHIVE
SET ARCHIVEFROMFORM = NULL;
COMMIT;

ALTER TABLE SCHEMA_ARCHIVE
MODIFY (ARCHIVEFROMFORM NUMBER (15));
COMMIT;

UPDATE SCHEMA_ARCHIVE
SET ARCHIVEFROMFORM =
(SELECT ARCHIVEFROMFORM
FROM SCHEMA_ARCHIVE_BACKUP
WHERE SCHEMA_ARCHIVE_BACKUP.SCHEMAID = SCHEMA_ARCHIVE.SCHEMAID);
COMMIT;

ALTER TABLE SCHEMA_ARCHIVE
MODIFY (ARCHIVEFROMFORM NOT NULL);
   


11.Upgrade to ARS 7.5.0 
12.Upgrade to ARS 7.6.04 SP5
13.Upgrade to ARS 8.0
14.Upgrade to ARS 8.1
15.Restore original config for
   Escalations 
   Alerts
   Archive
   Log Files
   Server Events
   Threads count
16.Import backed up records for the AR System User Central File form.
17.Import backed up records for the AR System User Preference form.
   

   
HTH,

Best Regards,
Theo


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: 12 December 2014 22:44
To: arslist@ARSLIST.ORG
Subject: Re: Help with upgrade path

My suggestion

Take a backup of the Oracle 10g data and copy/restore it to the Oracle 12c  
(Your DBA could also do this with oracle DataPump).   
Install 8.1 on the new server against the copy/restored data.   When 
installing it should ask you if you want to upgrade or start new in the 
database.  Choose upgrade.   
   (You do NOT need to have an existing set of ARS binaries on the new server 
 to choose upgrade as this only refers to the database data)

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Carina Burns
Sent: Friday, December 12, 2014 11:38 AM
To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG 
Subject: Help with upgrade path

Greetings!!!

I am turning to you all for suggestions for an upgrade path for our ARS 
system.  I've contacted BMC for advice, however our support contract level is 
Basic... which is also the adjective I would use to describe my current level 
of customer satisfaction.

Has anyone gone from ARS 7.1 to 8.1?  How did you do it?  
If you don't want to wade thru my specifics

Re: Help with upgrade path

[Carina Burns]

And I just read your other replyYou likely don't run HTTPD because you 
don't run Mid-Tier...

So I'll open the question to others, will Apache HTTPD 2.4.x 64bit work well 
with the 32bit JRE?  And is anyone running the later versions of JRE?  The 
support matrix lists JRE6u17 but Oracle has that in the Nope column.

On Fri, 19 Dec 2014 10:45:22 -0500, Carina Burns carina.bu...@risd.org wrote:

Thanks for the info Theo.  One more question.  Did you migrate the 3rd party 
pieces to 64bit as well?  We are using Exchange/Outlook for our mail server so 
we are using the MAPI protocol for the email engine.  This means we have to 
use the 32bit JRE.  I'm wondering whether I need to use the 32bit 2.4.x Apache 
HTTPD or whether I can use the 64bit.


On Mon, 15 Dec 2014 21:10:37 +0200, Theo Fondse (GMail) 
theo.fon...@gmail.com wrote:

Hi Carina,

We upgraded our Custom-Only 7.1/10g/Slolaris server recently to 
7.6.4/11g/RedHat.

I always suggest NOT to skip a major version when doing an upgrade, due to 
the fact that BMC only supports the last 3 versions, and therefore, might not 
test their software during development for upgrades from unsupported versions 
at the time. (I seriously doubt that BMC would have tested a straight upgrade 
from 7.1 to 7.6.04 or much less 8.0 or 8.1, due to their version support 
policies).

Before I started my current stint at the company where I am working now, they 
attempted an upgrade from 7.1 to 7.6.4 and failed several times.
Even with the assistance of a local support partner, the upgrade failed and 
they eventually gave up.

The solution to the problem later turned out to be that you should not skip 
any major versions and go through the installer logs to find out what went 
wrong if the installer fails.

We found a caveat with some of the AR System forms and tables which had to be 
addressed manually before the upgrade in order to get the upgrade to work.

I suggest the following steps which worked for us to do a successful upgrade 
(please test it first on a development/test environment before doing this on 
prod):

1.Back up the current DB (full DB export dump).
2.Export and delete all records from the AR System User Central File form.
3.Export and delete all records from the AR System User Preference form.
4.Temporary Disable Automatic Processes (performance tuning to make 
upgrade complete faster):
  Escalations 
  Alerts
  Archive
  Log Files
  Server Events
5.Temporary Decrease Threads count (max 2 each) to enable faster 
re-caching during upgrade.
6.Shut Down AR System.
7.Verify that the Oracle 11g 64 bit client has been installed on the 
server and update the tnsnames file for this client.
8.Verify that at least java 1.6 32 and 64 bit has been installed.
9.Comment out Db-Character-Set: UTF-8 parameter in ar.conf file if using 
UTF-8.
10.   Run the following script on Oracle (fix for SW00327170):

CREATE TABLE SCHEMA_ARCHIVE_BACKUP
 AS
 SELECT SCHEMAID, ARCHIVEFROMFORM FROM SCHEMA_ARCHIVE;
COMMIT;

UPDATE SCHEMA_ARCHIVE
SET ARCHIVEFROMFORM = NULL;
COMMIT;

ALTER TABLE SCHEMA_ARCHIVE
MODIFY (ARCHIVEFROMFORM NUMBER (15));
COMMIT;

UPDATE SCHEMA_ARCHIVE
SET ARCHIVEFROMFORM =
(SELECT ARCHIVEFROMFORM
FROM SCHEMA_ARCHIVE_BACKUP
WHERE SCHEMA_ARCHIVE_BACKUP.SCHEMAID = SCHEMA_ARCHIVE.SCHEMAID);
COMMIT;

ALTER TABLE SCHEMA_ARCHIVE
MODIFY (ARCHIVEFROMFORM NOT NULL);
  


11.   Upgrade to ARS 7.5.0 
12.   Upgrade to ARS 7.6.04 SP5
13.   Upgrade to ARS 8.0
14.   Upgrade to ARS 8.1
15.   Restore original config for
  Escalations 
  Alerts
  Archive
  Log Files
  Server Events
  Threads count
16.   Import backed up records for the AR System User Central File form.
17.   Import backed up records for the AR System User Preference form.
  

  
HTH,

Best Regards,
Theo


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: 12 December 2014 22:44
To: arslist@ARSLIST.ORG
Subject: Re: Help with upgrade path

My suggestion

Take a backup of the Oracle 10g data and copy/restore it to the Oracle 12c  
(Your DBA could also do this with oracle DataPump).   
Install 8.1 on the new server against the copy/restored data.   When 
installing it should ask you if you want to upgrade or start new in the 
database.  Choose upgrade.   
   (You do NOT need to have an existing set of ARS binaries on the new server 
 to choose upgrade as this only refers to the database data)

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Carina Burns
Sent: Friday, December 12, 2014 11:38 AM
To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG 
Subject: Help with upgrade path

Re: Help with upgrade path

[Theo Fondse]

Hi Carina,

We moved everything to 64-bit, but also installed a 32-bit copy of Java
especially for the Email Engine.

Best Regards,
Theo

On Fri, Dec 19, 2014 at 5:45 PM, Carina Burns carina.bu...@risd.org wrote:

 Thanks for the info Theo.  One more question.  Did you migrate the 3rd
 party pieces to 64bit as well?  We are using Exchange/Outlook for our mail
 server so we are using the MAPI protocol for the email engine.  This means
 we have to use the 32bit JRE.  I'm wondering whether I need to use the
 32bit 2.4.x Apache HTTPD or whether I can use the 64bit.


 On Mon, 15 Dec 2014 21:10:37 +0200, Theo Fondse (GMail) 
 theo.fon...@gmail.com wrote:

 Hi Carina,
 
 We upgraded our Custom-Only 7.1/10g/Slolaris server recently to
 7.6.4/11g/RedHat.
 
 I always suggest NOT to skip a major version when doing an upgrade, due
 to the fact that BMC only supports the last 3 versions, and therefore,
 might not test their software during development for upgrades from
 unsupported versions at the time. (I seriously doubt that BMC would have
 tested a straight upgrade from 7.1 to 7.6.04 or much less 8.0 or 8.1, due
 to their version support policies).
 
 Before I started my current stint at the company where I am working now,
 they attempted an upgrade from 7.1 to 7.6.4 and failed several times.
 Even with the assistance of a local support partner, the upgrade failed
 and they eventually gave up.
 
 The solution to the problem later turned out to be that you should not
 skip any major versions and go through the installer logs to find out what
 went wrong if the installer fails.
 
 We found a caveat with some of the AR System forms and tables which had
 to be addressed manually before the upgrade in order to get the upgrade to
 work.
 
 I suggest the following steps which worked for us to do a successful
 upgrade (please test it first on a development/test environment before
 doing this on prod):
 
 1. Back up the current DB (full DB export dump).
 2. Export and delete all records from the AR System User Central File
 form.
 3. Export and delete all records from the AR System User Preference
 form.
 4. Temporary Disable Automatic Processes (performance tuning to make
 upgrade complete faster):
Escalations
Alerts
Archive
Log Files
Server Events
 5. Temporary Decrease Threads count (max 2 each) to enable faster
 re-caching during upgrade.
 6. Shut Down AR System.
 7. Verify that the Oracle 11g 64 bit client has been installed on the
 server and update the tnsnames file for this client.
 8. Verify that at least java 1.6 32 and 64 bit has been installed.
 9. Comment out Db-Character-Set: UTF-8 parameter in ar.conf file if
 using UTF-8.
 10.Run the following script on Oracle (fix for SW00327170):
 
 CREATE TABLE SCHEMA_ARCHIVE_BACKUP
  AS
  SELECT SCHEMAID, ARCHIVEFROMFORM FROM SCHEMA_ARCHIVE;
 COMMIT;
 
 UPDATE SCHEMA_ARCHIVE
 SET ARCHIVEFROMFORM = NULL;
 COMMIT;
 
 ALTER TABLE SCHEMA_ARCHIVE
 MODIFY (ARCHIVEFROMFORM NUMBER (15));
 COMMIT;
 
 UPDATE SCHEMA_ARCHIVE
 SET ARCHIVEFROMFORM =
 (SELECT ARCHIVEFROMFORM
 FROM SCHEMA_ARCHIVE_BACKUP
 WHERE SCHEMA_ARCHIVE_BACKUP.SCHEMAID = SCHEMA_ARCHIVE.SCHEMAID);
 COMMIT;
 
 ALTER TABLE SCHEMA_ARCHIVE
 MODIFY (ARCHIVEFROMFORM NOT NULL);
 
 
 
 11.Upgrade to ARS 7.5.0
 12.Upgrade to ARS 7.6.04 SP5
 13.Upgrade to ARS 8.0
 14.Upgrade to ARS 8.1
 15.Restore original config for
Escalations
Alerts
Archive
Log Files
Server Events
Threads count
 16.Import backed up records for the AR System User Central File form.
 17.Import backed up records for the AR System User Preference form.
 
 
 
 HTH,
 
 Best Regards,
 Theo
 
 
 -Original Message-
 From: Action Request System discussion list(ARSList) [mailto:
 arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
 Sent: 12 December 2014 22:44
 To: arslist@ARSLIST.ORG
 Subject: Re: Help with upgrade path
 
 My suggestion
 
 Take a backup of the Oracle 10g data and copy/restore it to the Oracle
 12c  (Your DBA could also do this with oracle DataPump).
 Install 8.1 on the new server against the copy/restored data.   When
 installing it should ask you if you want to upgrade or start new in the
 database.  Choose upgrade.
(You do NOT need to have an existing set of ARS binaries on the new
 server to choose upgrade as this only refers to the database data)
 
 Fred
 
 -Original Message-
 From: Action Request System discussion list(ARSList) [mailto:
 arslist@ARSLIST.ORG] On Behalf Of Carina Burns
 Sent: Friday, December 12, 2014 11:38 AM
 To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG
 Subject: Help with upgrade path
 
 Greetings!!!
 
 I am turning to you all for suggestions for an upgrade path for our

Re: Help with upgrade path

[Theo Fondse]

Hi Carina,

We are running Mid-Tier, but with Tomcat on it's own and without HTTPD.
You do not need httpd to run mid-tier unless you want to host other
normal web sites/pages.

Mid-Tier is perfectly happy on Tomcat only.
(You can even configure Tomcat to bind on Port 80 in stead of 8080 if you
want to.)

Best Regards,
Theo


On Fri, Dec 19, 2014 at 5:52 PM, Carina Burns carina.bu...@risd.org wrote:

 And I just read your other replyYou likely don't run HTTPD because you
 don't run Mid-Tier...

 So I'll open the question to others, will Apache HTTPD 2.4.x 64bit work
 well with the 32bit JRE?  And is anyone running the later versions of JRE?
 The support matrix lists JRE6u17 but Oracle has that in the Nope column.

 On Fri, 19 Dec 2014 10:45:22 -0500, Carina Burns carina.bu...@risd.org
 wrote:

 Thanks for the info Theo.  One more question.  Did you migrate the 3rd
 party pieces to 64bit as well?  We are using Exchange/Outlook for our mail
 server so we are using the MAPI protocol for the email engine.  This means
 we have to use the 32bit JRE.  I'm wondering whether I need to use the
 32bit 2.4.x Apache HTTPD or whether I can use the 64bit.
 
 
 On Mon, 15 Dec 2014 21:10:37 +0200, Theo Fondse (GMail) 
 theo.fon...@gmail.com wrote:
 
 Hi Carina,
 
 We upgraded our Custom-Only 7.1/10g/Slolaris server recently to
 7.6.4/11g/RedHat.
 
 I always suggest NOT to skip a major version when doing an upgrade, due
 to the fact that BMC only supports the last 3 versions, and therefore,
 might not test their software during development for upgrades from
 unsupported versions at the time. (I seriously doubt that BMC would have
 tested a straight upgrade from 7.1 to 7.6.04 or much less 8.0 or 8.1, due
 to their version support policies).
 
 Before I started my current stint at the company where I am working now,
 they attempted an upgrade from 7.1 to 7.6.4 and failed several times.
 Even with the assistance of a local support partner, the upgrade failed
 and they eventually gave up.
 
 The solution to the problem later turned out to be that you should not
 skip any major versions and go through the installer logs to find out what
 went wrong if the installer fails.
 
 We found a caveat with some of the AR System forms and tables which had
 to be addressed manually before the upgrade in order to get the upgrade to
 work.
 
 I suggest the following steps which worked for us to do a successful
 upgrade (please test it first on a development/test environment before
 doing this on prod):
 
 1.Back up the current DB (full DB export dump).
 2.Export and delete all records from the AR System User Central File
 form.
 3.Export and delete all records from the AR System User Preference
 form.
 4.Temporary Disable Automatic Processes (performance tuning to make
 upgrade complete faster):
   Escalations
   Alerts
   Archive
   Log Files
   Server Events
 5.Temporary Decrease Threads count (max 2 each) to enable faster
 re-caching during upgrade.
 6.Shut Down AR System.
 7.Verify that the Oracle 11g 64 bit client has been installed on the
 server and update the tnsnames file for this client.
 8.Verify that at least java 1.6 32 and 64 bit has been installed.
 9.Comment out Db-Character-Set: UTF-8 parameter in ar.conf file if
 using UTF-8.
 10.   Run the following script on Oracle (fix for SW00327170):
 
 CREATE TABLE SCHEMA_ARCHIVE_BACKUP
  AS
  SELECT SCHEMAID, ARCHIVEFROMFORM FROM SCHEMA_ARCHIVE;
 COMMIT;
 
 UPDATE SCHEMA_ARCHIVE
 SET ARCHIVEFROMFORM = NULL;
 COMMIT;
 
 ALTER TABLE SCHEMA_ARCHIVE
 MODIFY (ARCHIVEFROMFORM NUMBER (15));
 COMMIT;
 
 UPDATE SCHEMA_ARCHIVE
 SET ARCHIVEFROMFORM =
 (SELECT ARCHIVEFROMFORM
 FROM SCHEMA_ARCHIVE_BACKUP
 WHERE SCHEMA_ARCHIVE_BACKUP.SCHEMAID = SCHEMA_ARCHIVE.SCHEMAID);
 COMMIT;
 
 ALTER TABLE SCHEMA_ARCHIVE
 MODIFY (ARCHIVEFROMFORM NOT NULL);
 
 
 
 11.   Upgrade to ARS 7.5.0
 12.   Upgrade to ARS 7.6.04 SP5
 13.   Upgrade to ARS 8.0
 14.   Upgrade to ARS 8.1
 15.   Restore original config for
   Escalations
   Alerts
   Archive
   Log Files
   Server Events
   Threads count
 16.   Import backed up records for the AR System User Central File form.
 17.   Import backed up records for the AR System User Preference form.
 
 
 
 HTH,
 
 Best Regards,
 Theo
 
 
 -Original Message-
 From: Action Request System discussion list(ARSList) [mailto:
 arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
 Sent: 12 December 2014 22:44
 To: arslist@ARSLIST.ORG
 Subject: Re: Help with upgrade path
 
 My suggestion
 
 Take a backup of the Oracle 10g data and copy/restore it to the Oracle
 12c  (Your DBA could also do this with oracle DataPump).
 Install 8.1 on the new server against the copy/restored data.   When
 installing it should ask you if you

Re: Help with upgrade path

[Carina Burns]

I just searched oracle support and can't find anything on SW00327170.  The only 
thing listed is a bug that isn't a bug but a config issue with OraDB 7.2.  Do 
you have any other reference number or doc id for this archive fix?

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help with upgrade path

[Carina Burns]

I just looked and that column in our linux Ora10g  Schema_archive table is a 
varchar2(254) with no “not null” constraint.  I don’t think I’m going to change 
it to a number(15) not null column before I try the upgrade since this may be a 
Solaris only issue.  If the upgrade bombs then I’ll look over the install log 
and see if it’s something I should address.

Thanks for the heads up though.

From: Theo Fondse [mailto:theo.fon...@gmail.com] 
Sent: Friday, December 19, 2014 10:25 AM
To: Burns, Carina
Subject: Re: Help with upgrade path

Nope, SW00327170 is on BMC.
I see how you could have thought it was on Oracle...  :-)

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help with upgrade path

[Theo Fondse]

You're welcome!

Let me know if the upgrade works for you without running the SW00327170
script.
Would be interesting to note.

Good luck with the rest of your upgrade hope all goes well!


On Fri, Dec 19, 2014 at 7:10 PM, Carina Burns carina.bu...@risd.org wrote:

 I just looked and that column in our linux Ora10g  Schema_archive table is
 a varchar2(254) with no “not null” constraint.  I don’t think I’m going to
 change it to a number(15) not null column before I try the upgrade since
 this may be a Solaris only issue.  If the upgrade bombs then I’ll look over
 the install log and see if it’s something I should address.

 Thanks for the heads up though.

 From: Theo Fondse [mailto:theo.fon...@gmail.com]
 Sent: Friday, December 19, 2014 10:25 AM
 To: Burns, Carina
 Subject: Re: Help with upgrade path

 Nope, SW00327170 is on BMC.
 I see how you could have thought it was on Oracle...  :-)


 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Where the Answers Are, and have been for 20 years


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help with upgrade path

[Carina Burns]

Interesting!  I put the question in on my support ticket as this doc on 
software requirements suggests HTTPD is required to install ARS 8.1
https://docs.bmc.com/docs/display/public/ars81/Software+requirements

And... it drives me nuts that the minimums are specified on the compatibility 
matrix but not which most recent version is stable.  You said you installed 
both the 32bit and 64bit JRE's?  Which versions did you use?

On Fri, 19 Dec 2014 18:09:06 +0200, Theo Fondse theo.fon...@gmail.com wrote:

Hi Carina,

We are running Mid-Tier, but with Tomcat on it's own and without HTTPD.
You do not need httpd to run mid-tier unless you want to host other
normal web sites/pages.

Mid-Tier is perfectly happy on Tomcat only.
(You can even configure Tomcat to bind on Port 80 in stead of 8080 if you
want to.)

Best Regards,
Theo

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help with upgrade path

[Grooms, Frederick W]

Do you have any data in the ARCHIVEFROMFORM column?  If not then you should be 
safe.  Since we did not use archiving all we had to do was make sure it was 
empty   
We are on Linux as well and there was a few small issues going from 6.3  to 
7.6.04 

Here is the script we used to correct them
truncate table ALERT_USER;  
commit;
-- Since no one can be logged in to the Alert tool while the upgrade is 
going on it seemed a good time to clear the list

-- Backup FIELD_ENUM
Create Table FWG_FIELD_ENUM as
select * from FIELD_ENUM;
commit;
Update FIELD_ENUM set ENUMSTYLE = NULL;
COMMIT;
ALTER TABLE FIELD_ENUM MODIFY (ENUMSTYLE NUMBER(15));
COMMIT;
Update Field_ENUM f
Set ENUMSTYLE = (
   Select ENUMSTYLE from FWG_FIELD_ENUM
   Where SCHEMAID=f.SCHEMAID and FIELDID=f.FIELDID)
Where  exists (Select ENUMSTYLE from FWG_FIELD_ENUM
   Where SCHEMAID=f.SCHEMAID and FIELDID=f.FIELDID);
Commit;

-- Backup FILTER_NOTIFY
Create Table FWG_FILTER_NOTIFY as
select * from FILTER_NOTIFY;
Commit;
Update FILTER_NOTIFY set BEHAVIOR = NULL, PERMISSION=NULL;
Commit;
ALTER TABLE FILTER_NOTIFY MODIFY (BEHAVIOR NUMBER(15), PERMISSION 
NUMBER(15) );
COMMIT;
Update FILTER_NOTIFY set BEHAVIOR = 0, PERMISSION=0;
Commit;

-- Backup SCHEMA_ARCHIVE
Create Table FWG_SCHEMA_ARCHIVE as
select * from SCHEMA_ARCHIVE;
Commit;
Update SCHEMA_ARCHIVE
set ARCHIVEFROMFORM=NULL;
Commit;


In order to speed up the upgrade I truncated the Flashboards historical server 
statistics data   
-- Flashboards  209 = FB_CUMULATIVESERVERSTATISTICS, 210 = 
FB_NONCUMULATIVESERVERSTATISTI
Truncate Table T209 Drop Storage;
Truncate Table H209 Drop Storage;
Truncate Table B209 Drop Storage;
Truncate Table T210 Drop Storage;
Truncate Table H210 Drop Storage;
Truncate Table B210 Drop Storage;

These forms were converted to Vendor Forms (We didn't use Flashboards so I 
could just drop them and the upgrade created the new Vendor ones)
FB:Alarm Monitor
FB:DataSourceVariables   
FB:Flashboards   
FB:Variable   
FB:Variable Attributes   


Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Carina Burns
Sent: Friday, December 19, 2014 11:11 AM
To: arslist@ARSLIST.ORG
Subject: Re: Help with upgrade path

I just looked and that column in our linux Ora10g  Schema_archive table is a 
varchar2(254) with no “not null” constraint.  I don’t think I’m going to change 
it to a number(15) not null column before I try the upgrade since this may be a 
Solaris only issue.  If the upgrade bombs then I’ll look over the install log 
and see if it’s something I should address.

Thanks for the heads up though.

-Original Message-
From: Theo Fondse [mailto:theo.fon...@gmail.com] 
Sent: Friday, December 19, 2014 10:25 AM
To: Burns, Carina
Subject: Re: Help with upgrade path

Nope, SW00327170 is on BMC.
I see how you could have thought it was on Oracle...  :-) 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help with upgrade path

[Scott Hallenger]

Theo.. was this an ARS upgrade only, or were you upgrading the whole ITSM 
suite. I'm looking into an upgrading of only my ARS 7.0.01 base, which has ITSM 
running on top of it, to to 8.1 or 7.6. We would leave the ITSM portion as is 
for now. Are you saying to do this we need to install every version of ARS 
until we get to 8.1 

 On Monday, December 15, 2014 2:11 PM, Theo Fondse (GMail) 
theo.fon...@gmail.com wrote:
   

 **RE: Help with upgrade pathHi Carina,We upgraded our Custom-Only 
7.1/10g/Slolaris server recently to 7.6.4/11g/RedHat.I always suggest NOT to 
skip a major version when doing an upgrade, due to the fact that BMC only 
supports the last 3 versions, and therefore, might not test their software 
during development for upgrades from unsupported versions at the time. (I 
seriously doubt that BMC would have tested a straight upgrade from 7.1 to 
7.6.04 or much less 8.0 or 8.1, due to their version support policies).Before I 
started my current stint at the company where I am working now, they attempted 
an upgrade from 7.1 to 7.6.4 and failed several times.Even with the assistance 
of a local support partner, the upgrade failed and they eventually gave up.The 
solution to the problem later turned out to be that you should not skip any 
major versions and go through the installer logs to find out what went wrong if 
the installer fails.We found a caveat with some of the AR System forms and 
tables which had to be addressed manually before the upgrade in order to get 
the upgrade to work.I suggest the following steps which worked for us to do a 
successful upgrade (please test it first on a development/test environment 
before doing this on prod):1.  Back up the current DB (full DB export 
dump).2.  Export and delete all records from the AR System User Central 
File form.3.  Export and delete all records from the AR System User 
Preference form.4.  Temporary Disable Automatic Processes (performance 
tuning to make upgrade complete faster):   
   
    Escalations     Alerts    Archive    Log Files    
Server Events5.  Temporary Decrease Threads count (max 2 each) to enable 
faster re-caching during upgrade.6.  Shut Down AR System.7.  Verify 
that the Oracle 11g 64 bit client has been installed on the server and update 
the tnsnames file for this client.8.  Verify that at least java 1.6 32 and 
64 bit has been installed.9.  Comment out Db-Character-Set: UTF-8 parameter 
in ar.conf file if using UTF-8.10. Run the following script on Oracle (fix 
for SW00327170):CREATE TABLE SCHEMA_ARCHIVE_BACKUP AS SELECT SCHEMAID, 
ARCHIVEFROMFORM FROM SCHEMA_ARCHIVE;COMMIT;UPDATE SCHEMA_ARCHIVESET 
ARCHIVEFROMFORM = NULL;COMMIT;ALTER TABLE SCHEMA_ARCHIVEMODIFY (ARCHIVEFROMFORM 
NUMBER (15));COMMIT;UPDATE SCHEMA_ARCHIVESET ARCHIVEFROMFORM =(SELECT 
ARCHIVEFROMFORMFROM SCHEMA_ARCHIVE_BACKUPWHERE SCHEMA_ARCHIVE_BACKUP.SCHEMAID = 
SCHEMA_ARCHIVE.SCHEMAID);COMMIT;ALTER TABLE SCHEMA_ARCHIVEMODIFY 
(ARCHIVEFROMFORM NOT NULL);   
11. Upgrade to ARS 7.5.0 12. Upgrade to ARS 7.6.04 SP513. Upgrade 
to ARS 8.014. Upgrade to ARS 8.115. Restore original config for   
   
    Escalations     Alerts    Archive    Log Files    
Server Events    Threads count16. Import backed up records for the AR 
System User Central File form.17. Import backed up records for the AR 
System User Preference form.   
HTH,Best Regards,Theo-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: 12 December 2014 22:44
To: arslist@ARSLIST.ORG
Subject: Re: Help with upgrade pathMy suggestionTake a backup of the Oracle 10g 
data and copy/restore it to the Oracle 12c  (Your DBA could also do this with 
oracle DataPump).   Install 8.1 on the new server against the copy/restored 
data.   When installing it should ask you if you want to upgrade or start new 
in the database.  Choose upgrade.      (You do NOT need to have an existing set 
of ARS binaries on the new server to choose upgrade as this only refers to the 
database data)Fred-Original Message-From: Action Request System 
discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Carina 
BurnsSent: Friday, December 12, 2014 11:38 AMTo: arslist@ARSLIST.ORGSubject: 
Help with upgrade pathGreetings!!!I am turning to you all for suggestions for 
an upgrade path for our ARS system.  I've contacted BMC for advice, however our 
support contract level is Basic... which is also the adjective I would use to 
describe my current level of customer satisfaction.Has anyone gone from ARS 7.1 
to 8.1?  How did you do it?  If you don't want to wade thru my specifics, 
kindly preface your reply with TLDR before you explain your upgrade method.The 
specifics:  Our production set up isARS 7.1 patch 11 / Midtier7.0.01 patch 5/ 
Apache Tomcat 5.027 / Crystal Reports XI running on WinSvr

Re: Help with upgrade path

[Theo Fondse (GMail)]

Hi Carina,

We upgraded our Custom-Only 7.1/10g/Slolaris server recently to 
7.6.4/11g/RedHat.

I always suggest NOT to skip a major version when doing an upgrade, due to the 
fact that BMC only supports the last 3 versions, and therefore, might not test 
their software during development for upgrades from unsupported versions at the 
time. (I seriously doubt that BMC would have tested a straight upgrade from 7.1 
to 7.6.04 or much less 8.0 or 8.1, due to their version support policies).

Before I started my current stint at the company where I am working now, they 
attempted an upgrade from 7.1 to 7.6.4 and failed several times.
Even with the assistance of a local support partner, the upgrade failed and 
they eventually gave up.

The solution to the problem later turned out to be that you should not skip any 
major versions and go through the installer logs to find out what went wrong if 
the installer fails.

We found a caveat with some of the AR System forms and tables which had to be 
addressed manually before the upgrade in order to get the upgrade to work.

I suggest the following steps which worked for us to do a successful upgrade 
(please test it first on a development/test environment before doing this on 
prod):

1.  Back up the current DB (full DB export dump).
2.  Export and delete all records from the AR System User Central File form.
3.  Export and delete all records from the AR System User Preference form.
4.  Temporary Disable Automatic Processes (performance tuning to make 
upgrade complete faster):
Escalations 
Alerts
Archive
Log Files
Server Events
5.  Temporary Decrease Threads count (max 2 each) to enable faster 
re-caching during upgrade.
6.  Shut Down AR System.
7.  Verify that the Oracle 11g 64 bit client has been installed on the 
server and update the tnsnames file for this client.
8.  Verify that at least java 1.6 32 and 64 bit has been installed.
9.  Comment out Db-Character-Set: UTF-8 parameter in ar.conf file if using 
UTF-8.
10. Run the following script on Oracle (fix for SW00327170):

CREATE TABLE SCHEMA_ARCHIVE_BACKUP
 AS
 SELECT SCHEMAID, ARCHIVEFROMFORM FROM SCHEMA_ARCHIVE;
COMMIT;

UPDATE SCHEMA_ARCHIVE
SET ARCHIVEFROMFORM = NULL;
COMMIT;

ALTER TABLE SCHEMA_ARCHIVE
MODIFY (ARCHIVEFROMFORM NUMBER (15));
COMMIT;

UPDATE SCHEMA_ARCHIVE
SET ARCHIVEFROMFORM =
(SELECT ARCHIVEFROMFORM
FROM SCHEMA_ARCHIVE_BACKUP
WHERE SCHEMA_ARCHIVE_BACKUP.SCHEMAID = SCHEMA_ARCHIVE.SCHEMAID);
COMMIT;

ALTER TABLE SCHEMA_ARCHIVE
MODIFY (ARCHIVEFROMFORM NOT NULL);



11. Upgrade to ARS 7.5.0 
12. Upgrade to ARS 7.6.04 SP5
13. Upgrade to ARS 8.0
14. Upgrade to ARS 8.1
15. Restore original config for
Escalations 
Alerts
Archive
Log Files
Server Events
Threads count
16. Import backed up records for the AR System User Central File form.
17. Import backed up records for the AR System User Preference form.



HTH,

Best Regards,
Theo


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: 12 December 2014 22:44
To: arslist@ARSLIST.ORG
Subject: Re: Help with upgrade path

My suggestion

Take a backup of the Oracle 10g data and copy/restore it to the Oracle 12c  
(Your DBA could also do this with oracle DataPump).   
Install 8.1 on the new server against the copy/restored data.   When installing 
it should ask you if you want to upgrade or start new in the database.  Choose 
upgrade.   
   (You do NOT need to have an existing set of ARS binaries on the new server 
to choose upgrade as this only refers to the database data)

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Carina Burns
Sent: Friday, December 12, 2014 11:38 AM
To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG 
Subject: Help with upgrade path

Greetings!!!

I am turning to you all for suggestions for an upgrade path for our ARS system. 
 I've contacted BMC for advice, however our support contract level is Basic... 
which is also the adjective I would use to describe my current level of 
customer satisfaction.

Has anyone gone from ARS 7.1 to 8.1?  How did you do it?  
If you don't want to wade thru my specifics, kindly preface your reply with 
TLDR before you explain your upgrade method.

The specifics:  
Our production set up is
ARS 7.1 patch 11 / Midtier7.0.01 patch 5/ Apache Tomcat 5.027 / Crystal Reports 
XI running on WinSvr 2003 SP2 against an Oracle 10g last patch database on 
RedHat Enterprise 4.0

I had thought to step thru and upgrade to 7.6 and then to 8.1 but was advised 
after opening a support ticket

Re: Help with upgrade path

[Carina Burns]

I should add that the first suggestion I received on my new support ticket was 
to upgrade the Oracle 10g database to 12c.  Unfortunately, as there are other 
applications pointing to it that aren't certified with 12c, I can't do this.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help with upgrade path

[William Rentfrow]

Okay, so - you're all custom.  That's good.

How many regular (data) forms are we talking about here?  Dozens? Hundreds?

William Rentfrow
wrentf...@stratacominc.com
Office: 715-204-3061 or 701-232-5697x25
Cell: 715-498-5056


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Carina Burns
Sent: Friday, December 12, 2014 11:38 AM
To: arslist@ARSLIST.ORG
Subject: Help with upgrade path

Greetings!!!

I am turning to you all for suggestions for an upgrade path for our ARS system. 
 I've contacted BMC for advice, however our support contract level is Basic... 
which is also the adjective I would use to describe my current level of 
customer satisfaction.

Has anyone gone from ARS 7.1 to 8.1?  How did you do it?  
If you don't want to wade thru my specifics, kindly preface your reply with 
TLDR before you explain your upgrade method.

The specifics:  
Our production set up is
ARS 7.1 patch 11 / Midtier7.0.01 patch 5/ Apache Tomcat 5.027 / Crystal Reports 
XI running on WinSvr 2003 SP2 against an Oracle 10g last patch database on 
RedHat Enterprise 4.0

I had thought to step thru and upgrade to 7.6 and then to 8.1 but was advised 
after opening a support ticket that since we have custom forms only and are not 
using ITSM or any other BMC app, we could go straight to 8.1 from 7.1.  

The compatibility matrix lists the minimums but states that any newer versions 
are supported for OS and database.  Since hardware only gets upgraded when bond 
money exists about every 5-7 years at our school district, I asked for the 
latest/greatest.  I cleared my choices/plan with support but since it was going 
to take a while to get the servers, I closed the ticket saying I would open 
another once I had my gear.

My new servers are virtual; a WinSvr2012 R2 and a Oracle Linux 6 box.  I put 
Oracle 12c on as the database.

I had thought to install ARS 7.1 as a new install, delete the data, copy the 
production 10g AR schema over to the 12c user, then run 8.1 as an upgrade. 
That's essentially how I did it the last time and support confirmed that a 
number of people run their upgrades that way.  But Oh-Oh! 7.1 is 32bit and 
doesn't want to install on my Win 64bit OS...Maybe both support and I missed 
that little hitch or perhaps I misunderstood.  Anyhow, I opened a new ticket 
and asked if I could do the same thing but with 8.1 instead.  In other words, 
install ARS 8.1 as a new install, delete the data, copy over the 10g AR schema 
to the 12c user, then run 8.1 again as an upgrade.

Here are the answers I got back on my ticket (paraphrased):
A) 7.1 isn't supported,
B) I was free to experiment using the new install/delete data/move schema/run 
upgrade method but it may not work
C) I can try to install 8.1 as new and use the Migrator to move over all my 
custom forms
D) Contract professional services and pay BMC to help with my upgrade

Option D isn't going to happen.  So I am left with options B and C.  The 
analyst on the first support ticket didn't think Migrator would be necessary 
since we aren't using ITSM.  Thoughts on that (While I go read the migrator 
documentation)?  Comments on option B?

Thanks in advance!
Carina

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers 
Are, and have been for 20 years

-
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2014.0.4794 / Virus Database: 4189/8665 - Release Date: 12/01/14 
Internal Virus Database is out of date.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help with upgrade path

[LJ LongWing]

Carina,
I have done a 7.5 32-bit - 8.1 64-bit before, and I did exactly like you
said...install a new on the new server, and then upgrade

The thing about the upgrade is that it's not necessarily upgrading the DB
that was installed, it's upgrading the DB that's pointed to during the
upgradeso, from that, what I would try, and expect it to work, is to
1 - Install 8.1 in a 'new' install on the new hardware, new db, etc
2 - Restore the prod db to the same server as the new install was done to
3 - Point your 'new' install to the restored db via config files
4 - Upgrade the Remedy install to 8.1

which is essentially option B if I'm not mistaken...

On Fri, Dec 12, 2014 at 10:54 AM, Carina Burns carina.bu...@risd.org
wrote:

 I should add that the first suggestion I received on my new support ticket
 was to upgrade the Oracle 10g database to 12c.  Unfortunately, as there are
 other applications pointing to it that aren't certified with 12c, I can't
 do this.


 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Where the Answers Are, and have been for 20 years


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help with upgrade path

[Joe D'Souza]

Find out from Support if the Database version necessarily needs to be at 12c
or just the Oracle client that the AR System would use.

Since you are all custom and no OTB, your upgrade path should be quite
simple.

Just make sure that you do not have any customizations done to ANY of the
OTB forms (core AR System forms in your case since you do not use ITSM).

If you have customizations, to any of the OTB forms, those customizations
would need to be converted to an overlay.

I do not know specifics about 8.x to do this, but for 7.6.04 the BPCU
utility would take care of that for you.

Find out if you need to use something similar.

Cheers

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Carina Burns
Sent: Friday, December 12, 2014 12:55 PM
To: arslist@ARSLIST.ORG
Subject: Re: Help with upgrade path

I should add that the first suggestion I received on my new support ticket
was to upgrade the Oracle 10g database to 12c.  Unfortunately, as there are
other applications pointing to it that aren't certified with 12c, I can't do
this.


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help with upgrade path

[Joe D'Souza]

I would not go with D either if I didn't want to pay my way through an
upgrade.

From your description your path is fairly straight forward with only the
consideration about your database compatibility with your current
applications and other applications that use the same database.

Your options as I see it are:

I. Check if installing the 12c clients for use of the AR Server would allow
that client to connect successfully to the older database and not impact
operations on  the AR Server.

II. Check if upgrading the database but leaving the oracle clients at your
current client versions would impact those other applications that uses the
current Oracle client for those apps.

III Go with a dedicated databse for the AR System by installing as a new
install and then migrate your current applications using your preferred
choice of migration tools that are available for 8.1

Cheers

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Carina Burns
Sent: Friday, December 12, 2014 12:38 PM
To: arslist@ARSLIST.ORG
Subject: Help with upgrade path

Greetings!!!

I am turning to you all for suggestions for an upgrade path for our ARS
system.  I've contacted BMC for advice, however our support contract level
is Basic... which is also the adjective I would use to describe my current
level of customer satisfaction.

Has anyone gone from ARS 7.1 to 8.1?  How did you do it?  
If you don't want to wade thru my specifics, kindly preface your reply with
TLDR before you explain your upgrade method.

The specifics:  
Our production set up is 
ARS 7.1 patch 11 / Midtier7.0.01 patch 5/ Apache Tomcat 5.027 / Crystal
Reports XI running on WinSvr 2003 SP2
against an
Oracle 10g last patch database on RedHat Enterprise 4.0

I had thought to step thru and upgrade to 7.6 and then to 8.1 but was
advised after opening a support ticket that since we have custom forms only
and are not using ITSM or any other BMC app, we could go straight to 8.1
from 7.1.  

The compatibility matrix lists the minimums but states that any newer
versions are supported for OS and database.  Since hardware only gets
upgraded when bond money exists about every 5-7 years at our school
district, I asked for the latest/greatest.  I cleared my choices/plan with
support but since it was going to take a while to get the servers, I closed
the ticket saying I would open another once I had my gear.

My new servers are virtual; a WinSvr2012 R2 and a Oracle Linux 6 box.  I put
Oracle 12c on as the database.

I had thought to install ARS 7.1 as a new install, delete the data, copy
the production 10g AR schema over to the 12c user, then run 8.1 as an
upgrade. That's essentially how I did it the last time and support confirmed
that a number of people run their upgrades that way.  But Oh-Oh! 7.1 is
32bit and doesn't want to install on my Win 64bit OS...Maybe both support
and I missed that little hitch or perhaps I misunderstood.  Anyhow, I opened
a new ticket and asked if I could do the same thing but with 8.1 instead.
In other words, install ARS 8.1 as a new install, delete the data, copy over
the 10g AR schema to the 12c user, then run 8.1 again as an upgrade.

Here are the answers I got back on my ticket (paraphrased):
A) 7.1 isn't supported, 
B) I was free to experiment using the new install/delete data/move
schema/run upgrade method but it may not work
C) I can try to install 8.1 as new and use the Migrator to move over all my
custom forms
D) Contract professional services and pay BMC to help with my upgrade

Option D isn't going to happen.  So I am left with options B and C.  The
analyst on the first support ticket didn't think Migrator would be necessary
since we aren't using ITSM.  Thoughts on that (While I go read the migrator
documentation)?  Comments on option B?

Thanks in advance!
Carina


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help with upgrade path

[Misi Mladoniczky]

Hi,

1. Install a new system with the new version.
2. Use RRR|Chive to migrate data (1 day to 4 weeks depending on size)
3. Do a delta data migration with RRR|Chive to catch up production
4. Stop production, do a final delta migration, switch server

The total outage can be brought down to an hour or two.

Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)

Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.

 Greetings!!!

 I am turning to you all for suggestions for an upgrade path for our ARS
 system.  I've contacted BMC for advice, however our support contract level is
 Basic... which is also the adjective I would use to describe my current level
 of customer satisfaction.

 Has anyone gone from ARS 7.1 to 8.1?  How did you do it?
 If you don't want to wade thru my specifics, kindly preface your reply with
 TLDR before you explain your upgrade method.

 The specifics:
 Our production set up is
 ARS 7.1 patch 11 / Midtier7.0.01 patch 5/ Apache Tomcat 5.027 / Crystal
 Reports XI running on WinSvr 2003 SP2
 against an
 Oracle 10g last patch database on RedHat Enterprise 4.0

 I had thought to step thru and upgrade to 7.6 and then to 8.1 but was advised
 after opening a support ticket that since we have custom forms only and are
 not using ITSM or any other BMC app, we could go straight to 8.1 from 7.1.

 The compatibility matrix lists the minimums but states that any newer versions
 are supported for OS and database.  Since hardware only gets upgraded when
 bond money exists about every 5-7 years at our school district, I asked for
 the latest/greatest.  I cleared my choices/plan with support but since it was
 going to take a while to get the servers, I closed the ticket saying I would
 open another once I had my gear.

 My new servers are virtual; a WinSvr2012 R2 and a Oracle Linux 6 box.  I put
 Oracle 12c on as the database.

 I had thought to install ARS 7.1 as a new install, delete the data, copy the
 production 10g AR schema over to the 12c user, then run 8.1 as an upgrade.
 That's essentially how I did it the last time and support confirmed that a
 number of people run their upgrades that way.  But Oh-Oh! 7.1 is 32bit and
 doesn't want to install on my Win 64bit OS...Maybe both support and I missed
 that little hitch or perhaps I misunderstood.  Anyhow, I opened a new ticket
 and asked if I could do the same thing but with 8.1 instead.  In other words,
 install ARS 8.1 as a new install, delete the data, copy over the 10g AR schema
 to the 12c user, then run 8.1 again as an upgrade.

 Here are the answers I got back on my ticket (paraphrased):
 A) 7.1 isn't supported,
 B) I was free to experiment using the new install/delete data/move schema/run
 upgrade method but it may not work
 C) I can try to install 8.1 as new and use the Migrator to move over all my
 custom forms
 D) Contract professional services and pay BMC to help with my upgrade

 Option D isn't going to happen.  So I am left with options B and C.  The
 analyst on the first support ticket didn't think Migrator would be necessary
 since we aren't using ITSM.  Thoughts on that (While I go read the migrator
 documentation)?  Comments on option B?

 Thanks in advance!
 Carina

 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Where the Answers Are, and have been for 20 years


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help with upgrade path

[Carina Burns]

Less than 100, no style sheets.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help with upgrade path

[Grooms, Frederick W]

My suggestion

Take a backup of the Oracle 10g data and copy/restore it to the Oracle 12c  
(Your DBA could also do this with oracle DataPump).   
Install 8.1 on the new server against the copy/restored data.   When installing 
it should ask you if you want to upgrade or start new in the database.  Choose 
upgrade.   
   (You do NOT need to have an existing set of ARS binaries on the new server 
to choose upgrade as this only refers to the database data)

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Carina Burns
Sent: Friday, December 12, 2014 11:38 AM
To: arslist@ARSLIST.ORG
Subject: Help with upgrade path

Greetings!!!

I am turning to you all for suggestions for an upgrade path for our ARS system. 
 I've contacted BMC for advice, however our support contract level is Basic... 
which is also the adjective I would use to describe my current level of 
customer satisfaction.

Has anyone gone from ARS 7.1 to 8.1?  How did you do it?  
If you don't want to wade thru my specifics, kindly preface your reply with 
TLDR before you explain your upgrade method.

The specifics:  
Our production set up is 
ARS 7.1 patch 11 / Midtier7.0.01 patch 5/ Apache Tomcat 5.027 / Crystal Reports 
XI running on WinSvr 2003 SP2
against an
Oracle 10g last patch database on RedHat Enterprise 4.0

I had thought to step thru and upgrade to 7.6 and then to 8.1 but was advised 
after opening a support ticket that since we have custom forms only and are not 
using ITSM or any other BMC app, we could go straight to 8.1 from 7.1.  

The compatibility matrix lists the minimums but states that any newer versions 
are supported for OS and database.  Since hardware only gets upgraded when bond 
money exists about every 5-7 years at our school district, I asked for the 
latest/greatest.  I cleared my choices/plan with support but since it was going 
to take a while to get the servers, I closed the ticket saying I would open 
another once I had my gear.

My new servers are virtual; a WinSvr2012 R2 and a Oracle Linux 6 box.  I put 
Oracle 12c on as the database.

I had thought to install ARS 7.1 as a new install, delete the data, copy the 
production 10g AR schema over to the 12c user, then run 8.1 as an upgrade. 
That's essentially how I did it the last time and support confirmed that a 
number of people run their upgrades that way.  But Oh-Oh! 7.1 is 32bit and 
doesn't want to install on my Win 64bit OS...Maybe both support and I missed 
that little hitch or perhaps I misunderstood.  Anyhow, I opened a new ticket 
and asked if I could do the same thing but with 8.1 instead.  In other words, 
install ARS 8.1 as a new install, delete the data, copy over the 10g AR schema 
to the 12c user, then run 8.1 again as an upgrade.

Here are the answers I got back on my ticket (paraphrased):
A) 7.1 isn't supported, 
B) I was free to experiment using the new install/delete data/move schema/run 
upgrade method but it may not work
C) I can try to install 8.1 as new and use the Migrator to move over all my 
custom forms
D) Contract professional services and pay BMC to help with my upgrade

Option D isn't going to happen.  So I am left with options B and C.  The 
analyst on the first support ticket didn't think Migrator would be necessary 
since we aren't using ITSM.  Thoughts on that (While I go read the migrator 
documentation)?  Comments on option B?

Thanks in advance!
Carina




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help with the Developer Studion Search Feature

[Jason Miller]

Hi Paul,

What version are you using?  I remember being very frustrated with the Dev
Studio search feature in 7.5 and didn't use it for years.  Somewhere along
the lines it got better (or I got smarter) and I have pretty good success
with it now.

Are you using ITSM?  I searched for RETRY_UPDATE and didn't find any
matches.  If you are using ITSM I have an issue as well.  If you are not
using ITSM then no results is expected :)

I searched our custom system with the parameters you detailed for
PROCESS_ORDER.  I know this exists in a number of filter Run Ifs.  I often
search for this string when working on our self-service ordering app but I
usually don't limit the criteria.  Thinking that might be the difference I
tried the same criteria and found matches (and quicker than usual as
expected with more specific criteria).  It looks to be working well for me
on an 7.6.04 SP4 AR server and Dev Studio 8.1 P2.

One additional thought.  You server does have 'Record Object Relationships
turned on right?  The Dev Studio search uses this data when searching.  I
think Dev Studio has the logic to not let you perform a search if this is
turned off but I don't have a server with it turned off to validate.

Jason


On Tue, Apr 8, 2014 at 8:01 AM, Campbell, Paul (Paul) p...@avaya.com wrote:

 **

 OK, so I think of myself as a fairly tech savvy individual and can work my
 way through most problems, but the Search Feature in Developer Studio seems
 like it doesn't ever work for me, so here is what I am trying to do:



 I am looking for every filter that has the string RETRY_UPDATE in the
 run-if portion of a filter, so here is what I have tried, all returning no
 results



 Search Text:  RETRY_UPDATE

 Search In:  I started with Filters, then tried all

 Qualification:  I tried Only These Locations: Filters- Run-If, then
 unchecked it

 Match:  Match Anywhere in Target Text

 String Constant Match: Match String Constants and Match Keywords both
 Checked





 Nothing I have tried is returning any matches when I can see a filter that
 has that in the run-if, suggestions?



 Paul Campbell  *|* Alarming Domain Architect *|  *Avaya Client Services  *|
 *

 *|*   678-421-5342 *|*  Web 
 Conferencehttps://collaborate.avaya.com/aacpa/?participantCode=4215342 *|
 *Audio Conference +1-513-228- code: 4215342



 *Everyone needs deadlines.  Even the beavers. They loaf around all summer,
 but when they are faced with the winter deadline, they work like fury. If
 we didn't have deadlines, we'd stagnate.  Walt Disney*




  _ARSlist: Where the Answers Are and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help with the Developer Studion Search Feature

[Campbell, Paul (Paul)]

I do have on Record Object Relationships and this is a custom app using 7.6.04 
server and Dev Studio 8.1.00 (according to the about dialog box).  I searched 
the AR System Metadata Filter form where Short Query=%RETRY_UPDATE% and it 
found 15 objects, so very strange indeed.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller
Sent: Tuesday, April 08, 2014 11:47 AM
To: arslist@ARSLIST.ORG
Subject: Re: Help with the Developer Studion Search Feature

**
Hi Paul,

What version are you using?  I remember being very frustrated with the Dev 
Studio search feature in 7.5 and didn't use it for years.  Somewhere along the 
lines it got better (or I got smarter) and I have pretty good success with it 
now.

Are you using ITSM?  I searched for RETRY_UPDATE and didn't find any matches.  
If you are using ITSM I have an issue as well.  If you are not using ITSM then 
no results is expected :)

I searched our custom system with the parameters you detailed for 
PROCESS_ORDER.  I know this exists in a number of filter Run Ifs.  I often 
search for this string when working on our self-service ordering app but I 
usually don't limit the criteria.  Thinking that might be the difference I 
tried the same criteria and found matches (and quicker than usual as expected 
with more specific criteria).  It looks to be working well for me on an 7.6.04 
SP4 AR server and Dev Studio 8.1 P2.

One additional thought.  You server does have 'Record Object Relationships 
turned on right?  The Dev Studio search uses this data when searching.  I think 
Dev Studio has the logic to not let you perform a search if this is turned off 
but I don't have a server with it turned off to validate.

Jason

On Tue, Apr 8, 2014 at 8:01 AM, Campbell, Paul (Paul) 
p...@avaya.commailto:p...@avaya.com wrote:
**
OK, so I think of myself as a fairly tech savvy individual and can work my way 
through most problems, but the Search Feature in Developer Studio seems like it 
doesn't ever work for me, so here is what I am trying to do:

I am looking for every filter that has the string RETRY_UPDATE in the run-if 
portion of a filter, so here is what I have tried, all returning no results

Search Text:  RETRY_UPDATE
Search In:  I started with Filters, then tried all
Qualification:  I tried Only These Locations: Filters- Run-If, then unchecked 
it
Match:  Match Anywhere in Target Text
String Constant Match: Match String Constants and Match Keywords both Checked


Nothing I have tried is returning any matches when I can see a filter that has 
that in the run-if, suggestions?

Paul Campbell  | Alarming Domain Architect |  Avaya Client Services  |
|   678-421-5342tel:678-421-5342 |  Web 
Conferencehttps://collaborate.avaya.com/aacpa/?participantCode=4215342 | 
Audio Conference +1-513-228-tel:%2B1-513-228- code: 4215342

Everyone needs deadlines.  Even the beavers. They loaf around all summer, but 
when they are faced with the winter deadline, they work like fury. If we didn't 
have deadlines, we'd stagnate.  Walt Disney


_ARSlist: Where the Answers Are and have been for 20 years_

_ARSlist: Where the Answers Are and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help button in ITSM 8.1 not working

[laurent matheo]

Hi :)

In the one I mentioned (« BMCRemedyITSMSuite8.1.00.help.zip »), you should
have the installer here for « service desk » for example:
« /servicedesk/incident/help/
Setup.exe

You have several installers in fact, per module for ITSM (asset, change,
rkm, servicedesk).


Laurent.

De :  Joe D'Souza jdso...@shyle.net
Société :  Shyle Networks
Répondre à :  arslist@ARSLIST.ORG
Date :  jeudi 17 octobre 2013 05:56
À :  arslist@ARSLIST.ORG
Objet :  Re: Help button in ITSM 8.1 not working

** 
There has to be as setup file (a bat file on windows if I remember
correctly).

 

Joe

 


From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sagar Valse
Sent: Wednesday, October 16, 2013 4:08 AM
To: arslist@ARSLIST.ORG
Subject: Re: Help button in ITSM 8.1 not working
 
** 

Hello Laurent,
Yes i had found 2 folder there 1 was online documentation and other was
offline documentation.
I have downloaded the offline documentation zip but i dont see a installer
in the downloaded zip.
I see a localhelp folder inside the docs.My question is how do i make the
help button work.


Thanks and Regards,
Sagar

 

On Wed, Oct 16, 2013 at 1:17 PM, laurent matheo lm...@me.com wrote:
** 

The help file should be on EPD « BMCRemedyITSMSuite8.1.00.help.zip » for
ITSM.

You can find it on EPD, search for « BMC Remedy IT Service Management »,
then select the 8.1 version, then for example « Remedy Asset Management
Application 8.1.00 » and you¹ll see « Help System ­ BMC remedyŠŠ ».

 

 

Laurent.

 

De : Joe D'Souza jdso...@shyle.net
Société : Shyle Networks
Répondre à : arslist@ARSLIST.ORG
Date : mercredi 16 octobre 2013 09:38
À : arslist@ARSLIST.ORG
Objet : Re: Help button in ITSM 8.1 not working

 
** 

I haven¹t worked with ITSM 8.x as yet but yes there were separate installers
available for ITSM help right from ITSM 5.x. I¹m guessing they have
continued it that way..

 

Joe

 


From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sagar Valse
Sent: Wednesday, October 16, 2013 3:36 AM
To: arslist@ARSLIST.ORG
Subject: Help button in ITSM 8.1 not working
 
** 

Hello All,
Is anyone aware if there is any installer available for ITSM 8.1
help.Currently the help button is not working and i was getting error
 
 Help has not been installed. For information about installing help, see
the ITSM Installation Guide. (ARERR 45120)
I have searched EPD but wasn't able to find installer.
Thanks and Regards,
Sagar 
_ARSlist: Where the Answers Are and have been for 20 years_

_ARSlist: Where the Answers Are and have been for 20 years_
 
_ARSlist: Where the Answers Are and have been for 20 years_
_ARSlist: Where the Answers Are and have been for 20 years_


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help button in ITSM 8.1 not working

[Rüdiger Tams]

Hi,
install the web help on the web server (mid tier) not on ar server (if it is 
not the same)
or - just extract it and copy the help files to the web server.
But with this you need to configure the form where the installation place of 
the help files is stored manually...
 
have fun!

Regards
Rüdiger



Von: laurent matheo lm...@me.com
An: arslist@ARSLIST.ORG 
Gesendet: 9:18 Donnerstag, 17.Oktober 2013
Betreff: Re: Help button in ITSM 8.1 not working



** 
Hi :)


In the one I mentioned (« BMCRemedyITSMSuite8.1.00.help.zip »), you should 
have the installer here for « service desk » for example:
« /servicedesk/incident/help/
Setup.exe


You have several installers in fact, per module for ITSM (asset, change, rkm, 
servicedesk).




Laurent.


De : Joe Dapos;Souza jdso...@shyle.net
Société : Shyle Networks
Répondre à : arslist@ARSLIST.ORG
Date : jeudi 17 octobre 2013 05:56
À : arslist@ARSLIST.ORG
Objet : Re: Help button in ITSM 8.1 not working 



** 
There has to be as setup file (a bat file on windows if I remember correctly).
 
Joe
 



From:Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sagar Valse
Sent: Wednesday, October 16, 2013 4:08 AM
To: arslist@ARSLIST.ORG
Subject: Re: Help button in ITSM 8.1 not working
 
** 
Hello Laurent,
Yes i had found 2 folder there 1 was online documentation and other was 
offline documentation.
I have downloaded the offline documentation zip but i dont see a installer in 
the downloaded zip.
I see a localhelp folder inside the docs.My question is how do i make the help 
button work.


Thanks and Regards,
Sagar
 
On Wed, Oct 16, 2013 at 1:17 PM, laurent matheo lm...@me.com wrote:
** 
The help file should be on EPD « BMCRemedyITSMSuite8.1.00.help.zip » for ITSM.
You can find it on EPD, search for « BMC Remedy IT Service Management », then 
select the 8.1 version, then for example « Remedy Asset Management Application 
8.1.00 » and you’ll see « Help System – BMC remedy…… ».
 
 
Laurent.
 
De : Joe Dapos;Souza jdso...@shyle.net
Société : Shyle Networks
Répondre à : arslist@ARSLIST.ORG
Date : mercredi 16 octobre 2013 09:38
À : arslist@ARSLIST.ORG
Objet : Re: Help button in ITSM 8.1 not working
 
** 
I haven’t worked with ITSM 8.x as yet but yes there were separate installers 
available for ITSM help right from ITSM 5.x. I’m guessing they have continued 
it that way..
 
Joe
 



From:Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sagar Valse
Sent: Wednesday, October 16, 2013 3:36 AM
To: arslist@ARSLIST.ORG
Subject: Help button in ITSM 8.1 not working
 
** 
Hello All,
Is anyone aware if there is any installer available for ITSM 8.1 
help.Currently the help button is not working and i was getting error
 
 Help has not been installed. For information about installing help, see 
the ITSM Installation Guide. (ARERR 45120) 
I have searched EPD but wasnapos;t able to find installer.
Thanks and Regards,
Sagar 
_ARSlist: Where the Answers Are and have been for 20 years_ 
_ARSlist: Where the Answers Are and have been for 20 years_ 
 
_ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where 
the Answers Are and have been for 20 years_ 
_ARSlist: Where the Answers Are and have been for 20 years_



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help button in ITSM 8.1 not working

[Joe D'Souza]

I haven't worked with ITSM 8.x as yet but yes there were separate installers
available for ITSM help right from ITSM 5.x. I'm guessing they have
continued it that way..

 

Joe

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sagar Valse
Sent: Wednesday, October 16, 2013 3:36 AM
To: arslist@ARSLIST.ORG
Subject: Help button in ITSM 8.1 not working

 

** 

Hello All,

Is anyone aware if there is any installer available for ITSM 8.1
help.Currently the help button is not working and i was getting error
 
 Help has not been installed. For information about installing help, see
the ITSM Installation Guide. (ARERR 45120) 

I have searched EPD but wasn't able to find installer.

Thanks and Regards,
Sagar 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help button in ITSM 8.1 not working

[laurent matheo]

The help file should be on EPD « BMCRemedyITSMSuite8.1.00.help.zip » for
ITSM.
You can find it on EPD, search for « BMC Remedy IT Service Management »,
then select the 8.1 version, then for example « Remedy Asset Management
Application 8.1.00 » and you¹ll see « Help System ­ BMC remedyŠŠ ».


Laurent.

De :  Joe D'Souza jdso...@shyle.net
Société :  Shyle Networks
Répondre à :  arslist@ARSLIST.ORG
Date :  mercredi 16 octobre 2013 09:38
À :  arslist@ARSLIST.ORG
Objet :  Re: Help button in ITSM 8.1 not working

** 
I haven¹t worked with ITSM 8.x as yet but yes there were separate installers
available for ITSM help right from ITSM 5.x. I¹m guessing they have
continued it that way..

 

Joe

 


From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sagar Valse
Sent: Wednesday, October 16, 2013 3:36 AM
To: arslist@ARSLIST.ORG
Subject: Help button in ITSM 8.1 not working
 
** 

Hello All,
Is anyone aware if there is any installer available for ITSM 8.1
help.Currently the help button is not working and i was getting error
 
 Help has not been installed. For information about installing help, see
the ITSM Installation Guide. (ARERR 45120)
I have searched EPD but wasn't able to find installer.
Thanks and Regards,
Sagar 
_ARSlist: Where the Answers Are and have been for 20 years_


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help button in ITSM 8.1 not working

[Sagar Valse]

Hello Laurent,

Yes i had found 2 folder there 1 was online documentation and other was
offline documentation.
I have downloaded the offline documentation zip but i dont see a installer
in the downloaded zip.
I see a localhelp folder inside the docs.My question is how do i make the
help button work.


Thanks and Regards,
Sagar


On Wed, Oct 16, 2013 at 1:17 PM, laurent matheo lm...@me.com wrote:

 **
 The help file should be on EPD « BMCRemedyITSMSuite8.1.00.help.zip » for
 ITSM.
 You can find it on EPD, search for « BMC Remedy IT Service Management »,
 then select the 8.1 version, then for example « Remedy Asset Management
 Application 8.1.00 » and you’ll see « Help System – BMC remedy…… ».


 Laurent.

 De : Joe D'Souza jdso...@shyle.net
 Société : Shyle Networks
 Répondre à : arslist@ARSLIST.ORG
 Date : mercredi 16 octobre 2013 09:38
 À : arslist@ARSLIST.ORG
 Objet : Re: Help button in ITSM 8.1 not working

 **

 I haven’t worked with ITSM 8.x as yet but yes there were separate
 installers available for ITSM help right from ITSM 5.x. I’m guessing they
 have continued it that way..

 ** **

 Joe

 ** **
 --

 *From:* Action Request System discussion list(ARSList) [
 mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG] *On Behalf Of *Sagar
 Valse
 *Sent:* Wednesday, October 16, 2013 3:36 AM
 *To:* arslist@ARSLIST.ORG
 *Subject:* Help button in ITSM 8.1 not working

 ** **

 ** 

 Hello All,

 Is anyone aware if there is any installer available for ITSM 8.1
 help.Currently the help button is not working and i was getting error

  Help has not been installed. For information about installing help,
 see the ITSM Installation Guide. (ARERR 45120) 

 I have searched EPD but wasn't able to find installer.

 Thanks and Regards,
 Sagar 
 _ARSlist: Where the Answers Are and have been for 20 years_
 _ARSlist: Where the Answers Are and have been for 20 years_


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help button in ITSM 8.1 not working

[Joe D'Souza]

There has to be as setup file (a bat file on windows if I remember
correctly).

 

Joe

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sagar Valse
Sent: Wednesday, October 16, 2013 4:08 AM
To: arslist@ARSLIST.ORG
Subject: Re: Help button in ITSM 8.1 not working

 

** 

Hello Laurent,

Yes i had found 2 folder there 1 was online documentation and other was
offline documentation.

I have downloaded the offline documentation zip but i dont see a installer
in the downloaded zip.

I see a localhelp folder inside the docs.My question is how do i make the
help button work.



Thanks and Regards,
Sagar

 

On Wed, Oct 16, 2013 at 1:17 PM, laurent matheo lm...@me.com wrote:

** 

The help file should be on EPD « BMCRemedyITSMSuite8.1.00.help.zip » for
ITSM.

You can find it on EPD, search for « BMC Remedy IT Service Management »,
then select the 8.1 version, then for example « Remedy Asset Management
Application 8.1.00 » and you’ll see « Help System – BMC remedy…… ».

 

 

Laurent.

 

De : Joe D'Souza jdso...@shyle.net
Société : Shyle Networks
Répondre à : arslist@ARSLIST.ORG
Date : mercredi 16 octobre 2013 09:38
À : arslist@ARSLIST.ORG
Objet : Re: Help button in ITSM 8.1 not working

 

** 

I haven’t worked with ITSM 8.x as yet but yes there were separate installers
available for ITSM help right from ITSM 5.x. I’m guessing they have
continued it that way..

 

Joe

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sagar Valse
Sent: Wednesday, October 16, 2013 3:36 AM
To: arslist@ARSLIST.ORG
Subject: Help button in ITSM 8.1 not working

 

** 

Hello All,

Is anyone aware if there is any installer available for ITSM 8.1
help.Currently the help button is not working and i was getting error
 
 Help has not been installed. For information about installing help, see
the ITSM Installation Guide. (ARERR 45120) 

I have searched EPD but wasn't able to find installer.

Thanks and Regards,
Sagar 

_ARSlist: Where the Answers Are and have been for 20 years_ 

_ARSlist: Where the Answers Are and have been for 20 years_ 

 

_ARSlist: Where the Answers Are and have been for 20 years_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help Needed for ARERR 102 Error.

[Kumar, Amit (Remedy-Dev Studio RD)]

The error (ARERR 102) comes when some of the  form name which is being passed 
dynamically to the server say in some active link action is not resolved . This 
could be because the server does not have that form at all or the field value 
which is being passed for form name does not have the value.

One possible case could be, on some action a filter is fired but that filter 
primary form is not available.
Same possibility could be with fields too.

However since you observe this issue after you got the new PC, it seems that 
because of some OS issue the values are not passed to the server on execution 
of some activelink in the first try . Will have to debug that on that specific 
machine/environment.

Regards,
Amit Kumar


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza
Sent: 03 October 2013 20:29
To: arslist@ARSLIST.ORG
Subject: Re: Help Needed for ARERR 102 Error.

**
First of all message not in catalog is a message you receive when the AR System 
cannot read messages from the arsystem.cat file which is usually a problem when 
you perform a non root install on UNIX and forget to perform the post 
installation recommended tasks of manually changing the permission of the 
arsystem.cat file to make it readable by the non root user that is starting the 
AR System.


So when you mention that you have got a new PC Windows 7, do you mean it's a 
client?



I do not have access to what ARERR 102 is as of now, but you might want to 
import the help.def and help.arx files which should have information about what 
102 is.



Joe


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Bhupendra Kumar
Sent: Thursday, October 03, 2013 3:06 AM
To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Subject: Help Needed for ARERR 102 Error.

Dear All,

Ever since I got a new PC, with new OS ( windows 7 ) , I have been getting an 
ARERR 102 error when Opening an Incident from the Incident Management console. 
If I click OK, the error comes back up a second time.  If I click OK a second 
time, the error will go away and the record will display. Otherwise, no other 
issues in Remedy.

I have deleted all my .arf and .arv files, still getting error.
I have tried changing the BMC Remedy User Compatibility settings, still getting 
error. (screenshot in Work Info)
I turned on Logging to capture the issue. (file in Work Info)

There are other people in the company also having the same issue. I am a remedy 
Admin and I tried all I can do to fix this issue but I cannot.

Please see the screen shot below :

[cid:image001.jpg@01CEC0F4.E978BBC0]

Best Regards,
Bhupendra KUMAR
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Tomasiewicz, Mike (Information 
Technology)
Sent: 03 October 2013 07:28
To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Subject: Re: BMC Customer Support

**
I'd like to interject that everyone's mileage may vary when engaging support 
resources.  I also believe that support is doing a much better job than they 
have in the past.  That being said, I do not vouch for every person manning the 
desk, only my interactions.

.: Mike T :.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Ortega, Jesus A
Sent: Wednesday, October 02, 2013 4:42 PM
To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Subject: Re: BMC Customer Support

**
Someone was just telling me on the ARSlist that BMC Support had really made a 
turnaround and was doing much better. Kathy's email seems to indicate otherwise.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kathy Morris
Sent: Wednesday, October 02, 2013 11:05 AM
To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Subject: BMC Customer Support

**
Hi,

Does anyone know who we can contact on a Sr. Management level at BMC regarding 
technical support?
We are not happy at all with the level of support we are receiving.
If you like, you contact me directly for any recommendations.

_ARSlist: Where the Answers Are and have been for 20 years_

Information contained in this email is subject to the disclaimer found by 
clicking on the following link: http://www.lyondellbasell.com/Footer/Disclaimer/
_ARSlist: Where the Answers Are and have been for 20 years_
_ARSlist: Where the Answers Are and have been for 20 years_
_ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where 
the Answers Are and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years
inline: image001.jpg

Re: Help Needed for ARERR 102 Error.

[Joe D'Souza]

First of all message not in catalog is a message you receive when the AR
System cannot read messages from the arsystem.cat file which is usually a
problem when you perform a non root install on UNIX and forget to perform
the post installation recommended tasks of manually changing the permission
of the arsystem.cat file to make it readable by the non root user that is
starting the AR System.

 

So when you mention that you have got a new PC Windows 7, do you mean it's a
client?

 

I do not have access to what ARERR 102 is as of now, but you might want to
import the help.def and help.arx files which should have information about
what 102 is.

 

Joe

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Bhupendra Kumar
Sent: Thursday, October 03, 2013 3:06 AM
To: arslist@ARSLIST.ORG
Subject: Help Needed for ARERR 102 Error.

 

Dear All,

 

Ever since I got a new PC, with new OS ( windows 7 ) , I have been getting
an ARERR 102 error when Opening an Incident from the Incident Management
console. If I click OK, the error comes back up a second time.  If I click
OK a second time, the error will go away and the record will display.
Otherwise, no other issues in Remedy.

 

I have deleted all my .arf and .arv files, still getting error.

I have tried changing the BMC Remedy User Compatibility settings, still
getting error. (screenshot in Work Info)

I turned on Logging to capture the issue. (file in Work Info)

 

There are other people in the company also having the same issue. I am a
remedy Admin and I tried all I can do to fix this issue but I cannot.

 

Please see the screen shot below : 

 



 

Best Regards,

Bhupendra KUMAR

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Tomasiewicz, Mike (Information
Technology)
Sent: 03 October 2013 07:28
To: arslist@ARSLIST.ORG
Subject: Re: BMC Customer Support

 

** 

I'd like to interject that everyone's mileage may vary when engaging support
resources.  I also believe that support is doing a much better job than they
have in the past.  That being said, I do not vouch for every person manning
the desk, only my interactions.

 

.: Mike T :.

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Ortega, Jesus A
Sent: Wednesday, October 02, 2013 4:42 PM
To: arslist@ARSLIST.ORG
Subject: Re: BMC Customer Support

 

** 

Someone was just telling me on the ARSlist that BMC Support had really made
a turnaround and was doing much better. Kathy's email seems to indicate
otherwise. 

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kathy Morris
Sent: Wednesday, October 02, 2013 11:05 AM
To: arslist@ARSLIST.ORG
Subject: BMC Customer Support

 

** 

Hi,

 

Does anyone know who we can contact on a Sr. Management level at BMC
regarding technical support?

We are not happy at all with the level of support we are receiving.

If you like, you contact me directly for any recommendations.

 

_ARSlist: Where the Answers Are and have been for 20 years_


Information contained in this email is subject to the disclaimer found by
clicking on the following link:
http://www.lyondellbasell.com/Footer/Disclaimer/ 

_ARSlist: Where the Answers Are and have been for 20 years_ 

_ARSlist: Where the Answers Are and have been for 20 years_ 

_ARSlist: Where the Answers Are and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years
image002.jpg

Re: EXTERNAL: Re: Help Needed for ARERR 102 Error.

[Reiser, John J]

From my Action Request System 3.2 Error Messages Guide

AR System Server Errors 102
Name parameter ( or name field in a parameter) is empty
The operation being performed requires a name specification for an item but no 
name was specified. Specify a value for the name parameter, and try the 
operation again.


Thank you,
---
John J. Reiser
Remedy Developer/Administrator
Senior Software Development Analyst
Lockheed Martin - MS2
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased by me

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza
Sent: Thursday, October 03, 2013 10:59 AM
To: arslist@ARSLIST.ORG
Subject: EXTERNAL: Re: Help Needed for ARERR 102 Error.

**
First of all message not in catalog is a message you receive when the AR System 
cannot read messages from the arsystem.cat file which is usually a problem when 
you perform a non root install on UNIX and forget to perform the post 
installation recommended tasks of manually changing the permission of the 
arsystem.cat file to make it readable by the non root user that is starting the 
AR System.


So when you mention that you have got a new PC Windows 7, do you mean it's a 
client?



I do not have access to what ARERR 102 is as of now, but you might want to 
import the help.def and help.arx files which should have information about what 
102 is.



Joe


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Bhupendra Kumar
Sent: Thursday, October 03, 2013 3:06 AM
To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Subject: Help Needed for ARERR 102 Error.

Dear All,

Ever since I got a new PC, with new OS ( windows 7 ) , I have been getting an 
ARERR 102 error when Opening an Incident from the Incident Management console. 
If I click OK, the error comes back up a second time.  If I click OK a second 
time, the error will go away and the record will display. Otherwise, no other 
issues in Remedy.

I have deleted all my .arf and .arv files, still getting error.
I have tried changing the BMC Remedy User Compatibility settings, still getting 
error. (screenshot in Work Info)
I turned on Logging to capture the issue. (file in Work Info)

There are other people in the company also having the same issue. I am a remedy 
Admin and I tried all I can do to fix this issue but I cannot.

Please see the screen shot below :

[cid:image001.jpg@01CEC029.DE6A1790]

Best Regards,
Bhupendra KUMAR
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Tomasiewicz, Mike (Information 
Technology)
Sent: 03 October 2013 07:28
To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Subject: Re: BMC Customer Support

**
I'd like to interject that everyone's mileage may vary when engaging support 
resources.  I also believe that support is doing a much better job than they 
have in the past.  That being said, I do not vouch for every person manning the 
desk, only my interactions.

.: Mike T :.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Ortega, Jesus A
Sent: Wednesday, October 02, 2013 4:42 PM
To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Subject: Re: BMC Customer Support

**
Someone was just telling me on the ARSlist that BMC Support had really made a 
turnaround and was doing much better. Kathy's email seems to indicate otherwise.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kathy Morris
Sent: Wednesday, October 02, 2013 11:05 AM
To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Subject: BMC Customer Support

**
Hi,

Does anyone know who we can contact on a Sr. Management level at BMC regarding 
technical support?
We are not happy at all with the level of support we are receiving.
If you like, you contact me directly for any recommendations.

_ARSlist: Where the Answers Are and have been for 20 years_

Information contained in this email is subject to the disclaimer found by 
clicking on the following link: http://www.lyondellbasell.com/Footer/Disclaimer/
_ARSlist: Where the Answers Are and have been for 20 years_
_ARSlist: Where the Answers Are and have been for 20 years_
_ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where 
the Answers Are and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years
inline: image001.jpg

Re: Help needed for installing a hotfix for 7.6.04 SP4-S

[Jonas Stumph Stevnsvig]

that depends on how you have deployed the midtier to weblogic. have you 
tried searching for said folders on the weblogic server?


Den 30-09-2013 14:42, tristan.rop...@t-online.de skrev:

Hi folks,

i need your help for installing a hotfix for Midtier.
Im not familiar with WebLogic servers.
We have to install this hotfix in a WebLogic instance, and not in a Tomcat 
instance.

In the manuals there is the description, that we have to delete these 
directories

midtier_dir/cache
midtier_dir/cachetemp (if exists)
midtier_dir/PluginsCache

But where can i find this under WebLogic ?

BR

Tristan

Tristan

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help needed for installing a hotfix for 7.6.04 SP4-S

[Abhijit Hendre]

Hi , you will get path to midtier_dir from Mid-Tier Config Tool -
Overview Page. Check for attribute Mid Tier Installation Directory on this
page.  once you have that value , you can clear contents of
midtier_dir/cache, midtier_dir/cachetemp  midtier_dir/pluginscache.

Thanks,
Abhijit H
On Sep 30, 2013 6:12 PM, tristan.rop...@t-online.de 
tristan.rop...@t-online.de wrote:

 Hi folks,

 i need your help for installing a hotfix for Midtier.
 Im not familiar with WebLogic servers.
 We have to install this hotfix in a WebLogic instance, and not in a Tomcat
 instance.

 In the manuals there is the description, that we have to delete these
 directories

 midtier_dir/cache
 midtier_dir/cachetemp (if exists)
 midtier_dir/PluginsCache

 But where can i find this under WebLogic ?

 BR

 Tristan

 Tristan


 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Where the Answers Are, and have been for 20 years


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help with simple SSO authentication

[Brian Gillock]

Hello Matt,
 I've recently been working on this myself.  There are a couple things
to look at, one being what is provided by BMC in KA286851
https://kb.bmc.com/infocenter/index?page=contentid=KA286851is
incomplete.  There is no interceptor, unless it's in the uncompiled C code
somewhere.  I don't have access to a compiler.  I had to download WAFFLE
http://waffle.codeplex.com/and implement it.  Also, ensure that your link
isn't directly to the login.jsp.  Yeah, I know that's the, does it have gas
in it, question.

HTH,
Brian Gillock


On Fri, May 10, 2013 at 10:22 AM, Matthew Perrault 
matthew.perra...@genmills.com wrote:

 **

 All,

 Environment:

 Windows Server 2008 R2

 IIS 7

 Mid-tier/ARS: 7.6.04

 2 Mid-TieràLoad BalanceràARS Servers.

 ** **

 I’m trying to get our SSO authentication setup.

 The goal is to allow end users to hit the web site and have it
 automatically log them in (no log in prompt).

 We have the LDAP connection to AD working correctly, and we were trying to
 set this up without that Atrium SSO authenticator.

 Primarily because what I read says that keeps the password in it’s own
 file and still forces a person to login (was my understanding correct?).**
 **

 I’ve read through the documentation and searched the web, and I’ve been
 able to find some things but nothing that has worked yet.

 I’ve got the Mid-tier all working

 ** **

 I tired taking our SSOAuthenticator.jar and sso.properties file from 7.1
 and moving it forward.

 But when I implement it on the Mid-Tier, it still prompts for login.

 I think I have the server side setup correctly:

 Authentication-Chaining-Mode: 4

 Crossref-Blank-Password: T

 External-Authentication-RPC-Socket: 390695

 AREA-Hub-Plugin: D:\Apps\BMC Software\ARSystem\areasso.dll

 AREA-Hub-Plugin: D:\Apps\BMC Software\ARSystem\arealdap\arealdap.dll

 ** **

 Any thoughts/Help would be greatly appreciated, as I am fairly novice with
 this SSO setup stuff.

 ** **

 Thanks,

 Matt P.

 ** **

 ** **
  _ARSlist: Where the Answers Are and have been for 20 years_




-- 
Brian Gillock
Principal Consultant, BGBS, Inc
brian.gill...@pbs-consulting.com

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help with simple SSO authentication

[Matthew Perrault]

Thanks for the help Brian,
But I got most of it figured out,
I just walked through the code line by line (extracted the .java file in the 
SSOAuthenticarot.jar file)
And found that I had not set up the environment variable that points to the 
areasso.config file correctly.
I had set it up as a User environment variable instead of as a System 
environment variable.
Once I corrected that the old 7.1 SSO stuff started to work fine.
Now I just need to get it to pass through the Load Balancer and it will be done.

Thanks for the help though
Matt P.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Gillock
Sent: Thursday, May 30, 2013 7:53 AM
To: arslist@ARSLIST.ORG
Subject: Re: Help with simple SSO authentication

**
Hello Matt,
 I've recently been working on this myself.  There are a couple things to 
look at, one being what is provided by BMC in KA286851 
https://kb.bmc.com/infocenter/index?page=contentid=KA286851 is incomplete.  
There is no interceptor, unless it's in the uncompiled C code somewhere.  I 
don't have access to a compiler.  I had to download WAFFLE 
http://waffle.codeplex.com/ and implement it.  Also, ensure that your link 
isn't directly to the login.jsp.  Yeah, I know that's the, does it have gas in 
it, question.
HTH,
Brian Gillock

On Fri, May 10, 2013 at 10:22 AM, Matthew Perrault 
matthew.perra...@genmills.commailto:matthew.perra...@genmills.com wrote:
**
All,
Environment:
Windows Server 2008 R2
IIS 7
Mid-tier/ARS: 7.6.04
2 Mid-Tier--Load Balancer--ARS Servers.

I'm trying to get our SSO authentication setup.
The goal is to allow end users to hit the web site and have it automatically 
log them in (no log in prompt).
We have the LDAP connection to AD working correctly, and we were trying to set 
this up without that Atrium SSO authenticator.
Primarily because what I read says that keeps the password in it's own file and 
still forces a person to login (was my understanding correct?).
I've read through the documentation and searched the web, and I've been able to 
find some things but nothing that has worked yet.
I've got the Mid-tier all working

I tired taking our SSOAuthenticator.jar and sso.properties file from 7.1 and 
moving it forward.
But when I implement it on the Mid-Tier, it still prompts for login.
I think I have the server side setup correctly:
Authentication-Chaining-Mode: 4
Crossref-Blank-Password: T
External-Authentication-RPC-Socket: 390695
AREA-Hub-Plugin: D:\Apps\BMC Software\ARSystem\areasso.dll
AREA-Hub-Plugin: D:\Apps\BMC Software\ARSystem\arealdap\arealdap.dll

Any thoughts/Help would be greatly appreciated, as I am fairly novice with this 
SSO setup stuff.

Thanks,
Matt P.


_ARSlist: Where the Answers Are and have been for 20 years_



--
Brian Gillock
Principal Consultant, BGBS, Inc
brian.gill...@pbs-consulting.commailto:brian.gill...@pbs-consulting.com

_ARSlist: Where the Answers Are and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help Needed

[Longwing, Lj]

Wellthe big question that you must ask then is 'did you store the
previous assignees anywhere'?


On Tue, May 14, 2013 at 9:18 PM, Shivanand Jeerigiwad shivu5sh...@gmail.com
 wrote:

 **
 Hi Joe,

 Thanks for the support.
 The requirement is basically as below,


 1) That these tickets were assigned to A, B and C support groups

 2) They had  individual assignees at that time.

 3) Reassigned to support groups D, E and F

 4) Under these assigned to one individual common to all 3
 4) Now want to assign to D, E and F with the assignee as like in A, B and
 C support group(Individual not common assignee). .




 Regards,
 Shiva


 On Wed, May 15, 2013 at 12:28 AM, Joe D'Souza jdso...@shyle.net wrote:

 **

 I am not sure I understood your problem correctly but I’ll take a stab at
 it based on what I think I understand.

 ** **

 I have understood:-

 1) That these tickets were assigned to A, B and C support groups

 2) They had no individual assignees at that time.

 3) You reassigned to support groups D, E and F

 4) Under these you assigned to one individual common to all 3

 4) Now you want to reassign to A, B and C.

 ** **

 Is that it? I think you could do that if this individual assignee was a
 member of A, B and C as well.

 ** **

 If that is not the case and you want it to go to some other individual
 assignee, are they a part of D, E and F? If not they would need to be.***
 *

 ** **

 If I  have completely misunderstood, then you may want to further clarify
 as to what you meant by ‘previous assignee’.

 ** **

 Cheers

 ** **

 Joe

 ** **

 PS: You may probably get more responses if you put an appropriate title /
 subject to your email. Help needed is so generic – everyones here for some
 help – except maybe John Sunderburg (I’m kididng!).. An appropriate subject
 for this might have been something like Help with ticket reassignment or
 something like that.. It would attract readers who have experience with
 that specific area..

 ** **
  --

 *From:* Action Request System discussion list(ARSList) [mailto:
 arslist@ARSLIST.ORG] *On Behalf Of *Shivanand Jeerigiwad
 *Sent:* Tuesday, May 14, 2013 6:02 AM
 *To:* arslist@ARSLIST.ORG
 *Subject:* Help Needed

 ** **

 ** 

 Hi List,

 There are some support group A, B, C and tickets(INC,PBM,CHG and TSK)
 under these support group.Created support group D, E,F and routed all the
 tickets under A, B, C to D,E,F and assigned to one Assignee who is common
 in all the D,E,F support group.

 

 Now the challenge is to assign back the ticket to there original assignee
 and not to the common assignee.So how we can get the data of the previous
 assignee to revert back.

 Any help will be appreciated.
 


 --
 With regards
 Shivanand Jeerigiwad

 ** **

 _ARSlist: Where the Answers Are and have been for 20 years_ 
  _ARSlist: Where the Answers Are and have been for 20 years_




 --
 With regards
 Shivanand Jeerigiwad
  _ARSlist: Where the Answers Are and have been for 20 years_


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help Needed

[Joe D'Souza]

 

That's what I meant to ask too.

 

You may want to also check your data in field 112 (Assignee Group field)
which can play an important part on permissions if the problem you are
having is permission related.

 

Cheers

 

Joe

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, Lj
Sent: Wednesday, May 15, 2013 9:04 AM
To: arslist@ARSLIST.ORG
Subject: Re: Help Needed

 

** 

Wellthe big question that you must ask then is 'did you store the
previous assignees anywhere'?

 

On Tue, May 14, 2013 at 9:18 PM, Shivanand Jeerigiwad
shivu5sh...@gmail.com wrote:

** 

Hi Joe,

Thanks for the support.
The requirement is basically as below,

 

1) That these tickets were assigned to A, B and C support groups

2) They had  individual assignees at that time.

3) Reassigned to support groups D, E and F

4) Under these assigned to one individual common to all 3

4) Now want to assign to D, E and F with the assignee as like in A, B and C
support group(Individual not common assignee). .





Regards,
Shiva

 

On Wed, May 15, 2013 at 12:28 AM, Joe D'Souza jdso...@shyle.net wrote:

** 

I am not sure I understood your problem correctly but I'll take a stab at it
based on what I think I understand.

 

I have understood:-

1) That these tickets were assigned to A, B and C support groups

2) They had no individual assignees at that time.

3) You reassigned to support groups D, E and F

4) Under these you assigned to one individual common to all 3

4) Now you want to reassign to A, B and C.

 

Is that it? I think you could do that if this individual assignee was a
member of A, B and C as well.

 

If that is not the case and you want it to go to some other individual
assignee, are they a part of D, E and F? If not they would need to be.

 

If I  have completely misunderstood, then you may want to further clarify as
to what you meant by 'previous assignee'.

 

Cheers

 

Joe

 

PS: You may probably get more responses if you put an appropriate title /
subject to your email. Help needed is so generic - everyones here for some
help - except maybe John Sunderburg (I'm kididng!).. An appropriate subject
for this might have been something like Help with ticket reassignment or
something like that.. It would attract readers who have experience with that
specific area..

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Shivanand Jeerigiwad
Sent: Tuesday, May 14, 2013 6:02 AM
To: arslist@ARSLIST.ORG
Subject: Help Needed

 

** 

Hi List,

There are some support group A, B, C and tickets(INC,PBM,CHG and TSK) under
these support group.Created support group D, E,F and routed all the tickets
under A, B, C to D,E,F and assigned to one Assignee who is common in all the
D,E,F support group.

Now the challenge is to assign back the ticket to there original assignee
and not to the common assignee.So how we can get the data of the previous
assignee to revert back.

Any help will be appreciated.



-- 
With regards
Shivanand Jeerigiwad

 

_ARSlist: Where the Answers Are and have been for 20 years_ 

_ARSlist: Where the Answers Are and have been for 20 years_ 




-- 
With regards
Shivanand Jeerigiwad

_ARSlist: Where the Answers Are and have been for 20 years_ 

 

_ARSlist: Where the Answers Are and have been for 20 years_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help Needed

[Joe D'Souza]

I am not sure I understood your problem correctly but I'll take a stab at it
based on what I think I understand.

 

I have understood:-

1) That these tickets were assigned to A, B and C support groups

2) They had no individual assignees at that time.

3) You reassigned to support groups D, E and F

4) Under these you assigned to one individual common to all 3

4) Now you want to reassign to A, B and C.

 

Is that it? I think you could do that if this individual assignee was a
member of A, B and C as well.

 

If that is not the case and you want it to go to some other individual
assignee, are they a part of D, E and F? If not they would need to be.

 

If I  have completely misunderstood, then you may want to further clarify as
to what you meant by 'previous assignee'.

 

Cheers

 

Joe

 

PS: You may probably get more responses if you put an appropriate title /
subject to your email. Help needed is so generic - everyones here for some
help - except maybe John Sunderburg (I'm kididng!).. An appropriate subject
for this might have been something like Help with ticket reassignment or
something like that.. It would attract readers who have experience with that
specific area..

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Shivanand Jeerigiwad
Sent: Tuesday, May 14, 2013 6:02 AM
To: arslist@ARSLIST.ORG
Subject: Help Needed

 

** 

Hi List,

There are some support group A, B, C and tickets(INC,PBM,CHG and TSK) under
these support group.Created support group D, E,F and routed all the tickets
under A, B, C to D,E,F and assigned to one Assignee who is common in all the
D,E,F support group.



Now the challenge is to assign back the ticket to there original assignee
and not to the common assignee.So how we can get the data of the previous
assignee to revert back.

Any help will be appreciated.



-- 
With regards
Shivanand Jeerigiwad

 

_ARSlist: Where the Answers Are and have been for 20 years_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help Needed

[Shivanand Jeerigiwad]

Hi Joe,

Thanks for the support.
The requirement is basically as below,

1) That these tickets were assigned to A, B and C support groups

2) They had  individual assignees at that time.

3) Reassigned to support groups D, E and F

4) Under these assigned to one individual common to all 3
4) Now want to assign to D, E and F with the assignee as like in A, B and C
support group(Individual not common assignee). .




Regards,
Shiva


On Wed, May 15, 2013 at 12:28 AM, Joe D'Souza jdso...@shyle.net wrote:

 **

 I am not sure I understood your problem correctly but I’ll take a stab at
 it based on what I think I understand.

 ** **

 I have understood:-

 1) That these tickets were assigned to A, B and C support groups

 2) They had no individual assignees at that time.

 3) You reassigned to support groups D, E and F

 4) Under these you assigned to one individual common to all 3

 4) Now you want to reassign to A, B and C.

 ** **

 Is that it? I think you could do that if this individual assignee was a
 member of A, B and C as well.

 ** **

 If that is not the case and you want it to go to some other individual
 assignee, are they a part of D, E and F? If not they would need to be.

 ** **

 If I  have completely misunderstood, then you may want to further clarify
 as to what you meant by ‘previous assignee’.

 ** **

 Cheers

 ** **

 Joe

 ** **

 PS: You may probably get more responses if you put an appropriate title /
 subject to your email. Help needed is so generic – everyones here for some
 help – except maybe John Sunderburg (I’m kididng!).. An appropriate subject
 for this might have been something like Help with ticket reassignment or
 something like that.. It would attract readers who have experience with
 that specific area..

 ** **
  --

 *From:* Action Request System discussion list(ARSList) [mailto:
 arslist@ARSLIST.ORG] *On Behalf Of *Shivanand Jeerigiwad
 *Sent:* Tuesday, May 14, 2013 6:02 AM
 *To:* arslist@ARSLIST.ORG
 *Subject:* Help Needed

 ** **

 ** 

 Hi List,

 There are some support group A, B, C and tickets(INC,PBM,CHG and TSK)
 under these support group.Created support group D, E,F and routed all the
 tickets under A, B, C to D,E,F and assigned to one Assignee who is common
 in all the D,E,F support group.

 

 Now the challenge is to assign back the ticket to there original assignee
 and not to the common assignee.So how we can get the data of the previous
 assignee to revert back.

 Any help will be appreciated.
 


 --
 With regards
 Shivanand Jeerigiwad

 ** **

 _ARSlist: Where the Answers Are and have been for 20 years_ 
  _ARSlist: Where the Answers Are and have been for 20 years_




-- 
With regards
Shivanand Jeerigiwad

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help with identifying process id for a specific arserverd Thread on linux

[Walters, Mark]

It's not obvious is it?

I've created  KB with an example of how to do it, which should be published 
soon.

Mark

Preview Knowledge Article

 Content Entry Fields







Title
How to Convert Thread IDs (TID) in AR Server Logs to Linux LWP IDs.




Problem
On Solaris the TID used in the AR Server logs is the same as that used by the 
OS to identify individual threads.  This makes it easy to take the output of 
commands such as pstack/top and map the activity of a particular thread to 
SQL/API being run by the server.  This is not the case on Linux as the OS 
utilities may show different LWP Ids that do no match the TID values used in 
the server logs.  For example, on startup the server thread log records the 
creation of each thread;

THRD /* Tue Feb 26 2013 07:14:36.3408 */ Thread Id 1106151744 (thread number  
 9) on LIST queue started.
THRD /* Tue Feb 26 2013 07:14:36.3409 */ Thread Id 1086691648 (thread number  
10) on PRIVATE queue 390680 started.

The server logs use the Thread Id value;

API  TID: 1086691648 RPC ID: 001180 Queue: Prv:390680 Client-RPC: 
390680USER: Remedy Application Service/* Tue Feb 26 
2013 07:24:39.8051 */+GESARGetEntryStatistics

However, OS utilities show LWP Ids;

$ top
PID USER  PR  NI  VIRT  RES  SHR S %CPU %MEMTIME+  COMMAND
 3533 remedy15   0  564m 160m  21m S  6.7  8.0   0:00.20 arserverd
 3469 remedy15   0  564m 160m  21m S  0.0  8.0   0:00.48 arserverd
 3470 remedy15   0  564m 160m  21m S  0.0  8.0   0:00.00 arserverd
 3471 remedy15   0  564m 160m  21m S  0.0  8.0   0:00.00 arserverd

$ pstack
Thread 11 (Thread 0x40c59940 (LWP 3533)):
#0  0x003742e0a899 in pthread_cond_wait@@GLIBC_2.3.2 ()
#1  0x009df414 in WaitForRxSemaphore ()
#2  0x006c40a4 in GetCall ()
#3  0x0045490b in HandleRPCs ()
#4  0x007e9266 in WorkerThread ()
#5  0x009df95c in RestartableThreadMain ()
#6  0x009df8e7 in UnixThreadStartRoutine ()
#7  0x003742e06367 in start_thread () from /lib64/libpthread.so.0
#8  0x0037422d30ad in clone () from /lib64/libc.so.6






Solution
It is possible to find the mapping between the different Ids being used by 
taking the hexadecimal thread number from the pstack output and converting it 
to decimal.

In the example above we can see that Thread 0x40c59940 is also known as LWP 
3533.  The decimal value of 0x40c59940 can be found by using this Linux command 
line, or a similar converter;

$ echo $((0x40c59940))
1086691648

LWP 3533 is the thread logged as TID: 1086691648 in the server logs.  Note that 
the Thread 11 in the pstack output does NOT match the thread number recorded in 
the arthread.log file.

A full list of mappings for an arserverd process can be found using the gdb 
debugger or pstack/gstack command;

WARNING - although the risk is low please be careful running this command 
against a production system.  These are debugging tools and it will suspend the 
arserverd process for a moment which may cause problems on a very busy server.  
If possible run this command when the server is not heavily loaded.

$ echo quit | gdb arserverd `pgrep arserverd` | grep LWP | sort -k5 | awk 
'BEGIN {print TID\t\tLWP\t\tHEX;}{ printf %i\t%i\t\t%s\n, strtonum($3), $5, 
$3}'
TIDLWP   HEX
47883904271504   3469  0x2b8cd71ac490
1088616768 3470  0x40e2f940
1089669440 3471  0x40f30940
1092467008 3472  0x411db940
1095625024 3527  0x414de940
1102993728 3528  0x41be5940
1100888384 3529  0x419e3940
1101941056 3530  0x41ae4940
1084586304 3531  0x40a57940
1106151744 3532  0x41ee8940
1086691648 3533  0x40c59940
1094572352 3534  0x413dd940
1104046400 3535  0x41ce6940
1097730368 3536  0x416e0940
1107204416 3537  0x41fe9940
1093519680 3538  0x412dc940
1105099072 3539  0x41de7940
1085638976 3540  0x40b58940
1083533632 3542  0x40956940
1099835712 3547  0x418e2940

The same output can be found using pstack/gstack;

$ pstack `pgrep arserverd` | grep '(LWP ' | sort -k6 | awk 'BEGIN {print 
TID\t\tLWP\t\tHEX;}{ printf %i\t%i\t\t%s\n, strtonum($4), $6, $4}'
TIDLWP   HEX
47883904271504   3469  0x2b8cd71ac490
1088616768 3470  0x40e2f940
1089669440 3471  0x40f30940
1092467008 3472  0x411db940
1095625024 3527  0x414de940
1102993728 3528  0x41be5940
1100888384 3529  0x419e3940
1101941056

Re: Help with identifying process id for a specific arserverd Thread on linux

[Campbell, Paul (Paul)]

Wow, that's fantastic, thanks

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Walters, Mark
Sent: Tuesday, February 26, 2013 5:17 AM
To: arslist@ARSLIST.ORG
Subject: Re: Help with identifying process id for a specific arserverd Thread 
on linux

**
It's not obvious is it?

I've created  KB with an example of how to do it, which should be published 
soon.

Mark

Preview Knowledge Article

 Content Entry Fields







Title
How to Convert Thread IDs (TID) in AR Server Logs to Linux LWP IDs.




Problem
On Solaris the TID used in the AR Server logs is the same as that used by the 
OS to identify individual threads.  This makes it easy to take the output of 
commands such as pstack/top and map the activity of a particular thread to 
SQL/API being run by the server.  This is not the case on Linux as the OS 
utilities may show different LWP Ids that do no match the TID values used in 
the server logs.  For example, on startup the server thread log records the 
creation of each thread;

THRD /* Tue Feb 26 2013 07:14:36.3408 */ Thread Id 1106151744 (thread number  
 9) on LIST queue started.
THRD /* Tue Feb 26 2013 07:14:36.3409 */ Thread Id 1086691648 (thread number  
10) on PRIVATE queue 390680 started.

The server logs use the Thread Id value;

API  TID: 1086691648 RPC ID: 001180 Queue: Prv:390680 Client-RPC: 
390680USER: Remedy Application Service/* Tue Feb 26 
2013 07:24:39.8051 */+GESARGetEntryStatistics

However, OS utilities show LWP Ids;

$ top
PID USER  PR  NI  VIRT  RES  SHR S %CPU %MEMTIME+  COMMAND
 3533 remedy15   0  564m 160m  21m S  6.7  8.0   0:00.20 arserverd
 3469 remedy15   0  564m 160m  21m S  0.0  8.0   0:00.48 arserverd
 3470 remedy15   0  564m 160m  21m S  0.0  8.0   0:00.00 arserverd
 3471 remedy15   0  564m 160m  21m S  0.0  8.0   0:00.00 arserverd

$ pstack
Thread 11 (Thread 0x40c59940 (LWP 3533)):
#0  0x003742e0a899 in pthread_cond_wait@@GLIBC_2.3.2 ()
#1  0x009df414 in WaitForRxSemaphore ()
#2  0x006c40a4 in GetCall ()
#3  0x0045490b in HandleRPCs ()
#4  0x007e9266 in WorkerThread ()
#5  0x009df95c in RestartableThreadMain ()
#6  0x009df8e7 in UnixThreadStartRoutine ()
#7  0x003742e06367 in start_thread () from /lib64/libpthread.so.0
#8  0x0037422d30ad in clone () from /lib64/libc.so.6






Solution
It is possible to find the mapping between the different Ids being used by 
taking the hexadecimal thread number from the pstack output and converting it 
to decimal.

In the example above we can see that Thread 0x40c59940 is also known as LWP 
3533.  The decimal value of 0x40c59940 can be found by using this Linux command 
line, or a similar converter;

$ echo $((0x40c59940))
1086691648

LWP 3533 is the thread logged as TID: 1086691648 in the server logs.  Note that 
the Thread 11 in the pstack output does NOT match the thread number recorded in 
the arthread.log file.

A full list of mappings for an arserverd process can be found using the gdb 
debugger or pstack/gstack command;

WARNING - although the risk is low please be careful running this command 
against a production system.  These are debugging tools and it will suspend the 
arserverd process for a moment which may cause problems on a very busy server.  
If possible run this command when the server is not heavily loaded.

$ echo quit | gdb arserverd `pgrep arserverd` | grep LWP | sort -k5 | awk 
'BEGIN {print TID\t\tLWP\t\tHEX;}{ printf %i\t%i\t\t%s\n, strtonum($3), $5, 
$3}'
TIDLWP   HEX
47883904271504   3469  0x2b8cd71ac490
1088616768 3470  0x40e2f940
1089669440 3471  0x40f30940
1092467008 3472  0x411db940
1095625024 3527  0x414de940
1102993728 3528  0x41be5940
1100888384 3529  0x419e3940
1101941056 3530  0x41ae4940
1084586304 3531  0x40a57940
1106151744 3532  0x41ee8940
1086691648 3533  0x40c59940
1094572352 3534  0x413dd940
1104046400 3535  0x41ce6940
1097730368 3536  0x416e0940
1107204416 3537  0x41fe9940
1093519680 3538  0x412dc940
1105099072 3539  0x41de7940
1085638976 3540  0x40b58940
1083533632 3542  0x40956940
1099835712 3547  0x418e2940

The same output can be found using pstack/gstack;

$ pstack `pgrep arserverd` | grep '(LWP ' | sort -k6 | awk 'BEGIN {print 
TID\t\tLWP\t\tHEX;}{ printf %i\t%i\t\t%s\n, strtonum($4), $6, $4}'
TIDLWP   HEX
47883904271504   3469  0x2b8cd71ac490
1088616768 3470

Re: Help with identifying process id for a specific arserverd Thread on linux

[Steve Kallestad]

Honestly, I never really track things down to a particular thread, so I
don't know if this will help...

ps xjf


will show a tree of processes.  But if the thread pid isn't matching the
tid in the logs I don't know where else to look.

maybe...
ps -eLf
or
ps axms

Sorry, but I figured an attempt to help would be better than I know some
of these words.  Not much better, but better. :)

Steve

On Mon, Feb 25, 2013 at 12:05 PM, Campbell, Paul (Paul) p...@avaya.comwrote:

 **

 OK ARSystem Linux gurus out there, I am moving to RHEL6 from Solaris 9 and
 on Solaris I could run a prstat -L -p arserverd pid and it would give me
 the arserverd/threadID of the top cpu using thread, I could then look at
 the arthread log and see which tid that thread would be in the filter/sql
 log file to try and find out what that thread was doing.  Now that we are
 on RHEL Linux, we don’t have prstat, I have to use top and press shiftH
 to get the per thread cpu usage, but on Linux, each LWP has its own process
 ID, so I can’t figure out how to tie a high running thread pid with the
 thread tid in arthread log or filter/sql logs.  I tried ps -C arserverd -m
 -o pid,tid,pcpu, but the tid column showed me the process id from top.  I
 even looked at /proc/pid/status and it showed pid and tgid as the same
 and nothing matched what I saw in the arthread.log.  Ideas?
  _ARSlist: Where the Answers Are and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help with Support Company Access Configuration

[Keith fawcett]

Hi Anita,

Wouldn't that defeat the whole purpose of using another form like Support 
Company Access? Giving the support person an access restriction to the company 
would allow them to do more than just submit tickets for users in the other 
company.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help with Support Company Access Configuration

[Ankita Pankaj]

Hi Keith,

I am not sure if i got your problem correctly .
But have you given access(in restriction access table in people form) to
your user of support company for the Customer company.

Thanks,
Ankita



On Thu, Jan 31, 2013 at 9:47 PM, Keith fawcett keith.fawc...@gmail.comwrote:

 Has anyone setup Support Company Access Configuration? I'm trying to set
 it up and it's not working.

 I have added a support company to a customer company and then I've
 selected the Customer Company in the Drop-down and pressed Update.
 I then log in with the Support Company and try to create an incident
 ticket for the Customer Company, but I am not able to select the Customer
 Company or Person.

 Is there a defect around this or any know issues? Not sure if it matters,
 but I'm trying this on 8.0

 Thanks,
 Keith


 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Where the Answers Are, and have been for 20 years


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Help finding Documentation

[patchsk]

I think what you are looking for is Task Phase Mgmt.
Use this feature after testing thoroughly and after setting expectation 
with the users. 
At least in 7.6.03 this feature was error prone and caused confusion with 
the users.
Also if you enable this I think you may have to redo all your change 
templates to use this feature along with templates.

Pg31 ( Configuring TMS Phases) in Task Mgmt Administration Guide. 
http://documents.bmc.com/supportu/documents/34/12/103412/103412.pdf 

Also there is a white paper on this topic.
http://documents.bmc.com/supportu/documents/42/21/194221/194221.pdf 

On Tuesday, September 25, 2012 11:13:23 AM UTC-7, Pargeter, Christie :CO IS 
wrote:

 ** 

 Hi All – I heard with ITSM 7.6.4 you could have tasks activated at the 
 Planning In Progress stage but I am not seeing how to do that.  If anyone 
 had an idea where the documentation is I would appreciate it or any help 
 around configuring and using this feature.

  

  

  
 --


 *Christie Pargeter *
 *Legacy Health** ***

 *IS - Programming*

 *SR Technical Analyst***

 cparge...@lhs.org javascript:

 *  **1120 Building* 

 tel: 503-415-5149

  
 _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_


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

Re: Help finding Documentation

[Pargeter, Christie :CO IS]

Thanks!!! This looks like exactly what I am looking for.

 

From: patchsk [mailto:vamsi...@gmail.com] 
Sent: Tuesday, September 25, 2012 11:46 AM
To: arsl...@googlegroups.com
Cc: arslist@ARSLIST.ORG; arslist@ARSLIST.ORG; Pargeter, Christie :CO IS
Subject: Re: Help finding Documentation

 

I think what you are looking for is Task Phase Mgmt.

Use this feature after testing thoroughly and after setting expectation with 
the users. 

At least in 7.6.03 this feature was error prone and caused confusion with the 
users.

Also if you enable this I think you may have to redo all your change templates 
to use this feature along with templates.

 

Pg31 ( Configuring TMS Phases) in Task Mgmt Administration Guide. 

http://documents.bmc.com/supportu/documents/34/12/103412/103412.pdf 

 

Also there is a white paper on this topic.

http://documents.bmc.com/supportu/documents/42/21/194221/194221.pdf 

On Tuesday, September 25, 2012 11:13:23 AM UTC-7, Pargeter, Christie :CO IS 
wrote:

** 

Hi All – I heard with ITSM 7.6.4 you could have tasks activated at the Planning 
In Progress stage but I am not seeing how to do that.  If anyone had an idea 
where the documentation is I would appreciate it or any help around configuring 
and using this feature.

 

 

 




Christie Pargeter 
Legacy Health 

IS - Programming

SR Technical Analyst

cparge...@lhs.org javascript: 

  1120 Building 

tel: 503-415-5149

 

_attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_


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

Re: Help with LDAP Configuration

[andres tamayo]

Guillermo entendiendo que estas configurando LDAP a traves de AREA
plugin en el caso de tener varios servers LDAP debes usar el area hub
pugin en el manual de integration hay mas informacion a respecto, no
recuerdo mucho en este momento los detalles.

saludos

2012/9/5 Guillermo Alfredo Torres Barron guillermo.torres.bar...@banorte.com:
 Hi dear listers
 We need to have two LDAP servers configured in our production server, we can 
 have users from both LDAP's, we did a test in our QA environment but receive 
 Authentication Error with every user, so we had reverse the configuration.
 How can we configured this??
 Thanks in advanced
 Greetings from Mexico City

 Este correo electronico es confidencial y/o puede contener informacion 
 privilegiada.
 Si usted no es su destinatario o no es alguna persona autorizada por este 
 para recibir sus correos electronicos, NO debera usted utilizar, copiar, 
 revelar, o tomar ninguna accion basada en este correo electronico o cualquier 
 otra informacion incluida en el, favor de notificar al remitente de inmediato 
 mediante el reenvio de este correo electronico y borrar a continuacion 
 totalmente este correo electronico y sus anexos.
 Nota: Los acentos y caracteres especiales fueron omitidos para su correcta 
 lectura en cualquier medio electronico.

 This e-mail is confidential and/or may contain privileged information.
 If you are not the addressee or authorized to receive this for the addressee, 
 you must not use, copy, disclose, or take any action based on this message or 
 any other information herein, please advise the sender immediately by reply 
 this e-mail and delete this e-mail and  its attachments.

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

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

Re: Help with LDAP Configuration

[Karthik]

Can you list the LDAP configuration parameters?

Regards,
Karthik

On 6 September 2012 18:16, andres tamayo cycom...@gmail.com wrote:

 Guillermo entendiendo que estas configurando LDAP a traves de AREA
 plugin en el caso de tener varios servers LDAP debes usar el area hub
 pugin en el manual de integration hay mas informacion a respecto, no
 recuerdo mucho en este momento los detalles.

 saludos

 2012/9/5 Guillermo Alfredo Torres Barron 
 guillermo.torres.bar...@banorte.com:
  Hi dear listers
  We need to have two LDAP servers configured in our production server, we
 can have users from both LDAP's, we did a test in our QA environment but
 receive Authentication Error with every user, so we had reverse the
 configuration.
  How can we configured this??
  Thanks in advanced
  Greetings from Mexico City
 
  Este correo electronico es confidencial y/o puede contener informacion
 privilegiada.
  Si usted no es su destinatario o no es alguna persona autorizada por
 este para recibir sus correos electronicos, NO debera usted utilizar,
 copiar, revelar, o tomar ninguna accion basada en este correo electronico o
 cualquier otra informacion incluida en el, favor de notificar al remitente
 de inmediato mediante el reenvio de este correo electronico y borrar a
 continuacion totalmente este correo electronico y sus anexos.
  Nota: Los acentos y caracteres especiales fueron omitidos para su
 correcta lectura en cualquier medio electronico.
 
  This e-mail is confidential and/or may contain privileged information.
  If you are not the addressee or authorized to receive this for the
 addressee, you must not use, copy, disclose, or take any action based on
 this message or any other information herein, please advise the sender
 immediately by reply this e-mail and delete this e-mail and  its
 attachments.
 
 
 ___
  UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
  attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are


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


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

Re: Help with LDAP Configuration

[andres tamayo]

En realidad son los mismos. es decir en la configuracion de ambos
servers LDAP nada cambia. Lo que debes considerar es que en vez de
usar el plugin AREA debes usar el que se llama AREA HUB. esto es lo
que aparece en el manual de ar integrations.

Setting up the AREA hub
The AR System plug-in server supports only one AREA plug-in directly. You can,
however, add a single AREA Hub plug-in to the plug-in server and then add
multiple AREA plug-ins to the AREA Hub plug-in. Plug-ins you add to the AREA
Hub are referred to as Hub-plug-ins. The AREA Hub propagates the calls it
receives from the Hub-plug-ins to the Plug-in server.
The AREA Hub loads the Hub-plug-ins in the order in which they appear in the
ar.cfg or ar.conf file. That is, the first entry the AREA Hub finds in
the ar.cfg
file is the first plug-in loaded, the second entry the second, and so on.

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

Re: Help on archiving data.

[Longwing, LJ CTR MDA/IC]

Robin,
I'm sure any method you use that is supported (through the application) will 
take just as long as the archive process built in, so your only option that I 
can think of that would be faster would be through DB directly, but doing that 
of course is not recommended or supported by BMC...so if you decide to go down 
that path, you go 'alone' from a support perspective.

Regarding taking things out of Remedy DB into another DBthis of course 
steps outside of the Remedy world anyway...but as Jose suggested, you can do 
this directly at the DB as well.

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Robin
Sent: Tuesday, August 07, 2012 1:02 AM
To: arslist@ARSLIST.ORG
Subject: Help on archiving data.

Hi all,

Can you please let me know your suggestions on requirements 1 and 2?

1) Transfer records from a regular form to an archive form and delete records 
from the regular form. I don't want to use built-in remedy archive feature as 
it consumes lot of resources and takes long time to complete.

2) Transfer records from an archive table to a different database table and 
delete records from the archive table.

The AR System database is oracle.


Regards
Robin

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

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

Re: help reseting application password for Flashboards 7604

[Carl Wilson]

Hi,

if running from the flashboards directory, you can use the syntax:

 

D:\Program Files\BMC Software\ARSystem\flashboardsjava -classpath
.;D:\Program Files\BMC Software\ARSystem\flashboard

s\* -DflashInstallPath=D:\program files\BMC Software\ARSystem\flashboards
FBDriver

 

This should work (as shown below on my system):

 

---

 

X:\Program Files\BMC Software\ARSystem\flashboardsjava -classpath
.;X:\Program Files\BMC Software\ARSystem\flashboards

\* -DflashInstallPath=X:\Program Files\BMC Software\ARSystem\flashboards
FBDriver

 Flashboard Driver

 

PasswordMisc

--  

set  (spw)  quit (q)

 

 

Enter the command :

 

---

 

It appears the -DflashInstallPath command line switch is needed to point
to the config files used by the  flashd7604_build002.jar file (as java
-cp . FBDriver throws dependency errors )

 

 

Cheers

Carl

 

http://www.missingpiecessoftware.com/

 

 

 

 

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Goodall, Andrew C
Sent: 18 July 2012 01:57
To: arslist@ARSLIST.ORG
Subject: help reseting application password for Flashboards 7604

 

** 

 

I keep getting the below error no matter the syntax variation I try:

 

D:\program files\BMC Software\ARSystem\flashboardsjava -classpath
.:arutil7604_

build002.jar;flashd7604_build002.jar;-DflashInstallPath=D:\program
files\BMC So

ftware\ARSystem\flashboards FBDriver

Exception in thread main java.lang.NoClassDefFoundError: FBDriver

Caused by: java.lang.ClassNotFoundException: FBDriver

at java.net.URLClassLoader$1.run(Unknown Source)

at java.security.AccessController.doPrivileged(Native Method)

at java.net.URLClassLoader.findClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

Could not find the main class: FBDriver.  Program will exit.

 

 

This is on a windows box (windows 2008 x64)

 

The flashboard guide 7.6.04 page 84/92 says:

 

java -classpath arutil7603_build001.jar;flashd7603_build001.jar;

-DflashInstallPath=FlashboardsInstallationDirectory FBDriver

 

 

It doesn't say change DflashInstallPath=FlashboardsInstallationDirectory -
and whether this is a variable or not - I'm assuming they want me to update
to actual path name

 

 

I tried:

java -classpath
arutil7604_build002.jar;flashd7604_build002.jar;-DflashInstallPath=Flashboar
dsInstallationDirectory FBDriver

 

 

I tried:

java -classpath
arutil7604_build002.jar;flashd7604_build002.jar;-DflashInstallPath=D:\progr
am files\BMC Software\ARSystem\flashboards FBDriver

 

 

I tried adding .:  - see https://kb.bmc.com/infocenter/index?page=content
https://kb.bmc.com/infocenter/index?page=contentid=KA334313actp=searchvi
ewlocale=en_USsearchid=1342572704320
id=KA334313actp=searchviewlocale=en_USsearchid=1342572704320

 

 

java -classpath
.:arutil7604_build002.jar;flashd7604_build002.jar;-DflashInstallPath=Flashbo
ardsInstallationDirectory FBDriver

 

java -classpath
.:arutil7604_build002.jar;flashd7604_build002.jar;-DflashInstallPath=D:\pro
gram files\BMC Software\ARSystem\flashboards FBDriver

 

 

No luck..??? I'm probably missing something obvious, but it's been a long
day and I can't spot it.

 

 

Regards,

 

Andrew C. Goodall

Software Engineer

Development Services

ago...@jcpenney.com

jcpenney

6501 Legacy Drive

Plano, TX 75024

jcp.com

 


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.

_attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_


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

Re: help reseting application password for Flashboards 7604

[Goodall, Andrew C]

Thanks so much Carl - that worked.

 

I think it is time for BMC to update their doc on this process.

 

Regards,

 

Andrew C. Goodall

Software Engineer

Development Services

ago...@jcpenney.com

T 972.431.1518

F 972.431.1027

jcpenney

6501 Legacy Drive

Plano, TX 75024

jcp.com

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@arslist.org] On Behalf Of Carl Wilson
Sent: Wednesday, July 18, 2012 4:06 AM
To: arslist@arslist.org
Subject: Re: help reseting application password for Flashboards 7604

 

** 

Hi,

if running from the flashboards directory, you can use the syntax:

 

D:\Program Files\BMC Software\ARSystem\flashboardsjava -classpath
.;D:\Program Files\BMC Software\ARSystem\flashboard

s\* -DflashInstallPath=D:\program files\BMC
Software\ARSystem\flashboards FBDriver

 

This should work (as shown below on my system):

 

---

 

X:\Program Files\BMC Software\ARSystem\flashboardsjava -classpath
.;X:\Program Files\BMC Software\ARSystem\flashboards

\* -DflashInstallPath=X:\Program Files\BMC
Software\ARSystem\flashboards FBDriver

 Flashboard Driver

 

PasswordMisc

--  

set  (spw)  quit (q)

 

 

Enter the command :

 

---

 

It appears the -DflashInstallPath command line switch is needed to
point to the config files used by the  flashd7604_build002.jar file
(as java -cp . FBDriver throws dependency errors )

 

 

Cheers

Carl

 

http://www.missingpiecessoftware.com/

 

 

 

 

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Goodall, Andrew C
Sent: 18 July 2012 01:57
To: arslist@ARSLIST.ORG
Subject: help reseting application password for Flashboards 7604

 

** 

 

I keep getting the below error no matter the syntax variation I try:

 

D:\program files\BMC Software\ARSystem\flashboardsjava -classpath
.:arutil7604_

build002.jar;flashd7604_build002.jar;-DflashInstallPath=D:\program
files\BMC So

ftware\ARSystem\flashboards FBDriver

Exception in thread main java.lang.NoClassDefFoundError: FBDriver

Caused by: java.lang.ClassNotFoundException: FBDriver

at java.net.URLClassLoader$1.run(Unknown Source)

at java.security.AccessController.doPrivileged(Native Method)

at java.net.URLClassLoader.findClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

Could not find the main class: FBDriver.  Program will exit.

 

 

This is on a windows box (windows 2008 x64)

 

The flashboard guide 7.6.04 page 84/92 says:

 

java -classpath arutil7603_build001.jar;flashd7603_build001.jar;

-DflashInstallPath=FlashboardsInstallationDirectory FBDriver

 

 

It doesn't say change DflashInstallPath=FlashboardsInstallationDirectory
- and whether this is a variable or not - I'm assuming they want me to
update to actual path name

 

 

I tried:

java -classpath
arutil7604_build002.jar;flashd7604_build002.jar;-DflashInstallPath=Flash
boardsInstallationDirectory FBDriver

 

 

I tried:

java -classpath
arutil7604_build002.jar;flashd7604_build002.jar;-DflashInstallPath=D:\p
rogram files\BMC Software\ARSystem\flashboards FBDriver

 

 

I tried adding .:  - see
https://kb.bmc.com/infocenter/index?page=contentid=KA334313actp=search
viewlocale=en_USsearchid=1342572704320

 

 

java -classpath
.:arutil7604_build002.jar;flashd7604_build002.jar;-DflashInstallPath=Fla
shboardsInstallationDirectory FBDriver

 

java -classpath
.:arutil7604_build002.jar;flashd7604_build002.jar;-DflashInstallPath=D:
\program files\BMC Software\ARSystem\flashboards FBDriver

 

 

No luck??? I'm probably missing something obvious, but it's been a
long day and I can't spot it.

 

 

Regards,

 

Andrew C. Goodall

Software Engineer

Development Services

ago...@jcpenney.com

jcpenney

6501 Legacy Drive

Plano, TX 75024

jcp.com

 


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.

_attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_

_attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ 


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

Re: help want to send 3 month back messages to relate forms

[gok's]

Hi Misi,

thanks you very much for this idea. I am going to try this.

Thanks
G

Misi Mladoniczky wrote:
 
 Hi,
 
 What kind of trigger do you have to set of your Pushes? Just make sure to
 trigger these manually.
 
 One technique is to create a temporary display-only-field which you use in
 a Modify-All, and have your filters trigger on that.
 
 Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
 
 Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
 * RRR|License - Not enough Remedy licenses? Save money by optimizing.
 * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
 Find these products, and many free tools and utilities, at http://rrr.se.
 
 Hi All,

 Environment: ARServer 7.5 patch 2; Database 2005 SQL server; Windows
 Server

 we are some time getting emails from OutLook express in HTML format to AR
 System Email Messages form to the HTML body field. I have written
 workflow
 to push it to the relate Change,Incident and Tasks which is working.All I
 want is there were messages are there from last 3 months can any one
 suggest
 me how to push them to related forms if I use escalation can some tell
 how
 to calculate the time which are last 3 months back should be pushed.

 Thanks
 G
 --
 View this message in context:
 http://old.nabble.com/help-want-to-send-3-month-back-messages-to-relate-forms-tp33763712p33763712.html
 Sent from the ARS (Action Request System) mailing list archive at
 Nabble.com.

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

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

-- 
View this message in context: 
http://old.nabble.com/help-want-to-send-3-month-back-messages-to-relate-forms-tp33763712p33839979.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

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

Re: help want to send 3 month back messages to relate forms

[Misi Mladoniczky]

Hi,

What kind of trigger do you have to set of your Pushes? Just make sure to
trigger these manually.

One technique is to create a temporary display-only-field which you use in
a Modify-All, and have your filters trigger on that.

Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)

Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.

 Hi All,

 Environment: ARServer 7.5 patch 2; Database 2005 SQL server; Windows
 Server

 we are some time getting emails from OutLook express in HTML format to AR
 System Email Messages form to the HTML body field. I have written workflow
 to push it to the relate Change,Incident and Tasks which is working.All I
 want is there were messages are there from last 3 months can any one
 suggest
 me how to push them to related forms if I use escalation can some tell how
 to calculate the time which are last 3 months back should be pushed.

 Thanks
 G
 --
 View this message in context:
 http://old.nabble.com/help-want-to-send-3-month-back-messages-to-relate-forms-tp33763712p33763712.html
 Sent from the ARS (Action Request System) mailing list archive at
 Nabble.com.

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


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

Re: Help For Depurate ITSM Forms

[Guillermo Alfredo Torres Barron]

Hi Folks!!
In this moment we have approximately 200GB assigned for DB data files in 
production environment, however we have 62% used of this disk space, so we need 
delete old registries and backup them but we don't know all forms that we need 
to do this, we want to backup data in ARX files
Only we have implemented Incident and Change Management modules in production 
environment actually
ARS 7.6.03, ITSM 7.6.03, Oracle 11g and Solaris 10
Thanks in advance Greetings


-Mensaje original-
De: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] 
En nombre de Joe Martin D'Souza Enviado el: Lunes, 23 de Abril de 2012 05:25 
p.m.
Para: arslist@ARSLIST.ORG
Asunto: Re: Help For Depurate ITSM Forms

Is the disk just too small? Or has the database really outgrown to ginormous 
proportions? What is your DB size? And what is the size of the disk that 
supports your data files?

Joe

-Original Message-
From: Guillermo Alfredo Torres Barron
Sent: Monday, April 23, 2012 6:22 PM Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Help For Depurate ITSM Forms

Hi folks
We have a problem with disc space of the database, so we need delete registries 
and backup them but don't know which forms must be do this Thanks Greetings

-Mensaje original-
De: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] 
En nombre de Joe Martin D'Souza Enviado el: Lunes, 23 de Abril de 2012 04:58 
p.m.
Para: arslist@ARSLIST.ORG
Asunto: Re: Help For Depurate ITSM Forms

What is the purpose of doing this? Do you want to refresh your production 
database to a test database? Or are you just looking to clean up a system?

Joe

-Original Message-
From: Guillermo Alfredo Torres Barron
Sent: Monday, April 23, 2012 5:52 PM Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Help For Depurate ITSM Forms

Hi dear listers
We need to depurate and back up Incident and Change Management modules of ITSM, 
but we don't know which forms must be depurate and back up, only we want to do 
this with principal forms not with foundation o configuration catalogs Is there 
any manual or document where we can know which forms nedd to depurate?
Or
Any suggestion?
We have Oracle 11g, Solaris 10,  AR Server 7.6.03, and ITSM 7.6.03 Thanks in 
advance Greetings from Mexico City

Este correo electronico es confidencial y/o puede contener informacion 
privilegiada.
Si usted no es su destinatario o no es alguna persona autorizada por este para 
recibir sus correos electronicos, NO debera usted utilizar, copiar, revelar, o 
tomar ninguna accion basada en este correo electronico o cualquier otra 
informacion incluida en el, favor de notificar al remitente de inmediato 
mediante el reenvio de este correo electronico y borrar a continuacion 
totalmente este correo electronico y sus anexos.
Nota: Los acentos y caracteres especiales fueron omitidos para su correcta 
lectura en cualquier medio electronico.

This e-mail is confidential and/or may contain privileged information.
If you are not the addressee or authorized to receive this for the addressee, 
you must not use, copy, disclose, or take any action based on this message or 
any other information herein, please advise the sender immediately by reply 
this e-mail and delete this e-mail and  its attachments.

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

Este correo electronico es confidencial y/o puede contener informacion 
privilegiada.
Si usted no es su destinatario o no es alguna persona autorizada por este para 
recibir sus correos electronicos, NO debera usted utilizar, copiar, revelar, o 
tomar ninguna accion basada en este correo electronico o cualquier otra 
informacion incluida en el, favor de notificar al remitente de inmediato 
mediante el reenvio de este correo electronico y borrar a continuacion 
totalmente este correo electronico y sus anexos.
Nota: Los acentos y caracteres especiales fueron omitidos para su correcta 
lectura en cualquier medio electronico.

This e-mail is confidential and/or may contain privileged information.
If you are not the addressee or authorized to receive this for the addressee, 
you must not use, copy, disclose, or take any action based on this message or 
any other information herein, please advise the sender immediately by reply 
this e-mail and delete this e-mail and  its attachments.

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

Este correo electronico es confidencial y/o puede contener informacion 
privilegiada.
Si usted no es su destinatario o no es alguna persona autorizada por este para 
recibir sus correos electronicos, NO debera usted

Re: Help with AIE

[Jose Huerta]

Thanks! Solved.

Don't know why, but it worked a few days ago.

Jose M. Huerta
Project Manager**

Movil: 661 665 088

Telf.: 971 75 03 24

Fax: 971 75 07 94

 http://www.sm2baleares.es/

SM2 Baleares S.A.
C/Rita Levi 

Edificio SM2 Parc Bit

07121 Palma de Mallorca

  http://es-es.facebook.com/pages/SM2-Baleares/158608627954
  http://twitter.com/#!/SM2Baleares
 http://www.linkedin.com/company/sm2-baleares

La información contenida en este mensaje de correo electrónico es
confidencial. La misma, es enviada con la intención de que únicamente sea
leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje
por otras personas no está autorizado, por lo que en tal caso, le rogamos
que nos lo comunique por la misma vía, se abstenga de realizar copias del
mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de
inmediato.

P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es
necesario.



On Mon, Apr 23, 2012 at 14:30, Frank Caruso caruso.fr...@gmail.com wrote:

 Are the ARS servers running on a specifc TCP port? If so that would have
 to specified in the AIE data exchange.


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


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
image004.jpgimage003.jpgimage001.jpgimage002.jpg

Re: Help For Depurate ITSM Forms

[Guillermo Alfredo Torres Barron]

Hi Joe
In this moment we have approximately 200GB assigned for DB data files in 
production environment, however we have 62% used of this disk space, so we need 
delete old registries and backup them but we don't know all forms that we need 
to do this, we want to backup data in ARX files
Only we have implemented Incident and Change Management modules in production 
environment actually
Thanks in advance
Greetings


-Mensaje original-
De: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] 
En nombre de Joe Martin D'Souza
Enviado el: Lunes, 23 de Abril de 2012 05:25 p.m.
Para: arslist@ARSLIST.ORG
Asunto: Re: Help For Depurate ITSM Forms

Is the disk just too small? Or has the database really outgrown to ginormous 
proportions? What is your DB size? And what is the size of the disk that 
supports your data files?

Joe

-Original Message-
From: Guillermo Alfredo Torres Barron
Sent: Monday, April 23, 2012 6:22 PM Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Help For Depurate ITSM Forms

Hi folks
We have a problem with disc space of the database, so we need delete registries 
and backup them but don't know which forms must be do this Thanks Greetings

-Mensaje original-
De: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] 
En nombre de Joe Martin D'Souza Enviado el: Lunes, 23 de Abril de 2012 04:58 
p.m.
Para: arslist@ARSLIST.ORG
Asunto: Re: Help For Depurate ITSM Forms

What is the purpose of doing this? Do you want to refresh your production 
database to a test database? Or are you just looking to clean up a system?

Joe

-Original Message-
From: Guillermo Alfredo Torres Barron
Sent: Monday, April 23, 2012 5:52 PM Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Help For Depurate ITSM Forms

Hi dear listers
We need to depurate and back up Incident and Change Management modules of ITSM, 
but we don't know which forms must be depurate and back up, only we want to do 
this with principal forms not with foundation o configuration catalogs Is there 
any manual or document where we can know which forms nedd to depurate?
Or
Any suggestion?
We have Oracle 11g, Solaris 10,  AR Server 7.6.03, and ITSM 7.6.03 Thanks in 
advance Greetings from Mexico City

Este correo electronico es confidencial y/o puede contener informacion 
privilegiada.
Si usted no es su destinatario o no es alguna persona autorizada por este para 
recibir sus correos electronicos, NO debera usted utilizar, copiar, revelar, o 
tomar ninguna accion basada en este correo electronico o cualquier otra 
informacion incluida en el, favor de notificar al remitente de inmediato 
mediante el reenvio de este correo electronico y borrar a continuacion 
totalmente este correo electronico y sus anexos.
Nota: Los acentos y caracteres especiales fueron omitidos para su correcta 
lectura en cualquier medio electronico.

This e-mail is confidential and/or may contain privileged information.
If you are not the addressee or authorized to receive this for the addressee, 
you must not use, copy, disclose, or take any action based on this message or 
any other information herein, please advise the sender immediately by reply 
this e-mail and delete this e-mail and  its attachments.

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

Este correo electronico es confidencial y/o puede contener informacion 
privilegiada.
Si usted no es su destinatario o no es alguna persona autorizada por este para 
recibir sus correos electronicos, NO debera usted utilizar, copiar, revelar, o 
tomar ninguna accion basada en este correo electronico o cualquier otra 
informacion incluida en el, favor de notificar al remitente de inmediato 
mediante el reenvio de este correo electronico y borrar a continuacion 
totalmente este correo electronico y sus anexos.
Nota: Los acentos y caracteres especiales fueron omitidos para su correcta 
lectura en cualquier medio electronico.

This e-mail is confidential and/or may contain privileged information.
If you are not the addressee or authorized to receive this for the addressee, 
you must not use, copy, disclose, or take any action based on this message or 
any other information herein, please advise the sender immediately by reply 
this e-mail and delete this e-mail and  its attachments.

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

Este correo electronico es confidencial y/o puede contener informacion 
privilegiada.
Si usted no es su destinatario o no es alguna persona autorizada por este para 
recibir sus correos electronicos, NO debera usted utilizar, copiar, revelar, o 
tomar ninguna accion basada en

Re: Help with AIE

[Frank Caruso]

Are the ARS servers running on a specifc TCP port? If so that would have to 
specified in the AIE data exchange.

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

Re: Help For Depurate ITSM Forms

[Joe Martin D'Souza]

What is the purpose of doing this? Do you want to refresh your production 
database to a test database? Or are you just looking to clean up a system?


Joe

-Original Message- 
From: Guillermo Alfredo Torres Barron
Sent: Monday, April 23, 2012 5:52 PM Newsgroups: 
public.remedy.arsystem.general

To: arslist@ARSLIST.ORG
Subject: Help For Depurate ITSM Forms

Hi dear listers
We need to depurate and back up Incident and Change Management modules of 
ITSM, but we don't know which forms must be depurate and back up, only we 
want to do this with principal forms not with foundation o configuration 
catalogs Is there any manual or document where we can know which forms nedd 
to depurate?

Or
Any suggestion?
We have Oracle 11g, Solaris 10,  AR Server 7.6.03, and ITSM 7.6.03 Thanks in 
advance Greetings from Mexico City


Este correo electronico es confidencial y/o puede contener informacion 
privilegiada.
Si usted no es su destinatario o no es alguna persona autorizada por este 
para recibir sus correos electronicos, NO debera usted utilizar, copiar, 
revelar, o tomar ninguna accion basada en este correo electronico o 
cualquier otra informacion incluida en el, favor de notificar al remitente 
de inmediato mediante el reenvio de este correo electronico y borrar a 
continuacion totalmente este correo electronico y sus anexos.
Nota: Los acentos y caracteres especiales fueron omitidos para su correcta 
lectura en cualquier medio electronico.


This e-mail is confidential and/or may contain privileged information.
If you are not the addressee or authorized to receive this for the 
addressee, you must not use, copy, disclose, or take any action based on 
this message or any other information herein, please advise the sender 
immediately by reply this e-mail and delete this e-mail and  its 
attachments. 


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

Re: Help For Depurate ITSM Forms

[Joe Martin D'Souza]

Got me looking for synonyms for other operations that may apply..
Submit - abide, accede, acknowledge, acquiesce, agree, appease, be 
submissive, bend, bow, buckle, capitulate, cave, cede, concede, defer, eat 
crow, fold, give away, give ground, give in, give way, go with the flow, 
grin and bear it, humor, indulge, knuckle, knuckle under, kowtow, lay down 
arms, obey, put up with, quit, relent, relinquish, resign oneself, say 
uncle, stoop, succumb, surrender, throw in the towel, toe the line, 
tolerate, truckle, withstand, yield


Ok so submit has very few that may really stay in context... Modify has some 
interesting ones..


Modify - correct, customize, doctor, mutate, recast, redo, refashion, 
reform, remodel, reorganize, revise, rework, switch over, transfigure, 
transform, transmogrify, transmute, tweak.. There are others but these sort 
of apply for a modify button..


Search has some really funny ones if we used it in the ARS context..

Search - chase, examination, exploration, fishing expedition, frisking, 
going-over, hunt, inquest, inquiry, inspection, investigation, legwork, 
perquisition, pursual, pursuance, pursuing, pursuit, quest, research, 
rummage, scrutiny, shakedown, wild-goose chase, witch hunt


Frisk that table! Scrutinize that!

Ok this is getting off topic..

Joe

-Original Message- 
From: Tauf Chowdhury
Sent: Monday, April 23, 2012 6:03 PM Newsgroups: 
public.remedy.arsystem.general

To: arslist@ARSLIST.ORG
Subject: Re: OT: Help For Depurate ITSM Forms

OK you got me. The real reason I feel like an idiot is that I thought
depurate was a spanish word... I wasn't even I the right language
dude!

Sent from my iPhone

On Apr 23, 2012, at 5:01 PM, Joe Martin D'Souza jdso...@shyle.net wrote:

Don't feel like that.. I looked up an online dictionary too although I had 
a nagging feeling that is what it meant..


Next time I create a button for Delete All functionality I'll name it 
Depurate That!!! So don't play scrabble with my users :-)


Joe

-Original Message- From: Tauf Chowdhury
Sent: Monday, April 23, 2012 5:56 PM Newsgroups: 
public.remedy.arsystem.general

To: arslist@ARSLIST.ORG
Subject: OT: Help For Depurate ITSM Forms

I feel like an idiot. I had to look up the meaning of the word depurate.
I'll remember it now for Scrabble. :/

Sent from my iPhone

On Apr 23, 2012, at 4:53 PM, Guillermo Alfredo Torres Barron
guillermo.torres.bar...@banorte.com wrote:


Hi dear listers
We need to depurate and back up Incident and Change Management modules of 
ITSM, but we don't know which forms must be depurate and back up, only we 
want to do this with principal forms not with foundation o configuration 
catalogs Is there any manual or document where we can know which forms 
nedd to depurate?

Or
Any suggestion?
We have Oracle 11g, Solaris 10,  AR Server 7.6.03, and ITSM 7.6.03 Thanks 
in advance Greetings from Mexico City


Este correo electronico es confidencial y/o puede contener informacion 
privilegiada.
Si usted no es su destinatario o no es alguna persona autorizada por este 
para recibir sus correos electronicos, NO debera usted utilizar, copiar, 
revelar, o tomar ninguna accion basada en este correo electronico o 
cualquier otra informacion incluida en el, favor de notificar al 
remitente de inmediato mediante el reenvio de este correo electronico y 
borrar a continuacion totalmente este correo electronico y sus anexos.
Nota: Los acentos y caracteres especiales fueron omitidos para su 
correcta lectura en cualquier medio electronico.


This e-mail is confidential and/or may contain privileged information.
If you are not the addressee or authorized to receive this for the 
addressee, you must not use, copy, disclose, or take any action based on 
this message or any other information herein, please advise the sender 
immediately by reply this e-mail and delete this e-mail and  its 
attachments. 


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

Re: Help For Depurate ITSM Forms

[Tauf Chowdhury]

I think wild goose chase correctly represents searching in ARS.

Sent from my iPhone

On Apr 23, 2012, at 5:14 PM, Joe Martin D'Souza jdso...@shyle.net wrote:

 Got me looking for synonyms for other operations that may apply..
 Submit - abide, accede, acknowledge, acquiesce, agree, appease, be 
 submissive, bend, bow, buckle, capitulate, cave, cede, concede, defer, eat 
 crow, fold, give away, give ground, give in, give way, go with the flow, grin 
 and bear it, humor, indulge, knuckle, knuckle under, kowtow, lay down arms, 
 obey, put up with, quit, relent, relinquish, resign oneself, say uncle, 
 stoop, succumb, surrender, throw in the towel, toe the line, tolerate, 
 truckle, withstand, yield

 Ok so submit has very few that may really stay in context... Modify has some 
 interesting ones..

 Modify - correct, customize, doctor, mutate, recast, redo, refashion, reform, 
 remodel, reorganize, revise, rework, switch over, transfigure, transform, 
 transmogrify, transmute, tweak.. There are others but these sort of apply for 
 a modify button..

 Search has some really funny ones if we used it in the ARS context..

 Search - chase, examination, exploration, fishing expedition, frisking, 
 going-over, hunt, inquest, inquiry, inspection, investigation, legwork, 
 perquisition, pursual, pursuance, pursuing, pursuit, quest, research, 
 rummage, scrutiny, shakedown, wild-goose chase, witch hunt

 Frisk that table! Scrutinize that!

 Ok this is getting off topic..

 Joe

 -Original Message- From: Tauf Chowdhury
 Sent: Monday, April 23, 2012 6:03 PM Newsgroups: 
 public.remedy.arsystem.general
 To: arslist@ARSLIST.ORG
 Subject: Re: OT: Help For Depurate ITSM Forms

 OK you got me. The real reason I feel like an idiot is that I thought
 depurate was a spanish word... I wasn't even I the right language
 dude!

 Sent from my iPhone

 On Apr 23, 2012, at 5:01 PM, Joe Martin D'Souza jdso...@shyle.net wrote:

 Don't feel like that.. I looked up an online dictionary too although I had a 
 nagging feeling that is what it meant..

 Next time I create a button for Delete All functionality I'll name it 
 Depurate That!!! So don't play scrabble with my users :-)

 Joe

 -Original Message- From: Tauf Chowdhury
 Sent: Monday, April 23, 2012 5:56 PM Newsgroups: 
 public.remedy.arsystem.general
 To: arslist@ARSLIST.ORG
 Subject: OT: Help For Depurate ITSM Forms

 I feel like an idiot. I had to look up the meaning of the word depurate.
 I'll remember it now for Scrabble. :/

 Sent from my iPhone

 On Apr 23, 2012, at 4:53 PM, Guillermo Alfredo Torres Barron
 guillermo.torres.bar...@banorte.com wrote:

 Hi dear listers
 We need to depurate and back up Incident and Change Management modules of 
 ITSM, but we don't know which forms must be depurate and back up, only we 
 want to do this with principal forms not with foundation o configuration 
 catalogs Is there any manual or document where we can know which forms nedd 
 to depurate?
 Or
 Any suggestion?
 We have Oracle 11g, Solaris 10,  AR Server 7.6.03, and ITSM 7.6.03 Thanks 
 in advance Greetings from Mexico City

 Este correo electronico es confidencial y/o puede contener informacion 
 privilegiada.
 Si usted no es su destinatario o no es alguna persona autorizada por este 
 para recibir sus correos electronicos, NO debera usted utilizar, copiar, 
 revelar, o tomar ninguna accion basada en este correo electronico o 
 cualquier otra informacion incluida en el, favor de notificar al remitente 
 de inmediato mediante el reenvio de este correo electronico y borrar a 
 continuacion totalmente este correo electronico y sus anexos.
 Nota: Los acentos y caracteres especiales fueron omitidos para su correcta 
 lectura en cualquier medio electronico.

 This e-mail is confidential and/or may contain privileged information.
 If you are not the addressee or authorized to receive this for the 
 addressee, you must not use, copy, disclose, or take any action based on 
 this message or any other information herein, please advise the sender 
 immediately by reply this e-mail and delete this e-mail and  its 
 attachments.

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

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

Re: Help For Depurate ITSM Forms

[Guillermo Alfredo Torres Barron]

Hi folks
We have a problem with disc space of the database, so we need delete registries 
and backup them but don't know which forms must be do this
Thanks
Greetings

-Mensaje original-
De: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] 
En nombre de Joe Martin D'Souza
Enviado el: Lunes, 23 de Abril de 2012 04:58 p.m.
Para: arslist@ARSLIST.ORG
Asunto: Re: Help For Depurate ITSM Forms

What is the purpose of doing this? Do you want to refresh your production 
database to a test database? Or are you just looking to clean up a system?

Joe

-Original Message-
From: Guillermo Alfredo Torres Barron
Sent: Monday, April 23, 2012 5:52 PM Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Help For Depurate ITSM Forms

Hi dear listers
We need to depurate and back up Incident and Change Management modules of ITSM, 
but we don't know which forms must be depurate and back up, only we want to do 
this with principal forms not with foundation o configuration catalogs Is there 
any manual or document where we can know which forms nedd to depurate?
Or
Any suggestion?
We have Oracle 11g, Solaris 10,  AR Server 7.6.03, and ITSM 7.6.03 Thanks in 
advance Greetings from Mexico City

Este correo electronico es confidencial y/o puede contener informacion 
privilegiada.
Si usted no es su destinatario o no es alguna persona autorizada por este para 
recibir sus correos electronicos, NO debera usted utilizar, copiar, revelar, o 
tomar ninguna accion basada en este correo electronico o cualquier otra 
informacion incluida en el, favor de notificar al remitente de inmediato 
mediante el reenvio de este correo electronico y borrar a continuacion 
totalmente este correo electronico y sus anexos.
Nota: Los acentos y caracteres especiales fueron omitidos para su correcta 
lectura en cualquier medio electronico.

This e-mail is confidential and/or may contain privileged information.
If you are not the addressee or authorized to receive this for the addressee, 
you must not use, copy, disclose, or take any action based on this message or 
any other information herein, please advise the sender immediately by reply 
this e-mail and delete this e-mail and  its attachments.

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

Este correo electronico es confidencial y/o puede contener informacion 
privilegiada.
Si usted no es su destinatario o no es alguna persona autorizada por este para 
recibir sus correos electronicos, NO debera usted utilizar, copiar, revelar, o 
tomar ninguna accion basada en este correo electronico o cualquier otra 
informacion incluida en el, favor de notificar al remitente de inmediato 
mediante el reenvio de este correo electronico y borrar a continuacion 
totalmente este correo electronico y sus anexos.
Nota: Los acentos y caracteres especiales fueron omitidos para su correcta 
lectura en cualquier medio electronico.

This e-mail is confidential and/or may contain privileged information.
If you are not the addressee or authorized to receive this for the addressee, 
you must not use, copy, disclose, or take any action based on this message or 
any other information herein, please advise the sender immediately by reply 
this e-mail and delete this e-mail and  its attachments.

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

Re: Help For Depurate ITSM Forms

[Joe Martin D'Souza]

ROFL!

Well getting back on topic, if its refreshing the database from production 
to dev while skipping though all the uncessary data, I had written a script 
in DOS, utilizing oracles imp and exp functions to generate par files that 
did selective export and imports, which ignored what you do not care about..


If that’s the direction you want to go let me know and I may be able to 
help..


Joe

-Original Message- 
From: Tauf Chowdhury
Sent: Monday, April 23, 2012 6:15 PM Newsgroups: 
public.remedy.arsystem.general

To: arslist@ARSLIST.ORG
Subject: Re: Help For Depurate ITSM Forms

I think wild goose chase correctly represents searching in ARS.

Sent from my iPhone

On Apr 23, 2012, at 5:14 PM, Joe Martin D'Souza jdso...@shyle.net wrote:


Got me looking for synonyms for other operations that may apply..
Submit - abide, accede, acknowledge, acquiesce, agree, appease, be 
submissive, bend, bow, buckle, capitulate, cave, cede, concede, defer, eat 
crow, fold, give away, give ground, give in, give way, go with the flow, 
grin and bear it, humor, indulge, knuckle, knuckle under, kowtow, lay down 
arms, obey, put up with, quit, relent, relinquish, resign oneself, say 
uncle, stoop, succumb, surrender, throw in the towel, toe the line, 
tolerate, truckle, withstand, yield


Ok so submit has very few that may really stay in context... Modify has 
some interesting ones..


Modify - correct, customize, doctor, mutate, recast, redo, refashion, 
reform, remodel, reorganize, revise, rework, switch over, transfigure, 
transform, transmogrify, transmute, tweak.. There are others but these 
sort of apply for a modify button..


Search has some really funny ones if we used it in the ARS context..

Search - chase, examination, exploration, fishing expedition, frisking, 
going-over, hunt, inquest, inquiry, inspection, investigation, legwork, 
perquisition, pursual, pursuance, pursuing, pursuit, quest, research, 
rummage, scrutiny, shakedown, wild-goose chase, witch hunt


Frisk that table! Scrutinize that!

Ok this is getting off topic..

Joe

-Original Message- From: Tauf Chowdhury
Sent: Monday, April 23, 2012 6:03 PM Newsgroups: 
public.remedy.arsystem.general

To: arslist@ARSLIST.ORG
Subject: Re: OT: Help For Depurate ITSM Forms

OK you got me. The real reason I feel like an idiot is that I thought
depurate was a spanish word... I wasn't even I the right language
dude!

Sent from my iPhone

On Apr 23, 2012, at 5:01 PM, Joe Martin D'Souza jdso...@shyle.net wrote:

Don't feel like that.. I looked up an online dictionary too although I 
had a nagging feeling that is what it meant..


Next time I create a button for Delete All functionality I'll name it 
Depurate That!!! So don't play scrabble with my users :-)


Joe

-Original Message- From: Tauf Chowdhury
Sent: Monday, April 23, 2012 5:56 PM Newsgroups: 
public.remedy.arsystem.general

To: arslist@ARSLIST.ORG
Subject: OT: Help For Depurate ITSM Forms

I feel like an idiot. I had to look up the meaning of the word 
depurate.

I'll remember it now for Scrabble. :/

Sent from my iPhone

On Apr 23, 2012, at 4:53 PM, Guillermo Alfredo Torres Barron
guillermo.torres.bar...@banorte.com wrote:


Hi dear listers
We need to depurate and back up Incident and Change Management modules 
of ITSM, but we don't know which forms must be depurate and back up, 
only we want to do this with principal forms not with foundation o 
configuration catalogs Is there any manual or document where we can know 
which forms nedd to depurate?

Or
Any suggestion?
We have Oracle 11g, Solaris 10,  AR Server 7.6.03, and ITSM 7.6.03 
Thanks in advance Greetings from Mexico City


Este correo electronico es confidencial y/o puede contener informacion 
privilegiada.
Si usted no es su destinatario o no es alguna persona autorizada por 
este para recibir sus correos electronicos, NO debera usted utilizar, 
copiar, revelar, o tomar ninguna accion basada en este correo 
electronico o cualquier otra informacion incluida en el, favor de 
notificar al remitente de inmediato mediante el reenvio de este correo 
electronico y borrar a continuacion totalmente este correo electronico y 
sus anexos.
Nota: Los acentos y caracteres especiales fueron omitidos para su 
correcta lectura en cualquier medio electronico.


This e-mail is confidential and/or may contain privileged information.
If you are not the addressee or authorized to receive this for the 
addressee, you must not use, copy, disclose, or take any action based on 
this message or any other information herein, please advise the sender 
immediately by reply this e-mail and delete this e-mail and  its 
attachments. 


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

Re: Help For Depurate ITSM Forms

[Tauf Chowdhury]

Guillermo,
Perhaps you can start with the audit log tables and look at the email
forms also. Start simple and then work your way into depurating more
stuff.

Sent from my iPhone

On Apr 23, 2012, at 5:23 PM, Guillermo Alfredo Torres Barron
guillermo.torres.bar...@banorte.com wrote:

 Hi folks
 We have a problem with disc space of the database, so we need delete 
 registries and backup them but don't know which forms must be do this
 Thanks
 Greetings

 -Mensaje original-
 De: Action Request System discussion list(ARSList) 
 [mailto:arslist@ARSLIST.ORG] En nombre de Joe Martin D'Souza
 Enviado el: Lunes, 23 de Abril de 2012 04:58 p.m.
 Para: arslist@ARSLIST.ORG
 Asunto: Re: Help For Depurate ITSM Forms

 What is the purpose of doing this? Do you want to refresh your production 
 database to a test database? Or are you just looking to clean up a system?

 Joe

 -Original Message-
 From: Guillermo Alfredo Torres Barron
 Sent: Monday, April 23, 2012 5:52 PM Newsgroups:
 public.remedy.arsystem.general
 To: arslist@ARSLIST.ORG
 Subject: Help For Depurate ITSM Forms

 Hi dear listers
 We need to depurate and back up Incident and Change Management modules of 
 ITSM, but we don't know which forms must be depurate and back up, only we 
 want to do this with principal forms not with foundation o configuration 
 catalogs Is there any manual or document where we can know which forms nedd 
 to depurate?
 Or
 Any suggestion?
 We have Oracle 11g, Solaris 10,  AR Server 7.6.03, and ITSM 7.6.03 Thanks in 
 advance Greetings from Mexico City

 Este correo electronico es confidencial y/o puede contener informacion 
 privilegiada.
 Si usted no es su destinatario o no es alguna persona autorizada por este 
 para recibir sus correos electronicos, NO debera usted utilizar, copiar, 
 revelar, o tomar ninguna accion basada en este correo electronico o cualquier 
 otra informacion incluida en el, favor de notificar al remitente de inmediato 
 mediante el reenvio de este correo electronico y borrar a continuacion 
 totalmente este correo electronico y sus anexos.
 Nota: Los acentos y caracteres especiales fueron omitidos para su correcta 
 lectura en cualquier medio electronico.

 This e-mail is confidential and/or may contain privileged information.
 If you are not the addressee or authorized to receive this for the addressee, 
 you must not use, copy, disclose, or take any action based on this message or 
 any other information herein, please advise the sender immediately by reply 
 this e-mail and delete this e-mail and  its attachments.

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

 Este correo electronico es confidencial y/o puede contener informacion 
 privilegiada.
 Si usted no es su destinatario o no es alguna persona autorizada por este 
 para recibir sus correos electronicos, NO debera usted utilizar, copiar, 
 revelar, o tomar ninguna accion basada en este correo electronico o cualquier 
 otra informacion incluida en el, favor de notificar al remitente de inmediato 
 mediante el reenvio de este correo electronico y borrar a continuacion 
 totalmente este correo electronico y sus anexos.
 Nota: Los acentos y caracteres especiales fueron omitidos para su correcta 
 lectura en cualquier medio electronico.

 This e-mail is confidential and/or may contain privileged information.
 If you are not the addressee or authorized to receive this for the addressee, 
 you must not use, copy, disclose, or take any action based on this message or 
 any other information herein, please advise the sender immediately by reply 
 this e-mail and delete this e-mail and  its attachments.

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

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

Re: Help For Depurate ITSM Forms

[Joe Martin D'Souza]

Is the disk just too small? Or has the database really outgrown to ginormous 
proportions? What is your DB size? And what is the size of the disk that 
supports your data files?


Joe

-Original Message- 
From: Guillermo Alfredo Torres Barron
Sent: Monday, April 23, 2012 6:22 PM Newsgroups: 
public.remedy.arsystem.general

To: arslist@ARSLIST.ORG
Subject: Re: Help For Depurate ITSM Forms

Hi folks
We have a problem with disc space of the database, so we need delete 
registries and backup them but don't know which forms must be do this

Thanks
Greetings

-Mensaje original-
De: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] En nombre de Joe Martin D'Souza

Enviado el: Lunes, 23 de Abril de 2012 04:58 p.m.
Para: arslist@ARSLIST.ORG
Asunto: Re: Help For Depurate ITSM Forms

What is the purpose of doing this? Do you want to refresh your production 
database to a test database? Or are you just looking to clean up a system?


Joe

-Original Message-
From: Guillermo Alfredo Torres Barron
Sent: Monday, April 23, 2012 5:52 PM Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Help For Depurate ITSM Forms

Hi dear listers
We need to depurate and back up Incident and Change Management modules of 
ITSM, but we don't know which forms must be depurate and back up, only we 
want to do this with principal forms not with foundation o configuration 
catalogs Is there any manual or document where we can know which forms nedd 
to depurate?

Or
Any suggestion?
We have Oracle 11g, Solaris 10,  AR Server 7.6.03, and ITSM 7.6.03 Thanks in 
advance Greetings from Mexico City


Este correo electronico es confidencial y/o puede contener informacion 
privilegiada.
Si usted no es su destinatario o no es alguna persona autorizada por este 
para recibir sus correos electronicos, NO debera usted utilizar, copiar, 
revelar, o tomar ninguna accion basada en este correo electronico o 
cualquier otra informacion incluida en el, favor de notificar al remitente 
de inmediato mediante el reenvio de este correo electronico y borrar a 
continuacion totalmente este correo electronico y sus anexos.
Nota: Los acentos y caracteres especiales fueron omitidos para su correcta 
lectura en cualquier medio electronico.


This e-mail is confidential and/or may contain privileged information.
If you are not the addressee or authorized to receive this for the 
addressee, you must not use, copy, disclose, or take any action based on 
this message or any other information herein, please advise the sender 
immediately by reply this e-mail and delete this e-mail and  its 
attachments.


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


Este correo electronico es confidencial y/o puede contener informacion 
privilegiada.
Si usted no es su destinatario o no es alguna persona autorizada por este 
para recibir sus correos electronicos, NO debera usted utilizar, copiar, 
revelar, o tomar ninguna accion basada en este correo electronico o 
cualquier otra informacion incluida en el, favor de notificar al remitente 
de inmediato mediante el reenvio de este correo electronico y borrar a 
continuacion totalmente este correo electronico y sus anexos.
Nota: Los acentos y caracteres especiales fueron omitidos para su correcta 
lectura en cualquier medio electronico.


This e-mail is confidential and/or may contain privileged information.
If you are not the addressee or authorized to receive this for the 
addressee, you must not use, copy, disclose, or take any action based on 
this message or any other information herein, please advise the sender 
immediately by reply this e-mail and delete this e-mail and  its 
attachments. 


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

Re: Help SYS: Notification Messages.

[Kelly Deaver]

**
The basics -
1 - workflow looks to see if a notifaction should be sent. IF yes it set a temp field with a 'tag'
2 - workflow determines who to notifiy and looks to see the locale in the people record for the person to be notified
3 - looks in the SYS:Notification Messages form for tag and locale that match
4 - send message in that language

There is LOT more to it than that but this is enough to get you on the right track.

Kelly DeaverUnisys Corporation
kdea...@kellydeaver.com (ARSlist mail)kelly.dea...@unisys.com(Business mail)



 Original Message Subject: Help SYS: Notification Messages.From: "team.rem...@libero.it" team.rem...@libero.itDate: Fri, March 23, 2012 8:33 amTo: arslist@ARSLIST.ORGhello all,could you explain how the mechanism of the email notifications works ?I need to send mail in two different languages, some users understands Italian other English.I found the form SYS: Notification Messages, but I do not understand how to use it to meet my goal.Thanks Regards.Peter___UNSUBSCRIBE or access ARSlist Archives at www.arslist.orgattend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
_attend WWRUG12 www.wwrug.com  ARSlist: "Where the Answers Are"_

Re: help: srm add to cart gets 623 authentication error

[Danny Kellett]

Sounds like the request is going to a different server. Has the db been
restored from a different environment?

 

Are you using any form of AREA?

 

Regards

Danny

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi
Sent: 21 March 2012 22:06
To: arslist@ARSLIST.ORG
Subject: help: srm add to cart gets 623 authentication error

 

** ENV:: solaris: 10, oracle on server,  ars 7.5 midtier 7.6, itsm 7.6.03 or
so.. 

We have been working like crazy with this issue all day.. 
we have reset the password for application service, midtier service, slm
module, 
We have cleared 1million pounds of cache, too bad it is not in my car.. 

you can login, 
you can go to SRM
but if you add to cart, or submit with data.. Wham..  623 slaps you down.

We have no idea what happened..

Throw me a BONE



-- 
Patrick Zandi
_attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ 


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