Ah ... I'm on Linux for the App and Web.

In your SOAP AuthenticationInfo are you specifying a timeZone or locale?


-----Original Message-----
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa
Sent: Tuesday, April 24, 2012 2:29 PM
To: arslist@ARSLIST.ORG
Subject: Re: Webservices and Queries

Windows XP for the desktop, Windows server 2008 for the app server, Oracle 11g 
for the backend. 


Thanks!

Lisa 


-----Original Message-----
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Tuesday, April 24, 2012 3:28 PM
To: arslist@ARSLIST.ORG
Subject: Re: Webservices and Queries

What platform are you on (as WS does do the DST for me)? 

Fred

-----Original Message-----
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa
Sent: Tuesday, April 24, 2012 2:26 PM
To: arslist@ARSLIST.ORG
Subject: Re: Webservices and Queries

I think that's the problem.  WUT and Midtier does the translation for DST while 
the webservices do not.  Ugh....   That's exactly what we are seeing and now 
the results make more sense.


Thanks!

Lisa 


-----Original Message-----
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza
Sent: Tuesday, April 24, 2012 2:16 PM
To: arslist@ARSLIST.ORG
Subject: Re: Webservices and Queries

Like Fred and Andrew suggested, check your permissions and / or the login used..

I wont be surprised though if there is a difference in the way the WS handles 
daylight saving time, thus one set of results is slightly different from the 
other because of the slight difference in an internal translation of the time 
input as one of the search parameters..

Look at your pliugin logs to look at the xml request that is sent from the 
client..

Joe

-----Original Message-----
From: Kemes, Lisa
Sent: Tuesday, April 24, 2012 2:07 PM Newsgroups: 
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Webservices and Queries

This worked!  Thanks!

NOW, back to the original problem I was trying to research.  When I run this 
query off of the webservices, I get 38 records back, but on WUT or Midtier, I 
get 37 records back.  (just like my customer said)

Is there any reason why the same query would bring back different results off 
of the Webservice vs. the WUT or Midtier?


Thanks!

Lisa


-----Original Message-----
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Tuesday, April 24, 2012 1:50 PM
To: arslist@ARSLIST.ORG
Subject: Re: Webservices and Queries

Try encoding the <
   <urn:Qualification> 'Change Status' &lt;= "NOT COMPLETED" 
</urn:Qualification>


-----Original Message-----
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa
Sent: Tuesday, April 24, 2012 9:56 AM
To: arslist@ARSLIST.ORG
Subject: Re: Webservices and Queries

Thanks Fred,

I tried your suggestion and I'm still getting this error.

I even tried:  <urn:Qualification> 'Change Status' <= "NOT COMPLETED" 
</urn:Qualification> and I get the error.  When I change the <= to >= it's fine.

I think it has something to do with the < symbol.  It's like it has to be 
matched with an opposite >.  This is in SOAP.  The whole reason why I'm testing 
this is because my customer is getting back different data than I am in the 
WUT, so I thought I would test his query in SOAP to see what records would come 
back, but I can't even test it if SOAP doesn't like the < symbol....


Thanks!

Lisa


-----Original Message-----
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Tuesday, April 24, 2012 10:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: Webservices and Queries

If the field is a Date/Time field I would think that the web service would 
expect it to be in a valid XML Date/Time format.
The XML Date/Time format is  YYYY-MM-DDThh:mm:ss.0000-05:00
   (http://www.w3schools.com/schema/schema_dtypes_date.asp)

With a web service try
   'Start Date and Time' <= "2012-04-23T15:30:00"  AND  'Change Status' = 
"CANCELED"


Fred

-----Original Message-----
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa
Sent: Tuesday, April 24, 2012 8:25 AM
To: arslist@ARSLIST.ORG
Subject: Webservices and Queries

**
We just upgraded to 7.6.04 SP2 (ARS) and when I run a query in the WUT or 
MidTier of:  'Start Date and Time' >= "4/23/2012 03:30:00 PM"  AND  'Change 
Status' = "CANCELED"  I get records back just fine.

When I use SOAP to run this query in our Webservice, everything is fine.

But when I try 'Start Date and Time' <= "4/23/2012 03:30:00 PM"  AND 
'Change Status' = "CANCELED", WUT and Midtier is fine, but I'm getting this 
error in SOAP:

"org.xml.sax.SAXParseException: The content of elements must consist of 
well-formed character data or markup"

Does anyone know why this would error out?

Lisa Kemes
AR System Developer
TEIS - USA
+1 717 810 2408 tel
+1 717 602 9460 mobile
lisa.ke...@te.com
100 Amp Drive
Harrisburg, PA 17112
www.te.com 

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Reply via email to