ARS 8.x and User Tool
Hi, Will the User Tool continue to work with 8.X? thanks, Tony ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: ARS 8.x and User Tool
thanks Laurent and others! | | From: | | --| |laurent matheo lm...@me.com | --| | | To:| | --| |arslist@arslist.org, | --| | | Date: | | --| |03/01/2013 12:10 PM | --| | | Subject: | | --| |Re: ARS 8.x and User Tool | --| | | Sent by: | | --| |Action Request System discussion list(ARSList) arslist@arslist.org | --| ** Hi :) There is no user tool anymore bundled in 8.x, but you can use the one from 7.6.04… Though it would be better to get used to mid-tier only Le 1 mars 2013 à 18:03, Anthony Jurado Jr ajur...@us.ibm.com a écrit : ** Hi, Will the User Tool continue to work with 8.X? thanks, Tony _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years inline: graycol.gifinline: ecblank.gif
Re: UTC Time
Hi, All of our servers are configured to use UTC. We've never seen any issues related to doing so. Regards, Tony | | From: | | --| |Paul Blasquez pblasq...@gmail.com | --| | | To:| | --| |arslist@arslist.org, | --| | | Date: | | --| |01/23/2013 11:20 PM | --| | | Subject: | | --| |UTC Time | --| | | Sent by: | | --| |Action Request System discussion list(ARSList) arslist@arslist.org | --| ** Hello All, I was wondering if anyone out there has set up their servers and clients to all use only UTC time (i.e. GMT time without switching to BST for DST)? We run a custom shop with global functions so we need a flat timezone. We'd like to standardize to GMT+0 Europe/London but we are worried that the clients will automatically transition to BST if we set their preference to GMT, as there is no DST on/off toggle. Any experience in this matter is appreciated! Thanks, Paul Blasquez _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years inline: graycol.gifinline: ecblank.gif
Re: ARS, Atrium, ITSM, etc. 7.6.04 and patches 003 and 004...
Hi, We upgraded our dev server and midtier to 7.6.04 several weeks ago. Since then, pages displayed in the MT do not show some standard gif images- e.g., the arrow for pull-down menus, the elipses for text area, etc. BMC support offered the solution of dropping and and re-adding the components. (We're not real excited by that prospect.) We haven't really had time to play with debugging it on our own yet, as the team is wrapping up a critical project due at the end on Jan. Regards, Tony From: Joe D'Souza jdso...@shyle.net To: arslist@arslist.org, Date: 01/07/2013 10:05 PM Subject:ARS, Atrium, ITSM, etc. 7.6.04 and patches 003 and 004... Sent by:Action Request System discussion list(ARSList) arslist@arslist.org ** Question 1 Although the versions and patch releases in the past had barely been chronologically consistent, BMC has managed to do a fair job of keeping this fairly consistent over the past few releases, both major and maintenance. However I do not see a patch 003 for the ITSM application. I see one for the AR Server, Approval, Atrium, RKM and almost all other complimentary tools with the exception of the ITSM suite. Was patch 003 never released for the ITSM suite?? Was it released and then recalled? Question 2 Is patch 004 for 7.6.04 released for the whole suite? Are there any major problems anyone had with it? Joe _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years inline: graycol.gifinline: ecblank.gif
Re: ARS, Atrium, ITSM, etc. 7.6.04 and patches 003 and 004...
quote from ticket - bring up the form in Dev. Studio, remove these menu fields (one at a time) and re-add them and save the form. Then flush MT cache and retest see if that corrects the problem Regards, Tony From: Joe D'Souza jdso...@shyle.net To: arslist@arslist.org, Date: 01/08/2013 02:11 PM Subject:Re: ARS, Atrium, ITSM, etc. 7.6.04 and patches 003 and 004... Sent by:Action Request System discussion list(ARSList) arslist@arslist.org ** What specifically did they (BMC Support) mean by dropping and re-adding components? Recreating the objects that had those missing or improper gifs? Joe From: Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG] On Behalf Of Anthony Jurado Jr Sent: Tuesday, January 08, 2013 12:10 PM To: arslist@ARSLIST.ORG Subject: Re: ARS, Atrium, ITSM, etc. 7.6.04 and patches 003 and 004... Hi, We upgraded our dev server and midtier to 7.6.04 several weeks ago. Since then, pages displayed in the MT do not show some standard gif images- e.g., the arrow for pull-down menus, the elipses for text area, etc. BMC support offered the solution of dropping and and re-adding the components. (We're not real excited by that prospect.) We haven't really had time to play with debugging it on our own yet, as the team is wrapping up a critical project due at the end on Jan. Regards, Tony Inactive hide details for Joe D'Souza ---01/07/2013 10:05:47 PM---Question 1 Although the versions and patch releases in the Joe D'Souza ---01/07/2013 10:05:47 PM---Question 1 Although the versions and patch releases in the past had barely been From: Joe D'Souza jdso...@shyle.net To:arslist@arslist.org, Date: 01/07/2013 10:05 PM Subject: ARS, Atrium, ITSM, etc. 7.6.04 and patches 003 and 004... Sent by: Action Request System discussion list(ARSList) arslist@arslist.org ** Question 1 Although the versions and patch releases in the past had barely been chronologically consistent, BMC has managed to do a fair job of keeping this fairly consistent over the past few releases, both major and maintenance. However I do not see a patch 003 for the ITSM application. I see one for the AR Server, Approval, Atrium, RKM and almost all other complimentary tools with the exception of the ITSM suite. Was patch 003 never released for the ITSM suite?? Was it released and then recalled? Question 2 Is patch 004 for 7.6.04 released for the whole suite? Are there any major problems anyone had with it? Joe _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20
Re: ARS, Atrium, ITSM, etc. 7.6.04 and patches 003 and 004...
correct- flushing cache did not help. Regards, Tony From: Rick Cook remedyr...@gmail.com To: arslist@arslist.org, Date: 01/08/2013 02:25 PM Subject:Re: ARS, Atrium, ITSM, etc. 7.6.04 and patches 003 and 004... Sent by:Action Request System discussion list(ARSList) arslist@arslist.org ** 0.o Never seen that suggestion before. I assume that flushing the MT cache and such has been tried and didn't work? Rick On Tue, Jan 8, 2013 at 11:15 AM, Anthony Jurado Jr ajur...@us.ibm.com wrote: ** quote from ticket - bring up the form in Dev. Studio, remove these menu fields (one at a time) and re-add them and save the form. Then flush MT cache and retest see if that corrects the problem Regards, Tony Joe D'Souza ---01/08/2013 02:11:12 PM--- What specifically did they (BMC Support) mean by dropping and re-adding From:Joe D'Souza jdso...@shyle.net To: arslist@arslist.org, Date:01/08/2013 02:11 PM Subject: Re: ARS, Atrium, ITSM, etc. 7.6.04 and patches 003 and 004... Sent by: Action Request System discussion list(ARSList) arslist@arslist.org ** What specifically did they (BMC Support) mean by dropping and re-adding components? Recreating the objects that had those missing or improper gifs? Joe From: Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG] On Behalf Of Anthony Jurado Jr Sent: Tuesday, January 08, 2013 12:10 PM To: arslist@ARSLIST.ORG Subject: Re: ARS, Atrium, ITSM, etc. 7.6.04 and patches 003 and 004... Hi, We upgraded our dev server and midtier to 7.6.04 several weeks ago. Since then, pages displayed in the MT do not show some standard gif images- e.g., the arrow for pull-down menus, the elipses for text area, etc. BMC support offered the solution of dropping and and re-adding the components. (We're not real excited by that prospect.) We haven't really had time to play with debugging it on our own yet, as the team is wrapping up a critical project due at the end on Jan. Regards, Tony Joe D'Souza ---01/07/2013 10:05:47 PM---Question 1 Although the versions and patch releases in the past had barely been From:Joe D'Souza jdso...@shyle.net To: arslist@arslist.org
Re: ARS, Atrium, ITSM, etc. 7.6.04 and patches 003 and 004...
Thanks Joe. I appreciate the tips! Regards, Tony From: Joe D'Souza jdso...@shyle.net To: arslist@arslist.org, Date: 01/08/2013 02:31 PM Subject:Re: ARS, Atrium, ITSM, etc. 7.6.04 and patches 003 and 004... Sent by:Action Request System discussion list(ARSList) arslist@arslist.org ** That’s what I thought. I have been doing a variation of that when I saw sporadic problem like that.. the funda behind that ‘fix’ is you change the display property of the affected part – for eg if the edit box doesn’t appear right change the hide show attribute of it, or if the menu does not appear right, detach it and then add it.. I have got better results by saving the form twice, once after making that ‘negative’ change, and then after adding the property back.. Unfortunately for the problem you are having, I have noticed that to be the only solution. Hopefully not too many objects per form are screwed up. Remember to flush the MT cache at both those times.. Joe From: Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG] On Behalf Of Anthony Jurado Jr Sent: Tuesday, January 08, 2013 2:15 PM To: arslist@ARSLIST.ORG Subject: Re: ARS, Atrium, ITSM, etc. 7.6.04 and patches 003 and 004... quote from ticket - bring up the form in Dev. Studio, remove these menu fields (one at a time) and re-add them and save the form. Then flush MT cache and retest see if that corrects the problem Regards, Tony Inactive hide details for Joe D'Souza ---01/08/2013 02:11:12 PM--- What specifically did they (BMC Support) mean by droppingJoe D'Souza ---01/08/2013 02:11:12 PM--- What specifically did they (BMC Support) mean by dropping and re-adding From: Joe D'Souza jdso...@shyle.net To:arslist@arslist.org, Date: 01/08/2013 02:11 PM Subject: Re: ARS, Atrium, ITSM, etc. 7.6.04 and patches 003 and 004... Sent by: Action Request System discussion list(ARSList) arslist@arslist.org ** What specifically did they (BMC Support) mean by dropping and re-adding components? Recreating the objects that had those missing or improper gifs? Joe From: Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG] On Behalf Of Anthony Jurado Jr Sent: Tuesday, January 08, 2013 12:10 PM To: arslist@ARSLIST.ORG Subject: Re: ARS, Atrium, ITSM, etc. 7.6.04 and patches 003 and 004... Hi, We upgraded our dev server and midtier to 7.6.04 several weeks ago. Since then, pages displayed in the MT do
Re: ARS, Atrium, ITSM, etc. 7.6.04 and patches 003 and 004...
Hi Fred. I have not tried that. I'll give it a try later this week. thanks, Tony From: Grooms, Frederick W frederick.w.gro...@xo.com To: arslist@arslist.org, Date: 01/08/2013 02:43 PM Subject:Re: ARS, Atrium, ITSM, etc. 7.6.04 and patches 003 and 004... Sent by:Action Request System discussion list(ARSList) arslist@arslist.org Joe, Tony, If there are a lot of fields on the form with messed up images, have you tried exporting to a .def and then re-importing the form on top of itself? Fred -Original Message- From: Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza Sent: Tuesday, January 08, 2013 1:36 PM To: arslist@ARSLIST.ORG Subject: Re: ARS, Atrium, ITSM, etc. 7.6.04 and patches 003 and 004... ** Nope it doesn't help. I had similar issues in the past, where for some reason the display at the mid tier is not right. I have had half the labels of a field visible, sometimes the data area of the field shorter or way longer than it actually appears on the dev studio, sometimes the edit box not visible when it should be or visible when it shouldn't.. And I've never found a pattern on when to expect these problems. -Original Message- From: Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook Sent: Tuesday, January 08, 2013 2:24 PM To: arslist@ARSLIST.ORG Subject: Re: ARS, Atrium, ITSM, etc. 7.6.04 and patches 003 and 004... ** 0.o Never seen that suggestion before. I assume that flushing the MT cache and such has been tried and didn't work? Rick -Original Message- From: Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG] On Behalf Of Anthony Jurado Jr Sent: Tuesday, January 08, 2013 1:15 PM To: arslist@ARSLIST.ORG Subject: Re: ARS, Atrium, ITSM, etc. 7.6.04 and patches 003 and 004... ** quote from ticket - bring up the form in Dev. Studio, remove these menu fields (one at a time) and re-add them and save the form. Then flush MT cache and retest see if that corrects the problem Regards, Tony -Original Message- From: Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza Sent: Tuesday, January 08, 2013 1:11 PM To: arslist@ARSLIST.ORG Subject: Re: ARS, Atrium, ITSM, etc. 7.6.04 and patches 003 and 004... ** What specifically did they (BMC Support) mean by dropping and re-adding components? Recreating the objects that had those missing or improper gifs? Joe -Original Message- From: Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG] On Behalf Of Anthony Jurado Jr Sent: Tuesday, January 08, 2013 12:10 PM To: arslist@ARSLIST.ORG Subject: Re: ARS, Atrium, ITSM, etc. 7.6.04 and patches 003 and 004... Hi, We upgraded our dev server and midtier to 7.6.04 several weeks ago. Since then, pages displayed in the MT do not show some standard gif images- e.g., the arrow for pull-down menus, the elipses for text area, etc. BMC support offered the solution of dropping and and re-adding the components. (We're not real excited by that prospect.) We haven't really had time to play with debugging it on our own yet, as the team is wrapping up a critical project due at the end on Jan. Regards, Tony ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been
dev studio for linux?
Hi Folks, I just switched my workstation from Windows to Linux. I don't see a download offering for Developer Studio for Linux. Am I missing something? Note that the platform listed at the product name is Linux, but the platform listed for AR System Clients ... is Windows. Is there anyone out there running Dev Studio on Linux? Many thanks in advance, Tony Jurado Release Manager, Services Engineering IBM Security Services ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Areinline: 39673374.gif
Re: Desktop operating system de-evolution by mobile device OS
Hi, Windows actually has a setting that allows you to switch between the 2 keyboard types. Here is an informative link on the topic: http://www.dvzine.org/zine/index.html Regards, Tony | | From: | | ---| |Joe Martin D'Souza jdso...@shyle.net | ---| | | To:| | ---| |arslist@arslist.org | ---| | | Date: | | ---| |04/02/2012 11:01 PM | ---| | | Subject: | | ---| |Re: Desktop operating system de-evolution by mobile device OS | ---| | | Sent by: | | ---| |Action Request System discussion list(ARSList) arslist@arslist.org | ---| ** That does sound like a fair reasoning.. Is it easy to switch back and forth? Meaning when lets say at a public terminal at a hotel and on a QWERTY, can you still type with ease? Joe From: LJ LongWing Sent: Monday, April 02, 2012 5:49 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Desktop operating system de-evolution by mobile device OS ** Joe, I had a friend at a job a number of years ago that was suffering from horrible carpel tunnel syndrome and switched to Dvorak and his symptoms went away entirely. I decided that because I was relatively young at the time, and planning on typing for a vast majority of my career…it might be better to head this one off before I had a syndrome that is proven to be very common in people that type on a regular basis…so I switched….all in all it took about 3 months of very frustrating times to switch from touch Qwerty to touch Dvorak. I find that I do type a bit faster…I was averaging about 60wpm before, and average somewhere around 80wpm now…and regarding the alternate picking….how many words have regular consecutive vowels? Not many…so even though in this configuration, your left hand on ‘home row’ is used regularly, it’s your home row, so it doesn’t take as much travel with your fingers as traditional Qwerty….and the layout is designed to reduce overall movement on the most common words, thus faster typing and less repetitive motion syndrome J I’m by no means recommending anyone ‘make the switch’, but it’s working for me and over a decade later the only problem I have is hunting and pecking on all computers other than mine (except those I have the layout installed on that I use regularly)….I still type on the same Qwerty keyboard that you find at your local computer store….but being I touch type, the labels on the keys don’t mess with my mind J From: Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, April 02, 2012 10:05 AM To: arslist@ARSLIST.ORG Subject: Re: Desktop operating system de-evolution by mobile device OS ** Interesting.. I never met anyone who uses that keyboard. How do you find its use? Does it actually make it easier to type faster than QWERTY if you are already used to QWERTY? One thing I do not understand about that keyboard is how can it be faster when the all the vowels are found on one side. All
Re: invalid relational operator exception from QualifierInfo
Hi,
I was originally using the 7.5 version of the API. I just tried with 7.6.4
and got the same result.
Unfortunately, I don't know how to turn it into an internal representation.
thanks,
Tony
|
| From: |
|
---|
|LJ LongWing lj.longw...@gmail.com
|
---|
|
| To:|
|
---|
|arslist@arslist.org
|
---|
|
| Date: |
|
---|
|03/19/2012 10:11 AM
|
---|
|
| Subject: |
|
---|
|Re: invalid relational operator exception from QualifierInfo
|
---|
|
| Sent by: |
|
---|
|Action Request System discussion list(ARSList) arslist@arslist.org
|
---|
Sothat begs the question then...what version of the API are you using?
Have you tried the latest 7.6.4 SP3? Can you try to use turn it into an
internal representation...and then back out to see if it goes there and
back
and comes out the same way it went in?
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Anthony Jurado Jr
Sent: Friday, March 16, 2012 5:49 PM
To: arslist@ARSLIST.ORG
Subject: Re: invalid relational operator exception from QualifierInfo
Hi,
Thanks to LJ and Jose for the replies! As suggested I looked at the logs.
The output seems to support the idea that there is a bug in
parseQualification:
When called on a field that works as expected ('Summary' in the example
below) the result is:
SELECT T852.C1,C536870989 FROM T852 WHERE (T852.C8 = 'atl01a')
ORDER
BY C536870944 DESC, 1 ASC
When called on a field that causes an exception ('Associated Asset' in the
example below) the result is:
SELECT T852.C1,C536870989 FROM T852 WHERE (T852.C536870989
ORDER BY
C536870944 DESC, 1 ASC
When called using LIKE instead of = on the 'Associated Asset' the result
is:
SELECT T852.C1,C536870989 FROM T852 WHERE (dbms_lob.instr
(T852.C536870989, 'atl01a') 0) ORDER BY C536870944 DESC, 1 ASC
Unfortunately, while this runs without an error, it does return any
results.
Maybe I'm missing something, but it seems to me that parseQualification is
not generating a working sql statement in the example that causes an
exception. Note that there is no comparison operator or RHS value between
T852.C536870989 and ORDER BY.
Further, the sql statement that is generated when LIKE is used doesn't
result in the correct results.
thanks again,
Tony
-Original Message-
Date:Thu, 15 Mar 2012 09:34:09 -0600
From:LJ LongWing lj.longw...@gmail.com
Subject: Re: invalid relational operator exception from QualifierInfo
Tony,
I have tried doing searches (via the user tool) on 0 length fields and
received errors (I believe it stores them in clob in the db)...but I'm on
SQL, and my error was different...but I suspect that the problem is a DB
problem, not a Remedy problemcan you issue the same query in the user
tool...and then maybe get an sql log of the request and try it directly at
the DB?...I fully suspect you will find that it's a db problem and not an
api
Re: invalid relational operator exception from QualifierInfo
Hi,
Thanks to LJ and Jose for the replies! As suggested I looked at the logs.
The output seems to support the idea that there is a bug in
parseQualification:
When called on a field that works as expected ('Summary' in the example
below) the result is:
SELECT T852.C1,C536870989 FROM T852 WHERE (T852.C8 = 'atl01a') ORDER
BY C536870944 DESC, 1 ASC
When called on a field that causes an exception ('Associated Asset' in the
example below) the result is:
SELECT T852.C1,C536870989 FROM T852 WHERE (T852.C536870989 ORDER BY
C536870944 DESC, 1 ASC
When called using LIKE instead of = on the 'Associated Asset' the result
is:
SELECT T852.C1,C536870989 FROM T852 WHERE (dbms_lob.instr
(T852.C536870989, 'atl01a') 0) ORDER BY C536870944 DESC, 1 ASC
Unfortunately, while this runs without an error, it does return any
results.
Maybe I'm missing something, but it seems to me that parseQualification is
not generating a working sql statement in the example that causes an
exception. Note that there is no comparison operator or RHS value between
T852.C536870989 and ORDER BY.
Further, the sql statement that is generated when LIKE is used doesn't
result in the correct results.
thanks again,
Tony
-Original Message-
Date:Thu, 15 Mar 2012 09:34:09 -0600
From:LJ LongWing lj.longw...@gmail.com
Subject: Re: invalid relational operator exception from QualifierInfo
Tony,
I have tried doing searches (via the user tool) on 0 length fields and
received errors (I believe it stores them in clob in the db)...but I'm on
SQL, and my error was different...but I suspect that the problem is a DB
problem, not a Remedy problemcan you issue the same query in the user
tool...and then maybe get an sql log of the request and try it directly at
the DB?...I fully suspect you will find that it's a db problem and not an
api issue.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Anthony Jurado Jr
Sent: Wednesday, March 14, 2012 2:13 PM
To: arslist@ARSLIST.ORG
Subject: invalid relational operator exception from QualifierInfo
Hi,
I have a Java program which uses getListEntry(). I use a QualifierInfo
object to create the qualification for getListEntry. The qualification
looks like this:
QualifierInfo qualifier = remedyConn.parseQualification(arForm,
'Associated Asset' = \atl01a\);
Which results in this exception:
CreateRemedyTicket.getSchema ARExceptionERROR (552): Failure
during SQL operation to the database; ORA-00920: invalid relational
operator
ERROR (552): Failure during SQL operation to the database;
ORA-00920: invalid relational operator
at com.bmc.arsys.api.ProxyJRpcBase.verifyStatus
(UnknownSource)
at com.bmc.arsys.api.ProxyJRpcBase.a(Unknown Source)
at com.bmc.arsys.api.ProxyJRpcBase.arCall(Unknown
Source)
at com.bmc.arsys.api.ProxyJRpc.ARGetListEntry
(UnknownSource)
at com.bmc.arsys.api.ARServerUser.getListEntry
(UnknownSource)
at CreateRemedyTicket.init(CreateRemedyTicket.java:42)
at CreateRemedyTicket.main(CreateRemedyTicket.java:94)
Oddly, if I change the equal sign to LIKE the query works:
QualifierInfo qualifier = remedyConn.parseQualification
(arForm,'Associated Asset' LIKE \atl01a\); // works
I have other qualifiers for different fields on the same form in which use
the equal sign with no problem. E.g.:
QualifierInfo qualifier = remedyConn.parseQualification
(arForm,'Summary' = \System Down\); // works
The properties for the Summary and Associated Asset are the same with the
following two exceptions:
Entry Mode is Required for the Summary field (which works as expected) and
optional for the Associated Asset (which doesn't work).
Input Length is 254 for the Summary field and 0 for the Associated Asset
field.
I would appreciate any suggestions!
thanks in advance,
Tony Jurado
Release Manager,
Services Engineering
IBM Security Services
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
invalid relational operator exception from QualifierInfo
Hi, I have a Java program which uses getListEntry(). I use a QualifierInfo object to create the qualification for getListEntry. The qualification looks like this: QualifierInfo qualifier = remedyConn.parseQualification(arForm, 'Associated Asset' = \atl01a\); Which results in this exception: CreateRemedyTicket.getSchema ARExceptionERROR (552): Failure during SQL operation to the database; ORA-00920: invalid relational operator ERROR (552): Failure during SQL operation to the database; ORA-00920: invalid relational operator at com.bmc.arsys.api.ProxyJRpcBase.verifyStatus(Unknown Source) at com.bmc.arsys.api.ProxyJRpcBase.a(Unknown Source) at com.bmc.arsys.api.ProxyJRpcBase.arCall(Unknown Source) at com.bmc.arsys.api.ProxyJRpc.ARGetListEntry(Unknown Source) at com.bmc.arsys.api.ARServerUser.getListEntry(Unknown Source) at CreateRemedyTicket.init(CreateRemedyTicket.java:42) at CreateRemedyTicket.main(CreateRemedyTicket.java:94) Oddly, if I change the equal sign to LIKE the query works: QualifierInfo qualifier = remedyConn.parseQualification(arForm, 'Associated Asset' LIKE \atl01a\); // works I have other qualifiers for different fields on the same form in which use the equal sign with no problem. E.g.: QualifierInfo qualifier = remedyConn.parseQualification(arForm, 'Summary' = \System Down\); // works The properties for the Summary and Associated Asset are the same with the following two exceptions: Entry Mode is Required for the Summary field (which works as expected) and optional for the Associated Asset (which doesn't work). Input Length is 254 for the Summary field and 0 for the Associated Asset field. I would appreciate any suggestions! thanks in advance, Tony Jurado Release Manager, Services Engineering IBM Security Services ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
