Looking for the ARS user guide

[Chanan Berler]

Hello All,

I am worked as an ARS programmer, but that was last year.
Currently I am starting working with it again.

Q: does anyone have the Admin / Client user guide ? or any other  related
document ?
Can't put my finger on these documents found over bmc.com site.

Thanks
Chanan

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: URGENT HELP REQUIRED --- PROD ISSUE

[Remedy Maniac]

**




from the same box where the admin tool is installed, try with Sybase
tools such as Advantage or Central, or isql to select the Remedy views
and tables.
This first step will show whether your DB is ok.


Jaya Munjal wrote:

  
**
   Hi List 
     
   We are not able to update or modify any workflow object on the
our Production Environment. As soon as we open any workflow object via
the Admin tool (Filters, Escalation, forms) etc it starts throwing an
error   
     
   Cannot establish a network connection to the AR System
server : lonss00014.fm.rbsgrp.net : RPC: Miscellaneous tli error -
System error (Connection refused) (ARERR 90) 
     
     
   In the ARERROR log we get the following error messages 
     
   * 
     
   Wed Nov 18 03:22:46 2009  390600 : Incorrect format in the
definition file (bad action value -- \) (ARERR 402) 
   Wed Nov 18 03:22:47 2009  390600 : Missing data in the SQL
database (filter.numActions) (ARERR 556) 
   Wed Nov 18 03:22:47 2009  390600 : Error in definition for a
filter (ARERR 343) 
   Wed Nov 18 03:22:47 2009 AR System Email Association Delete
Attachments 
     
   Wed Nov 18 03:22:55 2009  Dispatch : Cannot establish a network
connection to the AR System server (lonss00014 : RPC: Miscellaneous tli
error - An event requires attentionError 0)  ARERR - 90 
     
   * 
     
     
   We are able to login to the server via the admin tool but the
filter AR System Email Association Delete Attachments is not
visible. On trying to import in place the  we get the error. 
     
   Cannot establish a network connection to the AR System server
(lonss00014 : RPC: Miscellaneous tli error - An event requires
attentionError 0)  ARERR - 90 
     
     
   Platform - ARS 6.3 Patch 24 
   OS - Solaris 
   DB - Sybase 
     
     
   Any suggestion would be appreciated… Let me know if you require
any other information. 
     
   Thanks 
     
   Jaya Munjal
Technology Services India
The Royal Bank of Scotland Group
  
   O +91 124 479 1714 
   M +91 971 130 9277 
   F +91 124 479  0023 
  
jaya.mun...@rbs.com 
7B Building, DLF Cyber City, DLF Phase III, 
   Gurgaon - 122002, Haryana, India 
     
   Please don't print this e-mail unless you really need to. 
     
     
  ***
The Royal Bank of Scotland plc. Registered in Scotland No 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. 
Authorised and regulated by the Financial Services Authority. 
 
This e-mail message is confidential and for use by the 
addressee only. If the message is received by anyone other 
than the addressee, please return the message to the sender 
by replying to it and then delete the message from your 
computer. Internet e-mails are not necessarily secure. The 
Royal Bank of Scotland plc does not accept responsibility for 
changes made to this message after it was sent. 

Whilst all reasonable care has been taken to avoid the 
transmission of viruses, it is the responsibility of the recipient to 
ensure that the onward transmission, opening or use of this 
message and any attachments will not adversely affect its 
systems or data. No responsibility is accepted by The 
Royal Bank of Scotland plc in this regard and the recipient should carry 
out such virus and other checks as it considers appropriate. 

Visit our website at www.rbs.com

***
  
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_




_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

Re: ARS 6.3 and Helpdesk 5.6 "No Floating Licenses Available"

[Sharon Menachem]

I had a similar problem on this combination of versions. In our case there was 
a difference in capitalization of the name of the license in the SHR:People 
form and in the database. After correcting the problem in the database the 
users were able to work with their licenses. 

I was not able to ascertain why the license name was being stored incorrectly 
in the database ... and then we upgraded :) 

Sharon

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Brad Terhune
Sent: Thursday, November 12, 2009 12:17 AM
To: arslist@ARSLIST.ORG
Subject: ARS 6.3 and Helpdesk 5.6 "No Floating Licenses Available"

Hi list.  Been a while.
I'm currently trying to add some new people to our support group for
Remedy access.  I'm giving them Helpdesk-Floating licenses and ARS
floating licenses.  I'm getting an error that indicates:

There are no Help Desk Floating licenses available. (ARERR 42338)
The preceding message occurred during the execution of active link
SHRCFG:PGP-ModPeopleInfo08AddU -- action 1. (ARNOTE 1101)

I know that floating means only a certain number of people can log in
at once but I thought that as administrator I could assign floating
licenses to as large a pool as I wished?  Anyone know what might be
happening here and how I could fix it?
Thanks in advance for any help you can provide.

Brad Terhune
bterh...@uthsc.edu

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Midtier / view ticket online solution problem.....

[Sean Harrodine]

Hi all,

Can anyone advise on the following please.

We're running 6.3 and apache tomcat all on the same server (suse linux) with no 
issues.

We send out an email to the user when a ticket is raised which contains a URL 
where they can click to check the status of the ticket.

The format is below...

http://servername/arsys/servlet/ViewFormServlet?form=form-name-here&view=view-name-here&server=servernamehere&username=vto-683240&eid=683240

you will see
username variable = vto-nn
eid = "the users ticket number"

We have guest user logins enabled so the script that constructs the email gives 
them a username of "vto" (for "view ticket online") and then appends their 
ticket number onto the end, with the theory being that it should only be that 
user that needs to view that ticket.

So, all works well but if they close their browser afterwards, i notice in the 
Remedy admin tool that a Read license for username vto-683240 still remains 
after they have closed their browser and then, if they click the link in their 
email at a later time, they get the message "user is already logged on - do you 
want to override"

Does anyone know why the userid "hangs around" after closing the browser ?

Is it because its not a clean LOGOFF and if so, is there any way i can get this 
to happen ??

TIA

Sean




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Midtier / view ticket online solution problem.....

[Frank Caruso]

Not sure what tasks you allow guest logins (Read Only). If it just
submit then you could switch the license to Read Restricted which will
eliminate the "User Logged Into Other Machine" issue but will not
allow updates to tickets.

Closing the browser window does not clear the users connection. You
should give them a Logout button which does an Application-Exit. Not
sure if doing an Application-Exit on window close will do the same
thing.

HTH
Frank


On Wed, Nov 18, 2009 at 1:46 PM, Sean Harrodine  wrote:
> **
> Hi all,
>
> Can anyone advise on the following please.
>
> We're running 6.3 and apache tomcat all on the same server (suse linux) with
> no issues.
>
> We send out an email to the user when a ticket is raised which contains a
> URL where they can click to check the status of the ticket.
>
> The format is below...
>
> http://servername/arsys/servlet/ViewFormServlet?form=form-name-here&view=view-name-here&server=servernamehere&username=vto-683240&eid=683240
>
> you will see
> username variable = vto-nn
> eid = "the users ticket number"
>
> We have guest user logins enabled so the script that constructs the email
> gives them a username of "vto" (for "view ticket online") and then appends
> their ticket number onto the end, with the theory being that it should only
> be that user that needs to view that ticket.
>
> So, all works well but if they close their browser afterwards, i notice in
> the Remedy admin tool that a Read license for username vto-683240 still
> remains after they have closed their browser and then, if they click the
> link in their email at a later time, they get the message "user is already
> logged on - do you want to override"
>
> Does anyone know why the userid "hangs around" after closing the browser ?
>
> Is it because its not a clean LOGOFF and if so, is there any way i can get
> this to happen ??
>
> TIA
>
> Sean
>
>
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Midtier / view ticket online solution problem.....

[Sean Harrodine]

thanks for the reply Frank

I have popped a button on the Web View Form with an active link which does a 
Run Process "PERFORM-ACTION-EXIT-APP"

Once pressed, It pops up the MidTier screen saying "You have successfully 
logged out" but upon checking in the "Admin tool / Manage User Licenses", the 
userid is still showing although it seems to have addressed the "user already 
logged on" issue.
If i click the link again, the ticket seems to display ok without the "user 
already logged on" message

hmmm





From: Frank Caruso 
To: arslist@ARSLIST.ORG
Sent: Wed, 18 November, 2009 11:04:15
Subject: Re: Midtier / view ticket online solution problem.

Not sure what tasks you allow guest logins (Read Only). If it just
submit then you could switch the license to Read Restricted which will
eliminate the "User Logged Into Other Machine" issue but will not
allow updates to tickets.

Closing the browser window does not clear the users connection. You
should give them a Logout button which does an Application-Exit. Not
sure if doing an Application-Exit on window close will do the same
thing.

HTH
Frank


On Wed, Nov 18, 2009 at 1:46 PM, Sean Harrodine  wrote:
> **
> Hi all,
>
> Can anyone advise on the following please.
>
> We're running 6.3 and apache tomcat all on the same server (suse linux) with
> no issues.
>
> We send out an email to the user when a ticket is raised which contains a
> URL where they can click to check the status of the ticket.
>
> The format is below...
>
> http://servername/arsys/servlet/ViewFormServlet?form=form-name-here&view=view-name-here&server=servernamehere&username=vto-683240&eid=683240
>
> you will see
> username variable = vto-nn
> eid = "the users ticket number"
>
> We have guest user logins enabled so the script that constructs the email
> gives them a username of "vto" (for "view ticket online") and then appends
> their ticket number onto the end, with the theory being that it should only
> be that user that needs to view that ticket.
>
> So, all works well but if they close their browser afterwards, i notice in
> the Remedy admin tool that a Read license for username vto-683240 still
> remains after they have closed their browser and then, if they click the
> link in their email at a later time, they get the message "user is already
> logged on - do you want to override"
>
> Does anyone know why the userid "hangs around" after closing the browser ?
>
> Is it because its not a clean LOGOFF and if so, is there any way i can get
> this to happen ??
>
> TIA
>
> Sean
>
>
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"





___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

please ignore

[Daniel Bloom]

8:51am EST
Really to see if i get this back,
for some reason my own feed of the ARSlist stopped
when I went to the Conference and I think it is the usual,
so much built up my ISP thinks it was spam, sigh.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Midtier / view ticket online solution problem.....

[Frank Caruso]

Do the same test again but this time turn on User logging and I think
you will see the user being added then removed. Not sure about the
license tool.


On Wed, Nov 18, 2009 at 3:52 PM, Sean Harrodine  wrote:
> **
> thanks for the reply Frank
>
> I have popped a button on the Web View Form with an active link which does a
> Run Process "PERFORM-ACTION-EXIT-APP"
>
> Once pressed, It pops up the MidTier screen saying "You have successfully
> logged out" but upon checking in the "Admin tool / Manage User Licenses",
> the userid is still showing although it seems to have addressed the "user
> already logged on" issue.
> If i click the link again, the ticket seems to display ok without the "user
> already logged on" message
>
> hmmm
>
> 
> From: Frank Caruso 
> To: arslist@ARSLIST.ORG
> Sent: Wed, 18 November, 2009 11:04:15
> Subject: Re: Midtier / view ticket online solution problem.
>
> Not sure what tasks you allow guest logins (Read Only). If it just
> submit then you could switch the license to Read Restricted which will
> eliminate the "User Logged Into Other Machine" issue but will not
> allow updates to tickets.
>
> Closing the browser window does not clear the users connection. You
> should give them a Logout button which does an Application-Exit. Not
> sure if doing an Application-Exit on window close will do the same
> thing.
>
> HTH
> Frank
>
>
> On Wed, Nov 18, 2009 at 1:46 PM, Sean Harrodine 
> wrote:
>> **
>> Hi all,
>>
>> Can anyone advise on the following please.
>>
>> We're running 6.3 and apache tomcat all on the same server (suse linux)
>> with
>> no issues.
>>
>> We send out an email to the user when a ticket is raised which contains a
>> URL where they can click to check the status of the ticket.
>>
>> The format is below...
>>
>>
>> http://servername/arsys/servlet/ViewFormServlet?form=form-name-here&view=view-name-here&server=servernamehere&username=vto-683240&eid=683240
>>
>> you will see
>> username variable = vto-nn
>> eid = "the users ticket number"
>>
>> We have guest user logins enabled so the script that constructs the email
>> gives them a username of "vto" (for "view ticket online") and then appends
>> their ticket number onto the end, with the theory being that it should
>> only
>> be that user that needs to view that ticket.
>>
>> So, all works well but if they close their browser afterwards, i notice in
>> the Remedy admin tool that a Read license for username vto-683240
>> still
>> remains after they have closed their browser and then, if they click the
>> link in their email at a later time, they get the message "user is already
>> logged on - do you want to override"
>>
>> Does anyone know why the userid "hangs around" after closing the browser ?
>>
>> Is it because its not a clean LOGOFF and if so, is there any way i can get
>> this to happen ??
>>
>> TIA
>>
>> Sean
>>
>>
>>
>> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
>> Are"_
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Oracle in-row LOB storage issue - IM 7.03

[William Rentfrow]

Correct - also, if you are using Solaris + remote Oracle db the
performance takes a huge hit if you are using out-of-row.

However, we are using IN-ROW! :)  And the space is still being consumed
at a ridiculous rate - I can't believe I didn't mention that but it was
rather late last night when I wrote this.


William Rentfrow
Principal Consultant, StrataCom Inc.
wrentf...@stratacominc.com
O 715-592-5185
C 715-410-8056

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky
Sent: Wednesday, November 18, 2009 1:21 AM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle in-row LOB storage issue - IM 7.03

Hi,

In most cases, as I understand, it is definitely better to not use the
out-row-lob-setting. This will save a lot of space and time for the DB.

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

> I've read a LOT of the documentation, etc, regarding how LOB storage 
> works (including Axton's very fine wiki on this topic) and I'm pretty 
> familiar with it in theory.
>
> We are doing a data migration at the moment which is using an enormous

> amount of space.  We are in the process of migratiing 330,000 records 
> as a test.
>
> This has used (so far) 33 GB of table space.  We only have 47 GB in 
> this test system.  Considering the actual ARX exports were < 1 GB 
> something is clearly not right here.
>
> Initial consultation with a DBA has indicated these rows in the T1114 
> (aka, HPD:HelpDesk) are LOB's:
>
> C105940 z1D Template Related CI
> C100151 Detailed Decription
> C100156 Resolution
> C103742 z1D Mobile Worklog Upd
> C300270900 Reason Description
>
> All of these are character fields set to 0 (unlimited) length.
>
> The questions I have are:
>
> 1.) If a LOB is > 4K it is stored out of row regardless.  Can anyone 
> tell me how to determine the space used by any of those particular 
> fields in Oracle?  And how I can tell if these are in fact being 
> stored out of row due to the "unlimited" option on the field?
>
> 2.) Aren't z1D fields supposed to be Display only according to 
> Remedy's design and naming conventions?  I'm pretty sure that is the 
> case but both of the fields above with that prefix are stored as
optional.
>
> Thanks in advance -
>
> William Rentfrow
> Principal Consultant, StrataCom Inc.
> wrentf...@stratacominc.com
> O 715-592-5185
> C 715-410-8056
>
>
> __
> _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum
Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: URGENT HELP REQUIRED --- PROD ISSUE

[Tommy Morris]

Reboot your AR server or at the least restart the services. We receive
this error when our DB team takes down our database without us knowing.
A simple restart of AR reestablishes that connection, of course we also
restart mid-tier just to be on the safe side.

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Jaya Munjal
Sent: Tuesday, November 17, 2009 10:31 PM
To: arslist@ARSLIST.ORG
Subject: URGENT HELP REQUIRED --- PROD ISSUE
Importance: High

 

** 

Hi List

 

We are not able to update or modify any workflow object on the our
Production Environment. As soon as we open any workflow object via the
Admin tool (Filters, Escalation, forms) etc it starts throwing an error
 

 

Cannot establish a network connection to the AR System server :
lonss00014.fm.rbsgrp.net : RPC: Miscellaneous tli error - System error
(Connection refused) (ARERR 90)

 

 

In the ARERROR log we get the following error messages

 

*

 

Wed Nov 18 03:22:46 2009  390600 : Incorrect format in the definition
file (bad action value -- \) (ARERR 402)

Wed Nov 18 03:22:47 2009  390600 : Missing data in the SQL database
(filter.numActions) (ARERR 556)

Wed Nov 18 03:22:47 2009  390600 : Error in definition for a filter
(ARERR 343)

Wed Nov 18 03:22:47 2009 AR System Email Association Delete
Attachments

 

Wed Nov 18 03:22:55 2009  Dispatch : Cannot establish a network
connection to the AR System server (lonss00014 : RPC: Miscellaneous tli
error - An event requires attentionError 0)  ARERR - 90

 

*

 

 

We are able to login to the server via the admin tool but the filter AR
System Email Association Delete Attachments is not visible. On trying to
import in place the  we get the error. 

 

Cannot establish a network connection to the AR System server
(lonss00014 : RPC: Miscellaneous tli error - An event requires
attentionError 0)  ARERR - 90

 

 

Platform - ARS 6.3 Patch 24

OS - Solaris

DB - Sybase

 

 

Any suggestion would be appreciated... Let me know if you require any
other information.

 

Thanks

 

Jaya Munjal
Technology Services India
The Royal Bank of Scotland Group

O +91 124 479 1714

M +91 971 130 9277

F +91 124 479  0023 
jaya.mun...@rbs.com  
7B Building, DLF Cyber City, DLF Phase III, 

Gurgaon - 122002, Haryana, India

 

Please don't print this e-mail unless you really need to. 

 

 

 

***
The Royal Bank of Scotland plc. Registered in Scotland No 90312.
Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. 
Authorised and regulated by the Financial Services Authority. 
 
This e-mail message is confidential and for use by the 
addressee only. If the message is received by anyone other 
than the addressee, please return the message to the sender 
by replying to it and then delete the message from your 
computer. Internet e-mails are not necessarily secure. The 
Royal Bank of Scotland plc does not accept responsibility for 
changes made to this message after it was sent. 
 
Whilst all reasonable care has been taken to avoid the 
transmission of viruses, it is the responsibility of the recipient to 
ensure that the onward transmission, opening or use of this 
message and any attachments will not adversely affect its 
systems or data. No responsibility is accepted by The 
Royal Bank of Scotland plc in this regard and the recipient should carry

out such virus and other checks as it considers appropriate. 
 
Visit our website at www.rbs.com
 

***

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: URGENT HELP REQUIRED --- PROD ISSUE

[Tanner, Doug]

I have seen this pretty recently and there was a corrupted object (form) in the 
database, we successfully removed the object at the database level (thru 
Enterprise Manager - Our was on MS SQL).  In our case it was a corrupted form 
so we removed the form, views, fields and 2 active links attached to the form 
from the database and then imported from a def backup/another server.

Hit me off list if you need the exact steps we took.

Thanks, Doug

doug.tan...@compass-usa.com


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Tommy Morris
Sent: Wednesday, November 18, 2009 9:23 AM
To: arslist@ARSLIST.ORG
Subject: Re: URGENT HELP REQUIRED --- PROD ISSUE

**
Reboot your AR server or at the least restart the services. We receive this 
error when our DB team takes down our database without us knowing. A simple 
restart of AR reestablishes that connection, of course we also restart mid-tier 
just to be on the safe side.

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Jaya Munjal
Sent: Tuesday, November 17, 2009 10:31 PM
To: arslist@ARSLIST.ORG
Subject: URGENT HELP REQUIRED --- PROD ISSUE
Importance: High

**
Hi List

We are not able to update or modify any workflow object on the our Production 
Environment. As soon as we open any workflow object via the Admin tool 
(Filters, Escalation, forms) etc it starts throwing an error  

Cannot establish a network connection to the AR System server : 
lonss00014.fm.rbsgrp.net : RPC: Miscellaneous tli error - System error 
(Connection refused) (ARERR 90)


In the ARERROR log we get the following error messages

*

Wed Nov 18 03:22:46 2009  390600 : Incorrect format in the definition file (bad 
action value -- \) (ARERR 402)
Wed Nov 18 03:22:47 2009  390600 : Missing data in the SQL database 
(filter.numActions) (ARERR 556)
Wed Nov 18 03:22:47 2009  390600 : Error in definition for a filter (ARERR 343)
Wed Nov 18 03:22:47 2009 AR System Email Association Delete Attachments

Wed Nov 18 03:22:55 2009  Dispatch : Cannot establish a network connection to 
the AR System server (lonss00014 : RPC: Miscellaneous tli error - An event 
requires attentionError 0)  ARERR - 90

*


We are able to login to the server via the admin tool but the filter AR System 
Email Association Delete Attachments is not visible. On trying to import in 
place the  we get the error.

Cannot establish a network connection to the AR System server (lonss00014 : 
RPC: Miscellaneous tli error - An event requires attentionError 0)  ARERR - 90


Platform - ARS 6.3 Patch 24
OS - Solaris
DB - Sybase


Any suggestion would be appreciated... Let me know if you require any other 
information.

Thanks

Jaya Munjal
Technology Services India
The Royal Bank of Scotland Group
O +91 124 479 1714
M +91 971 130 9277
F +91 124 479  0023
jaya.mun...@rbs.com
7B Building, DLF Cyber City, DLF Phase III,
Gurgaon - 122002, Haryana, India

Please don't print this e-mail unless you really need to.





***

The Royal Bank of Scotland plc. Registered in Scotland No 90312. Registered 
Office: 36 St Andrew Square, Edinburgh EH2 2YB.

Authorised and regulated by the Financial Services Authority.



This e-mail message is confidential and for use by the

addressee only. If the message is received by anyone other

than the addressee, please return the message to the sender

by replying to it and then delete the message from your

computer. Internet e-mails are not necessarily secure. The

Royal Bank of Scotland plc does not accept responsibility for

changes made to this message after it was sent.



Whilst all reasonable care has been taken to avoid the

transmission of viruses, it is the responsibility of the recipient to

ensure that the onward transmission, opening or use of this

message and any attachments will not adversely affect its

systems or data. No responsibility is accepted by The

Royal Bank of Scotland plc in this regard and the recipient should carry

out such virus and other checks as it considers appropriate.



Visit our website at www.rbs.com



***
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_


DISCLAIMER Important! This message is intended for the above named person(s) 
only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient 
of this e-mail and have received it in error, please immediately notify the 
sender by return email and then delete it from your mailbox. This message may 
be protected by the attorney-client privilege and/or work product doctrine.  
Accessing, copying, disseminating o

Re: Looking for the ARS user guide

[DCI Remedy]

Assuming that you are registered with a support ID.  Go to BMC Support /
Patch downloads and fixes / Product Downloads (EPD) - After you accept the
agreements you can drill down on your products associated to your support
ID.  Keep drilling in until you get to the documents.

 

Which set are you looking for?  6x/7x/7.5?

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Chanan Berler
Sent: Wednesday, November 18, 2009 1:08 AM
To: arslist@ARSLIST.ORG
Subject: Looking for the ARS user guide

 

** 

Hello All,

I am worked as an ARS programmer, but that was last year.
Currently I am starting working with it again.

Q: does anyone have the Admin / Client user guide ? or any other  related
document ?
Can't put my finger on these documents found over bmc.com site.

Thanks
Chanan

 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Technosys Announce New BMC ITSM to CA Clarity PPM Connector

[Khalil]

Dear Listers,
 
We are pleased to announce the availability of our new BMC ITSM to CA
Clarity PPM Connector. 

This connector allows users of BMC ITSM / Remedy to seamlessly link Change
Management requests directly to CA Clarity Project Management tools. The out
of the box functionality enables organisations using both tool sets to
benefit from a complete EITM solution within days rather than months.

CA Clarity is typically used to manage strategic and tactical demand within
the business. Change programs and requests generated from BMC ITSM can be
automatically added to the overall IT Project Portfolio to allow coordinated
project and resource planning. 

By providing a single system of record for IT project portfolio decisions,
investment decisions, resource based optimisations, budgeting and
forecasting, best practice methodologies and time tracking, IT efficiencies
are improved.

For further information on this new connector please go
http://www.technosysuk.com/services/clarity_connector.htm or email to
itsm_clar...@technosysuk.com, book a demo at
http://www.technosysuk.com/solutions/demos.htm

Technosys is a global solution provider specialising in the BMC portfolio of
products for Business Service Management (BSM). 

Best regards,

M. Khalil
Technosys Limited
Ph: +44(0)2084295955
Mob: +44(0)7916153032
Fax: +44(0)208 866 2400 
 
IMPORTANT NOTICE 
This communication is from Technosys Limited registered in England and Wales
with registered number 4436385. Its registered office is Talbot House,
204-226 Imperial Drive, Harrow, Middlesex, HA2 7HH, United Kingdom. 
 
This communication contains information which is confidential and may also
be privileged. It is for the exclusive use of the intended recipient(s).  If
you are not the intended recipient(s), please (1) notify
secur...@technosysuk.com by forwarding this email and delete all copies from
your system and (2) note that disclosure, distribution, copying or use of
this communication is strictly prohibited.  
 
Email communications cannot be guaranteed to be secure or free from error or
viruses. To the extent permitted by law, Technosys Limited does not accept
any liability for use of or reliance on the contents of this email by any
person save by the intended recipient(s) to the extent agreed in a Technosys
Limited engagement contract. 
 
Opinions, conclusions and other information in this email which have not
been delivered by way of the business of Technosys Limited are neither given
nor endorsed by it.
 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Looking for the ARS user guide

[Easter, David]

Current documentation is only available to those with a Support ID.  
Documentation for AR System 7.0.01, 7.1.00 and 7.5.00 can be found here:

http://webapps.bmc.com/support/faces/prodallversions.jsp?seqid=108018

For legacy documentation (6.3.00 and prior), zip files have been posted to the 
BMC Developer Network in the Documents section:

http://communities.bmc.com/communities/community/bmcdn/bmc_atrium_and_foundation_technologies/bmc_remedy_ar_system?view=documents

You will need a BMC DN account to access them, but signing up is free.

Since the information is copyrighted, it can't be put on a site that does not 
require some sort of login/access - and can't legally be forward by non-BMC 
authorized entities.   That's why it's not posted on www.bmc.com.


-David J. Easter
Sr. Product Manager, Solution Strategy and Development
BMC Software, Inc.

The opinions, statements, and/or suggested courses of action expressed in this 
E-mail do not necessarily reflect those of BMC Software, Inc.  My voluntary 
participation in this forum is not intended to convey a role as a spokesperson, 
liaison or public relations representative for BMC Software, Inc.

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of DCI Remedy
Sent: Wednesday, November 18, 2009 6:45 AM
To: arslist@ARSLIST.ORG
Subject: Re: Looking for the ARS user guide

**
Assuming that you are registered with a support ID.  Go to BMC Support / Patch 
downloads and fixes / Product Downloads (EPD) - After you accept the agreements 
you can drill down on your products associated to your support ID.  Keep 
drilling in until you get to the documents.

Which set are you looking for?  6x/7x/7.5?

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Chanan Berler
Sent: Wednesday, November 18, 2009 1:08 AM
To: arslist@ARSLIST.ORG
Subject: Looking for the ARS user guide

**
Hello All,

I am worked as an ARS programmer, but that was last year.
Currently I am starting working with it again.

Q: does anyone have the Admin / Client user guide ? or any other  related 
document ?
Can't put my finger on these documents found over bmc.com site.

Thanks
Chanan

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Question about Work Info and View Access in ITSM 7.1

[Pargeter, Christie :CO IS]

We are running in Single Tenancy and were informed that Public means the
end client can see it on Requester Console and Internal means that it
doesn't show on Requester Console.



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Shyam Attavar
Sent: Tuesday, November 17, 2009 4:50 PM
To: arslist@ARSLIST.ORG
Subject: Question about Work Info and View Access in ITSM 7.1


** 
Dear Listers,

We are trying to see if there is more to what is mentioned in the
Incident Management guide for the View Access flag for Work Info records
(excerpt below):



>From the View Access list, select Internal or Public.

! Internal-If you want users within your organization to see the entry.

! Public-If you want everyone with access to the application to see the

entry, including requesters from the Requester console.


We are using the application in a single tenancy mode and don't have any
other companies or organizations being supported on this instance.

I was wondering what the "within your organization" really means, since
I see behavior not consistent with what is documented.

Any thoughts/inputs?

TIA
--
Shyam

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Chat with Remedy

[Brittain, Mark]

Hi All,

Currently we have Citrix GoToAssist integrated with ARS 6.3, patch 20. Citrix 
has just informed us that we have to upgrade to their latest version by the end 
of the year. The catch is they no longer support integration with Remedy. I 
like to have back up/company when something stops working. So I was wondering 
if either BMC has a chat integration product or any other vendors that support 
the Remedy integration.

Thanks
Mark


Mark Brittain
Remedy Developer
NaviSite
mbritt...@navisite.com
(315) 453-2912 x5418 (Phone)
(315) 317.2897 (Cell)
Reduce Cost of IT with Managed Hosting and Application Services from NaviSite.
Visit www.NaviSite.com Today.



  
This e-mail is the property of NaviSite, Inc. It is intended only for the 
person or entity to which it is addressed and may contain information that is 
privileged, confidential, or otherwise protected from disclosure. Distribution 
or copying of this e-mail, or the information contained herein, to anyone other 
than the intended recipient is prohibited.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Chat with Remedy

[Shellman, David]

Mark,

AT WWRUG09, my eService and Conversive had chat products that integrated within 
the AR System.

Dave


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Brittain, Mark
Sent: Wednesday, November 18, 2009 11:13 AM
To: arslist@ARSLIST.ORG
Subject: Chat with Remedy

**
Hi All,

Currently we have Citrix GoToAssist integrated with ARS 6.3, patch 20. Citrix 
has just informed us that we have to upgrade to their latest version by the end 
of the year. The catch is they no longer support integration with Remedy. I 
like to have back up/company when something stops working. So I was wondering 
if either BMC has a chat integration product or any other vendors that support 
the Remedy integration.

Thanks
Mark


Mark Brittain
Remedy Developer
NaviSite
mbritt...@navisite.com
(315) 453-2912 x5418 (Phone)
(315) 317.2897 (Cell)
Reduce Cost of IT with Managed Hosting and Application Services from NaviSite.
Visit www.NaviSite.com Today.


  
This e-mail is the property of NaviSite, Inc. It is intended only for the 
person or entity to which it is addressed and may contain information that is 
privileged, confidential, or otherwise protected from disclosure. Distribution 
or copying of this e-mail, or the information contained herein, to anyone other 
than the intended recipient is prohibited.
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Oracle in-row LOB storage issue - IM 7.03

[Axton]

You can look at the oracle data dictionary view dba_segments to see
the size of the base tables, lob segments, indexes, etc:

Here is an example for schemaid 746:

SQL> ed
Wrote file afiedt.buf

  1  select bytes, segment_name, owner
  2  from dba_segments
  3  where (segment_name like '_746' or segment_name like '_746C%')
  4* and segment_type = 'TABLE'
SQL> /

 BYTES SEGMENT_NAME   OWNER
-- -- ---
   3407872 B746   ARADMIN
2390491136 T746   ARADMIN
  27525120 H746   ARADMIN
 932446208 B746C701000357 ARADMIN

B746C701000357 is the lob segment for field id 701000357.  The others
are the base tables.  You can run the query without the where clause
for segment_type to get the indexes, lob segment indexes, etc:

select bytes, segment_name, owner
from dba_segments
where (segment_name like '_746%' or segment_name like '_746C%')

Axton Grams

The opinions, statements, and/or suggested courses of action expressed
in this E-mail do not necessarily reflect those of BMC Software, Inc.
My voluntary participation in this forum is not intended to convey a
role as a spokesperson, liaison or public relations representative for
BMC Software, Inc.

On Wed, Nov 18, 2009 at 12:57 AM, William Rentfrow
 wrote:
> **
>
> I've read a LOT of the documentation, etc, regarding how LOB storage works
> (including Axton's very fine wiki on this topic) and I'm pretty familiar
> with it in theory.
>
> We are doing a data migration at the moment which is using an enormous
> amount of space.  We are in the process of migratiing 330,000 records as a
> test.
>
> This has used (so far) 33 GB of table space.  We only have 47 GB in this
> test system.  Considering the actual ARX exports were < 1 GB something is
> clearly not right here.
>
> Initial consultation with a DBA has indicated these rows in the T1114 (aka,
> HPD:HelpDesk) are LOB's:
>
> C105940 z1D Template Related CI
> C100151 Detailed Decription
> C100156 Resolution
> C103742 z1D Mobile Worklog Upd
> C300270900 Reason Description
>
> All of these are character fields set to 0 (unlimited) length.
>
> The questions I have are:
>
> 1.) If a LOB is > 4K it is stored out of row regardless.  Can anyone tell me
> how to determine the space used by any of those particular fields in
> Oracle?  And how I can tell if these are in fact being stored out of row due
> to the "unlimited" option on the field?
>
> 2.) Aren't z1D fields supposed to be Display only according to Remedy's
> design and naming conventions?  I'm pretty sure that is the case but both of
> the fields above with that prefix are stored as optional.
>
> Thanks in advance -
>
> William Rentfrow
> Principal Consultant, StrataCom Inc.
> wrentf...@stratacominc.com
> O 715-592-5185
> C 715-410-8056
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Chat with Remedy

[Mansur, Joanne]

So does Bomgar, I believe.

Joanne Mansur
Client Systems Analyst
Northeastern University
(617) 373-3295 (office)
(617) 373-4354 (fax)
j.man...@neu.edu

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Shellman, David
Sent: Wednesday, November 18, 2009 11:19 AM
To: arslist@ARSLIST.ORG
Subject: Re: [ARSLIST] Chat with Remedy

**
Mark,

AT WWRUG09, my eService and Conversive had chat products that integrated within 
the AR System.

Dave


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Brittain, Mark
Sent: Wednesday, November 18, 2009 11:13 AM
To: arslist@ARSLIST.ORG
Subject: Chat with Remedy
**
Hi All,

Currently we have Citrix GoToAssist integrated with ARS 6.3, patch 20. Citrix 
has just informed us that we have to upgrade to their latest version by the end 
of the year. The catch is they no longer support integration with Remedy. I 
like to have back up/company when something stops working. So I was wondering 
if either BMC has a chat integration product or any other vendors that support 
the Remedy integration.

Thanks
Mark


Mark Brittain
Remedy Developer
NaviSite
mbritt...@navisite.com
(315) 453-2912 x5418 (Phone)
(315) 317.2897 (Cell)
Reduce Cost of IT with Managed Hosting and Application Services from NaviSite.
Visit www.NaviSite.com Today.


  
This e-mail is the property of NaviSite, Inc. It is intended only for the 
person or entity to which it is addressed and may contain information that is 
privileged, confidential, or otherwise protected from disclosure. Distribution 
or copying of this e-mail, or the information contained herein, to anyone other 
than the intended recipient is prohibited.
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Duplicate notifications on helpdesk modify

[Robert Fults]

I set up a filter to fire a notification on Modify of the HPD:HelpDesk form by 
anyone other than the assignee:

( 'Assignee Login ID' !=  $NULL$ ) AND ( ( 'Last Modified By' != 'Assignee 
Login ID') OR ( 'Last Modified By' !=  "AR_ESCALATOR" ) OR ( 'Last Modified By' 
!=  "Remedy Application Service" ) )

For some reason it fires twice, even when updated by the assignee.  Any ideas 
what I did wrong here?
Sincerely,

Robert Fults
Remedy Dev.
Florida International University
Email: rfu...@fiu.edu
http://uts.fiu.edu


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Duplicate notifications on helpdesk modify

[Shellman, David]

There was a bug in the email engine that generated duplicate messages.  What 
version of the email engine are you using?

Dave


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Robert Fults
Sent: Wednesday, November 18, 2009 11:38 AM
To: arslist@ARSLIST.ORG
Subject: Duplicate notifications on helpdesk modify

**

I set up a filter to fire a notification on Modify of the HPD:HelpDesk form by 
anyone other than the assignee:

( 'Assignee Login ID' !=  $NULL$ ) AND ( ( 'Last Modified By' != 'Assignee 
Login ID') OR ( 'Last Modified By' !=  "AR_ESCALATOR" ) OR ( 'Last Modified By' 
!=  "Remedy Application Service" ) )

For some reason it fires twice, even when updated by the assignee.  Any ideas 
what I did wrong here?
Sincerely,

Robert Fults
Remedy Dev.
Florida International University
Email: rfu...@fiu.edu
http://uts.fiu.edu

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

ITSP 4.0 on 7.5 arsystem?

[Dennis Ruble]

Hi All,
The compatibility matrix says that ITSP 4.0 isn't supported on arsystem 
7.5.  I'm not sure if there's some problem with it or if it just hasn't 
been QA'd.  I've asked several people at BMC and haven't gotten a 
response, so I'll ask you.  Anyone out there running ITSP 4.0 on arsystem 
7.5?  If so, have you found anything that doesn't work as expected?

Thanks in advance!

Dennis Ruble
Rockwell Collins

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Duplicate notifications on helpdesk modify

[Norbert Bolmer]

Hi Robert,

I think you have to replace the ORs with ANDs. 

If 'Last Modified By' is e.g. "AR_ESCALATOR" then 'Last Modified By' != 
'Assignee Login ID' is true

Br,
Norbert


Am 18.11.2009 um 17:37 schrieb Robert Fults:

> **
> I set up a filter to fire a notification on Modify of the HPD:HelpDesk form 
> by anyone other than the assignee:
> 
> ( 'Assignee Login ID' !=  $NULL$ ) AND ( ( 'Last Modified By' != 'Assignee 
> Login ID') OR ( 'Last Modified By' !=  "AR_ESCALATOR" ) OR ( 'Last Modified 
> By' !=  "Remedy Application Service" ) )
> 
> For some reason it fires twice, even when updated by the assignee.  Any ideas 
> what I did wrong here?
> 
> Sincerely,
> 
>  
> 
> Robert Fults
> 
> Remedy Dev.
> 
> Florida International University
> 
> Email: rfu...@fiu.edu
> 
> http://uts.fiu.edu
> 
>  
> 
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: [HERD] Duplicate notifications on helpdesk modify

[Thomas Bean]

Hi Robert,
I'm not sure why it is firing twice, but the 'OR' operators are the reason
it is firing even when the assignee makes the update (using 'AND' would
probably prevent this).

I would recommend trying a much simpler 'Run If' statement:

*'Assignee Login ID' != $USER$*

If the 'Assignee Login ID' field is NULL, it shouldn't meet the
qualification.

Hope that helps,

--Thomas

On Wed, Nov 18, 2009 at 10:37 AM, Robert Fults  wrote:

>  I set up a filter to fire a notification on Modify of the HPD:HelpDesk
> form by anyone other than the assignee:
>
> *( 'Assignee Login ID' !=  $NULL$ ) AND ( ( 'Last Modified By' !=
> 'Assignee Login ID') OR ( 'Last Modified By' !=  "AR_ESCALATOR" ) OR ( 'Last
> Modified By' !=  "Remedy Application Service" ) )*
>
> For some reason it fires twice, even when updated by the assignee.  Any
> ideas what I did wrong here?
>
> Sincerely,
>
>
>
> Robert Fults
>
> Remedy Dev.
>
> Florida International University
>
> Email: rfu...@fiu.edu
>
> http://uts.fiu.edu
>
>
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: [HERD] Duplicate notifications on helpdesk modify

[Robert Fults]

Thanks!  That is one issue down.  Still firing twice though.


From: Thomas Bean [mailto:bea...@slu.edu]
Sent: Wednesday, November 18, 2009 11:54 AM
To: Robert Fults
Cc: arslist@ARSLIST.ORG; herd-dispa...@lists.stanford.edu
Subject: Re: [HERD] Duplicate notifications on helpdesk modify

Hi Robert,
I'm not sure why it is firing twice, but the 'OR' operators are the reason it 
is firing even when the assignee makes the update (using 'AND' would probably 
prevent this).

I would recommend trying a much simpler 'Run If' statement:
'Assignee Login ID' != $USER$

If the 'Assignee Login ID' field is NULL, it shouldn't meet the qualification.

Hope that helps,

--Thomas
On Wed, Nov 18, 2009 at 10:37 AM, Robert Fults 
mailto:rfu...@fiu.edu>> wrote:

I set up a filter to fire a notification on Modify of the HPD:HelpDesk form by 
anyone other than the assignee:

( 'Assignee Login ID' !=  $NULL$ ) AND ( ( 'Last Modified By' != 'Assignee 
Login ID') OR ( 'Last Modified By' !=  "AR_ESCALATOR" ) OR ( 'Last Modified By' 
!=  "Remedy Application Service" ) )

For some reason it fires twice, even when updated by the assignee.  Any ideas 
what I did wrong here?
Sincerely,

Robert Fults
Remedy Dev.
Florida International University
Email: rfu...@fiu.edu
http://uts.fiu.edu



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Oracle in-row LOB storage issue - IM 7.03

[Grooms, Frederick W]

Wow... I actually have something to disagree with Axton on ...

If you create a form (since v6x) Remedy no longer uses the BtttCccc 
structure to hold the long character fields.  I am on 7.1.0 patch 7 with Oracle 
10g and all of my CLOB columns are just columns in the normal table.

   SQL> describe T10;
Name Null?Type
  ---
C1   NOT NULL VARCHAR2(15)
C2VARCHAR2(254)
C3   NOT NULL NUMBER(15)
C4VARCHAR2(254)
C5   NOT NULL VARCHAR2(254)
C6   NOT NULL NUMBER(15)
C7   NOT NULL NUMBER(15)
C8   NOT NULL VARCHAR2(128)
C536870912VARCHAR2(255)
C536870913CLOB
C536870914NUMBER(15)
C536870915CLOB
C536870916NUMBER(15)
C536870921VARCHAR2(4000)
C536870924VARCHAR2(4000)
C536870925NUMBER(15)
C54710VARCHAR2(255)

And if I look at the create script thru TOAD I see:

   CREATE TABLE T10
   (
 C1  VARCHAR2(15 BYTE) NOT NULL,
 C2  VARCHAR2(254 BYTE),
 C3  NUMBER(15)NOT NULL,
 C4  VARCHAR2(254 BYTE),
 C5  VARCHAR2(254 BYTE)NOT NULL,
 C6  NUMBER(15)NOT NULL,
 C7  NUMBER(15)NOT NULL,
 C8  VARCHAR2(128 BYTE)NOT NULL,
 C536870912  VARCHAR2(255 BYTE),
 C536870913  CLOB,
 C536870914  NUMBER(15),
 C536870915  CLOB,
 C536870916  NUMBER(15),
 C536870921  VARCHAR2(4000 BYTE),
 C536870924  VARCHAR2(4000 BYTE),
 C536870925  NUMBER(15),
 C54710  VARCHAR2(255 BYTE)
   )
   TABLESPACE ARSYSTEM
   LOGGING
   NOCOMPRESS
   LOB (C536870913) STORE AS
 ( TABLESPACE  ARSYSTEM
   ENABLE  STORAGE IN ROW
   CHUNK   8192
   PCTVERSION  10
   NOCACHE
 )
 LOB (C536870915) STORE AS
 ( TABLESPACE  ARSYSTEM
   ENABLE  STORAGE IN ROW
   CHUNK   8192
   PCTVERSION  10
   NOCACHE
 )
   NOCACHE
   NOPARALLEL
   MONITORING;


The Oracle query for schemaid 10 for me is:
   select SEGMENT_NAME, bytes
   from USER_SEGMENTS
   Where SEGMENT_NAME in (select SEGMENT_NAME from USER_LOBS where TABLE_NAME 
like '_10')
   orSEGMENT_NAME like '_10'
   orSEGMENT_NAME like '_10C%'


NOTE:  I used USER_SEGMENTS and USER_LOBS in case your DBA has locked down your 
database (and the DBA_ versions of these objects are not available)

Fred


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Axton
Sent: Wednesday, November 18, 2009 10:24 AM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle in-row LOB storage issue - IM 7.03

You can look at the oracle data dictionary view dba_segments to see
the size of the base tables, lob segments, indexes, etc:

Here is an example for schemaid 746:

SQL> ed
Wrote file afiedt.buf

  1  select bytes, segment_name, owner
  2  from dba_segments
  3  where (segment_name like '_746' or segment_name like '_746C%')
  4* and segment_type = 'TABLE'
SQL> /

 BYTES SEGMENT_NAME   OWNER
-- -- ---
   3407872 B746   ARADMIN
2390491136 T746   ARADMIN
  27525120 H746   ARADMIN
 932446208 B746C701000357 ARADMIN

B746C701000357 is the lob segment for field id 701000357.  The others
are the base tables.  You can run the query without the where clause
for segment_type to get the indexes, lob segment indexes, etc:

select bytes, segment_name, owner
from dba_segments
where (segment_name like '_746%' or segment_name like '_746C%')

Axton Grams

The opinions, statements, and/or suggested courses of action expressed
in this E-mail do not necessarily reflect those of BMC Software, Inc.
My voluntary participation in this forum is not intended to convey a
role as a spokesperson, liaison or public relations representative for
BMC Software, Inc.

On Wed, Nov 18, 2009 at 12:57 AM, William Rentfrow
 wrote:
> **
>
> I've read a LOT of the documentation, etc, regarding how LOB storage works
> (including Axton's very fine wiki on this topic) and I'm pretty familiar
> with it in theory.
>
> We are doing a data migration at the moment which is using an enormous
> amount of space.  We are in the process of migratiing 330,000 records as a
> test.
>
> This has used (so far) 33 GB of table space.  We only have 47 GB in this
> test system.  Considering the actual ARX exports were < 1 GB something is
> clearly not right here.
>
> Initial consultation with a DBA has indicated these rows in the T1114 (aka,
> HPD:HelpDesk) are LOB's:
>
> C105940 z1D Template Related CI
> C100151 Detailed Decription
> C100156 Resolution
> C103742 z1D Mobile Worklog Upd
> C300270900 Reason Description
>
> All of these are character fields set to 0 (unlimited

Re: [HERD] Duplicate notifications on helpdesk modify

[Shellman, David]

What does your filter log show?


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Robert Fults
Sent: Wednesday, November 18, 2009 12:01 PM
To: arslist@ARSLIST.ORG
Subject: Re: [HERD] Duplicate notifications on helpdesk modify

**
Thanks!  That is one issue down.  Still firing twice though.


From: Thomas Bean [mailto:bea...@slu.edu]
Sent: Wednesday, November 18, 2009 11:54 AM
To: Robert Fults
Cc: arslist@ARSLIST.ORG; herd-dispa...@lists.stanford.edu
Subject: Re: [HERD] Duplicate notifications on helpdesk modify

Hi Robert,
I'm not sure why it is firing twice, but the 'OR' operators are the reason it 
is firing even when the assignee makes the update (using 'AND' would probably 
prevent this).

I would recommend trying a much simpler 'Run If' statement:
'Assignee Login ID' != $USER$

If the 'Assignee Login ID' field is NULL, it shouldn't meet the qualification.

Hope that helps,

--Thomas
On Wed, Nov 18, 2009 at 10:37 AM, Robert Fults 
mailto:rfu...@fiu.edu>> wrote:

I set up a filter to fire a notification on Modify of the HPD:HelpDesk form by 
anyone other than the assignee:

( 'Assignee Login ID' !=  $NULL$ ) AND ( ( 'Last Modified By' != 'Assignee 
Login ID') OR ( 'Last Modified By' !=  "AR_ESCALATOR" ) OR ( 'Last Modified By' 
!=  "Remedy Application Service" ) )

For some reason it fires twice, even when updated by the assignee.  Any ideas 
what I did wrong here?
Sincerely,

Robert Fults
Remedy Dev.
Florida International University
Email: rfu...@fiu.edu
http://uts.fiu.edu


_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Server Information form time out

[Barnhill, Jason (Jason)]

Yes the portmapper seems to be the problem, as I also cannot login with
the clients with TCP port = blank.  As far as I can tell, portmapper is
running.  It's on a Solaris box, and I can see arserverd processes in
the rpcinfo listing.  But I am really weak on rpcinfo and portmapper.

 

Do you have any advice on how to check that portmapper is running
properly on a unix box?

 

Thanks!

Jason

 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Tuesday, November 17, 2009 7:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

 

If I understand correctly, the underlying error is this: ONC/RPC portmap
failure.  It sounds like it's trying to register itself with the
portmapper but can't.  Do you have the portmapper service running?

 

Lyle

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Tuesday, November 17, 2009 4:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

 

** 

Ah, I had looked in plugin log but not java plugin log.  I found this in
the arjavaplugin.log.  My java is weak.  Does this scream anything
obvious to anyone?  Not finding anything in kb...

 

2009-11-17 22:46:04,244 ERROR [main]
com.bmc.arsys.pluginsvr.ARPluginServerMain

(?:?) - AR Plugin Server Startup Error ONC/RPC portmap failure

org.acplt.oncrpc.OncRpcException: ONC/RPC portmap failure

at org.acplt.oncrpc.OncRpcPortmapClient.setPort(Unknown Source)

at
org.acplt.oncrpc.server.OncRpcTcpServerTransport.register(Unknown Sou

rce)

at com.bmc.arsys.pluginsvr.a.c.register(Unknown Source)

at org.acplt.oncrpc.server.OncRpcServerStub.register(Unknown
Source)

at org.acplt.oncrpc.server.OncRpcServerStub.run(Unknown Source)

at com.bmc.arsys.pluginsvr.ARPluginServerMain.main(Unknown
Source)

AR Plugin Server Startup ErrorONC/RPC portmap failure

 

Thanks!

Jason

 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Tuesday, November 17, 2009 4:46 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

 

Hi Lyle,

 

Yes, one of my coworkers did try that a little while ago, to no avail...

 

Thanks!

Jason

 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Tuesday, November 17, 2009 4:42 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

 

Just for giggles, can you try killing the plugin process, letting
armonitor restart it and try again?  I've seen similar errors when the
plugins aren't properly initialized (although I understand you don't see
any errors in the logs).

 

Lyle

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Tuesday, November 17, 2009 2:06 PM
To: arslist@ARSLIST.ORG
Subject: Server Information form time out

 

** 

Hi folks,

 

When I open the 'AR System Administration: Server Information' form it
times out...

 

ARERR [94] Timeout during database query -- consider using more specific
search criteria to narrow the results, and retry the operation :
psremap1

 

There are no plugin server errors on system startup or in the plugin
logs.  Anybody else seen this one?

 

Thanks,

Jason

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ 



NOTICE: This email message is for the sole use of the intended
recipient(s) and may contain confidential and privileged information.
Any unauthorized review, use, disclosure or distribution is prohibited.
If you are not the intended recipient, please contact the sender by
reply email and destroy all copies of the original message.

 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the
Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist:
"Where the Answers Are"_

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Server Information form time out

[Shellman, David]

Is there a firewall in between the clients and the server?  The initial traffic 
from the client to the server uses UDP if the TCP port is blank.  This is an 
initial conversation to the portmapper to figure out which TCP port to use to 
carry on the conversation.  Most network folks have UDP blocked in the firewall 
rules.

Dave


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Wednesday, November 18, 2009 12:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

**
Yes the portmapper seems to be the problem, as I also cannot login with the 
clients with TCP port = blank.  As far as I can tell, portmapper is running.  
It's on a Solaris box, and I can see arserverd processes in the rpcinfo 
listing.  But I am really weak on rpcinfo and portmapper.

Do you have any advice on how to check that portmapper is running properly on a 
unix box?

Thanks!
Jason


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Tuesday, November 17, 2009 7:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

If I understand correctly, the underlying error is this: ONC/RPC portmap 
failure.  It sounds like it's trying to register itself with the portmapper but 
can't.  Do you have the portmapper service running?

Lyle

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Tuesday, November 17, 2009 4:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

**
Ah, I had looked in plugin log but not java plugin log.  I found this in the 
arjavaplugin.log.  My java is weak.  Does this scream anything obvious to 
anyone?  Not finding anything in kb...

2009-11-17 22:46:04,244 ERROR [main] com.bmc.arsys.pluginsvr.ARPluginServerMain
(?:?) - AR Plugin Server Startup Error ONC/RPC portmap failure
org.acplt.oncrpc.OncRpcException: ONC/RPC portmap failure
at org.acplt.oncrpc.OncRpcPortmapClient.setPort(Unknown Source)
at org.acplt.oncrpc.server.OncRpcTcpServerTransport.register(Unknown Sou
rce)
at com.bmc.arsys.pluginsvr.a.c.register(Unknown Source)
at org.acplt.oncrpc.server.OncRpcServerStub.register(Unknown Source)
at org.acplt.oncrpc.server.OncRpcServerStub.run(Unknown Source)
at com.bmc.arsys.pluginsvr.ARPluginServerMain.main(Unknown Source)
AR Plugin Server Startup ErrorONC/RPC portmap failure

Thanks!
Jason


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Tuesday, November 17, 2009 4:46 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

Hi Lyle,

Yes, one of my coworkers did try that a little while ago, to no avail...

Thanks!
Jason


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Tuesday, November 17, 2009 4:42 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

Just for giggles, can you try killing the plugin process, letting armonitor 
restart it and try again?  I've seen similar errors when the plugins aren't 
properly initialized (although I understand you don't see any errors in the 
logs).

Lyle

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Tuesday, November 17, 2009 2:06 PM
To: arslist@ARSLIST.ORG
Subject: Server Information form time out

**
Hi folks,

When I open the 'AR System Administration: Server Information' form it times 
out...

ARERR [94] Timeout during database query -- consider using more specific search 
criteria to narrow the results, and retry the operation : psremap1

There are no plugin server errors on system startup or in the plugin logs.  
Anybody else seen this one?

Thanks,
Jason
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_


NOTICE: This email message is for the sole use of the intended recipient(s) and 
may contain confidential and privileged information. Any unauthorized review, 
use, disclosure or distribution is prohibited. If you are not the intended 
recipient, please contact the sender by reply email and destroy all copies of 
the original message.

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ 
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ 
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ 
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archive

Re: WWRUG ARSLIST Awards

[Hulmes, Timothy W Mr CTR USA IMCOM]

I have some catching up to doI am averaging 1 post a year right now


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of LJ Longwing
Sent: Thursday, November 12, 2009 9:11 AM
To: arslist@ARSLIST.ORG
Subject: Re: WWRUG ARSLIST Awards

New or old?and 350?...that's almost a post a day for the entire year


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Jason Miller
Sent: Wednesday, November 11, 2009 3:58 PM
To: arslist@ARSLIST.ORG
Subject: Re: WWRUG ARSLIST Awards

There were some cracks about your last name :)

On 11/11/09, LJ Longwing  wrote:
> Wow, what a dubious honor...does that make me helpful or wordy?
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Doug Blair
> Sent: Wednesday, November 11, 2009 11:23 AM
> To: arslist@ARSLIST.ORG
> Subject: WWRUG ARSLIST Awards
>
> Hello from the conference in Las Vegas
>
> For the first time this year, the ARSLIST award winners were announced 
> in near-real time on Twitter :-)  But for the rest of us, here's what 
> I remember (Dan et all, please add the ones I missed!)
>
> There were, a number of varied, goofy, unusual and amusing awards...
> you'll just have to come to the next conference to enjoy these.  There 
> were also pictures and songs from previous RUG's and Userworld 
> conferences, music and an impassioned speech from Phil Bautista about 
> organizing Remedy User Groups. At several times the presentations were 
> interrupted by "spontaneous" tossing of the official WWRUG food item:
> Twinkies!  Doug Mueller was kind enough to explain the significance of 
> the fond association between RUG attendees and Twinkies.
>
> Most posts: LJ Longwing (350)
> Longest Thread: (most posts on a single topic) History of the AR 
> System (90) Jet Lag Award - Australia (fellow from New Zealand wasn't 
> in the room!)
>
> BMC Employee Beyond The Call of Duty award: Kelly Deaver (who is no 
> longer a BMC employee but was during the nomination and voting period)
>
> Most Valuable ARSLIST Poster: Dr. Christopher Strauss
>
> Congratulations!
>
> Now, I've got to attend some of the sessions and learn some more stuff!
>
>
> Doug
>
> --
> Doug Blair
> d...@blairing.com
> +1 224-558-5462
>
> 200 North Arlington Heights Road
> Arlington Heights, Illinois 60004
>
>
>
> __
> __
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum 
> Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
>
> __
> _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
>


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum
Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum
Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"


smime.p7s
Description: S/MIME cryptographic signature

Re: WWRUG ARSLIST Awards

[Hulmes, Timothy W Mr CTR USA IMCOM]

I have some catching up to doI am averaging 1 post a year right now

Tim

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of LJ Longwing
Sent: Thursday, November 12, 2009 9:11 AM
To: arslist@ARSLIST.ORG
Subject: Re: WWRUG ARSLIST Awards

New or old?and 350?...that's almost a post a day for the entire
year


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Jason Miller
Sent: Wednesday, November 11, 2009 3:58 PM
To: arslist@ARSLIST.ORG
Subject: Re: WWRUG ARSLIST Awards

There were some cracks about your last name :)

On 11/11/09, LJ Longwing  wrote:
> Wow, what a dubious honor...does that make me helpful or wordy?
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Doug Blair
> Sent: Wednesday, November 11, 2009 11:23 AM
> To: arslist@ARSLIST.ORG
> Subject: WWRUG ARSLIST Awards
>
> Hello from the conference in Las Vegas
>
> For the first time this year, the ARSLIST award winners were announced

> in near-real time on Twitter :-)  But for the rest of us, here's what 
> I remember (Dan et all, please add the ones I missed!)
>
> There were, a number of varied, goofy, unusual and amusing awards...
> you'll just have to come to the next conference to enjoy these.  There

> were also pictures and songs from previous RUG's and Userworld 
> conferences, music and an impassioned speech from Phil Bautista about 
> organizing Remedy User Groups. At several times the presentations were

> interrupted by "spontaneous" tossing of the official WWRUG food item:
> Twinkies!  Doug Mueller was kind enough to explain the significance of

> the fond association between RUG attendees and Twinkies.
>
> Most posts: LJ Longwing (350)
> Longest Thread: (most posts on a single topic) History of the AR 
> System (90) Jet Lag Award - Australia (fellow from New Zealand wasn't 
> in the room!)
>
> BMC Employee Beyond The Call of Duty award: Kelly Deaver (who is no 
> longer a BMC employee but was during the nomination and voting period)
>
> Most Valuable ARSLIST Poster: Dr. Christopher Strauss
>
> Congratulations!
>
> Now, I've got to attend some of the sessions and learn some more
stuff!
>
>
> Doug
>
> --
> Doug Blair
> d...@blairing.com
> +1 224-558-5462
>
> 200 North Arlington Heights Road
> Arlington Heights, Illinois 60004
>
>
>
> __
> __
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum 
> Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
>
> __
> _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"
>



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum
Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum
Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

WWRUG09 Twitter Feed @weazel8

[Hulmes, Timothy W Mr CTR USA IMCOM]

What a great conference.  I tried to keep everyone up to date with my
twitter feed from the conference, weazel8.

Hope all of you enjoyed the feed that couldn't make the
conferenceCan't wait for WWRUG10

Timothy W. Hulmes

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Firewall TCP Timeouts

[Leihkauff, Kenneth]

Thanks for your time, Axton.  I spoke with our network engineer and he studied 
the firewall logs and sees quit a few denials and some resets, but is confident 
things should be set up correctly on the firewall.  He only sees these 
denials/resets for the Midtier application, not some of our other apps.  

Here is what we're observing on the Linux Midtier server.  Below is an example 
of 3 existing tcp connections that remain intact indefinitely or until midtier 
is restarted.  The firewall knows about these 3 tcp connections, but if the 
connections are idle for more than 60 minutes (default firewall setting), the 
firewall will drop these idle tcp connections.  Then, when a user gets on 
midtier (after the idle period), midtier will attempt to use one or more of 
these tcp connections and the firewall responds with a Deny (since it has aged 
off the inactive connection).  This is normal behavior for a firewall as I 
understand things, but the application (midtier in this case) should ideally 
make use of the tcp keepalive or inactivetly timeout supported by Linux.  
Apparently, midtier does not take advantage of this.

I suspect other customers are having this problem IF their topology utilizes a 
firewall between Midtier and ARS and there are long periods of inactivity.  The 
reason, however, they may not be complaining is because once you get the RCP 
failure (arerr 91), then subsequent connections seem to work fine.  For the 
example below, once the arerr 91 timeout finally occurred, the associated tcp 
connection was terminated on the midtier server and a new one was created.  

$netstat -antopp|grep 2031
Proto Recv-Q Send-Q Local Address   Foreign Address 
State   Timer
tcp0  0 :::172.16.0.129:54310   :::10.1.1.141:2031  
ESTABLISHED 24977/java  off (0.00/0/0)
tcp0864 :::172.16.0.129:54309   :::10.1.1.141:2031  
ESTABLISHED 24977/java  on (3.59/12/0)
tcp0   1416 :::172.16.0.129:43717   :::10.1.1.141:2031  
ESTABLISHED 24977/java  on (16.19/11/0)

After a very long wait trying to login in, the user will receive this message:
ARERR [91]
RPC call failed : ONC/RPC call timed out


Ken 


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Axton
Sent: Tuesday, November 17, 2009 3:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Firewall TCP Timeouts

You need to configure your firewall properly.  With a firewall, you
can define what types of packets can create a state entry on the
firewall.  Typical is syn, syn ack.  Even if there is no state entry,
a new packet should create a new state (not be dropped).  If a new
packet does not create a new state, change the firewall rules so that
it does.  A network dump will tell you what type of packet is going
out; the firewall logs should tell you what type of packet was
rejected.

I could see that this would be a problem if the midtier servers were
behind a NAT.  Is this the case?

Axton Grams

On Tue, Nov 17, 2009 at 12:07 PM, Leihkauff, Kenneth
 wrote:
> **
>
> Hello,
>
>
>
> We have a firewall between our MidTier server and ARS system.  The firewall
> is configured to drop tcp connections after being idle for 60 minutes
> (typical/default firewall setting).  Several MidTier user sessions will make
> use of a shared tcp connection so you might have 100 sessions but
> significantly fewer tcp connections.  During idle times (like at night), the
> firewall will discard these idle tcp connections but the MidTier server will
> still retain these tcp references (this can be seen by using "netstat
> -anto").  So, when users get back on the system, MidTier apparently is
> trying to utilize one of these defunct tcp connections so you end up with
> problems like ARERR 91 rpc timeouts because these tcp connections are broken
> pipes.
>
>
>
> Is there a MidTier/Tomcat or other setting that you have found addresses
> this problem?
>
>
>
> Thanks.
>
>
>
> Ken
>
>
>
> Background:
>
> Version 7.5 patch 3
>
> MidTier - Linux, Tomcat JSP
>
> ARS - Linux, Oracle 10g
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Server Information form time out

[Barnhill, Jason (Jason)]

Hi David,

No there is no firewall.  We have two servers in that domain, and until
this week we could login to both with TCP port = blank.  This week I can
still login to the other server with TCP = blank, so that indicates
network is not a problem...

Thanks!

Jason



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Shellman, David
Sent: Wednesday, November 18, 2009 12:13 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

 

Is there a firewall in between the clients and the server?  The initial
traffic from the client to the server uses UDP if the TCP port is blank.
This is an initial conversation to the portmapper to figure out which
TCP port to use to carry on the conversation.  Most network folks have
UDP blocked in the firewall rules.

 

Dave

 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Wednesday, November 18, 2009 12:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

Yes the portmapper seems to be the problem, as I also cannot login with
the clients with TCP port = blank.  As far as I can tell, portmapper is
running.  It's on a Solaris box, and I can see arserverd processes in
the rpcinfo listing.  But I am really weak on rpcinfo and portmapper.

 

Do you have any advice on how to check that portmapper is running
properly on a unix box?

 

Thanks!

Jason

 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Tuesday, November 17, 2009 7:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

 

If I understand correctly, the underlying error is this: ONC/RPC portmap
failure.  It sounds like it's trying to register itself with the
portmapper but can't.  Do you have the portmapper service running?

 

Lyle

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Tuesday, November 17, 2009 4:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

 

Ah, I had looked in plugin log but not java plugin log.  I found this in
the arjavaplugin.log.  My java is weak.  Does this scream anything
obvious to anyone?  Not finding anything in kb...

 

2009-11-17 22:46:04,244 ERROR [main]
com.bmc.arsys.pluginsvr.ARPluginServerMain

(?:?) - AR Plugin Server Startup Error ONC/RPC portmap failure

org.acplt.oncrpc.OncRpcException: ONC/RPC portmap failure

at org.acplt.oncrpc.OncRpcPortmapClient.setPort(Unknown Source)

at
org.acplt.oncrpc.server.OncRpcTcpServerTransport.register(Unknown Sou

rce)

at com.bmc.arsys.pluginsvr.a.c.register(Unknown Source)

at org.acplt.oncrpc.server.OncRpcServerStub.register(Unknown
Source)

at org.acplt.oncrpc.server.OncRpcServerStub.run(Unknown Source)

at com.bmc.arsys.pluginsvr.ARPluginServerMain.main(Unknown
Source)

AR Plugin Server Startup ErrorONC/RPC portmap failure

 

Thanks!

Jason

 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Tuesday, November 17, 2009 4:46 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

 

Hi Lyle,

 

Yes, one of my coworkers did try that a little while ago, to no avail...

 

Thanks!

Jason

 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Tuesday, November 17, 2009 4:42 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

 

Just for giggles, can you try killing the plugin process, letting
armonitor restart it and try again?  I've seen similar errors when the
plugins aren't properly initialized (although I understand you don't see
any errors in the logs).

 

Lyle

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Tuesday, November 17, 2009 2:06 PM
To: arslist@ARSLIST.ORG
Subject: Server Information form time out

 

Hi folks,

 

When I open the 'AR System Administration: Server Information' form it
times out...

 

ARERR [94] Timeout during database query -- consider using more specific
search criteria to narrow the results, and retry the operation :
psremap1

 

There are no plugin server errors on system startup or in the plugin
logs.  Anybody else seen this one?

 

Thanks,

Jason

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: WWRUG09 Twitter Feed @weazel8

[LJ Longwing]

Is it just me or did everyone else get this exact same post 2 days ago? 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Hulmes, Timothy W Mr CTR USA IMCOM
Sent: Wednesday, November 18, 2009 10:17 AM
To: arslist@ARSLIST.ORG
Subject: WWRUG09 Twitter Feed @weazel8

What a great conference.  I tried to keep everyone up to date with my
twitter feed from the conference, weazel8.

Hope all of you enjoyed the feed that couldn't make the conferenceCan't
wait for WWRUG10

Timothy W. Hulmes


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum
Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Parse Group Members for Notification

[jham36]

Thanks for the reply.  I was looking at the CTM:Support Group
Association form.  I wasn't aware of "server side tables" and how they
worked.
I did a quick test with some test forms, filters and a filter guide.
It worked.
Now we just need to go lookup the user notification preferences and
some other tweaking and we should be all set.

Thanks,
James

On Nov 17, 5:19 pm, Lyle Taylor  wrote:
> Do you mean that for a given group, you want to create a notification record 
> for each individual in the group, meaning that the problem is how to get the 
> list of members of the group and iterate over that list to create a new 
> record for each one?
>
> If that's the case, the group memberships of people are stored in the 
> CTM:Support Group Association form.  In principle, you should be able to 
> create a table that references this form, filtering on the support group 
> name, that you can run a filter guide on to iterate over all the records in 
> the table.  You can then create an individual notification record for each 
> row in the table.
>
> Does that address what you're trying to do?
>
> Otherwise, the OOTB workflow handles group notifications a little differently 
> than individual notifications.  Individual notifications (e.g., Customer, 
> Assignee, etc.) are processed immediately - so you'll immediately see the 
> notification record for that individual when you perform an action on a 
> record that generates a notification.  However, for group notifications, it 
> does it in two steps.  First it creates an initial entry for the group, and 
> then an escalation (maybe SYS:NPC:IM1-TriggerGroupNTG) takes care of 
> processing the group notifications to generate the individual notifications.  
> That may be why you weren't seeing it in your log files - if you didn't wait 
> long enough, the escalation may not have fired before you turned off logging.
>
> Sorry for not providing more detail - I'm trying to be quick writing this 
> while hoping that the general information will help steer you in the right 
> direction.  If any of this doesn't make sense, let me know.
>
> Lyle
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of jham36
> Sent: Tuesday, November 17, 2009 2:53 PM
> To: arsl...@arslist.org
> Subject: Parse Group Members for Notification
>
> Group,
>
> We have created some custom workflow and notifications outside of the
> Notification Engine that ITSM uses.
> We want to take advantage of the user notification preferences as part
> of this.  I turned logging on for the ootb notification process.  I
> see that for group notifications, a notify record is created for each
> user in the group.  Then the user preferences are checked to see if
> the notification should be sent.
> For the life of me, I cannot figure out how to create a record for
> each of the group members on my notify form.  I know the support group
> name and the group name for it from the group form.
> I looked over the log file for longer than I want to admit.  I cannot
> seem to identify how bmc creates the individual notify records for the
> support group members.
> Any ideas?
>
> We have ARS 7.1 patch 7, ITSM 7.03 patch 9, Win 2003 Server, Oracle
> 10G
>
> Thanks,
> James
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
>
>  NOTICE: This email message is for the sole use of the intended recipient(s) 
> and may contain confidential and privileged information. Any unauthorized 
> review, use, disclosure or distribution is prohibited. If you are not the 
> intended recipient, please contact the sender by reply email and destroy all 
> copies of the original message.
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Oracle in-row LOB storage issue - IM 7.03

[Grooms, Frederick W]

I should have posted my output:
   select SEGMENT_NAME, bytes
   from USER_SEGMENTS
   Where SEGMENT_NAME in (select SEGMENT_NAME from USER_LOBS where TABLE_NAME 
like '_10' or TABLE_NAME like '_10C%')
   orSEGMENT_NAME like '_10'
   orSEGMENT_NAME like '_10C%'

   SEGMENT_NAMEBYTES
   -- --
   B10   1048576
   H10   2097152
   T10   2097152
   SYS_LOB039519C00010$$ 1048576
   SYS_LOB039519C00012$$ 1048576

You can verify the In Row of your CLOB data with:
   select TABLE_NAME, COLUMN_NAME, SEGMENT_NAME, IN_ROW
   from USER_LOBS
   where TABLE_NAME like '_10' or TABLE_NAME like '_10C%'

   TABLE_NAME  COLUMN_NAME  SEGMENT_NAME   IN_ROW
   ---  -- ---
   T10 C536870915   SYS_LOB039519C00012$$  YES
   T10 C536870913   SYS_LOB039519C00010$$  YES

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
Sent: Wednesday, November 18, 2009 11:02 AM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle in-row LOB storage issue - IM 7.03

Wow... I actually have something to disagree with Axton on ...

If you create a form (since v6x) Remedy no longer uses the BtttCccc 
structure to hold the long character fields.  I am on 7.1.0 patch 7 with Oracle 
10g and all of my CLOB columns are just columns in the normal table.

   SQL> describe T10;
Name Null?Type
  ---
C1   NOT NULL VARCHAR2(15)
C2VARCHAR2(254)
C3   NOT NULL NUMBER(15)
C4VARCHAR2(254)
C5   NOT NULL VARCHAR2(254)
C6   NOT NULL NUMBER(15)
C7   NOT NULL NUMBER(15)
C8   NOT NULL VARCHAR2(128)
C536870912VARCHAR2(255)
C536870913CLOB
C536870914NUMBER(15)
C536870915CLOB
C536870916NUMBER(15)
C536870921VARCHAR2(4000)
C536870924VARCHAR2(4000)
C536870925NUMBER(15)
C54710VARCHAR2(255)

And if I look at the create script thru TOAD I see:

   CREATE TABLE T10
   (
 C1  VARCHAR2(15 BYTE) NOT NULL,
 C2  VARCHAR2(254 BYTE),
 C3  NUMBER(15)NOT NULL,
 C4  VARCHAR2(254 BYTE),
 C5  VARCHAR2(254 BYTE)NOT NULL,
 C6  NUMBER(15)NOT NULL,
 C7  NUMBER(15)NOT NULL,
 C8  VARCHAR2(128 BYTE)NOT NULL,
 C536870912  VARCHAR2(255 BYTE),
 C536870913  CLOB,
 C536870914  NUMBER(15),
 C536870915  CLOB,
 C536870916  NUMBER(15),
 C536870921  VARCHAR2(4000 BYTE),
 C536870924  VARCHAR2(4000 BYTE),
 C536870925  NUMBER(15),
 C54710  VARCHAR2(255 BYTE)
   )
   TABLESPACE ARSYSTEM
   LOGGING
   NOCOMPRESS
   LOB (C536870913) STORE AS
 ( TABLESPACE  ARSYSTEM
   ENABLE  STORAGE IN ROW
   CHUNK   8192
   PCTVERSION  10
   NOCACHE
 )
 LOB (C536870915) STORE AS
 ( TABLESPACE  ARSYSTEM
   ENABLE  STORAGE IN ROW
   CHUNK   8192
   PCTVERSION  10
   NOCACHE
 )
   NOCACHE
   NOPARALLEL
   MONITORING;


The Oracle query for schemaid 10 for me is:
   select SEGMENT_NAME, bytes
   from USER_SEGMENTS
   Where SEGMENT_NAME in (select SEGMENT_NAME from USER_LOBS where TABLE_NAME 
like '_10')
   orSEGMENT_NAME like '_10'
   orSEGMENT_NAME like '_10C%'


NOTE:  I used USER_SEGMENTS and USER_LOBS in case your DBA has locked down your 
database (and the DBA_ versions of these objects are not available)

Fred


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Axton
Sent: Wednesday, November 18, 2009 10:24 AM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle in-row LOB storage issue - IM 7.03

You can look at the oracle data dictionary view dba_segments to see
the size of the base tables, lob segments, indexes, etc:

Here is an example for schemaid 746:

SQL> ed
Wrote file afiedt.buf

  1  select bytes, segment_name, owner
  2  from dba_segments
  3  where (segment_name like '_746' or segment_name like '_746C%')
  4* and segment_type = 'TABLE'
SQL> /

 BYTES SEGMENT_NAME   OWNER
-- -- ---
   3407872 B746   ARADMIN
2390491136 T746   ARADMIN
  27525120 H746   ARADMIN
 932446208 B746C701000357 ARADMIN

B746C701000357 is the lob segment for field id 701000357.  The others
are the base tables.  You can run the query without the where clause
for segment_type to get the indexes, lob segment indexes, etc:

select bytes, segment_name, owner
from dba_segments
where (segment_name like '_746%' o

Re: WWRUG09 Twitter Feed @weazel8

[Shellman, David]

Dan may be resetting servers and messages that were stuck in the web interface 
are now popping out.

Dave 

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of LJ Longwing
Sent: Wednesday, November 18, 2009 12:21 PM
To: arslist@ARSLIST.ORG
Subject: Re: WWRUG09 Twitter Feed @weazel8

Is it just me or did everyone else get this exact same post 2 days ago? 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Hulmes, Timothy W Mr CTR USA IMCOM
Sent: Wednesday, November 18, 2009 10:17 AM
To: arslist@ARSLIST.ORG
Subject: WWRUG09 Twitter Feed @weazel8

What a great conference.  I tried to keep everyone up to date with my
twitter feed from the conference, weazel8.

Hope all of you enjoyed the feed that couldn't make the conferenceCan't
wait for WWRUG10

Timothy W. Hulmes


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum
Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Duplicate notifications on helpdesk modify

[Robert Fults]

7.1 patch 007

Sincerely,

Robert Fults
Coordinator, UTS Support Center
Florida International University
University Park, PC 330
Miami, Florida 33199
Office: 305-348-2284
Email: rfu...@fiu.edu
http://uts.fiu.edu

From: Shellman, David [mailto:dave.shell...@tycoelectronics.com]
Sent: Wednesday, November 18, 2009 11:40 AM
Subject: Re: Duplicate notifications on helpdesk modify

**
There was a bug in the email engine that generated duplicate messages.  What 
version of the email engine are you using?

Dave


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Robert Fults
Sent: Wednesday, November 18, 2009 11:38 AM
To: arslist@ARSLIST.ORG
Subject: Duplicate notifications on helpdesk modify
**

I set up a filter to fire a notification on Modify of the HPD:HelpDesk form by 
anyone other than the assignee:

( 'Assignee Login ID' !=  $NULL$ ) AND ( ( 'Last Modified By' != 'Assignee 
Login ID') OR ( 'Last Modified By' !=  "AR_ESCALATOR" ) OR ( 'Last Modified By' 
!=  "Remedy Application Service" ) )

For some reason it fires twice, even when updated by the assignee.  Any ideas 
what I did wrong here?
Sincerely,

Robert Fults
Remedy Dev.
Florida International University
Email: rfu...@fiu.edu
http://uts.fiu.edu

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Server Information form time out

[Shellman, David]

It is an item often overlooked.  It still doesn't mean that it's not a network 
issue.  The network folks may have that portion of the network configured to 
not route UDP.

Dave


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Wednesday, November 18, 2009 12:20 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

**
Hi David,
No there is no firewall.  We have two servers in that domain, and until this 
week we could login to both with TCP port = blank.  This week I can still login 
to the other server with TCP = blank, so that indicates network is not a 
problem...
Thanks!
Jason

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Shellman, David
Sent: Wednesday, November 18, 2009 12:13 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

Is there a firewall in between the clients and the server?  The initial traffic 
from the client to the server uses UDP if the TCP port is blank.  This is an 
initial conversation to the portmapper to figure out which TCP port to use to 
carry on the conversation.  Most network folks have UDP blocked in the firewall 
rules.

Dave


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Wednesday, November 18, 2009 12:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out
Yes the portmapper seems to be the problem, as I also cannot login with the 
clients with TCP port = blank.  As far as I can tell, portmapper is running.  
It's on a Solaris box, and I can see arserverd processes in the rpcinfo 
listing.  But I am really weak on rpcinfo and portmapper.

Do you have any advice on how to check that portmapper is running properly on a 
unix box?

Thanks!
Jason


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Tuesday, November 17, 2009 7:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

If I understand correctly, the underlying error is this: ONC/RPC portmap 
failure.  It sounds like it's trying to register itself with the portmapper but 
can't.  Do you have the portmapper service running?

Lyle

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Tuesday, November 17, 2009 4:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

Ah, I had looked in plugin log but not java plugin log.  I found this in the 
arjavaplugin.log.  My java is weak.  Does this scream anything obvious to 
anyone?  Not finding anything in kb...

2009-11-17 22:46:04,244 ERROR [main] com.bmc.arsys.pluginsvr.ARPluginServerMain
(?:?) - AR Plugin Server Startup Error ONC/RPC portmap failure
org.acplt.oncrpc.OncRpcException: ONC/RPC portmap failure
at org.acplt.oncrpc.OncRpcPortmapClient.setPort(Unknown Source)
at org.acplt.oncrpc.server.OncRpcTcpServerTransport.register(Unknown Sou
rce)
at com.bmc.arsys.pluginsvr.a.c.register(Unknown Source)
at org.acplt.oncrpc.server.OncRpcServerStub.register(Unknown Source)
at org.acplt.oncrpc.server.OncRpcServerStub.run(Unknown Source)
at com.bmc.arsys.pluginsvr.ARPluginServerMain.main(Unknown Source)
AR Plugin Server Startup ErrorONC/RPC portmap failure

Thanks!
Jason


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Tuesday, November 17, 2009 4:46 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

Hi Lyle,

Yes, one of my coworkers did try that a little while ago, to no avail...

Thanks!
Jason


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Tuesday, November 17, 2009 4:42 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

Just for giggles, can you try killing the plugin process, letting armonitor 
restart it and try again?  I've seen similar errors when the plugins aren't 
properly initialized (although I understand you don't see any errors in the 
logs).

Lyle

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Tuesday, November 17, 2009 2:06 PM
To: arslist@ARSLIST.ORG
Subject: Server Information form time out

Hi folks,

When I open the 'AR System Administration: Server Information' form it times 
out...

ARERR [94] Timeout during database query -- consider using more specific search 
criteria to narrow the results, and retry the operation : psremap1

There are no plugin server errors on system startup or in the plugin logs.  
Any

JVM output -- only sees 2GB - but machine has 4GB?

[John Sundberg]

Below is the output of a hs_err_pid file -- the JVM is only seeing 2GB  
-- but the physical machine has 4GB.


Does anybody know why?


Also -- does anybody on a Windows 2003 Server see anything (relevant)  
different if they get a pid file?



Any other suggestions are welcome.


Thanks,


-John




---  S Y S T E M  ---

OS: Windows Server 2003 family Build 3790 Service Pack 2

CPU:total 1 (8 cores per cpu, 1 threads per core) family 6 model 10  
stepping 5, cmov, cx8, fxsr, mmx, sse, sse2, sse3, ssse3


Memory: 4k page, physical 2097151k(1391860k free), swap  
4194303k(3394944k free)


vm_info: Java HotSpot(TM) Server VM (11.3-b02) for windows-x86 JRE  
(1.6.0_13-b03), built on Mar  9 2009 01:10:11 by "java_re" with MS VC+ 
+ 7.1


time: Fri Nov 13 14:11:23 2009
elapsed time: 77507 seconds











--
John David Sundberg
235 East 6th Street, Suite 400B
St. Paul, MN 55101
(651) 556-0930-work
(651) 247-6766-cell
(651) 695-8577-fax
john.sundb...@kineticdata.com






___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Server Information form time out

[Lyle Taylor]

Which version of AR Server are you running?

Lyle

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Wednesday, November 18, 2009 10:06 AM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

**
Yes the portmapper seems to be the problem, as I also cannot login with the 
clients with TCP port = blank.  As far as I can tell, portmapper is running.  
It's on a Solaris box, and I can see arserverd processes in the rpcinfo 
listing.  But I am really weak on rpcinfo and portmapper.

Do you have any advice on how to check that portmapper is running properly on a 
unix box?

Thanks!
Jason


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Tuesday, November 17, 2009 7:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

If I understand correctly, the underlying error is this: ONC/RPC portmap 
failure.  It sounds like it's trying to register itself with the portmapper but 
can't.  Do you have the portmapper service running?

Lyle

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Tuesday, November 17, 2009 4:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

**
Ah, I had looked in plugin log but not java plugin log.  I found this in the 
arjavaplugin.log.  My java is weak.  Does this scream anything obvious to 
anyone?  Not finding anything in kb...

2009-11-17 22:46:04,244 ERROR [main] com.bmc.arsys.pluginsvr.ARPluginServerMain
(?:?) - AR Plugin Server Startup Error ONC/RPC portmap failure
org.acplt.oncrpc.OncRpcException: ONC/RPC portmap failure
at org.acplt.oncrpc.OncRpcPortmapClient.setPort(Unknown Source)
at org.acplt.oncrpc.server.OncRpcTcpServerTransport.register(Unknown Sou
rce)
at com.bmc.arsys.pluginsvr.a.c.register(Unknown Source)
at org.acplt.oncrpc.server.OncRpcServerStub.register(Unknown Source)
at org.acplt.oncrpc.server.OncRpcServerStub.run(Unknown Source)
at com.bmc.arsys.pluginsvr.ARPluginServerMain.main(Unknown Source)
AR Plugin Server Startup ErrorONC/RPC portmap failure

Thanks!
Jason


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Tuesday, November 17, 2009 4:46 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

Hi Lyle,

Yes, one of my coworkers did try that a little while ago, to no avail...

Thanks!
Jason


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Tuesday, November 17, 2009 4:42 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

Just for giggles, can you try killing the plugin process, letting armonitor 
restart it and try again?  I've seen similar errors when the plugins aren't 
properly initialized (although I understand you don't see any errors in the 
logs).

Lyle

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Tuesday, November 17, 2009 2:06 PM
To: arslist@ARSLIST.ORG
Subject: Server Information form time out

**
Hi folks,

When I open the 'AR System Administration: Server Information' form it times 
out...

ARERR [94] Timeout during database query -- consider using more specific search 
criteria to narrow the results, and retry the operation : psremap1

There are no plugin server errors on system startup or in the plugin logs.  
Anybody else seen this one?

Thanks,
Jason
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_


NOTICE: This email message is for the sole use of the intended recipient(s) and 
may contain confidential and privileged information. Any unauthorized review, 
use, disclosure or distribution is prohibited. If you are not the intended 
recipient, please contact the sender by reply email and destroy all copies of 
the original message.

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ 
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ 
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ 
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Oracle in-row LOB storage issue - IM 7.03

[William Rentfrow]

Thanks for all the responses.

I'm trying to reconcile our db size usage (53% of 47 MB after some 
re-structuring) with BMC's in-row examples.

The in-row examples (from Oracle) in their docs mention a table with 43000+ 
with 32000+ of those having LOB entries and a size of ~261 MB.

Even if I give Remedy a 50% fudge factor and bump that number to 390 (heck, 
let's go 400) we are using nearly 100X the space.  And we only have 10X the 
records.  

All LOBS are now confirmed (again) as being in-row - waiting for BMC..and any 
bright ideas from the list.  DBA is working on your suggestions to determine 
where exactly all the space has gone.

William Rentfrow
Principal Consultant, StrataCom Inc.
wrentf...@stratacominc.com
O 715-592-5185
C 715-410-8056

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
Sent: Wednesday, November 18, 2009 11:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle in-row LOB storage issue - IM 7.03

I should have posted my output:
   select SEGMENT_NAME, bytes
   from USER_SEGMENTS
   Where SEGMENT_NAME in (select SEGMENT_NAME from USER_LOBS where TABLE_NAME 
like '_10' or TABLE_NAME like '_10C%')
   orSEGMENT_NAME like '_10'
   orSEGMENT_NAME like '_10C%'

   SEGMENT_NAMEBYTES
   -- --
   B10   1048576
   H10   2097152
   T10   2097152
   SYS_LOB039519C00010$$ 1048576
   SYS_LOB039519C00012$$ 1048576

You can verify the In Row of your CLOB data with:
   select TABLE_NAME, COLUMN_NAME, SEGMENT_NAME, IN_ROW
   from USER_LOBS
   where TABLE_NAME like '_10' or TABLE_NAME like '_10C%'

   TABLE_NAME  COLUMN_NAME  SEGMENT_NAME   IN_ROW
   ---  -- ---
   T10 C536870915   SYS_LOB039519C00012$$  YES
   T10 C536870913   SYS_LOB039519C00010$$  YES

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
Sent: Wednesday, November 18, 2009 11:02 AM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle in-row LOB storage issue - IM 7.03

Wow... I actually have something to disagree with Axton on ...

If you create a form (since v6x) Remedy no longer uses the BtttCccc 
structure to hold the long character fields.  I am on 7.1.0 patch 7 with Oracle 
10g and all of my CLOB columns are just columns in the normal table.

   SQL> describe T10;
Name Null?Type
  ---
C1   NOT NULL VARCHAR2(15)
C2VARCHAR2(254)
C3   NOT NULL NUMBER(15)
C4VARCHAR2(254)
C5   NOT NULL VARCHAR2(254)
C6   NOT NULL NUMBER(15)
C7   NOT NULL NUMBER(15)
C8   NOT NULL VARCHAR2(128)
C536870912VARCHAR2(255)
C536870913CLOB
C536870914NUMBER(15)
C536870915CLOB
C536870916NUMBER(15)
C536870921VARCHAR2(4000)
C536870924VARCHAR2(4000)
C536870925NUMBER(15)
C54710VARCHAR2(255)

And if I look at the create script thru TOAD I see:

   CREATE TABLE T10
   (
 C1  VARCHAR2(15 BYTE) NOT NULL,
 C2  VARCHAR2(254 BYTE),
 C3  NUMBER(15)NOT NULL,
 C4  VARCHAR2(254 BYTE),
 C5  VARCHAR2(254 BYTE)NOT NULL,
 C6  NUMBER(15)NOT NULL,
 C7  NUMBER(15)NOT NULL,
 C8  VARCHAR2(128 BYTE)NOT NULL,
 C536870912  VARCHAR2(255 BYTE),
 C536870913  CLOB,
 C536870914  NUMBER(15),
 C536870915  CLOB,
 C536870916  NUMBER(15),
 C536870921  VARCHAR2(4000 BYTE),
 C536870924  VARCHAR2(4000 BYTE),
 C536870925  NUMBER(15),
 C54710  VARCHAR2(255 BYTE)
   )
   TABLESPACE ARSYSTEM
   LOGGING
   NOCOMPRESS
   LOB (C536870913) STORE AS
 ( TABLESPACE  ARSYSTEM
   ENABLE  STORAGE IN ROW
   CHUNK   8192
   PCTVERSION  10
   NOCACHE
 )
 LOB (C536870915) STORE AS
 ( TABLESPACE  ARSYSTEM
   ENABLE  STORAGE IN ROW
   CHUNK   8192
   PCTVERSION  10
   NOCACHE
 )
   NOCACHE
   NOPARALLEL
   MONITORING;


The Oracle query for schemaid 10 for me is:
   select SEGMENT_NAME, bytes
   from USER_SEGMENTS
   Where SEGMENT_NAME in (select SEGMENT_NAME from USER_LOBS where TABLE_NAME 
like '_10')
   orSEGMENT_NAME like '_10'
   orSEGMENT_NAME like '_10C%'


NOTE:  I used USER_SEGMENTS and USER_LOBS in case your DBA has locked down your 
database (and the DBA_ versions of these objects are not available)

Fred


-Original Message-
From: Action Request System discussion list(ARSList) 
[ma

Re: Server Information form time out

[Lyle Taylor]

Never mind.  As you said, if you can see the process listed in the rcpinfo 
listing, then it's probably running.  I haven't dealt with portmapper on 
Solaris and don't have a Solaris box to look at, so I'm not sure I will be much 
more help on this.  Sorry.

This might be a good problem to take up with BMC support if that's an option 
for you.

Good luck,
Lyle

From: Lyle Taylor
Sent: Wednesday, November 18, 2009 10:43 AM
To: 'arslist@ARSLIST.ORG'
Subject: RE: Server Information form time out

Which version of AR Server are you running?

Lyle

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Wednesday, November 18, 2009 10:06 AM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

**
Yes the portmapper seems to be the problem, as I also cannot login with the 
clients with TCP port = blank.  As far as I can tell, portmapper is running.  
It's on a Solaris box, and I can see arserverd processes in the rpcinfo 
listing.  But I am really weak on rpcinfo and portmapper.

Do you have any advice on how to check that portmapper is running properly on a 
unix box?

Thanks!
Jason


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Tuesday, November 17, 2009 7:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

If I understand correctly, the underlying error is this: ONC/RPC portmap 
failure.  It sounds like it's trying to register itself with the portmapper but 
can't.  Do you have the portmapper service running?

Lyle

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Tuesday, November 17, 2009 4:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

**
Ah, I had looked in plugin log but not java plugin log.  I found this in the 
arjavaplugin.log.  My java is weak.  Does this scream anything obvious to 
anyone?  Not finding anything in kb...

2009-11-17 22:46:04,244 ERROR [main] com.bmc.arsys.pluginsvr.ARPluginServerMain
(?:?) - AR Plugin Server Startup Error ONC/RPC portmap failure
org.acplt.oncrpc.OncRpcException: ONC/RPC portmap failure
at org.acplt.oncrpc.OncRpcPortmapClient.setPort(Unknown Source)
at org.acplt.oncrpc.server.OncRpcTcpServerTransport.register(Unknown Sou
rce)
at com.bmc.arsys.pluginsvr.a.c.register(Unknown Source)
at org.acplt.oncrpc.server.OncRpcServerStub.register(Unknown Source)
at org.acplt.oncrpc.server.OncRpcServerStub.run(Unknown Source)
at com.bmc.arsys.pluginsvr.ARPluginServerMain.main(Unknown Source)
AR Plugin Server Startup ErrorONC/RPC portmap failure

Thanks!
Jason


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Tuesday, November 17, 2009 4:46 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

Hi Lyle,

Yes, one of my coworkers did try that a little while ago, to no avail...

Thanks!
Jason


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Tuesday, November 17, 2009 4:42 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

Just for giggles, can you try killing the plugin process, letting armonitor 
restart it and try again?  I've seen similar errors when the plugins aren't 
properly initialized (although I understand you don't see any errors in the 
logs).

Lyle

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Tuesday, November 17, 2009 2:06 PM
To: arslist@ARSLIST.ORG
Subject: Server Information form time out

**
Hi folks,

When I open the 'AR System Administration: Server Information' form it times 
out...

ARERR [94] Timeout during database query -- consider using more specific search 
criteria to narrow the results, and retry the operation : psremap1

There are no plugin server errors on system startup or in the plugin logs.  
Anybody else seen this one?

Thanks,
Jason
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_


NOTICE: This email message is for the sole use of the intended recipient(s) and 
may contain confidential and privileged information. Any unauthorized review, 
use, disclosure or distribution is prohibited. If you are not the intended 
recipient, please contact the sender by reply email and destroy all copies of 
the original message.

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ 
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ 
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ 
_Platinum Sp

Re: Server Information form time out

[LJ Longwing]

Jason,
Have you tried in your ar.conf file to see if your
'Register-With-Portmapper: T' is set to T?

  _  

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Wednesday, November 18, 2009 10:54 AM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out


** 

Never mind.  As you said, if you can see the process listed in the rcpinfo
listing, then it's probably running.  I haven't dealt with portmapper on
Solaris and don't have a Solaris box to look at, so I'm not sure I will be
much more help on this.  Sorry.

 

This might be a good problem to take up with BMC support if that's an option
for you.

 

Good luck,

Lyle

 

From: Lyle Taylor 
Sent: Wednesday, November 18, 2009 10:43 AM
To: 'arslist@ARSLIST.ORG'
Subject: RE: Server Information form time out

 

Which version of AR Server are you running?

 

Lyle

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Wednesday, November 18, 2009 10:06 AM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

 

** 

Yes the portmapper seems to be the problem, as I also cannot login with the
clients with TCP port = blank.  As far as I can tell, portmapper is running.
It's on a Solaris box, and I can see arserverd processes in the rpcinfo
listing.  But I am really weak on rpcinfo and portmapper.

 

Do you have any advice on how to check that portmapper is running properly
on a unix box?

 

Thanks!

Jason

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Tuesday, November 17, 2009 7:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

 

If I understand correctly, the underlying error is this: ONC/RPC portmap
failure.  It sounds like it's trying to register itself with the portmapper
but can't.  Do you have the portmapper service running?

 

Lyle

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Tuesday, November 17, 2009 4:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

 

** 

Ah, I had looked in plugin log but not java plugin log.  I found this in the
arjavaplugin.log.  My java is weak.  Does this scream anything obvious to
anyone?  Not finding anything in kb.

 

2009-11-17 22:46:04,244 ERROR [main]
com.bmc.arsys.pluginsvr.ARPluginServerMain

(?:?) - AR Plugin Server Startup Error ONC/RPC portmap failure

org.acplt.oncrpc.OncRpcException: ONC/RPC portmap failure

at org.acplt.oncrpc.OncRpcPortmapClient.setPort(Unknown Source)

at org.acplt.oncrpc.server.OncRpcTcpServerTransport.register(Unknown
Sou

rce)

at com.bmc.arsys.pluginsvr.a.c.register(Unknown Source)

at org.acplt.oncrpc.server.OncRpcServerStub.register(Unknown Source)

at org.acplt.oncrpc.server.OncRpcServerStub.run(Unknown Source)

at com.bmc.arsys.pluginsvr.ARPluginServerMain.main(Unknown Source)

AR Plugin Server Startup ErrorONC/RPC portmap failure

 

Thanks!

Jason

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Tuesday, November 17, 2009 4:46 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

 

Hi Lyle,

 

Yes, one of my coworkers did try that a little while ago, to no avail.

 

Thanks!

Jason

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Tuesday, November 17, 2009 4:42 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

 

Just for giggles, can you try killing the plugin process, letting armonitor
restart it and try again?  I've seen similar errors when the plugins aren't
properly initialized (although I understand you don't see any errors in the
logs).

 

Lyle

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Tuesday, November 17, 2009 2:06 PM
To: arslist@ARSLIST.ORG
Subject: Server Information form time out

 

** 

Hi folks,

 

When I open the 'AR System Administration: Server Information' form it times
out.

 

ARERR [94] Timeout during database query -- consider using more specific
search criteria to narrow the results, and retry the operation : psremap1

 

There are no plugin server errors on system startup or in the plugin logs.
Anybody else seen this one?

 

Thanks,

Jason

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ 



NOTICE: This email message is for the sole use of the intended recipient(s)
and may contain confidential and privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not the
intended recipient, please contact the sender by reply email and destroy all
copies of

Re: Server Information form time out

[Barnhill, Jason (Jason)]

No worries.  Thank you much for helping.  I've logged a ticket with my
SAs to restart rpcbind.  I have found an error on 390600 trying to bind
to rpc, even though I see other arserverd processes bound to rpc.  I
think that's the ultimate cause of my woes... 

 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Wednesday, November 18, 2009 12:54 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

 

Never mind.  As you said, if you can see the process listed in the
rcpinfo listing, then it's probably running.  I haven't dealt with
portmapper on Solaris and don't have a Solaris box to look at, so I'm
not sure I will be much more help on this.  Sorry.

 

This might be a good problem to take up with BMC support if that's an
option for you.

 

Good luck,

Lyle

 

From: Lyle Taylor 
Sent: Wednesday, November 18, 2009 10:43 AM
To: 'arslist@ARSLIST.ORG'
Subject: RE: Server Information form time out

 

Which version of AR Server are you running?

 

Lyle

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Wednesday, November 18, 2009 10:06 AM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

 

** 

Yes the portmapper seems to be the problem, as I also cannot login with
the clients with TCP port = blank.  As far as I can tell, portmapper is
running.  It's on a Solaris box, and I can see arserverd processes in
the rpcinfo listing.  But I am really weak on rpcinfo and portmapper.

 

Do you have any advice on how to check that portmapper is running
properly on a unix box?

 

Thanks!

Jason

 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Tuesday, November 17, 2009 7:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

 

If I understand correctly, the underlying error is this: ONC/RPC portmap
failure.  It sounds like it's trying to register itself with the
portmapper but can't.  Do you have the portmapper service running?

 

Lyle

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Tuesday, November 17, 2009 4:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

 

** 

Ah, I had looked in plugin log but not java plugin log.  I found this in
the arjavaplugin.log.  My java is weak.  Does this scream anything
obvious to anyone?  Not finding anything in kb...

 

2009-11-17 22:46:04,244 ERROR [main]
com.bmc.arsys.pluginsvr.ARPluginServerMain

(?:?) - AR Plugin Server Startup Error ONC/RPC portmap failure

org.acplt.oncrpc.OncRpcException: ONC/RPC portmap failure

at org.acplt.oncrpc.OncRpcPortmapClient.setPort(Unknown Source)

at
org.acplt.oncrpc.server.OncRpcTcpServerTransport.register(Unknown Sou

rce)

at com.bmc.arsys.pluginsvr.a.c.register(Unknown Source)

at org.acplt.oncrpc.server.OncRpcServerStub.register(Unknown
Source)

at org.acplt.oncrpc.server.OncRpcServerStub.run(Unknown Source)

at com.bmc.arsys.pluginsvr.ARPluginServerMain.main(Unknown
Source)

AR Plugin Server Startup ErrorONC/RPC portmap failure

 

Thanks!

Jason

 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Tuesday, November 17, 2009 4:46 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

 

Hi Lyle,

 

Yes, one of my coworkers did try that a little while ago, to no avail...

 

Thanks!

Jason

 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Tuesday, November 17, 2009 4:42 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

 

Just for giggles, can you try killing the plugin process, letting
armonitor restart it and try again?  I've seen similar errors when the
plugins aren't properly initialized (although I understand you don't see
any errors in the logs).

 

Lyle

 

 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: JVM output -- only sees 2GB - but machine has 4GB?

[Lyle Taylor]

If you're using a 32-bit JVM (which is required for Remedy), then it is limited 
to a 2GB memory space, as are all 32-bit processes.  You may have more memory 
on the machine, but 32-bit processes cannot access more than 2GB (unless 
they're specially compiled for that, which these aren't).

Lyle

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of John Sundberg
Sent: Wednesday, November 18, 2009 10:38 AM
To: arslist@ARSLIST.ORG
Subject: JVM output -- only sees 2GB - but machine has 4GB?

**


Below is the output of a hs_err_pid file -- the JVM is only seeing 2GB -- but 
the physical machine has 4GB.

Does anybody know why?


Also -- does anybody on a Windows 2003 Server see anything (relevant) different 
if they get a pid file?


Any other suggestions are welcome.


Thanks,


-John




---  S Y S T E M  ---

OS: Windows Server 2003 family Build 3790 Service Pack 2

CPU:total 1 (8 cores per cpu, 1 threads per core) family 6 model 10 stepping 5, 
cmov, cx8, fxsr, mmx, sse, sse2, sse3, ssse3

Memory: 4k page, physical 2097151k(1391860k free), swap 4194303k(3394944k free)

vm_info: Java HotSpot(TM) Server VM (11.3-b02) for windows-x86 JRE 
(1.6.0_13-b03), built on Mar  9 2009 01:10:11 by "java_re" with MS VC++ 7.1

time: Fri Nov 13 14:11:23 2009
elapsed time: 77507 seconds











--
John David Sundberg
235 East 6th Street, Suite 400B
St. Paul, MN 55101
(651) 556-0930-work
(651) 247-6766-cell
(651) 695-8577-fax
john.sundb...@kineticdata.com





_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_


 NOTICE: This email message is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information. Any unauthorized 
review, use, disclosure or distribution is prohibited. If you are not the 
intended recipient, please contact the sender by reply email and destroy all 
copies of the original message.



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: [HERD] Duplicate notifications on helpdesk modify

[Thomas Bean]

This won't fix the firing twice issue, but I just noticed that my earlier
recommendation was incomplete -- you still need to explicitly exclude
AR_ESCALATOR and "Remedy Application Service":
*
*
*'Assignee Login ID' != $USER$** AND **$USER$ != "AR_ESCALATOR" AND **$USER$
!= "Remedy Application Service"*

I would recommend running a Filter log in the client to determine what is
triggering the filter to run twice.

--Thomas

On Wed, Nov 18, 2009 at 11:00 AM, Robert Fults  wrote:

>  Thanks!  That is one issue down.  Still firing twice though.
>
>
>
>
>
> *From:* Thomas Bean [mailto:bea...@slu.edu]
> *Sent:* Wednesday, November 18, 2009 11:54 AM
> *To:* Robert Fults
> *Cc:* arslist@ARSLIST.ORG; herd-dispa...@lists.stanford.edu
> *Subject:* Re: [HERD] Duplicate notifications on helpdesk modify
>
>
>
> Hi Robert,
> I'm not sure why it is firing twice, but the 'OR' operators are the reason
> it is firing even when the assignee makes the update (using 'AND' would
> probably prevent this).
>
> I would recommend trying a much simpler 'Run If' statement:
>
> *'Assignee Login ID' != $USER$*
>
>
> If the 'Assignee Login ID' field is NULL, it shouldn't meet the
> qualification.
>
> Hope that helps,
>
> --Thomas
>
> On Wed, Nov 18, 2009 at 10:37 AM, Robert Fults  wrote:
>
> I set up a filter to fire a notification on Modify of the HPD:HelpDesk form
> by anyone other than the assignee:
>
> *( 'Assignee Login ID' !=  $NULL$ ) AND ( ( 'Last Modified By' !=
> 'Assignee Login ID') OR ( 'Last Modified By' !=  "AR_ESCALATOR" ) OR ( 'Last
> Modified By' !=  "Remedy Application Service" ) )*
>
> For some reason it fires twice, even when updated by the assignee.  Any
> ideas what I did wrong here?
>
> Sincerely,
>
>
>
> Robert Fults
>
> Remedy Dev.
>
> Florida International University
>
> Email: rfu...@fiu.edu
>
> http://uts.fiu.edu
>
>
>
>
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Server Information form time out

[Barnhill, Jason (Jason)]

Hey LJ,

Yes I have checked there, and confirmed it is set to 'T'...  I think
I've finally found something in the rpcinfo that indicates it's not
working.  If I get this resolved I'll post it here, as I've seen a few
other instances of folks having this problem...

 

Thanks!

Jason

 

And on a totally unrelated note, when did the list start limiting email
size??  Have to keep chopping these replies to get them through.  Makes
it harder to follow a thread...

 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of LJ Longwing
Sent: Wednesday, November 18, 2009 12:59 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

 

Jason,

Have you tried in your ar.conf file to see if your
'Register-With-Portmapper: T' is set to T?

 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Wednesday, November 18, 2009 10:54 AM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

** 

Never mind.  As you said, if you can see the process listed in the
rcpinfo listing, then it's probably running.  I haven't dealt with
portmapper on Solaris and don't have a Solaris box to look at, so I'm
not sure I will be much more help on this.  Sorry.

 

This might be a good problem to take up with BMC support if that's an
option for you.

 

Good luck,

Lyle

 

From: Lyle Taylor 
Sent: Wednesday, November 18, 2009 10:43 AM
To: 'arslist@ARSLIST.ORG'
Subject: RE: Server Information form time out

 

Which version of AR Server are you running?

 

Lyle

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Wednesday, November 18, 2009 10:06 AM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

 

** 

Yes the portmapper seems to be the problem, as I also cannot login with
the clients with TCP port = blank.  As far as I can tell, portmapper is
running.  It's on a Solaris box, and I can see arserverd processes in
the rpcinfo listing.  But I am really weak on rpcinfo and portmapper.

 

Do you have any advice on how to check that portmapper is running
properly on a unix box?

 

Thanks!

Jason

 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Tuesday, November 17, 2009 7:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

 

If I understand correctly, the underlying error is this: ONC/RPC portmap
failure.  It sounds like it's trying to register itself with the
portmapper but can't.  Do you have the portmapper service running?

 

Lyle

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Tuesday, November 17, 2009 4:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

 

** 

Ah, I had looked in plugin log but not java plugin log.  I found this in
the arjavaplugin.log.  My java is weak.  Does this scream anything
obvious to anyone?  Not finding anything in kb...

 

2009-11-17 22:46:04,244 ERROR [main]
com.bmc.arsys.pluginsvr.ARPluginServerMain

(?:?) - AR Plugin Server Startup Error ONC/RPC portmap failure

org.acplt.oncrpc.OncRpcException: ONC/RPC portmap failure

at org.acplt.oncrpc.OncRpcPortmapClient.setPort(Unknown Source)

at
org.acplt.oncrpc.server.OncRpcTcpServerTransport.register(Unknown Sou

rce)

at com.bmc.arsys.pluginsvr.a.c.register(Unknown Source)

at org.acplt.oncrpc.server.OncRpcServerStub.register(Unknown
Source)

at org.acplt.oncrpc.server.OncRpcServerStub.run(Unknown Source)

at com.bmc.arsys.pluginsvr.ARPluginServerMain.main(Unknown
Source)

AR Plugin Server Startup ErrorONC/RPC portmap failure

 

Thanks!

Jason

 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Oracle in-row LOB storage issue - IM 7.03

[Axton]

I need sleep ;)  The B#C# are used for attachments, I believe, at
least they were in past versions.  This is because Remedy used to use
a LONG RAW data type for the binary storage and there could be only 1
long raw per table.  The SYS_LOB039519C00010$$ cited by Frederick
is the LOB segment.  You can add the segment_type column to the
results to see what type it actually is.  The segment_type will tell
you one of these:

CACHE
CLUSTER
INDEX
LOBINDEX
LOBSEGMENT
ROLLBACK
TABLE
TABLE PARTITION
TYPE2 UNDO

Axton Grams

The opinions, statements, and/or suggested courses of action expressed
in this E-mail do not necessarily reflect those of BMC Software, Inc.
My voluntary participation in this forum is not intended to convey a
role as a spokesperson, liaison or public relations representative for
BMC Software, Inc.

On Wed, Nov 18, 2009 at 11:01 AM, Grooms, Frederick W
 wrote:
> Wow... I actually have something to disagree with Axton on ...
>
> If you create a form (since v6x) Remedy no longer uses the BtttCccc 
> structure to hold the long character fields.  I am on 7.1.0 patch 7 with 
> Oracle 10g and all of my CLOB columns are just columns in the normal table.
>
>   SQL> describe T10;
>    Name         Null?    Type
>      ---
>    C1           NOT NULL VARCHAR2(15)
>    C2                    VARCHAR2(254)
>    C3           NOT NULL NUMBER(15)
>    C4                    VARCHAR2(254)
>    C5           NOT NULL VARCHAR2(254)
>    C6           NOT NULL NUMBER(15)
>    C7           NOT NULL NUMBER(15)
>    C8           NOT NULL VARCHAR2(128)
>    C536870912            VARCHAR2(255)
>    C536870913            CLOB
>    C536870914            NUMBER(15)
>    C536870915            CLOB
>    C536870916            NUMBER(15)
>    C536870921            VARCHAR2(4000)
>    C536870924            VARCHAR2(4000)
>    C536870925            NUMBER(15)
>    C54710            VARCHAR2(255)
>
> And if I look at the create script thru TOAD I see:
>
>   CREATE TABLE T10
>   (
>     C1          VARCHAR2(15 BYTE)     NOT NULL,
>     C2          VARCHAR2(254 BYTE),
>     C3          NUMBER(15)            NOT NULL,
>     C4          VARCHAR2(254 BYTE),
>     C5          VARCHAR2(254 BYTE)    NOT NULL,
>     C6          NUMBER(15)            NOT NULL,
>     C7          NUMBER(15)            NOT NULL,
>     C8          VARCHAR2(128 BYTE)    NOT NULL,
>     C536870912  VARCHAR2(255 BYTE),
>     C536870913  CLOB,
>     C536870914  NUMBER(15),
>     C536870915  CLOB,
>     C536870916  NUMBER(15),
>     C536870921  VARCHAR2(4000 BYTE),
>     C536870924  VARCHAR2(4000 BYTE),
>     C536870925  NUMBER(15),
>     C54710  VARCHAR2(255 BYTE)
>   )
>   TABLESPACE ARSYSTEM
>   LOGGING
>   NOCOMPRESS
>   LOB (C536870913) STORE AS
>         ( TABLESPACE  ARSYSTEM
>           ENABLE      STORAGE IN ROW
>           CHUNK       8192
>           PCTVERSION  10
>           NOCACHE
>         )
>     LOB (C536870915) STORE AS
>         ( TABLESPACE  ARSYSTEM
>           ENABLE      STORAGE IN ROW
>           CHUNK       8192
>           PCTVERSION  10
>           NOCACHE
>         )
>   NOCACHE
>   NOPARALLEL
>   MONITORING;
>
>
> The Oracle query for schemaid 10 for me is:
>   select SEGMENT_NAME, bytes
>   from USER_SEGMENTS
>   Where SEGMENT_NAME in (select SEGMENT_NAME from USER_LOBS where TABLE_NAME 
> like '_10')
>   or    SEGMENT_NAME like '_10'
>   or    SEGMENT_NAME like '_10C%'
>
>
> NOTE:  I used USER_SEGMENTS and USER_LOBS in case your DBA has locked down 
> your database (and the DBA_ versions of these objects are not available)
>
> Fred
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Axton
> Sent: Wednesday, November 18, 2009 10:24 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: Oracle in-row LOB storage issue - IM 7.03
>
> You can look at the oracle data dictionary view dba_segments to see
> the size of the base tables, lob segments, indexes, etc:
>
> Here is an example for schemaid 746:
>
> SQL> ed
> Wrote file afiedt.buf
>
>  1  select bytes, segment_name, owner
>  2  from dba_segments
>  3  where (segment_name like '_746' or segment_name like '_746C%')
>  4* and segment_type = 'TABLE'
> SQL> /
>
>     BYTES SEGMENT_NAME   OWNER
> -- -- ---
>   3407872 B746           ARADMIN
> 2390491136 T746           ARADMIN
>  27525120 H746           ARADMIN
>  932446208 B746C701000357 ARADMIN
>
> B746C701000357 is the lob segment for field id 701000357.  The others
> are the base tables.  You can run the query without the where clause
> for segment_type to get the indexes, lob segment indexes, etc:
>
> select bytes, segment_name, owner
> from dba_segments
> where (segment_name like '_746%' or segment_name like '_746C%')
>
> Axton Grams
>
> The opinions, statements, and/or suggested courses of action expressed
> in this E-mail do not necessarily reflect those of BMC Software, Inc.
> My voluntary particip

Re: Firewall TCP Timeouts

[Axton]

This "can" be normal behavior for a firewall.  It all depends on how
you allow packets to create a state or if you use state at all.  You
can create a rule that is stateless so that all packets from host X to
host Y are allowed.  You should explore creating the rule to do a
quick pass of the packets and not use state for these connections.
Basically, the rules would look like this:

pass in quick on $if_1 inet proto tcp from $mt_host_1 to $ar_host_1
pass out quick on $if_2 inet proto tcp from $ar_host_1 to $mt_host_1

Instead of a state based or policy based ruleset.

You can also change the type of packet on the firewall so that syn/syn
ack packets are not the only type of packet that can insert a state
into the state table.  This is a little funky and is probably not the
best way to do this, but it can be done this way too.

Axton Grams

The opinions, statements, and/or suggested courses of action expressed
in this E-mail do not necessarily reflect those of BMC Software, Inc.
My voluntary participation in this forum is not intended to convey a
role as a spokesperson, liaison or public relations representative for
BMC Software, Inc.

On Wed, Nov 18, 2009 at 11:17 AM, Leihkauff, Kenneth
 wrote:
> Thanks for your time, Axton.  I spoke with our network engineer and he 
> studied the firewall logs and sees quit a few denials and some resets, but is 
> confident things should be set up correctly on the firewall.  He only sees 
> these denials/resets for the Midtier application, not some of our other apps.
>
> Here is what we're observing on the Linux Midtier server.  Below is an 
> example of 3 existing tcp connections that remain intact indefinitely or 
> until midtier is restarted.  The firewall knows about these 3 tcp 
> connections, but if the connections are idle for more than 60 minutes 
> (default firewall setting), the firewall will drop these idle tcp 
> connections.  Then, when a user gets on midtier (after the idle period), 
> midtier will attempt to use one or more of these tcp connections and the 
> firewall responds with a Deny (since it has aged off the inactive 
> connection).  This is normal behavior for a firewall as I understand things, 
> but the application (midtier in this case) should ideally make use of the tcp 
> keepalive or inactivetly timeout supported by Linux.  Apparently, midtier 
> does not take advantage of this.
>
> I suspect other customers are having this problem IF their topology utilizes 
> a firewall between Midtier and ARS and there are long periods of inactivity.  
> The reason, however, they may not be complaining is because once you get the 
> RCP failure (arerr 91), then subsequent connections seem to work fine.  For 
> the example below, once the arerr 91 timeout finally occurred, the associated 
> tcp connection was terminated on the midtier server and a new one was created.
>
> $netstat -antopp|grep 2031
> Proto Recv-Q Send-Q Local Address               Foreign Address             
> State       Timer
> tcp        0      0 :::172.16.0.129:54310   :::10.1.1.141:2031      
> ESTABLISHED 24977/java          off (0.00/0/0)
> tcp        0    864 :::172.16.0.129:54309   :::10.1.1.141:2031      
> ESTABLISHED 24977/java          on (3.59/12/0)
> tcp        0   1416 :::172.16.0.129:43717   :::10.1.1.141:2031      
> ESTABLISHED 24977/java          on (16.19/11/0)
>
> After a very long wait trying to login in, the user will receive this message:
> ARERR [91]
> RPC call failed : ONC/RPC call timed out
>
>
> Ken
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Axton
> Sent: Tuesday, November 17, 2009 3:24 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Firewall TCP Timeouts
>
> You need to configure your firewall properly.  With a firewall, you
> can define what types of packets can create a state entry on the
> firewall.  Typical is syn, syn ack.  Even if there is no state entry,
> a new packet should create a new state (not be dropped).  If a new
> packet does not create a new state, change the firewall rules so that
> it does.  A network dump will tell you what type of packet is going
> out; the firewall logs should tell you what type of packet was
> rejected.
>
> I could see that this would be a problem if the midtier servers were
> behind a NAT.  Is this the case?
>
> Axton Grams
>
> On Tue, Nov 17, 2009 at 12:07 PM, Leihkauff, Kenneth
>  wrote:
>> **
>>
>> Hello,
>>
>>
>>
>> We have a firewall between our MidTier server and ARS system.  The firewall
>> is configured to drop tcp connections after being idle for 60 minutes
>> (typical/default firewall setting).  Several MidTier user sessions will make
>> use of a shared tcp connection so you might have 100 sessions but
>> significantly fewer tcp connections.  During idle times (like at night), the
>> firewall will discard these idle tcp connections but the MidTier server will
>> still retain these tcp references (this 

Re: JVM output -- only sees 2GB - but machine has 4GB?

[John Sundberg]

As I read http://support.microsoft.com/kb/283037

It seems as if ALL programs together under windows can only take 2GB.

So - if I have 3 programs each take 1GB -- I would have a problem --  
even though I have 4GB.



Do others interpret the MS support document similarly?




-John



On Nov 18, 2009, at 12:05 PM, Lyle Taylor wrote:

**
If you’re using a 32-bit JVM (which is required for Remedy), then it  
is limited to a 2GB memory space, as are all 32-bit processes.  You  
may have more memory on the machine, but 32-bit processes cannot  
access more than 2GB (unless they’re specially compiled for that,  
which these aren’t).


Lyle

From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG 
] On Behalf Of John Sundberg

Sent: Wednesday, November 18, 2009 10:38 AM
To: arslist@ARSLIST.ORG
Subject: JVM output -- only sees 2GB - but machine has 4GB?

**


Below is the output of a hs_err_pid file -- the JVM is only seeing 2GB  
-- but the physical machine has 4GB.


Does anybody know why?


Also -- does anybody on a Windows 2003 Server see anything (relevant)  
different if they get a pid file?



Any other suggestions are welcome.


Thanks,


-John




---  S Y S T E M  ---

OS: Windows Server 2003 family Build 3790 Service Pack 2

CPU:total 1 (8 cores per cpu, 1 threads per core) family 6 model 10  
stepping 5, cmov, cx8, fxsr, mmx, sse, sse2, sse3, ssse3


Memory: 4k page, physical 2097151k(1391860k free), swap  
4194303k(3394944k free)


vm_info: Java HotSpot(TM) Server VM (11.3-b02) for windows-x86 JRE  
(1.6.0_13-b03), built on Mar  9 2009 01:10:11 by "java_re" with MS VC+ 
+ 7.1


time: Fri Nov 13 14:11:23 2009
elapsed time: 77507 seconds











--
John David Sundberg
235 East 6th Street, Suite 400B
St. Paul, MN 55101
(651) 556-0930-work
(651) 247-6766-cell
(651) 695-8577-fax
john.sundb...@kineticdata.com





_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the  
Answers Are"_



NOTICE: This email message is for the sole use of the intended  
recipient(s) and may contain confidential and privileged information.  
Any unauthorized review, use, disclosure or distribution is  
prohibited. If you are not the intended recipient, please contact the  
sender by reply email and destroy all copies of the original message.


_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the  
Answers Are"_


--
John David Sundberg
235 East 6th Street, Suite 400B
St. Paul, MN 55101
(651) 556-0930-work
(651) 247-6766-cell
(651) 695-8577-fax
john.sundb...@kineticdata.com






___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: JVM output -- only sees 2GB - but machine has 4GB?

[LJ Longwing]

Yes, and thus one of the limitations of 32Bitnow 'servers' can access a
total higher than that...even in 32 BitI think they can go as high as
4...

  _  

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of John Sundberg
Sent: Wednesday, November 18, 2009 11:34 AM
To: arslist@ARSLIST.ORG
Subject: Re: JVM output -- only sees 2GB - but machine has 4GB?


** 

As I read http://support.microsoft.com/kb/283037

It seems as if ALL programs together under windows can only take 2GB. 

So - if I have 3 programs each take 1GB -- I would have a problem -- even
though I have 4GB.


Do others interpret the MS support document similarly?




-John



On Nov 18, 2009, at 12:05 PM, Lyle Taylor wrote:

** 
If you're using a 32-bit JVM (which is required for Remedy), then it is
limited to a 2GB memory space, as are all 32-bit processes.  You may have
more memory on the machine, but 32-bit processes cannot access more than 2GB
(unless they're specially compiled for that, which these aren't).
Lyle
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of John Sundberg
Sent: Wednesday, November 18, 2009 10:38 AM
To: arslist@ARSLIST.ORG
Subject: JVM output -- only sees 2GB - but machine has 4GB?
**
Below is the output of a hs_err_pid file -- the JVM is only seeing 2GB --
but the physical machine has 4GB. 
Does anybody know why?
Also -- does anybody on a Windows 2003 Server see anything (relevant)
different if they get a pid file?
Any other suggestions are welcome.
Thanks,
-John
---  S Y S T E M  ---
OS: Windows Server 2003 family Build 3790 Service Pack 2
CPU:total 1 (8 cores per cpu, 1 threads per core) family 6 model 10 stepping
5, cmov, cx8, fxsr, mmx, sse, sse2, sse3, ssse3
Memory: 4k page, physical 2097151k(1391860k free), swap 4194303k(3394944k
free)
vm_info: Java HotSpot(TM) Server VM (11.3-b02) for windows-x86 JRE
(1.6.0_13-b03), built on Mar  9 2009 01:10:11 by "java_re" with MS VC++ 7.1
time: Fri Nov 13 14:11:23 2009
elapsed time: 77507 seconds
--
John David Sundberg
235 East 6th Street, Suite 400B
St. Paul, MN 55101
(651) 556-0930-work
(651) 247-6766-cell
(651) 695-8577-fax
john.sundb...@kineticdata.com
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_


NOTICE: This email message is for the sole use of the intended recipient(s)
and may contain confidential and privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not the
intended recipient, please contact the sender by reply email and destroy all
copies of the original message.


_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_

--
John David Sundberg
235 East 6th Street, Suite 400B
St. Paul, MN 55101
(651) 556-0930-work
(651) 247-6766-cell
(651) 695-8577-fax
john.sundb...@kineticdata.com





_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: JVM output -- only sees 2GB - but machine has 4GB?

[Axton]

http://msdn.microsoft.com/en-us/library/aa366912%28VS.85%29.aspx

Axton

On Wed, Nov 18, 2009 at 12:33 PM, John Sundberg
 wrote:
> **
> As I read http://support.microsoft.com/kb/283037
> It seems as if ALL programs together under windows can only take 2GB.
> So - if I have 3 programs each take 1GB -- I would have a problem -- even
> though I have 4GB.
>
> Do others interpret the MS support document similarly?
>
>
>
> -John
>
>
> On Nov 18, 2009, at 12:05 PM, Lyle Taylor wrote:
> **
> If you’re using a 32-bit JVM (which is required for Remedy), then it is
> limited to a 2GB memory space, as are all 32-bit processes.  You may have
> more memory on the machine, but 32-bit processes cannot access more than 2GB
> (unless they’re specially compiled for that, which these aren’t).
>
> Lyle
>
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] on Behalf Of John Sundberg
> Sent: Wednesday, November 18, 2009 10:38 AM
> To: arsl...@arslist.org
> Subject: JVM output -- only sees 2GB - but machine has 4GB?
>
> **
>
>
> Below is the output of a hs_err_pid file -- the JVM is only seeing 2GB --
> but the physical machine has 4GB.
>
> Does anybody know why?
>
>
> Also -- does anybody on a Windows 2003 Server see anything (relevant)
> different if they get a pid file?
>
>
> Any other suggestions are welcome.
>
>
> Thanks,
>
>
> -John
>
>
>
>
> ---  S Y S T E M  ---
>
> OS: Windows Server 2003 family Build 3790 Service Pack 2
>
> CPU:total 1 (8 cores per cpu, 1 threads per core) family 6 model 10 stepping
> 5, cmov, cx8, fxsr, mmx, sse, sse2, sse3, ssse3
>
> Memory: 4k page, physical 2097151k(1391860k free), swap 4194303k(3394944k
> free)
>
> vm_info: Java HotSpot(TM) Server VM (11.3-b02) for windows-x86 JRE
> (1.6.0_13-b03), built on Mar  9 2009 01:10:11 by "java_re" with MS VC++ 7.1
>
> time: Fri Nov 13 14:11:23 2009
> elapsed time: 77507 seconds
>
>
>
>
>
>
>
>
>
>
>
> --
> John David Sundberg
> 235 East 6th Street, Suite 400B
> St. Paul, MN 55101
> (651) 556-0930-work
> (651) 247-6766-cell
> (651) 695-8577-fax
> john.sundb...@kineticdata.com
>
>
>
>
>
> _Platinum Sponsor: rmisoluti...@verizon.net arslist: "Where the Answers
> Are"_
>
> NOTICE: This email message is for the sole use of the intended recipient(s)
> and may contain confidential and privileged information. Any unauthorized
> review, use, disclosure or distribution is prohibited. If you are not the
> intended recipient, please contact the sender by reply email and destroy all
> copies of the original message.
> _Platinum Sponsor: rmisoluti...@verizon.net arslist: "Where the Answers
> Are"_
> --
> John David Sundberg
> 235 East 6th Street, Suite 400B
> St. Paul, MN 55101
> (651) 556-0930-work
> (651) 247-6766-cell
> (651) 695-8577-fax
> john.sundb...@kineticdata.com
>
>
>
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: ITSP 4.0 on 7.5 arsystem?

[Easter, David]

Hi Dennis,

  To answer your first question, it's because it hasn't been tested by QA due 
to ITSP 4.0 being a legacy product.  To the best of my knowledge, no BMC 
testing has been done that would indicate that it won't work - but, as with all 
things, best to try it in your dev environment first and see if anything 
negative occurs.  And, of course, keep in mind that the combination would be 
unsupported, so if you run into problems, you may be asked to duplicate the 
issue on a supported combination.


-David J. Easter
Sr. Product Manager, Solution Strategy and Development
BMC Software, Inc.

The opinions, statements, and/or suggested courses of action expressed in this 
E-mail do not necessarily reflect those of BMC Software, Inc.  My voluntary 
participation in this forum is not intended to convey a role as a spokesperson, 
liaison or public relations representative for BMC Software, Inc.

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Dennis Ruble
Sent: Wednesday, November 18, 2009 8:44 AM
To: arslist@ARSLIST.ORG
Subject: ITSP 4.0 on 7.5 arsystem?

**
Hi All,
The compatibility matrix says that ITSP 4.0 isn't supported on arsystem 7.5.  
I'm not sure if there's some problem with it or if it just hasn't been QA'd.  
I've asked several people at BMC and haven't gotten a response, so I'll ask 
you.  Anyone out there running ITSP 4.0 on arsystem 7.5?  If so, have you found 
anything that doesn't work as expected?

Thanks in advance!

Dennis Ruble
Rockwell Collins _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where 
the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Double-Click to select incident template

[Robert Fults]

A question came up about this on the BMC Communities board today, I thought it 
was good idea so I implemented it.

Requirement:
Support Staff wants to be able to double-click incident template on the 
Incident Template Selection and have it populate the incident instead of having 
to press the select button.

Solution:
You need to deselect the Return/Table or Level Dbl-Clk option in HPD:HTU 
Details_100_OpenDiag. You then select that option to run on the field "z2TH 
Template Selection" in the 5 Active Links that start with HPD:HTU:Select.

Sincerely,

Robert Fults
Remedy Dev.
Florida International University
Email: rfu...@fiu.edu
http://uts.fiu.edu


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Double-Click to select incident template

[Chowdhury, Tauf]

I would just keep it OOB and have the user Highlight and Select instead
of Highlight and Double Click. 

Selling point? One less mouse click!

 

Tauf Chowdhury | Forest Laboratories, Inc.

Analyst, Service Management

Mobile:646.483.2779

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Robert Fults
Sent: Wednesday, November 18, 2009 1:59 PM
To: arslist@ARSLIST.ORG
Subject: Double-Click to select incident template

 

** 

A question came up about this on the BMC Communities board today, I
thought it was good idea so I implemented it.

 

Requirement:

Support Staff wants to be able to double-click incident template on the
Incident Template Selection and have it populate the incident instead of
having to press the select button.

 

Solution:

You need to deselect the Return/Table or Level Dbl-Clk option in HPD:HTU
Details_100_OpenDiag. You then select that option to run on the field
"z2TH Template Selection" in the 5 Active Links that start with
HPD:HTU:Select.

 

Sincerely,

 

Robert Fults

Remedy Dev.

Florida International University

Email: rfu...@fiu.edu

http://uts.fiu.edu

 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ 

**
This e-mail and its attachments may contain Forest Laboratories, Inc. 
proprietary information that is privileged, confidential or subject to 
copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely 
for the use of the individual or entity to which it is addressed. If you are 
not the intended recipient of this e-mail, or the employee or agent responsible 
for delivering this e-mail to the intended recipient, you are hereby notified 
that any dissemination, distribution, copying or action taken in relation to 
the contents of and attachments to this e-mail is strictly prohibited and may 
be unlawful. If you have received this e-mail in error, please notify the 
sender immediately and permanently delete the original and any copy of this 
e-mail and any printout.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Midtier / view ticket online solution problem.....

[Joe DeSouza]

You could as a workaround also have an AL that does the logout on closing the 
said window.. That should release the license..

Joe

 


From: Frank Caruso 
To: arslist@ARSLIST.ORG
Sent: Wed, November 18, 2009 6:04:15 AM
Subject: Re: Midtier / view ticket online solution problem.

Not sure what tasks you allow guest logins (Read Only). If it just
submit then you could switch the license to Read Restricted which will
eliminate the "User Logged Into Other Machine" issue but will not
allow updates to tickets.

Closing the browser window does not clear the users connection. You
should give them a Logout button which does an Application-Exit. Not
sure if doing an Application-Exit on window close will do the same
thing.

HTH
Frank


On Wed, Nov 18, 2009 at 1:46 PM, Sean Harrodine  wrote:
> **
> Hi all,
>
> Can anyone advise on the following please.
>
> We're running 6.3 and apache tomcat all on the same server (suse linux) with
> no issues.
>
> We send out an email to the user when a ticket is raised which contains a
> URL where they can click to check the status of the ticket.
>
> The format is below...
>
> http://servername/arsys/servlet/ViewFormServlet?form=form-name-here&view=view-name-here&server=servernamehere&username=vto-683240&eid=683240
>
> you will see
> username variable = vto-nn
> eid = "the users ticket number"
>
> We have guest user logins enabled so the script that constructs the email
> gives them a username of "vto" (for "view ticket online") and then appends
> their ticket number onto the end, with the theory being that it should only
> be that user that needs to view that ticket.
>
> So, all works well but if they close their browser afterwards, i notice in
> the Remedy admin tool that a Read license for username vto-683240 still
> remains after they have closed their browser and then, if they click the
> link in their email at a later time, they get the message "user is already
> logged on - do you want to override"
>
> Does anyone know why the userid "hangs around" after closing the browser ?
>
> Is it because its not a clean LOGOFF and if so, is there any way i can get
> this to happen ??
>
> TIA
>
> Sean




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Duplicate notifications on helpdesk modify

[Lamy, Thomas]

Hi Rob,

Do you have a development server?  If so, make sure the email on development is 
configured for development and not your production service.  Same with your 
ar.conf.  If these settings get copied over from production email do exactly 
that - send two emails.

Tom Lamy
UNH


From: herd-dispatch-boun...@mailman.stanford.edu 
[mailto:herd-dispatch-boun...@mailman.stanford.edu] On Behalf Of Robert Fults
Sent: Wednesday, November 18, 2009 11:38 AM
To: arslist@ARSLIST.ORG; herd-dispa...@lists.stanford.edu
Subject: [HERD] Duplicate notifications on helpdesk modify


I set up a filter to fire a notification on Modify of the HPD:HelpDesk form by 
anyone other than the assignee:

( 'Assignee Login ID' !=  $NULL$ ) AND ( ( 'Last Modified By' != 'Assignee 
Login ID') OR ( 'Last Modified By' !=  "AR_ESCALATOR" ) OR ( 'Last Modified By' 
!=  "Remedy Application Service" ) )

For some reason it fires twice, even when updated by the assignee.  Any ideas 
what I did wrong here?
Sincerely,

Robert Fults
Remedy Dev.
Florida International University
Email: rfu...@fiu.edu
http://uts.fiu.edu


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Duplicate notifications on helpdesk modify

[Barb Wagner]

Assuming the "OR" should be "AND" in your qualification? 

Barb Wagner
Remedy Architect
IBM Global Services
(612) 397-2955
Tie Line 608-1958
bar...@us.ibm.com




"Lamy, Thomas"  
Sent by: "Action Request System discussion list(ARSList)" 

11/18/2009 01:40 PM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Re: Duplicate notifications on helpdesk modify






** 
Hi Rob,
 
Do you have a development server?  If so, make sure the email on 
development is configured for development and not your production service. 
 Same with your ar.conf.  If these settings get copied over from 
production email do exactly that – send two emails. 
 
Tom Lamy
UNH
 
 
From: herd-dispatch-boun...@mailman.stanford.edu [
mailto:herd-dispatch-boun...@mailman.stanford.edu] On Behalf Of Robert 
Fults
Sent: Wednesday, November 18, 2009 11:38 AM
To: arslist@ARSLIST.ORG; herd-dispa...@lists.stanford.edu
Subject: [HERD] Duplicate notifications on helpdesk modify
 
I set up a filter to fire a notification on Modify of the HPD:HelpDesk 
form by anyone other than the assignee:
( 'Assignee Login ID' !=  $NULL$ ) AND ( ( 'Last Modified By' != 'Assignee 
Login ID') OR ( 'Last Modified By' !=  "AR_ESCALATOR" ) OR ( 'Last 
Modified By' !=  "Remedy Application Service" ) )
For some reason it fires twice, even when updated by the assignee.  Any 
ideas what I did wrong here?
Sincerely,
 
Robert Fults
Remedy Dev.
Florida International University
Email: rfu...@fiu.edu
http://uts.fiu.edu
 
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers 
Are"_ 

ARSmarts, free export utility for ITSM7.x

[support]

Dear List,

For those who need to export ITSM 7.x and other large AR System 
applications, we are pleased to let you know that the _ARSmarts Export 
utility is available for free_ with the evaluation version of ARSmarts.
Just register on our website (http://www.arsmarts.com/Register) to gain 
access to the download area.


The ARSmarts Export utility:
- exports definitions from AR System servers _without limitation of 
size_ (ITSM7.x, CMDB, SRM, )
- allows you to run exports at night or in the week-end against all your 
servers.

- is free with the evaluation version of ARSmarts.

Enjoy :-) :-) 

Kaïs
kais.albas...@arsmarts.com


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Duplicate notifications on helpdesk modify

[Robert Fults]

Unfortunately, no dev server. ..yet.

Sincerely,

Robert Fults
Remedy Dev.
Florida International University
Email: rfu...@fiu.edu
http://uts.fiu.edu

From: Lamy, Thomas [mailto:tom.l...@unh.edu]
Sent: Wednesday, November 18, 2009 2:40 PM
To: Robert Fults; arslist@ARSLIST.ORG; herd-dispa...@lists.stanford.edu
Subject: RE: Duplicate notifications on helpdesk modify

Hi Rob,

Do you have a development server?  If so, make sure the email on development is 
configured for development and not your production service.  Same with your 
ar.conf.  If these settings get copied over from production email do exactly 
that - send two emails.

Tom Lamy
UNH


From: herd-dispatch-boun...@mailman.stanford.edu 
[mailto:herd-dispatch-boun...@mailman.stanford.edu] On Behalf Of Robert Fults
Sent: Wednesday, November 18, 2009 11:38 AM
To: arslist@ARSLIST.ORG; herd-dispa...@lists.stanford.edu
Subject: [HERD] Duplicate notifications on helpdesk modify


I set up a filter to fire a notification on Modify of the HPD:HelpDesk form by 
anyone other than the assignee:

( 'Assignee Login ID' !=  $NULL$ ) AND ( ( 'Last Modified By' != 'Assignee 
Login ID') OR ( 'Last Modified By' !=  "AR_ESCALATOR" ) OR ( 'Last Modified By' 
!=  "Remedy Application Service" ) )

For some reason it fires twice, even when updated by the assignee.  Any ideas 
what I did wrong here?
Sincerely,

Robert Fults
Remedy Dev.
Florida International University
Email: rfu...@fiu.edu
http://uts.fiu.edu


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: URGENT HELP REQUIRED --- PROD ISSUE

[Rex Krebs]

Read the arfilter log. Shut off offending Filter...

--- On Tue, 11/17/09, Frank Caruso  wrote:

> From: Frank Caruso 
> Subject: Re: URGENT HELP REQUIRED --- PROD ISSUE
> To: arslist@ARSLIST.ORG
> Date: Tuesday, November 17, 2009, 9:18 PM
> What did you do prior to receiving
> the error?
> 
> On Wed, Nov 18, 2009 at 7:31 AM, Jaya Munjal 
> wrote:
> > **
> > Hi List
> >
> > We are not able to update or modify any workflow
> object on the our
> > Production Environment. As soon as we open any
> workflow object via the Admin
> > tool (Filters, Escalation, forms) etc it starts
> throwing an error  
> >
> > Cannot establish a network connection to the AR System
> server :
> > lonss00014.fm.rbsgrp.net : RPC: Miscellaneous tli
> error - System error
> > (Connection refused) (ARERR 90)
> >
> >
> > In the ARERROR log we get the following error
> messages
> >
> > *
> >
> > Wed Nov 18 03:22:46 2009  390600 : Incorrect format
> in the definition file
> > (bad action value -- \) (ARERR 402)
> > Wed Nov 18 03:22:47 2009  390600 : Missing data in
> the SQL database
> > (filter.numActions) (ARERR 556)
> > Wed Nov 18 03:22:47 2009  390600 : Error in
> definition for a filter (ARERR
> > 343)
> > Wed Nov 18 03:22:47 2009 AR System Email
> Association Delete Attachments
> >
> > Wed Nov 18 03:22:55 2009  Dispatch : Cannot establish
> a network connection
> > to the AR System server (lonss00014 : RPC:
> Miscellaneous tli error - An
> > event requires attentionError 0)  ARERR - 90
> >
> > *
> >
> >
> > We are able to login to the server via the admin tool
> but the filter AR
> > System Email Association Delete Attachments is not
> visible. On trying to
> > import in place the  we get the error.
> >
> > Cannot establish a network connection to the AR System
> server (lonss00014 :
> > RPC: Miscellaneous tli error - An event requires
> attentionError 0)  ARERR -
> > 90
> >
> >
> > Platform - ARS 6.3 Patch 24
> > OS - Solaris
> > DB - Sybase
> >
> >
> > Any suggestion would be appreciated… Let me know if
> you require any other
> > information.
> >
> > Thanks
> >
> > Jaya Munjal
> > Technology Services India
> > The Royal Bank of Scotland Group
> > O +91 124 479 1714
> > M +91 971 130 9277
> > F +91 124 479  0023
> > jaya.mun...@rbs.com
> > 7B Building, DLF Cyber City, DLF Phase III,
> > Gurgaon - 122002, Haryana, India
> >
> > Please don't print this e-mail unless you really need
> to.
> >
> >
> >
> >
> ***
> > The Royal Bank of Scotland plc. Registered in Scotland
> No 90312. Registered
> > Office: 36 St Andrew Square, Edinburgh EH2 2YB.
> > Authorised and regulated by the Financial Services
> Authority.
> >
> > This e-mail message is confidential and for use by
> the
> > addressee only. If the message is received by anyone
> other
> > than the addressee, please return the message to the
> sender
> > by replying to it and then delete the message from
> your
> > computer. Internet e-mails are not necessarily secure.
> The
> > Royal Bank of Scotland plc does not accept
> responsibility for
> > changes made to this message after it was sent.
> > Whilst all reasonable care has been taken to avoid
> the
> > transmission of viruses, it is the responsibility of
> the recipient to
> > ensure that the onward transmission, opening or use of
> this
> > message and any attachments will not adversely affect
> its
> > systems or data. No responsibility is accepted by The
> > Royal Bank of Scotland plc in this regard and the
> recipient should carry
> > out such virus and other checks as it considers
> appropriate.
> > Visit our website at www.rbs.com
> >
> ***
> >
> > _Platinum Sponsor: rmisoluti...@verizon.net
> ARSlist: "Where the Answers
> > Are"_
> 
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net
> ARSlist: "Where the Answers Are"
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: URGENT HELP REQUIRED --- PROD ISSUE

[Tommy Morris]

An offending filter? The nerve of some code!

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Rex Krebs
Sent: Wednesday, November 18, 2009 2:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: URGENT HELP REQUIRED --- PROD ISSUE

Read the arfilter log. Shut off offending Filter...

--- On Tue, 11/17/09, Frank Caruso  wrote:

> From: Frank Caruso 
> Subject: Re: URGENT HELP REQUIRED --- PROD ISSUE
> To: arslist@ARSLIST.ORG
> Date: Tuesday, November 17, 2009, 9:18 PM
> What did you do prior to receiving
> the error?
> 
> On Wed, Nov 18, 2009 at 7:31 AM, Jaya Munjal 
> wrote:
> > **
> > Hi List
> >
> > We are not able to update or modify any workflow
> object on the our
> > Production Environment. As soon as we open any
> workflow object via the Admin
> > tool (Filters, Escalation, forms) etc it starts
> throwing an error  
> >
> > Cannot establish a network connection to the AR System
> server :
> > lonss00014.fm.rbsgrp.net : RPC: Miscellaneous tli
> error - System error
> > (Connection refused) (ARERR 90)
> >
> >
> > In the ARERROR log we get the following error
> messages
> >
> > *
> >
> > Wed Nov 18 03:22:46 2009  390600 : Incorrect format
> in the definition file
> > (bad action value -- \) (ARERR 402)
> > Wed Nov 18 03:22:47 2009  390600 : Missing data in
> the SQL database
> > (filter.numActions) (ARERR 556)
> > Wed Nov 18 03:22:47 2009  390600 : Error in
> definition for a filter (ARERR
> > 343)
> > Wed Nov 18 03:22:47 2009 AR System Email
> Association Delete Attachments
> >
> > Wed Nov 18 03:22:55 2009  Dispatch : Cannot establish
> a network connection
> > to the AR System server (lonss00014 : RPC:
> Miscellaneous tli error - An
> > event requires attentionError 0)  ARERR - 90
> >
> > *
> >
> >
> > We are able to login to the server via the admin tool
> but the filter AR
> > System Email Association Delete Attachments is not
> visible. On trying to
> > import in place the  we get the error.
> >
> > Cannot establish a network connection to the AR System
> server (lonss00014 :
> > RPC: Miscellaneous tli error - An event requires
> attentionError 0)  ARERR -
> > 90
> >
> >
> > Platform - ARS 6.3 Patch 24
> > OS - Solaris
> > DB - Sybase
> >
> >
> > Any suggestion would be appreciated… Let me know if
> you require any other
> > information.
> >
> > Thanks
> >
> > Jaya Munjal
> > Technology Services India
> > The Royal Bank of Scotland Group
> > O +91 124 479 1714
> > M +91 971 130 9277
> > F +91 124 479  0023
> > jaya.mun...@rbs.com
> > 7B Building, DLF Cyber City, DLF Phase III,
> > Gurgaon - 122002, Haryana, India
> >
> > Please don't print this e-mail unless you really need
> to.
> >
> >
> >
> >
> ***
> > The Royal Bank of Scotland plc. Registered in Scotland
> No 90312. Registered
> > Office: 36 St Andrew Square, Edinburgh EH2 2YB.
> > Authorised and regulated by the Financial Services
> Authority.
> >
> > This e-mail message is confidential and for use by
> the
> > addressee only. If the message is received by anyone
> other
> > than the addressee, please return the message to the
> sender
> > by replying to it and then delete the message from
> your
> > computer. Internet e-mails are not necessarily secure.
> The
> > Royal Bank of Scotland plc does not accept
> responsibility for
> > changes made to this message after it was sent.
> > Whilst all reasonable care has been taken to avoid
> the
> > transmission of viruses, it is the responsibility of
> the recipient to
> > ensure that the onward transmission, opening or use of
> this
> > message and any attachments will not adversely affect
> its
> > systems or data. No responsibility is accepted by The
> > Royal Bank of Scotland plc in this regard and the
> recipient should carry
> > out such virus and other checks as it considers
> appropriate.
> > Visit our website at www.rbs.com
> >
> ***
> >
> > _Platinum Sponsor: rmisoluti...@verizon.net
> ARSlist: "Where the Answers
> > Are"_
> 
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net
> ARSlist: "Where the Answers Are"
> 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

AW: Firewall TCP Timeouts

[Conny Martin]

We had the same issue. We solved this by using libkeepalive 
(http://libkeepalive.sourceforge.net/) on the arserver machine. But it would 
work only if you are using Linux.

HTH 

Kind Regards Conny 

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Leihkauff, Kenneth
Gesendet: Mittwoch, 18. November 2009 18:18
An: arslist@ARSLIST.ORG
Betreff: Re: Firewall TCP Timeouts

Thanks for your time, Axton.  I spoke with our network engineer and he studied 
the firewall logs and sees quit a few denials and some resets, but is confident 
things should be set up correctly on the firewall.  He only sees these 
denials/resets for the Midtier application, not some of our other apps.  

Here is what we're observing on the Linux Midtier server.  Below is an example 
of 3 existing tcp connections that remain intact indefinitely or until midtier 
is restarted.  The firewall knows about these 3 tcp connections, but if the 
connections are idle for more than 60 minutes (default firewall setting), the 
firewall will drop these idle tcp connections.  Then, when a user gets on 
midtier (after the idle period), midtier will attempt to use one or more of 
these tcp connections and the firewall responds with a Deny (since it has aged 
off the inactive connection).  This is normal behavior for a firewall as I 
understand things, but the application (midtier in this case) should ideally 
make use of the tcp keepalive or inactivetly timeout supported by Linux.  
Apparently, midtier does not take advantage of this.

I suspect other customers are having this problem IF their topology utilizes a 
firewall between Midtier and ARS and there are long periods of inactivity.  The 
reason, however, they may not be complaining is because once you get the RCP 
failure (arerr 91), then subsequent connections seem to work fine.  For the 
example below, once the arerr 91 timeout finally occurred, the associated tcp 
connection was terminated on the midtier server and a new one was created.  

$netstat -antopp|grep 2031
Proto Recv-Q Send-Q Local Address   Foreign Address 
State   Timer
tcp0  0 :::172.16.0.129:54310   :::10.1.1.141:2031  
ESTABLISHED 24977/java  off (0.00/0/0)
tcp0864 :::172.16.0.129:54309   :::10.1.1.141:2031  
ESTABLISHED 24977/java  on (3.59/12/0)
tcp0   1416 :::172.16.0.129:43717   :::10.1.1.141:2031  
ESTABLISHED 24977/java  on (16.19/11/0)

After a very long wait trying to login in, the user will receive this message:
ARERR [91]
RPC call failed : ONC/RPC call timed out


Ken 


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Axton
Sent: Tuesday, November 17, 2009 3:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Firewall TCP Timeouts

You need to configure your firewall properly.  With a firewall, you can define 
what types of packets can create a state entry on the firewall.  Typical is 
syn, syn ack.  Even if there is no state entry, a new packet should create a 
new state (not be dropped).  If a new packet does not create a new state, 
change the firewall rules so that it does.  A network dump will tell you what 
type of packet is going out; the firewall logs should tell you what type of 
packet was rejected.

I could see that this would be a problem if the midtier servers were behind a 
NAT.  Is this the case?

Axton Grams

On Tue, Nov 17, 2009 at 12:07 PM, Leihkauff, Kenneth 
 wrote:
> **
>
> Hello,
>
>
>
> We have a firewall between our MidTier server and ARS system.  The 
> firewall is configured to drop tcp connections after being idle for 60 
> minutes (typical/default firewall setting).  Several MidTier user 
> sessions will make use of a shared tcp connection so you might have 
> 100 sessions but significantly fewer tcp connections.  During idle 
> times (like at night), the firewall will discard these idle tcp 
> connections but the MidTier server will still retain these tcp 
> references (this can be seen by using "netstat -anto").  So, when 
> users get back on the system, MidTier apparently is trying to utilize 
> one of these defunct tcp connections so you end up with problems like 
> ARERR 91 rpc timeouts because these tcp connections are broken pipes.
>
>
>
> Is there a MidTier/Tomcat or other setting that you have found 
> addresses this problem?
>
>
>
> Thanks.
>
>
>
> Ken
>
>
>
> Background:
>
> Version 7.5 patch 3
>
> MidTier - Linux, Tomcat JSP
>
> ARS - Linux, Oracle 10g
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the 
> Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum 
Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Issues with moving from SUN Solaris to HP-UX

[Pruitt, Christopher (Bank of America Account)]

Hello All,



Has anyone on the list every had to move Remedy from a SUN Solaris to an HP-UX 
environment? If so what were some of the biggest issues you had to deal with 
making that move? We are in the process of evaluating new servers for our 
environment. We currently are running on SUN 5.9 OS but are looking at moving 
either to a SUN Blade or HP server and are looking at the pros and cons of 
moving from SUN to HP.



Anyone ever have to experience this type of move? Can you give me some or your 
thoughts both good and/or bad.


Christopher Pruitt
Business Consulting III
HP Enterprises Services
christopher.pru...@hp.com
www.hp.com
[cid:image001.jpg@01CA685B.A65FCF90]

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


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
<>

AW: Oracle in-row LOB storage issue - IM 7.03

[Conny Martin]

William,

here's an excerpt out of the oracle docs



Choosing the Value of CHUNK
Once the value of CHUNK is chosen (when the LOB column is created), it cannot 
be changed. Hence, it is important that you choose a value which optimizes your 
storage and performance requirements.

Space Considerations
The value of CHUNK does not matter for LOBs that are stored inline. This 
happens when ENABLE STORAGE IN ROW is set, and the size of the LOB locator and 
the LOB data is less than 4000 bytes. However, when the LOB data is stored 
out-of-line, it will always take up space in multiples of the CHUNK parameter. 
This can lead to a large waste of space if your data is small, but the CHUNK is 
set to a large number. The following table illustrates this point:

Table 4-4 Data Size and CHUNK Size

Data Size   CHUNK Size  Disk Space Used 
to Store the LOBSpace Utilization (Percent) 
3500 enable storage in row  irrelevant  3500 in row 
100 
3500 disable storage in row 32 KB   32 KB   
10 
3500 disable storage in row 4 KB4 KB
90 
33 KB   32 KB   64 KB   
51 
2 GB +1032 KB   2 GB + 32 KB
99+  



HTH

Kind Regards Conny

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von William Rentfrow
Gesendet: Mittwoch, 18. November 2009 18:50
An: arslist@ARSLIST.ORG
Betreff: Re: Oracle in-row LOB storage issue - IM 7.03

Thanks for all the responses.

I'm trying to reconcile our db size usage (53% of 47 MB after some 
re-structuring) with BMC's in-row examples.

The in-row examples (from Oracle) in their docs mention a table with 43000+ 
with 32000+ of those having LOB entries and a size of ~261 MB.

Even if I give Remedy a 50% fudge factor and bump that number to 390 (heck, 
let's go 400) we are using nearly 100X the space.  And we only have 10X the 
records.  

All LOBS are now confirmed (again) as being in-row - waiting for BMC..and any 
bright ideas from the list.  DBA is working on your suggestions to determine 
where exactly all the space has gone.

William Rentfrow
Principal Consultant, StrataCom Inc.
wrentf...@stratacominc.com
O 715-592-5185
C 715-410-8056

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
Sent: Wednesday, November 18, 2009 11:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle in-row LOB storage issue - IM 7.03

I should have posted my output:
   select SEGMENT_NAME, bytes
   from USER_SEGMENTS
   Where SEGMENT_NAME in (select SEGMENT_NAME from USER_LOBS where TABLE_NAME 
like '_10' or TABLE_NAME like '_10C%')
   orSEGMENT_NAME like '_10'
   orSEGMENT_NAME like '_10C%'

   SEGMENT_NAMEBYTES
   -- --
   B10   1048576
   H10   2097152
   T10   2097152
   SYS_LOB039519C00010$$ 1048576
   SYS_LOB039519C00012$$ 1048576

You can verify the In Row of your CLOB data with:
   select TABLE_NAME, COLUMN_NAME, SEGMENT_NAME, IN_ROW
   from USER_LOBS
   where TABLE_NAME like '_10' or TABLE_NAME like '_10C%'

   TABLE_NAME  COLUMN_NAME  SEGMENT_NAME   IN_ROW
   ---  -- ---
   T10 C536870915   SYS_LOB039519C00012$$  YES
   T10 C536870913   SYS_LOB039519C00010$$  YES

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
Sent: Wednesday, November 18, 2009 11:02 AM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle in-row LOB storage issue - IM 7.03

Wow... I actually have something to disagree with Axton on ...

If you create a form (since v6x) Remedy no longer uses the BtttCccc 
structure to hold the long character fields.  I am on 7.1.0 patch 7 with Oracle 
10g and all of my CLOB columns are just columns in the normal table.

   SQL> describe T10;
Name Null?Type
  ---
C1   NOT NULL VARCHAR2(15)
C2VARCHAR2(254)
C3   NOT NULL NUMBER(15)
C4VARCHAR2(254)
C5   NOT NULL VARCHAR2(254)
C6   NOT NULL NUMBER(15)
C7   NOT NULL NUMBER(15)
C8   NOT NULL VARCHAR2(128)
C536870912VARCHAR2(255)
C536870913CLOB
C536870914NUMBER(15)
C536870915CLOB
C536870916NUMBER(15)
C536870921VARCHAR2(4000)
C536870924VAR

Remedy Consulting Company in Atlanta

[Jamahowal Pinitubel]

Hi there,


Does anyone know of a company that has Remedy consultants available with an 
office that is based in Atlanta, GA?

 

Thanks,

 

JP

 
  
_
Windows Live: Make it easier for your friends to see what you’re up to on 
Facebook.
http://go.microsoft.com/?linkid=9691816
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Remedy Consulting Company in Atlanta

[Kelly Gatewood]

Jamahowal,

IT Prophets is based in Atlanta.  What might we be able to assist you with 
today?

Thanks

Kelly Gatewood
Senior Solutions Architect
IT Prophets
Cell 615-830-5078
www.itprophets.com

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Jamahowal Pinitubel
Sent: Wednesday, November 18, 2009 3:01 PM
To: arslist@ARSLIST.ORG
Subject: Remedy Consulting Company in Atlanta

**
Hi there,

Does anyone know of a company that has Remedy consultants available with an 
office that is based in Atlanta, GA?

Thanks,

JP


Windows Live: Make it easier for your friends to see what you're up to on 
Facebook.
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Remedy Consulting Company in Atlanta

[Rick Cook]

IT Prophets is the best one I know. 

Rick

-Original Message-
From: Jamahowal Pinitubel 
Date: Wed, 18 Nov 2009 16:01:00 
To: 
Subject: Remedy Consulting Company in Atlanta


Hi there,


Does anyone know of a company that has Remedy consultants available with an 
office that is based in Atlanta, GA?

 

Thanks,

 

JP

 
  
_
Windows Live: Make it easier for your friends to see what you’re up to on 
Facebook.
http://go.microsoft.com/?linkid=9691816
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Remedy Consulting Company in Atlanta

[Howard Richter]

I will second that.

On Wed, Nov 18, 2009 at 4:11 PM, Rick Cook  wrote:

> **
> IT Prophets is the best one I know.
>
> Rick
> --
> *From: *Jamahowal Pinitubel 
> *Date: *Wed, 18 Nov 2009 16:01:00 -0500
>  *To: *
> *Subject: *Remedy Consulting Company in Atlanta
>
>  Hi there,
>
> Does anyone know of a company that has Remedy consultants available with an
> office that is based in Atlanta, GA?
>
> Thanks,
>
> JP
>
>
> --
> Windows Live: Make it easier for your friends to see what you’re up to on
> Facebook. 
>  _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
>



-- 
Howard Richter
Red Hat Certified Technician
CompTIA Linux+ Certified
ITIL Foundation Certified
E-Mail = hbr4...@gmail.com
LinkedIn Profile = http://www.linkedin.com/in/hbr4270

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Remedy Consulting Company in Atlanta

[Tommy Morris]

If they are such good Prophets then why don't they already know what he
needs? False advertising right there in the name shsh. J

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Howard Richter
Sent: Wednesday, November 18, 2009 3:35 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy Consulting Company in Atlanta

 

** I will second that.

On Wed, Nov 18, 2009 at 4:11 PM, Rick Cook  wrote:

** 

IT Prophets is the best one I know. 

Rick



From: Jamahowal Pinitubel  

Date: Wed, 18 Nov 2009 16:01:00 -0500

To: 

Subject: Remedy Consulting Company in Atlanta

 

Hi there,

Does anyone know of a company that has Remedy consultants available with
an office that is based in Atlanta, GA?
 
Thanks,
 
JP
 



Windows Live: Make it easier for your friends to see what you're up to
on Facebook.  

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ 




-- 
Howard Richter
Red Hat Certified Technician
CompTIA Linux+ Certified
ITIL Foundation Certified 
E-Mail = hbr4...@gmail.com
LinkedIn Profile = http://www.linkedin.com/in/hbr4270
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Remedy Consulting Company in Atlanta

[Howard Richter]

But they do, they are just waiting for you call.[?]

On Wed, Nov 18, 2009 at 4:38 PM, Tommy Morris
wrote:

> **
>
> If they are such good Prophets then why don’t they already know what he
> needs? False advertising right there in the name shsh. J
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arsl...@arslist.org] *On Behalf Of *Howard Richter
> *Sent:* Wednesday, November 18, 2009 3:35 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: Remedy Consulting Company in Atlanta
>
>
>
> ** I will second that.
>
> On Wed, Nov 18, 2009 at 4:11 PM, Rick Cook  wrote:
>
> **
>
> IT Prophets is the best one I know.
>
> Rick
>  --
>
> *From: *Jamahowal Pinitubel 
>
> *Date: *Wed, 18 Nov 2009 16:01:00 -0500
>
> *To: *
>
> *Subject: *Remedy Consulting Company in Atlanta
>
>
>
> Hi there,
>
> Does anyone know of a company that has Remedy consultants available with an
> office that is based in Atlanta, GA?
>
> Thanks,
>
> JP
>
>  --
>
> Windows Live: Make it easier for your friends to see what you’re up to on
> Facebook. 
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
>
>
>
>
> --
> Howard Richter
> Red Hat Certified Technician
> CompTIA Linux+ Certified
> ITIL Foundation Certified
> E-Mail = hbr4...@gmail.com
> LinkedIn Profile = http://www.linkedin.com/in/hbr4270
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
>  _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
>



-- 
Howard Richter
Red Hat Certified Technician
CompTIA Linux+ Certified
ITIL Foundation Certified
E-Mail = hbr4...@gmail.com
LinkedIn Profile = http://www.linkedin.com/in/hbr4270

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
<<1E3.gif>>

Re: Firewall TCP Timeouts

[Leihkauff, Kenneth]

Thanks, Conny. Are you saying the libkeepalive was implemented on the ARserver 
-- not the MidTier linux server? Our midtier and arserver are linux with a 
firewall in between.  

Unfortunately, the firewall is not an application level firewall so the 
firewall rule changes Axton proposed cannot be implemented according to our 
network engineer.

Ken 

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Conny Martin
Sent: Wednesday, November 18, 2009 3:30 PM
To: arslist@ARSLIST.ORG
Subject: AW: Firewall TCP Timeouts

We had the same issue. We solved this by using libkeepalive 
(http://libkeepalive.sourceforge.net/) on the arserver machine. But it would 
work only if you are using Linux.

HTH 

Kind Regards Conny 

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Leihkauff, Kenneth
Gesendet: Mittwoch, 18. November 2009 18:18
An: arslist@ARSLIST.ORG
Betreff: Re: Firewall TCP Timeouts

Thanks for your time, Axton.  I spoke with our network engineer and he studied 
the firewall logs and sees quit a few denials and some resets, but is confident 
things should be set up correctly on the firewall.  He only sees these 
denials/resets for the Midtier application, not some of our other apps.  

Here is what we're observing on the Linux Midtier server.  Below is an example 
of 3 existing tcp connections that remain intact indefinitely or until midtier 
is restarted.  The firewall knows about these 3 tcp connections, but if the 
connections are idle for more than 60 minutes (default firewall setting), the 
firewall will drop these idle tcp connections.  Then, when a user gets on 
midtier (after the idle period), midtier will attempt to use one or more of 
these tcp connections and the firewall responds with a Deny (since it has aged 
off the inactive connection).  This is normal behavior for a firewall as I 
understand things, but the application (midtier in this case) should ideally 
make use of the tcp keepalive or inactivetly timeout supported by Linux.  
Apparently, midtier does not take advantage of this.

I suspect other customers are having this problem IF their topology utilizes a 
firewall between Midtier and ARS and there are long periods of inactivity.  The 
reason, however, they may not be complaining is because once you get the RCP 
failure (arerr 91), then subsequent connections seem to work fine.  For the 
example below, once the arerr 91 timeout finally occurred, the associated tcp 
connection was terminated on the midtier server and a new one was created.  

$netstat -antopp|grep 2031
Proto Recv-Q Send-Q Local Address   Foreign Address 
State   Timer
tcp0  0 :::172.16.0.129:54310   :::10.1.1.141:2031  
ESTABLISHED 24977/java  off (0.00/0/0)
tcp0864 :::172.16.0.129:54309   :::10.1.1.141:2031  
ESTABLISHED 24977/java  on (3.59/12/0)
tcp0   1416 :::172.16.0.129:43717   :::10.1.1.141:2031  
ESTABLISHED 24977/java  on (16.19/11/0)

After a very long wait trying to login in, the user will receive this message:
ARERR [91]
RPC call failed : ONC/RPC call timed out


Ken 


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Axton
Sent: Tuesday, November 17, 2009 3:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Firewall TCP Timeouts

You need to configure your firewall properly.  With a firewall, you can define 
what types of packets can create a state entry on the firewall.  Typical is 
syn, syn ack.  Even if there is no state entry, a new packet should create a 
new state (not be dropped).  If a new packet does not create a new state, 
change the firewall rules so that it does.  A network dump will tell you what 
type of packet is going out; the firewall logs should tell you what type of 
packet was rejected.

I could see that this would be a problem if the midtier servers were behind a 
NAT.  Is this the case?

Axton Grams

On Tue, Nov 17, 2009 at 12:07 PM, Leihkauff, Kenneth 
 wrote:
> **
>
> Hello,
>
>
>
> We have a firewall between our MidTier server and ARS system.  The 
> firewall is configured to drop tcp connections after being idle for 60 
> minutes (typical/default firewall setting).  Several MidTier user 
> sessions will make use of a shared tcp connection so you might have 
> 100 sessions but significantly fewer tcp connections.  During idle 
> times (like at night), the firewall will discard these idle tcp 
> connections but the MidTier server will still retain these tcp 
> references (this can be seen by using "netstat -anto").  So, when 
> users get back on the system, MidTier apparently is trying to utilize 
> one of these defunct tcp connections so you end up with problems like 
> ARERR 91 rpc timeouts because these tcp connections are broken pipes.
>
>
>
> I

Re: Firewall TCP Timeouts

[Grooms, Frederick W]

Since you are using MidTier I would suggest you do the following...

Add a specified port for your AR Server to listen on (The AR Server runs just 
fine with portmapper and a specified port).
Set the MidTier to use the specified port.  

Also set the MidTier Session TimeOut value to be less than your firewall time 
out setting.  This way Mid-Tier will drop old connections before the firewall 
does. You should be able to set the MIdTier TimeOut from the configuration 
pages on your MidTier server.

Fred


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Leihkauff, Kenneth
Sent: Wednesday, November 18, 2009 3:51 PM
To: arslist@ARSLIST.ORG
Subject: Re: Firewall TCP Timeouts

Thanks, Conny. Are you saying the libkeepalive was implemented on the ARserver 
-- not the MidTier linux server? Our midtier and arserver are linux with a 
firewall in between.  

Unfortunately, the firewall is not an application level firewall so the 
firewall rule changes Axton proposed cannot be implemented according to our 
network engineer.

Ken 

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Conny Martin
Sent: Wednesday, November 18, 2009 3:30 PM
To: arslist@ARSLIST.ORG
Subject: AW: Firewall TCP Timeouts

We had the same issue. We solved this by using libkeepalive 
(http://libkeepalive.sourceforge.net/) on the arserver machine. But it would 
work only if you are using Linux.

HTH 

Kind Regards Conny 

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Leihkauff, Kenneth
Gesendet: Mittwoch, 18. November 2009 18:18
An: arslist@ARSLIST.ORG
Betreff: Re: Firewall TCP Timeouts

Thanks for your time, Axton.  I spoke with our network engineer and he studied 
the firewall logs and sees quit a few denials and some resets, but is confident 
things should be set up correctly on the firewall.  He only sees these 
denials/resets for the Midtier application, not some of our other apps.  

Here is what we're observing on the Linux Midtier server.  Below is an example 
of 3 existing tcp connections that remain intact indefinitely or until midtier 
is restarted.  The firewall knows about these 3 tcp connections, but if the 
connections are idle for more than 60 minutes (default firewall setting), the 
firewall will drop these idle tcp connections.  Then, when a user gets on 
midtier (after the idle period), midtier will attempt to use one or more of 
these tcp connections and the firewall responds with a Deny (since it has aged 
off the inactive connection).  This is normal behavior for a firewall as I 
understand things, but the application (midtier in this case) should ideally 
make use of the tcp keepalive or inactivetly timeout supported by Linux.  
Apparently, midtier does not take advantage of this.

I suspect other customers are having this problem IF their topology utilizes a 
firewall between Midtier and ARS and there are long periods of inactivity.  The 
reason, however, they may not be complaining is because once you get the RCP 
failure (arerr 91), then subsequent connections seem to work fine.  For the 
example below, once the arerr 91 timeout finally occurred, the associated tcp 
connection was terminated on the midtier server and a new one was created.  

$netstat -antopp|grep 2031
Proto Recv-Q Send-Q Local Address   Foreign Address 
State   Timer
tcp0  0 :::172.16.0.129:54310   :::10.1.1.141:2031  
ESTABLISHED 24977/java  off (0.00/0/0)
tcp0864 :::172.16.0.129:54309   :::10.1.1.141:2031  
ESTABLISHED 24977/java  on (3.59/12/0)
tcp0   1416 :::172.16.0.129:43717   :::10.1.1.141:2031  
ESTABLISHED 24977/java  on (16.19/11/0)

After a very long wait trying to login in, the user will receive this message:
ARERR [91]
RPC call failed : ONC/RPC call timed out


Ken 


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Axton
Sent: Tuesday, November 17, 2009 3:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Firewall TCP Timeouts

You need to configure your firewall properly.  With a firewall, you can define 
what types of packets can create a state entry on the firewall.  Typical is 
syn, syn ack.  Even if there is no state entry, a new packet should create a 
new state (not be dropped).  If a new packet does not create a new state, 
change the firewall rules so that it does.  A network dump will tell you what 
type of packet is going out; the firewall logs should tell you what type of 
packet was rejected.

I could see that this would be a problem if the midtier servers were behind a 
NAT.  Is this the case?

Axton Grams

On Tue, Nov 17, 2009 at 12:07 PM, Leihkauff, Kenneth 
 wrote:
> **
>
> Hello,
>
> We have a firewall between our

Re: Firewall TCP Timeouts

[Axton]

Midtier timeout has to do with the user session timeout.  Once
arserver is started there is a persistent socket connection to the
arserver.

Can I ask what type of firewall this is?

Axton

The opinions, statements, and/or suggested courses of action expressed
in this E-mail do not necessarily reflect those of BMC Software, Inc.
My voluntary participation in this forum is not intended to convey a
role as a spokesperson, liaison or public relations representative for
BMC Software, Inc.

On Wed, Nov 18, 2009 at 4:05 PM, Grooms, Frederick W
 wrote:
> Since you are using MidTier I would suggest you do the following...
>
> Add a specified port for your AR Server to listen on (The AR Server runs just 
> fine with portmapper and a specified port).
> Set the MidTier to use the specified port.
>
> Also set the MidTier Session TimeOut value to be less than your firewall time 
> out setting.  This way Mid-Tier will drop old connections before the firewall 
> does. You should be able to set the MIdTier TimeOut from the configuration 
> pages on your MidTier server.
>
> Fred
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Leihkauff, Kenneth
> Sent: Wednesday, November 18, 2009 3:51 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Firewall TCP Timeouts
>
> Thanks, Conny. Are you saying the libkeepalive was implemented on the 
> ARserver -- not the MidTier linux server? Our midtier and arserver are linux 
> with a firewall in between.
>
> Unfortunately, the firewall is not an application level firewall so the 
> firewall rule changes Axton proposed cannot be implemented according to our 
> network engineer.
>
> Ken
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Conny Martin
> Sent: Wednesday, November 18, 2009 3:30 PM
> To: arslist@ARSLIST.ORG
> Subject: AW: Firewall TCP Timeouts
>
> We had the same issue. We solved this by using libkeepalive 
> (http://libkeepalive.sourceforge.net/) on the arserver machine. But it would 
> work only if you are using Linux.
>
> HTH
>
> Kind Regards Conny
>
> -Ursprüngliche Nachricht-
> Von: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] Im Auftrag von Leihkauff, Kenneth
> Gesendet: Mittwoch, 18. November 2009 18:18
> An: arslist@ARSLIST.ORG
> Betreff: Re: Firewall TCP Timeouts
>
> Thanks for your time, Axton.  I spoke with our network engineer and he 
> studied the firewall logs and sees quit a few denials and some resets, but is 
> confident things should be set up correctly on the firewall.  He only sees 
> these denials/resets for the Midtier application, not some of our other apps.
>
> Here is what we're observing on the Linux Midtier server.  Below is an 
> example of 3 existing tcp connections that remain intact indefinitely or 
> until midtier is restarted.  The firewall knows about these 3 tcp 
> connections, but if the connections are idle for more than 60 minutes 
> (default firewall setting), the firewall will drop these idle tcp 
> connections.  Then, when a user gets on midtier (after the idle period), 
> midtier will attempt to use one or more of these tcp connections and the 
> firewall responds with a Deny (since it has aged off the inactive 
> connection).  This is normal behavior for a firewall as I understand things, 
> but the application (midtier in this case) should ideally make use of the tcp 
> keepalive or inactivetly timeout supported by Linux.  Apparently, midtier 
> does not take advantage of this.
>
> I suspect other customers are having this problem IF their topology utilizes 
> a firewall between Midtier and ARS and there are long periods of inactivity.  
> The reason, however, they may not be complaining is because once you get the 
> RCP failure (arerr 91), then subsequent connections seem to work fine.  For 
> the example below, once the arerr 91 timeout finally occurred, the associated 
> tcp connection was terminated on the midtier server and a new one was created.
>
> $netstat -antopp|grep 2031
> Proto Recv-Q Send-Q Local Address               Foreign Address             
> State       Timer
> tcp        0      0 :::172.16.0.129:54310   :::10.1.1.141:2031      
> ESTABLISHED 24977/java          off (0.00/0/0)
> tcp        0    864 :::172.16.0.129:54309   :::10.1.1.141:2031      
> ESTABLISHED 24977/java          on (3.59/12/0)
> tcp        0   1416 :::172.16.0.129:43717   :::10.1.1.141:2031      
> ESTABLISHED 24977/java          on (16.19/11/0)
>
> After a very long wait trying to login in, the user will receive this message:
> ARERR [91]
> RPC call failed : ONC/RPC call timed out
>
>
> Ken
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Axton
> Sent: Tuesday, November 17, 2009 3:24 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Firewall TCP Time

Kforce - Job Openings - Several - Nationwide

[Kitchen, Joshua]

Here is the high level oversight

 

1)   Remedy Developer with heavy infrastructure skills - Columbus,
OH (Straight Contract) (Below Market Rates)

2)   2 Remedy SME's with 7.x migration exp - New York (3 Month
Contract) (Market Rates)

3)   Remedy Process Manager/ITIL Expert - New Jersey (6 Month
Contract)  (Below Market Rates)

4)   Sr. Remedy Developer - San Jose, CA (6 Month Contract to Hire)
(Below Market Rates)

 

Ping me for more details!

 

Joshua Kitchen
Senior Recruiter
Kforce Federal 
937.449.1749 office
jkitc...@kforce.com   

http://www.govtrecruiter.com  

Great People = Great Results(r)

Confidentiality Notice: This email message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential and/or privileged information. Any unauthorized review,
use, disclosure or distribution is prohibited. If you are not the
intended recipient, please contact the sender by reply email and destroy
all copies of the original.

 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Remedy Consulting Company in Atlanta

[Jase Brandon]

We have also used IT Prophets in the past and those guys are hands down the
best group I have ever worked with.

Thanks,

Jase

On Wed, Nov 18, 2009 at 4:41 PM, Howard Richter  wrote:

> ** But they do, they are just waiting for you call.[?]
>
>
> On Wed, Nov 18, 2009 at 4:38 PM, Tommy Morris  > wrote:
>
>> **
>>
>> If they are such good Prophets then why don’t they already know what he
>> needs? False advertising right there in the name shsh. J
>>
>>
>>
>> *From:* Action Request System discussion list(ARSList) [mailto:
>> arsl...@arslist.org] *On Behalf Of *Howard Richter
>> *Sent:* Wednesday, November 18, 2009 3:35 PM
>> *To:* arslist@ARSLIST.ORG
>> *Subject:* Re: Remedy Consulting Company in Atlanta
>>
>>
>>
>> ** I will second that.
>>
>> On Wed, Nov 18, 2009 at 4:11 PM, Rick Cook  wrote:
>>
>> **
>>
>> IT Prophets is the best one I know.
>>
>> Rick
>>  --
>>
>> *From: *Jamahowal Pinitubel 
>>
>> *Date: *Wed, 18 Nov 2009 16:01:00 -0500
>>
>> *To: *
>>
>> *Subject: *Remedy Consulting Company in Atlanta
>>
>>
>>
>> Hi there,
>>
>> Does anyone know of a company that has Remedy consultants available with
>> an office that is based in Atlanta, GA?
>>
>> Thanks,
>>
>> JP
>>
>>  --
>>
>> Windows Live: Make it easier for your friends to see what you’re up to on
>> Facebook. 
>>
>> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
>> Are"_
>>
>>
>>
>>
>> --
>> Howard Richter
>> Red Hat Certified Technician
>> CompTIA Linux+ Certified
>> ITIL Foundation Certified
>> E-Mail = hbr4...@gmail.com
>> LinkedIn Profile = http://www.linkedin.com/in/hbr4270
>> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
>> Are"_
>>   _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
>> Are"_
>>
>
>
>
> --
> Howard Richter
> Red Hat Certified Technician
> CompTIA Linux+ Certified
> ITIL Foundation Certified
> E-Mail = hbr4...@gmail.com
> LinkedIn Profile = http://www.linkedin.com/in/hbr4270
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
<<1E3.gif>>

Discovery 1.6

[Kathy Morris]

In the Discovery (foundation) - I  thought once you run  your task to 
discover the asset - this shows up in BMC.Import.Topo?  Is  this correct?
 
 
 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Oracle in-row LOB storage issue - IM 7.03 - RESOLVED - kinda sorta...

[William Rentfrow]

After a day's worth of work we've figured out that the vast majority of space 
being used was coming from:

HPD:HelpDesk_AuditLogSystem 

This is the base product Audit logging built into IM 7.03 and as much as I love 
Remedy I am willing to call this feature very poor design for an application 
that is supposed to scale.  Actually, I think Log-style auditing is ridiculous 
for many reasons.

In this case the Audit Logging was using 25% of our total disk space.  Needless 
to say we are in the process of disabling it and truncating tables.


William Rentfrow
Principal Consultant, StrataCom Inc.
wrentf...@stratacominc.com
O 715-592-5185
C 715-410-8056

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Axton
Sent: Wednesday, November 18, 2009 12:19 PM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle in-row LOB storage issue - IM 7.03

I need sleep ;)  The B#C# are used for attachments, I believe, at least they 
were in past versions.  This is because Remedy used to use a LONG RAW data type 
for the binary storage and there could be only 1 long raw per table.  The 
SYS_LOB039519C00010$$ cited by Frederick is the LOB segment.  You can add 
the segment_type column to the results to see what type it actually is.  The 
segment_type will tell you one of these:

CACHE
CLUSTER
INDEX
LOBINDEX
LOBSEGMENT
ROLLBACK
TABLE
TABLE PARTITION
TYPE2 UNDO

Axton Grams

The opinions, statements, and/or suggested courses of action expressed in this 
E-mail do not necessarily reflect those of BMC Software, Inc.
My voluntary participation in this forum is not intended to convey a role as a 
spokesperson, liaison or public relations representative for BMC Software, Inc.

On Wed, Nov 18, 2009 at 11:01 AM, Grooms, Frederick W 
 wrote:
> Wow... I actually have something to disagree with Axton on ...
>
> If you create a form (since v6x) Remedy no longer uses the BtttCccc 
> structure to hold the long character fields.  I am on 7.1.0 patch 7 with 
> Oracle 10g and all of my CLOB columns are just columns in the normal table.
>
>   SQL> describe T10;
>    Name         Null?    Type
>      ---
>    C1           NOT NULL VARCHAR2(15)
>    C2                    VARCHAR2(254)
>    C3           NOT NULL NUMBER(15)
>    C4                    VARCHAR2(254)
>    C5           NOT NULL VARCHAR2(254)
>    C6           NOT NULL NUMBER(15)
>    C7           NOT NULL NUMBER(15)
>    C8           NOT NULL VARCHAR2(128)
>    C536870912            VARCHAR2(255)
>    C536870913            CLOB
>    C536870914            NUMBER(15)
>    C536870915            CLOB
>    C536870916            NUMBER(15)
>    C536870921            VARCHAR2(4000)
>    C536870924            VARCHAR2(4000)
>    C536870925            NUMBER(15)
>    C54710            VARCHAR2(255)
>
> And if I look at the create script thru TOAD I see:
>
>   CREATE TABLE T10
>   (
>     C1          VARCHAR2(15 BYTE)     NOT NULL,
>     C2          VARCHAR2(254 BYTE),
>     C3          NUMBER(15)            NOT NULL,
>     C4          VARCHAR2(254 BYTE),
>     C5          VARCHAR2(254 BYTE)    NOT NULL,
>     C6          NUMBER(15)            NOT NULL,
>     C7          NUMBER(15)            NOT NULL,
>     C8          VARCHAR2(128 BYTE)    NOT NULL,
>     C536870912  VARCHAR2(255 BYTE),
>     C536870913  CLOB,
>     C536870914  NUMBER(15),
>     C536870915  CLOB,
>     C536870916  NUMBER(15),
>     C536870921  VARCHAR2(4000 BYTE),
>     C536870924  VARCHAR2(4000 BYTE),
>     C536870925  NUMBER(15),
>     C54710  VARCHAR2(255 BYTE)
>   )
>   TABLESPACE ARSYSTEM
>   LOGGING
>   NOCOMPRESS
>   LOB (C536870913) STORE AS
>         ( TABLESPACE  ARSYSTEM
>           ENABLE      STORAGE IN ROW
>           CHUNK       8192
>           PCTVERSION  10
>           NOCACHE
>         )
>     LOB (C536870915) STORE AS
>         ( TABLESPACE  ARSYSTEM
>           ENABLE      STORAGE IN ROW
>           CHUNK       8192
>           PCTVERSION  10
>           NOCACHE
>         )
>   NOCACHE
>   NOPARALLEL
>   MONITORING;
>
>
> The Oracle query for schemaid 10 for me is:
>   select SEGMENT_NAME, bytes
>   from USER_SEGMENTS
>   Where SEGMENT_NAME in (select SEGMENT_NAME from USER_LOBS where 
> TABLE_NAME like '_10')
>   or    SEGMENT_NAME like '_10'
>   or    SEGMENT_NAME like '_10C%'
>
>
> NOTE:  I used USER_SEGMENTS and USER_LOBS in case your DBA has locked 
> down your database (and the DBA_ versions of these objects are not 
> available)
>
> Fred
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Axton
> Sent: Wednesday, November 18, 2009 10:24 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: Oracle in-row LOB storage issue - IM 7.03
>
> You can look at the oracle data dictionary view dba_segments to see 
> the size of the base tables, lob segments, indexes, etc:
>
> Here is an example for schemaid 746:
>
> SQL> ed
> Wrote fi

Enter character problem in 7.5

[LJ Longwing]

ARSystem 7.5 Patch 3 for Server and Dev Studio

Prior to 7.5 if I wanted to do a search for an enter in a character string I
would specify something like

STRSTR($field$, "") and open the ... Box, specify an enter between the ""
and save the workflow.  I have done this countless times in the past and it
works great.  Today I tried the same thing in the dev studio...but there is
no ... Anymore...not the same anyway...so I perform the same update but this
time it doesn't find the enter in my string so I compared it to the output
from the 7.1 Admin tool.  In the admin tool it shown one single black box
that I recognize as an enter character, if I look a the new filter that does
the same thing I see two black boxes instead of 1as noon as I replace
the two boxes with the same method used in the old admin tool which gives me
a single black box it works just fine...anyone else experienced this
scenario?

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Server Information form time out

[Barnhill, Jason (Jason)]

I found a bit more in a support doc about checking arserver on rpcinfo
with this command:

 

rpcinfo -t  390600 3

 

and it should return

 

program 390600 version 3 ready and waiting

 

on my server it is returning 

 

rpcinfo: RPC: Rpcbind failure - RPC: Timed out 
program 390600 version 3 is not available 



Remedy is running, I can log into it with TCP port set in the client.
And RPC is running.  But for whatever reason Remedy is not binding to
rpc/portmapper properly.  Has anyone else seen this particular error and
resolved it?

 

Thanks!

Jason

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Tuesday, November 17, 2009 4:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

 

** 

Ah, I had looked in plugin log but not java plugin log.  I found this in
the arjavaplugin.log.  My java is weak.  Does this scream anything
obvious to anyone?  Not finding anything in kb...

 

2009-11-17 22:46:04,244 ERROR [main]
com.bmc.arsys.pluginsvr.ARPluginServerMain

(?:?) - AR Plugin Server Startup Error ONC/RPC portmap failure

org.acplt.oncrpc.OncRpcException: ONC/RPC portmap failure

at org.acplt.oncrpc.OncRpcPortmapClient.setPort(Unknown Source)

at
org.acplt.oncrpc.server.OncRpcTcpServerTransport.register(Unknown Sou

rce)

at com.bmc.arsys.pluginsvr.a.c.register(Unknown Source)

at org.acplt.oncrpc.server.OncRpcServerStub.register(Unknown
Source)

at org.acplt.oncrpc.server.OncRpcServerStub.run(Unknown Source)

at com.bmc.arsys.pluginsvr.ARPluginServerMain.main(Unknown
Source)

AR Plugin Server Startup ErrorONC/RPC portmap failure

 

Thanks!

Jason

 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the
Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Remedy Consulting Company in Atlanta

[Barnhill, Jason (Jason)]

And because I live in Atlanta and want to be on their good side in case
I ever need a job... I'll add that I have spoken with a couple of guys
there over the years and they seem cool.  I have a peer who worked for
them a while back and he had good things to say about them as well...

 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Jase Brandon
Sent: Wednesday, November 18, 2009 5:18 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy Consulting Company in Atlanta

 

** We have also used IT Prophets in the past and those guys are hands
down the best group I have ever worked with.

Thanks,

Jase

On Wed, Nov 18, 2009 at 4:41 PM, Howard Richter 
wrote:

** But they do, they are just waiting for you call. 

 

On Wed, Nov 18, 2009 at 4:38 PM, Tommy Morris <
tommy.mor...@radioshack.com> wrote:

** 

If they are such good Prophets then why don't they already know what he
needs? False advertising right there in the name shsh. :-)

 

From: Action Request System discussion list(ARSList) [mailto:
arsl...@arslist.org] On Behalf Of Howard Richter
Sent: Wednesday, November 18, 2009 3:35 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy Consulting Company in Atlanta

 

** I will second that.

On Wed, Nov 18, 2009 at 4:11 PM, Rick Cook  wrote:

** 

IT Prophets is the best one I know. 

Rick



From: Jamahowal Pinitubel  

Date: Wed, 18 Nov 2009 16:01:00 -0500

To: 

Subject: Remedy Consulting Company in Atlanta

 

Hi there,

Does anyone know of a company that has Remedy consultants available with
an office that is based in Atlanta, GA?
 
Thanks,
 
JP
 



Windows Live: Make it easier for your friends to see what you're up to
on Facebook.  

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ 




-- 
Howard Richter
Red Hat Certified Technician
CompTIA Linux+ Certified
ITIL Foundation Certified 
E-Mail = hbr4...@gmail.com
LinkedIn Profile = http://www.linkedin.com/in/hbr4270
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ 




-- 
Howard Richter
Red Hat Certified Technician
CompTIA Linux+ Certified
ITIL Foundation Certified 
E-Mail = hbr4...@gmail.com
LinkedIn Profile = http://www.linkedin.com/in/hbr4270
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ 


_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
<>

Re: Discovery 1.6

[Pat Zandi]

It shows up on the query and the console default view on the fd  
application. But only after syncronization does it get to the cmdb...  
Then after reconcilation job runs it is in the cmdb..

Hope that helps

Sent from my iPhone

On Nov 18, 2009, at 5:19 PM, Kathy Morris   
wrote:



**
In the Discovery (foundation) - I  thought once you run your task to  
discover the asset - this shows up in BMC.Import.Topo? Is this  
correct?




_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the  
Answers Are"_


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Remedy Consulting Company in Atlanta

[Burns, Yvonne]

Hi JP, 

 

DISYS is a BMC Partner and has offices and consultants in Atlanta. 

With over 1,300 consultants on billing in North America, we offer many
other services in addition to Remedy. 

 

Feel free to reach out to me directly - so I can put you in touch with
the right person. 

Best regards, 

 

Yvonne Burns

Office (813) 207-1204

Mobile (813) 215-7895

yvonne.bu...@disys.com

 

 

 

www.disys.com

Certified Minority Enterprise (CME)

 

 

P Please consider the environment before printing this e-mail

 

 

 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Jamahowal Pinitubel
Sent: Wednesday, November 18, 2009 4:01 PM
To: arslist@ARSLIST.ORG
Subject: Remedy Consulting Company in Atlanta

 

Hi there,

Does anyone know of a company that has Remedy consultants available with
an office that is based in Atlanta, GA?
 
Thanks,
 
JP
 



Windows Live: Make it easier for your friends to see what you're up to
on Facebook.  

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
<>

Re: Kforce - Job Openings - Several - Nationwide

[Susan Palmer]

Hi Joshua,

Wouldn't it be more effective just to list the rates?  Maybe there's someone
that would relocate to a different market and accept a higher or lower if
they knew what it was.

Thanks,
Susan

On Wed, Nov 18, 2009 at 4:13 PM, Kitchen, Joshua wrote:

> **
>
> Here is the high level oversight
>
>
>
> 1)   Remedy Developer with heavy infrastructure skills – Columbus, OH
> (Straight Contract) (Below Market Rates)
>
> 2)   2 Remedy SME’s with 7.x migration exp – New York (3 Month
> Contract) (Market Rates)
>
> 3)   Remedy Process Manager/ITIL Expert – New Jersey (6 Month
> Contract)  (Below Market Rates)
>
> 4)   Sr. Remedy Developer – San Jose, CA (6 Month Contract to Hire)
> (Below Market Rates)
>
>
>
> Ping me for more details!
>
>
>
> *Joshua Kitchen
> Senior Recruiter
> Kforce Federal
> 937.449.1749 office
> jkitc...@kforce.com
>
> http://www.govtrecruiter.com*
>
> *Great People = Great Results®*
>
> *Confidentiality Notice: This email message, including any attachments, is
> for the sole use of the intended recipient(s) and may contain confidential
> and/or privileged information. Any unauthorized review, use, disclosure or
> distribution is prohibited. If you are not the intended recipient, please
> contact the sender by reply email and destroy all copies of the original.*
> **
>
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Report environments: thinking strategically

[Differ, Alfred W CTR NAVSEA, 210]

Hi all,

I'm working with a new employer that is making the transition from ITSM 6 to 7 
and they are learning the pains associated with some decisions they made that 
they thought were unrelated.  I'm referring to Crystal mostly since a few print 
features transitioned from ar reports to crystal ones.  My new friends here 
don't have a crystal server set up anywhere and are now contemplating their 
options.

I can look things up on the compatibility matrix and will when it comes time to 
tell them what they need to buy if they choose to buy at all.  What I can't 
look up so easily is where things are going in the future.  Some of you might 
know or have an educated guess that would help.  I'm not looking for the 
official BMC line here because I should be able to look that up on their 
website, right?  8)  I'm wondering if some of you might share what you've heard 
on where things might be going.

Specifically, I'm wondering if there are any changes in the weather forecast 
regarding how much the crystal report objects are integrated into ITSM.  
Ownership of applications can change and cause that butterfly wing flapping 
half way around the world that creates the typhoon for us.

Any thoughts?


-al

Alfred Differ
no.addr...@somemysteriousgovernmentcontractor.mil  8)

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"


smime.p7s
Description: S/MIME cryptographic signature

Re: Duplicate notifications on helpdesk modify

[Rod Harris]

Hi Robert,

ITSM has some rather complex workflow and quite often it will do two
updates on the ticket for one user update. You have to exclude the
second update. One thing you could try is to exclude the second update
caused by syncing the worklog by adding ('z1D Action' !=
"SYNC_WORKLOG" to your condition.

Rod



2009/11/19 Robert Fults :
> **
>
> I set up a filter to fire a notification on Modify of the HPD:HelpDesk form
> by anyone other than the assignee:
>
> ( 'Assignee Login ID' !=  $NULL$ ) AND ( ( 'Last Modified By' != 'Assignee
> Login ID') OR ( 'Last Modified By' !=  "AR_ESCALATOR" ) OR ( 'Last Modified
> By' !=  "Remedy Application Service" ) )
>
> For some reason it fires twice, even when updated by the assignee.  Any
> ideas what I did wrong here?
>
> Sincerely,
>
>
>
> Robert Fults
>
> Remedy Dev.
>
> Florida International University
>
> Email: rfu...@fiu.edu
>
> http://uts.fiu.edu
>
>
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Server Information form time out

[William Rentfrow]

I've had this problem.
 
1.) Stop the server
2.) Comment out the java plugin process in the armonitor.conf file -
this is largely unused by the Remedy application suite.  The only thing
I know for sure that uses it is the data collector module in SLM.
Comment it out anyway to give it a try.
3.) Make sure you have this line in your ar.conf file:
 
Server-Plugin-Alias: REMEDY.ARDBC.SERVER.ADMINISTRATION
REMEDY.ARDBC.SERVER.ADMI
NISTRATION your_server_name_here:port#
 
You can skip the colon and port # if you're using portmapper.  I've
always found it easier to NOT use portmapper on Solaris for a variety of
reasons related to security.
 
If that works then un-comment out the java plugin server and try it
again.
 
I've had identical installs (varying only by port #, server name, and db
server name) behave differently running on the same server at the same
time.  One would run the java plugin server and the other wouldn't.
This was with every possible combination of having one or both of them
online at the same time, one or the other down, order of starting them
up, etc.  Never did find the reason
 
 

William Rentfrow 
Principal Consultant, StrataCom Inc. 
wrentf...@stratacominc.com 
O 715-592-5185 
C 715-410-8056 

 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Wednesday, November 18, 2009 5:02 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out


** 

I found a bit more in a support doc about checking arserver on rpcinfo
with this command:

 

rpcinfo -t  390600 3

 

and it should return

 

program 390600 version 3 ready and waiting

 

on my server it is returning 

 

rpcinfo: RPC: Rpcbind failure - RPC: Timed out 
program 390600 version 3 is not available 



Remedy is running, I can log into it with TCP port set in the client.
And RPC is running.  But for whatever reason Remedy is not binding to
rpc/portmapper properly.  Has anyone else seen this particular error and
resolved it?

 

Thanks!

Jason

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason)
Sent: Tuesday, November 17, 2009 4:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Information form time out

 

** 

Ah, I had looked in plugin log but not java plugin log.  I found this in
the arjavaplugin.log.  My java is weak.  Does this scream anything
obvious to anyone?  Not finding anything in kb...

 

2009-11-17 22:46:04,244 ERROR [main]
com.bmc.arsys.pluginsvr.ARPluginServerMain

(?:?) - AR Plugin Server Startup Error ONC/RPC portmap failure

org.acplt.oncrpc.OncRpcException: ONC/RPC portmap failure

at org.acplt.oncrpc.OncRpcPortmapClient.setPort(Unknown Source)

at
org.acplt.oncrpc.server.OncRpcTcpServerTransport.register(Unknown Sou

rce)

at com.bmc.arsys.pluginsvr.a.c.register(Unknown Source)

at org.acplt.oncrpc.server.OncRpcServerStub.register(Unknown
Source)

at org.acplt.oncrpc.server.OncRpcServerStub.run(Unknown Source)

at com.bmc.arsys.pluginsvr.ARPluginServerMain.main(Unknown
Source)

AR Plugin Server Startup ErrorONC/RPC portmap failure

 

Thanks!

Jason

 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the
Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist:
"Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: ARSmarts, free export utility for ITSM7.x

[William Rentfrow]

Where were you about 4 days ago? :)
 
I registered and I'll be stress-testing your app.  I'll post results.
 

William Rentfrow 
Principal Consultant, StrataCom Inc. 
wrentf...@stratacominc.com 
O 715-592-5185 
C 715-410-8056 

 



From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of support
Sent: Wednesday, November 18, 2009 1:59 PM
To: arslist@ARSLIST.ORG
Subject: ARSmarts, free export utility for ITSM7.x


** Dear List,

For those who need to export ITSM 7.x and other large AR System applications, 
we are pleased to let you know that the ARSmarts Export utility is available 
for free with the evaluation version of ARSmarts.
Just register on our website (http://www.arsmarts.com/Register) to gain access 
to the download area.

The ARSmarts Export utility:
- exports definitions from AR System servers without limitation of size 
(ITSM7.x, CMDB, SRM, )
- allows you to run exports at night or in the week-end against all your 
servers.
- is free with the evaluation version of ARSmarts.

Enjoy :-) :-) 

Kaïs
kais.albas...@arsmarts.com

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Asset Management Software License

[Frank Caruso]

ITMS 7.03

Still trying to figure out the Software License management module ...

What I have so far is that I've created a Software Contract record for
company A. This contract covers several software products, 10. So I
added each as a Licensable Product. I then added under License Details
the keys that are associated with each product with the total number
of licenses, roughly 50. As I add each key the total license count is
accumulating on the contract record. However, there is no way to
associate the key to a product.

The next thing I was hoping to do was start relating CI's (Computer
Systems) to the software contract. I figured this would make the most
sense as the keys are tied to those CIs. However, this does not appear
to be the way the tool works. I have to relate a System Software CI to
the Software Contract. This will then decrement the total number of
licenses for the contract, not at the key level. I then thought if I
relate Computer Systems to the System Software CI that it would also
decrement the license count on the contract record. No such luck. The
only way to decrement the license count is to relate CIs that match at
all 5 levels: Tier 1,2,3, Product Name and Mfct. And still this is
being done at the contract level not at the key level so I would have
to manually go to each key and update the counts, which amazingly
enough updates the counts at the contract level.

Can anybody speak to these issues and let me know whether I understand
correctly how the module works?

Thank you.

Frank Caruso
Iraq

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

AW: Firewall TCP Timeouts

[Conny Martin]

on the arserver! 

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Leihkauff, Kenneth
Gesendet: Mittwoch, 18. November 2009 22:51
An: arslist@ARSLIST.ORG
Betreff: Re: Firewall TCP Timeouts

Thanks, Conny. Are you saying the libkeepalive was implemented on the ARserver 
-- not the MidTier linux server? Our midtier and arserver are linux with a 
firewall in between.  

Unfortunately, the firewall is not an application level firewall so the 
firewall rule changes Axton proposed cannot be implemented according to our 
network engineer.

Ken 

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Conny Martin
Sent: Wednesday, November 18, 2009 3:30 PM
To: arslist@ARSLIST.ORG
Subject: AW: Firewall TCP Timeouts

We had the same issue. We solved this by using libkeepalive 
(http://libkeepalive.sourceforge.net/) on the arserver machine. But it would 
work only if you are using Linux.

HTH 

Kind Regards Conny 

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Leihkauff, Kenneth
Gesendet: Mittwoch, 18. November 2009 18:18
An: arslist@ARSLIST.ORG
Betreff: Re: Firewall TCP Timeouts

Thanks for your time, Axton.  I spoke with our network engineer and he studied 
the firewall logs and sees quit a few denials and some resets, but is confident 
things should be set up correctly on the firewall.  He only sees these 
denials/resets for the Midtier application, not some of our other apps.  

Here is what we're observing on the Linux Midtier server.  Below is an example 
of 3 existing tcp connections that remain intact indefinitely or until midtier 
is restarted.  The firewall knows about these 3 tcp connections, but if the 
connections are idle for more than 60 minutes (default firewall setting), the 
firewall will drop these idle tcp connections.  Then, when a user gets on 
midtier (after the idle period), midtier will attempt to use one or more of 
these tcp connections and the firewall responds with a Deny (since it has aged 
off the inactive connection).  This is normal behavior for a firewall as I 
understand things, but the application (midtier in this case) should ideally 
make use of the tcp keepalive or inactivetly timeout supported by Linux.  
Apparently, midtier does not take advantage of this.

I suspect other customers are having this problem IF their topology utilizes a 
firewall between Midtier and ARS and there are long periods of inactivity.  The 
reason, however, they may not be complaining is because once you get the RCP 
failure (arerr 91), then subsequent connections seem to work fine.  For the 
example below, once the arerr 91 timeout finally occurred, the associated tcp 
connection was terminated on the midtier server and a new one was created.  

$netstat -antopp|grep 2031
Proto Recv-Q Send-Q Local Address   Foreign Address 
State   Timer
tcp0  0 :::172.16.0.129:54310   :::10.1.1.141:2031  
ESTABLISHED 24977/java  off (0.00/0/0)
tcp0864 :::172.16.0.129:54309   :::10.1.1.141:2031  
ESTABLISHED 24977/java  on (3.59/12/0)
tcp0   1416 :::172.16.0.129:43717   :::10.1.1.141:2031  
ESTABLISHED 24977/java  on (16.19/11/0)

After a very long wait trying to login in, the user will receive this message:
ARERR [91]
RPC call failed : ONC/RPC call timed out


Ken 


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Axton
Sent: Tuesday, November 17, 2009 3:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Firewall TCP Timeouts

You need to configure your firewall properly.  With a firewall, you can define 
what types of packets can create a state entry on the firewall.  Typical is 
syn, syn ack.  Even if there is no state entry, a new packet should create a 
new state (not be dropped).  If a new packet does not create a new state, 
change the firewall rules so that it does.  A network dump will tell you what 
type of packet is going out; the firewall logs should tell you what type of 
packet was rejected.

I could see that this would be a problem if the midtier servers were behind a 
NAT.  Is this the case?

Axton Grams

On Tue, Nov 17, 2009 at 12:07 PM, Leihkauff, Kenneth 
 wrote:
> **
>
> Hello,
>
>
>
> We have a firewall between our MidTier server and ARS system.  The 
> firewall is configured to drop tcp connections after being idle for 60 
> minutes (typical/default firewall setting).  Several MidTier user 
> sessions will make use of a shared tcp connection so you might have 
> 100 sessions but significantly fewer tcp connections.  During idle 
> times (like at night), the firewall will discard these idle tcp 
> connections but the MidTier server will still retain these tcp 
> references (this can 

Re: Java API for ARS - How to obtain a Run-If line from an Active Link (for example)

[Misi Mladoniczky]

Hi Fred,

Why would this have anything to do with flat files???

The only reason for this that I can think of, is that the developers did
not get enough time to do it right.

I can not imagine a programmer that would not LOVE the challenge of
optimizing a thing like this, and get payed to do it ;-)

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

Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
* RRR|Translator - Manage and automate your language translations.
Find these products, and many free tools and utilities, at http://rrr.se.

> According to the Workflow Objects docs there is a operator precedence.
>
> Operator precedence
>
> When you use multiple operators to construct qualification criteria, they
> are evaluated in the following order:
>   1 ( )
>   2 NOT (!) - (unary minus)
>   3 * / %
>   4 + -
>   5 < <= > >= = != LIKE
>   6 AND (&&)
>   7 OR (||)
> Operators of the same precedence are performed left to right.
> You can use parentheses in an expression to override operator precedence.
> AR System evaluates expressions inside parentheses first before evaluating
> those outside.
>
> Part of the design of adding parenthesis probably goes back to when Remedy
> supported using flat files as a database.
>
> Fred
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
> Sent: Monday, November 02, 2009 2:12 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Java API for ARS - How to obtain a Run-If line from an Active
> Link (for example)
>
> It's possible that that's the motivation behind how it's currently
> architected, but it's not a very good excuse.  The SQL will all get
> dynamically generated based on the qualification tree generated by parsing
> the qualification string, not on the qualification string itself.  It's
> very doable to define qualification strings so that operator precedence,
> etc., is in line with common practice, and that wouldn't affect Remedy's
> ability to be DB agnostic in the slightest.  The only difference that it
> makes is that parsing the qualification strings becomes slightly more
> complicated (but still very doable - there are tools that will write much
> of this code for you - e.g., lex/yacc, etc.).  Once you've parsed the
> qualification string according to whatever rules you've put in place, you
> end up with the same data structure that they currently have which will
> then be used to generate the SQL just like they do now.  The current
> scheme is unnecessarily simplistic and actually makes the system more
> difficult to use because of the excessive number of parentheses in
> qualification schemese.
>
> Lyle
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Rick Cook
> Sent: Monday, November 02, 2009 12:46 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Java API for ARS - How to obtain a Run-If line from an Active
> Link (for example)
>
> Lyle, my take on that is that Remedy is trying to be DB agnostic.  Rather
> than compete with how each DB processes SQL, or trying to anticipate how a
> receiver of an API call might do so, they just kept it simple.
>
>
> Rick
>
> -Original Message-
> From: Lyle Taylor 
> Date: Mon, 2 Nov 2009 12:29:40
> To: 
> Subject: Re: Java API for ARS - How to obtain a Run-If line from an Active
> Link (for example)
>
>>From what I've been able to tell, there is no such thing as operator
>> precedence in AR System aside from parentheses.  It all seems to be
>> dictated on the parentheses which seems to correspond to the tree that
>> their parser build internally.  There's a lot of room for improvement in
>> the area of qualifications in Remedy, in my opinion.
>
> Lyle
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky
> Sent: Thursday, October 29, 2009 2:13 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: Java API for ARS - How to obtain a Run-If line from an Active
> Link (for example)
>
> Hi,
>
> Just tested some things.
>
> I am working on ARServer/Developer 7.5.0 patch 3.
>
> In the Run-If and Set/Push-Fields-If-Qualification, it still puts in extra
> brackets:
>
> What I entered:
> 'CU:ID' = $CU:ID$ AND 'CO:ID' = $CO:ID$ AND 'Status' = "Active"
> After reopen:
> (('CU:ID' = $CU:ID$) AND ('CO:ID' = $CO:ID$)) AND ('Status' = "Active")
>
> It seems like they did some efforts on the the VALUE in the
> Set/Push-Fields Action.
>
> The problem is that i does not work, the new BMC parenthesis optimizer is
> faulty!!!
>
> I entered:
> (1.0 + 2.0) * 3.0
> This is shown after reopening the filter:
> 1.0 + 2.0 * 3.0
>
> They must take into account that the * has a higher priority than the +,
> and put in parenthesis accordingly, if needed.
>
>