Re: Thanks to all WW RUG participants, those that attended our talks and visited our booth, BMC, and especially the Organizers

[Geoff Endresen]

+ 10 ;-)

Sent from my iPad

On Oct 26, 2010, at 3:27 AM, Ben Chernys  
wrote:

> **
> Just wanted to say a big thanks to all participants, an extra thanks to those 
> that took the time to listen to our talks and visit our booth, thanks to BMC 
> for providing a wide array of senior people (and providing the rockets), and 
> finally a big giant thank you for all the hard work done by all the WW RUG 
> Organisers.
> 
>  
> 
> It was great to meet you in person and finally attach faces to those years of 
> emails on the arslist. 
> 
>  
> 
> It was also great to meet former co-workers Dan and Ed after some 15 years 
> after we had worked together on ARS release 2.
> 
>  
> 
> I am also especially enthralled to see the interest and reaction to 
> Meta-Update and will follow up with those that attended the talks and 
> requested more information.
> 
>  
> 
> Cheers
> 
> Ben Chernys
> 
> Senior Software Architect
> Software Tool House Inc.
> 
> Canada / Deutschland / Germany
> Mobile:  +49 171 380 2329GMT + 1 + [ DST ]
> Email:   ben.cher...@softwaretoolhouse.com
> Web: www.softwaretoolhouse.com
> 
> Check out Software Tool House's free Diary Editor.
> 
> Meta-Update, our premium ARS Data tool, lets you automate 
> your imports, migrations, in no time at all, without programming, 
> without staging forms, without merge workflow. 
> http://www.softwaretoolhouse.com/ 
> 
>  
> 
> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_

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

Critical: Value of pending field differ while taking reporting from midtier

[Anuj DUA]

Hello,

We are facing an issue where pending  field on hpd:helpdesk is showing 
different value while taking report. But the actual value is different on ticket

For eg.
pending field has -

* Parts

* Requester information

* Problem

* Answer

* Action
While the ticket is showing Answer but while taking report it is showing Action 
on mid tier

When we export the file from aruser, it shows Answer in the file but Action on 
the tool


With Regards,
Anuj Dua



With Regards,
Anuj Dua


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

Re: java error from 7.1 mid-tier on

[Joe Martin D'Souza]

Larry,

Welcome to the list..

Out of memory errors typically happen when your java heap size is undersized..

You have to optimize the available java heap memory. Be careful while doing so 
as you do not want to size it higher than your server is capable of. Leaving 20 
to 30% headroom when defining the max heap size is generally a good idea..

Joe


From: Hayes, Larry [JJCUS] 
Sent: Tuesday, October 26, 2010 9:58 PM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG 
Subject: java error from 7.1 mid-tier on

** 
Hi Everyone,

 

(this is my first post…)

 

I receive the following when I login to a Remedy Support Console on AR System 
using 7.1 mid-tier:

Error. The server encountered an unexpected condition which prevented it from 
fulfilling the request. 

java.lang.OutOfMemoryError

at java.io.RandomAccessFile.readBytes(Native Method)

at java.io.RandomAccessFile.read(RandomAccessFile.java:315)

at java.io.RandomAccessFile.readFully(RandomAccessFile.java:371)

at java.io.RandomAccessFile.readFully(RandomAccessFile.java:351)

at 
net.sf.ehcache.store.DiskStore.loadElementFromDiskElement(DiskStore.java:276)

at net.sf.ehcache.store.DiskStore.get(DiskStore.java:250)

at net.sf.ehcache.Cache.searchInDiskStore(Cache.java:846)

at net.sf.ehcache.Cache.get(Cache.java:657)

at net.sf.ehcache.Cache.get(Cache.java:632)

at com.remedy.arsys.share.Cachetable.get(Unknown Source)

at com.remedy.arsys.share.FieldMapCache.get(Unknown Source)

at com.remedy.arsys.goat.Form.getCachedFieldMap(Unknown Source)

at com.remedy.arsys.goat.Form.getCachedFieldMap(Unknown Source)

at 
com.remedy.arsys.goat.preferences.ARUserPreferences.getEnumValue(Unknown Source)

at 
com.remedy.arsys.goat.preferences.ARUserPreferences.setPreferenceValue(Unknown 
Source)

at 
com.remedy.arsys.goat.preferences.ARUserPreferences.clearAndLoadDefaultFields(Unknown
 Source)

at 
com.remedy.arsys.goat.preferences.ARUserPreferences.loadFromServer(Unknown 
Source)

at 
com.remedy.arsys.goat.preferences.ARUserPreferences.addConfiguredPreferences(Unknown
 Source)

at com.remedy.arsys.goat.preferences.ARUserPreferences.(Unknown Source)

at 
com.remedy.arsys.goat.preferences.ARUserPreferences.getUserPreferences(Unknown 
Source)

at com.remedy.arsys.stubs.SessionData.(Unknown Source)

at com.remedy.arsys.stubs.SessionData.(Unknown Source)

at com.remedy.arsys.session.Login.initSessions(Unknown Source)

at com.remedy.arsys.session.Login.establishSession(Unknown Source)

at com.remedy.arsys.session.Login.establishSession(Unknown Source)

at com.remedy.arsys.stubs.GoatServlet.postInternal(Unknown Source)

at com.remedy.arsys.stubs.GoatHttpServlet.doGet(Unknown Source)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

at 
com.newatlanta.servletexec.SERequestDispatcher.forwardServlet(SERequestDispatcher.java:638)

at 
com.newatlanta.servletexec.SERequestDispatcher.forward(SERequestDispatcher.java:236)

at 
com.newatlanta.servletexec.SERequestDispatcher.internalForward(SERequestDispatcher.java:283)

at 
com.newatlanta.servletexec.ApplicationInfo.processApplRequest(ApplicationInfo.java:1846)

at 
com.newatlanta.servletexec.ServerHostInfo.processApplRequest(ServerHostInfo.java:937)

at 
com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:1091)

at 
com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:1002)

 

Has anyone seen anything like this before? I’ve worked with AR System for five 
years and never have experienced this kind of error.

 

Thanks,

Larry Hayes

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

java error from 7.1 mid-tier on

[Hayes, Larry [JJCUS]]

Hi Everyone,

 

(this is my first post...)

 

I receive the following when I login to a Remedy Support Console on AR
System using 7.1 mid-tier:

Error. The server encountered an unexpected condition which prevented it
from fulfilling the request. 

java.lang.OutOfMemoryError

at java.io.RandomAccessFile.readBytes(Native Method)

at java.io.RandomAccessFile.read(RandomAccessFile.java:315)

at java.io.RandomAccessFile.readFully(RandomAccessFile.java:371)

at java.io.RandomAccessFile.readFully(RandomAccessFile.java:351)

at
net.sf.ehcache.store.DiskStore.loadElementFromDiskElement(DiskStore.java
:276)

at net.sf.ehcache.store.DiskStore.get(DiskStore.java:250)

at net.sf.ehcache.Cache.searchInDiskStore(Cache.java:846)

at net.sf.ehcache.Cache.get(Cache.java:657)

at net.sf.ehcache.Cache.get(Cache.java:632)

at com.remedy.arsys.share.Cachetable.get(Unknown Source)

at com.remedy.arsys.share.FieldMapCache.get(Unknown Source)

at com.remedy.arsys.goat.Form.getCachedFieldMap(Unknown Source)

at com.remedy.arsys.goat.Form.getCachedFieldMap(Unknown Source)

at
com.remedy.arsys.goat.preferences.ARUserPreferences.getEnumValue(Unknown
Source)

at
com.remedy.arsys.goat.preferences.ARUserPreferences.setPreferenceValue(U
nknown Source)

at
com.remedy.arsys.goat.preferences.ARUserPreferences.clearAndLoadDefaultF
ields(Unknown Source)

at
com.remedy.arsys.goat.preferences.ARUserPreferences.loadFromServer(Unkno
wn Source)

at
com.remedy.arsys.goat.preferences.ARUserPreferences.addConfiguredPrefere
nces(Unknown Source)

at com.remedy.arsys.goat.preferences.ARUserPreferences.(Unknown
Source)

at
com.remedy.arsys.goat.preferences.ARUserPreferences.getUserPreferences(U
nknown Source)

at com.remedy.arsys.stubs.SessionData.(Unknown Source)

at com.remedy.arsys.stubs.SessionData.(Unknown Source)

at com.remedy.arsys.session.Login.initSessions(Unknown Source)

at com.remedy.arsys.session.Login.establishSession(Unknown
Source)

at com.remedy.arsys.session.Login.establishSession(Unknown
Source)

at com.remedy.arsys.stubs.GoatServlet.postInternal(Unknown
Source)

at com.remedy.arsys.stubs.GoatHttpServlet.doGet(Unknown Source)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

at
com.newatlanta.servletexec.SERequestDispatcher.forwardServlet(SERequestD
ispatcher.java:638)

at
com.newatlanta.servletexec.SERequestDispatcher.forward(SERequestDispatch
er.java:236)

at
com.newatlanta.servletexec.SERequestDispatcher.internalForward(SERequest
Dispatcher.java:283)

at
com.newatlanta.servletexec.ApplicationInfo.processApplRequest(Applicatio
nInfo.java:1846)

at
com.newatlanta.servletexec.ServerHostInfo.processApplRequest(ServerHostI
nfo.java:937)

at
com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:1
091)

at
com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:1
002)

 

Has anyone seen anything like this before? I've worked with AR System
for five years and never have experienced this kind of error.

 

Thanks,

Larry Hayes

 

 


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

Re: use mod_proxy_ajp connector to tomcat (6) instead of mod_jk?

[Joe Martin D'Souza]

Rabi,

Have you checked if the user that runs apache and the tomcat web servelet, 
has access to the mid-tier directories?


Joe

-Original Message- 
From: Rabi Tripathi
Sent: Tuesday, October 26, 2010 3:19 PM Newsgroups: 
public.remedy.arsystem.general

To: arslist@ARSLIST.ORG
Subject: use mod_proxy_ajp connector to tomcat (6) instead of mod_jk?

Can anybody provide any tips...list of steps for doing this?

I installed ARS &  Midtier using the ARS 7.6.03 suite installer on a RHEL 5 
64-bit VM. After mid-tier install, the config.jsp URL (or any other) wasn't 
working.


I installed both ARS & Midtier as non root. ARS runs fine, can access using 
Rem User. During midtier install, I specified directory to existing apache 
setup (v 2.2.3), and asked for tomcat to be installed. I made sure that the 
user had write permissions on httpd.conf and related directories for 
existing apache setup, and I followed the usual instruction, did 
post-install taks for ARS install etc (didn't see any for midtier as 
non-root).


After the mid-tier install, apache's httpd.conf was left untouched. Mid-tier 
URLs through apache, of course, didn't work.


I can get to the default page for apache. I can also get to the new tomcat 
on my browser directly at its port number (not through apache). I get the 
"apache is running" text. It doesn't seem to know about midtier.


I tried doing mod_proxy_ajp configuration on httpd.conf file and tomcat's 
xml files, and have it recognize/serve midtier, but no success so far. I 
don't hve mod_jk and would like to avoid it based on local admin's 
preference.


My main issue seems to be having tomcat be aware of midtier/midtier's jars.
With proper configuration, I am thinking I should be able to access mid-tier 
directly on tomcat's port...without having to worry about mod_proxy_ajp 
connector (which really instructs apache, as i understand). Then I plan to 
have it work with apache, through the port reroute by apache. If this two 
step plan doesn't make sense, somebody please correct me.


Support site has info on mod_jk connector setup, but not mod_proxy_ajp.

Way more complications than I want to deal with at the moment. I don't want 
to go off and start down the path of becoming a tomcat/apache configuration 
specialist. Can't it all work nicely with a few simple steps that somebody 
must have written down at some point? I wish.


Any tips on steps for mod_proxy_ajp configuration for midtier 7.6.03??

TIA. 


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

Error upgrading CMDB 2.0.1 Patch 9 to CMDB 2.1.0 Patch003

[G. Lafontant]

I received this error below while upgrading the _CMDB 2.0.1 P009_ to 
_CMDB 2.1.0 P003_.  Anyone encounters this issue before to please share 
input on a fix.


thanks all in advance.

Platform:
AIX 5.3
ARS 7.1 Patch009
ITSM 7.0.03 Patch09

Error:
Importing upgrade workflow.
Performing upgrade for: BMC Atrium CMDB 2.1.00 patch 000 stage 3

Problem upgrading to 2.1.00 patch 000 stage 3 using 
metadata-upgr-import-OSD.txt


Once the problem has been resolved, repeat the installation.

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

Re: PBX

[keith thompson]

Marcelo,

See Mapping Your Data to BMC Atrium CMDB 7.6.03 Classes (#160651) from the
support site.  It's for 7.6.03, but should give you plenty of pointers.

btw, pbx is:
CI=Modular switching system
Class=BMC.CORE:BMC_ComputerSystem
Cat 1=Hardware
Cat 2=Telecommunication
Cat 3=PBX

(unless it's a voice switch, then it's different)

hth
k

On Tue, Oct 26, 2010 at 2:19 PM, Martinez, Marcelo A wrote:

> What class should PBXs be listed under in the CMDB? I currently have them
> under computer system but I cannot find a suitable "Primary Capability".
>  Also, I have not created a category for this type of assets..
>
> ARS 7.1
> CMDB 2.0
> ITSM 7.0.03
>
> Thanks,
> Marcelo
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>

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

PBX

[Martinez, Marcelo A]

What class should PBXs be listed under in the CMDB? I currently have them under 
computer system but I cannot find a suitable "Primary Capability".  Also, I 
have not created a category for this type of assets..

ARS 7.1
CMDB 2.0
ITSM 7.0.03

Thanks,
Marcelo

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

Re: CMDB Import Recon Job

[Mike Tomasiewicz (ConAgra Foods)]

>From the BMC Users Guide ...

To import reconciliation definitions:
1 Open a command prompt.
2 If using Microsoft Windows, change to the directory where BMC Data Import 
tools
are installed.
The default directory is
\AR System\\dataimporttool.
3 Enter the command:
dataimport.bat -x  -u  -p  -a
 -o  -l  -e 179 -D 4

For , specify the full path to the file containing the exported
definitions from the procedure "Exporting reconciliation definitions" on page 
132.
Specifying a log file is optional, but recommended in case there are any errors 
with
the import. If you are not using portmapper, you can specify the port for the 
server
with the optional -a parameter.

The -e 179 option enables you to verify whether a definition you are importing
already exists. This check is performed based on the globally unique identifier
(GUID) values. Specifying the -D4 option updates an entry if a match is found. 
If
no match is found, a new entry is created. For more information about the 
various
options for the dataimport.bat utility, click the Help

.:Mike:.

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Ranjith
Sent: Tuesday, October 26, 2010 2:35 PM
To: arslist@ARSLIST.ORG
Subject: CMDB Import Recon Job

Hi everyone,

>From the Atrium Console, I've been able to do an Export of a recon job.  The 
>problem is I don't see where/how to import an exported recon job.

Thanks,
Ranjith Kariminlla

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

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

CMDB Import Recon Job

[Ranjith]

Hi everyone,

>From the Atrium Console, I've been able to do an Export of a recon
job.  The problem is I don't see where/how to import an exported recon
job.

Thanks,
Ranjith Kariminlla

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

use mod_proxy_ajp connector to tomcat (6) instead of mod_jk?

[Rabi Tripathi]

Can anybody provide any tips...list of steps for doing this?

I installed ARS &  Midtier using the ARS 7.6.03 suite installer on a RHEL 5 
64-bit VM. After mid-tier install, the config.jsp URL (or any other) wasn't 
working. 

I installed both ARS & Midtier as non root. ARS runs fine, can access using Rem 
User. During midtier install, I specified directory to existing apache setup (v 
2.2.3), and asked for tomcat to be installed. I made sure that the user had 
write permissions on httpd.conf and related directories for existing apache 
setup, and I followed the usual instruction, did post-install taks for ARS 
install etc (didn't see any for midtier as non-root).

After the mid-tier install, apache's httpd.conf was left untouched. Mid-tier 
URLs through apache, of course, didn't work.

I can get to the default page for apache. I can also get to the new tomcat on 
my browser directly at its port number (not through apache). I get the "apache 
is running" text. It doesn't seem to know about midtier.

I tried doing mod_proxy_ajp configuration on httpd.conf file and tomcat's xml 
files, and have it recognize/serve midtier, but no success so far. I don't hve 
mod_jk and would like to avoid it based on local admin's preference.

My main issue seems to be having tomcat be aware of midtier/midtier's jars. 
With proper configuration, I am thinking I should be able to access mid-tier 
directly on tomcat's port...without having to worry about mod_proxy_ajp 
connector (which really instructs apache, as i understand). Then I plan to have 
it work with apache, through the port reroute by apache. If this two step plan 
doesn't make sense, somebody please correct me.

Support site has info on mod_jk connector setup, but not mod_proxy_ajp.

Way more complications than I want to deal with at the moment. I don't want to 
go off and start down the path of becoming a tomcat/apache configuration 
specialist. Can't it all work nicely with a few simple steps that somebody must 
have written down at some point? I wish.

Any tips on steps for mod_proxy_ajp configuration for midtier 7.6.03??

TIA.


  

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

Re: ARERR [8760] Cannot establish a network connection to the AR System Plug-In server : BMC.FILTERAPI.NORM.ENGINE

[Rabi Tripathi]

Thank you all. Found the setting to make "Service" optional. And the ar.conf 
fix is working.

--- On Thu, 10/21/10, strauss  wrote:

> From: strauss 
> Subject: Re: ARERR [8760] Cannot establish a network connection to the AR 
> System Plug-In server : BMC.FILTERAPI.NORM.ENGINE
> To: arslist@ARSLIST.ORG
> Date: Thursday, October 21, 2010, 4:07 PM
> That is the fix that support gave me
> when I reported the following problem with a sample data
> 7.5/7.6 -> 7.6.03 system:
> 
> "Attempting to change an email address in a sample data
> CTM:People record (Allen Allbrook) fails with the error:
> ARERR [8753] Error in plugin : BMC.FILTERAPI.NORM.ENGINE"
> 
> All of the Atrium 7.6.x installs are setting this flag
> incorrectly in the ar.cfg.  Support says that it also
> causes serious performance problems.
> 
> There is a configuration for Incident that will make
> selecting a Service optional - I had to set it on my sample
> data systems to allow testing.
> 
> Christopher Strauss, Ph.D.
> Call Tracking Administration Manager
> University of North Texas Computing & IT Center
> 
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org]
> On Behalf Of Rabi Tripathi
> Sent: Thursday, October 21, 2010 1:53 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: ARERR [8760] Cannot establish a network
> connection to the AR System Plug-In server :
> BMC.FILTERAPI.NORM.ENGINE
> 
> Doug, the same here, any CI.
> 
> By updating this line on ar.conf to say "F" instead of
> "T":
> CMDB-Inline-Normalization: F
> 
> I got past the error. However, not sure if all is well and
> I haven't had time to find out yet implications of having a
> F.
> 
> Another annoyance, can't create an incident...requires a
> "Service" to be chosen. I added a business service CI, but
> can't get it to show up on the menu for Service. Wonder if
> setting the value to F has anything to do with this. Should
> read up on this parameter. 
> 
> I wish the stack already had a service CI preconfigured
> during the install. Or the Service CI configuration should
> have been pre-stacked in the installer. Or pre-installed on
> the stack of configuration. I don't know, just can't seem to
> get it right.
> 
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers
> Are"
> 




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

Re: Indexing Values Rarely Used

[Guillaume Rheault]

One more thing Frank

Also make sure the table statistics are up to date ensure such index would be 
used (at least for Oracle).
When table statistics are updated, the index statistics on that table are 
updated too.
In Oracle 10g and 11g, there are scheduled jobs that keep the statistics up to 
date. However, you may want to manually refresh the statistics of that table 
before viewing the execution plans that would tell you whether that index was 
used or not

Guillaume


From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on 
behalf of Misi Mladoniczky [...@rrr.se]
Sent: Tuesday, October 26, 2010 11:56 AM
To: arslist@ARSLIST.ORG
Subject: Re: Indexing Values Rarely Used

Hi,

You may need to tune your database settings to get the index to be used.

An index where 90% of the records has the same value (NULL, Status=Closed,
...) may not be used otherwise, as the database may determine that it is
not selective enough. And it would not be selective enough if you searched
for NULL/Closed, but when any of the other values are referenced, it could
improve performance considerably.

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

Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
* 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.

> Frank,
>
> The overhead is the same for the index regardless of content.  Why?
> Because NULL is a value (actually the
> lack of a value) and that has to be updated in the index too so that you
> can efficiently search for NULL values
> just like any other value.
>
> So, the cost of the index is really the same.
>
> The answer for you about whether to add it is whether it is important for
> retrieval performance.  From what
> you describe, it is.  Without it, you will get table scans in the use case
> you indicate and if it is a large
> table, that is a challenge.
>
> In general, the overhead for maintaining an index is reasonably small and
> if there is a significant use for that
> index for widespread or even narrow use patterns, it is worth creating.
>
> Doug Mueller
>
> 
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Frank Caruso
> Sent: Monday, October 25, 2010 8:33 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: Indexing Values Rarely Used
>
> ** Because they want to be able to search on that field with no other
> criteria. Its sort of like a pointer to an end user that may or may be
> included in a ticket.
>
> Anyhow, I was just hoping that adding the index would not put any extra
> strain on the database because the value would not often be included.
>
>
> On Mon, Oct 25, 2010 at 10:14 AM, Jarl Grøneng
> mailto:jarl.gron...@gmail.com>> wrote:
> Why do you need an index on a column that rarely contains a value?
>
> --
> J
>
> 2010/10/22 Frank Caruso
> mailto:caruso.fr...@gmail.com>>:
>> ** Oracle 10G on Solaris 10
>>
>> If in an index is added to a form against a single column but that
>> column
>> rarely contains a value, does it have the same impact on the database as
>> a
>> column that is indexed against a required field?
>>
>> My thought is that if there is no value provided for the column then the
>> database does not perform any extra work to maintain the index.
>>
>> Thank you
>>
>> Frank
>> _attend WWRUG10 www.wwrug.com ARSlist: "Where the
>> Answers Are"_
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at
> www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the
> Answers Are"
>
> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>

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

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

Re: IE Script error in SRM / midtier

[Guillaume Rheault]

Hi Vi

There is no fix on this on the Remedy side...
The solution to this problem is to either upgrade to IE 8.0 or use Firefox. 
Firefox is great, and I have not seen yet this kind of issues with Firefox

Guillaume


From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on 
behalf of Vianna Vianna [vianna...@hotmail.com]
Sent: Tuesday, October 26, 2010 1:26 PM
To: arslist@ARSLIST.ORG
Subject: Re: IE Script error in SRM / midtier

** Thanks for the reply. We actually clear the cache in order to replicate the 
error on user's machines.  It'll happen occassionally on some user's machines 
and if we want it to happen on demand while investigating, we clear the cache 
again. So agreed that it seems to be an IE issue, but not sure what the fix 
might be.

Thanks again.

Vi


Date: Tue, 26 Oct 2010 14:38:29 +
From: guilla...@dcshq.com
Subject: Re: IE Script error in SRM / midtier
To: arslist@ARSLIST.ORG

**
This kind of errors are usually related to corruption in the IE cache.
Therefore what those users need to do is delete all the temporary files in IE:

1. Click on Internet Options
2. On the General tab,  click on Delete...
3. Click on Delete Files..., then click Close
4. Close all instances of Internet Explorer that are running

After this, the user needs to open a new IE, and log back into Remedy

Guillaume

From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on 
behalf of Vianna Vianna [vianna...@hotmail.com]
Sent: Monday, October 25, 2010 1:44 PM
To: arslist@ARSLIST.ORG
Subject: IE Script error in SRM / midtier

** Hello
Some of our users are receiving a concerning script error when launching the 
Service Request Management portal.

They are getting:

IE Script Error
An error has occurred in the script on this page
Line: 21
Char: 1
Error: Syntax error
Code: 0
URL: http://(our midtier server)/arsys/plugins/ 
etc... and then it shows the AR server name, user's name, and user's password

Do you want to continue running scripts on this page?

If you select yes, then another script error appears  with:
Line: 17
Char:2
Error: 'EventDispatcher' is undefined

and the URL for this second script  is identical to the one above.

Our primary concern is the fact that the user's password is passed in clear 
text.

Anybody else experience something like this?

We're running ARSystem 7.5 (patch 003), SRM 2.2, and IE 7

Thank you

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

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

Re: Installing wut patch from scratch

[Martin, Dwayne - martinrd]

Thanks, Lisa!

That is what I thot, but we are having some problems and are sort of grasping 
for straws to figure out why our installation isn't working.

At least we know it isn't that.

Thanks again,
Dwayne

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa
Sent: Tuesday, October 26, 2010 1:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: Installing wut patch from scratch

**
You should be able to just install the 7.5 patch and be done.  No need to 
install a base and then the patch on top of it.  Patched version are cumulative.


Lisa



From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Martin, Dwayne - martinrd
Sent: Tuesday, October 26, 2010 1:03 PM
To: arslist@ARSLIST.ORG
Subject: Installing wut patch from scratch
**
Dear List,

Can you install a wut 7.5 patch on a new Windows machine, or do you need to 
install the base version, and then the patch.

(I did try to find this in the documentation, but obviously didn't look in the 
right place.)

Dwayne Martin
James Madison University
_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_

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

Re: IE Script error in SRM / midtier

[Vianna Vianna]

Thanks for the reply. We actually clear the cache in order to replicate the 
error on user's machines.  It'll happen occassionally on some user's machines 
and if we want it to happen on demand while investigating, we clear the cache 
again. So agreed that it seems to be an IE issue, but not sure what the fix 
might be. 
 
Thanks again.
 
Vi
 


Date: Tue, 26 Oct 2010 14:38:29 +
From: guilla...@dcshq.com
Subject: Re: IE Script error in SRM / midtier
To: arslist@ARSLIST.ORG

** 




This kind of errors are usually related to corruption in the IE cache.
Therefore what those users need to do is delete all the temporary files in IE:

1. Click on Internet Options
2. On the General tab,  click on Delete...
3. Click on Delete Files..., then click Close
4. Close all instances of Internet Explorer that are running

After this, the user needs to open a new IE, and log back into Remedy

Guillaume




From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on 
behalf of Vianna Vianna [vianna...@hotmail.com]
Sent: Monday, October 25, 2010 1:44 PM
To: arslist@ARSLIST.ORG
Subject: IE Script error in SRM / midtier



** 

Hello
Some of our users are receiving a concerning script error when launching the 
Service Request Management portal. 
 
They are getting: 
 
IE Script Error
An error has occurred in the script on this page
Line: 21
Char: 1
Error: Syntax error
Code: 0 
URL: http://(our midtier server)/arsys/plugins/ etc... and then it shows the AR 
server name, user's name, and user's password
 
Do you want to continue running scripts on this page?
 
If you select yes, then another script error appears  with:
Line: 17
Char:2
Error: 'EventDispatcher' is undefined
 
and the URL for this second script  is identical to the one above. 
 
Our primary concern is the fact that the user's password is passed in clear 
text. 
 
Anybody else experience something like this? 
 
We're running ARSystem 7.5 (patch 003), SRM 2.2, and IE 7
 
Thank you
 
Vi
_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 
www.wwrug.com ARSlist: "Where the Answers Are"_ 
  
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Installing wut patch from scratch

[Kemes, Lisa]

You should be able to just install the 7.5 patch and be done.  No need to 
install a base and then the patch on top of it.  Patched version are cumulative.


Lisa




From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Martin, Dwayne - martinrd
Sent: Tuesday, October 26, 2010 1:03 PM
To: arslist@ARSLIST.ORG
Subject: Installing wut patch from scratch

**
Dear List,

Can you install a wut 7.5 patch on a new Windows machine, or do you need to 
install the base version, and then the patch.

(I did try to find this in the documentation, but obviously didn't look in the 
right place.)

Dwayne Martin
James Madison University
_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_

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

Installing wut patch from scratch

[Martin, Dwayne - martinrd]

Dear List,

Can you install a wut 7.5 patch on a new Windows machine, or do you need to 
install the base version, and then the patch.

(I did try to find this in the documentation, but obviously didn't look in the 
right place.)

Dwayne Martin
James Madison University

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

Re: Filter Issue: Command Line Action is not translating DB NAMES with character on Oracle 11g, AIX 6.1, ARS 7.5P4

[Ddussie]

Misi, 

Thank you so much. I had the time to try your suggestion below, it worked. 
Exporting filter to XML, change label to dbid: reimport.

I have a request with bmc, i will send the your suggestion, pointing in some 
direction. Unfortunately, this could be happening else where in environment.

Sincerely,
D.Dussie


On Oct 14, 2010, at 3:22 PM, Misi Mladoniczky  wrote:

> Hi,
> 
> In that case you do not have an admin tool but a developer studio. I do
> not know in which order it performs its magic...
> 
> You may very well be able to do the def-xml-trick though. At least to
> verify what is in the FLTR def.
> 
>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.
> Find these products, and many free tools and utilities, at http://rrr.se.
> 
>> Version admin tool: 7.5 P6.
>> 
>> I will try this " Have you tried exporting the FLTR to a def-file? I
>> recommend an XML-filein this case, to simplify editing.If you find the
>> text in there, try to replace it with the field-id andreimport it."
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> -Original Message-
>> From: Misi Mladoniczky 
>> To: arslist 
>> Sent: Thu, Oct 14, 2010 1:10 pm
>> Subject: Re: Filter Issue: Command Line Action is not translating DB NAMES
>> with character on Oracle 11g, AIX 6.1, ARS 7.5P4
>> 
>> 
>> Hi,
>> 
>> Which version are you on? My experience with this is mainly from the good
>> odl Admin-tool.
>> 
>> Have you tried exporting the FLTR to a def-file? I recommend an XML-file
>> in this case, to simplify editing.
>> 
>> If you find the text in there, try to replace it with the field-id and
>> reimport 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.
>> Find these products, and many free tools and utilities, at http://rrr.se.
>> 
>>> 
>>> Hi Misi,
>>> 
>>> Tried that also, same outcome.
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> -Original Message-
>>> From: Misi Mladoniczky 
>>> To: arslist 
>>> Sent: Thu, Oct 14, 2010 11:44 am
>>> Subject: Re: Filter Issue: Command Line Action is not translating DB
>>> NAMES
>>> with character on Oracle 11g, AIX 6.1, ARS 7.5P4
>>> 
>>> 
>>> Hi,
>>> 
>>> It should convert it to a name on your screen after you press
>>> Modify/Save.
>>> This is not what is stored in your actual FLTR/ACTL, it should be the
>>> ID.
>>> 
>>> If you edit the FLTR/ACTL action and resave it, it will do the
>>> string-to-id-conversion which is probably what is failing to you...
>>> 
>>> So every time you need to change the command, you need to change the
>>> Name
>>> to the Id before saving your change.
>>> 
>>>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.
>>> Find these products, and many free tools and utilities, at
>>> http://rrr.se.
>>> 
 Hi Fred, thanks for responding.
 
 Sorry, I forgot to mention - I tried the DB ID; however, it converts to
 the DB Name.
 
 
 
 
 
 
 -Original Message-
 From: Grooms, Frederick W 
 To: arslist 
 Sent: Thu, Oct 14, 2010 10:57 am
 Subject: Re: Filter Issue: Command Line Action is not translating DB
 NAMES
 with character on Oracle 11g, AIX 6.1, ARS 7.5P4
 
 
 It looks like the system is not recognizing your field name in the
 filter.
 In
 your filter's Run Process action try putting the field ID and saving
 the
 filter.
 This will let the system pull the field name.
 
 Fred
 
 ---Original Message---
 From: Action Request System discussion list(ARSList)
 [mailto:arsl...@arslist.org]
 On Behalf Of D
 Sent: Thursday, October 14, 2010 6:20 AM
 To: arslist@ARSLIST.ORG
 Subject: Filter Issue: Command Line Action is not translating DB NAMES
 with
 character on Oracle 11g, AIX 6.1, ARS 7.5P4
 
 **
 
 Hello,
 
 Filter Issue: Run Process: Command Line Action is not translating DB
 NAMES
 with
 character on Oracle 11g, AIX 6.1, ARS 7.5P4
 
 Our Test environment is configured:Oracle 11g, AIX 6.1, ARS 7.5P4
 Our Prod environment is configured:Oracle 10g, AIX 6.1, ARS 7.5P4
 
 We are not having this issue on production, can anyone provide a
 possible
 solution?
 
 Process: On submit of incident/change ticket, this filter fires run
 process to
 run a command local to the unix server, passing variables for that
 request.
 However, one of the variables has characters.
 
>>>

Re: Indexing Values Rarely Used

[Misi Mladoniczky]

Hi,

You may need to tune your database settings to get the index to be used.

An index where 90% of the records has the same value (NULL, Status=Closed,
...) may not be used otherwise, as the database may determine that it is
not selective enough. And it would not be selective enough if you searched
for NULL/Closed, but when any of the other values are referenced, it could
improve performance considerably.

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

Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
* 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.

> Frank,
>
> The overhead is the same for the index regardless of content.  Why?
> Because NULL is a value (actually the
> lack of a value) and that has to be updated in the index too so that you
> can efficiently search for NULL values
> just like any other value.
>
> So, the cost of the index is really the same.
>
> The answer for you about whether to add it is whether it is important for
> retrieval performance.  From what
> you describe, it is.  Without it, you will get table scans in the use case
> you indicate and if it is a large
> table, that is a challenge.
>
> In general, the overhead for maintaining an index is reasonably small and
> if there is a significant use for that
> index for widespread or even narrow use patterns, it is worth creating.
>
> Doug Mueller
>
> 
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Frank Caruso
> Sent: Monday, October 25, 2010 8:33 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: Indexing Values Rarely Used
>
> ** Because they want to be able to search on that field with no other
> criteria. Its sort of like a pointer to an end user that may or may be
> included in a ticket.
>
> Anyhow, I was just hoping that adding the index would not put any extra
> strain on the database because the value would not often be included.
>
>
> On Mon, Oct 25, 2010 at 10:14 AM, Jarl Grøneng
> mailto:jarl.gron...@gmail.com>> wrote:
> Why do you need an index on a column that rarely contains a value?
>
> --
> J
>
> 2010/10/22 Frank Caruso
> mailto:caruso.fr...@gmail.com>>:
>> ** Oracle 10G on Solaris 10
>>
>> If in an index is added to a form against a single column but that
>> column
>> rarely contains a value, does it have the same impact on the database as
>> a
>> column that is indexed against a required field?
>>
>> My thought is that if there is no value provided for the column then the
>> database does not perform any extra work to maintain the index.
>>
>> Thank you
>>
>> Frank
>> _attend WWRUG10 www.wwrug.com ARSlist: "Where the
>> Answers Are"_
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at
> www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the
> Answers Are"
>
> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>

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

Re: Weird SQL issue - column missing from T table

[Ron Legters]

So, the field missing from the T table was, in fact, a display-only field and 
it was supposed to be. The problem I was having was getting a SQL error after 
saving a request, and the log said the problem was this field wasn't in the 
table.

What was happening is that I had a menu attached to a character field, which 
used as one of its qualifications a value from a field on the CRQ that had the 
same ID as this 'missing' field. This field gets a value when the tab it's on 
gets focus. After submit, the menu couldn't find the value, since the field 
wasn't populated yet, and for some reason tried to query this other table for 
it.

I solved this by creating a second menu that doesn't use this value, and 
attached it to the character field, and then attaching the first menu with a 
change fields action after the qualifier field gets populated.

Thanks,
Ron Legters
ITIL Tools & Process Admin


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
Sent: Tuesday, October 26, 2010 6:57 AM
To: arslist@ARSLIST.ORG
Subject: Re: Weird SQL issue - column missing from T table

If it is reporting an error with the column missing in the DB then somewhere in 
the system it thinks it is a real database field.  I had the same problem a 
while back (also because of copying a field).  The only way to correct it was 
to manually add the column to the table (with an alter table add column 
statement).  I could then delete the field thru the admin tool and recreate it 
again (without doing the copy) to be safe that it was correct everywhere (until 
the column was in the T table I could not even delete the field thru the admin 
tool).

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Ron Legters
Sent: Monday, October 25, 2010 4:34 PM
To: arslist@ARSLIST.ORG
Subject: Re: Weird SQL issue - column missing from T table

** 
Bingo! I would swear this worked on Friday, though. Well, back to the drawing 
board.

Thanks,
Ron Legters
ITIL Tools & Process Admin

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Roger Medsker
Sent: Monday, October 25, 2010 2:26 PM
To: arslist@ARSLIST.ORG
Subject: Re: Weird SQL issue - column missing from T table

** 
Ron,

Check in Admin to see whether this field is "Display Only". If so, it will show 
up in all of the places you mention AND will not be a column in the T1148 table.

Roger Medsker

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Ron Legters
Sent: Monday, October 25, 2010 4:21 PM
To: arslist@ARSLIST.ORG
Subject: Weird SQL issue - column missing from T table

** 
I'm getting an error when I try to save a CRQ - "ARERR [552] Failure during SQL 
operation to the database :  Standard Change". 
Looking at the SQL log, the problem seems to be this: *** ERROR ***  Invalid 
column name 'C100338'

It's doing a 'select' from table T1148, which is CHG:TemplateSPGLookup. Field 
100338 is 'z1D Support Group ID'. When I look in the Admin tool, the field 
is on the form. If I query the db, there is a field 100338 in the 'field' 
table for schema 1148. The column isn't in the table T1148, though.

How do I get it back? I've re-saved the form in the Admin tool with the field 
in place, but it hasn't helped.

If it's any help, I copied this field last Friday from CHG:TemplateSPGLookup to 
a tab on the Change form for some new workflow I'm building. I didn't do 
anything else to it, on the lookup form, though.

MSSQL 2005
ARS 7.1
Windows
ITSM 7.2

Thank you,
Ron Legters 
ITIL Tools & Process Administrator
UNIVAR Business Information Services 
17425 NE Union Hill Road
Redmond, WA 98052  USA
+1 425 889 3952  Work
ron.legt...@univar.com

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

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

Re: IE Script error in SRM / midtier

[Guillaume Rheault]

This kind of errors are usually related to corruption in the IE cache.
Therefore what those users need to do is delete all the temporary files in IE:

1. Click on Internet Options
2. On the General tab,  click on Delete...
3. Click on Delete Files..., then click Close
4. Close all instances of Internet Explorer that are running

After this, the user needs to open a new IE, and log back into Remedy

Guillaume

From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on 
behalf of Vianna Vianna [vianna...@hotmail.com]
Sent: Monday, October 25, 2010 1:44 PM
To: arslist@ARSLIST.ORG
Subject: IE Script error in SRM / midtier

** Hello
Some of our users are receiving a concerning script error when launching the 
Service Request Management portal.

They are getting:

IE Script Error
An error has occurred in the script on this page
Line: 21
Char: 1
Error: Syntax error
Code: 0
URL: http://(our midtier server)/arsys/plugins/ etc... 
and then it shows the AR server name, user's name, and user's password

Do you want to continue running scripts on this page?

If you select yes, then another script error appears  with:
Line: 17
Char:2
Error: 'EventDispatcher' is undefined

and the URL for this second script  is identical to the one above.

Our primary concern is the fact that the user's password is passed in clear 
text.

Anybody else experience something like this?

We're running ARSystem 7.5 (patch 003), SRM 2.2, and IE 7

Thank you

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

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

Re: Indexing Values Rarely Used

[Frank Caruso]

Sounds good Doug.

Thank you for the information.

On Tue, Oct 26, 2010 at 10:18 AM, Mueller, Doug wrote:

> **
> Frank,
>
> The overhead is the same for the index regardless of content.  Why?
> Because NULL is a value (actually the
> lack of a value) and that has to be updated in the index too so that you
> can efficiently search for NULL values
> just like any other value.
>
> So, the cost of the index is really the same.
>
> The answer for you about whether to add it is whether it is important for
> retrieval performance.  From what
> you describe, it is.  Without it, you will get table scans in the use case
> you indicate and if it is a large
> table, that is a challenge.
>
> In general, the overhead for maintaining an index is reasonably small and
> if there is a significant use for that
> index for widespread or even narrow use patterns, it is worth creating.
>
> Doug Mueller
>
>  --
> *From:* Action Request System discussion list(ARSList) [mailto:
> arsl...@arslist.org] *On Behalf Of *Frank Caruso
> *Sent:* Monday, October 25, 2010 8:33 AM
>
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: Indexing Values Rarely Used
>
> ** Because they want to be able to search on that field with no other
> criteria. Its sort of like a pointer to an end user that may or may be
> included in a ticket.
>
>
> Anyhow, I was just hoping that adding the index would not put any extra
> strain on the database because the value would not often be included.
>
>
> On Mon, Oct 25, 2010 at 10:14 AM, Jarl Grøneng wrote:
>
>> Why do you need an index on a column that rarely contains a value?
>>
>> --
>> J
>>
>> 2010/10/22 Frank Caruso :
>> > ** Oracle 10G on Solaris 10
>>  >
>> > If in an index is added to a form against a single column but that
>> column
>> > rarely contains a value, does it have the same impact on the database as
>> a
>> > column that is indexed against a required field?
>> >
>> > My thought is that if there is no value provided for the column then the
>> > database does not perform any extra work to maintain the index.
>> >
>> > Thank you
>> >
>> > Frank
>> > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
>>
>>
>> ___
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>>
>
> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_

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

Re: Indexing Values Rarely Used

[Mueller, Doug]

Frank,

The overhead is the same for the index regardless of content.  Why?  Because 
NULL is a value (actually the
lack of a value) and that has to be updated in the index too so that you can 
efficiently search for NULL values
just like any other value.

So, the cost of the index is really the same.

The answer for you about whether to add it is whether it is important for 
retrieval performance.  From what
you describe, it is.  Without it, you will get table scans in the use case you 
indicate and if it is a large
table, that is a challenge.

In general, the overhead for maintaining an index is reasonably small and if 
there is a significant use for that
index for widespread or even narrow use patterns, it is worth creating.

Doug Mueller


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Frank Caruso
Sent: Monday, October 25, 2010 8:33 AM
To: arslist@ARSLIST.ORG
Subject: Re: Indexing Values Rarely Used

** Because they want to be able to search on that field with no other criteria. 
Its sort of like a pointer to an end user that may or may be included in a 
ticket.

Anyhow, I was just hoping that adding the index would not put any extra strain 
on the database because the value would not often be included.


On Mon, Oct 25, 2010 at 10:14 AM, Jarl Grøneng 
mailto:jarl.gron...@gmail.com>> wrote:
Why do you need an index on a column that rarely contains a value?

--
J

2010/10/22 Frank Caruso mailto:caruso.fr...@gmail.com>>:
> ** Oracle 10G on Solaris 10
>
> If in an index is added to a form against a single column but that column
> rarely contains a value, does it have the same impact on the database as a
> column that is indexed against a required field?
>
> My thought is that if there is no value provided for the column then the
> database does not perform any extra work to maintain the index.
>
> Thank you
>
> Frank
> _attend WWRUG10 www.wwrug.com ARSlist: "Where the 
> Answers Are"_

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

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

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

Re: Indexing Values Rarely Used

[Chris Danaceau]

It would take up additional storage, and add extra processing time when records 
were submitted or the value was modified.  And in the end the index would 
probably not even be used when the db analyzer determined it's low value.
 
-- 
Chris Danaceau
AttivaSoft Solutions Architect



From: Action Request System discussion list(ARSList) on behalf of Frank Caruso
Sent: Mon 10/25/2010 11:33 AM
To: arslist@ARSLIST.ORG
Subject: Re: Indexing Values Rarely Used


** Because they want to be able to search on that field with no other criteria. 
Its sort of like a pointer to an end user that may or may be included in a 
ticket.

Anyhow, I was just hoping that adding the index would not put any extra strain 
on the database because the value would not often be included.



On Mon, Oct 25, 2010 at 10:14 AM, Jarl Grøneng  wrote:


Why do you need an index on a column that rarely contains a value?

--
J

2010/10/22 Frank Caruso :
> ** Oracle 10G on Solaris 10

>
> If in an index is added to a form against a single column but that 
column
> rarely contains a value, does it have the same impact on the database 
as a
> column that is indexed against a required field?
>
> My thought is that if there is no value provided for the column then 
the
> database does not perform any extra work to maintain the index.
>
> Thank you
>
> Frank

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



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
 

attend wwrug11 www.wwrug.com   ARSList: "Where 
the Answers Are"



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

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

Re: Weird SQL issue - column missing from T table

[Grooms, Frederick W]

If it is reporting an error with the column missing in the DB then somewhere in 
the system it thinks it is a real database field.  I had the same problem a 
while back (also because of copying a field).  The only way to correct it was 
to manually add the column to the table (with an alter table add column 
statement).  I could then delete the field thru the admin tool and recreate it 
again (without doing the copy) to be safe that it was correct everywhere (until 
the column was in the T table I could not even delete the field thru the admin 
tool).

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Ron Legters
Sent: Monday, October 25, 2010 4:34 PM
To: arslist@ARSLIST.ORG
Subject: Re: Weird SQL issue - column missing from T table

** 
Bingo! I would swear this worked on Friday, though. Well, back to the drawing 
board.

Thanks,
Ron Legters
ITIL Tools & Process Admin

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Roger Medsker
Sent: Monday, October 25, 2010 2:26 PM
To: arslist@ARSLIST.ORG
Subject: Re: Weird SQL issue - column missing from T table

** 
Ron,

Check in Admin to see whether this field is "Display Only". If so, it will show 
up in all of the places you mention AND will not be a column in the T1148 table.

Roger Medsker

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Ron Legters
Sent: Monday, October 25, 2010 4:21 PM
To: arslist@ARSLIST.ORG
Subject: Weird SQL issue - column missing from T table

** 
I'm getting an error when I try to save a CRQ - "ARERR [552] Failure during SQL 
operation to the database :  Standard Change". 
Looking at the SQL log, the problem seems to be this: *** ERROR ***  Invalid 
column name 'C100338'

It's doing a 'select' from table T1148, which is CHG:TemplateSPGLookup. Field 
100338 is 'z1D Support Group ID'. When I look in the Admin tool, the field 
is on the form. If I query the db, there is a field 100338 in the 'field' 
table for schema 1148. The column isn't in the table T1148, though.

How do I get it back? I've re-saved the form in the Admin tool with the field 
in place, but it hasn't helped.

If it's any help, I copied this field last Friday from CHG:TemplateSPGLookup to 
a tab on the Change form for some new workflow I'm building. I didn't do 
anything else to it, on the lookup form, though.

MSSQL 2005
ARS 7.1
Windows
ITSM 7.2

Thank you,
Ron Legters 
ITIL Tools & Process Administrator
UNIVAR Business Information Services 
17425 NE Union Hill Road
Redmond, WA 98052  USA
+1 425 889 3952  Work
ron.legt...@univar.com

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

Re: Caught ecception error

[Prasanth Prabhakaran (UST, IND)]

Hi ,

 

It may be due to missing permission. Even  we were facing the same issue
couple of weeks before. What we found is the permission is not matching
in people form and user form, we have corrected it and issue got
resolved.

 

 

Thanks and Regards,

 

Prasanth.p | Remedy Team| VOIP:1113 | Mob : +91 999 559 5875

 

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Ramagiri
Sent: Tuesday, October 26, 2010 10:47 AM
To: arslist@ARSLIST.ORG
Subject: Re: Caught ecception error

 

** 

Hi Rajesh ,

 

Thanks for the quick responds . We are using ARS 7.1  with mid tier
patch 008.

 

___

 

Thanks and regards,

Ravi Chandra  Ramagiri   

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Nair, Rajesh SISPL
Sent: Tuesday, October 26, 2010 10:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: Caught ecception error

 

** 

HI

Can you please help out with the version please??

 

Regards

Rajesh 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Ramagiri
Sent: Tuesday, October 26, 2010 10:10 AM
To: arslist@ARSLIST.ORG
Subject: Caught ecception error
Importance: High

 

Hi All , 

 We are experiencing a major issue with mid tier form the client
side . When they are trying to login to remedy using IE or Mozilla ,
some are getting blank screen and some with the error

 " caught exception :Expected'}' "

   Please anybody can help me in resolving the issue.



Thanks and regards,

Ravi Chandra  Ramagiri   

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



Important notice: This e-mail and any attachment there to contains
corporate proprietary information. If you have received it by mistake,
please notify us immediately by reply e-mail and delete this e-mail and
its attachments from your system.
Thank You.

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

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


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

Thanks to all WW RUG participants, those that attended our talks and visited our booth, BMC, and especially the Organizers

[Ben Chernys]

Just wanted to say a big thanks to all participants, an extra thanks to
those that took the time to listen to our talks and visit our booth, thanks
to BMC for providing a wide array of senior people (and providing the
rockets), and finally a big giant thank you for all the hard work done by
all the WW RUG Organisers.

 

It was great to meet you in person and finally attach faces to those years
of emails on the arslist.  

 

It was also great to meet former co-workers Dan and Ed after some 15 years
after we had worked together on ARS release 2.

 

I am also especially enthralled to see the interest and reaction to
Meta-Update and will follow up with those that attended the talks and
requested more information.

 

Cheers

Ben Chernys

Senior Software Architect
Software Tool House Inc.

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

Check out Software Tool House's free Diary Editor.

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

 


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

Re: Getting malloc error on server when running AIS 7.6.03 installation

[Jiri Pospisil]

Tried that, but there seems to always be yet one more form to be deleted by the 
installer.
Was wondering if there was a quicker way around this issue than re-running the 
install over and over again and waiting at which point it is going to fail next.

Jiri

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
Sent: 25 October 2010 15:14
To: arslist@ARSLIST.ORG
Subject: Re: Getting malloc error on server when running AIS 7.6.03 installation

What if you delete the workflow for the form yourself (in small chunks) ahead 
of time?

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Jiri Pospisil
Sent: Sunday, October 24, 2010 7:58 AM
To: arslist@ARSLIST.ORG
Subject: Getting malloc error on server when running AIS 7.6.03 installation

++
Please Read The Disclaimer At The Bottom Of This Email
++

Hi,

I am trying to run Atrium 7.6.03 installation on our test server, but it keeps 
failing with malloc on the server.
After looking at the generated log files, it seems the installer fails when it 
attempts deleting some of the old forms that have lots of workflow associated.
I tried to delete the form using the development studio and got the malloc 
again.
What seems to be happening is that the server keeps issuing delete commands to 
the database for all related workflow, but does not commit until all items are 
deleted. At the same time the size of the arsystem.exe process starts growing 
rapidly and eventually reaches 3GB at which point the server fails, before it 
managed to delete all related items.

Anybody seen this and can suggest a way around this? What worries me is that I 
got similar error when trying to install ITSM 7.6.03.

Environment
Microsoft Server 2003, SP2
MS SQL 2005 database (remote)
Memory on server 8GB (with 3GB switch enabled)
AR System version 7.6.03
AIE version 7.6.0 patch 001 

Thanks

Jiri Pospisil
LCH.Clearnet 



*

This email is intended for the named recipient(s) only. Its contents are 
confidential and may only be retained by the named recipient(s) and may only be 
copied or disclosed with the consent of LCH.Clearnet Limited and/or 
LCH.Clearnet SA.   If you are not an intended recipient please delete this 
e-mail and notify postmas...@lchclearnet.com.
LCH.Clearnet Limited, LCH.Clearnet SA and each other member of the LCH.Clearnet 
Group accept no liability, including liability for negligence, in respect of 
any statement in this email.
The contents of this email are subject to contract in all cases, and 
LCH.Clearnet Limited and/or LCH.Clearnet SA makes no contractual commitment 
save where confirmed by hard copy.  
Cet e-mail et toutes les pièces jointes (ci-après le "message") sont 
confidentiels et établis à l'intention exclusive de ses destinataires. Toute 
utilisation de ce message non conforme à sa destination, toute diffusion ou 
toute publication, est interdite, sauf autorisation expresse de LCH.Clearnet 
Limited et/ou LCH.Clearnet SA. Si ce message vous a été adressé par erreur, 
merci de le détruire et d'en avertir immédiatement postmas...@lchclearnet.com.
LCH.Clearnet Limited, LCH.Clearnet SA et les autres entités du groupe 
LCH.Clearnet Group, ne peuvent en aucun cas être tenues responsables au titre 
de ce message à moins qu’il n’ait fait l’objet d’un contrat signé.
LCH.Clearnet Limited, Registered Office: Aldgate House, 33 Aldgate High Street, 
London EC3N 1EA.Recognised as a Clearing House under the Financial Services 
& Markets Act 2000. Reg in England No.25932 
Telephone: +44 20 7426 7000  Internet: http://www.lchclearnet.com
LCH.Clearnet SA, Siège Social, 18 rue du Quatre Septembre, 75002 Paris, Chambre 
de Compensation conformément au Code Monétaire et Financier.

*