It turns out this was a known issue that will be corrected as part of 7.6.04 SP1 (which has not been released yet). It was part of Defect SW00389256.
Christopher Pruitt Business Consulting III HP Enterprises Services christopher.pru...@hp.com www.hp.com Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of vikram_k Sent: Wednesday, March 09, 2011 12:09 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Developers Studio - Error hi, Yes sure you do.. Also it will be nice to check whats changed in the GLSQL call from previous version to this version to understand better :) Thanks, Vikram Pruitt, Christopher (Bank of America Account) wrote: > > Interesting. I ran the SQL and API logs and this is what is showed. Looks > like I need to open an issue with BMC. > > <API > <TID: 0000000004> <RPC ID: 0000005776> <Queue: Admin > > <Client-RPC: 390600 > <USER: Dev1 > > /* Tue Mar 08 2011 08:04:36.9353 */+GSQL ARGetListSQL -- select > fil.filterId, fil.name from filter fil where fil.timestamp > 0 > _##EXTRA_WHERE_CLAUSE_## from Client Type 36 (protocol 13) at IP address > <REMOVED> > <SQL > <TID: 0000000004> <RPC ID: 0000005776> <Queue: Admin > > <Client-RPC: 390600 > <USER: Dev1 > > /* Tue Mar 08 2011 08:04:36.9359 */select fil.filterId, fil.name from > filter fil where fil.timestamp > 0 _##EXTRA_WHERE_CLAUSE_## > <SQL > <TID: 0000000004> <RPC ID: 0000005776> <Queue: Admin > > <Client-RPC: 390600 > <USER: Dev1 > > /* Tue Mar 08 2011 08:04:36.9382 */*** ERROR *** ORA-00911: invalid > character > <API > <TID: 0000000004> <RPC ID: 0000005776> <Queue: Admin > > <Client-RPC: 390600 > <USER: Dev1 > > /* Tue Mar 08 2011 08:04:36.9384 */-GSQL FAIL > > > > Christopher Pruitt > HP Enterprise Services > Bank of America Account | CIA - Integrated Applications | IW > Infrastructure Team > +1.972.605.7702 office | christopher.pru...@hp.com > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of vikram_k > Sent: Tuesday, March 08, 2011 1:03 AM > To: arslist@ARSLIST.ORG > Subject: Re: Remedy Developers Studio - Error > > hi, > > Can you extract the corresponding API and SQL logs with this error > message > that can tell a lot of things. > > Thanks, > Vikram > > Pruitt, Christopher (Bank of America Account) wrote: >> >> This is a brand new install I ran this morning. >> >> Christopher Pruitt >> Business Consulting III >> HP Enterprises Services >> christopher.pru...@hp.com >> www.hp.com<http://www.hp.com/> >> [cid:image003.png@01CBDCE2.1F899120] >> >> Confidentiality Notice: This message and any files transmitted with it >> are >> intended for the sole use of the entity or individual to whom it is >> addressed, and may contain information that is confidential, privileged, >> and exempt from disclosure under applicable law. If you are not the >> intended addressee for this e-mail, you are hereby notified that any >> copying, distribution, or dissemination of this e-mail is strictly >> prohibited. If you have received this e-mail in error, please immediately >> destroy, erase, or discard this message. Please notify the sender >> immediately by return e-mail if you have received this e-mail by mistake. >> >> From: Action Request System discussion list(ARSList) >> [mailto:arslist@ARSLIST.ORG] On Behalf Of Roger Justice >> Sent: Monday, March 07, 2011 4:09 PM >> To: arslist@ARSLIST.ORG >> Subject: Re: Remedy Developers Studio - Error >> >> ** Have you tried a new install of RDS? >> >> -----Original Message----- >> From: Pruitt, Christopher (Bank of America Account) (Bank of America >> Account) <christopher.pru...@hp.com> >> To: arslist <arslist@ARSLIST.ORG> >> Sent: Mon, Mar 7, 2011 5:05 pm >> Subject: Remedy Developers Studio - Error >> >> Has anyone ever seen this error with the Remedy Developer Studio 7.6.4 >> >> >> >> I select all Objects, select Forms or Active Links and it will bring back >> a list >> >> of objects, however, when I select Filters it gives me the following >> error >> >> >> >> Unable to retrieve Filters lists from <servername>. >> com.bmc.arsys.studio.model.ModelException: >> >> ERROR (552): Failure during SQL operation to the database: ORA-00911: >> invalid >> >> character (ARERR 5087). >> >> >> >> I did not have an issue when using version 7.5 but when I upgraded to >> 7.6.4 this >> >> started to pop up. >> >> >> >> Environment: >> >> Remedy AR Server 7.1 (we are planning an upgrade to 7.6.4 later this >> year) >> >> Oracle 10g >> >> SUN OS 5.9 >> >> Remedy Developer Studio 7.6.4 running on Windows XP SP3. >> >> >> >> >> >> Christopher Pruitt >> >> Business Consulting III >> >> HP Enterprises Services >> >> christopher.pru...@hp.com<mailto:christopher.pru...@hp.com> >> >> www.hp.com<http://www.hp.com/<http://www.hp.com%3chttp/www.hp.com/>> >> >> >> >> >> >> Confidentiality Notice: This message and any files transmitted with it >> are >> >> intended for the sole use of the entity or individual to whom it is >> addressed, >> >> and may contain information that is confidential, privileged, and exempt >> from >> >> disclosure under applicable law. If you are not the intended addressee >> for >> this >> >> e-mail, you are hereby notified that any copying, distribution, or >> dissemination >> >> of this e-mail is strictly prohibited. If you have received this e-mail >> in >> >> error, please immediately destroy, erase, or discard this message. Please >> notify >> >> the sender immediately by return e-mail if you have received this e-mail >> by >> >> mistake. >> >> >> >> >> >> >> >> >> >> _______________________________________________________________________________ >> >> UNSUBSCRIBE or access ARSlist Archives at >> www.arslist.org<http://www.arslist.org/> >> >> attend wwrug11 www.wwrug.com<http://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" >> >> >> > > -- > View this message in context: > http://old.nabble.com/Remedy-Developers-Studio---Error-tp31092225p31094766.html > Sent from the ARS (Action Request System) mailing list archive at > Nabble.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" > > -- View this message in context: http://old.nabble.com/Remedy-Developers-Studio---Error-tp31092225p31103706.html Sent from the ARS (Action Request System) mailing list archive at Nabble.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"
