I would suggest you to turn on the SQL log to see what is sent to the database. The error is an oracle one, so an SQL is sent.
El miércoles 14 de marzo de 2012, Anthony Jurado Jr <[email protected]> escribió: > 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" > -- Jose M. Huerta Project Manager** Movil: 661 665 088 Telf.: 971 75 03 24**** Fax: 971 75 07 94**** <http://www.sm2baleares.es/>**** SM2 Baleares S.A. C/Rita Levi **** Edificio SM2 Parc Bit**** 07121 Palma de Mallorca**** <http://es-es.facebook.com/pages/SM2-Baleares/158608627954> <http://twitter.com/#!/SM2Baleares> <http://www.linkedin.com/company/sm2-baleares> La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato.**** P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
<<image002.jpg>>
<<image001.jpg>>
<<image003.jpg>>
<<image004.jpg>>
