SRM Read-Only Questions

[Mohamed Abdelaziz]

Has anyone been successful in finding a way to provide a read-only question
to the end user on an SRD? I know that it might not make sense but this is
the situation we have. We have few questions on an SRD and we need to
include a text field with a disclaimer for the customer to read it and
confirm acknowledgement by checking a check box. The only caveat is that the
text box cannot be read-only. It's either required, hidden or optional.

 

Environment Specs:

Oracle 10.2

SRM 7.6.02

ITSM 7.6.0

ARS 7.5.04

 

Regards,

Moe.


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

Re: Report error on web report drill-down

[Shafqat Ayaz]

Hi
what form are you running the report on? Are you sure that the form is not a 
Join Form? If it is a join form a drill down may give you this error. 

 


Shafqat Ayaz





 From: Joe Martin D'Souza 
To: arslist@ARSLIST.ORG 
Sent: Tuesday, March 13, 2012 6:53 PM
Subject: Re: Report error on web report drill-down
 
Its an assumption at this point that it may not be the issue. I forgot to 
mention that it could perhaps be renamed too. From the description of your 
environment, it is unlikely that these may be the issues. No experienced Remedy 
developer would delete or rename an already deployed form - but accidents can 
happen.. That’s a unforgivable crime in our world when it happens :-)

Maybe you could use Ben Cherny's Meta-Update tool to perform a comparison with 
what you have on your server, to what's usually available OTB as he has a 
spreadsheet with all OTB forms documented. He was just discussing that on 
another thread "ITSM 7.6.03 OTB forms that begin with CTM:Ppl% or CTM:PPL%" 
that I had started... Not everything missing from the difference you see may 
mean a problem as some of the differences could be because of the components 
you have installed, opposed to those that were installed when that spreadsheet 
was generated. Also the patch you are on would also make a difference..

In the end, flushing the cache should resolve the problem..

Joe


-Original Message- From: Kay Wilthew
Sent: Tuesday, March 13, 2012 2:00 PM Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Report error on web report drill-down

Thanks for the suggestion, Joe.  Your comment makes me question how a form 
could have been deleted when we're using an out of the box Remedy build, and 
there has never been any development performed.  I am the only administrator 
and I've never done any development on our system.  Is there a way to identify 
which form is missing, and is it really possible for a form to have been 
deleted?

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza
Sent: Monday, March 12, 2012 3:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: Report error on web report drill-down

Try flushing the Mid-Tier cache. My hunch is you may have deleted the original 
form that table field was pointing to, and created a new form, to point it to.

Even if that is not the case, refreshing your Mid-Tier cache would never hurt.

Cheers

Joe

-Original Message-
From: Kay W
Sent: Monday, March 12, 2012 3:01 PM Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Report error on web report drill-down

When running a web report, the report generates fine but when clicking on the 
hyperlink to drill down to a specific record in the report, Internet Explorer 8 
is generating an error that the page cannot be found.  This is a simple web 
report created within Reports Console of an out-of-box installation of Remedy 
7.6.04.

Any trouble-shooting advice?

Thanks,
Kay 
___
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: BMC_GLOBAL_DEFAULT_SRVC CI

[PCR Remedy]

Same for Problem or SLM Service field, the menu qualification do not
filter only the CI-Asset related to the current company..
I suggest to change the menus attached to the Service Field..




On Tue, Mar 13, 2012 at 6:47 AM, Tauf Chowdhury  wrote:
> I'm pretty sure it's tied to the default services that come with SRM.
>
> Sent from my iPhone
>
> On Mar 13, 2012, at 6:17 AM, Peter Romain
>  wrote:
>
>> Hi All,
>>
>> CMDB 7.6.04 SP2
>>
>> The BMC_GLOBAL_DEFAULT_SRVC CI appears in the Service field menu on the 
>> Infrastructure Change form.
>>
>> BMC tells us that this CI should never be deleted.
>>
>> Does anyone know precisely what it is for? I guess it's to do with the 
>> Service Catalog functionality in  Atrium Core.
>>
>> I can set the status of this CI from its out-of-the-box value of 'Ordered' 
>> to 'End of Life' to remove it from the menu but would this affect the 
>> functionality that the CI is there to support?
>>
>> Cheers
>>
>> Peter
>>
>> ___
>> 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: AR Server 7.6.04 patch 3 Installer and Reflection X Manager

[Pruitt, Christopher (Bank of America Account)]

Everyone thanks for your input. It turns out Fred's suggestion worked best.  I 
used export DISPLAY=IP:1.0 and now I can see the installer GUI.
Again, thanks to everyone for your very valuable feedback.

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


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


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Tuesday, March 13, 2012 1:11 PM
To: arslist@ARSLIST.ORG
Subject: Re: AR Server 7.6.04 patch 3 Installer and Reflection X Manager

I have seen issues with xWindows windows and RDC (it actually displays on the 
PC but RDC does not send that window across because the xWindows app is running 
in the console session and RDP is actually a new user login in another session).

Try connecting to your PC thru RDC in a console session
   mstsc.exe /console (or mstsc.exe /admin)

or alternatively set the DISPLAY environment to the second session  
DISPLAY=IP:1.0
   (You can see what sessions there are by running qwinsta in a dos window on 
the PC)


Fred


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of 
Pruitt, Christopher (Bank of America Account)
Sent: Tuesday, March 13, 2012 12:48 PM
To: arslist@ARSLIST.ORG
Subject: AR Server 7.6.04 patch 3 Installer and Reflection X Manager

I am at a loss here and was hoping someone on the list has encountered this 
issue.

I am trying to do a AR Server upgrade on a SUN UNIX server. I can start an 
xterm session using the Reflection X Manager and do an export DISPLAY=IP 
Address and start the AR Server 7.6.03 installer and it will bring up the 
installer on my desktop display. This works great when I am directly logged 
onto my desktop.

However, the issue I am having is when I am using Remove Desktop Connection 
(RDC) connected remotely to my desktop and perform that same steps to export 
the DISPLAY to my IP Address of my desktop it will not display the AR Server 
7.6.03 installer. Is there some setting or trick I am missing to let me see the 
AR Server 7.6.03 installer when I am using RDC into my desktop? I have gone 
through all the settings on the Reflection X Manager and nothing is obvious 
that I need to set to make the AR Server 7.6.03 installer display when using 
RDC.

Reflection X Manager version 14.1.0
AR Server 7.6.04 patch 3 Installer
SUN OS 5.9


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


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

___
UNSUBSCRIBE or access ARSlist Archives at 
www.arslist.org attend 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: Web Service GetList issue

[Wirasat Siddiqi]

Yes, I have removed them from Input Mapping. And yes server is configured 
to allow unqualified searches.

Thanks,
Wirasat



From:   "Grooms, Frederick W" 
To: arslist@ARSLIST.ORG
Date:   03/13/2012 04:09 PM
Subject:Re: Web Service GetList issue
Sent by:"Action Request System discussion list(ARSList)" 




You removed it from the inbound mapping?  Did you also remove it from the 
qualifications?  And is your server set up to allow unqualified searches?

Fred

-Original Message-
From: Action Request System discussion list(ARSList) [
mailto:arslist@ARSLIST.ORG] On Behalf Of Wirasat Siddiqi
Sent: Tuesday, March 13, 2012 3:03 PM
To: arslist@ARSLIST.ORG
Subject: Re: Web Service GetList issue

** This is what I get when I give 0. 

0 is not valid selection for Maximum Limit.,  5158, 
0 is not valid selection for Start Record.,  5158, 

Thanks, 
Wirasat Siddiqi 
Remedy Development Team 
Desk Phone: 202-502-3204 
Cell: 202-368-7190 
Email: wirasat_sidd...@ao.uscourts.gov 


-Original Message-
From:Jose Huerta 
To:arslist@ARSLIST.ORG 
Date:03/13/2012 03:58 PM 
Subject:Re: Web Service GetList issue 
Sent by:"Action Request System discussion list(ARSList)" 
 


** I think that you must give a value. It isn't mandatory to publish these 
values at the input, but you need to provide a value for them. So put 0, 0 
in order to not limit the response. 
Jose M. Huerta
Project Manager 
Movil: 661 665 088 
Telf.: 971 75 03 24 
Fax: 971 75 07 94 

SM2 Baleares S.A.
C/Rita Levi  
Edificio SM2 Parc Bit 
07121 Palma de Mallorca 


-Original Message-
On Tue, Mar 13, 2012 at 20:07, Wirasat Siddiqi wrote: 
** Hi all, 

I am having issue with a web service with Getlist operation. Created the 
web service with Getlist operation to search multiple rows on a form. 
Removed the startRecord and maxLimit from Input mapping as I don't want to 
use those limits. However, I am seeing these values under qualification 
field with no values entered. When I try to consume the web service, it 
does not return any data. 
Any help would be appreciated. 

Thanks, 
Wirasat 

___
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: Web Service GetList issue

[Grooms, Frederick W]

You removed it from the inbound mapping?  Did you also remove it from the 
qualifications?  And is your server set up to allow unqualified searches?

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Wirasat Siddiqi
Sent: Tuesday, March 13, 2012 3:03 PM
To: arslist@ARSLIST.ORG
Subject: Re: Web Service GetList issue

** This is what I get when I give 0. 

0 is not valid selection for Maximum Limit.,  5158, 
0 is not valid selection for Start Record.,  5158, 

Thanks, 
Wirasat Siddiqi 
Remedy Development Team 
Desk Phone: 202-502-3204 
Cell: 202-368-7190 
Email: wirasat_sidd...@ao.uscourts.gov 


-Original Message-
From:        Jose Huerta 
To:        arslist@ARSLIST.ORG 
Date:        03/13/2012 03:58 PM 
Subject:        Re: Web Service GetList issue 
Sent by:        "Action Request System discussion list(ARSList)" 
 


** I think that you must give a value. It isn't mandatory to publish these 
values at the input, but you need to provide a value for them. So put 0, 0 in 
order to not limit the response. 
Jose M. Huerta
Project Manager 
Movil: 661 665 088 
Telf.: 971 75 03 24 
Fax: 971 75 07 94 

SM2 Baleares S.A.
C/Rita Levi  
Edificio SM2 Parc Bit 
07121 Palma de Mallorca 


-Original Message-
On Tue, Mar 13, 2012 at 20:07, Wirasat Siddiqi wrote: 
** Hi all, 

I am having issue with a web service with Getlist operation. Created the web 
service with Getlist operation to search multiple rows on a form. Removed the 
startRecord and maxLimit from Input mapping as I don't want to use those 
limits. However, I am seeing these values under qualification field with no 
values entered. When I try to consume the web service, it does not return any 
data. 
Any help would be appreciated. 

Thanks, 
Wirasat 

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

Re: Web Service GetList issue

[Wirasat Siddiqi]

This is what I get when I give 0.

0 is not valid selection for Maximum Limit.,  5158, 
0 is not valid selection for Start Record.,  5158, 

Thanks,
Wirasat Siddiqi
Remedy Development Team
Desk Phone: 202-502-3204
Cell: 202-368-7190
Email: wirasat_sidd...@ao.uscourts.gov



From:   Jose Huerta 
To: arslist@ARSLIST.ORG
Date:   03/13/2012 03:58 PM
Subject:Re: Web Service GetList issue
Sent by:"Action Request System discussion list(ARSList)" 




** I think that you must give a value. It isn't mandatory to publish these 
values at the input, but you need to provide a value for them. So put 0, 0 
in order to not limit the response.

Jose M. Huerta
Project Manager
Movil: 661 665 088
Telf.: 971 75 03 24
Fax: 971 75 07 94

SM2 Baleares S.A.
C/Rita Levi 
Edificio SM2 Parc Bit
07121 Palma de Mallorca
 
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 Tue, Mar 13, 2012 at 20:07, Wirasat Siddiqi <
wirasat_sidd...@ao.uscourts.gov> wrote:
** Hi all, 

I am having issue with a web service with Getlist operation. Created the 
web service with Getlist operation to search multiple rows on a form. 
Removed the startRecord and maxLimit from Input mapping as I don't want to 
use those limits. However, I am seeing these values under qualification 
field with no values entered. When I try to consume the web service, it 
does not return any data. 
Any help would be appreciated. 

Thanks, 
Wirasat 

_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: Web Service GetList issue

[Jose Huerta]

I think that you must give a value. It isn't mandatory to publish these
values at the input, but you need to provide a value for them. So put 0, 0
in order to not limit the response.

 Jose M. Huerta
Project Manager**

Movil: 661 665 088

Telf.: 971 75 03 24

Fax: 971 75 07 94

 

SM2 Baleares S.A.
C/Rita Levi 

Edificio SM2 Parc Bit

07121 Palma de Mallorca

  
  
 

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 Tue, Mar 13, 2012 at 20:07, Wirasat Siddiqi <
wirasat_sidd...@ao.uscourts.gov> wrote:

> ** Hi all,
>
> I am having issue with a web service with Getlist operation. Created the
> web service with Getlist operation to search multiple rows on a form.
> Removed the startRecord and maxLimit from Input mapping as I don't want to
> use those limits. However, I am seeing these values under qualification
> field with no values entered. When I try to consume the web service, it
> does not return any data.
> Any help would be appreciated.
>
> Thanks,
> Wirasat
>
> _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"
<><><><>

Web Service GetList issue

[Wirasat Siddiqi]

Hi all,

I am having issue with a web service with Getlist operation. Created the 
web service with Getlist operation to search multiple rows on a form. 
Removed the startRecord and maxLimit from Input mapping as I don't want to 
use those limits. However, I am seeing these values under qualification 
field with no values entered. When I try to consume the web service, it 
does not return any data.
Any help would be appreciated.

Thanks,
Wirasat


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

Re: Report error on web report drill-down

[Joe Martin D'Souza]

Its an assumption at this point that it may not be the issue. I forgot to 
mention that it could perhaps be renamed too. From the description of your 
environment, it is unlikely that these may be the issues. No experienced 
Remedy developer would delete or rename an already deployed form - but 
accidents can happen.. That’s a unforgivable crime in our world when it 
happens :-)


Maybe you could use Ben Cherny's Meta-Update tool to perform a comparison 
with what you have on your server, to what's usually available OTB as he has 
a spreadsheet with all OTB forms documented. He was just discussing that on 
another thread "ITSM 7.6.03 OTB forms that begin with CTM:Ppl% or CTM:PPL%" 
that I had started... Not everything missing from the difference you see may 
mean a problem as some of the differences could be because of the components 
you have installed, opposed to those that were installed when that 
spreadsheet was generated. Also the patch you are on would also make a 
difference..


In the end, flushing the cache should resolve the problem..

Joe


-Original Message- 
From: Kay Wilthew
Sent: Tuesday, March 13, 2012 2:00 PM Newsgroups: 
public.remedy.arsystem.general

To: arslist@ARSLIST.ORG
Subject: Re: Report error on web report drill-down

Thanks for the suggestion, Joe.  Your comment makes me question how a form 
could have been deleted when we're using an out of the box Remedy build, and 
there has never been any development performed.  I am the only administrator 
and I've never done any development on our system.  Is there a way to 
identify which form is missing, and is it really possible for a form to have 
been deleted?


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza

Sent: Monday, March 12, 2012 3:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: Report error on web report drill-down

Try flushing the Mid-Tier cache. My hunch is you may have deleted the 
original form that table field was pointing to, and created a new form, to 
point it to.


Even if that is not the case, refreshing your Mid-Tier cache would never 
hurt.


Cheers

Joe

-Original Message-
From: Kay W
Sent: Monday, March 12, 2012 3:01 PM Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Report error on web report drill-down

When running a web report, the report generates fine but when clicking on 
the hyperlink to drill down to a specific record in the report, Internet 
Explorer 8 is generating an error that the page cannot be found.  This is a 
simple web report created within Reports Console of an out-of-box 
installation of Remedy 7.6.04.


Any trouble-shooting advice?

Thanks,
Kay 


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

Re: AR Server 7.6.04 patch 3 Installer and Reflection X Manager

[Walters, Mark]

Does your desktop have multiple monitors?  Whenever I do this the X window 
always seems to open on one of the non-visible( via RDP) monitors, although the 
X session appears on the taskbar, and so I have to alt+spacebar to get the 
window menu and Move it back to the main screen so that I can see it.  

Mark

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Pruitt, Christopher (Bank of America 
Account)
Sent: 13 March 2012 17:48
To: arslist@ARSLIST.ORG
Subject: AR Server 7.6.04 patch 3 Installer and Reflection X Manager

I am at a loss here and was hoping someone on the list has encountered this 
issue.

I am trying to do a AR Server upgrade on a SUN UNIX server. I can start an 
xterm session using the Reflection X Manager and do an export DISPLAY=IP 
Address and start the AR Server 7.6.03 installer and it will bring up the 
installer on my desktop display. This works great when I am directly logged 
onto my desktop. 

However, the issue I am having is when I am using Remove Desktop Connection 
(RDC) connected remotely to my desktop and perform that same steps to export 
the DISPLAY to my IP Address of my desktop it will not display the AR Server 
7.6.03 installer. Is there some setting or trick I am missing to let me see the 
AR Server 7.6.03 installer when I am using RDC into my desktop? I have gone 
through all the settings on the Reflection X Manager and nothing is obvious 
that I need to set to make the AR Server 7.6.03 installer display when using 
RDC.

Reflection X Manager version 14.1.0
AR Server 7.6.04 patch 3 Installer
SUN OS 5.9


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


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

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend 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: Question: oracle clob in a row scenario

[patrick zandi]

no rows selected: so it worked..

Ya know.. I believe All I did was timeout..
I killed the sqplus, went to another sqlplus session, did it again.. and in
15 min it returned..
ran what you sent below .. working.. so I really do not know how long it
too..

I am doing 1 more test on this.. it should give me some real numbers..

On Tue, Mar 13, 2012 at 1:57 PM, Axton  wrote:

> If you ran and you want to confirm, take a look in the oracle data
> dictionary to see the state of the lob storage parameter for each
> column.
>
> select table_name || '.' || column_name as "column"
> from user_lobs
> where in_row = 'NO'
> /
>
> The integrity of the data will be fine, but if the alter table
> statement takes 10 minutes to complete for a given column and some
> other sql (from the arserver) tries to perform and update on that
> column while the alter table is running, arserver only waits so long
> for the database to response (5 minutes I think).  If you hit that
> threshold, arserverd will throw and error that the database is not
> responding.
>
> It is not unreasonable to assume that some of the alter table
> statements will take a long time (more than 5 minutes) to run if the
> total time of the alterations is 24 hours.
>
> Other things can/will slow down your conversion as well, such as backups.
>
> Also, the redo space required for the conversion will need to be rather
> large.
>
> The script you are using may not be as efficient as it could be.
> These hints/changes can make a big difference in the execution time:
> - parallel hint
> - nologging (don't generate redo logs)
> - direct-path INSERT (bypass the buffer cache)
>
> I don't know how you are doing the conversion, but each of the things
> above are worth looking into.
>
> Axton Grams
>
> On Tue, Mar 13, 2012 at 11:30 AM, patrick zandi 
> wrote:
> > ** I know some of the Alter commands are Implicit commits.. so I think
> the
> > data is ok..
> >
> > On Tue, Mar 13, 2012 at 12:26 PM, patrick zandi 
> wrote:
> >>
> >> Actually,, this is what I was wondering...
> >> so do I run the whole job again, or is there some way to run this
> somehow
> >> that I know it will finish..
> >>
> >> I thought about running this from an escalation, then I thought better..
> >> an escalation thread running for 3 days.. this is probably  a bad
> idea...
> >> ROFL..
> >>
> >>
> >>
> >> On Tue, Mar 13, 2012 at 11:35 AM, Axton  wrote:
> >>>
> >>> You may run into timeouts if a table is locked for a long enough
> >>> period of time and workflow, or a user, try to update a record in that
> >>> table.  The same problems that apply to oracle errors in general apply
> >>> to this scenario.
> >>>
> >>> Axton Grams
> >>>
> >>> On Tue, Mar 13, 2012 at 10:34 AM, patrick zandi 
> >>> wrote:
> >>> > ** That is what I want..
> >>> >
> >>> > On Tue, Mar 13, 2012 at 10:44 AM, Misi Mladoniczky 
> wrote:
> >>> >>
> >>> >> Hi,
> >>> >>
> >>> >> You should see a significant size reduction as well as performance
> >>> >> improvement on inserts/updates :-)
> >>> >>
> >>> >> The size was reduced to less than half in the system I was working
> on,
> >>> >> and
> >>> >> the bulk of the data left was actually attachments.
> >>> >>
> >>> >>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.
> >>> >>
> >>> >> > I think I have around 120 Gig of LOB, that is going from out to
> in..
> >>> >> > I need to put in row, it is getting out of control..
> >>> >> >
> >>> >> > On Tue, Mar 13, 2012 at 9:45 AM, Misi Mladoniczky 
> >>> >> > wrote:
> >>> >> >
> >>> >> >> Hi,
> >>> >> >>
> >>> >> >> I have done that a couple of times without any real problems. It
> >>> >> >> did
> >>> >> >> take
> >>> >> >> a lot less than 24 hours though, so these systems were probably
> >>> >> >> much
> >>> >> >> smaller. About 10-15GB if I remember right, and much bigger with
> >>> >> >> out-row
> >>> >> >> storage.
> >>> >> >>
> >>> >> >>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.
> >>> >> >>
> >>> >> >> > Hey all ,
> >>> >> >> > Odd question, from a person who is not normal.. which is
> normal..
> >>> >> >> > lol
> >>> >> >> >
> >>> >> >> > If you have a production system and you are taking an existing
> >>> >> >> > system
> >>> >> >> that
> >>> >>

Re: AR Server 7.6.04 patch 3 Installer and Reflection X Manager

[Grooms, Frederick W]

I have seen issues with xWindows windows and RDC (it actually displays on the 
PC but RDC does not send that window across because the xWindows app is running 
in the console session and RDP is actually a new user login in another session).

Try connecting to your PC thru RDC in a console session 
   mstsc.exe /console (or mstsc.exe /admin)

or alternatively set the DISPLAY environment to the second session  
DISPLAY=IP:1.0
   (You can see what sessions there are by running qwinsta in a dos window on 
the PC)


Fred


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Pruitt, Christopher (Bank of America 
Account)
Sent: Tuesday, March 13, 2012 12:48 PM
To: arslist@ARSLIST.ORG
Subject: AR Server 7.6.04 patch 3 Installer and Reflection X Manager

I am at a loss here and was hoping someone on the list has encountered this 
issue.

I am trying to do a AR Server upgrade on a SUN UNIX server. I can start an 
xterm session using the Reflection X Manager and do an export DISPLAY=IP 
Address and start the AR Server 7.6.03 installer and it will bring up the 
installer on my desktop display. This works great when I am directly logged 
onto my desktop. 

However, the issue I am having is when I am using Remove Desktop Connection 
(RDC) connected remotely to my desktop and perform that same steps to export 
the DISPLAY to my IP Address of my desktop it will not display the AR Server 
7.6.03 installer. Is there some setting or trick I am missing to let me see the 
AR Server 7.6.03 installer when I am using RDC into my desktop? I have gone 
through all the settings on the Reflection X Manager and nothing is obvious 
that I need to set to make the AR Server 7.6.03 installer display when using 
RDC.

Reflection X Manager version 14.1.0
AR Server 7.6.04 patch 3 Installer
SUN OS 5.9


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


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

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend 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: Report error on web report drill-down

[Kay Wilthew]

Thanks for the suggestion, Joe.  Your comment makes me question how a form 
could have been deleted when we're using an out of the box Remedy build, and 
there has never been any development performed.  I am the only administrator 
and I've never done any development on our system.  Is there a way to identify 
which form is missing, and is it really possible for a form to have been 
deleted?

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza
Sent: Monday, March 12, 2012 3:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: Report error on web report drill-down

Try flushing the Mid-Tier cache. My hunch is you may have deleted the original 
form that table field was pointing to, and created a new form, to point it to.

Even if that is not the case, refreshing your Mid-Tier cache would never hurt.

Cheers

Joe

-Original Message-
From: Kay W
Sent: Monday, March 12, 2012 3:01 PM Newsgroups: 
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Report error on web report drill-down

When running a web report, the report generates fine but when clicking on the 
hyperlink to drill down to a specific record in the report, Internet Explorer 8 
is generating an error that the page cannot be found.  This is a simple web 
report created within Reports Console of an out-of-box installation of Remedy 
7.6.04.

Any trouble-shooting advice?

Thanks,
Kay 

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


Your Comments: Peckham is committed to delivering the highest levels of 
customer service. Your comments help us to reach this goal. If you would like 
to provide feedback, please email our continuous improvement team at 
comme...@peckham.org . Thank you for the opportunity to serve you better.
CONFIDENTIALITY: The information contained in this electronic mail message and 
any attachments is intended only for the use of the individual or entity to 
whom it is addressed and may contain legally privileged, confidential 
information or work product. If the reader of this message is not the intended 
recipient, you are hereby notified that any use, dissemination, distribution, 
or forwarding of this email message is strictly prohibited. If you have 
received this message in error, please notify confidential...@peckham.org 
immediately and delete the original message from your system.



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

Re: Question: oracle clob in a row scenario

[Axton]

If you ran and you want to confirm, take a look in the oracle data
dictionary to see the state of the lob storage parameter for each
column.

select table_name || '.' || column_name as "column"
from user_lobs
where in_row = 'NO'
/

The integrity of the data will be fine, but if the alter table
statement takes 10 minutes to complete for a given column and some
other sql (from the arserver) tries to perform and update on that
column while the alter table is running, arserver only waits so long
for the database to response (5 minutes I think).  If you hit that
threshold, arserverd will throw and error that the database is not
responding.

It is not unreasonable to assume that some of the alter table
statements will take a long time (more than 5 minutes) to run if the
total time of the alterations is 24 hours.

Other things can/will slow down your conversion as well, such as backups.

Also, the redo space required for the conversion will need to be rather large.

The script you are using may not be as efficient as it could be.
These hints/changes can make a big difference in the execution time:
- parallel hint
- nologging (don't generate redo logs)
- direct-path INSERT (bypass the buffer cache)

I don't know how you are doing the conversion, but each of the things
above are worth looking into.

Axton Grams

On Tue, Mar 13, 2012 at 11:30 AM, patrick zandi  wrote:
> ** I know some of the Alter commands are Implicit commits.. so I think the
> data is ok..
>
> On Tue, Mar 13, 2012 at 12:26 PM, patrick zandi  wrote:
>>
>> Actually,, this is what I was wondering...
>> so do I run the whole job again, or is there some way to run this somehow
>> that I know it will finish..
>>
>> I thought about running this from an escalation, then I thought better..
>> an escalation thread running for 3 days.. this is probably  a bad idea...
>> ROFL..
>>
>>
>>
>> On Tue, Mar 13, 2012 at 11:35 AM, Axton  wrote:
>>>
>>> You may run into timeouts if a table is locked for a long enough
>>> period of time and workflow, or a user, try to update a record in that
>>> table.  The same problems that apply to oracle errors in general apply
>>> to this scenario.
>>>
>>> Axton Grams
>>>
>>> On Tue, Mar 13, 2012 at 10:34 AM, patrick zandi 
>>> wrote:
>>> > ** That is what I want..
>>> >
>>> > On Tue, Mar 13, 2012 at 10:44 AM, Misi Mladoniczky  wrote:
>>> >>
>>> >> Hi,
>>> >>
>>> >> You should see a significant size reduction as well as performance
>>> >> improvement on inserts/updates :-)
>>> >>
>>> >> The size was reduced to less than half in the system I was working on,
>>> >> and
>>> >> the bulk of the data left was actually attachments.
>>> >>
>>> >>        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.
>>> >>
>>> >> > I think I have around 120 Gig of LOB, that is going from out to in..
>>> >> > I need to put in row, it is getting out of control..
>>> >> >
>>> >> > On Tue, Mar 13, 2012 at 9:45 AM, Misi Mladoniczky 
>>> >> > wrote:
>>> >> >
>>> >> >> Hi,
>>> >> >>
>>> >> >> I have done that a couple of times without any real problems. It
>>> >> >> did
>>> >> >> take
>>> >> >> a lot less than 24 hours though, so these systems were probably
>>> >> >> much
>>> >> >> smaller. About 10-15GB if I remember right, and much bigger with
>>> >> >> out-row
>>> >> >> storage.
>>> >> >>
>>> >> >>        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.
>>> >> >>
>>> >> >> > Hey all ,
>>> >> >> > Odd question, from a person who is not normal.. which is normal..
>>> >> >> > lol
>>> >> >> >
>>> >> >> > If you have a production system and you are taking an existing
>>> >> >> > system
>>> >> >> that
>>> >> >> > is up and running online
>>> >> >> > and you do the modify all the lob's from out-row to in-row
>>> >> >> > is there any issues with doing this while everyone is using it ?
>>> >> >> >
>>> >> >> > I see nothing obviously stated that you should not run this while
>>> >> >> doing
>>> >> >> > audits, or anything..
>>> >> >> > Does Oracle take care of that scenario, while moving from one way
>>> >> >> > to
>>> >> >> the
>>> >> >> > other..
>>> >> >> >
>>> >> >> > I did one system that took almost 24 hours.. This is why I am
>>> >> >> asking...
>>> >> >> >
>>> >> >> > thanks..
>>> >> >> >
>>> >> >> > --
>>> >> >> > Patrick Zand

Re: AR Server 7.6.04 patch 3 Installer and Reflection X Manager

[patrick zandi]

ok, this I know..
if you are logging in as the same person installing it.. it should display
back, however if you are installing as root, after logging in, you need to
set the enviorment to ensure it knows where to go..

So ..
Login as joesmith (sorry joe, to use your name again)
env |grep -i display
>> DISPLAY=localhost:10.0
su - >> to get to root
export DISPLAY=localhost:10.0
export HOME=~joesmith

run command..

Now you have to make sure your application is allowing X to come back to
the desktop and is authorized to display back..

Hope that helps..


On Tue, Mar 13, 2012 at 1:48 PM, Pruitt, Christopher (Bank of America
Account)  wrote:

> I am at a loss here and was hoping someone on the list has encountered
> this issue.
>
> I am trying to do a AR Server upgrade on a SUN UNIX server. I can start an
> xterm session using the Reflection X Manager and do an export DISPLAY=IP
> Address and start the AR Server 7.6.03 installer and it will bring up the
> installer on my desktop display. This works great when I am directly logged
> onto my desktop.
>
> However, the issue I am having is when I am using Remove Desktop
> Connection (RDC) connected remotely to my desktop and perform that same
> steps to export the DISPLAY to my IP Address of my desktop it will not
> display the AR Server 7.6.03 installer. Is there some setting or trick I am
> missing to let me see the AR Server 7.6.03 installer when I am using RDC
> into my desktop? I have gone through all the settings on the Reflection X
> Manager and nothing is obvious that I need to set to make the AR Server
> 7.6.03 installer display when using RDC.
>
> Reflection X Manager version 14.1.0
> AR Server 7.6.04 patch 3 Installer
> SUN OS 5.9
>
>
> Christopher Pruitt
> Business Consulting III
> HP Enterprises Services
> christopher.pru...@hp.com
> www.hp.com
>
>
> Confidentiality Notice: This message and any files transmitted with it are
> intended for the sole use of the entity or individual to whom it is
> addressed, and may contain information that is confidential, privileged,
> and exempt from disclosure under applicable law. If you are not the
> intended addressee for this e-mail, you are hereby notified that any
> copying, distribution, or dissemination of this e-mail is strictly
> prohibited. If you have received this e-mail in error, please immediately
> destroy, erase, or discard this message. Please notify the sender
> immediately by return e-mail if you have received this e-mail by mistake.
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>



-- 
Patrick Zandi

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

AR Server 7.6.04 patch 3 Installer and Reflection X Manager

[Pruitt, Christopher (Bank of America Account)]

I am at a loss here and was hoping someone on the list has encountered this 
issue.

I am trying to do a AR Server upgrade on a SUN UNIX server. I can start an 
xterm session using the Reflection X Manager and do an export DISPLAY=IP 
Address and start the AR Server 7.6.03 installer and it will bring up the 
installer on my desktop display. This works great when I am directly logged 
onto my desktop. 

However, the issue I am having is when I am using Remove Desktop Connection 
(RDC) connected remotely to my desktop and perform that same steps to export 
the DISPLAY to my IP Address of my desktop it will not display the AR Server 
7.6.03 installer. Is there some setting or trick I am missing to let me see the 
AR Server 7.6.03 installer when I am using RDC into my desktop? I have gone 
through all the settings on the Reflection X Manager and nothing is obvious 
that I need to set to make the AR Server 7.6.03 installer display when using 
RDC.

Reflection X Manager version 14.1.0
AR Server 7.6.04 patch 3 Installer
SUN OS 5.9


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


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

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

Re: Remedy 7.6.04 - BRIE Timeouts

[Axton]

Check the server statistics too.  Your queue/thread configuration
appears to be sufficient for some load, but the queue blocked items in
the server stats will confirm that it's enough.  I've been practicing
setting the minimum threads to 1 and the max to wherever it needs to
be.  This lets the arserver create new threads for each pool as
needed.  The exercise of trying to allocate a thread from a pool and
creating a new one if all the threads are occupied is relatively
simple and the arserver seems to have implemented it well, so setting
a minimum of 1 and letting the server drive the thread count saves
resources where it can.  The only exception is the escalation queue,
which needs the min threads defined at a value greater than 1.

There are 4 servers total.  Am I correct in assuming that all servers
are in a server group, and all but the admin server are behind a load
balancer?  I am still curious about the following things, to complete
the picture:
- server group ranking
- rpc program used by each subsystem (e.g., 390621 is used by the
approval server; 390624 is used by the mid-tier, etc.)
- the server statistics queue blocked count
- With this server count, I am curious if the hanging occurs on all
servers or just one server at a time

Do keep in mind that cache operations can wreak havoc on your servers,
because they are all in a server group together.

Regards,
Axton Grams

On Tue, Mar 13, 2012 at 11:45 AM, Chris Wilson
 wrote:
> ** Hello,
>
> Here is the thread/queue information for our 7.6.04 SP2 application server
> environment:
>
> Admin Server:
>
> Private-RPC-Socket:  390601   1   1
> Private-RPC-Socket:  390603   1   4      (Escalations)
> Private-RPC-Socket:  390620  12  20   (Fast)
> Private-RPC-Socket:  390621   2  20
> Private-RPC-Socket:  390626   2   5
> Private-RPC-Socket:  390635  18  20   (List)
> Private-RPC-Socket:  390680   1   4     (Approvals)
> Plugin-Loopback-RPC-Socket: 390626
> Approval-RPC-Socket: 390680
> External-Authentication-RPC-Socket: 390695
>
>
> AR Server 1:
>
> Private-RPC-Socket:  390601   1   1
> Private-RPC-Socket:  390603   1   1     (Escalations)
> Private-RPC-Socket:  390620   4  10    (Fast)
> Private-RPC-Socket:  390621   2   8
> Private-RPC-Socket:  390626   2   5
> Private-RPC-Socket:  390635   4  12    (List)
> Private-RPC-Socket:  390680   1   4     (Approvals)
> Plugin-Loopback-RPC-Socket: 390626
> Approval-RPC-Socket: 390680
> External-Authentication-RPC-Socket: 390695
>
>
> AR Server 2:
>
> Private-RPC-Socket:  390601   1   1
> Private-RPC-Socket:  390603   1   1     (Escalations)
> Private-RPC-Socket:  390620   4  10    (Fast)
> Private-RPC-Socket:  390621   2   8
> Private-RPC-Socket:  390626   2   5
> Private-RPC-Socket:  390635   4  12    (List)
> Private-RPC-Socket:  390680   1   4     (Approvals)
> Plugin-Loopback-RPC-Socket: 390626
> Approval-RPC-Socket: 390680
> External-Authentication-RPC-Socket: 390695
>
>
> AR Server 3:
>
> Private-RPC-Socket:  390601   1   1
> Private-RPC-Socket:  390603   1   1     (Escalations)
> Private-RPC-Socket:  390620   4  10    (Fast)
> Private-RPC-Socket:  390621   2   8
> Private-RPC-Socket:  390626   2   5
> Private-RPC-Socket:  390635   4  12    (List)
> Private-RPC-Socket:  390680   1   4     (Approvals)
> Plugin-Loopback-RPC-Socket: 390626
> Approval-RPC-Socket: 390680
> External-Authentication-RPC-Socket: 390695
>
> Application Server Specifications:
>
> Virtual Server
> Windows 2008 Enterprise Server R2 64-bit
> (6) Intel Xeon X5650 2.67 Ghz Virtual CPUs
> 16 GB of RAM
>
> Thanks,
>
> Chris
>
>
>
>
>
> From:        Axton 
> To:        arslist@ARSLIST.ORG
> Date:        03/12/2012 03:17 PM
> Subject:        Re: Remedy 7.6.04 - BRIE Timeouts
> Sent by:        "Action Request System discussion list(ARSList)"
> 
>
> 
>
>
>
> Turn on cumulative and individual queue server statistics collection
> on the servers.  Look for queue blocked items in the recorded
> statistics.  What is your queue/thread configuration on arserver and
> what subsystems use which queues?
>
> Axton Grams
>
> On Mon, Mar 12, 2012 at 2:34 PM, Chris Wilson
>  wrote:
>> We are implementing new 7.6.04 SP2 environments and we seem to experience
>> BRIE timeouts sporatically on our ARS servers. The timeouts seem to be
>> triggered by user activity, however, it does not take much activity to
>> activate the timeouts. When timeouts are experieced, current users
>> experience an hourglass and new users cannot login. Once the timeouts start,
>> we must recycle the application server(s) experiencing the issue to restore
>> service. We are experiencing this issue in our DEV, QA and PROD 7.6.04
>> environments. Anyone else experiencing this issue? We are also running ARS
>> 7.5 Patch 6 with no timeout issues.
>>
>> Thanks,
>>
>> Chris Wilson
>>
>>
>> ___
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> attend wwrug12 www.wwrug12.

Re: Mid-Tier Caching Endeavors

[strauss]

I'd be curious to know what you see with this in SP3, since as near as I can 
tell it made significant changes to how the mid-tier ehcache handles users and 
groups, and changed prefetch from push to pull.

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

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Tuesday, March 13, 2012 8:30 AM
To: arslist@ARSLIST.ORG
Subject: Mid-Tier Caching Endeavors

Hi all Mid-Tier Admins!

I have had a series of frustrating issues with Mid-Tier 7.6.04 SP2 caching, 
that I think I have now come to grips with.

What I did was to create a Group (STUGUN) and a Role (STUGUN) to be used in 
customization of the application "Remedy Incident Management". The role granted 
access to a set of ACTLs.

What happened was that Mid-Tier failed to recache things sometimes, and some 
users with this group (STUGUN) got access to the ACTLs, and some did not.

The same user could get different results depending on which Mid-Tier he 
accessed.

My error, I think, is that the STUGUN-Group was set defined as a None-Group.

As it was mapped to a Role, it worked fine to assign permission to it, and it 
also worked fine in Remedy User.

When Mid-Tier does its caching, it will create a unique Group-combination based 
on each users unique combination of Groups.

For example if a user belongs to:

20213 => Service Request User (Change)

10001 => STUGUN (None, this is my group)

20003 => Incident User (Change)

2 => General Access (Change)

20032 => Asset Viewer (Change)

100021 => 100021 (None) - this is a Support Group

The Unique combination here will be ";2;20003;20032;20213;" where the two 
groups with Group-Type "None" has been stripped out.

This is because None-groups should not be able to change access in any way, 
except for row-level-access, but that is calculated in another way.

So depending on if the first User with the unique permission map 
";2;20003;20032;20213;" belonged to my STUGUN-group or not, the cached file 
included/excluded permission to thos STUGUN-Active-Links!

SOLUTION: Change the None-Group to View or Change

CONCLUSION: Never map a None-Group to a Role

Please let me know if my deductions seems flawed in any way!

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.

___
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"

Job Senior Programmer Analyst (ICS) Orlando Utilities Commission Orlando, Florida 32802

[Sharyl Augustitus - Agile1]

Please send resumes to saugusti...@agile1.com
 

 

Senior Programmer Analyst (ICS)

Orlando Utilities Commission

Orlando, Florida 32802

Dept:  IT/Integrated & Customer Systems

 

NATURE OF WORK:

 

To provide Information Technology support and solutions for all
application systems and for all areas of the Commission.  The Senior
Programmer Analyst serves as a companywide resource for projects
involving Information Technology.  The Senior Programmer Analyst is
responsible for designing, developing, and maintaining software
integration solutions using the Software AG webMethods Integration
Platform when applicable.  Responsible for maintaining the webMethods
Integration Platform system's integrity, availability, accessibility,
security and current patch levels. Install and maintain software
packages purchased by OUC. Responsible for administering existing
production & non-production environments.

 

 

BASIC JOB DUTIES:

  As a Sr. Programmer Analyst, you will be responsible for the
following:

 

*Perform software development duties as part of a team

*Thorough analysis, specifications and application design

*All forms of testing inclusive of unit, integration, system and
user acceptance with proper documentation

*Coordinate and work with internal and external team members to
understand technical and functional requirements and identify and
resolve issues and risks.

*Provide technical guidance to junior developers.

*Provide second tier on call support in the event there are
production outages during and after business hours

*Projects include the development and implementation of automated
systems, back-office systems, integration middleware, web services, web
development.

*Install and maintain software packages purchased by OUC.

*Coordinate the implementation and completion of recommended
specifications for all new systems, system changes, and problem
correction.

*Deploy developed software projects through the different stages
such as test, user acceptance, and production environments.

*Responsibilities including; installing, configuring, supporting,
maintaining, administering, and documenting the webMethods environments

*Identify problems, troubleshooting, and solution implementation in
a production environment.

*Develop and demonstrate a good understanding and use of monitoring
tools and webMethods Administration Consoles.

*Monitor the application health using monitoring tools and custom
procedures.

*Monitor alerts thrown by the applications via monitoring alerts and
take appropriate action

*Develop and demonstrate a good understanding of the Change
Management process.

*Prepare unit test data, test and debug webMethods solutions

*Deploy the software release using webMethods Deployer and
appropriate tools.

*Interact with software, network, database, and Unix administrators
to seamlessly implement solutions to complex technical issues

*Participate in incident management and problem management
discussions and support incident manager in submitting root cause
analysis reports and to resolve application issues.

*Working with various multiple application teams, application
developers, adapting SOA and Middle-Tier standards.

*Implementing security policies.

*Will be expected to follow web services standards and provide
intelligent and experienced feedback on standards improvements

*Must be able to communicate clearly with UML diagrams and data flow
patterns

*Provide detailed time estimates of the work to be done and regular
progress updates as required to the Team Leader and/or Project Manager

*Perform other related duties as directed

 

REQUIREMENTS:

 

*   B.S. in Computer Science or related field. Minimum seven (7)
years software development experience (in multiple environments)
employing formal software development methodologies. 
*   Experience and understanding of network devices within a DMZ and
corporate architecture that includes load balancers, firewalls and XML
Gateways 
*   Experience with relational databases (Oracle and SQL Server
required) and client/server environment (HP Unix and MS Windows 2008
Server). 
*   Strong knowledge of integration technologies including but not
limited to HTML, ASP, .NET, JAVA, EJB, J2EE, XSLT, XML, JMS, ODBC, JDBC,
JNDI, SOAP, Web Services, WSDL, and WS-* specifications, UML diagrams 
*   2+ Years developing integration solutions with the Software AG
webMethods Integration Platform version 7.x and greater including
Integration Server, Broker, Deployer, and My WebMethods Server (Portal)
and Developer/Designer. 
*   Experience is designing of an enterprise canonical message
models and object oriented design 
*   Experience in enterprise messaging and integration design,
analysis, and development techniques using the Software AG webMethods
Integration Platform. 
*   Must 

Re: Remedy 7.6.04 - BRIE Timeouts

[Chris Wilson]

Hello,

Here is the thread/queue information for our 7.6.04 SP2 application server 
environment:

Admin Server:

Private-RPC-Socket:  390601   1   1 
Private-RPC-Socket:  390603   1   4  (Escalations)
Private-RPC-Socket:  390620  12  20   (Fast)
Private-RPC-Socket:  390621   2  20 
Private-RPC-Socket:  390626   2   5 
Private-RPC-Socket:  390635  18  20   (List)
Private-RPC-Socket:  390680   1   4 (Approvals)
Plugin-Loopback-RPC-Socket: 390626
Approval-RPC-Socket: 390680
External-Authentication-RPC-Socket: 390695


AR Server 1:

Private-RPC-Socket:  390601   1   1 
Private-RPC-Socket:  390603   1   1 (Escalations)
Private-RPC-Socket:  390620   4  10(Fast)
Private-RPC-Socket:  390621   2   8
Private-RPC-Socket:  390626   2   5 
Private-RPC-Socket:  390635   4  12(List)
Private-RPC-Socket:  390680   1   4 (Approvals)
Plugin-Loopback-RPC-Socket: 390626
Approval-RPC-Socket: 390680
External-Authentication-RPC-Socket: 390695


AR Server 2:

Private-RPC-Socket:  390601   1   1 
Private-RPC-Socket:  390603   1   1 (Escalations)
Private-RPC-Socket:  390620   4  10(Fast)
Private-RPC-Socket:  390621   2   8
Private-RPC-Socket:  390626   2   5 
Private-RPC-Socket:  390635   4  12(List)
Private-RPC-Socket:  390680   1   4 (Approvals)
Plugin-Loopback-RPC-Socket: 390626
Approval-RPC-Socket: 390680
External-Authentication-RPC-Socket: 390695


AR Server 3:

Private-RPC-Socket:  390601   1   1 
Private-RPC-Socket:  390603   1   1 (Escalations)
Private-RPC-Socket:  390620   4  10(Fast)
Private-RPC-Socket:  390621   2   8
Private-RPC-Socket:  390626   2   5 
Private-RPC-Socket:  390635   4  12(List)
Private-RPC-Socket:  390680   1   4 (Approvals)
Plugin-Loopback-RPC-Socket: 390626
Approval-RPC-Socket: 390680
External-Authentication-RPC-Socket: 390695
Application Server Specifications:
Virtual Server
Windows 2008 Enterprise Server R2 64-bit
(6) Intel Xeon X5650 2.67 Ghz Virtual CPUs
16 GB of RAM
Thanks,
Chris
 



From:   Axton 
To: arslist@ARSLIST.ORG
Date:   03/12/2012 03:17 PM
Subject:Re: Remedy 7.6.04 - BRIE Timeouts
Sent by:"Action Request System discussion list(ARSList)" 




Turn on cumulative and individual queue server statistics collection
on the servers.  Look for queue blocked items in the recorded
statistics.  What is your queue/thread configuration on arserver and
what subsystems use which queues?

Axton Grams

On Mon, Mar 12, 2012 at 2:34 PM, Chris Wilson
 wrote:
> We are implementing new 7.6.04 SP2 environments and we seem to 
experience BRIE timeouts sporatically on our ARS servers. The timeouts 
seem to be triggered by user activity, however, it does not take much 
activity to activate the timeouts. When timeouts are experieced, current 
users experience an hourglass and new users cannot login. Once the 
timeouts start, we must recycle the application server(s) experiencing the 
issue to restore service. We are experiencing this issue in our DEV, QA 
and PROD 7.6.04 environments. Anyone else experiencing this issue? We are 
also running ARS 7.5 Patch 6 with no timeout issues.
>
> Thanks,
>
> Chris Wilson
>
> 
___
> 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: Question: oracle clob in a row scenario

[patrick zandi]

I know some of the Alter commands are Implicit commits.. so I think the
data is ok..

On Tue, Mar 13, 2012 at 12:26 PM, patrick zandi  wrote:

> Actually,, this is what I was wondering...
> so do I run the whole job again, or is there some way to run this somehow
> that I know it will finish..
>
> I thought about running this from an escalation, then I thought better..
> an escalation thread running for 3 days.. this is probably  a bad idea...
> ROFL..
>
>
>
> On Tue, Mar 13, 2012 at 11:35 AM, Axton  wrote:
>
>> You may run into timeouts if a table is locked for a long enough
>> period of time and workflow, or a user, try to update a record in that
>> table.  The same problems that apply to oracle errors in general apply
>> to this scenario.
>>
>> Axton Grams
>>
>> On Tue, Mar 13, 2012 at 10:34 AM, patrick zandi 
>> wrote:
>> > ** That is what I want..
>> >
>> > On Tue, Mar 13, 2012 at 10:44 AM, Misi Mladoniczky  wrote:
>> >>
>> >> Hi,
>> >>
>> >> You should see a significant size reduction as well as performance
>> >> improvement on inserts/updates :-)
>> >>
>> >> The size was reduced to less than half in the system I was working on,
>> and
>> >> the bulk of the data left was actually attachments.
>> >>
>> >>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.
>> >>
>> >> > I think I have around 120 Gig of LOB, that is going from out to in..
>> >> > I need to put in row, it is getting out of control..
>> >> >
>> >> > On Tue, Mar 13, 2012 at 9:45 AM, Misi Mladoniczky 
>> wrote:
>> >> >
>> >> >> Hi,
>> >> >>
>> >> >> I have done that a couple of times without any real problems. It did
>> >> >> take
>> >> >> a lot less than 24 hours though, so these systems were probably much
>> >> >> smaller. About 10-15GB if I remember right, and much bigger with
>> >> >> out-row
>> >> >> storage.
>> >> >>
>> >> >>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.
>> >> >>
>> >> >> > Hey all ,
>> >> >> > Odd question, from a person who is not normal.. which is normal..
>> lol
>> >> >> >
>> >> >> > If you have a production system and you are taking an existing
>> system
>> >> >> that
>> >> >> > is up and running online
>> >> >> > and you do the modify all the lob's from out-row to in-row
>> >> >> > is there any issues with doing this while everyone is using it ?
>> >> >> >
>> >> >> > I see nothing obviously stated that you should not run this while
>> >> >> doing
>> >> >> > audits, or anything..
>> >> >> > Does Oracle take care of that scenario, while moving from one way
>> to
>> >> >> the
>> >> >> > other..
>> >> >> >
>> >> >> > I did one system that took almost 24 hours.. This is why I am
>> >> >> asking...
>> >> >> >
>> >> >> > thanks..
>> >> >> >
>> >> >> > --
>> >> >> > Patrick Zandi
>> >> >> >
>> >> >> >
>> >> >>
>> >> >>
>> ___
>> >> >> > 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"
>> >> >>
>> >> >
>> >> >
>> >> >
>> >> > --
>> >> > Patrick Zandi
>> >> >
>> >> >
>> >> >
>> ___
>> >> > 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"
>> >
>> >
>> >
>> >
>> > --
>> > 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"
>>
>
>
>
> --
> Patrick Zandi
>



-- 
Patrick Zandi

_

Re: Question: oracle clob in a row scenario

[patrick zandi]

Actually,, this is what I was wondering...
so do I run the whole job again, or is there some way to run this somehow
that I know it will finish..

I thought about running this from an escalation, then I thought better.. an
escalation thread running for 3 days.. this is probably  a bad idea...
ROFL..


On Tue, Mar 13, 2012 at 11:35 AM, Axton  wrote:

> You may run into timeouts if a table is locked for a long enough
> period of time and workflow, or a user, try to update a record in that
> table.  The same problems that apply to oracle errors in general apply
> to this scenario.
>
> Axton Grams
>
> On Tue, Mar 13, 2012 at 10:34 AM, patrick zandi 
> wrote:
> > ** That is what I want..
> >
> > On Tue, Mar 13, 2012 at 10:44 AM, Misi Mladoniczky  wrote:
> >>
> >> Hi,
> >>
> >> You should see a significant size reduction as well as performance
> >> improvement on inserts/updates :-)
> >>
> >> The size was reduced to less than half in the system I was working on,
> and
> >> the bulk of the data left was actually attachments.
> >>
> >>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.
> >>
> >> > I think I have around 120 Gig of LOB, that is going from out to in..
> >> > I need to put in row, it is getting out of control..
> >> >
> >> > On Tue, Mar 13, 2012 at 9:45 AM, Misi Mladoniczky  wrote:
> >> >
> >> >> Hi,
> >> >>
> >> >> I have done that a couple of times without any real problems. It did
> >> >> take
> >> >> a lot less than 24 hours though, so these systems were probably much
> >> >> smaller. About 10-15GB if I remember right, and much bigger with
> >> >> out-row
> >> >> storage.
> >> >>
> >> >>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.
> >> >>
> >> >> > Hey all ,
> >> >> > Odd question, from a person who is not normal.. which is normal..
> lol
> >> >> >
> >> >> > If you have a production system and you are taking an existing
> system
> >> >> that
> >> >> > is up and running online
> >> >> > and you do the modify all the lob's from out-row to in-row
> >> >> > is there any issues with doing this while everyone is using it ?
> >> >> >
> >> >> > I see nothing obviously stated that you should not run this while
> >> >> doing
> >> >> > audits, or anything..
> >> >> > Does Oracle take care of that scenario, while moving from one way
> to
> >> >> the
> >> >> > other..
> >> >> >
> >> >> > I did one system that took almost 24 hours.. This is why I am
> >> >> asking...
> >> >> >
> >> >> > thanks..
> >> >> >
> >> >> > --
> >> >> > Patrick Zandi
> >> >> >
> >> >> >
> >> >>
> >> >>
> ___
> >> >> > 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"
> >> >>
> >> >
> >> >
> >> >
> >> > --
> >> > Patrick Zandi
> >> >
> >> >
> >> >
> ___
> >> > 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"
> >
> >
> >
> >
> > --
> > 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"
>



-- 
Patrick Zandi

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

Re: Question: oracle clob in a row scenario

[Axton]

You may run into timeouts if a table is locked for a long enough
period of time and workflow, or a user, try to update a record in that
table.  The same problems that apply to oracle errors in general apply
to this scenario.

Axton Grams

On Tue, Mar 13, 2012 at 10:34 AM, patrick zandi  wrote:
> ** That is what I want..
>
> On Tue, Mar 13, 2012 at 10:44 AM, Misi Mladoniczky  wrote:
>>
>> Hi,
>>
>> You should see a significant size reduction as well as performance
>> improvement on inserts/updates :-)
>>
>> The size was reduced to less than half in the system I was working on, and
>> the bulk of the data left was actually attachments.
>>
>>        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.
>>
>> > I think I have around 120 Gig of LOB, that is going from out to in..
>> > I need to put in row, it is getting out of control..
>> >
>> > On Tue, Mar 13, 2012 at 9:45 AM, Misi Mladoniczky  wrote:
>> >
>> >> Hi,
>> >>
>> >> I have done that a couple of times without any real problems. It did
>> >> take
>> >> a lot less than 24 hours though, so these systems were probably much
>> >> smaller. About 10-15GB if I remember right, and much bigger with
>> >> out-row
>> >> storage.
>> >>
>> >>        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.
>> >>
>> >> > Hey all ,
>> >> > Odd question, from a person who is not normal.. which is normal.. lol
>> >> >
>> >> > If you have a production system and you are taking an existing system
>> >> that
>> >> > is up and running online
>> >> > and you do the modify all the lob's from out-row to in-row
>> >> > is there any issues with doing this while everyone is using it ?
>> >> >
>> >> > I see nothing obviously stated that you should not run this while
>> >> doing
>> >> > audits, or anything..
>> >> > Does Oracle take care of that scenario, while moving from one way to
>> >> the
>> >> > other..
>> >> >
>> >> > I did one system that took almost 24 hours.. This is why I am
>> >> asking...
>> >> >
>> >> > thanks..
>> >> >
>> >> > --
>> >> > Patrick Zandi
>> >> >
>> >> >
>> >>
>> >> ___
>> >> > 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"
>> >>
>> >
>> >
>> >
>> > --
>> > Patrick Zandi
>> >
>> >
>> > ___
>> > 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"
>
>
>
>
> --
> 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"

Re: Question: oracle clob in a row scenario

[patrick zandi]

That is what I want..

On Tue, Mar 13, 2012 at 10:44 AM, Misi Mladoniczky  wrote:

> Hi,
>
> You should see a significant size reduction as well as performance
> improvement on inserts/updates :-)
>
> The size was reduced to less than half in the system I was working on, and
> the bulk of the data left was actually attachments.
>
>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.
>
> > I think I have around 120 Gig of LOB, that is going from out to in..
> > I need to put in row, it is getting out of control..
> >
> > On Tue, Mar 13, 2012 at 9:45 AM, Misi Mladoniczky  wrote:
> >
> >> Hi,
> >>
> >> I have done that a couple of times without any real problems. It did
> >> take
> >> a lot less than 24 hours though, so these systems were probably much
> >> smaller. About 10-15GB if I remember right, and much bigger with out-row
> >> storage.
> >>
> >>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.
> >>
> >> > Hey all ,
> >> > Odd question, from a person who is not normal.. which is normal.. lol
> >> >
> >> > If you have a production system and you are taking an existing system
> >> that
> >> > is up and running online
> >> > and you do the modify all the lob's from out-row to in-row
> >> > is there any issues with doing this while everyone is using it ?
> >> >
> >> > I see nothing obviously stated that you should not run this while
> >> doing
> >> > audits, or anything..
> >> > Does Oracle take care of that scenario, while moving from one way to
> >> the
> >> > other..
> >> >
> >> > I did one system that took almost 24 hours.. This is why I am
> >> asking...
> >> >
> >> > thanks..
> >> >
> >> > --
> >> > Patrick Zandi
> >> >
> >> >
> >>
> ___
> >> > 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"
> >>
> >
> >
> >
> > --
> > Patrick Zandi
> >
> >
> ___
> > 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"
>



-- 
Patrick Zandi

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

Re: Avoiding pop-ups while requiring input

[Joe Martin D'Souza]

Do not forget to disable the change flag on every field that gets a value 
(hidden field or otherwise), else the default form submit button will get 
enabled. It may also be a good idea to hide the form bar, so that button is not 
visible, in which case it is not necessary to turn off the change flag on 
fields...

Joe

From: David Durling 
Sent: Tuesday, March 13, 2012 9:35 AM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG 
Subject: Re: Avoiding pop-ups while requiring input

** 
Hi Ian,

 

The issue would be stopping things before I hit a submit or modify action, I 
think – because then the system will generate a pop-up (on 7.5).

 

So, like Joe suggested, I think I’ll try a custom submit/modify button and 
display the text/color like you mention if the needed fields are null.  This 
avoids any submit or modify action actually being initiated until the needed 
fields are filled in.  I guess I could even leave the fields as Required and do 
this.

 

Thanks guys,

David

 

David Durling

University of Georgia

 

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Ian Trimnell
Sent: Tuesday, March 13, 2012 1:42 AM
To: arslist@ARSLIST.ORG
Subject: Re: Avoiding pop-ups while requiring input

 

** 

David,

One way to avoid pop-ups could be as follows:

  a.. parse the form on submit and check if any of the required fields are 
blank 
  b.. if so, make a hidden warning text field visible saying something like 
"please enter required data" 
  c.. change the label colour on the fields that are required.
Would that fit the bill?

Ian



Ian Trimnell
Systems Programmer, Distributed Systems
Information Technology
Berrill Building, Level 1 North
Phone: 01908 6 53741   web: http://www.open.ac.uk/ 


On 12/03/2012 21:28, David Durling wrote: 

We're rolling out an app for staff that normally don't use Remedy, and a 
usability concern is browser pop-up blockers.   (I know the login page warns 
about pop-ups, but I've seen it ignored & I've done it myself.)  This is a 
rather detailed Remedy form, and if they get a pop-up & have to reload the 
page, the user input is lost. I took out "message" actions from my workflow to 
avoid this, but there are still Required fields:  if left blank, they use a 
pop-up box. Does anyone have a creative way for getting around this for 
required fields?  Maybe some trick where the fields are not really required on 
the database side, but not sure how ensure they are populated without using a 
message to the user.  Or something else I can do? David ---David Durling
  durling@uga.eduEnterprise IT Services  706-542-0223University 
of Georgia 
___UNSUBSCRIBE
 or access ARSlist Archives at www.arslist.orgattend wwrug12 www.wwrug12.com 
ARSList: "Where the Answers Are"
-- 
The Open University is incorporated by Royal Charter (RC 000391), an exempt 
charity in England & Wales and a charity registered in Scotland (SC 038302).

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

Re: ITSM 7.6.03 OTB forms that begin with CTM:Ppl% or CTM:PPL%

[Joe Martin D'Souza]

That actually led me to posting this although there is an internal convention 
here to postfix customizations with our customer abbreviations.. I wanted to 
make sure that the some of the 5 different conventions were not indeed 
customizations that the developer missed putting a prefix to. I thought it was 
weird too and there is almost no reason why they should have not stuck to just 
2 conventions here CTM:PeopleX and CTM:PPL-X. I would have felt 
more confident separating the OTB from customized flow.

The only other way to reassure if its an OTB object is looking at the Change 
History on the object where BMC owned objects have something like:
“9/10/2009 9:19:53 PMBMC
Copyright (c) 1991 - 2009 BMC Software, Inc. all rights reserved

BMCVer=7.6.00”

This too, I wonder if its consistent really.. I wouldn’t be surprised if there 
are a vast number of BMC owned objects that do not have that ‘signature’ in the 
Change History.

Joe

From: John Sundberg 
Sent: Tuesday, March 13, 2012 8:48 AM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG 
Subject: Re: ITSM 7.6.03 OTB forms that begin with CTM:Ppl% or CTM:PPL%

** I see 5 different naming conventions. 

How many do you see?

-John

On Tue, Mar 13, 2012 at 2:15 AM, patchsk  wrote:

  ** Here is the list from ITSM 7.6.03p002 

  CTM:PPL-SptGrpAssoc-ITSkills
  CTM:PPL-SptGrpFuncRole-ITSkills
  CTM:PPLSupptGrpAscFcnRoleLkUp
  CTM:Ppl Search-PermissionGrp
  CTM:Ppl Search-SupportGrpAssoc 
  CTM:Ppl Search-SupportGrpFuncR 
  CTM:Ppl Search-Worklog
  CTM:PplPermissionSupGrpFuncRoleJoin
  CTM:PplPermissionSupGrpJoin
  
  CTM:People
  CTM:People Attachments
  CTM:People Attributes
  CTM:People Audit 
  CTM:People Benefit Info 
  CTM:People Education 
  CTM:People HR Attendance Mgmt 
  CTM:People HR Time Management 
  CTM:People IT Skills 
  CTM:People LookUp 
  CTM:People Management Console
  CTM:People Organization 
  CTM:People Organization Search 
  CTM:People Permission Groups
  CTM:People Profile
  CTM:People Search
  CTM:People Search-Supp. Staff 
  CTM:People Template 
  CTM:People Template NTE 
  CTM:People Template PG 
  CTM:People Template SG 
  CTM:People Template SG Lookup
  CTM:People Travel Profile
  CTM:People Wallet
  CTM:People WorkLog
  CTM:PeopleITSkillsJoin
  CTM:PeoplePermissionGrpUnique
  CTM:PeoplePermissionJoin
  CTM:PeoplePermissionJoin_PMC
  CTM:PeopleSelfJoin
  CTM:PeopleSyncConsole
  CTM:PeopleUser
  CTM:PeopleUserSupportGroupFunctionalRole
  CTM:People_Template_Child
  CTM:People_Template_SFR
  CTM:People_Template_SFR_Lookup

  On Monday, March 12, 2012 4:17:37 PM UTC-5, Joe Martin D'Souza wrote: 
** 

I do not have a vanilla system to compare our moderately customized system 
with and I know for a fact there are some new custom forms created for 
integration purposes to LDAP, that begin with CTM:PPL and although for the most 
part the past developers have post fixed new custom forms with the abbreviation 
of the site name, I do not want to assume that’s been the case consistently..

So could someone help me with a list of all forms that begin with CTM:Ppl 
or CTM:PPL that are out of the box??

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




-- 

John Sundberg

Kinetic Data, Inc. 
"Your Business. Your Process."
Recipient of:
WWRUG10 Best Customer Service/Support Award
WWRUG09 Innovator of the Year Award


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

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

Re: ITSM 7.6.03 OTB forms that begin with CTM:Ppl% or CTM:PPL%

[Joe Martin D'Souza]

Thank you (and others who responded – Ben Chernys, John Sundberg and Jose 
Huerta)! Appreciate it..

I was interested in this list (beginning with CTM:PPL or CTM:Ppl) so I could 
ignore looking at these unless there are customizations within them..
CTM:PPL-SptGrpAssoc-ITSkills
CTM:PPL-SptGrpFuncRole-ITSkills
CTM:PPLSupptGrpAscFcnRoleLkUp
CTM:Ppl Search-PermissionGrp
CTM:Ppl Search-SupportGrpAssoc 
CTM:Ppl Search-SupportGrpFuncR 
CTM:Ppl Search-Worklog
CTM:PplPermissionSupGrpFuncRoleJoin
CTM:PplPermissionSupGrpJoin

Thank you’ll for the information..

Joe

From: patchsk 
Sent: Tuesday, March 13, 2012 3:15 AM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG 
Subject: Re: ITSM 7.6.03 OTB forms that begin with CTM:Ppl% or CTM:PPL%

** Here is the list from ITSM 7.6.03p002 

CTM:PPL-SptGrpAssoc-ITSkills
CTM:PPL-SptGrpFuncRole-ITSkills
CTM:PPLSupptGrpAscFcnRoleLkUp
CTM:Ppl Search-PermissionGrp
CTM:Ppl Search-SupportGrpAssoc 
CTM:Ppl Search-SupportGrpFuncR 
CTM:Ppl Search-Worklog
CTM:PplPermissionSupGrpFuncRoleJoin
CTM:PplPermissionSupGrpJoin

CTM:People
CTM:People Attachments
CTM:People Attributes
CTM:People Audit 
CTM:People Benefit Info 
CTM:People Education 
CTM:People HR Attendance Mgmt 
CTM:People HR Time Management 
CTM:People IT Skills 
CTM:People LookUp 
CTM:People Management Console
CTM:People Organization 
CTM:People Organization Search 
CTM:People Permission Groups
CTM:People Profile
CTM:People Search
CTM:People Search-Supp. Staff 
CTM:People Template 
CTM:People Template NTE 
CTM:People Template PG 
CTM:People Template SG 
CTM:People Template SG Lookup
CTM:People Travel Profile
CTM:People Wallet
CTM:People WorkLog
CTM:PeopleITSkillsJoin
CTM:PeoplePermissionGrpUnique
CTM:PeoplePermissionJoin
CTM:PeoplePermissionJoin_PMC
CTM:PeopleSelfJoin
CTM:PeopleSyncConsole
CTM:PeopleUser
CTM:PeopleUserSupportGroupFunctionalRole
CTM:People_Template_Child
CTM:People_Template_SFR
CTM:People_Template_SFR_Lookup

On Monday, March 12, 2012 4:17:37 PM UTC-5, Joe Martin D'Souza wrote: 
  ** 

  I do not have a vanilla system to compare our moderately customized system 
with and I know for a fact there are some new custom forms created for 
integration purposes to LDAP, that begin with CTM:PPL and although for the most 
part the past developers have post fixed new custom forms with the abbreviation 
of the site name, I do not want to assume that’s been the case consistently..

  So could someone help me with a list of all forms that begin with CTM:Ppl or 
CTM:PPL that are out of the box??

  Joe

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

Re: Avoiding pop-ups while requiring input

[LJ LongWing]

Sorry I missed the version :)...we moved to 7.5, and then about 6 months
later went to 7.6.4...so it's hard to keep track of what was in each
release.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling
Sent: Tuesday, March 13, 2012 7:19 AM
To: arslist@ARSLIST.ORG
Subject: Re: Avoiding pop-ups while requiring input

Thanks LJ and Chris,

(Sorry, forgot to say I was on ARS 7.5.)
I looked around and couldn't find the option, and it turns out it's not a
7.5 feature - don't see it in the 7.5 docs, but I do see it in 7.6.4 docs.

David

> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
> Sent: Monday, March 12, 2012 6:07 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Avoiding pop-ups while requiring input
> 
> David,
> If you are running 7.5 I think it was...you can configure everything to go
> to the 'prompt bar'that's not a popup :)
> 
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling
> Sent: Monday, March 12, 2012 3:29 PM
> To: arslist@ARSLIST.ORG
> Subject: Avoiding pop-ups while requiring input
> 
> We're rolling out an app for staff that normally don't use Remedy, and a
> usability concern is browser pop-up blockers.   (I know the login page
warns
> about pop-ups, but I've seen it ignored & I've done it myself.)  This is a
> rather detailed Remedy form, and if they get a pop-up & have to reload the
> page, the user input is lost.
> 
> I took out "message" actions from my workflow to avoid this, but there are
> still Required fields:  if left blank, they use a pop-up box.
> 
> Does anyone have a creative way for getting around this for required
fields?
> Maybe some trick where the fields are not really required on the database
> side, but not sure how ensure they are populated without using a message
> to
> the user.  Or something else I can do?
> 
> David
> 
> ---
> David Durling  durl...@uga.edu
> Enterprise IT Services  706-542-0223
> University of Georgia
> 
> __
> __
> ___
> 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"

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

Re: Question: oracle clob in a row scenario

[Misi Mladoniczky]

Hi,

You should see a significant size reduction as well as performance
improvement on inserts/updates :-)

The size was reduced to less than half in the system I was working on, and
the bulk of the data left was actually attachments.

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.

> I think I have around 120 Gig of LOB, that is going from out to in..
> I need to put in row, it is getting out of control..
>
> On Tue, Mar 13, 2012 at 9:45 AM, Misi Mladoniczky  wrote:
>
>> Hi,
>>
>> I have done that a couple of times without any real problems. It did
>> take
>> a lot less than 24 hours though, so these systems were probably much
>> smaller. About 10-15GB if I remember right, and much bigger with out-row
>> storage.
>>
>>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.
>>
>> > Hey all ,
>> > Odd question, from a person who is not normal.. which is normal.. lol
>> >
>> > If you have a production system and you are taking an existing system
>> that
>> > is up and running online
>> > and you do the modify all the lob's from out-row to in-row
>> > is there any issues with doing this while everyone is using it ?
>> >
>> > I see nothing obviously stated that you should not run this while
>> doing
>> > audits, or anything..
>> > Does Oracle take care of that scenario, while moving from one way to
>> the
>> > other..
>> >
>> > I did one system that took almost 24 hours.. This is why I am
>> asking...
>> >
>> > thanks..
>> >
>> > --
>> > Patrick Zandi
>> >
>> >
>> ___
>> > 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"
>>
>
>
>
> --
> Patrick Zandi
>
> ___
> 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: Question: oracle clob in a row scenario

[patrick zandi]

I think I have around 120 Gig of LOB, that is going from out to in..
I need to put in row, it is getting out of control..

On Tue, Mar 13, 2012 at 9:45 AM, Misi Mladoniczky  wrote:

> Hi,
>
> I have done that a couple of times without any real problems. It did take
> a lot less than 24 hours though, so these systems were probably much
> smaller. About 10-15GB if I remember right, and much bigger with out-row
> storage.
>
>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.
>
> > Hey all ,
> > Odd question, from a person who is not normal.. which is normal.. lol
> >
> > If you have a production system and you are taking an existing system
> that
> > is up and running online
> > and you do the modify all the lob's from out-row to in-row
> > is there any issues with doing this while everyone is using it ?
> >
> > I see nothing obviously stated that you should not run this while doing
> > audits, or anything..
> > Does Oracle take care of that scenario, while moving from one way to the
> > other..
> >
> > I did one system that took almost 24 hours.. This is why I am asking...
> >
> > thanks..
> >
> > --
> > Patrick Zandi
> >
> >
> ___
> > 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"
>



-- 
Patrick Zandi

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

Re: Cannot establish a network connection to the AR System server

[Grooms, Frederick W]

Since you are getting errors like Error while writing to file and no file found 
I would guess that you are not running the AR System as the correct unix user.

libclntsh.so.9.0 is part of the Oracle client libraries (so your PATH and 
LD_LIBRARY_PATH environment variables are not set correctly)

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of vidyasagar kommu
Sent: Tuesday, March 13, 2012 9:18 AM
To: arslist@ARSLIST.ORG
Subject: Cannot establish a network connection to the AR System server

Hi All,

I am unable to access the server i am getting below error :

ARERR [90] Cannot establish a network connection to the AR System
server : servera : RPC: Miscellaneous tli error - System error
(Connection refused).

When i am trying to restart the server below error i am getting.

ld.so.1: arserverd: fatal: libclntsh.so.9.0: open failed: No such file
or directory.

In arrerror log file Below errors:
Tue Mar 13 09:34:57 2012  Distrib : AR System Distributed Server
terminated -- fatal error encountered (ARDSNOTE 3001)
Tue Mar 13 09:34:58 2012  Distrib : Error while writing to a file (ARDSERR 301)
Tue Mar 13 09:34:58 2012 /opt/ar/itm104/db/ardist.log
Tue Mar 13 09:37:18 2012  Distrib : AR System Server is not currently
available -- will retry connection (ARDSNOTE 3004)
Tue Mar 13 09:39:54 2012  Distrib : AR System Distributed Server
terminated when a signal was received by the server (ARDSNOTE 3000)
Tue Mar 13 09:39:54 2012 15
Tue Mar 13 09:39:55 2012  Distrib : AR System Distributed Server
terminated -- fatal error encountered (ARDSNOTE 3001)
Tue Mar 13 09:40:18 2012  Distrib : Error while writing to a file (ARDSERR 301)
Tue Mar 13 09:40:18 2012 /opt/ar/itm104/db/ardist.log
Tue Mar 13 09:42:38 2012  Distrib : AR System Server is not currently
available -- will retry connection (ARDSNOTE 3004)

Could you please help me on this .


Thanks
Sagar

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

Cannot establish a network connection to the AR System server

[vidyasagar kommu]

Hi All,

I am unable to access the server i am getting below error :

ARERR [90] Cannot establish a network connection to the AR System
server : servera : RPC: Miscellaneous tli error - System error
(Connection refused).

When i am trying to restart the server below error i am getting.

ld.so.1: arserverd: fatal: libclntsh.so.9.0: open failed: No such file
or directory.

In arrerror log file Below errors:
Tue Mar 13 09:34:57 2012  Distrib : AR System Distributed Server
terminated -- fatal error encountered (ARDSNOTE 3001)
Tue Mar 13 09:34:58 2012  Distrib : Error while writing to a file (ARDSERR 301)
Tue Mar 13 09:34:58 2012 /opt/ar/itm104/db/ardist.log
Tue Mar 13 09:37:18 2012  Distrib : AR System Server is not currently
available -- will retry connection (ARDSNOTE 3004)
Tue Mar 13 09:39:54 2012  Distrib : AR System Distributed Server
terminated when a signal was received by the server (ARDSNOTE 3000)
Tue Mar 13 09:39:54 2012 15
Tue Mar 13 09:39:55 2012  Distrib : AR System Distributed Server
terminated -- fatal error encountered (ARDSNOTE 3001)
Tue Mar 13 09:40:18 2012  Distrib : Error while writing to a file (ARDSERR 301)
Tue Mar 13 09:40:18 2012 /opt/ar/itm104/db/ardist.log
Tue Mar 13 09:42:38 2012  Distrib : AR System Server is not currently
available -- will retry connection (ARDSNOTE 3004)

Could you please help me on this .


Thanks
Sagar

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

Re: Question: oracle clob in a row scenario

[Misi Mladoniczky]

Hi,

I have done that a couple of times without any real problems. It did take
a lot less than 24 hours though, so these systems were probably much
smaller. About 10-15GB if I remember right, and much bigger with out-row
storage.

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.

> Hey all ,
> Odd question, from a person who is not normal.. which is normal.. lol
>
> If you have a production system and you are taking an existing system that
> is up and running online
> and you do the modify all the lob's from out-row to in-row
> is there any issues with doing this while everyone is using it ?
>
> I see nothing obviously stated that you should not run this while doing
> audits, or anything..
> Does Oracle take care of that scenario, while moving from one way to the
> other..
>
> I did one system that took almost 24 hours.. This is why I am asking...
>
> thanks..
>
> --
> Patrick Zandi
>
> ___
> 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: Avoiding pop-ups while requiring input

[David Durling]

Hi Ian,

The issue would be stopping things before I hit a submit or modify action, I 
think - because then the system will generate a pop-up (on 7.5).

So, like Joe suggested, I think I'll try a custom submit/modify button and 
display the text/color like you mention if the needed fields are null.  This 
avoids any submit or modify action actually being initiated until the needed 
fields are filled in.  I guess I could even leave the fields as Required and do 
this.

Thanks guys,
David

David Durling
University of Georgia


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Ian Trimnell
Sent: Tuesday, March 13, 2012 1:42 AM
To: arslist@ARSLIST.ORG
Subject: Re: Avoiding pop-ups while requiring input

**

David,

One way to avoid pop-ups could be as follows:

  *   parse the form on submit and check if any of the required fields are blank
  *   if so, make a hidden warning text field visible saying something like 
"please enter required data"
  *   change the label colour on the fields that are required.

Would that fit the bill?

Ian

Ian Trimnell
Systems Programmer, Distributed Systems
Information Technology
Berrill Building, Level 1 North
Phone: 01908 6 53741   web: http://www.open.ac.uk/

On 12/03/2012 21:28, David Durling wrote:

We're rolling out an app for staff that normally don't use Remedy, and a 
usability concern is browser pop-up blockers.   (I know the login page warns 
about pop-ups, but I've seen it ignored & I've done it myself.)  This is a 
rather detailed Remedy form, and if they get a pop-up & have to reload the 
page, the user input is lost.



I took out "message" actions from my workflow to avoid this, but there are 
still Required fields:  if left blank, they use a pop-up box.



Does anyone have a creative way for getting around this for required fields?  
Maybe some trick where the fields are not really required on the database side, 
but not sure how ensure they are populated without using a message to the user. 
 Or something else I can do?



David



---

David Durling  durl...@uga.edu

Enterprise IT Services  706-542-0223

University of Georgia



___

UNSUBSCRIBE or access ARSlist Archives at 
www.arslist.org

attend wwrug12 www.wwrug12.com ARSList: "Where the 
Answers Are"

--
The Open University is incorporated by Royal Charter (RC 000391), an exempt 
charity in England & Wales and a charity registered in Scotland (SC 038302).
_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"

Mid-Tier Caching Endeavors

[Misi Mladoniczky]

Hi all Mid-Tier Admins!

I have had a series of frustrating issues with Mid-Tier 7.6.04 SP2
caching, that I think I have now come to grips with.

What I did was to create a Group (STUGUN) and a Role (STUGUN) to be used
in customization of the application "Remedy Incident Management". The role
granted access to a set of ACTLs.

What happened was that Mid-Tier failed to recache things sometimes, and
some users with this group (STUGUN) got access to the ACTLs, and some did
not.

The same user could get different results depending on which Mid-Tier he
accessed.

My error, I think, is that the STUGUN-Group was set defined as a None-Group.

As it was mapped to a Role, it worked fine to assign permission to it, and
it also worked fine in Remedy User.

When Mid-Tier does its caching, it will create a unique Group-combination
based on each users unique combination of Groups.

For example if a user belongs to:

20213 => Service Request User (Change)

10001 => STUGUN (None, this is my group)

20003 => Incident User (Change)

2 => General Access (Change)

20032 => Asset Viewer (Change)

100021 => 100021 (None) - this is a Support Group

The Unique combination here will be ";2;20003;20032;20213;" where the
two groups with Group-Type "None" has been stripped out.

This is because None-groups should not be able to change access in any
way, except for row-level-access, but that is calculated in another way.

So depending on if the first User with the unique permission map
";2;20003;20032;20213;" belonged to my STUGUN-group or not, the cached
file included/excluded permission to thos STUGUN-Active-Links!

SOLUTION: Change the None-Group to View or Change

CONCLUSION: Never map a None-Group to a Role

Please let me know if my deductions seems flawed in any way!

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.

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

Re: CMDB 7.6.04 SP2 Error

[Peter Romain]

We wanted to fix the issue with CMDB 7.6.04 allowing duplicate
reconciliation id's in the same dataset and were advised to wait for CMDB
7.6.04 SP3 which is due in March (i.e. this month)

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi
Sent: 13 March 2012 12:44
To: arslist@ARSLIST.ORG
Subject: Re: CMDB 7.6.04 SP2 Error

 

** I kinda got the idea was that sp3 is core only..  period.. 
I also got the idea they were focused on 7.7,  \but I would love to hear
otherwise.. Silence is not golden... It's nerve racking.. 8-P

On Tue, Mar 13, 2012 at 2:52 AM, BradRemedy  wrote:

** 



So...anyone have any idea on when CMDB 7.6.04 SP3 is being released? I see
that the Remedy Server Sp3 has been released which is great...however it
doesnt solve this problem. And for the life of me I cannot find out when BMC
plan (or if they even are going to ) to release CMDB 7.6.40 SP3. Our Support
partner also cannot find out.

 

I honestly cannot wait for the next visit from a BMC representative so that
I can ask them to please explain to me how they expect us to plan our
roadmap, upgrades as well as resolve important bugs when they will not let
us know when a patch is expected. This error that we have is forcing us to
keep delaying our upgrade to 7.6.04 as we are waiting for SP3 and is giving
Remedy such a bad name it is past being funny. All the work that we have
done to build this product up as a reliable, fast solution is going out the
window.



On Thu, Feb 2, 2012 at 8:23 PM, Basil Webster  wrote:

** 

Hi,

 

I know it's a little late but we logged an issue about a month ago
referencing the SW mentioned below. I immediately got a reply saying that we
should wait for SP3 but they could not provide a date. Long story short, I
escalated this via our partner support and received an mail today saying
that they hope to have SP3 out by March but are looking into a special
release to SP2 before then.

 

I suggest you log that ticket asking for the special release.

 

 

Regards,

 

 

Basil Webster | Support Manager | Remex Group

Email: ba...@remex.co.za | www.remex.co.za  

Tel:  +27 (0) 12 756 4227/8 | Cell: +27 (0) 82
  452 9389 | Fax:  +27 (0) 86
  540 9224 |

Centurion Close | Suite 2C | 119 Gerhard Street | Centurion CBD | South
Africa |

 

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of BradRemedy
Sent: 12 January 2012 02:58 PM
To: arslist@ARSLIST.ORG
Subject: Re: CMDB 7.6.04 SP2 Error

 

** 

Hi Mark

 

Thanks for that

 

Just had a look and it does seem to be related. Dont suppose anyone has any
idea on when SP3 is being released? The only other thing I can try is to use
SP1 and see if the same error occurs. At the end of the day we would prefer
not to have to wait months for SP3 as it will delay our upgrade plans we
have for the year - and we havent even start with ITSM and SRM yet :-(.

On Thu, Jan 12, 2012 at 2:25 PM, Walters, Mark  wrote:

** 

There's a very similar looking defect that looks likely to be fixed in
7.6.04 SP3.  I suggest you open an issue with BMC and reference defect
SW00416229, support should be able to confirm whether it's the same problem.

 

Mark

I work for BMC, I don't speak for them

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of BradRemedy
Sent: 12 January 2012 11:54
To: arslist@ARSLIST.ORG
Subject: CMDB 7.6.04 SP2 Error

 

** 

Hi

 

We have run into a wierd error that we cannot find any reference to on the
ARSList, Manuals or Support web. Hopefully someone here can offer some
suggestions on what we can try next as we are quickly running out of ideas
and have tried this upgrade a few times.

 

Firstly some background information. We have a Test server running Windows
Server 2008 Enterprise with a seperate DB Server running SQL 2008. We also
have a third server acting as a Mid Tier server also running Windows Server
2008.

 

We are testing our upgrade strategy on upgrading from ARS Core 7.5 Patch
003, CMDB 7.6 Patch 001 to ARS Core 7.6.04 SP2 and CMDB 7.6.04 SP2. We are
also running ITSM 7.6 and SRM 7.6 Patch 001 however these 2 applications
will only be upgraded at a later stage and we want to leave them on their
current versions.

 

Now, we have run the Upgrade for ARS core to 7.6.04 SP2 with no errors.
Every looks and works as expected. We then ran the ugprade for CMDB to
7.6.04 SP2 which also completed successfully. The mid tier server is also
ugprade to 7.6.04 SP2 and all applications (Incident, Problem, Change, SRM)
are working correctly, with the exception to this one problem.

 

When we click on any CI in the Asset Management Application and click on the
"Explore CI' option, the BMC Atrium Explorer opens and attempts to load some
screens - however we then get this error - "Error when calling
getRelatedComponentsAndRelationshipsOverlay"

 

 

Re: Avoiding pop-ups while requiring input

[David Durling]

Thanks LJ and Chris,

(Sorry, forgot to say I was on ARS 7.5.)
I looked around and couldn't find the option, and it turns out it's not a 7.5 
feature - don't see it in the 7.5 docs, but I do see it in 7.6.4 docs.

David

> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
> Sent: Monday, March 12, 2012 6:07 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Avoiding pop-ups while requiring input
> 
> David,
> If you are running 7.5 I think it was...you can configure everything to go
> to the 'prompt bar'that's not a popup :)
> 
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling
> Sent: Monday, March 12, 2012 3:29 PM
> To: arslist@ARSLIST.ORG
> Subject: Avoiding pop-ups while requiring input
> 
> We're rolling out an app for staff that normally don't use Remedy, and a
> usability concern is browser pop-up blockers.   (I know the login page warns
> about pop-ups, but I've seen it ignored & I've done it myself.)  This is a
> rather detailed Remedy form, and if they get a pop-up & have to reload the
> page, the user input is lost.
> 
> I took out "message" actions from my workflow to avoid this, but there are
> still Required fields:  if left blank, they use a pop-up box.
> 
> Does anyone have a creative way for getting around this for required fields?
> Maybe some trick where the fields are not really required on the database
> side, but not sure how ensure they are populated without using a message
> to
> the user.  Or something else I can do?
> 
> David
> 
> ---
> David Durling  durl...@uga.edu
> Enterprise IT Services  706-542-0223
> University of Georgia
> 
> __
> __
> ___
> 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: ITSM 7.6.03 OTB forms that begin with CTM:Ppl% or CTM:PPL%

[Jose Huerta]

A year ago I started to write my own best practices (And I published a lot
of them on my blog) because I couldn't find any BMC's best practices guide.
I know why BMC doesn't publish a best practices guide, because they don't
have it!

Jose M. Huerta
Project Manager**

Movil: 661 665 088

Telf.: 971 75 03 24

Fax: 971 75 07 94

 

SM2 Baleares S.A.
C/Rita Levi 

Edificio SM2 Parc Bit

07121 Palma de Mallorca

  
  
 

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 Tue, Mar 13, 2012 at 13:48, John Sundberg
wrote:

> ** I see 5 different naming conventions.
>
> How many do you see?
>
> -John
>
> On Tue, Mar 13, 2012 at 2:15 AM, patchsk  wrote:
>
>> ** Here is the list from ITSM 7.6.03p002
>>
>> CTM:PPL-SptGrpAssoc-ITSkills
>> CTM:PPL-SptGrpFuncRole-ITSkills
>> CTM:PPLSupptGrpAscFcnRoleLkUp
>> CTM:Ppl Search-PermissionGrp
>> CTM:Ppl Search-SupportGrpAssoc
>> CTM:Ppl Search-SupportGrpFuncR
>> CTM:Ppl Search-Worklog
>> CTM:PplPermissionSupGrpFuncRoleJoin
>> CTM:PplPermissionSupGrpJoin
>> 
>> CTM:People
>> CTM:People Attachments
>> CTM:People Attributes
>> CTM:People Audit
>> CTM:People Benefit Info
>> CTM:People Education
>> CTM:People HR Attendance Mgmt
>> CTM:People HR Time Management
>> CTM:People IT Skills
>> CTM:People LookUp
>> CTM:People Management Console
>> CTM:People Organization
>> CTM:People Organization Search
>> CTM:People Permission Groups
>> CTM:People Profile
>> CTM:People Search
>> CTM:People Search-Supp. Staff
>> CTM:People Template
>> CTM:People Template NTE
>> CTM:People Template PG
>> CTM:People Template SG
>> CTM:People Template SG Lookup
>> CTM:People Travel Profile
>> CTM:People Wallet
>> CTM:People WorkLog
>> CTM:PeopleITSkillsJoin
>> CTM:PeoplePermissionGrpUnique
>> CTM:PeoplePermissionJoin
>> CTM:PeoplePermissionJoin_PMC
>> CTM:PeopleSelfJoin
>> CTM:PeopleSyncConsole
>> CTM:PeopleUser
>> CTM:PeopleUserSupportGroupFunctionalRole
>> CTM:People_Template_Child
>> CTM:People_Template_SFR
>> CTM:People_Template_SFR_Lookup
>>
>> On Monday, March 12, 2012 4:17:37 PM UTC-5, Joe Martin D'Souza wrote:
>>>
>>> **
>>>
>>> I do not have a vanilla system to compare our moderately customized
>>> system with and I know for a fact there are some new custom forms created
>>> for integration purposes to LDAP, that begin with CTM:PPL and although for
>>> the most part the past developers have post fixed new custom forms with the
>>> abbreviation of the site name, I do not want to assume that’s been the case
>>> consistently..
>>>
>>> So could someone help me with a list of all forms that begin with
>>> CTM:Ppl or CTM:PPL that are out of the box??
>>>
>>> Joe
>>> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
>>
>> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
>
>
>
>
> --
>
> *John Sundberg*
> Kinetic Data, Inc.
> "Your Business. Your Process."
> *Recipient of:
> **WWRUG10 Best Customer Service/Support Award*
> *WWRUG09 Innovator of the Year Award*
> *
> *
> 651-556-0930 I john.sundb...@kineticdata.com
>  www.kineticdata.com I community.kineticdata.com
>
>
>
>  _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: ResetKickbackCount" Escalation question .... out of the box escalation seems to be updating every incident older than 31 days

[John Atherly]

I agree I don't like to disable workflow but in this case with the 
escalation doing a modify all records and with the number of records in my 
system and plus the fact we are not using this report.
_
 


John Atherly  |   APC by Schneider Electric   |  Information, Process & 
Organization (IPO)  |   Remedy Administrator / Developer 
Phone: +305-266-5005 ext. 237  |   
Email: john.athe...@apcc.com  |   Site: www.apc.com/  |   Address: 703 
Waterford Way, Suit 850, Miami, FL 33126 USA 
*** Please consider the environment before printing this e-mail 




Jose Huerta  
Sent by: "Action Request System discussion list(ARSList)" 

03/13/2012 08:45 AM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Re: ResetKickbackCount" Escalation question  out of the box escalation 
seems to be updating every incident older than 31 days






** My recommendation about customizations is to add and not to delete or 
disable objects ( 
http://theremedyforit.com/2012/03/best-practices-for-customizations/ ) So 
I continue to recommend to create another last modified by and date 
fields.

Jose M. Huerta
Project Manager
Movil: 661 665 088
Telf.: 971 75 03 24
Fax: 971 75 07 94

SM2 Baleares S.A.
C/Rita Levi 
Edificio SM2 Parc Bit
07121 Palma de Mallorca
 
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 Tue, Mar 13, 2012 at 13:40, John Atherly <
john.athe...@schneider-electric.com> wrote:
** 
I looked more into this escalation to see what it is doing and what fields 
that it uses and why.  I found a filter (HPD:INC:SetFromResolved_Kickback) 
 that fires when a ticket is reopened that increases the count in the 
Kickback count field. Then on the first of the month this escalation fire 
and reset everything back to zero.  My best guess is that this process is 
used for some out of the box report.   I think I'm going to recommend to 
just disable the escalation.
_
 


John Atherly  |   APC by Schneider Electric   |  Information, Process & 
Organization (IPO)  |   Remedy Administrator / Developer 
Phone: +305-266-5005 ext. 237  |   
Email: john.athe...@apcc.com  |   Site: www.apc.com/  |   Address: 703 
Waterford Way, Suit 850, Miami, FL 33126 USA 
*** Please consider the environment before printing this e-mail 




"Joe Martin D'Souza"  
Sent by: "Action Request System discussion list(ARSList)" <
arslist@ARSLIST.ORG> 
03/12/2012 10:36 PM 


Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG 
cc

Subject
Re: ResetKickbackCount" Escalation question  out of the box escalation 
seems to be updating every incident older than 31 days








** 
  
I completely agree that bypassing the application layer is never a good 
idea unless absolutely necessary.. the second option of a custom Last 
Modified Date2 set by custom workflow is a better idea as the framework of 
its implementation stays within the applications context. 
  
Direct SQL’s if used, MUST be used CAREFULLY. The only reason I thought of 
it in this case is that I’m almost 100% sure a Direct SQL when used within 
workflow to update a record, does not alter the Last Modified Date or Last 
Modified By field. It just updates what is asked to update and bypasses 
the application layer altogether and does not update these system fields 
even if the SQL was designed to update a AR record. 
  
Out of curiosity (I didn’t have the time to find out the purpose of this 
Escalation), what does it do? 
  
Joe 
  
  
From: Jose Huerta 
Sent: Monday, March 12, 2012 7:31 PM 
Newsgroups: public.remedy.arsystem.general 
To: arslist@ARSLIST.ORG 
Subject: Re: ResetKickbackCount" Escalation question  out of the box 
escalation seems to be updating every incident older than 31 days 
  
** I think that change a set action to a direct SQL to avoid normal ARS 
behavior is a bad practice and you'll pay it at the future. 
Jose M. Huerta
Project Manager 
Movil: 661 665 088 
Telf.: 971 75 03 24 
Fax: 971 75 07 94 

SM2 Baleares S.A.
C/Rita Levi 
Edificio SM2 Parc Bit 
07121 Palma de Mallorca 
 
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 

Re: ITSM 7.6.03 OTB forms that begin with CTM:Ppl% or CTM:PPL%

[John Sundberg]

I see 5 different naming conventions.

How many do you see?

-John

On Tue, Mar 13, 2012 at 2:15 AM, patchsk  wrote:

> ** Here is the list from ITSM 7.6.03p002
>
> CTM:PPL-SptGrpAssoc-ITSkills
> CTM:PPL-SptGrpFuncRole-ITSkills
> CTM:PPLSupptGrpAscFcnRoleLkUp
> CTM:Ppl Search-PermissionGrp
> CTM:Ppl Search-SupportGrpAssoc
> CTM:Ppl Search-SupportGrpFuncR
> CTM:Ppl Search-Worklog
> CTM:PplPermissionSupGrpFuncRoleJoin
> CTM:PplPermissionSupGrpJoin
> 
> CTM:People
> CTM:People Attachments
> CTM:People Attributes
> CTM:People Audit
> CTM:People Benefit Info
> CTM:People Education
> CTM:People HR Attendance Mgmt
> CTM:People HR Time Management
> CTM:People IT Skills
> CTM:People LookUp
> CTM:People Management Console
> CTM:People Organization
> CTM:People Organization Search
> CTM:People Permission Groups
> CTM:People Profile
> CTM:People Search
> CTM:People Search-Supp. Staff
> CTM:People Template
> CTM:People Template NTE
> CTM:People Template PG
> CTM:People Template SG
> CTM:People Template SG Lookup
> CTM:People Travel Profile
> CTM:People Wallet
> CTM:People WorkLog
> CTM:PeopleITSkillsJoin
> CTM:PeoplePermissionGrpUnique
> CTM:PeoplePermissionJoin
> CTM:PeoplePermissionJoin_PMC
> CTM:PeopleSelfJoin
> CTM:PeopleSyncConsole
> CTM:PeopleUser
> CTM:PeopleUserSupportGroupFunctionalRole
> CTM:People_Template_Child
> CTM:People_Template_SFR
> CTM:People_Template_SFR_Lookup
>
> On Monday, March 12, 2012 4:17:37 PM UTC-5, Joe Martin D'Souza wrote:
>>
>> **
>>
>> I do not have a vanilla system to compare our moderately customized
>> system with and I know for a fact there are some new custom forms created
>> for integration purposes to LDAP, that begin with CTM:PPL and although for
>> the most part the past developers have post fixed new custom forms with the
>> abbreviation of the site name, I do not want to assume that’s been the case
>> consistently..
>>
>> So could someone help me with a list of all forms that begin with CTM:Ppl
>> or CTM:PPL that are out of the box??
>>
>> Joe
>> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
>
> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_




-- 

*John Sundberg*
Kinetic Data, Inc.
"Your Business. Your Process."
*Recipient of:
**WWRUG10 Best Customer Service/Support Award*
*WWRUG09 Innovator of the Year Award*
*
*
651-556-0930 I john.sundb...@kineticdata.com
www.kineticdata.com I community.kineticdata.com

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

Re: BMC_GLOBAL_DEFAULT_SRVC CI

[Tauf Chowdhury]

I'm pretty sure it's tied to the default services that come with SRM.

Sent from my iPhone

On Mar 13, 2012, at 6:17 AM, Peter Romain
 wrote:

> Hi All,
>
> CMDB 7.6.04 SP2
>
> The BMC_GLOBAL_DEFAULT_SRVC CI appears in the Service field menu on the 
> Infrastructure Change form.
>
> BMC tells us that this CI should never be deleted.
>
> Does anyone know precisely what it is for? I guess it's to do with the 
> Service Catalog functionality in  Atrium Core.
>
> I can set the status of this CI from its out-of-the-box value of 'Ordered' to 
> 'End of Life' to remove it from the menu but would this affect the 
> functionality that the CI is there to support?
>
> Cheers
>
> Peter
>
> ___
> 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: ResetKickbackCount" Escalation question .... out of the box escalation seems to be updating every incident older than 31 days

[Jose Huerta]

My recommendation about customizations is to add and not to delete or
disable objects (
http://theremedyforit.com/2012/03/best-practices-for-customizations/ ) So I
continue to recommend to create another last modified by and date fields.

Jose M. Huerta
Project Manager**

Movil: 661 665 088

Telf.: 971 75 03 24

Fax: 971 75 07 94

 

SM2 Baleares S.A.
C/Rita Levi 

Edificio SM2 Parc Bit

07121 Palma de Mallorca

  
  
 

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 Tue, Mar 13, 2012 at 13:40, John Atherly <
john.athe...@schneider-electric.com> wrote:

> **
> I looked more into this escalation to see what it is doing and what fields
> that it uses and why.  I found a filter (HPD:INC:SetFromResolved_Kickback)
>  that fires when a ticket is reopened that increases the count in the
> Kickback count field. Then on the first of the month this escalation fire
> and reset everything back to zero.  My best guess is that this process is
> used for some out of the box report.   I think I'm going to recommend to
> just disable the escalation.
>
> _
> *
> John Atherly*  |  * APC by Schneider Electric **  |  Information, Process
> & Organization (IPO)*  |   *Remedy Administrator / Developer* *
> Phone:* +305-266-5005 ext. 237  |   *
> Email:* *john.athe...@apcc.com* <+john.athe...@apcc.com>  |   
> *Site:**www.apc.com/
> *   |   *Address:* 703 Waterford Way, Suit 850,
> Miami, FL 33126 USA
> *** Please consider the environment before printing this e-mail
>
>
>
>  *"Joe Martin D'Souza" *
> Sent by: "Action Request System discussion list(ARSList)" <
> arslist@ARSLIST.ORG>
>
> 03/12/2012 10:36 PM
>  Please respond to
> arslist@ARSLIST.ORG
>
>   To
> arslist@ARSLIST.ORG
> cc
>   Subject
> Re: ResetKickbackCount" Escalation question  out of the box escalation
> seems to be updating every incident older than 31 days
>
>
>
>
> **
>
> I completely agree that bypassing the application layer is never a good
> idea unless absolutely necessary.. the second option of a custom Last
> Modified Date2 set by custom workflow is a better idea as the framework of
> its implementation stays within the applications context.
>
> Direct SQL’s if used, MUST be used CAREFULLY. The only reason I thought of
> it in this case is that I’m almost 100% sure a Direct SQL when used within
> workflow to update a record, does not alter the Last Modified Date or Last
> Modified By field. It just updates what is asked to update and bypasses the
> application layer altogether and does not update these system fields even
> if the SQL was designed to update a AR record.
>
> Out of curiosity (I didn’t have the time to find out the purpose of this
> Escalation), what does it do?
>
> Joe
>
>
> *From:* *Jose Huerta* 
> *Sent:* Monday, March 12, 2012 7:31 PM
> *Newsgroups:* public.remedy.arsystem.general
> *To:* *arslist@ARSLIST.ORG* 
> *Subject:* Re: ResetKickbackCount" Escalation question  out of the
> box escalation seems to be updating every incident older than 31 days
>
> ** I think that change a set action to a direct SQL to avoid normal ARS
> behavior is a bad practice and you'll pay it at the future.  Jose M.
> Huerta
> Project Manager
> Movil: 661 665 088
> Telf.: 971 75 03 24
> Fax: 971 75 07 94
> 
>  SM2 Baleares S.A.
> C/Rita Levi
> Edificio SM2 Parc Bit
> 07121 Palma de Mallorca
>   
>    
> 
>
> 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, Mar 12, 2012 at 21:25, Joe Martin D'Souza 
> <*jdso...@shyle.net*>
> wrote:
> Three may be a workaround provided HPD:INC:ResetKickb

Re: CMDB 7.6.04 SP2 Error

[patrick zandi]

I kinda got the idea was that sp3 is core only..  period..
I also got the idea they were focused on 7.7,  \but I would love to hear
otherwise.. Silence is not golden... It's nerve racking.. 8-P

On Tue, Mar 13, 2012 at 2:52 AM, BradRemedy  wrote:

> **
> 
> So...anyone have any idea on when CMDB 7.6.04 SP3 is being released? I see
> that the Remedy Server Sp3 has been released which is great...however it
> doesnt solve this problem. And for the life of me I cannot find out when
> BMC plan (or if they even are going to ) to release CMDB 7.6.40 SP3. Our
> Support partner also cannot find out.
>
> I honestly cannot wait for the next visit from a BMC representative so
> that I can ask them to please explain to me how they expect us to plan our
> roadmap, upgrades as well as resolve important bugs when they will not let
> us know when a patch is expected. This error that we have is forcing us to
> keep delaying our upgrade to 7.6.04 as we are waiting for SP3 and is giving
> Remedy such a bad name it is past being funny. All the work that we have
> done to build this product up as a reliable, fast solution is going out the
> window.
> 
>
> On Thu, Feb 2, 2012 at 8:23 PM, Basil Webster  wrote:
>
>> **
>>
>> Hi,
>>
>> ** **
>>
>> I know it’s a little late but we logged an issue about a month ago
>> referencing the SW mentioned below. I immediately got a reply saying that
>> we should wait for SP3 but they could not provide a date. Long story short,
>> I escalated this via our partner support and received an mail today saying
>> that they hope to have SP3 out by March but are looking into a special
>> release to SP2 before then.
>>
>> ** **
>>
>> I suggest you log that ticket asking for the special release.
>>
>> ** **
>>
>> * *
>>
>> *Regards,*
>>
>> * *
>>
>> * *
>>
>> *Basil Webster *| *Support Manager *| *Remex Group*
>>
>> *Email**: **ba...@remex.co.za *| www.remex.co.za
>>
>> *Tel:  +27 (0) 12 756 4227/8 *| *Cell: +27 (0) 82 452 9389 *| *Fax:  +27
>> (0) 86 540 9224 *|
>>
>> *Centurion Close* | *Suite 2C* | *119 Gerhard Street *| *Centurion CBD*|
>> *South Africa* |
>>
>> ** **
>>
>> [image: Description: Description: Description: Description: Description:
>> REMEX GROUP - White Background - 30]
>>
>> ** **
>>
>> *From:* Action Request System discussion list(ARSList) [mailto:
>> arslist@ARSLIST.ORG] *On Behalf Of *BradRemedy
>> *Sent:* 12 January 2012 02:58 PM
>> *To:* arslist@ARSLIST.ORG
>> *Subject:* Re: CMDB 7.6.04 SP2 Error
>>
>> ** **
>>
>> ** 
>>
>> Hi Mark
>>
>>  
>>
>> Thanks for that
>>
>>  
>>
>> Just had a look and it does seem to be related. Dont suppose anyone has
>> any idea on when SP3 is being released? The only other thing I can try is
>> to use SP1 and see if the same error occurs. At the end of the day we would
>> prefer not to have to wait months for SP3 as it will delay our upgrade
>> plans we have for the year - and we havent even start with ITSM and SRM yet
>> :-(.
>>
>> On Thu, Jan 12, 2012 at 2:25 PM, Walters, Mark 
>> wrote:
>>
>> ** 
>>
>> There’s a very similar looking defect that looks likely to be fixed in
>> 7.6.04 SP3.  I suggest you open an issue with BMC and reference defect
>> SW00416229, support should be able to confirm whether it’s the same problem.
>> 
>>
>>  
>>
>> Mark
>>
>> *I work for BMC, I don’t speak for them*
>>
>>  
>>
>> *From:* Action Request System discussion list(ARSList) [mailto:
>> arslist@ARSLIST.ORG] *On Behalf Of *BradRemedy
>> *Sent:* 12 January 2012 11:54
>> *To:* arslist@ARSLIST.ORG
>> *Subject:* CMDB 7.6.04 SP2 Error
>>
>>  
>>
>> ** 
>>
>> Hi
>>
>>  
>>
>> We have run into a wierd error that we cannot find any reference to on
>> the ARSList, Manuals or Support web. Hopefully someone here can offer some
>> suggestions on what we can try next as we are quickly running out of ideas
>> and have tried this upgrade a few times.
>>
>>  
>>
>> Firstly some background information. We have a Test server running
>> Windows Server 2008 Enterprise with a seperate DB Server running SQL 2008.
>> We also have a third server acting as a Mid Tier server also running
>> Windows Server 2008.
>>
>>  
>>
>> We are testing our upgrade strategy on upgrading from ARS Core 7.5 Patch
>> 003, CMDB 7.6 Patch 001 to ARS Core 7.6.04 SP2 and CMDB 7.6.04 SP2. We are
>> also running ITSM 7.6 and SRM 7.6 Patch 001 however these 2 applications
>> will only be upgraded at a later stage and we want to leave them on their
>> current versions.
>>
>>  
>>
>> Now, we have run the Upgrade for ARS core to 7.6.04 SP2 with no errors.
>> Every looks and works as expected. We then ran the ugprade for CMDB to
>> 7.6.04 SP2 which also completed successfully. The mid tier server is also
>> ugprade to 7.6.04 SP2 and all applications (Incident, Problem, Change, SRM)
>> are working correctly, with the exception to this one problem.
>>
>>  
>>
>> When we click on an

Question: oracle clob in a row scenario

[patrick zandi]

Hey all ,
Odd question, from a person who is not normal.. which is normal.. lol

If you have a production system and you are taking an existing system that
is up and running online
and you do the modify all the lob's from out-row to in-row
is there any issues with doing this while everyone is using it ?

I see nothing obviously stated that you should not run this while doing
audits, or anything..
Does Oracle take care of that scenario, while moving from one way to the
other..

I did one system that took almost 24 hours.. This is why I am asking...

thanks..

-- 
Patrick Zandi

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

Re: ResetKickbackCount" Escalation question .... out of the box escalation seems to be updating every incident older than 31 days

[John Atherly]

I looked more into this escalation to see what it is doing and what fields 
that it uses and why.  I found a filter (HPD:INC:SetFromResolved_Kickback) 
 that fires when a ticket is reopened that increases the count in the 
Kickback count field. Then on the first of the month this escalation fire 
and reset everything back to zero.  My best guess is that this process is 
used for some out of the box report.   I think I'm going to recommend to 
just disable the escalation.
_
 


John Atherly  |   APC by Schneider Electric   |  Information, Process & 
Organization (IPO)  |   Remedy Administrator / Developer 
Phone: +305-266-5005 ext. 237  |   
Email: john.athe...@apcc.com  |   Site: www.apc.com/  |   Address: 703 
Waterford Way, Suit 850, Miami, FL 33126 USA 
*** Please consider the environment before printing this e-mail 




"Joe Martin D'Souza"  
Sent by: "Action Request System discussion list(ARSList)" 

03/12/2012 10:36 PM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Re: ResetKickbackCount" Escalation question  out of the box escalation 
seems to be updating every incident older than 31 days






** 
 
I completely agree that bypassing the application layer is never a good 
idea unless absolutely necessary.. the second option of a custom Last 
Modified Date2 set by custom workflow is a better idea as the framework of 
its implementation stays within the applications context.
 
Direct SQL’s if used, MUST be used CAREFULLY. The only reason I thought of 
it in this case is that I’m almost 100% sure a Direct SQL when used within 
workflow to update a record, does not alter the Last Modified Date or Last 
Modified By field. It just updates what is asked to update and bypasses 
the application layer altogether and does not update these system fields 
even if the SQL was designed to update a AR record.
 
Out of curiosity (I didn’t have the time to find out the purpose of this 
Escalation), what does it do?
 
Joe
 
 
From: Jose Huerta 
Sent: Monday, March 12, 2012 7:31 PM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG 
Subject: Re: ResetKickbackCount" Escalation question  out of the box 
escalation seems to be updating every incident older than 31 days
 
** I think that change a set action to a direct SQL to avoid normal ARS 
behavior is a bad practice and you'll pay it at the future.
Jose M. Huerta
Project Manager
Movil: 661 665 088
Telf.: 971 75 03 24
Fax: 971 75 07 94

SM2 Baleares S.A.
C/Rita Levi 
Edificio SM2 Parc Bit
07121 Palma de Mallorca
  
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, Mar 12, 2012 at 21:25, Joe Martin D'Souza  
wrote:
Three may be a workaround provided HPD:INC:ResetKickbackCount does not 
trigger any filters that sets other fields..

Instead of the set field operation use Direct SQL in the Escalation.

Direct SQL's will not touch the Last Modified Date to the best of my 
knowledge. The side effect is that they will not trigger any workflow 
either set for modify action of a filter.

You could try

UPDATE KickBack_Count from HPD:Help_Desk where Entry_ID = "$1$"

z1D Action is a display only field which is set to "RESETKICKBACK", so you 
would need to check all the filters that run on Escalations that get 
triggered on this value of z1D Action, and see if those actions can be 
replicated by direct SQL's too..

That way you could potentially modify the record without touching the Last 
Modified Date.

ALTERNATELY, created a Last Modified Date2 field that gets set on 
Modifications only when the user is not AR_ESCALATOR.

Joe

-Original Message- From: John Atherly
Sent: Monday, March 12, 2012 3:13 PM Newsgroups: 
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: "HPD:INC:ResetKickbackCount" Escalation question  out of 
the box escalation seems to be updating every incident older than 31 days

I have a report the looks for all Incidents modified in the last 10 days 
that runs and the escalation called HPD:INC:ResetKickbackCount is killing 
my report since it modifies all incidents.  Does anyone know any thing 
about kick back.

__
This email has been scanned by the Symantec Email Security.cloud service.
__
_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ 


___

Re: Using $GROUPS$ like not showing data in search menus.....can some guide me in right direction

[Jose Huerta]

Because BMC recommends not to use process if it can be done by other
workflow.

Jose M. Huerta
Project Manager**

Movil: 661 665 088

Telf.: 971 75 03 24

Fax: 971 75 07 94

 

SM2 Baleares S.A.
C/Rita Levi 

Edificio SM2 Parc Bit

07121 Palma de Mallorca

  
  
 

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 Tue, Mar 13, 2012 at 13:06, David Sanders <
david.sand...@westoverconsulting.co.uk> wrote:

> **
>
> Why not use the run process *Application-Confirm-Group ** *to
> test if they are a member of the group concerned? 
>
> ** **
>
> David Sanders
>
> Solution Architect
>
> *Enterprise Service Suite @ Work / e-ServiceSuite *
>
>  
>
> tel +44 1494 468980
>
> mobile +44 7710 377761
>
> email david.sand...@westoverconsulting.co.uk
>
>  
>
> web  http://www.westoverconsulting.co.uk
>
>  
>
> http://www.e-servicesuite.co.uk
>
>  
>
> 
>
> [image: Description: 
> cid:image001.gif@01CCE023.38E7E320]
> 
>
>  
>
> *ITIL – SaaS – On Premise*
>
> ** **
>
> ** **
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Ben Chernys
> *Sent:* 13 March 2012 06:58
>
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: Using $GROUPS$ like not showing data in search
> menus.can some guide me in right direction
>
> ** **
>
> ** 
>
> Hi John,
>
> ** **
>
> Interesting that you say this.
>
> ** **
>
> I saw an issue where an ITSM 6 had its ARS upgraded to 7.1 and this issue
> popped up as prior to 7.1 the groups values were as you describe (but not
> on every record!).  Problem was fixed with a 5 minute Meta-Update script to
> update said records into the correct format.
>
> ** **
>
> Since 7.1, ARS enforces the group list fields syntax so that “%;x;%” will
> work.
>
> ** **
>
> Cheers
>
> Ben Chernys
>
> www.softwaretoolhouse.com
>
> ** **
>
> *From:* Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] *On Behalf Of *John Sundberg
> *Sent:* March-13-12 03:27
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: Using $GROUPS$ like not showing data in search
> menus.can some guide me in right direction
>
> ** **
>
> ** Just wondering - what if your group is at the beginning?
>
> ** **
>
> Or - at the end….
>
> ** **
>
> $GROUPS$ like "%;100140;%" 
>
> ** **
>
> I think the above query assumes your group is in the middle of a group
> list?
>
> ** **
>
> So - you would have to do something like:
>
> ** **
>
> $GROUPS$ like "%;100140;%" OR $GROUPS$ like "100140;%" OR $GROUPS$
> like "%;100140" 
>
> ** **
>
> I am not positive -- just mentioning…
>
> ** **
>
> I did do something similar to this recently - and I did have to consider
> the case I mentioned.
>
> ** **
>
> ** **
>
> -John
>
> ** **
>
> ** **
>
> On Mon, Mar 12, 2012 at 8:10 PM, gok's  wrote:
>
> I have fixed this now all the values are showing up. What i did was like
> this
> i have give as Jose said $GROUPS$ like "%;100140;%"
> and also gave the $GROUPS$ like "%;100140;%" in menus.
> it is working showing all the values.
>
> gok's wrote:
> >
> > Environment ARServer 7.5 patch 4
> > DB:2005 SQL
> >
> > I have created a simple active link for certain group like "XYZ" changes
> a
> > search menu values to read/write only
> > A.l > Display
> > Qualification:$GROUPS$ like "XYZ"
> > IfAction:Change Field
> > Read/Write mode
> >
> > it is working for the group but in the search menu there are no values
> are
> > showing up . The user's who are in this group are not "Adminstrators"
> > they are  having Infra Change Manager,Task Manager,application level
> > permissions like that .
> >
> > can any one guide me am I missing any thing.
> >
> > Thanks
> >
> >
> --
> View this message in context:
> http://old.nabble.com/Using-%24GROUPS%24-like-not-showing-data-in-search-menus.can-some-guide-me-in-right-direction-tp33476035p33491582.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 ARS

Re: Using $GROUPS$ like not showing data in search menus.....can some guide me in right direction

[David Sanders]

Why not use the run process Application-Confirm-Group  to test if
they are a member of the group concerned? 

 

David Sanders

Solution Architect

Enterprise Service Suite @ Work / e-ServiceSuite 

 

tel +44 1494 468980

mobile +44 7710 377761

email david.sand...@westoverconsulting.co.uk

 

web  http://www.westoverconsulting.co.uk
 

 

http://www.e-servicesuite.co.uk
 

 




  Description:
cid:image001.gif@01CCE023.38E7E320

 


ITIL - SaaS - On Premise

 

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Ben Chernys
Sent: 13 March 2012 06:58
To: arslist@ARSLIST.ORG
Subject: Re: Using $GROUPS$ like not showing data in search menus.can
some guide me in right direction

 

** 

Hi John,

 

Interesting that you say this.

 

I saw an issue where an ITSM 6 had its ARS upgraded to 7.1 and this issue
popped up as prior to 7.1 the groups values were as you describe (but not on
every record!).  Problem was fixed with a 5 minute Meta-Update script to
update said records into the correct format.

 

Since 7.1, ARS enforces the group list fields syntax so that "%;x;%" will
work.

 

Cheers

Ben Chernys

  www.softwaretoolhouse.com

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of John Sundberg
Sent: March-13-12 03:27
To: arslist@ARSLIST.ORG
Subject: Re: Using $GROUPS$ like not showing data in search menus.can
some guide me in right direction

 

** Just wondering - what if your group is at the beginning?

 

Or - at the end..

 

$GROUPS$ like "%;100140;%" 

 

I think the above query assumes your group is in the middle of a group list?

 

So - you would have to do something like:

 

$GROUPS$ like "%;100140;%" OR $GROUPS$ like "100140;%" OR $GROUPS$
like "%;100140" 

 

I am not positive -- just mentioning.

 

I did do something similar to this recently - and I did have to consider the
case I mentioned.

 

 

-John

 

 

On Mon, Mar 12, 2012 at 8:10 PM, gok's  wrote:

I have fixed this now all the values are showing up. What i did was like
this
i have give as Jose said $GROUPS$ like "%;100140;%"
and also gave the $GROUPS$ like "%;100140;%" in menus.
it is working showing all the values.

gok's wrote:
>
> Environment ARServer 7.5 patch 4
> DB:2005 SQL
>
> I have created a simple active link for certain group like "XYZ" changes a
> search menu values to read/write only
> A.l > Display
> Qualification:$GROUPS$ like "XYZ"
> IfAction:Change Field
> Read/Write mode
>
> it is working for the group but in the search menu there are no values are
> showing up . The user's who are in this group are not "Adminstrators"
> they are  having Infra Change Manager,Task Manager,application level
> permissions like that .
>
> can any one guide me am I missing any thing.
>
> Thanks
>
>
--
View this message in context:
http://old.nabble.com/Using-%24GROUPS%24-like-not-showing-data-in-search-men
us.can-some-guide-me-in-right-direction-tp33476035p33491582.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"





 

-- 

John Sundberg

Kinetic Data, Inc.

"Your Business. Your Process."

Recipient of:
WWRUG10 Best Customer Service/Support Award

WWRUG09 Innovator of the Year Award

 

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

  www.kineticdata.com I
 community.kineticdata.com 

 

 

 

_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: BMC_GLOBAL_DEFAULT_SRVC CI

[Pat Zandi]

I love those: do not delete or remove
No reason why, no solution if you accidentally did..   Gotta love it

Sent from my iPhone

On Mar 13, 2012, at 7:17, Peter Romain  
wrote:

> Hi All,
> 
> CMDB 7.6.04 SP2
> 
> The BMC_GLOBAL_DEFAULT_SRVC CI appears in the Service field menu on the 
> Infrastructure Change form.
> 
> BMC tells us that this CI should never be deleted.
> 
> Does anyone know precisely what it is for? I guess it's to do with the 
> Service Catalog functionality in  Atrium Core.
> 
> I can set the status of this CI from its out-of-the-box value of 'Ordered' to 
> 'End of Life' to remove it from the menu but would this affect the 
> functionality that the CI is there to support?
> 
> Cheers
> 
> Peter
> 
> ___
> 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"

BMC_GLOBAL_DEFAULT_SRVC CI

[Peter Romain]

Hi All,

CMDB 7.6.04 SP2

The BMC_GLOBAL_DEFAULT_SRVC CI appears in the Service field menu on the 
Infrastructure Change form.

BMC tells us that this CI should never be deleted.

Does anyone know precisely what it is for? I guess it's to do with the Service 
Catalog functionality in  Atrium Core.

I can set the status of this CI from its out-of-the-box value of 'Ordered' to 
'End of Life' to remove it from the menu but would this affect the 
functionality that the CI is there to support?

Cheers

Peter

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

Re: Where does $DATE$ come from?

[Doug Blair]

How many of us are waiting for someone to say...

$DATE$ come from $PALMTREE$

(Due to recent time zone changes it is now Friday!)

I couldn't resist, sorry. 


Doug

--
Doug Blair
Sent from my iPhone4, typographic errors likely
+1-224-558-5462

On Mar 12, 2012, at 11:28 AM, "Brittain, Mark"  wrote:

> **
> Hi All,
>  
> Where does the $DATE$ function get the date/time information, the OS server 
> or the database server. This may seem like a strange question but yesterday I 
> had a case where $TIMESTAMP$ was work correctly and diary field entries were 
> correct but the $DATE$ was on hour behind as 3/10/2012 23:00:00 PM. Strangely 
> today, it working correctly as  3/12/2012 00:00:00 AM
>  
> ARS 6.3 patch 20
> SunOS 5.9
> Oracle 9.2
>  
> Thanks
> Mark
>  
> Mark Brittain
> Remedy Developer
> ITILv3 Foundation
> NaviSite – A Time Warner Cable Company
> mbritt...@navisite.com
> Office: 315-453-2912 x5335
> Mobile: 315-317-2897
>  
> 
> This e-mail is the property of NaviSite, Inc. It is intended only for the 
> person or entity to which it is addressed and may contain information that is 
> privileged, confidential, or otherwise protected from disclosure. 
> Distribution or copying of this e-mail, or the information contained herein, 
> to anyone other than the intended recipient is prohibited.
> _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: Remedy 7.6.04 - BRIE Timeouts

[Michael Burton]

Hi, We get something along those lines when rebuilding service targets. The 
only way out of it is to restart arserver and then tomcat. However, we have 
found that if we shutdown tomcat on our first (admin) server and then trigger 
the rebuilds from the other server, we don't see the timeout issues. This seems 
to be the least disruptive way of maintaining a service to our users, but its 
far from ideal.  Regards -Mike   > Date: Mon, 12 Mar 2012 15:34:40 -0400
> From: christopher.j.wil...@stls.frb.org
> Subject: Remedy 7.6.04 - BRIE Timeouts
> To: arslist@ARSLIST.ORG
> 
> We are implementing new 7.6.04 SP2 environments and we seem to experience 
> BRIE timeouts sporatically on our ARS servers. The timeouts seem to be 
> triggered by user activity, however, it does not take much activity to 
> activate the timeouts. When timeouts are experieced, current users experience 
> an hourglass and new users cannot login. Once the timeouts start, we must 
> recycle the application server(s) experiencing the issue to restore service. 
> We are experiencing this issue in our DEV, QA and PROD 7.6.04 environments. 
> Anyone else experiencing this issue? We are also running ARS 7.5 Patch 6 with 
> no timeout issues. 
> 
> Thanks,
> 
> Chris Wilson
> 
> ___
> 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: ITSM 7.6.03 OTB forms that begin with CTM:Ppl% or CTM:PPL%

[Ben Chernys]

For the 7.6.04 list, I refer you to Software Tool House’s Freebies page:  
www.softwaretoolhouse.com

 

For 7.6.03 or other servers, simply fill out a Meta-Update trial request, 
participate in the “Live Install” service and presentation (under 1 hr.), and 
then generate the form and field spreadsheets for your ARS server (which will 
include your customisations).

 

>From the posting to the list of Tue, 2012-Feb-21:

 

Hi Folks,

 

A lot of you have asked for fields and labels of ITSM.  To help out, we’re 
offering a free Excel 2010 Spreadsheet taken from a Pre-configured Stack 
Installed ITSM 7.6.04.  

 

As you all know, ITSM is big, some 235,000 fields.   We’ve made the original 
CSV files  also available to you.  This will allow you to take slices (say by 
form name or prefix) when you are running previous Excel releases.  
Instructions for this are included.

 

Please check out the new “Freebies” section of our web
 www.softwaretoolhouse.com  and get the ITSM 
7.6.04 Schema and Fields spreadsheet.

 

The spreadsheet was generated using Meta-Schema with the English locale and 
selecting the Default Views for the field labels.  

Field labels are used in Queries and are view dependent.  All Meta-Update 
utilities accept ARS Field Names as well as labels and ids in query 
qualifications.  There are duplicates as well as fields not in view.

 

Meta-Schema is bundled with Meta-Update.  If you want to run the utility 
against your server, please request a Meta-Update trial.

 

We sincerely hope you use and this spreadsheet.

 

Cheers

Ben Chernys
Senior Software Architect
Description: Description: logoSthInc-sm  

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

Check out Software Tool House's free Diary Editor.

Meta-Update, our premium ARS Data tool, lets you automate 
your imports, migrations, in no time at all, without programming, 
without staging forms, without merge workflow. 
  http://www.softwaretoolhouse.com/  

 

 

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of patchsk
Sent: March-13-12 08:15
To: arslist@ARSLIST.ORG
Subject: Re: ITSM 7.6.03 OTB forms that begin with CTM:Ppl% or CTM:PPL%

 

** Here is the list from ITSM 7.6.03p002

 

CTM:PPL-SptGrpAssoc-ITSkills

CTM:PPL-SptGrpFuncRole-ITSkills

CTM:PPLSupptGrpAscFcnRoleLkUp

CTM:Ppl Search-PermissionGrp

CTM:Ppl Search-SupportGrpAssoc

CTM:Ppl Search-SupportGrpFuncR   

CTM:Ppl Search-Worklog

CTM:PplPermissionSupGrpFuncRoleJoin

CTM:PplPermissionSupGrpJoin



CTM:People

CTM:People Attachments

CTM:People Attributes

CTM:People Audit 

CTM:People Benefit Info   

CTM:People Education  

CTM:People HR Attendance Mgmt   

CTM:People HR Time Management  

CTM:People IT Skills 

CTM:People LookUp 

CTM:People Management Console

CTM:People Organization  

CTM:People Organization Search  

CTM:People Permission Groups

CTM:People Profile

CTM:People Search

CTM:People Search-Supp. Staff

CTM:People Template

CTM:People Template NTE   

CTM:People Template PG  

CTM:People Template SG  

CTM:People Template SG Lookup

CTM:People Travel Profile

CTM:People Wallet

CTM:People WorkLog

CTM:PeopleITSkillsJoin

CTM:PeoplePermissionGrpUnique

CTM:PeoplePermissionJoin

CTM:PeoplePermissionJoin_PMC

CTM:PeopleSelfJoin

CTM:PeopleSyncConsole

CTM:PeopleUser

CTM:PeopleUserSupportGroupFunctionalRole

CTM:People_Template_Child

CTM:People_Template_SFR

CTM:People_Template_SFR_Lookup


On Monday, March 12, 2012 4:17:37 PM UTC-5, Joe Martin D'Souza wrote:

** 

 

I do not have a vanilla system to compare our moderately customized system with 
and I know for a fact there are some new custom forms created for integration 
purposes to LDAP, that begin with CTM:PPL and although for the most part the 
past developers have post fixed new custom forms with the abbreviation of the 
site name, I do not want to assume that’s been the case consistently..

 

So could someone help me with a list of all forms that begin with CTM:Ppl or 
CTM:PPL that are out of the box??

 

Joe

_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: ITSM 7.6.03 OTB forms that begin with CTM:Ppl% or CTM:PPL%

[patchsk]

Here is the list from ITSM 7.6.03p002

CTM:PPL-SptGrpAssoc-ITSkills
CTM:PPL-SptGrpFuncRole-ITSkills
CTM:PPLSupptGrpAscFcnRoleLkUp
CTM:Ppl Search-PermissionGrp
CTM:Ppl Search-SupportGrpAssoc 
CTM:Ppl Search-SupportGrpFuncR 
CTM:Ppl Search-Worklog
CTM:PplPermissionSupGrpFuncRoleJoin
CTM:PplPermissionSupGrpJoin

CTM:People
CTM:People Attachments
CTM:People Attributes
CTM:People Audit 
CTM:People Benefit Info 
CTM:People Education 
CTM:People HR Attendance Mgmt 
CTM:People HR Time Management 
CTM:People IT Skills 
CTM:People LookUp 
CTM:People Management Console
CTM:People Organization 
CTM:People Organization Search 
CTM:People Permission Groups
CTM:People Profile
CTM:People Search
CTM:People Search-Supp. Staff 
CTM:People Template 
CTM:People Template NTE 
CTM:People Template PG 
CTM:People Template SG 
CTM:People Template SG Lookup
CTM:People Travel Profile
CTM:People Wallet
CTM:People WorkLog
CTM:PeopleITSkillsJoin
CTM:PeoplePermissionGrpUnique
CTM:PeoplePermissionJoin
CTM:PeoplePermissionJoin_PMC
CTM:PeopleSelfJoin
CTM:PeopleSyncConsole
CTM:PeopleUser
CTM:PeopleUserSupportGroupFunctionalRole
CTM:People_Template_Child
CTM:People_Template_SFR
CTM:People_Template_SFR_Lookup

On Monday, March 12, 2012 4:17:37 PM UTC-5, Joe Martin D'Souza wrote:
>
> ** 
>   
> I do not have a vanilla system to compare our moderately customized system 
> with and I know for a fact there are some new custom forms created for 
> integration purposes to LDAP, that begin with CTM:PPL and although for the 
> most part the past developers have post fixed new custom forms with the 
> abbreviation of the site name, I do not want to assume that’s been the case 
> consistently..
>  
> So could someone help me with a list of all forms that begin with CTM:Ppl 
> or CTM:PPL that are out of the box??
>  
> Joe
> _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"