Re: Floating License Estimation - rule of thumb or formula

[Mauricio M.]

Hi Misi,
But in your experience how do you do when it is for budgeting purposes,
these are custom applications that have not been used before and they need
to provision the licenses needed for the future load ... you say the only
way to have a number close to reality is based only in previous usage
analysis?
Regards,
Mauricio

2012/6/28 Misi Mladoniczky 

> Hi,
>
> I would say that there is no rule of thumb.
>
> Even if you have historical data, you could come up with 5:1 or 1:5, all
> depending how your system is used.
>
> One days worth of data will give you some information, and one week will
> give you a very good estimate.
>
> You can even try the free version of RRR|License, and it will tell you the
> ratio that is optimum for you. You can even use the change planner in the
> test version, where you can put in a future number of expected users:
> http://rrr.se/tmp/rrrLicChangePlanner.html
>
>Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>
> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
> Find these products, and many free tools and utilities, at http://rrr.se.
>
> > Hi Jose,
> >
> > So in order to simplify a model, don´t you think you can compare this
> > distribution to the behaviour of ocassional users logging in and updating
> > records? because RRRLicense measures over a period of time and I do not
> > have historical data and no window frame to measure from this present
> time
> > into the future
> >
> > Thank you!!!
> >
> > Mauricio
> >
> > 2012/6/28 Jose Huerta 
> >
> >> ** Erlang formulas assume Poisson distribution. Your team won't be
> >> distributed in any computable wat. So I recommend you to study the use.
> >> Maybe you can try the RRR|License tool.
> >>
> >> 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 Thu, Jun 28, 2012 at 9:23 PM, Mauricio M. 
> >> wrote:
> >>
> >>> ** Hello All,
> >>>
> >>>
> >>> I know this is and old age question but it continues to be relevant on
> >>> how you estimate the appropiate number of floating licenses that will
> >>> be
> >>> needed in the near future for a given application, but not taking into
> >>> account any past behaviour, I mean, suppose that we do not have
> >>> historical
> >>> data to reference, but only an expected behaviour in regards to a total
> >>> number of users, total number of tickets, etc. As a rule of thumb we
> >>> might
> >>> use a given proportion, 3:1 or 5:1 but how you normally manage to hold
> >>> up a
> >>> more solid number? I was wondering if anyone has used Erlang formulas
> >>> to
> >>> get a more solid number?
> >>>
> >>> Thank you and Regards,
> >>>
> >>> -Mauricio
> >>> _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"
> >
>
>
> ___
> 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: Form Field missing in Web Reports Designer

[Ray Palla]

Just to clarify... the field is on the Report Designer in ITSM 7.6.04, and
is a table field with a list of reportable fields for selection... it is
not, as in older versions, a character field with a menu attached.
 
Thanks;
R

  _  

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of ITSM.Support
Sent: Thursday, June 28, 2012 11:40 AM
To: arslist@ARSLIST.ORG
Subject: Re: Form Field missing in Web Reports Designer


** 

Hi,

In background we have a field on "AR System Report Console" form, named
"Form Name", on which run time form name is populated after selecting value
in "Report Name" field.

For populating fields, we have data dictionary menu attached to different
fields.

(e.g. Field1, Field2 etc) Fields which are getting populated in the list are
only "data fields". For other fields we need to select the check boxes of
the menu. 

HTH

--

Regards,

ITSM Support

 

Vyom Labs Pvt. Ltd.

BSM Solutions & Services || ITIL Consulting & Training

Email: i...@vyomlabs.com  || Web Site: www.vyomlabs.com Follow Vyom Labs
http://twitter.com/#!/vyomlabs || http://www.linkedin.com/company/vyom-labs

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Ray Palla
Sent: Wednesday, June 27, 2012 2:33 AM
To: arslist@ARSLIST.ORG
Subject: Form Field missing in Web Reports Designer

 

** 

Listers;

We've created a custom char field in the CHG:Infrastructure Change form.
Permissions are correct for usage, read/write, and visibility. When creating
or editing a Web report from the AR System Report Console (Report Designer)
the new field is not visible or selectable.

Is there a form controlling this Available field list tables in the
Designer?  How can we get the new field to display as a selectable column in
Reports?

Odd thing, the field is available for AR System reports.

R

 


Ray Palla
Sr. IT/Remedy Consultant 







Mobile: 512-917-1739
Time Zone: Central

Email:   ray.pa...@insona.com
 Professional Profile  

  INSONA Corporation
1201 Berry Lane
 
Georgetown, TX

78626-3832 USA
Infrastructure Solutions - Network Applications 


 



 

_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: Form Field missing in Web Reports Designer

[Ray Palla]

So, I'm reading your post over-and-over.  I'm sure you are trying to help,
however I'm just not getting the gist.
 
The field that is missing in our Selection List in Report Designer is a
"data field" and it is otherwise functioning exactly correctly.  We have
other identical custom fields that do show up in the Designer list, but for
some reason with this new one, there seems to be a limit on how many custom
fields we can create or report on in a Web style report.
 
What do you mean by "select the check boxes of the menu"?
 
Are you saying that the Designer's available fields list is built before the
Designer screen opens?  Where is that created... a hidden field?
 
Thanks;
R

  _  

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of ITSM.Support
Sent: Thursday, June 28, 2012 11:40 AM
To: arslist@ARSLIST.ORG
Subject: Re: Form Field missing in Web Reports Designer


** 

Hi,

In background we have a field on "AR System Report Console" form, named
"Form Name", on which run time form name is populated after selecting value
in "Report Name" field.

For populating fields, we have data dictionary menu attached to different
fields.

(e.g. Field1, Field2 etc) Fields which are getting populated in the list are
only "data fields". For other fields we need to select the check boxes of
the menu. 

HTH

--

Regards,

ITSM Support

 

Vyom Labs Pvt. Ltd.

BSM Solutions & Services || ITIL Consulting & Training

Email: i...@vyomlabs.com  || Web Site: www.vyomlabs.com Follow Vyom Labs
http://twitter.com/#!/vyomlabs || http://www.linkedin.com/company/vyom-labs

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Ray Palla
Sent: Wednesday, June 27, 2012 2:33 AM
To: arslist@ARSLIST.ORG
Subject: Form Field missing in Web Reports Designer

 

** 

Listers;

We've created a custom char field in the CHG:Infrastructure Change form.
Permissions are correct for usage, read/write, and visibility. When creating
or editing a Web report from the AR System Report Console (Report Designer)
the new field is not visible or selectable.

Is there a form controlling this Available field list tables in the
Designer?  How can we get the new field to display as a selectable column in
Reports?

Odd thing, the field is available for AR System reports.

R

 


Ray Palla
Sr. IT/Remedy Consultant 







Mobile: 512-917-1739
Time Zone: Central

Email:   ray.pa...@insona.com
 Professional Profile  

  INSONA Corporation
1201 Berry Lane
 
Georgetown, TX

78626-3832 USA
Infrastructure Solutions - Network Applications 


 



 


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

Re: Paging and Notification Applications

[Peters, Ron]

We don't have pagers but use cell phones. People records have the "Pager 
Email+" field where you can put the email address of the phone. At least some 
pagers have the same type of email access. I then setup blat (Linux/UNIX likely 
wouldn't require a separate mail program) for the pager configuration to simply 
send an email to the device instead of using a pager application.

Ron

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Barbour, Brandi D
Sent: Thursday, June 28, 2012 1:39 PM
To: arslist@ARSLIST.ORG
Subject: Paging and Notification Applications

**
We are looking for a Automated Paging/Notification application.  Does anyone 
use anything other than xMatters Alarmpoint for this?  We love that product 
however have been asked to investigate what else is out there.  If there 
happens to be any freeware that could meet this need that would be even better. 
 :)
Thanks,
Brandi


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

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

Re: Paging and Notification Applications

[Shellman, David]

We use TelAlert.

Dave

On Jun 28, 2012, at 4:39 PM, "Barbour, Brandi D" 
mailto:bdbar...@jcp.com>> wrote:

**
We are looking for a Automated Paging/Notification application.  Does anyone 
use anything other than xMatters Alarmpoint for this?  We love that product 
however have been asked to investigate what else is out there.  If there 
happens to be any freeware that could meet this need that would be even better. 
 ☺
Thanks,
Brandi


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

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

Re: Floating License Estimation - rule of thumb or formula

[Misi Mladoniczky]

Hi,

I would say that there is no rule of thumb.

Even if you have historical data, you could come up with 5:1 or 1:5, all
depending how your system is used.

One days worth of data will give you some information, and one week will
give you a very good estimate.

You can even try the free version of RRR|License, and it will tell you the
ratio that is optimum for you. You can even use the change planner in the
test version, where you can put in a future number of expected users:
http://rrr.se/tmp/rrrLicChangePlanner.html

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

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

> Hi Jose,
>
> So in order to simplify a model, don´t you think you can compare this
> distribution to the behaviour of ocassional users logging in and updating
> records? because RRRLicense measures over a period of time and I do not
> have historical data and no window frame to measure from this present time
> into the future
>
> Thank you!!!
>
> Mauricio
>
> 2012/6/28 Jose Huerta 
>
>> ** Erlang formulas assume Poisson distribution. Your team won't be
>> distributed in any computable wat. So I recommend you to study the use.
>> Maybe you can try the RRR|License tool.
>>
>> 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 Thu, Jun 28, 2012 at 9:23 PM, Mauricio M. 
>> wrote:
>>
>>> ** Hello All,
>>>
>>>
>>> I know this is and old age question but it continues to be relevant on
>>> how you estimate the appropiate number of floating licenses that will
>>> be
>>> needed in the near future for a given application, but not taking into
>>> account any past behaviour, I mean, suppose that we do not have
>>> historical
>>> data to reference, but only an expected behaviour in regards to a total
>>> number of users, total number of tickets, etc. As a rule of thumb we
>>> might
>>> use a given proportion, 3:1 or 5:1 but how you normally manage to hold
>>> up a
>>> more solid number? I was wondering if anyone has used Erlang formulas
>>> to
>>> get a more solid number?
>>>
>>> Thank you and Regards,
>>>
>>> -Mauricio
>>> _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"
>

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

Paging and Notification Applications

[Barbour, Brandi D]

We are looking for a Automated Paging/Notification application.  Does
anyone use anything other than xMatters Alarmpoint for this?  We love
that product however have been asked to investigate what else is out
there.  If there happens to be any freeware that could meet this need
that would be even better.  J

Thanks,

Brandi

 

The information transmitted is intended 
only for the person or entity to which it is addressed and may contain 
confidential and/or privileged material. If the reader of this message is not 
the intendedrecipient, you are hereby notified that your access is 
unauthorized, and any review, dissemination,distribution or copying of this 
message including any attachments is strictly prohibited. If you are notthe 
intended recipient, please contact the sender and delete the material from any 
computer.

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

Re: Floating License Estimation - rule of thumb or formula

[Shellman, David]

Mauricio,

With out data you can only make a guess.  We are a world wide organization 
using one AR System server.  We have found that there are many factors that 
influence license utilization.  Most of our users are US based but there is 
also a large number of others outside the US.

Here are factors that we found influence out peak utilization:
Time of day - we see peaks utilization between 9:00 AM and 11:00 AM Eastern
Holidays - peaks are lower during a holiday as expected.  However peaks can be 
higher before and after a holiday.  Additional consideration is EMEA holidays 
which are different than US bank holidays
Maintenance weekend - often see higher usage peaks after a maintenance weekend.
First of the month - Higher usage peaks at the beginning of the month.  Due to 
change freezes at the end of the month to avoid month end.
Day of the week - Higher usage peaks at the beginning of the week than at the 
end of the week.

Dave


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mauricio M.
Sent: Thursday, June 28, 2012 3:46 PM
To: arslist@ARSLIST.ORG
Subject: Re: Floating License Estimation - rule of thumb or formula

** Hi Jose,

So in order to simplify a model, don´t you think you can compare this 
distribution to the behaviour of ocassional users logging in and updating 
records? because RRRLicense measures over a period of time and I do not have 
historical data and no window frame to measure from this present time into the 
future

Thank you!!!

Mauricio

2012/6/28 Jose Huerta 
mailto:jose.hue...@sm2baleares.es>>
** Erlang formulas assume Poisson distribution. Your team won't be distributed 
in any computable wat. So I recommend you to study the use. Maybe you can try 
the RRR|License tool.

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 Thu, Jun 28, 2012 at 9:23 PM, Mauricio M. 
mailto:mau.rem...@gmail.com>> wrote:
** Hello All,


I know this is and old age question but it continues to be relevant on how you 
estimate the appropiate number of floating licenses that will be needed in the 
near future for a given application, but not taking into account any past 
behaviour, I mean, suppose that we do not have historical data to reference, 
but only an expected behaviour in regards to a total number of users, total 
number of tickets, etc. As a rule of thumb we might use a given proportion, 3:1 
or 5:1 but how you normally manage to hold up a more solid number? I was 
wondering if anyone has used Erlang formulas to get a more solid number?

Thank you and Regards,

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

_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: Floating License Estimation - rule of thumb or formula

[Mauricio M.]

Hi Jose,

So in order to simplify a model, don´t you think you can compare this
distribution to the behaviour of ocassional users logging in and updating
records? because RRRLicense measures over a period of time and I do not
have historical data and no window frame to measure from this present time
into the future

Thank you!!!

Mauricio

2012/6/28 Jose Huerta 

> ** Erlang formulas assume Poisson distribution. Your team won't be
> distributed in any computable wat. So I recommend you to study the use.
> Maybe you can try the RRR|License tool.
>
> 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 Thu, Jun 28, 2012 at 9:23 PM, Mauricio M.  wrote:
>
>> ** Hello All,
>>
>>
>> I know this is and old age question but it continues to be relevant on
>> how you estimate the appropiate number of floating licenses that will be
>> needed in the near future for a given application, but not taking into
>> account any past behaviour, I mean, suppose that we do not have historical
>> data to reference, but only an expected behaviour in regards to a total
>> number of users, total number of tickets, etc. As a rule of thumb we might
>> use a given proportion, 3:1 or 5:1 but how you normally manage to hold up a
>> more solid number? I was wondering if anyone has used Erlang formulas to
>> get a more solid number?
>>
>> Thank you and Regards,
>>
>> -Mauricio
>> _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: Floating License Estimation - rule of thumb or formula

[Jose Huerta]

Erlang formulas assume Poisson distribution. Your team won't be distributed
in any computable wat. So I recommend you to study the use. Maybe you can
try the RRR|License tool.

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 Thu, Jun 28, 2012 at 9:23 PM, Mauricio M.  wrote:

> ** Hello All,
>
> I know this is and old age question but it continues to be relevant on how
> you estimate the appropiate number of floating licenses that will be needed
> in the near future for a given application, but not taking into account any
> past behaviour, I mean, suppose that we do not have historical data to
> reference, but only an expected behaviour in regards to a total number of
> users, total number of tickets, etc. As a rule of thumb we might use a
> given proportion, 3:1 or 5:1 but how you normally manage to hold up a more
> solid number? I was wondering if anyone has used Erlang formulas to get a
> more solid number?
>
> Thank you and Regards,
>
> -Mauricio
> _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: Issue in opening a display only form

[Jose Huerta]

Can you explain us why do you need that quantity of fields? Just curiosity.

To show a lot of info?
To use them as variables in code?
...

Regards,
Jose Huerta
http://theremedyforit.com/



On Thu, Jun 28, 2012 at 8:15 PM, Misi Mladoniczky  wrote:

> Hi,
>
> I agree with Susan. Maybe your design is a little bit flawed, and you can
> do this in another way?
>
> In any event, I still think you should do a Save-As on your form, and try
> to open the new form. Did that work?
>
> The second thing would be to delete field. That should be quick enough if
> you multiselect with the lasso.
>
>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 you've probably generated some curiosity  with this issue.  I
> have
> > data forms with maybe 600 fields and other developers often express
> > negative opinions about that.  I understand yours is a display form, but
> > what are these fields for?  That is alot of fields!
> >
> > Susan
> >
> > On Thu, Jun 28, 2012 at 8:33 AM, Sreenivas  wrote:
> >
> >> Thanks Misi for quick response.
> >>
> >> We are trying by deleting recently added fields but there are 500
> >> fields added in this week. Till now it is not yet getting opened in
> >> user tool.
> >>
> >> Any other ideas please
> >>
> >> Is it really an issue if we have high number fields? We need to add
> >> more fields on this form. it may cross 5k fields also.
> >>
> >> Regars,
> >> Sreenivas
> >>
> >>
> >>
> >> On 6/28/12, Misi Mladoniczky  wrote:
> >> > Hi,
> >> >
> >> > Make a copy of the form (save as) and try that one.
> >> >
> >> > If it does not work, remove half the fields and try that.
> >> >
> >> > That is a rather high number of fields...
> >> >
> >> > 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
> >> .
> >> >
> >> >> Dear All,
> >> >>
> >> >> We have 3844 fields on a display-only form. Does it cause any issue
> >> >> while opening a form in user tool. It is working fine in thin client
> >> >> however when we open the same form in thick client, window gets
> >> >> freezed. Any idea why it is not working in user tool.
> >> >>
> >> >> Environment:
> >> >> ARS Server - 7.0.1
> >> >> User Tool- 7.0.1
> >> >> Oracle 10g
> >> >>
> >> >>
> >> >> Regards,
> >> >> Sreenivas
> >> >>
> >> >>
> >>
> ___
> >> >> 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"
> >
>
>
> ___
> 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"

Floating License Estimation - rule of thumb or formula

[Mauricio M.]

Hello All,

I know this is and old age question but it continues to be relevant on how
you estimate the appropiate number of floating licenses that will be needed
in the near future for a given application, but not taking into account any
past behaviour, I mean, suppose that we do not have historical data to
reference, but only an expected behaviour in regards to a total number of
users, total number of tickets, etc. As a rule of thumb we might use a
given proportion, 3:1 or 5:1 but how you normally manage to hold up a more
solid number? I was wondering if anyone has used Erlang formulas to get a
more solid number?

Thank you and Regards,

-Mauricio

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

Re: Can remedy code push cause DB crash, etc?

[Raj]

Our DBA mentioned that:
DB can accommodate up to 750 oracle processes per DB instances.

So, how does this number relates to the Server Ports and Queues we have 
configured.
Any recommendations?

Even the last time, issue was encountered in this specific form only.
This form has many table fields ~15 and overall fields count ~400.
(Basically, this is a heavily customized form but not as much as our HPD 
form)

On Thursday, June 28, 2012 11:35:09 AM UTC-7, Raj wrote:
>
> Sorry! Screenshot didn't work.
> Here is the information again:
> Type/RPC/Min/Max
> Admin / 390600 / 1/ 1
> Fast / 390620 / 20 / 50
> List / 390635 / 20 / 50
> Private / 390623 / 1 / 1
> Private / 390624 / 1 / 1
> Private / 390680 / 1 / 1
> Private / 390694 / 1 / 1
>
> On Thursday, June 28, 2012 11:29:00 AM UTC-7, Raj wrote:
>>
>> ** Thanks Fred for your prompt reply.
>> I checked the Server Ports and Queues settings:
>>
>> reaching out to DBA to check "how many connections and processes the 
>> database (and database O/S for the user the database runs under) is 
>> configured for." as you suggested.
>> Will let you know my findings.
>>
>> On Thursday, June 28, 2012 11:02:13 AM UTC-7, Grooms, Frederick W wrote:
>>>
>>> ** 
>>>  
>>> Let me make sure I have the facts from your earlier email in the chain …  
>>>
>>>
>>>Server : 5.01.02 Patch 1313   
>>>Hardware : sun4u   
>>>OS: SunOS 5.10   
>>>DB: SQL -- Oracle   
>>>DB Version : 10.2.0.5.0 - 64bit   
>>>
>>> And since it is ARS version 5 you are using the Oracle 8 client.
>>>
>>> Since the DBA said processes reached the threshold you should ask the 
>>> DBA how many connections and processes the database (and database O/S for 
>>> the user the database runs under) is configured for.
>>>
>>> If the number of connections and processes is less than the max number 
>>> of threads you have configured (Fast, List, Escalation, Admin, Private, …) 
>>> you will need to increase the number on the database or reduce the max 
>>> number on the ARS server.
>>>
>>>  
>>>
>>> If I remember correctly ARS always dropped the view and created a new 
>>> one when database field names were changed or added (the table uses the 
>>> field IDs and there is a database view that has the names).  Remedy 
>>> doesn’t do anything with the view itself, it is created just to make 
>>> outside querying of the data easier.   
>>>
>>>  
>>>
>>> Fred
>>>
>>>  
>>>
>>>  
>>>
>>> -Original Message- 
>>> *From:* Action Request System discussion list(ARSList) [mailto:
>>> arslist@ARSLIST.ORG] *On Behalf Of *Axton
>>> *Sent:* Thursday, June 28, 2012 12:35 PM
>>> *To:* arslist@ARSLIST.ORG
>>> *Subject:* Re: Can remedy code push cause DB crash, etc?
>>>
>>>  
>>>
>>> ** From https://forums.oracle.com/forums/thread.jspa?threadID=364644
>>>  
>>>  
>>>  
>>>  Oracle finally admit there was a bug: BUG 5607984 - ORACLE DOES NOT 
>>> CLOSE TCP CONNECTIONS. REMAINS IN CLOSE_WAIT STATE. [On Windows 32-bit].
>>>  
>>>  
>>>  
>>> The patch 10 (patch number 5639232) is supposed to solve the problem for 
>>> 10.2.0.2.0. We applied it monday morning and everything is fine up to now.
>>>  
>>>  
>>>  
>>> This bug is also supposed to be solved in the 10.2.0.3.0 patchset that 
>>> is availlable on the Metalink site.
>>>  
>>>  
>>> Do you happen to be running Oracle on a Windows 32-bit server?
>>>  
>>> -Original Message- 
>>> On Thu, Jun 28, 2012 at 11:55 AM, Raj  wrote:
>>>
>>> ** Thank everyone for their help.
>>>
>>> Last night we experienced the same issue again.
>>> Added a new field to the form and modified DB name of the 4 fields and 
>>> hit save.
>>> System froze and users started getting ARERR 94.
>>> When checked arerror.log, noticed the following entries:
>>>
>>> Wed Jun 27 21:54:13 2012  390635 : Failure while trying to connect to 
>>> the SQL database.
>>>  
>>>
>>> Please ensure the SQL database is running or contact the Database 
>>> Administrator for help (ARERR 550)
>>>  
>>> Wed Jun 27 21:54:13 2012 ORA-12535: TNS:operation timed out
>>> Wed Jun 27 21:54:13 2012  390635 : Cannot initialize contact with SQL 
>>> database (ARERR 551)
>>> Wed Jun 27 21:54:13 2012 Thread 63 not handling connection
>>>
>>> DBA mentioned that the processes on DB instances reached the threshold. 
>>> The server/DB became unresponsive. When we looked in the DB, the view 
>>> (for the form I was trying to modify) was missing in Production.
>>> So, looks like the Save operation on the form never completed. We had to 
>>> bounce the DB instances and AR Server.
>>> After that We had to manually copy the view DDL from our QA environment 
>>> and modify it for Prod and run it to enable the view to compile and other 
>>> related views to compile.
>>>
>>> Could anyone throw some light what might have happened and how we can 
>>> avoid this in future to avoid any impact to customers.
>>>
>>>
>>> Here's the environment info:
>>>  
>>>
>>> Server : 5.01.02 Patch 1313
>>> Hardware : sun4u
>>> OS: SunOS 5.10
>>> DB: 

Re: Web Service questions

[Joe Martin D'Souza]

No problem. Glad I was of some help. Fred has given some good tips about 
setting your logging level. That is useful as you need to know as much as is 
possible in case of errors.


Tools like Notepad++ would be useful as XML editors, while SoapUI or 
SoapSonar are some useful tools that may come handy to view the WSDL and the 
format of the envelopes it requires. These are free tools..


Notepad++ has a few available downloadable plugins to convert XML to text 
and text to XML etc. which would also be useful in debugging your filter def 
files in case of issues..


Joe

-Original Message- 
From: Sean O'Sullivan
Sent: Thursday, June 28, 2012 1:40 PM Newsgroups: 
public.remedy.arsystem.general

To: arslist@ARSLIST.ORG
Subject: Re: Web Service questions

Many Thanks Joe,

Yeah...I have the integration guide right here with a paperclip on that 
page.


What you said about the logs makes sense, I spent some time yesterday 
looking at the mid-tier log and turning on and off the Web Service 
logging.wondering why no errors were showing up.


Thanks for your helpand also thanks to the others who responded.

Sean O 


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

Re: Can remedy code push cause DB crash, etc?

[Raj]

Sorry! Screenshot didn't work.
Here is the information again:
Type/RPC/Min/Max
Admin / 390600 / 1/ 1
Fast / 390620 / 20 / 50
List / 390635 / 20 / 50
Private / 390623 / 1 / 1
Private / 390624 / 1 / 1
Private / 390680 / 1 / 1
Private / 390694 / 1 / 1

On Thursday, June 28, 2012 11:29:00 AM UTC-7, Raj wrote:
>
> ** Thanks Fred for your prompt reply.
> I checked the Server Ports and Queues settings:
>
> reaching out to DBA to check "how many connections and processes the 
> database (and database O/S for the user the database runs under) is 
> configured for." as you suggested.
> Will let you know my findings.
>
> On Thursday, June 28, 2012 11:02:13 AM UTC-7, Grooms, Frederick W wrote:
>>
>> ** 
>>  
>> Let me make sure I have the facts from your earlier email in the chain …  
>>
>>
>>Server : 5.01.02 Patch 1313   
>>Hardware : sun4u   
>>OS: SunOS 5.10   
>>DB: SQL -- Oracle   
>>DB Version : 10.2.0.5.0 - 64bit   
>>
>> And since it is ARS version 5 you are using the Oracle 8 client.
>>
>> Since the DBA said processes reached the threshold you should ask the DBA 
>> how many connections and processes the database (and database O/S for the 
>> user the database runs under) is configured for.
>>
>> If the number of connections and processes is less than the max number of 
>> threads you have configured (Fast, List, Escalation, Admin, Private, …) you 
>> will need to increase the number on the database or reduce the max number 
>> on the ARS server.
>>
>>  
>>
>> If I remember correctly ARS always dropped the view and created a new one 
>> when database field names were changed or added (the table uses the field 
>> IDs and there is a database view that has the names).  Remedy doesn’t do 
>> anything with the view itself, it is created just to make outside querying 
>> of the data easier.   
>>
>>  
>>
>> Fred
>>
>>  
>>
>>  
>>
>> -Original Message- 
>> *From:* Action Request System discussion list(ARSList) [mailto:
>> arslist@ARSLIST.ORG] *On Behalf Of *Axton
>> *Sent:* Thursday, June 28, 2012 12:35 PM
>> *To:* arslist@ARSLIST.ORG
>> *Subject:* Re: Can remedy code push cause DB crash, etc?
>>
>>  
>>
>> ** From https://forums.oracle.com/forums/thread.jspa?threadID=364644
>>  
>>  
>>  
>>  Oracle finally admit there was a bug: BUG 5607984 - ORACLE DOES NOT 
>> CLOSE TCP CONNECTIONS. REMAINS IN CLOSE_WAIT STATE. [On Windows 32-bit].
>>  
>>  
>>  
>> The patch 10 (patch number 5639232) is supposed to solve the problem for 
>> 10.2.0.2.0. We applied it monday morning and everything is fine up to now.
>>  
>>  
>>  
>> This bug is also supposed to be solved in the 10.2.0.3.0 patchset that is 
>> availlable on the Metalink site.
>>  
>>  
>> Do you happen to be running Oracle on a Windows 32-bit server?
>>  
>> -Original Message- 
>> On Thu, Jun 28, 2012 at 11:55 AM, Raj  wrote:
>>
>> ** Thank everyone for their help.
>>
>> Last night we experienced the same issue again.
>> Added a new field to the form and modified DB name of the 4 fields and 
>> hit save.
>> System froze and users started getting ARERR 94.
>> When checked arerror.log, noticed the following entries:
>>
>> Wed Jun 27 21:54:13 2012  390635 : Failure while trying to connect to 
>> the SQL database.
>>  
>>
>> Please ensure the SQL database is running or contact the Database 
>> Administrator for help (ARERR 550)
>>  
>> Wed Jun 27 21:54:13 2012 ORA-12535: TNS:operation timed out
>> Wed Jun 27 21:54:13 2012  390635 : Cannot initialize contact with SQL 
>> database (ARERR 551)
>> Wed Jun 27 21:54:13 2012 Thread 63 not handling connection
>>
>> DBA mentioned that the processes on DB instances reached the threshold. 
>> The server/DB became unresponsive. When we looked in the DB, the view 
>> (for the form I was trying to modify) was missing in Production.
>> So, looks like the Save operation on the form never completed. We had to 
>> bounce the DB instances and AR Server.
>> After that We had to manually copy the view DDL from our QA environment 
>> and modify it for Prod and run it to enable the view to compile and other 
>> related views to compile.
>>
>> Could anyone throw some light what might have happened and how we can 
>> avoid this in future to avoid any impact to customers.
>>
>>
>> Here's the environment info:
>>  
>>
>> Server : 5.01.02 Patch 1313
>> Hardware : sun4u
>> OS: SunOS 5.10
>> DB: SQL -- Oracle
>> DB Version : 0.2.0.5.0 - 64bi
>>  
>> Thank you, Raj
>>  
>>
>> -Original Message- 
>> On Friday, March 30, 2012 1:14:40 PM UTC-7, Joe Martin D'Souza wrote:
>>
>> Yes in my previous email I was talking about the /tmp directory on the OS 
>> and files created there too.. The files created there are done by AR 
>> process 
>> that are a result of an operation from a client.. in your case the client 
>> was a import operation from the DS (the new toy for us adults from 
>> Remedyville).
>>
>> I do no think in this case its your TEMP database which we thought it may 
>> be 
>> earlier. You

Re: .PNG screenshots

[Ibbi]

Ya I just opened a ticket so let's see what happens. 

Sent from my iPhone

On Jun 28, 2012, at 2:06 PM, "Poston, Lynn"  wrote:

> **
> Ahmed,
>  
> We have an issue with any incoming emails that have .png, .eml or .msg files 
> attached.  They error out every time.  I've had a ticket open with BMC 
> Support on this since 10/2010 without resolution. 
>  
> Lynn
>  
> From: Action Request System discussion list(ARSList) 
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Ahmed Sauga
> Sent: Thursday, June 28, 2012 11:48 AM
> To: arslist@ARSLIST.ORG
> Subject: .PNG screenshots
>  
> ** Hey guys,
> 
> anyone else experiencing .png files not loading in the 'screenshot' section 
> of the incident page.
> 
> It seems like all other extensions are working?
> _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: Can remedy code push cause DB crash, etc?

[Raj]

Thanks Fred for your prompt reply.
I checked the Server Ports and Queues settings:

reaching out to DBA to check "how many connections and processes the 
database (and database O/S for the user the database runs under) is 
configured for." as you suggested.
Will let you know my findings.

On Thursday, June 28, 2012 11:02:13 AM UTC-7, Grooms, Frederick W wrote:
>
> ** 
>  
> Let me make sure I have the facts from your earlier email in the chain …  
>
>Server : 5.01.02 Patch 1313   
>Hardware : sun4u   
>OS: SunOS 5.10   
>DB: SQL -- Oracle   
>DB Version : 10.2.0.5.0 - 64bit   
>
> And since it is ARS version 5 you are using the Oracle 8 client.
>
> Since the DBA said processes reached the threshold you should ask the DBA 
> how many connections and processes the database (and database O/S for the 
> user the database runs under) is configured for.
>
> If the number of connections and processes is less than the max number of 
> threads you have configured (Fast, List, Escalation, Admin, Private, …) you 
> will need to increase the number on the database or reduce the max number 
> on the ARS server.
>
>  
>
> If I remember correctly ARS always dropped the view and created a new one 
> when database field names were changed or added (the table uses the field 
> IDs and there is a database view that has the names).  Remedy doesn’t do 
> anything with the view itself, it is created just to make outside querying 
> of the data easier.   
>
>  
>
> Fred
>
>  
>
>  
>
> -Original Message- 
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Axton
> *Sent:* Thursday, June 28, 2012 12:35 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: Can remedy code push cause DB crash, etc?
>
>  
>
> ** From https://forums.oracle.com/forums/thread.jspa?threadID=364644
>  
>  
>  
>  Oracle finally admit there was a bug: BUG 5607984 - ORACLE DOES NOT 
> CLOSE TCP CONNECTIONS. REMAINS IN CLOSE_WAIT STATE. [On Windows 32-bit].
>  
>  
>  
> The patch 10 (patch number 5639232) is supposed to solve the problem for 
> 10.2.0.2.0. We applied it monday morning and everything is fine up to now.
>  
>  
>  
> This bug is also supposed to be solved in the 10.2.0.3.0 patchset that is 
> availlable on the Metalink site.
>  
>  
> Do you happen to be running Oracle on a Windows 32-bit server?
>  
> -Original Message- 
> On Thu, Jun 28, 2012 at 11:55 AM, Raj  wrote:
>
> ** Thank everyone for their help.
>
> Last night we experienced the same issue again.
> Added a new field to the form and modified DB name of the 4 fields and hit 
> save.
> System froze and users started getting ARERR 94.
> When checked arerror.log, noticed the following entries:
>
> Wed Jun 27 21:54:13 2012  390635 : Failure while trying to connect to the 
> SQL database.
>  
>
> Please ensure the SQL database is running or contact the Database 
> Administrator for help (ARERR 550)
>  
> Wed Jun 27 21:54:13 2012 ORA-12535: TNS:operation timed out
> Wed Jun 27 21:54:13 2012  390635 : Cannot initialize contact with SQL 
> database (ARERR 551)
> Wed Jun 27 21:54:13 2012 Thread 63 not handling connection
>
> DBA mentioned that the processes on DB instances reached the threshold. 
> The server/DB became unresponsive. When we looked in the DB, the view (for 
> the form I was trying to modify) was missing in Production.
> So, looks like the Save operation on the form never completed. We had to 
> bounce the DB instances and AR Server.
> After that We had to manually copy the view DDL from our QA environment 
> and modify it for Prod and run it to enable the view to compile and other 
> related views to compile.
>
> Could anyone throw some light what might have happened and how we can 
> avoid this in future to avoid any impact to customers.
>
>
> Here's the environment info:
>  
>
> Server : 5.01.02 Patch 1313
> Hardware : sun4u
> OS: SunOS 5.10
> DB: SQL -- Oracle
> DB Version : 0.2.0.5.0 - 64bi
>  
> Thank you, Raj
>  
>
> -Original Message- 
> On Friday, March 30, 2012 1:14:40 PM UTC-7, Joe Martin D'Souza wrote:
>
> Yes in my previous email I was talking about the /tmp directory on the OS 
> and files created there too.. The files created there are done by AR 
> process 
> that are a result of an operation from a client.. in your case the client 
> was a import operation from the DS (the new toy for us adults from 
> Remedyville).
>
> I do no think in this case its your TEMP database which we thought it may 
> be 
> earlier. Your DBA's information directs us to the OS. Running out of 
> volume 
> space on the where the /tmp is equally critical.
>
> Check this directory to see if there are a lot of files owned by the AR 
> System OS user after you shut down the AR System process.. It might be an 
> indication of an application level problem.. Without shutting down the 
> processes, you will be unable to delete the files that are owned by the AR 
> System OS user.. These files wil

Re: Data Management Client on Windows 7

[patrick zandi]

Folks.. When all else fails.. : go to application, right mouse properties,
compatibility tab, select xp sp3 or whatever, say ok.. and run..


On Thu, Jun 28, 2012 at 2:21 PM, Jlbess  wrote:

> I just copied everything to the Program Files\ directory and it worked
> fine after that.
>
> Jason
>
>
>
> On Jun 28, 2012, at 1:04 PM, Jamie  wrote:
>
> > Has anyone installe the Data Management Client on a Windows 7
> workstation with excel 2010?  By default the application installed in the
> 32 bit Program Files (x86) folder, and even though when I'm trying to use
> the DMT tool for foundation upload and I select the correct path to for the
> DMT install, the worksheets are not opened and converted correctly.  For
> some reason the worksheet is opened with a hard value of the DMT install
> path of /Program Files/ instead of /Program Files (x86).
> >
> > Has anyone had any luck getting the Data Management Client to work with
> Windows 7?  I tried opening a ticket with BMC and after two weeks of going
> back and forth they said it was part of the design and excel that to be
> 2003.
> >
> >
> ___
> > 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: Data Management Client on Windows 7

[Jlbess]

I just copied everything to the Program Files\ directory and it worked fine 
after that.

Jason



On Jun 28, 2012, at 1:04 PM, Jamie  wrote:

> Has anyone installe the Data Management Client on a Windows 7 workstation 
> with excel 2010?  By default the application installed in the 32 bit Program 
> Files (x86) folder, and even though when I'm trying to use the DMT tool for 
> foundation upload and I select the correct path to for the DMT install, the 
> worksheets are not opened and converted correctly.  For some reason the 
> worksheet is opened with a hard value of the DMT install path of /Program 
> Files/ instead of /Program Files (x86).
> 
> Has anyone had any luck getting the Data Management Client to work with 
> Windows 7?  I tried opening a ticket with BMC and after two weeks of going 
> back and forth they said it was part of the design and excel that to be 2003.
> 
> ___
> 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: Issue in opening a display only form

[Misi Mladoniczky]

Hi,

I agree with Susan. Maybe your design is a little bit flawed, and you can
do this in another way?

In any event, I still think you should do a Save-As on your form, and try
to open the new form. Did that work?

The second thing would be to delete field. That should be quick enough if
you multiselect with the lasso.

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 you've probably generated some curiosity  with this issue.  I have
> data forms with maybe 600 fields and other developers often express
> negative opinions about that.  I understand yours is a display form, but
> what are these fields for?  That is alot of fields!
>
> Susan
>
> On Thu, Jun 28, 2012 at 8:33 AM, Sreenivas  wrote:
>
>> Thanks Misi for quick response.
>>
>> We are trying by deleting recently added fields but there are 500
>> fields added in this week. Till now it is not yet getting opened in
>> user tool.
>>
>> Any other ideas please
>>
>> Is it really an issue if we have high number fields? We need to add
>> more fields on this form. it may cross 5k fields also.
>>
>> Regars,
>> Sreenivas
>>
>>
>>
>> On 6/28/12, Misi Mladoniczky  wrote:
>> > Hi,
>> >
>> > Make a copy of the form (save as) and try that one.
>> >
>> > If it does not work, remove half the fields and try that.
>> >
>> > That is a rather high number of fields...
>> >
>> > 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
>> .
>> >
>> >> Dear All,
>> >>
>> >> We have 3844 fields on a display-only form. Does it cause any issue
>> >> while opening a form in user tool. It is working fine in thin client
>> >> however when we open the same form in thick client, window gets
>> >> freezed. Any idea why it is not working in user tool.
>> >>
>> >> Environment:
>> >> ARS Server - 7.0.1
>> >> User Tool- 7.0.1
>> >> Oracle 10g
>> >>
>> >>
>> >> Regards,
>> >> Sreenivas
>> >>
>> >>
>> ___
>> >> 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"
>

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

Re: Web Service questions

[Grooms, Frederick W]

When developing filters that consume web services I recommend changing the 
logging level for the java plugin server to "info" (in both the 
pluginsvr/log4j_pluginsvr.xml file and the pluginsvr/log4j.xml file).  This is 
also where you define the name of the log files to use.

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sean O'Sullivan
Sent: Thursday, June 28, 2012 12:41 PM
To: arslist@ARSLIST.ORG
Subject: Re: Web Service questions

Many Thanks Joe, 

Yeah...I have the integration guide right here with a paperclip on that page.  

What you said about the logs makes sense, I spent some time yesterday looking 
at the mid-tier log and turning on and off the Web Service 
logging.wondering why no errors were showing up.  

Thanks for your helpand also thanks to the others who responded. 

Sean O 




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

Re: .PNG screenshots

[Poston, Lynn]

Ahmed,

We have an issue with any incoming emails that have .png, .eml or .msg files 
attached.  They error out every time.  I've had a ticket open with BMC Support 
on this since 10/2010 without resolution.

Lynn

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Ahmed Sauga
Sent: Thursday, June 28, 2012 11:48 AM
To: arslist@ARSLIST.ORG
Subject: .PNG screenshots

** Hey guys,

anyone else experiencing .png files not loading in the 'screenshot' section of 
the incident page.

It seems like all other extensions are working?
_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: Data Management Client on Windows 7

[Boyd, Rebecca]

I use Windows 7 Enterprise with Office 2010. I had to tinker with DMT to
get it work but don't remember exactly what I did.

On Thu, Jun 28, 2012 at 1:44 PM, Rick Phillips  wrote:

> You have to use the earlier version of Excel-I don't recall which one, but
> 2003 sounds about right.  It has nothing to do with Windows 7, but you
> can't use a recent version of Excel.
>
> rp
>
> On 6/28/2012 10:25 AM, Murnane, Phil wrote:
>
>> Jamie:
>>
>> I've never tried Excel 2007 or later -- I keep a Windows XP virtual
>> machine with Office 2003 specifically to run the DMT.
>>
>> Not much help for you, but there it is.
>>
>> --Phil
>>
>> -Original Message-
>> From: Action Request System discussion list(ARSList) [mailto:
>> arslist@ARSLIST.ORG] On Behalf Of Jamie
>> Sent: Thursday, June 28, 2012 13:04
>> To: arslist@ARSLIST.ORG
>> Subject: Data Management Client on Windows 7
>>
>> Has anyone installe the Data Management Client on a Windows 7 workstation
>> with excel 2010?  By default the application installed in the 32 bit
>> Program Files (x86) folder, and even though when I'm trying to use the DMT
>> tool for foundation upload and I select the correct path to for the DMT
>> install, the worksheets are not opened and converted correctly.  For some
>> reason the worksheet is opened with a hard value of the DMT install path of
>> /Program Files/ instead of /Program Files (x86).
>>
>> Has anyone had any luck getting the Data Management Client to work with
>> Windows 7?  I tried opening a ticket with BMC and after two weeks of going
>> back and forth they said it was part of the design and excel that to be
>> 2003.
>>
>> __**__**
>> ___
>> 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"
>



-- 
Rebecca Boyd
Application Administrator
Wake Forest University

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

Re: Data Management Client on Windows 7

[Rick Phillips]

You have to use the earlier version of Excel-I don't recall which one, 
but 2003 sounds about right.  It has nothing to do with Windows 7, but 
you can't use a recent version of Excel.


rp

On 6/28/2012 10:25 AM, Murnane, Phil wrote:

Jamie:

I've never tried Excel 2007 or later -- I keep a Windows XP virtual machine 
with Office 2003 specifically to run the DMT.

Not much help for you, but there it is.

--Phil

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Jamie
Sent: Thursday, June 28, 2012 13:04
To: arslist@ARSLIST.ORG
Subject: Data Management Client on Windows 7

Has anyone installe the Data Management Client on a Windows 7 workstation with 
excel 2010?  By default the application installed in the 32 bit Program Files 
(x86) folder, and even though when I'm trying to use the DMT tool for 
foundation upload and I select the correct path to for the DMT install, the 
worksheets are not opened and converted correctly.  For some reason the 
worksheet is opened with a hard value of the DMT install path of /Program 
Files/ instead of /Program Files (x86).

Has anyone had any luck getting the Data Management Client to work with Windows 
7?  I tried opening a ticket with BMC and after two weeks of going back and 
forth they said it was part of the design and excel that to be 2003.

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

[Sean O'Sullivan]

Many Thanks Joe, 

Yeah...I have the integration guide right here with a paperclip on that page.  

What you said about the logs makes sense, I spent some time yesterday looking 
at the mid-tier log and turning on and off the Web Service 
logging.wondering why no errors were showing up.  

Thanks for your helpand also thanks to the others who responded. 

Sean O

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

Re: Can remedy code push cause DB crash, etc?

[Axton]

>From https://forums.oracle.com/forums/thread.jspa?threadID=364644

Oracle finally admit there was a bug: BUG 5607984 - ORACLE DOES NOT CLOSE
TCP CONNECTIONS. REMAINS IN CLOSE_WAIT STATE. [On Windows 32-bit].

The patch 10 (patch number 5639232) is supposed to solve the problem for
10.2.0.2.0. We applied it monday morning and everything is fine up to now.

This bug is also supposed to be solved in the 10.2.0.3.0 patchset that is
availlable on the Metalink site.


Do you happen to be running Oracle on a Windows 32-bit server?

On Thu, Jun 28, 2012 at 11:55 AM, Raj  wrote:

> ** Thank everyone for their help.
>
> Last night we experienced the same issue again.
> Added a new field to the form and modified DB name of the 4 fields and hit
> save.
> System froze and users started getting ARERR 94.
> When checked arerror.log, noticed the following entries:
>
> Wed Jun 27 21:54:13 2012  390635 : Failure while trying to connect to the
> SQL database.
>
> Please ensure the SQL database is running or contact the Database
> Administrator for help (ARERR 550)
> Wed Jun 27 21:54:13 2012 ORA-12535: TNS:operation timed out
> Wed Jun 27 21:54:13 2012  390635 : Cannot initialize contact with SQL
> database (ARERR 551)
> Wed Jun 27 21:54:13 2012 Thread 63 not handling connection
>
> DBA mentioned that the processes on DB instances reached the threshold.
> The server/DB became unresponsive. When we looked in the DB, the view (for
> the form I was trying to modify) was missing in Production.
> So, looks like the Save operation on the form never completed. We had to
> bounce the DB instances and AR Server.
> After that We had to manually copy the view DDL from our QA environment
> and modify it for Prod and run it to enable the view to compile and other
> related views to compile.
>
> Could anyone throw some light what might have happened and how we can
> avoid this in future to avoid any impact to customers.
>
> Here's the environment info:
>
> Server : 5.01.02 Patch 1313
> Hardware : sun4u
> OS: SunOS 5.10
> DB: SQL -- Oracle
> DB Version : 0.2.0.5.0 - 64bi
>
> Thank you, Raj
>
>
> On Friday, March 30, 2012 1:14:40 PM UTC-7, Joe Martin D'Souza wrote:
>>
>> Yes in my previous email I was talking about the /tmp directory on the OS
>> and files created there too.. The files created there are done by AR
>> process
>> that are a result of an operation from a client.. in your case the client
>> was a import operation from the DS (the new toy for us adults from
>> Remedyville).
>>
>> I do no think in this case its your TEMP database which we thought it may
>> be
>> earlier. Your DBA's information directs us to the OS. Running out of
>> volume
>> space on the where the /tmp is equally critical.
>>
>> Check this directory to see if there are a lot of files owned by the AR
>> System OS user after you shut down the AR System process.. It might be an
>> indication of an application level problem.. Without shutting down the
>> processes, you will be unable to delete the files that are owned by the
>> AR
>> System OS user.. These files will be locked if created after the process
>> was
>> last started..
>>
>> Joe
>>
>> -Original Message-
>> From: Raj
>> Sent: Friday, March 30, 2012 4:04 PM Newsgroups:
>> public.remedy.arsystem.general
>> To: arslist@ARSLIST.ORG
>> Subject: Re: Can remedy code push cause DB crash, etc?
>>
>> Thanks Joe:
>>
>> Here some additional details I gathered from our DBA:
>> It was DataWarehouse that had issues and it was not complaining about
>> TEMP
>> tablespace but the errors in the alert log were pertaining the OS
>> resource
>> problem
>>
>> Wed Mar 28 08:22:30 UTC 2012
>> Process startup failed, error stack:
>> Wed Mar 28 08:22:31 UTC 2012
>> ORA-27300: OS system dependent operation:fork failed with status: 11
>> ORA-27301: OS failure message: Resource temporarily unavailable
>> ORA-27302: failure occurred at: skgpspawn3
>> Wed Mar 28 08:22:32 UTC 2012
>> Process q000 died, see its trace file
>> Wed Mar 28 08:22:32 UTC 2012
>> ..
>>
>> Wed Mar 28 08:49:31 UTC 2012
>> Process startup failed, error stack:
>> Wed Mar 28 08:49:31 UTC 2012
>> ORA-27300: OS system dependent operation:fork failed with status: 12
>> ORA-27301: OS failure message: Not enough space
>> ORA-27302: failure occurred at: ..
>> Wed Mar 28 08:49:31 UTC 2012
>> Process J001 died, see its trace file
>>
>> So, what are the recommended size, settings? whom should I approach
>> at my end to get these settings in place?
>>
>>
>> On Mar 30, 12:50 pm, Joe Martin D'Souza  wrote:
>> > The /tmp directory is needed by the AR Server process to process some
>> of
>> > its
>> > internal stuff.. running out of space here is not good too..
>> >
>> > Every client connection that is opened up from a client, creates a
>> unique
>> > temp file in the /tmp directory and this directory can grow pretty
>> large
>> > as
>> > well.. The size of that file is directly directly dependent on the
>> > operation
>> > performed.. The operation you were per

Re: Data Management Client on Windows 7

[Murnane, Phil]

Jamie:

I've never tried Excel 2007 or later -- I keep a Windows XP virtual machine 
with Office 2003 specifically to run the DMT.

Not much help for you, but there it is.

--Phil

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Jamie
Sent: Thursday, June 28, 2012 13:04
To: arslist@ARSLIST.ORG
Subject: Data Management Client on Windows 7

Has anyone installe the Data Management Client on a Windows 7 workstation with 
excel 2010?  By default the application installed in the 32 bit Program Files 
(x86) folder, and even though when I'm trying to use the DMT tool for 
foundation upload and I select the correct path to for the DMT install, the 
worksheets are not opened and converted correctly.  For some reason the 
worksheet is opened with a hard value of the DMT install path of /Program 
Files/ instead of /Program Files (x86).

Has anyone had any luck getting the Data Management Client to work with Windows 
7?  I tried opening a ticket with BMC and after two weeks of going back and 
forth they said it was part of the design and excel that to be 2003.

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

Data Management Client on Windows 7

[Jamie]

Has anyone installe the Data Management Client on a Windows 7 workstation with 
excel 2010?  By default the application installed in the 32 bit Program Files 
(x86) folder, and even though when I'm trying to use the DMT tool for 
foundation upload and I select the correct path to for the DMT install, the 
worksheets are not opened and converted correctly.  For some reason the 
worksheet is opened with a hard value of the DMT install path of /Program 
Files/ instead of /Program Files (x86).

Has anyone had any luck getting the Data Management Client to work with Windows 
7?  I tried opening a ticket with BMC and after two weeks of going back and 
forth they said it was part of the design and excel that to be 2003.

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

Re: Can remedy code push cause DB crash, etc?

[Raj]

Thank everyone for their help.

Last night we experienced the same issue again.
Added a new field to the form and modified DB name of the 4 fields and hit 
save.
System froze and users started getting ARERR 94.
When checked arerror.log, noticed the following entries:

Wed Jun 27 21:54:13 2012  390635 : Failure while trying to connect to the 
SQL database.
Please ensure the SQL database is running or contact the Database 
Administrator for help (ARERR 550)
Wed Jun 27 21:54:13 2012 ORA-12535: TNS:operation timed out
Wed Jun 27 21:54:13 2012  390635 : Cannot initialize contact with SQL 
database (ARERR 551)
Wed Jun 27 21:54:13 2012 Thread 63 not handling connection

DBA mentioned that the processes on DB instances reached the threshold. 
The server/DB became unresponsive. When we looked in the DB, the view (for 
the form I was trying to modify) was missing in Production.
So, looks like the Save operation on the form never completed. We had to 
bounce the DB instances and AR Server.
After that We had to manually copy the view DDL from our QA environment and 
modify it for Prod and run it to enable the view to compile and other 
related views to compile.

Could anyone throw some light what might have happened and how we can avoid 
this in future to avoid any impact to customers.

Here's the environment info:
Server : 5.01.02 Patch 1313
Hardware : sun4u
OS: SunOS 5.10
DB: SQL -- Oracle
DB Version : 0.2.0.5.0 - 64bi

Thank you, Raj

On Friday, March 30, 2012 1:14:40 PM UTC-7, Joe Martin D'Souza wrote:
>
> Yes in my previous email I was talking about the /tmp directory on the OS 
> and files created there too.. The files created there are done by AR 
> process 
> that are a result of an operation from a client.. in your case the client 
> was a import operation from the DS (the new toy for us adults from 
> Remedyville).
>
> I do no think in this case its your TEMP database which we thought it may 
> be 
> earlier. Your DBA's information directs us to the OS. Running out of 
> volume 
> space on the where the /tmp is equally critical.
>
> Check this directory to see if there are a lot of files owned by the AR 
> System OS user after you shut down the AR System process.. It might be an 
> indication of an application level problem.. Without shutting down the 
> processes, you will be unable to delete the files that are owned by the AR 
> System OS user.. These files will be locked if created after the process 
> was 
> last started..
>
> Joe
>
> -Original Message- 
> From: Raj
> Sent: Friday, March 30, 2012 4:04 PM Newsgroups: 
> public.remedy.arsystem.general
> To: arslist@ARSLIST.ORG
> Subject: Re: Can remedy code push cause DB crash, etc?
>
> Thanks Joe:
>
> Here some additional details I gathered from our DBA:
> It was DataWarehouse that had issues and it was not complaining about TEMP 
> tablespace but the errors in the alert log were pertaining the OS resource 
> problem
>
> Wed Mar 28 08:22:30 UTC 2012
> Process startup failed, error stack:
> Wed Mar 28 08:22:31 UTC 2012
> ORA-27300: OS system dependent operation:fork failed with status: 11
> ORA-27301: OS failure message: Resource temporarily unavailable
> ORA-27302: failure occurred at: skgpspawn3
> Wed Mar 28 08:22:32 UTC 2012
> Process q000 died, see its trace file
> Wed Mar 28 08:22:32 UTC 2012
> ..
>
> Wed Mar 28 08:49:31 UTC 2012
> Process startup failed, error stack:
> Wed Mar 28 08:49:31 UTC 2012
> ORA-27300: OS system dependent operation:fork failed with status: 12
> ORA-27301: OS failure message: Not enough space
> ORA-27302: failure occurred at: ..
> Wed Mar 28 08:49:31 UTC 2012
> Process J001 died, see its trace file
>
> So, what are the recommended size, settings? whom should I approach
> at my end to get these settings in place?
>
>
> On Mar 30, 12:50 pm, Joe Martin D'Souza  wrote:
> > The /tmp directory is needed by the AR Server process to process some of 
> > its
> > internal stuff.. running out of space here is not good too..
> >
> > Every client connection that is opened up from a client, creates a unique
> > temp file in the /tmp directory and this directory can grow pretty large 
> > as
> > well.. The size of that file is directly directly dependent on the 
> > operation
> > performed.. The operation you were performing is an expensive AR System
> > operation so I can see that this file could grow pretty large. After the
> > client connection is closed the file is typically purged..
> >
> > If a file for whatever reason does not get purged after the operation, 
> its
> > usually an indication of some sort of an application problem.. The file 
> is
> > locked so cannot be deleted until you terminate the AR System server 
> > process
> > in case that happens.. Also when that happens, you can get this directory
> > fill up with files that are large, and not deleted. Monitoring this
> > directory once in a while may be a good idea..
> >
> > In short you can't be having a low volume dedicated to the tmp directory 
> > on

Re: Form Field missing in Web Reports Designer

[ITSM.Support]

Hi,

In background we have a field on "AR System Report Console" form, named
"Form Name", on which run time form name is populated after selecting value
in "Report Name" field.

For populating fields, we have data dictionary menu attached to different
fields.

(e.g. Field1, Field2 etc) Fields which are getting populated in the list are
only "data fields". For other fields we need to select the check boxes of
the menu. 

HTH

--

Regards,

ITSM Support

 

Vyom Labs Pvt. Ltd.

BSM Solutions & Services || ITIL Consulting & Training

Email: i...@vyomlabs.com  || Web Site: www.vyomlabs.com Follow Vyom Labs
http://twitter.com/#!/vyomlabs || http://www.linkedin.com/company/vyom-labs

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Ray Palla
Sent: Wednesday, June 27, 2012 2:33 AM
To: arslist@ARSLIST.ORG
Subject: Form Field missing in Web Reports Designer

 

** 

Listers;

We've created a custom char field in the CHG:Infrastructure Change form.
Permissions are correct for usage, read/write, and visibility. When creating
or editing a Web report from the AR System Report Console (Report Designer)
the new field is not visible or selectable.

Is there a form controlling this Available field list tables in the
Designer?  How can we get the new field to display as a selectable column in
Reports?

Odd thing, the field is available for AR System reports.

R

 


Ray Palla
Sr. IT/Remedy Consultant 







Mobile: 512-917-1739
Time Zone: Central

Email:   ray.pa...@insona.com
 Professional Profile  

  INSONA Corporation
1201 Berry Lane
 
Georgetown, TX

78626-3832 USA
Infrastructure Solutions - Network Applications 


 



 

_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 questions

[pritch]

I tried WS with certificates one time, couldn't figure it out and couldn't get 
any good answers from BMC Support, so (since it was Remedy to Remedy) I went 
the DSO route instead.

- Original Message -
From: "Joe Martin D'Souza" 
To: arslist@ARSLIST.ORG
Sent: Thursday, June 28, 2012 11:26:33 AM
Subject: Re: Web Service questions

Never worked with certificates and WS's but yes its logical that those would 
need to be on the Remedy server for the Remedy server to be able to use 
those certificates and keys..

Just so you know (since you thought it was going through the mid tier) if 
you have trouble with your WS consumption, your error logs would be on the 
arjavaplugin.log on your AR Server.. The mid-tier logs will be clean and not 
have anything pertaining to any consumption errors, which is an indication 
too that its not used during the process of consumption..

Good luck.. You might have trouble with using the WS itself on the road 
ahead even after you get the connections setup.. The AR Server has a number 
of limitations consuming WS's. This is because of some of the constructs 
that the AR Web service plugin does not support or understand. I wasn't 
fully aware of these limitations when I embarked on this same road a few 
weeks ago.. They are documented on the Integration guide, so it may help if 
you read that whole section on using the Web Service integration, and get a 
grasp of the different constructs that the AR Web service plugin will not 
comprehend..

If it’s a simple web service and not a complex one, you are in luck...

Joe

-Original Message- 
From: Sean O'Sullivan
Sent: Thursday, June 28, 2012 11:04 AM Newsgroups: 
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Web Service questions

Joe,


Thanks very much...that helps a lot.  We were set up all wrong.  We're using 
a Web Service gateway that our company has set up.  We had all our verisign 
certificates and connections set up to the mid tier not the main Remedy box. 
We will swing all of that to the main Remedy box and give it another try.


Thanks again

Sean O 

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

.PNG screenshots

[Ahmed Sauga]

Hey guys,

anyone else experiencing .png files not loading in the 'screenshot' section
of the incident page.

It seems like all other extensions are working?

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

Re: Web Service questions

[Joe Martin D'Souza]

Never worked with certificates and WS's but yes its logical that those would 
need to be on the Remedy server for the Remedy server to be able to use 
those certificates and keys..


Just so you know (since you thought it was going through the mid tier) if 
you have trouble with your WS consumption, your error logs would be on the 
arjavaplugin.log on your AR Server.. The mid-tier logs will be clean and not 
have anything pertaining to any consumption errors, which is an indication 
too that its not used during the process of consumption..


Good luck.. You might have trouble with using the WS itself on the road 
ahead even after you get the connections setup.. The AR Server has a number 
of limitations consuming WS's. This is because of some of the constructs 
that the AR Web service plugin does not support or understand. I wasn't 
fully aware of these limitations when I embarked on this same road a few 
weeks ago.. They are documented on the Integration guide, so it may help if 
you read that whole section on using the Web Service integration, and get a 
grasp of the different constructs that the AR Web service plugin will not 
comprehend..


If it’s a simple web service and not a complex one, you are in luck...

Joe

-Original Message- 
From: Sean O'Sullivan
Sent: Thursday, June 28, 2012 11:04 AM Newsgroups: 
public.remedy.arsystem.general

To: arslist@ARSLIST.ORG
Subject: Re: Web Service questions

Joe,


Thanks very much...that helps a lot.  We were set up all wrong.  We're using 
a Web Service gateway that our company has set up.  We had all our verisign 
certificates and connections set up to the mid tier not the main Remedy box. 
We will swing all of that to the main Remedy box and give it another try.



Thanks again

Sean O 


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

Re: Web Service questions

[Tommy Morris]

Fortunately I have access to the software provider's developer team. I asked 
them to adjust the WSDL (namespace was the actual root of the problem) as that 
will be a permanent fix and I do not have to keep messing with the filters.

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza
Sent: Thursday, June 28, 2012 9:46 AM
To: arslist@ARSLIST.ORG
Subject: Re: Web Service questions

I have set mustunderstand to 1 as it does when it sends it out, and have been 
able to get responses that are valid from a WS.

"The external WSDL I was trying to consume was not expecting the SOAP header 
that Remedy was compiling"
This is more of the problem. The envelope that Remedy sends out is not in the 
format that is expected as it tends to either use namespaces that do not exist. 
This in some cases can be overcome by tweaking the filters a wee bit.. But in 
complex envelopes, its harder (maybe even not possible) to tweak the envelope 
at the AR level that the filter tries to generate...

So far I have had 50% success in tweaking filters to make non functional 
filters functional.. Literally 50% success in fact..

-Original Message-
From: Tommy Morris
Sent: Thursday, June 28, 2012 10:21 AM Newsgroups: 
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Web Service questions

If you receive an ERROR 9130, this is the reason:
AXIS 1.4 which is bundled with Remedy AR since 7.5 onwards sets the 
mustunderstand attribute to 1 if it finds SOAP header information in the Client 
request to the Webservice (AR or External) for example WS Security information 
like username and password. When SOAP header information is sent out, the 
mustunderstand attribute is set to 1 which otherwise is 0; Because this 
attribute is set to 1, the Webservice is not able to understand it and thus the 
error.

The external WSDL I was trying to consume was not expecting the SOAP header 
that Remedy was compiling. I had to contact that external app vendor and ask 
them to add an inclusion to their authentication so that the app can process 
the request. Otherwise on the external system I will continue to receive 
Authentication Errors.

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sean O'Sullivan
Sent: Thursday, June 28, 2012 8:55 AM
To: arslist@ARSLIST.ORG
Subject: Web Service questions

Good Morning Listers,

We're building an integration between our in-house Remedy system and an 
externally hosted SAAS system.
The integration is via Web Services.  We're new at this and its been an 
adventure.

Right now we're looking to consume a Web Service presented by the external 
system.
The code that calls the external Web Service is a filter that does a set field.

I'm trying to understand if the web service call is going out of the mid-tier 
box or going out of the main application server so that I can open the correct 
holes in the firewall.  I've read lots of documentation and I've seen 
references to it both ways.

Also, How common is it for the WSDL from the other system to need modification 
before it works with Remedy?

Thanks for your help.


Sean O'Sullivan
Prudential Financial 

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

[Sean O'Sullivan]

Joe, 


Thanks very much...that helps a lot.  We were set up all wrong.  We're using a 
Web Service gateway that our company has set up.  We had all our verisign 
certificates and connections set up to the mid tier not the main Remedy box.  
We will swing all of that to the main Remedy box and give it another try.  


Thanks again

Sean O 

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

"LIC:SYS-License Permission Map" form not found

[Mahmoud Mahdy-Mohamed]

Dears,
Please help as I installed ARS 7.6.04 on windows 2008 server and when I try to 
put the permission mapping, I can't find "LIC:SYS-License Permission Map" form 
!!.

Thanks,
Best Regards,

Mahmoud Mahdy Mohammed,PMP | Business Process Automation
Technology | Products & Services Delivery
Phone: +20(0)104999638
Mail: 
mahmoud.mahdy-moha...@vodafone.com


*

The content of this document is classified as Vodafone Egypt S.A.E. 
Confidential and Proprietary Information.

The recipient hereby is committed to hold in strict confidence the contents of 
this (e-mail, document, information) and not to disclose to any third party 
without the prior written consent of Vodafone Egypt S.A.E. Recipient will be 
held liable for any unauthorized disclosure.

If you have received this message in error, please notify the sender by return 
e-mail and delete the message in its entirety, including any attachments.

http://www.vodafone.com.eg

*

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

Re: Web Service questions

[Joe Martin D'Souza]

I have set mustunderstand to 1 as it does when it sends it out, and have 
been able to get responses that are valid from a WS.


"The external WSDL I was trying to consume was not expecting the SOAP header 
that Remedy was compiling"
This is more of the problem. The envelope that Remedy sends out is not in 
the format that is expected as it tends to either use namespaces that do not 
exist. This in some cases can be overcome by tweaking the filters a wee 
bit.. But in complex envelopes, its harder (maybe even not possible) to 
tweak the envelope at the AR level that the filter tries to generate...


So far I have had 50% success in tweaking filters to make non functional 
filters functional.. Literally 50% success in fact..


-Original Message- 
From: Tommy Morris
Sent: Thursday, June 28, 2012 10:21 AM Newsgroups: 
public.remedy.arsystem.general

To: arslist@ARSLIST.ORG
Subject: Re: Web Service questions

If you receive an ERROR 9130, this is the reason:
AXIS 1.4 which is bundled with Remedy AR since 7.5 onwards sets the 
mustunderstand attribute to 1 if it finds SOAP header information in the 
Client request to the Webservice (AR or External) for example WS Security 
information like username and password. When SOAP header information is sent 
out, the mustunderstand attribute is set to 1 which otherwise is 0; Because 
this attribute is set to 1, the Webservice is not able to understand it and 
thus the error.


The external WSDL I was trying to consume was not expecting the SOAP header 
that Remedy was compiling. I had to contact that external app vendor and ask 
them to add an inclusion to their authentication so that the app can process 
the request. Otherwise on the external system I will continue to receive 
Authentication Errors.


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sean O'Sullivan

Sent: Thursday, June 28, 2012 8:55 AM
To: arslist@ARSLIST.ORG
Subject: Web Service questions

Good Morning Listers,

We're building an integration between our in-house Remedy system and an 
externally hosted SAAS system.
The integration is via Web Services.  We're new at this and its been an 
adventure.


Right now we're looking to consume a Web Service presented by the external 
system.
The code that calls the external Web Service is a filter that does a set 
field.


I'm trying to understand if the web service call is going out of the 
mid-tier box or going out of the main application server so that I can open 
the correct holes in the firewall.  I've read lots of documentation and I've 
seen references to it both ways.


Also, How common is it for the WSDL from the other system to need 
modification before it works with Remedy?


Thanks for your help.


Sean O'Sullivan
Prudential Financial 


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

Re: Web Service questions

[Grooms, Frederick W]

You beat me to the response again Joe ;)

As for the modification of a WSDL... It all depends on how good of a design you 
are using.  If the person just slapped together something quick, then you will 
probably have to do some modifications.

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza
Sent: Thursday, June 28, 2012 9:33 AM
To: arslist@ARSLIST.ORG
Subject: Re: Web Service questions

Consuming a web service will not use the Mid-Tier. Its only publishing that 
uses the Mid-Tier. It is sent out from the Web Service plugin on the AR 
Server.. The plugin does not use the Mid-Tier while consuming, and just 
needs your AR Server java environment set up correctly...

I'm assuming that is what you meant to ask to clarify?

Joe

-Original Message- 
From: Sean O'Sullivan
Sent: Thursday, June 28, 2012 9:54 AM Newsgroups: 
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Web Service questions

Good Morning Listers,

We're building an integration between our in-house Remedy system and an 
externally hosted SAAS system.
The integration is via Web Services.  We're new at this and its been an 
adventure.

Right now we're looking to consume a Web Service presented by the external 
system.
The code that calls the external Web Service is a filter that does a set 
field.

I'm trying to understand if the web service call is going out of the 
mid-tier box or going out of the main application server so that I can open 
the correct holes in the firewall.  I've read lots of documentation and I've 
seen references to it both ways.

Also, How common is it for the WSDL from the other system to need 
modification before it works with Remedy?

Thanks for your help.


Sean O'Sullivan
Prudential Financial 



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

Re: Issue in opening a display only form

[Grooms, Frederick W]

Turn on Logging in the User tool and see what is taking the time

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sreenivas
Sent: Thursday, June 28, 2012 5:51 AM
To: arslist@ARSLIST.ORG
Subject: Issue in opening a display only form

Dear All,

We have 3844 fields on a display-only form. Does it cause any issue
while opening a form in user tool. It is working fine in thin client
however when we open the same form in thick client, window gets
freezed. Any idea why it is not working in user tool.

Environment:
ARS Server - 7.0.1
User Tool- 7.0.1
Oracle 10g


Regards,
Sreenivas

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

Re: Web Service questions

[Joe Martin D'Souza]

Consuming a web service will not use the Mid-Tier. Its only publishing that 
uses the Mid-Tier. It is sent out from the Web Service plugin on the AR 
Server.. The plugin does not use the Mid-Tier while consuming, and just 
needs your AR Server java environment set up correctly...


I'm assuming that is what you meant to ask to clarify?

Joe

-Original Message- 
From: Sean O'Sullivan
Sent: Thursday, June 28, 2012 9:54 AM Newsgroups: 
public.remedy.arsystem.general

To: arslist@ARSLIST.ORG
Subject: Web Service questions

Good Morning Listers,

We're building an integration between our in-house Remedy system and an 
externally hosted SAAS system.
The integration is via Web Services.  We're new at this and its been an 
adventure.


Right now we're looking to consume a Web Service presented by the external 
system.
The code that calls the external Web Service is a filter that does a set 
field.


I'm trying to understand if the web service call is going out of the 
mid-tier box or going out of the main application server so that I can open 
the correct holes in the firewall.  I've read lots of documentation and I've 
seen references to it both ways.


Also, How common is it for the WSDL from the other system to need 
modification before it works with Remedy?


Thanks for your help.


Sean O'Sullivan
Prudential Financial 


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

Re: Web Service questions

[Sean O'Sullivan]

Tommy, 

Thanks for the reply but we have not gotten that error yet.  Right now we're 
working on an error 7012.  

Thanks

Sean O

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

Re: Web Service questions

[Tommy Morris]

If you receive an ERROR 9130, this is the reason:
AXIS 1.4 which is bundled with Remedy AR since 7.5 onwards sets the 
mustunderstand attribute to 1 if it finds SOAP header information in the Client 
request to the Webservice (AR or External) for example WS Security information 
like username and password. When SOAP header information is sent out, the 
mustunderstand attribute is set to 1 which otherwise is 0; Because this 
attribute is set to 1, the Webservice is not able to understand it and thus the 
error.

The external WSDL I was trying to consume was not expecting the SOAP header 
that Remedy was compiling. I had to contact that external app vendor and ask 
them to add an inclusion to their authentication so that the app can process 
the request. Otherwise on the external system I will continue to receive 
Authentication Errors.

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sean O'Sullivan
Sent: Thursday, June 28, 2012 8:55 AM
To: arslist@ARSLIST.ORG
Subject: Web Service questions

Good Morning Listers, 

We're building an integration between our in-house Remedy system and an 
externally hosted SAAS system. 
The integration is via Web Services.  We're new at this and its been an 
adventure.  

Right now we're looking to consume a Web Service presented by the external 
system.  
The code that calls the external Web Service is a filter that does a set field. 

I'm trying to understand if the web service call is going out of the mid-tier 
box or going out of the main application server so that I can open the correct 
holes in the firewall.  I've read lots of documentation and I've seen 
references to it both ways.  

Also, How common is it for the WSDL from the other system to need modification 
before it works with Remedy?

Thanks for your help.  


Sean O'Sullivan
Prudential Financial

___
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: Issue in opening a display only form

[Susan Palmer]

I think you've probably generated some curiosity  with this issue.  I have
data forms with maybe 600 fields and other developers often express
negative opinions about that.  I understand yours is a display form, but
what are these fields for?  That is alot of fields!

Susan

On Thu, Jun 28, 2012 at 8:33 AM, Sreenivas  wrote:

> Thanks Misi for quick response.
>
> We are trying by deleting recently added fields but there are 500
> fields added in this week. Till now it is not yet getting opened in
> user tool.
>
> Any other ideas please
>
> Is it really an issue if we have high number fields? We need to add
> more fields on this form. it may cross 5k fields also.
>
> Regars,
> Sreenivas
>
>
>
> On 6/28/12, Misi Mladoniczky  wrote:
> > Hi,
> >
> > Make a copy of the form (save as) and try that one.
> >
> > If it does not work, remove half the fields and try that.
> >
> > That is a rather high number of fields...
> >
> > 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
> .
> >
> >> Dear All,
> >>
> >> We have 3844 fields on a display-only form. Does it cause any issue
> >> while opening a form in user tool. It is working fine in thin client
> >> however when we open the same form in thick client, window gets
> >> freezed. Any idea why it is not working in user tool.
> >>
> >> Environment:
> >> ARS Server - 7.0.1
> >> User Tool- 7.0.1
> >> Oracle 10g
> >>
> >>
> >> Regards,
> >> Sreenivas
> >>
> >>
> ___
> >> 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"

Web Service questions

[Sean O'Sullivan]

Good Morning Listers, 

We're building an integration between our in-house Remedy system and an 
externally hosted SAAS system. 
The integration is via Web Services.  We're new at this and its been an 
adventure.  

Right now we're looking to consume a Web Service presented by the external 
system.  
The code that calls the external Web Service is a filter that does a set field. 

I'm trying to understand if the web service call is going out of the mid-tier 
box or going out of the main application server so that I can open the correct 
holes in the firewall.  I've read lots of documentation and I've seen 
references to it both ways.  

Also, How common is it for the WSDL from the other system to need modification 
before it works with Remedy?

Thanks for your help.  


Sean O'Sullivan
Prudential Financial

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

Re: Issue in opening a display only form

[Sreenivas]

Thanks Misi for quick response.

We are trying by deleting recently added fields but there are 500
fields added in this week. Till now it is not yet getting opened in
user tool.

Any other ideas please

Is it really an issue if we have high number fields? We need to add
more fields on this form. it may cross 5k fields also.

Regars,
Sreenivas



On 6/28/12, Misi Mladoniczky  wrote:
> Hi,
>
> Make a copy of the form (save as) and try that one.
>
> If it does not work, remove half the fields and try that.
>
> That is a rather high number of fields...
>
> 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.
>
>> Dear All,
>>
>> We have 3844 fields on a display-only form. Does it cause any issue
>> while opening a form in user tool. It is working fine in thin client
>> however when we open the same form in thick client, window gets
>> freezed. Any idea why it is not working in user tool.
>>
>> Environment:
>> ARS Server - 7.0.1
>> User Tool- 7.0.1
>> Oracle 10g
>>
>>
>> Regards,
>> Sreenivas
>>
>> ___
>> 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: AW: Filter Table Refresh differ if Admin User...

[Misi Mladoniczky]

Hi again,

Please forget my last mail in this thread...

The SQL did not return any values, because the record had NOT been created
yet. When I rechecked via Remedy User, the record had been created, and I
got a match.

Sorry about that, I guess everyone makes mistakes from time to time ;-)

But the original post is still true. There are some permission caveats
that you have to take into consideration when you are dealing with filter
table fields.

And I also learned that you can ask a filter to impersonate the users
permissions instead of using Admin permissions. This seems to me a very
useful new feature. I can not understand why it was not mentioned in the
release notes.

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

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

> Hi,
>
> Now I have another problem with almost the same workflow. It does not work
> even though I run it as an admin.
>
> I can see the SQL-code executing in the SQL-log within my filter.
>
> But the COLMAX($ColSelectionValue$) returns empty, even though the single
> match contains a value.
>
> I have done the exact same things manually in Remedy User with a
> table-field-refresh. The SQL code is identical, and I get exactly one
> hit...
>
> Anyone else seen strange behaviour like this?
>
> This is from the API/FLTR log:
> ...
>   Checking "MOB:NT/svc-132 Cell
> Set Cellkategori" (132)
>  --> Passed -- perform actions
>  0: Set Fields
>  SELECT T370.C1,C536870913,C536871068 FROM T370 WHERE
>((T370.C8 = '738122') AND (T370.C536870958 = 'DK') AND
>(T370.C536871068 >= 1) AND (NOT (('F2925' LIKE '[^ ]%')) OR
>(T370.C536870913 = 'F2925'))) ORDER BY 1 ASC
>  OK
>  Cellkat (600043039) =
>   Checking "MOB:NT/svc-141
> Ownership Start" (141)
> ...
>
> This is the SQL code from my manual Remedy User table refresh. It is
> identical:
>  +GLEWF  ARGetListEntryWithFields -- schema MOB:ÄomfJoinCell from
> Remedy User (protocol 18) at IP address 10.20.7.167
>  SELECT T370.C1,C536870913,C536871068 FROM T370 WHERE
>((T370.C8 = '738122') AND (T370.C536870958 = 'DK') AND
>(T370.C536871068 >= 1) AND (NOT (('F2925' LIKE '[^ ]%')) OR
>(T370.C536870913 = 'F2925'))) ORDER BY 1 ASC
>  -GLEWFOK
> One record was returned with a value in the column I was interested in.
>
> Note that all testing was performed as an Admin user.
>
> Best Regards - Misi, RRR AB, http://rrr.se
>
>> Hi,
>>
>> Very interesting. I wonder about the reasons for this "design"...
>>
>> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP
>> 2011)
>>
>> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
>> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
>> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy
>> logs.
>> Find these products, and many free tools and utilities, at
>> http://rrr.se.
>>
>>> Hi,
>>>
>>> Some years ago I had a similar problem in ARS 7.1. The answer was:
>>> "works
>>> as designed" and they created a defect to correct the manuals. But I
>>> never
>>> verified if BMC modified their manuals.
>>>
>>> SW00301166  -- Doc bug: Server Side Table loop requires access
>>> permission
>>> on supporting table form REF ARS 7.1 Worfklow Objects Pg15
>>>
>>> KR Conny
>>>
>>> -Ursprüngliche Nachricht-
>>> Von: Action Request System discussion list(ARSList)
>>> [mailto:arslist@ARSLIST.ORG] Im Auftrag von Misi Mladoniczky
>>> Gesendet: Mittwoch, 20. Juni 2012 19:51
>>> An: arslist@ARSLIST.ORG
>>> Betreff: Re: Filter Table Refresh differ if Admin User...
>>>
>>> Hi,
>>>
>>> I missed this feature too... I usually read the release notes quite
>>> thoroughly, but I did not see this. Which version was it introduced?
>>>
>>> RRR|Log does not strip out anything from the logged lines, but in this
>>> case I checked the setting for Data Access -> Get Data As, and it is
>>> set
>>> to "System", not "User". So it seems like this is actually a bug
>>> then...
>>>
>>> AR System 7.6.04 SP2.
>>>
>>> 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.
>>>
 Fred,
 That is an interesting feature I didn't know existed

 Misi,
 A few choice notes from the workflow guide, page 303

 Workflow Functions
 In addition to the Set Fields, Push Fields, and Call Guide actions,
 setting Get Data As to User affects the workflow functions COLCOUNT,
>>>

Re: How to change Service Target Colors - Remedy 7.6.03

[Doug Blair]

Kali,

The colors for the results list are part of the properties for each form view. 
You can have different colors based on different fields for each view.

In Dev Studio, open the Incident form (HPD:Help Desk in my ITSM 7.6.0), click 
the bottom tab that shows desired view (e.g. Default Admin View), the Results 
List is the bottom property and results list color is the third property.

For the Incident and other consoles you'll find a similar results list color 
setting for the z2TH Incidents table properties.

Hope this helps...

Doug

--
Doug Blair
+1 224-558-5462

Sent from my new iPad
Auto-corrected typos, misspellings and non-sequiturs are gratefully attributed 
to Steve Jobs :-)

On Jun 28, 2012, at 5:22 AM, Kali Obsum  wrote:

> **
> Hi,
>  
> Currently, the default color in the Results List (if you search for Incidents 
> with SLAs in the Incident form) is red,green,yellow,black. Is there a way to 
> configure/change those colors?
>  
> Regards,
> Kali
>  
> NOTICE
> 
> The information contained in this email is confidential. If you are not the 
> intended recipient, you must not disclose or use the information in this 
> email in any way. If you received it in error, please tell us immediately by 
> return email and delete the document. We do not guarantee the integrity of 
> any e-mails or attached files and are not responsible for any changes made to 
> them by any other person.
> 
>  
> 
> _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: Issue in opening a display only form

[Misi Mladoniczky]

Hi,

Make a copy of the form (save as) and try that one.

If it does not work, remove half the fields and try that.

That is a rather high number of fields...

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.

> Dear All,
>
> We have 3844 fields on a display-only form. Does it cause any issue
> while opening a form in user tool. It is working fine in thin client
> however when we open the same form in thick client, window gets
> freezed. Any idea why it is not working in user tool.
>
> Environment:
> ARS Server - 7.0.1
> User Tool- 7.0.1
> Oracle 10g
>
>
> Regards,
> Sreenivas
>
> ___
> 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"

Issue in opening a display only form

[Sreenivas]

Dear All,

We have 3844 fields on a display-only form. Does it cause any issue
while opening a form in user tool. It is working fine in thin client
however when we open the same form in thick client, window gets
freezed. Any idea why it is not working in user tool.

Environment:
ARS Server - 7.0.1
User Tool- 7.0.1
Oracle 10g


Regards,
Sreenivas

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

Re: How to change Service Target Colors - Remedy 7.6.03

[Jose Huerta]

The only way is through customization. You can read:
http://theremedyforit.com/2011/12/color-highlight-table-results-from-more-than-one-field/
for further information.

Regards,

Jose Huerta
http://theremedyforit.com/



On Thu, Jun 28, 2012 at 11:22 AM, Kali Obsum wrote:

> **
>
> Hi,
>
> ** **
>
> Currently, the default color in the Results List (if you search for
> Incidents with SLAs in the Incident form) is red,green,yellow,black. Is
> there a way to configure/change those colors?
>
> ** **
>
> Regards,
>
> *Kali* 
>
> ** **
>
> NOTICE
>
> The information contained in this email is confidential. If you are not
> the intended recipient, you must not disclose or use the information in
> this email in any way. If you received it in error, please tell us
> immediately by return email and delete the document. We do not guarantee
> the integrity of any e-mails or attached files and are not responsible for
> any changes made to them by any other person.
>
>
> _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"

How to change Service Target Colors - Remedy 7.6.03

[Kali Obsum]

Hi,

 

Currently, the default color in the Results List (if you search for
Incidents with SLAs in the Incident form) is red,green,yellow,black. Is
there a way to configure/change those colors?

 

Regards,

Kali 

 


NOTICE 
The information contained in this email is confidential. If you are not the 
intended recipient, you must not disclose or use the information in this email 
in any way. If you received it in error, please tell us immediately by return 
email and delete the document.  We do not guarantee the integrity of any 
e-mails or attached files and are not responsible for any changes made to them 
by any other person.


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

Re: Filter Table Refresh differ if Admin User...

[Rod Harris]

Hi Misi,

I agree with you. It does seem to be overkill for one set fields. It seems
to be kind of an idiosyncrasy with the way it's implemented. It's always
been that way though. I'm not sure that the manual explains it very well
either. I'm pretty sure it is worth doing the exit guide in the filter
guide so that it doesn't loop over all the rows unnecessarily. I'm not 100%
that it helps so it would be good if you could let the list know what you
experience.

Rod

On 28 June 2012 14:56, Misi Mladoniczky  wrote:

> Hi,
>
> Maybe I need to resort to the table-loop solution...
>
> One reason for me to use tables was to reduce workflow. In theory you
> should only need to do a Set-Fields: SomeField = $SomeColumn$, and the
> table should get refreshed. The same thing should apply if you make a
> Filter Run-If that references 'SomeColumn'. The first row should be
> referenced if multiple rows are returned.
>
>Best Regards - Misi, RRR AB, http://rrr.se
>
> > Hi Misi,
> >
> > I've always needed to put server side table workflow in a filter guide.
> It
> > is the calling of the guide that triggers the table refresh I think.
> Often
> > I don't want to do a walk so I just do my COLSUM and then exit the guide
> > to
> > avoid walking each row.
> > I think under certain circumstances the table may get refreshed without
> > the filter guide call  but putting the workflow in a filter guide is the
> > only reliable way I've found to get the results I want.
> >
> > Rod Harris
> > On 20 June 2012 00:02, Misi Mladoniczky  wrote:
> >
> >> Hi LJ,
> >>
> >> Thank you for the input.
> >>
> >> In this specific case, the table is never refreshed.
> >>
> >> And I am not doing a table loop, just a Set-Fields with a COLSUM().
> >>
> >> And the really strange thing is that the behaviour differ depending on
> >> the
> >> users permission groups...
> >>
> >> I agree that there is need for more control over the filter tables!
> >>
> >>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.
> >>
> >> > Misi,
> >> > I can't speak directly to your situation, but I have seen in the past
> >> that
> >> > server table loops don't necessarily refresh the table every time you
> >> do
> >> > something with them...I have done loops before where the table has a
> >> > dynamic qualification, and you set the field that makes it dynamic,
> >> then
> >> > utilize the table...then within the same transaction, you change that
> >> > qual, and try again and it doesn't necessarily refresh the table even
> >> > though the qual, and thus the contents should change.  Without a
> >> 'refresh
> >> > table' option in filters, I've never quite been sure how to get it
> >> done.
> >> >
> >> > -Original Message-
> >> > From: Action Request System discussion list(ARSList)
> >> > [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
> >> > Sent: Tuesday, June 19, 2012 8:34 AM
> >> > To: arslist@ARSLIST.ORG
> >> > Subject: Filter Table Refresh differ if Admin User...
> >> >
> >> > Hi,
> >> >
> >> > I have a 7.6.04 SP2 system, where I am having inconsistent behaviour
> >> in
> >> > filters depending on if you are an Admin user or not.
> >> >
> >> > This is an outline of the stuff involved
> >> > 1. API Call Create Entry
> >> > 2. Filter makes Service Call
> >> > 3. Filter performs a Set-Fields from a Table Column, which should
> >> always
> >> > trigger a table refresh
> >> >
> >> > This is the same workflow as non-admin user, followed by an admin-user
> >> > (Demo):
> >> >
> >>
> http://rrr.se/tmp/rrrlog-service-table-refresh-problem-nonadmin.html#goto
> >> >
> http://rrr.se/tmp/rrrlog-service-table-refresh-problem-admin.html#goto
> >> >
> >> > I have some times seen strange behaviour inside of
> >> filter-service-calls.
> >> > This could be related to that.
> >> >
> >> > How is a person to make sure that tables in filters are refreshed
> >> > properly?
> >> >
> >> > Any comments?
> >> >
> >> > 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: Filter Table Refresh differ if Admin User...

[Misi Mladoniczky]

Hi,

Maybe I need to resort to the table-loop solution...

One reason for me to use tables was to reduce workflow. In theory you
should only need to do a Set-Fields: SomeField = $SomeColumn$, and the
table should get refreshed. The same thing should apply if you make a
Filter Run-If that references 'SomeColumn'. The first row should be
referenced if multiple rows are returned.

Best Regards - Misi, RRR AB, http://rrr.se

> Hi Misi,
>
> I've always needed to put server side table workflow in a filter guide. It
> is the calling of the guide that triggers the table refresh I think. Often
> I don't want to do a walk so I just do my COLSUM and then exit the guide
> to
> avoid walking each row.
> I think under certain circumstances the table may get refreshed without
> the filter guide call  but putting the workflow in a filter guide is the
> only reliable way I've found to get the results I want.
>
> Rod Harris
> On 20 June 2012 00:02, Misi Mladoniczky  wrote:
>
>> Hi LJ,
>>
>> Thank you for the input.
>>
>> In this specific case, the table is never refreshed.
>>
>> And I am not doing a table loop, just a Set-Fields with a COLSUM().
>>
>> And the really strange thing is that the behaviour differ depending on
>> the
>> users permission groups...
>>
>> I agree that there is need for more control over the filter tables!
>>
>>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.
>>
>> > Misi,
>> > I can't speak directly to your situation, but I have seen in the past
>> that
>> > server table loops don't necessarily refresh the table every time you
>> do
>> > something with them...I have done loops before where the table has a
>> > dynamic qualification, and you set the field that makes it dynamic,
>> then
>> > utilize the table...then within the same transaction, you change that
>> > qual, and try again and it doesn't necessarily refresh the table even
>> > though the qual, and thus the contents should change.  Without a
>> 'refresh
>> > table' option in filters, I've never quite been sure how to get it
>> done.
>> >
>> > -Original Message-
>> > From: Action Request System discussion list(ARSList)
>> > [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
>> > Sent: Tuesday, June 19, 2012 8:34 AM
>> > To: arslist@ARSLIST.ORG
>> > Subject: Filter Table Refresh differ if Admin User...
>> >
>> > Hi,
>> >
>> > I have a 7.6.04 SP2 system, where I am having inconsistent behaviour
>> in
>> > filters depending on if you are an Admin user or not.
>> >
>> > This is an outline of the stuff involved
>> > 1. API Call Create Entry
>> > 2. Filter makes Service Call
>> > 3. Filter performs a Set-Fields from a Table Column, which should
>> always
>> > trigger a table refresh
>> >
>> > This is the same workflow as non-admin user, followed by an admin-user
>> > (Demo):
>> >
>> http://rrr.se/tmp/rrrlog-service-table-refresh-problem-nonadmin.html#goto
>> > http://rrr.se/tmp/rrrlog-service-table-refresh-problem-admin.html#goto
>> >
>> > I have some times seen strange behaviour inside of
>> filter-service-calls.
>> > This could be related to that.
>> >
>> > How is a person to make sure that tables in filters are refreshed
>> > properly?
>> >
>> > Any comments?
>> >
>> > 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"
>> >
>>
>>
>> ___
>> 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 ARSLi