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"