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 [email protected] 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:[email protected]] On Behalf Of vikram_k Sent: Wednesday, March 09, 2011 12:09 AM To: [email protected] 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 | [email protected] > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of vikram_k > Sent: Tuesday, March 08, 2011 1:03 AM > To: [email protected] > 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 >> [email protected] >> www.hp.com<http://www.hp.com/> >> [cid:[email protected]] >> >> 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:[email protected]] On Behalf Of Roger Justice >> Sent: Monday, March 07, 2011 4:09 PM >> To: [email protected] >> 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) <[email protected]> >> To: arslist <[email protected]> >> 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 >> >> [email protected]<mailto:[email protected]> >> >> 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"
