Loadbalancer issue in Mid-Tier 7.6.04 SP2

[Nithin Vinod Kumar]

Hi All,

We are facing a issue with the loadbalancer Mid-Tier 7.6.04 SP2.

While using the midtier with load balancer we are getting the below error
message altough it goes to the homepage.

*"Session is invalid or has timed out. Please reload page to log in again.
(ARERR 9201) "*
**
But when we individually access each midtier, it is working fine.

Please suggest.

Thanks & Regards,
Nithin

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

Loadbalancer issue in Mid-Tier 7.6.04 SP2

[John Baker]

Hello

Do you have the sticky flag set on the LB? Mid Tier does not support session 
replication (although I wish it would).


John

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

Re: Loadbalancer issue in Mid-Tier 7.6.04 SP2

[Chowdhury, Tauf]

Nithin,

What are you using to load balance your mid tiers? You should make sure
that the session timeout on your load balancer is greater than the
session time out that you have set on your mid tiers. 

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Nithin Vinod Kumar
Sent: Monday, November 21, 2011 6:41 AM
To: arslist@ARSLIST.ORG
Subject: Loadbalancer issue in Mid-Tier 7.6.04 SP2

 

** 

Hi All,

 

We are facing a issue with the loadbalancer Mid-Tier 7.6.04 SP2.

 

While using the midtier with load balancer we are getting the below
error message altough it goes to the homepage.

 

"Session is invalid or has timed out. Please reload page to log in
again. (ARERR 9201) "

 

But when we individually access each midtier, it is working fine.

 

Please suggest.

 

Thanks & Regards,

Nithin

 

 

_attend WWRUG12 www.wwrug.com 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
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: Loadbalancer issue in Mid-Tier 7.6.04 SP2

[patchsk]

I think that feature is now available from ars7.6.04 and above.
So no sticky bit is needed for midtier load balancing.
Here is the text from BMC white paper on load balancer.
For versions 7.6.04 or later, BMC recommends configuring the load balancer 
that 
is located between the web servers and AR System servers without setting a 
“sticky” bit. In versions earlier than 7.6.04, BMC recommended setting the 
sticky 
bit to activate session affinity to route all connections from one web 
server to the 
same AR System server
http://documents.bmc.com/supportu/documents/61/98/186198/186198.pdf

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

Re: Loadbalancer issue in Mid-Tier 7.6.04 SP2

[Chowdhury, Tauf]

Yes, that is between the Mid Tier and App server but I believe that the issue 
Nithin is facing is more on the User to Mid Tier side of things. Usually when 
there are timeout or misconfigurations between the mid tier and load balancer, 
the errors are more along the lines of: “Data Connection Error” or “RPC 
Timeout”. 

Also, Nithin mentioned that when he goes directly to the mid tiers, they are 
fine. 

Actually, it would be nice to know if their environment is load balanced both 
at the user side and the AR side. 

 

You are correct though in that the sticky bit between Mid Tier and AR is no 
longer needed. However, the sticky bit or session affinity is still needed 
between the user and mid tiers. 

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of patchsk
Sent: Monday, November 21, 2011 8:40 AM
To: arslist@ARSLIST.ORG
Subject: Re: Loadbalancer issue in Mid-Tier 7.6.04 SP2

 

** I think that feature is now available from ars7.6.04 and above.
So no sticky bit is needed for midtier load balancing.
Here is the text from BMC white paper on load balancer.
For versions 7.6.04 or later, BMC recommends configuring the load balancer that 
is located between the web servers and AR System servers without setting a 
“sticky” bit. In versions earlier than 7.6.04, BMC recommended setting the 
sticky 
bit to activate session affinity to route all connections from one web server 
to the 
same AR System server
http://documents.bmc.com/supportu/documents/61/98/186198/186198.pdf
_attend WWRUG12 www.wwrug.com 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
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: Importing data from server upgrade 7.6.3 to 7.6.4

[Dan]

I guess where our real issue was on the people record where you
specify which access restrictions the have for multi-tenancy.  This
information does not come over with the push of data.   Am I missing a
foundation form push to get his information over?   All of the other
foundation data came over but we had to go to the people records and
manually update the access restrictions.
Thanks for the help


Misi,

Unfortunately I cannot get your RRR software and use it on our
system.  I have seen it in action and would use it if I could.


v/r

Dan

___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug12www.wwrug12.comARSList: "Where the Answers Are"

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

Re: Loadbalancer issue in Mid-Tier 7.6.04 SP2

[Axton]

As far as I know, the load balancer in front of the midtier still
needs to use session persistence.  The whitepaper refers to the load
balancer in front of the AR Server.

If using an F5 BigIP LTM, make sure that you have set up a OneConnect
profile for the VIP:
http://support.f5.com/kb/en-us/solutions/public/7000/200/sol7208.html

If you look at your request/response pairs and the http access logs on
the midtier server, see if your requests are bouncing between multiple
nodes.  If they are there is an issue with your session persistence
configuration.  There are several different methods of session
persistence:
- Source IP
- Cookie Insert

The Cookie Insert method is the best option for the midtier servers,
but it requires that a OneConnect profile be configured.  The Source
IP method does not handle many situations as well as the cookie insert
method:
- Many clients are behind a NAT, thus they have the same source IP
- Clients use load balanced forward proxy servers (they may send
requests with different IP addresses)

See this for a recent discussion on the topic of midtier load balancer
configurations:
http://permalink.gmane.org/gmane.comp.crm.arsystem.general/100236

Axton Grams

On Mon, Nov 21, 2011 at 7:40 AM, patchsk  wrote:
> ** I think that feature is now available from ars7.6.04 and above.
> So no sticky bit is needed for midtier load balancing.
> Here is the text from BMC white paper on load balancer.
> For versions 7.6.04 or later, BMC recommends configuring the load balancer
> that
> is located between the web servers and AR System servers without setting a
> “sticky” bit. In versions earlier than 7.6.04, BMC recommended setting the
> sticky
> bit to activate session affinity to route all connections from one web
> server to the
> same AR System server
> http://documents.bmc.com/supportu/documents/61/98/186198/186198.pdf
> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_

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

Re: Loadbalancer issue in Mid-Tier 7.6.04 SP2

[patchsk]

Thanks for the reply. We are not into this version yet, so just trying to 
understand the changes in 7.6.04.

As we are not talking about Clients and  midtier, I do see the following 
notes related to this also in the same white paper.
Load balancing between the clients and web servers without 
setting a sticky bit. If the web servers in your AR System were installed 
in a cluster (with fail-over 
enabled), then setting the sticky bit on the load balancer between the 
clients and 
web servers is not needed.

Do they meant software cluster at web server level, not a hardware cluster.
Webservers configured in a cluster have inbuilt mechanism to share sessions?


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

Re: Loadbalancer issue in Mid-Tier 7.6.04 SP2

[Axton]

The use of the term "failover" implies to me that this applies to an
active/passive web server configuration where only a single web server
is active at a time.  In this case, session persistence is not needed.

Axton

On Mon, Nov 21, 2011 at 8:20 AM, patchsk  wrote:
> ** Thanks for the reply. We are not into this version yet, so just trying to
> understand the changes in 7.6.04.
>
> As we are not talking about Clients and  midtier, I do see the following
> notes related to this also in the same white paper.
> Load balancing between the clients and web servers without
> setting a sticky bit. If the web servers in your AR System were installed in
> a cluster (with fail-over
> enabled), then setting the sticky bit on the load balancer between the
> clients and
> web servers is not needed.
>
> Do they meant software cluster at web server level, not a hardware cluster.
> Webservers configured in a cluster have inbuilt mechanism to share sessions?
>
> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_

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

Re: Loadbalancer issue in Mid-Tier 7.6.04 SP2

[Randeep Atwal]

They mean software cluster at the web server level. �This works with the 
exception of Atrium CMDB as far as I know. �BMC are working on making Atrium 
work (they have some non serializable classes at present within Atrium I 
believe), but normal arsystem forms will now work with a clustered setup that 
does not require a sticky bit for the web server tier. �

This also works with the arsystem servers set to have no sticky bit.

Sent from my BlackBerry device on the Rogers Wireless Network

-Original Message-
From: patchsk 
Sender:   "Action Request System discussion list(ARSList)" 

Date: Mon, 21 Nov 2011 06:20:52 
To: 
Reply-To: arslist@ARSLIST.ORG
Subject: Re: Loadbalancer issue in Mid-Tier 7.6.04 SP2

Thanks for the reply. We are not into this version yet, so just trying to 
understand the changes in 7.6.04.

As we are not talking about Clients and  midtier, I do see the following 
notes related to this also in the same white paper.
Load balancing between the clients and web servers without 
setting a sticky bit. If the web servers in your AR System were installed 
in a cluster (with fail-over 
enabled), then setting the sticky bit on the load balancer between the 
clients and 
web servers is not needed.

Do they meant software cluster at web server level, not a hardware cluster.
Webservers configured in a cluster have inbuilt mechanism to share sessions?


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


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

Re: any experience or suggestions regarding improving performance of web client experience

[Jeff Jackson]

We are working on performance and tuning of our ITSM 7.6.03 implementation and 
am wondering if someone could point me in the right direction for the BMC bench 
mark document mentioned above. I have checked their knowledge base as well as 
the documentation for ITSM 7.6.03 and do not see it available for download. We 
would love to have this document to compare our system against.

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

Trying to find out what workflow make the server do a search on HPD:Help Desk form

[John . Atherly]

When I search on a field the holds the Kinetic number (KSR) the action 
takes along time to complete compared to the time it takes to search on 
the ICN number


Below is what my DBA sent me.

When searching by KSR it runs this sql which ignores the index:

SELECT * FROM ( SELECT 
T1908.C1,C100161,C100018,C100019,C10,C303497300,C100164,C7,C100217,C100218,C105261,C103009
 
FROM T1908 WHERE (T1908.C800021100 LIKE '%KSR00304374%') ORDER BY 
C100161 DESC, 1 ASC ) WHERE ROWNUM <=  9001

When searching by Incident Num it runs this sql which returns in seconds:

SELECT * FROM ( SELECT 
T1908.C1,C100161,C100018,C100019,C10,C303497300,C100164,C7,C100217,C100218,C105261,C103009
 
FROM T1908 WHERE (T1908.C100161 = 'INC00239686') ORDER BY 
C100161 DESC, 1 ASC ) WHERE ROWNUM <=  9001

Notice the difference in the clause after WHERE . 

When I run the first sql at the db level it takes between 60-90 seconds. 
When I run the modified sql below it returns in seconds just like the INC 
search:

SELECT * FROM ( SELECT 
T1908.C1,C100161,C100018,C100019,C10,C303497300,C100164,C7,C100217,C100218,C105261,C103009
 
FROM T1908 WHERE (T1908.C800021100 = 'KSR00304374') ORDER BY 
C100161 DESC, 1 ASC ) WHERE ROWNUM <=  9001


Where would this SQL statement live in Developer Studio. 

1.  Ran client side logs on AL, Filters and the other boxes checked off 
and nothing show up in my client side logs
2.  I have search and read several Active Links but none of them have the 
SQL statement
3.  Did the same for filters
4.  Searched menu guides

Currently the DBA is out for the Holiday and can not contact him. 

Remedy 7.6
Oracle back end

_
 


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

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

Re: any experience or suggestions regarding improving performance of web client experience

[Matt Laurenceau]

Hi.

This online doc
includes a
couple of resources.
Haven't look at details yet.

Thanks, Matt

On Mon, Nov 21, 2011 at 4:36 PM, Jeff Jackson wrote:

> We are working on performance and tuning of our ITSM 7.6.03 implementation
> and am wondering if someone could point me in the right direction for the
> BMC bench mark document mentioned above. I have checked their knowledge
> base as well as the documentation for ITSM 7.6.03 and do not see it
> available for download. We would love to have this document to compare our
> system against.
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>



-- 

~ Matt Laurenceau, BMC Software
Senior Community Ambassador, BMC Communities
matthieu_laurenc...@bmc.com
Follow me at @Matt_L 
Skype: matt.laurenceau

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

Re: Trying to find out what workflow make the server do a search on HPD:Help Desk form

[Frank Caruso]

Check out the QBE match on the field being searched. It probably says
Anywhere. Change it to leading or equal. This would be done in the
Admin tool for the form being searched.


On 11/21/11, john.athe...@schneider-electric.com
 wrote:
> When I search on a field the holds the Kinetic number (KSR) the action
> takes along time to complete compared to the time it takes to search on
> the ICN number
>
>
> Below is what my DBA sent me.
>
> When searching by KSR it runs this sql which ignores the index:
>
> SELECT * FROM ( SELECT
> T1908.C1,C100161,C100018,C100019,C10,C303497300,C100164,C7,C100217,C100218,C105261,C103009
> FROM T1908 WHERE (T1908.C800021100 LIKE '%KSR00304374%') ORDER BY
> C100161 DESC, 1 ASC ) WHERE ROWNUM <=  9001
>
> When searching by Incident Num it runs this sql which returns in seconds:
>
> SELECT * FROM ( SELECT
> T1908.C1,C100161,C100018,C100019,C10,C303497300,C100164,C7,C100217,C100218,C105261,C103009
> FROM T1908 WHERE (T1908.C100161 = 'INC00239686') ORDER BY
> C100161 DESC, 1 ASC ) WHERE ROWNUM <=  9001
>
> Notice the difference in the clause after WHERE .
>
> When I run the first sql at the db level it takes between 60-90 seconds.
> When I run the modified sql below it returns in seconds just like the INC
> search:
>
> SELECT * FROM ( SELECT
> T1908.C1,C100161,C100018,C100019,C10,C303497300,C100164,C7,C100217,C100218,C105261,C103009
> FROM T1908 WHERE (T1908.C800021100 = 'KSR00304374') ORDER BY
> C100161 DESC, 1 ASC ) WHERE ROWNUM <=  9001
>
>
> Where would this SQL statement live in Developer Studio.
>
> 1.  Ran client side logs on AL, Filters and the other boxes checked off
> and nothing show up in my client side logs
> 2.  I have search and read several Active Links but none of them have the
> SQL statement
> 3.  Did the same for filters
> 4.  Searched menu guides
>
> Currently the DBA is out for the Holiday and can not contact him.
>
> Remedy 7.6
> Oracle back end
>
> _
>
>
> John Atherly  |   APC by Schneider Electric   |  Information, Process &
> Organization (IPO)  |   Remedy Administrator / Developer
> Phone: +305-266-5005 ext. 237  |
> Email: john.athe...@apcc.com  |   Site: www.apc.com/  |   Address: 703
> Waterford Way, Suit 850, Miami, FL 33126 USA
> *** Please consider the environment before printing this e-mail
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>

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

Re: Trying to find out what workflow make the server do a search on HPD:Help Desk form

[Grooms, Frederick W]

The system is performing an anywhere LIKE search (T1908.C800021100 LIKE 
'%KSR00304374%') because you have the field that holds the KSR set for QBE 
Match = "Anywhere" (in the Database section of the Field's definition).   

Changing that to "Leading" should change the SQL to:   
   T1908.C800021100 LIKE 'KSR00304374%'   
which will use the index, but that will mean that you can no longer just enter 
the number 304374 to find the data.  If you want to just enter the number you 
would have to enter %304374 to find the data.

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of john.athe...@schneider-electric.com
Sent: Monday, November 21, 2011 9:40 AM
To: arslist@ARSLIST.ORG
Subject: Trying to find out what workflow make the server do a search on 
HPD:Help Desk form

** 
When I search on a field the holds the Kinetic number (KSR) the action takes a 
long time to complete compared to the time it takes to search on the ICN number 


Below is what my DBA sent me. 

When searching by KSR it runs this sql which ignores the index: 

SELECT * FROM ( SELECT  
T1908.C1,C100161,C100018,C100019,C10,C303497300,C100164,C7,C100217,C100218,C105261,C103009
 FROM T1908 WHERE (T1908.C800021100 LIKE '%KSR00304374%') ORDER BY 
C100161 DESC, 1 ASC ) WHERE ROWNUM <=  9001 

When searching by Incident Num it runs this sql which returns in seconds: 

SELECT * FROM ( SELECT  
T1908.C1,C100161,C100018,C100019,C10,C303497300,C100164,C7,C100217,C100218,C105261,C103009
 FROM T1908 WHERE (T1908.C100161 = 'INC00239686') ORDER BY C100161 
DESC, 1 ASC ) WHERE ROWNUM <=  9001 

Notice the difference in the clause after WHERE .   

When I run the first sql at the db level it takes between 60-90 seconds.  When 
I run the modified sql below it returns in seconds just like the INC search: 

SELECT * FROM ( SELECT  
T1908.C1,C100161,C100018,C100019,C10,C303497300,C100164,C7,C100217,C100218,C105261,C103009
 FROM T1908 WHERE (T1908.C800021100 = 'KSR00304374') ORDER BY C100161 
DESC, 1 ASC ) WHERE ROWNUM <=  9001 


Where would this SQL statement live in Developer Studio.   

1.  Ran client side logs on AL, Filters and the other boxes checked off and 
nothing show up in my client side logs 
2.  I have search and read several Active Links but none of them have the SQL 
statement 
3.  Did the same for filters 
4.  Searched menu guides 

Currently the DBA is out for the Holiday and can not contact him.   

Remedy 7.6 
Oracle back end 
_
 
John Atherly  |   APC by Schneider Electric   |  Information, Process & 
Organization (IPO)  |   Remedy Administrator / Developer 
Phone: +305-266-5005 ext. 237  |   
Email: john.athe...@apcc.com  |   Site: www.apc.com/  |   Address: 703 
Waterford Way, Suit 850, Miami, FL 33126 USA 

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

Re: any experience or suggestions regarding improving performance of web client experience

[patchsk]

https://communities.bmc.com/communities/message/148437#148437
http://documents.bmc.com/supportu/documents/11/88/121188/121188.pdf
http://documents.bmc.com/supportu/documents/46/71/104671/104671.pdf

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

RANT - any experience or suggestions regarding improving performance of web client experience

[Sanford, Claire]

Ok, I may be a bit cranky since I am working a ton of hours these days... but 
this reply was pretty useless.  I understand your desire to point people to the 
BMC Communities... but to include a link that requires them to log into the 
site and then throws up a red flag... is irritating.  Either answer the 
question or don't.

"This area of the BMC Communities is visible only to registered, logged in 
users. If you are logged in when you receive this message, then you might not 
have sufficient access privileges to view the requested page. Please contact 
us if you need further 
assistance. "

I have a sign on.  I was signed in and it gives me this message.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Matt Laurenceau
Sent: Monday, November 21, 2011 9:47 AM
To: arslist@ARSLIST.ORG
Subject: Re: any experience or suggestions regarding improving performance of 
web client experience

** Hi.

This online doc includes 
a couple of resources.
Haven't look at details yet.

Thanks, Matt
On Mon, Nov 21, 2011 at 4:36 PM, Jeff Jackson 
mailto:jeffery.e.jack...@jci.com>> wrote:
We are working on performance and tuning of our ITSM 7.6.03 implementation and 
am wondering if someone could point me in the right direction for the BMC bench 
mark document mentioned above. I have checked their knowledge base as well as 
the documentation for ITSM 7.6.03 and do not see it available for download. We 
would love to have this document to compare our system against.

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



--

~ Matt Laurenceau, BMC Software
Senior Community Ambassador, BMC Communities
matthieu_laurenc...@bmc.com
Follow me at @Matt_L
Skype: matt.laurenceau

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

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

Re: Trying to find out what workflow make the server do a search on HPD:Help Desk form

[John . Atherly]

Thank you Frank and Frederick   I never thought about QBE Match
_
 


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




"Grooms, Frederick W"  
Sent by: "Action Request System discussion list(ARSList)" 

11/21/2011 11:23 AM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Re: Trying to find out what workflow make the server do a search on 
HPD:Help Desk form






The system is performing an anywhere LIKE search (T1908.C800021100 LIKE 
'%KSR00304374%') because you have the field that holds the KSR set for 
QBE Match = "Anywhere" (in the Database section of the Field's 
definition). 

Changing that to "Leading" should change the SQL to: 
   T1908.C800021100 LIKE 'KSR00304374%' 
which will use the index, but that will mean that you can no longer just 
enter the number 304374 to find the data.  If you want to just enter the 
number you would have to enter %304374 to find the data.

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of 
john.athe...@schneider-electric.com
Sent: Monday, November 21, 2011 9:40 AM
To: arslist@ARSLIST.ORG
Subject: Trying to find out what workflow make the server do a search on 
HPD:Help Desk form

** 
When I search on a field the holds the Kinetic number (KSR) the action 
takes a long time to complete compared to the time it takes to search on 
the ICN number 


Below is what my DBA sent me. 

When searching by KSR it runs this sql which ignores the index: 

SELECT * FROM ( SELECT 
 
T1908.C1,C100161,C100018,C100019,C10,C303497300,C100164,C7,C100217,C100218,C105261,C103009
 
FROM T1908 WHERE (T1908.C800021100 LIKE '%KSR00304374%') ORDER BY 
C100161 DESC, 1 ASC ) WHERE ROWNUM <=  9001 

When searching by Incident Num it runs this sql which returns in seconds: 

SELECT * FROM ( SELECT 
 
T1908.C1,C100161,C100018,C100019,C10,C303497300,C100164,C7,C100217,C100218,C105261,C103009
 
FROM T1908 WHERE (T1908.C100161 = 'INC00239686') ORDER BY 
C100161 DESC, 1 ASC ) WHERE ROWNUM <=  9001 

Notice the difference in the clause after WHERE .   

When I run the first sql at the db level it takes between 60-90 seconds. 
 When I run the modified sql below it returns in seconds just like the INC 
search: 

SELECT * FROM ( SELECT 
 
T1908.C1,C100161,C100018,C100019,C10,C303497300,C100164,C7,C100217,C100218,C105261,C103009
 
FROM T1908 WHERE (T1908.C800021100 = 'KSR00304374') ORDER BY 
C100161 DESC, 1 ASC ) WHERE ROWNUM <=  9001 


Where would this SQL statement live in Developer Studio.   

1.  Ran client side logs on AL, Filters and the other boxes checked off 
and nothing show up in my client side logs 
2.  I have search and read several Active Links but none of them have the 
SQL statement 
3.  Did the same for filters 
4.  Searched menu guides 

Currently the DBA is out for the Holiday and can not contact him.   

Remedy 7.6 
Oracle back end 
_
 

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

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

__
This email has been scanned by the Symantec Email Security.cloud service.
__


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

Re: RANT - any experience or suggestions regarding improving performance of web client experience

[Axton]

Yep, I stopped reading further when I was prompted for login
information.  Have better things to do than dig up login information
to read content.  That's one of the things I really like about
ARSList, wikipedia, Oracle Documentation, BigIP, Java, WebSphere,
Tomcat, Apache, and many other sites.  Plus, I can find the
information I need using a search engine, versus having tribal
knowledge about a website that I use infrequently.

Axton Grams

On Mon, Nov 21, 2011 at 10:50 AM, Sanford, Claire
 wrote:
> **
>
> Ok, I may be a bit cranky since I am working a ton of hours these days… but
> this reply was pretty useless.  I understand your desire to point people to
> the BMC Communities… but to include a link that requires them to log into
> the site and then throws up a red flag… is irritating.  Either answer the
> question or don’t.
>
>
>
> “This area of the BMC Communities is visible only to registered, logged in
> users. If you are logged in when you receive this message, then you might
> not have sufficient access privileges to view the requested page. Please
> contact us if you need further assistance. “
>
>
>
> I have a sign on.  I was signed in and it gives me this message.
>
>
>
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Matt Laurenceau
> Sent: Monday, November 21, 2011 9:47 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: any experience or suggestions regarding improving performance
> of web client experience
>
>
>
> ** Hi.
>
>
>
> This online doc includes a couple of resources.
>
> Haven't look at details yet.
>
>
>
> Thanks, Matt
>
> On Mon, Nov 21, 2011 at 4:36 PM, Jeff Jackson 
> wrote:
>
> We are working on performance and tuning of our ITSM 7.6.03 implementation
> and am wondering if someone could point me in the right direction for the
> BMC bench mark document mentioned above. I have checked their knowledge base
> as well as the documentation for ITSM 7.6.03 and do not see it available for
> download. We would love to have this document to compare our system against.
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>
>
>
> --
>
>
>
> ~ Matt Laurenceau, BMC Software
>
> Senior Community Ambassador, BMC Communities
>
> matthieu_laurenc...@bmc.com
>
> Follow me at @Matt_L
>
> Skype: matt.laurenceau
>
>
>
> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
>
> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_

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

Re: RANT - any experience or suggestions regarding improving performance of web client experience

[Matt Laurenceau]

Ooops, sorry Claire. That's the resource I'm familiar with. 
Will check out tomorrow the permission issue. 

Matt Laurenceau
Senior Community Ambassador, BMC Communities
matthieu_laurenc...@bmc.com
Follow me @Matt_L
Skype: matt.laurenceau


On 21 nov. 2011, at 17:50, "Sanford, Claire" 
 wrote:

> **
> Ok, I may be a bit cranky since I am working a ton of hours these days… but 
> this reply was pretty useless.  I understand your desire to point people to 
> the BMC Communities… but to include a link that requires them to log into the 
> site and then throws up a red flag… is irritating.  Either answer the 
> question or don’t.
>  
> “This area of the BMC Communities is visible only to registered, logged in 
> users. If you are logged in when you receive this message, then you might not 
> have sufficient access privileges to view the requested page. Please contact 
> us if you need further assistance. “
>  
> I have a sign on.  I was signed in and it gives me this message.
>  
> From: Action Request System discussion list(ARSList) 
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Matt Laurenceau
> Sent: Monday, November 21, 2011 9:47 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: any experience or suggestions regarding improving performance of 
> web client experience
>  
> ** Hi.
>  
> This online doc includes a couple of resources.
> Haven't look at details yet.
>  
> Thanks, Matt
> 
> On Mon, Nov 21, 2011 at 4:36 PM, Jeff Jackson  
> wrote:
> We are working on performance and tuning of our ITSM 7.6.03 implementation 
> and am wondering if someone could point me in the right direction for the BMC 
> bench mark document mentioned above. I have checked their knowledge base as 
> well as the documentation for ITSM 7.6.03 and do not see it available for 
> download. We would love to have this document to compare our system against.
> 
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
> 
> 
>  
> --
>  
> ~ Matt Laurenceau, BMC Software
> Senior Community Ambassador, BMC Communities
> matthieu_laurenc...@bmc.com
> Follow me at @Matt_L
> Skype: matt.laurenceau 
>  
> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
> _attend WWRUG12 www.wwrug.com  ARSlist: "Where the Answers Are"_

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

Re: RANT - any experience or suggestions regarding improving performance of web client experience

[Matt Laurenceau]

Axton, Claire, 

I'm with you here, I like easy access to information. 
Will check out permission issue tomorrow (I sure didn't do it on purpose)

Regards,

Matt Laurenceau
Senior Community Ambassador, BMC Communities
matthieu_laurenc...@bmc.com
Follow me @Matt_L
Skype: matt.laurenceau


On 21 nov. 2011, at 17:57, Axton  wrote:

> Yep, I stopped reading further when I was prompted for login
> information.  Have better things to do than dig up login information
> to read content.  That's one of the things I really like about
> ARSList, wikipedia, Oracle Documentation, BigIP, Java, WebSphere,
> Tomcat, Apache, and many other sites.  Plus, I can find the
> information I need using a search engine, versus having tribal
> knowledge about a website that I use infrequently.
> 
> Axton Grams
> 
> On Mon, Nov 21, 2011 at 10:50 AM, Sanford, Claire
>  wrote:
>> **
>> 
>> Ok, I may be a bit cranky since I am working a ton of hours these days… but
>> this reply was pretty useless.  I understand your desire to point people to
>> the BMC Communities… but to include a link that requires them to log into
>> the site and then throws up a red flag… is irritating.  Either answer the
>> question or don’t.
>> 
>> 
>> 
>> “This area of the BMC Communities is visible only to registered, logged in
>> users. If you are logged in when you receive this message, then you might
>> not have sufficient access privileges to view the requested page. Please
>> contact us if you need further assistance. “
>> 
>> 
>> 
>> I have a sign on.  I was signed in and it gives me this message.
>> 
>> 
>> 
>> From: Action Request System discussion list(ARSList)
>> [mailto:arslist@ARSLIST.ORG] On Behalf Of Matt Laurenceau
>> Sent: Monday, November 21, 2011 9:47 AM
>> To: arslist@ARSLIST.ORG
>> Subject: Re: any experience or suggestions regarding improving performance
>> of web client experience
>> 
>> 
>> 
>> ** Hi.
>> 
>> 
>> 
>> This online doc includes a couple of resources.
>> 
>> Haven't look at details yet.
>> 
>> 
>> 
>> Thanks, Matt
>> 
>> On Mon, Nov 21, 2011 at 4:36 PM, Jeff Jackson 
>> wrote:
>> 
>> We are working on performance and tuning of our ITSM 7.6.03 implementation
>> and am wondering if someone could point me in the right direction for the
>> BMC bench mark document mentioned above. I have checked their knowledge base
>> as well as the documentation for ITSM 7.6.03 and do not see it available for
>> download. We would love to have this document to compare our system against.
>> 
>> ___
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>> 
>> 
>> 
>> --
>> 
>> 
>> 
>> ~ Matt Laurenceau, BMC Software
>> 
>> Senior Community Ambassador, BMC Communities
>> 
>> matthieu_laurenc...@bmc.com
>> 
>> Follow me at @Matt_L
>> 
>> Skype: matt.laurenceau
>> 
>> 
>> 
>> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
>> 
>> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
> 
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

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

Re: Auto-Table Refresh After Active Link fires

[Mary Dollus]

Setting the Table chunk to > 0 worked for the auto-refresh issue!!! Thanks Mike 
White!

Thanks again to all who responded!

and Thanks Fred, nope I answer directly on the list,,, the arslist email is 
blocked for me.. :( so I'll just copy/paste :)


-Original Message- 
Are the previous comments in your reply email (This is controlled by your email 
client and not the list server)?  (In Outlook it is Tools -> Options -> 
Preferences tab -> E-mail Options button)  
 
Fred 
 
-Original Message- 
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mary Dollus 
Sent: Thursday, November 17, 2011 4:44 PM 
To: arslist@ARSLIST.ORG 
Subject: Re: Auto-Table Refresh After Active Link fires 
 
Mike, Setting the chunk size of the table to > 0 works like a charm on SP1 and 
SP2! 
 
another Q... when I reply on here to a message, how can I get it to retain the 
previous comments? 
 
Thanks! 
Mary 

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

Re: RANT/OOPSS - any experience or suggestions regarding improving performance of web client experience

[Matt Laurenceau]

Was able to check further. Indeed, it was pointing to a non-open Community.
My bad, brain fried.

Axton, Claire, I also definitely want BMC Communities to be *very* open.
We've been opening and simplifying many areas on Communities in the past weeks, 
this one is still in the backlog. 

Regards,

~ Matt Laurenceau
Senior Community Ambassador, BMC Communities
matthieu_laurenc...@bmc.com
Follow me @Matt_L
Skype: matt.laurenceau 


On 21 nov. 2011, at 18:11, Matt Laurenceau  wrote:

> Axton, Claire, 
> 
> I'm with you here, I like easy access to information. 
> Will check out permission issue tomorrow (I sure didn't do it on purpose)
> 
> Regards,
> 
> Matt Laurenceau
> Senior Community Ambassador, BMC Communities
> matthieu_laurenc...@bmc.com
> Follow me @Matt_L
> Skype: matt.laurenceau
> 
> 
> On 21 nov. 2011, at 17:57, Axton  wrote:
> 
>> Yep, I stopped reading further when I was prompted for login
>> information.  Have better things to do than dig up login information
>> to read content.  That's one of the things I really like about
>> ARSList, wikipedia, Oracle Documentation, BigIP, Java, WebSphere,
>> Tomcat, Apache, and many other sites.  Plus, I can find the
>> information I need using a search engine, versus having tribal
>> knowledge about a website that I use infrequently.
>> 
>> Axton Grams
>> 
>> On Mon, Nov 21, 2011 at 10:50 AM, Sanford, Claire
>>  wrote:
>>> **
>>> 
>>> Ok, I may be a bit cranky since I am working a ton of hours these days… but
>>> this reply was pretty useless.  I understand your desire to point people to
>>> the BMC Communities… but to include a link that requires them to log into
>>> the site and then throws up a red flag… is irritating.  Either answer the
>>> question or don’t.
>>> 
>>> 
>>> 
>>> “This area of the BMC Communities is visible only to registered, logged in
>>> users. If you are logged in when you receive this message, then you might
>>> not have sufficient access privileges to view the requested page. Please
>>> contact us if you need further assistance. “
>>> 
>>> 
>>> 
>>> I have a sign on.  I was signed in and it gives me this message.
>>> 
>>> 
>>> 
>>> From: Action Request System discussion list(ARSList)
>>> [mailto:arslist@ARSLIST.ORG] On Behalf Of Matt Laurenceau
>>> Sent: Monday, November 21, 2011 9:47 AM
>>> To: arslist@ARSLIST.ORG
>>> Subject: Re: any experience or suggestions regarding improving performance
>>> of web client experience
>>> 
>>> 
>>> 
>>> ** Hi.
>>> 
>>> 
>>> 
>>> This online doc includes a couple of resources.
>>> 
>>> Haven't look at details yet.
>>> 
>>> 
>>> 
>>> Thanks, Matt
>>> 
>>> On Mon, Nov 21, 2011 at 4:36 PM, Jeff Jackson 
>>> wrote:
>>> 
>>> We are working on performance and tuning of our ITSM 7.6.03 implementation
>>> and am wondering if someone could point me in the right direction for the
>>> BMC bench mark document mentioned above. I have checked their knowledge base
>>> as well as the documentation for ITSM 7.6.03 and do not see it available for
>>> download. We would love to have this document to compare our system against.
>>> 
>>> ___
>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>>> 
>>> 
>>> 
>>> --
>>> 
>>> 
>>> 
>>> ~ Matt Laurenceau, BMC Software
>>> 
>>> Senior Community Ambassador, BMC Communities
>>> 
>>> matthieu_laurenc...@bmc.com
>>> 
>>> Follow me at @Matt_L
>>> 
>>> Skype: matt.laurenceau
>>> 
>>> 
>>> 
>>> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
>>> 
>>> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
>> 
>> ___
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

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

Re: RANT/OOPSS - any experience or suggestions regarding improving performance of web client experience

[Axton]

I have faith you will see it through ;)  Just letting out my take on
it all so you know where at least 1 person stands on these kinds of
things.

Axton Grams

On Mon, Nov 21, 2011 at 11:51 AM, Matt Laurenceau
 wrote:
> Was able to check further. Indeed, it was pointing to a non-open Community.
> My bad, brain fried.
>
> Axton, Claire, I also definitely want BMC Communities to be *very* open.
> We've been opening and simplifying many areas on Communities in the past 
> weeks, this one is still in the backlog.
>
> Regards,
>
> ~ Matt Laurenceau
> Senior Community Ambassador, BMC Communities
> matthieu_laurenc...@bmc.com
> Follow me @Matt_L
> Skype: matt.laurenceau
>
>
> On 21 nov. 2011, at 18:11, Matt Laurenceau  wrote:
>
>> Axton, Claire,
>>
>> I'm with you here, I like easy access to information.
>> Will check out permission issue tomorrow (I sure didn't do it on purpose)
>>
>> Regards,
>>
>> Matt Laurenceau
>> Senior Community Ambassador, BMC Communities
>> matthieu_laurenc...@bmc.com
>> Follow me @Matt_L
>> Skype: matt.laurenceau
>>
>>
>> On 21 nov. 2011, at 17:57, Axton  wrote:
>>
>>> Yep, I stopped reading further when I was prompted for login
>>> information.  Have better things to do than dig up login information
>>> to read content.  That's one of the things I really like about
>>> ARSList, wikipedia, Oracle Documentation, BigIP, Java, WebSphere,
>>> Tomcat, Apache, and many other sites.  Plus, I can find the
>>> information I need using a search engine, versus having tribal
>>> knowledge about a website that I use infrequently.
>>>
>>> Axton Grams
>>>
>>> On Mon, Nov 21, 2011 at 10:50 AM, Sanford, Claire
>>>  wrote:
 **

 Ok, I may be a bit cranky since I am working a ton of hours these days… but
 this reply was pretty useless.  I understand your desire to point people to
 the BMC Communities… but to include a link that requires them to log into
 the site and then throws up a red flag… is irritating.  Either answer the
 question or don’t.



 “This area of the BMC Communities is visible only to registered, logged in
 users. If you are logged in when you receive this message, then you might
 not have sufficient access privileges to view the requested page. Please
 contact us if you need further assistance. “



 I have a sign on.  I was signed in and it gives me this message.



 From: Action Request System discussion list(ARSList)
 [mailto:arslist@ARSLIST.ORG] On Behalf Of Matt Laurenceau
 Sent: Monday, November 21, 2011 9:47 AM
 To: arslist@ARSLIST.ORG
 Subject: Re: any experience or suggestions regarding improving performance
 of web client experience



 ** Hi.



 This online doc includes a couple of resources.

 Haven't look at details yet.



 Thanks, Matt

 On Mon, Nov 21, 2011 at 4:36 PM, Jeff Jackson 
 wrote:

 We are working on performance and tuning of our ITSM 7.6.03 implementation
 and am wondering if someone could point me in the right direction for the
 BMC bench mark document mentioned above. I have checked their knowledge 
 base
 as well as the documentation for ITSM 7.6.03 and do not see it available 
 for
 download. We would love to have this document to compare our system 
 against.

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



 --



 ~ Matt Laurenceau, BMC Software

 Senior Community Ambassador, BMC Communities

 matthieu_laurenc...@bmc.com

 Follow me at @Matt_L

 Skype: matt.laurenceau



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

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

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

Re: RANT - any experience or suggestions regarding improving performance of web client experience

[Easter, David]

> Plus, I can find the information I need using a search engine, versus having 
> tribal knowledge about a website that I use infrequently.

The public forums on BMC DN actually show up in searches (Google, Yahoo, etc.) 
- so that does work properly.   For example, if I type "BMC web reporting 
parameters" into Google, all the postings about the topic show up in the first 
several hits...

-David J. Easter
Manager of Product Management, Remedy Platform
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.
-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: Monday, November 21, 2011 8:57 AM
To: arslist@ARSLIST.ORG
Subject: Re: RANT - any experience or suggestions regarding improving 
performance of web client experience

Yep, I stopped reading further when I was prompted for login
information.  Have better things to do than dig up login information
to read content.  That's one of the things I really like about
ARSList, wikipedia, Oracle Documentation, BigIP, Java, WebSphere,
Tomcat, Apache, and many other sites.  Plus, I can find the
information I need using a search engine, versus having tribal
knowledge about a website that I use infrequently.

Axton Grams

On Mon, Nov 21, 2011 at 10:50 AM, Sanford, Claire
 wrote:
> **
>
> Ok, I may be a bit cranky since I am working a ton of hours these days. but
> this reply was pretty useless.  I understand your desire to point people to
> the BMC Communities. but to include a link that requires them to log into
> the site and then throws up a red flag. is irritating.  Either answer the
> question or don't.
>
>
>
> "This area of the BMC Communities is visible only to registered, logged in
> users. If you are logged in when you receive this message, then you might
> not have sufficient access privileges to view the requested page. Please
> contact us if you need further assistance. "
>
>
>
> I have a sign on.  I was signed in and it gives me this message.
>
>
>
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Matt Laurenceau
> Sent: Monday, November 21, 2011 9:47 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: any experience or suggestions regarding improving performance
> of web client experience
>
>
>
> ** Hi.
>
>
>
> This online doc includes a couple of resources.
>
> Haven't look at details yet.
>
>
>
> Thanks, Matt
>
> On Mon, Nov 21, 2011 at 4:36 PM, Jeff Jackson 
> wrote:
>
> We are working on performance and tuning of our ITSM 7.6.03 implementation
> and am wondering if someone could point me in the right direction for the
> BMC bench mark document mentioned above. I have checked their knowledge base
> as well as the documentation for ITSM 7.6.03 and do not see it available for
> download. We would love to have this document to compare our system against.
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>
>
>
> --
>
>
>
> ~ Matt Laurenceau, BMC Software
>
> Senior Community Ambassador, BMC Communities
>
> matthieu_laurenc...@bmc.com
>
> Follow me at @Matt_L
>
> Skype: matt.laurenceau
>
>
>
> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
>
> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_

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

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

Atrium CMDB-Asset Integration: Issue when relating Business Services with Companies

[Alejandro Canon]

Hi Listers

ARS 7.6.04 SP1
CMDB 7.6.04
ITSM 7.6.04

We have about 40 customers, each one of them with its Company record.
When relating Companies to some business Service CI's (AST:AssetPeople) through 
People tab in AST:BusinessService form, we're facing this issue related:

Value does not fall within the limits specified for the field : (Maximum length 
- 255) : BMC.CORE:BMC_BaseElement : CMDBRowLevelSecurity (ARERR 306)

After checking CMDBRowLevelSecurity field for Business Service CI affected, 
it's filled with Group ID's for all Companies related to this service (About 30 
customers). It seems to be the field is full and we can't add any company 
record without getting error messages because there´s no available space in 
that field in order too add new company records.

What can I do? Extend CMDBRowLevelSecurity size is not a good option. Neither 
modiifying Company model for our customers.

Any ideas?

Regards,

Alejandro

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

Re: Atrium CMDB-Asset Integration: Issue when relating Business Services with Companies

[Chowdhury, Tauf]

Alejandro,

What about breaking up that Business Service CI into other logical CI's so that 
you are not relating 1 business service to the entire company list? I know it's 
not a solution but maybe it can be a worthy workaround. 

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Alejandro Canon
Sent: Monday, November 21, 2011 2:36 PM
To: arslist@ARSLIST.ORG
Subject: Atrium CMDB-Asset Integration: Issue when relating Business Services 
with Companies

 

** 

Hi Listers

 

ARS 7.6.04 SP1

CMDB 7.6.04

ITSM 7.6.04

 

We have about 40 customers, each one of them with its Company record.

When relating Companies to some business Service CI's (AST:AssetPeople) through 
People tab in AST:BusinessService form, we're facing this issue related:

 

Value does not fall within the limits specified for the field : (Maximum length 
- 255) : BMC.CORE:BMC_BaseElement : CMDBRowLevelSecurity (ARERR 306) 

 

After checking CMDBRowLevelSecurity field for Business Service CI affected, 
it's filled with Group ID's for all Companies related to this service (About 30 
customers). It seems to be the field is full and we can't add any company 
record without getting error messages because there´s no available space in 
that field in order too add new company records.

 

What can I do? Extend CMDBRowLevelSecurity size is not a good option. Neither 
modiifying Company model for our customers.

 

Any ideas?

 

Regards,

 

Alejandro

_attend WWRUG12 www.wwrug.com 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
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

FYI: ITSM 7.6.4 SP2 Future Approvers Issue

[Pierson, Shawn]

Good afternoon,

I just wanted to give you all a heads up in case you run into an issue that we 
ran into.  Basically, in ITSM 7.6.4 SP2, Change Management, we would be able to 
essentially lock up the system by simply selecting the "Future Approvers" 
option on a Change Request above the approvers table.  This seemed to cause 
some issue with the Plugin Server, although I'm still not quite sure what the 
problem was.

The solution was for BMC to provide a hotfix of basically giving us a new 
arapprove.dll.  This cleared it up completely for us.  I wanted to post this 
here in case someone else runs into that issue and spends time trying to fix 
it.  Just contact BMC and get them to send you the updated file.

Thanks,

Shawn Pierson
Remedy Developer | Southern Union

Private and confidential as detailed here: 
http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the 
link, please e-mail sender.

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

Re: RANT - any experience or suggestions regarding improving performance of web client experience

[Axton]

It's a start.  All those product docs, white papers, release notes,
and other sources that contain lots of useful information are not
searchable using search engines; those sources of information
typically contain the information that my searches would return a hit
on but they are not indexed and publicly searchable.

Axton Grams

On Mon, Nov 21, 2011 at 12:20 PM, Easter, David  wrote:
>> Plus, I can find the information I need using a search engine, versus having 
>> tribal knowledge about a website that I use infrequently.
>
> The public forums on BMC DN actually show up in searches (Google, Yahoo, 
> etc.) - so that does work properly.   For example, if I type "BMC web 
> reporting parameters" into Google, all the postings about the topic show up 
> in the first several hits...
>
> -David J. Easter
> Manager of Product Management, Remedy Platform
> 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.
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
> Sent: Monday, November 21, 2011 8:57 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: RANT - any experience or suggestions regarding improving 
> performance of web client experience
>
> Yep, I stopped reading further when I was prompted for login
> information.  Have better things to do than dig up login information
> to read content.  That's one of the things I really like about
> ARSList, wikipedia, Oracle Documentation, BigIP, Java, WebSphere,
> Tomcat, Apache, and many other sites.  Plus, I can find the
> information I need using a search engine, versus having tribal
> knowledge about a website that I use infrequently.
>
> Axton Grams
>
> On Mon, Nov 21, 2011 at 10:50 AM, Sanford, Claire
>  wrote:
>> **
>>
>> Ok, I may be a bit cranky since I am working a ton of hours these days. but
>> this reply was pretty useless.  I understand your desire to point people to
>> the BMC Communities. but to include a link that requires them to log into
>> the site and then throws up a red flag. is irritating.  Either answer the
>> question or don't.
>>
>>
>>
>> "This area of the BMC Communities is visible only to registered, logged in
>> users. If you are logged in when you receive this message, then you might
>> not have sufficient access privileges to view the requested page. Please
>> contact us if you need further assistance. "
>>
>>
>>
>> I have a sign on.  I was signed in and it gives me this message.
>>
>>
>>
>> From: Action Request System discussion list(ARSList)
>> [mailto:arslist@ARSLIST.ORG] On Behalf Of Matt Laurenceau
>> Sent: Monday, November 21, 2011 9:47 AM
>> To: arslist@ARSLIST.ORG
>> Subject: Re: any experience or suggestions regarding improving performance
>> of web client experience
>>
>>
>>
>> ** Hi.
>>
>>
>>
>> This online doc includes a couple of resources.
>>
>> Haven't look at details yet.
>>
>>
>>
>> Thanks, Matt
>>
>> On Mon, Nov 21, 2011 at 4:36 PM, Jeff Jackson 
>> wrote:
>>
>> We are working on performance and tuning of our ITSM 7.6.03 implementation
>> and am wondering if someone could point me in the right direction for the
>> BMC bench mark document mentioned above. I have checked their knowledge base
>> as well as the documentation for ITSM 7.6.03 and do not see it available for
>> download. We would love to have this document to compare our system against.
>>
>> ___
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>>
>>
>>
>> --
>>
>>
>>
>> ~ Matt Laurenceau, BMC Software
>>
>> Senior Community Ambassador, BMC Communities
>>
>> matthieu_laurenc...@bmc.com
>>
>> Follow me at @Matt_L
>>
>> Skype: matt.laurenceau
>>
>>
>>
>> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
>>
>> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>

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

Re: RANT - any experience or suggestions regarding improving performance of web client experience

[Easter, David]

I do not disagree.  We continue to have discussions with BMC Legal 
representatives to find ways to compromise on protecting Intellectual Property 
while balancing customer convenience.  If/When things change in that area, I'll 
be sure to let the community know.

-David J. Easter
Manager of Product Management, Remedy Platform
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.


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: Monday, November 21, 2011 11:58 AM
To: arslist@ARSLIST.ORG
Subject: Re: RANT - any experience or suggestions regarding improving 
performance of web client experience

It's a start.  All those product docs, white papers, release notes,
and other sources that contain lots of useful information are not
searchable using search engines; those sources of information
typically contain the information that my searches would return a hit
on but they are not indexed and publicly searchable.

Axton Grams

On Mon, Nov 21, 2011 at 12:20 PM, Easter, David  wrote:
>> Plus, I can find the information I need using a search engine, versus having 
>> tribal knowledge about a website that I use infrequently.
>
> The public forums on BMC DN actually show up in searches (Google, Yahoo, 
> etc.) - so that does work properly.   For example, if I type "BMC web 
> reporting parameters" into Google, all the postings about the topic show up 
> in the first several hits...
>
> -David J. Easter
> Manager of Product Management, Remedy Platform
> 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.
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
> Sent: Monday, November 21, 2011 8:57 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: RANT - any experience or suggestions regarding improving 
> performance of web client experience
>
> Yep, I stopped reading further when I was prompted for login
> information.  Have better things to do than dig up login information
> to read content.  That's one of the things I really like about
> ARSList, wikipedia, Oracle Documentation, BigIP, Java, WebSphere,
> Tomcat, Apache, and many other sites.  Plus, I can find the
> information I need using a search engine, versus having tribal
> knowledge about a website that I use infrequently.
>
> Axton Grams
>
> On Mon, Nov 21, 2011 at 10:50 AM, Sanford, Claire
>  wrote:
>> **
>>
>> Ok, I may be a bit cranky since I am working a ton of hours these days. but
>> this reply was pretty useless.  I understand your desire to point people to
>> the BMC Communities. but to include a link that requires them to log into
>> the site and then throws up a red flag. is irritating.  Either answer the
>> question or don't.
>>
>>
>>
>> "This area of the BMC Communities is visible only to registered, logged in
>> users. If you are logged in when you receive this message, then you might
>> not have sufficient access privileges to view the requested page. Please
>> contact us if you need further assistance. "
>>
>>
>>
>> I have a sign on.  I was signed in and it gives me this message.
>>
>>
>>
>> From: Action Request System discussion list(ARSList)
>> [mailto:arslist@ARSLIST.ORG] On Behalf Of Matt Laurenceau
>> Sent: Monday, November 21, 2011 9:47 AM
>> To: arslist@ARSLIST.ORG
>> Subject: Re: any experience or suggestions regarding improving performance
>> of web client experience
>>
>>
>>
>> ** Hi.
>>
>>
>>
>> This online doc includes a couple of resources.
>>
>> Haven't look at details yet.
>>
>>
>>
>> Thanks, Matt
>>
>> On Mon, Nov 21, 2011 at 4:36 PM, Jeff Jackson 
>> wrote:
>>
>> We are working on performance and tuning of our ITSM 7.6.03 implementation
>> and am wondering if someone could point me in the right direction for the
>> BMC bench mark document mentioned above. I have checked their knowledge base
>> as well as the documentation for ITSM 7.6.03 and do not see it available for
>> download. We would love to have this document to compare our system against.
>>
>> ___
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>>
>>
>>
>> --
>>
>>
>>
>> ~ Matt Laurenceau, BMC Software
>>
>> Senior Community Ambassador, BMC Communities
>>
>> matthieu_laurenc...@bmc.com
>>
>> Follow me at @Matt_L
>

Re: Loadbalancer issue in Mid-Tier 7.6.04 SP2

[Brett Azzopardi]

Are you still able to run queries/continue following that error message? I 
would suggest you check your lb setup, some applications allow sessions to 
change between mid tier servers, from my experience remedy requires session 
persistence or stickiness.

Sent from my HTC

- Reply message -
From: "Nithin Vinod Kumar" 
To: "ARSList" 
Subject: Loadbalancer issue in Mid-Tier 7.6.04 SP2
Date: Mon, Nov 21, 2011 10:53 pm




** 
Hi All,
 
We are facing a issue with the loadbalancer Mid-Tier 7.6.04 SP2.
 
While using the midtier with load balancer we are getting the below error 
message altough it goes to the homepage.
 
"Session is invalid or has timed out. Please reload page to log in again. 
(ARERR 9201) "
 
But when we individually access each midtier, it is working fine.
 
Please suggest.
 
Thanks & Regards,
Nithin
 
 
_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ 

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

Re: any experience or suggestions regarding improving performance of web client experience

[Prabhakaran, Prasanth (GO IN Application Management)]

Hi 

Below are the main areas which we need to focus when we are doing a performance 
tuning. Hope this will help you.

Best practices for monitoring CPU consumption

1.Collect CPU usage data for each machine in the configuration.
2.Make sure less than 70% of the total CPU capacity is used on every system in 
the configuration.
3.Note which processes are consuming the majority of the CPU resources.
4.Note whether wait I/O time is a substantial component of CPU use. (This 
indicates that the I/O subsystem is not   keeping up with demand.)

Best practices for monitoring memory consumption

1.Make sure no system in the configuration is running out of physical memory 
and swapping.
2.Be aware of 64-bit and 32-bit limitations on both the OS and applications.
3.Track memory growth over time to identify any memory leaks.

Best practices for tuning the mid tier

1.Use precaching to avoid high latency for first-time access to a form.
2.Set resource_check_interval to one day.
3.Set minimum heap size to 512 MB and maximum heap size to 1 GB.
4.Set pooling_max_total_connections to 2000.

Best practices for tuning database (Oracle) servers

1.Use external storage to increase I/O bandwidth on the database server.
2.Use an appropriately sized System Global Area (SGA).
3.Set cursor_sharing to force in 9i and similar in 10g.
4.Use statspack (9i) or AWR (10g) reports to collect diagnostics.
5.If system is I/O bound or db_file_scattered_read events exist, consider 
whether highload SQL statements need   tuning or additional indexes should be 
added.
6.Keep HASH_JOIN_ENABLED set to false (the default).

Best practices for tuning the AR System server

1.Set thread count for fast and list to appropriate values.
2.Set NEXT_ID_BLOCK_SIZE to 10.
3.Use AR System server logging to obtain additional diagnostic information.
4.Set Max Entries Returned by GetList and Server Table Field Chunk Size to 
reduce the impact of queries with large   return sets.

Best practices for tuning the overall system

1.Survey each area of your system for possible tuning issues before making any 
changes.
2.Prioritize all changes by their likely impact on the identified problem.
3.Implement changes one at a time in a prioritized manner.
4.Quantitatively evaluate the impact of every change before considering whether 
another change should be made.


Regards,
Prasanth

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Jeff Jackson
Sent: Monday, November 21, 2011 9:07 PM
To: arslist@ARSLIST.ORG
Subject: Re: any experience or suggestions regarding improving performance of 
web client experience

We are working on performance and tuning of our ITSM 7.6.03 implementation and 
am wondering if someone could point me in the right direction for the BMC bench 
mark document mentioned above. I have checked their knowledge base as well as 
the documentation for ITSM 7.6.03 and do not see it available for download. We 
would love to have this document to compare our system against.

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


Think green - keep it on the screen.

This e-mail and any attachment is for authorised use by the intended 
recipient(s) only. It may contain proprietary material, confidential 
information and/or be subject to legal privilege. It should not be copied, 
disclosed to, retained or used by, any other party. If you are not an intended 
recipient then please promptly delete this e-mail and any attachment and all 
copies and inform the sender. Thank you.



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

Field ID Updation

[Bhupesh Gupta]

Hi All,

Is there any way we can update fieldID directly on form without deleting
and creating in ARS 7.6.04? Kindly advise.

-- 
Regards,
Bhupesh Gupta

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

Re: Field ID Updation

[Joe Martin D'Souza]

No. There are meta data tables that need to be updated even if that field has 
not yet been used by any workflow..

Besides there is no way of editing  the Field ID from the Dev Studio or the AR 
Admin tool whatever you use for development depending on your version of the AR 
System..

If you have no data on that form for that field at all, and there is no 
workflow that the field in question is tied to, then you could delete the field 
from the form and recreate it giving it the new Field ID..

If not, if you have lots of data as well as workflow that the field is tied to, 
use the archgid utility that will be found on your installation directory of 
the server, to change the Field ID. This utility does a clean job of modifying 
all the relationships in the meta data that are needed so as to tie the 
workflow back to that field when the Id is changed.. This method is the only 
supported method..

There are alternatives if you do not have access to this utility if you have 
access to the database directly, by modifying it & the relationships from the 
database which Remedy Support will not support you on, should you mess up 
things.. So it is possible from DB level too. But since you are even asking 
this question, I’m assuming you have limited knowledge of the underlying 
database relationships, so I’d recommend you stick to the utility if you have 
workflow and data in that field..

Joe

From: Bhupesh Gupta 
Sent: Tuesday, November 22, 2011 12:40 AM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG 
Subject: Field ID Updation

** 
Hi All,

Is there any way we can update fieldID directly on form without deleting and 
creating in ARS 7.6.04? Kindly advise.

-- 
Regards,
Bhupesh Gupta

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

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

Re: Field ID Updation

[Misi Mladoniczky]

Hi,

You should find archgid in the unsupported directory of your server
install, I think.

Here is a guide from BMCDN (that does not require a login ;-)
https://communities.bmc.com/communities/docs/DOC-5423

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

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

> No. There are meta data tables that need to be updated even if that field
> has not yet been used by any workflow..
>
> Besides there is no way of editing  the Field ID from the Dev Studio or
> the AR Admin tool whatever you use for development depending on your
> version of the AR System..
>
> If you have no data on that form for that field at all, and there is no
> workflow that the field in question is tied to, then you could delete the
> field from the form and recreate it giving it the new Field ID..
>
> If not, if you have lots of data as well as workflow that the field is
> tied to, use the archgid utility that will be found on your installation
> directory of the server, to change the Field ID. This utility does a clean
> job of modifying all the relationships in the meta data that are needed so
> as to tie the workflow back to that field when the Id is changed.. This
> method is the only supported method..
>
> There are alternatives if you do not have access to this utility if you
> have access to the database directly, by modifying it & the relationships
> from the database which Remedy Support will not support you on, should you
> mess up things.. So it is possible from DB level too. But since you are
> even asking this question, I’m assuming you have limited knowledge of the
> underlying database relationships, so I’d recommend you stick to the
> utility if you have workflow and data in that field..
>
> Joe
>
> From: Bhupesh Gupta
> Sent: Tuesday, November 22, 2011 12:40 AM
> Newsgroups: public.remedy.arsystem.general
> To: arslist@ARSLIST.ORG
> Subject: Field ID Updation
>
> **
> Hi All,
>
> Is there any way we can update fieldID directly on form without deleting
> and creating in ARS 7.6.04? Kindly advise.
>
> --
> Regards,
> Bhupesh Gupta
>
> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

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