on our Solaris server with tomcat and webservices here is the date/time strings We are on Central Daylight Savings time. Following is a date from a year ago:
April 4th, 2011 15:27:46 <ns0:Create_Date>2011-04-27T15:27:46-05:00</ns0:Create_Date> > -----Original Message----- > From: lisa.ke...@te.com > Sent: Wed, 25 Apr 2012 11:31:05 -0400 > To: arslist@arslist.org > Subject: Re: Webservices and Queries > > I added "GMT-5:00 (EST) America/New_York" to the timeZone and it's still > coming back with invalid data. ARRGH! Does anyone else experiencing > this? > > > > > 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 4:51 PM > To: arslist@ARSLIST.ORG > Subject: Re: Webservices and Queries > > In the AuthenticationInfo structure for ARS webservices there are 5 > elements. User and Password are required. The other 3 (authentication, > locale, and timeZone) are not required. > > Fred > > -----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 3:41 PM > To: arslist@ARSLIST.ORG > Subject: Re: Webservices and Queries > > I am fairly new to consuming web services too, and am at the moment > working on OIM web service integration as well.. > > Isn't there a locale input that the WS requires? I would think that's > where it will pick it from.. > > Joe > > -----Original Message----- > From: Kemes, Lisa > Sent: Tuesday, April 24, 2012 3:55 PM Newsgroups: > public.remedy.arsystem.general > To: arslist@ARSLIST.ORG > Subject: Re: Webservices and Queries > > Would the timezone names be the same ones on the Local Tab of the AR > System User Preference form? > > > 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 3:42 PM > To: arslist@ARSLIST.ORG > Subject: Re: Webservices and Queries > > That could probably be it :-) > > -----Original Message----- > From: Kemes, Lisa > Sent: Tuesday, April 24, 2012 3:41 PM Newsgroups: > public.remedy.arsystem.general > To: arslist@ARSLIST.ORG > Subject: Re: Webservices and Queries > > Looks like we are not specifying anything in Local or Timezone. I'll add > some data to that and see if it works! > > > 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:34 PM > To: arslist@ARSLIST.ORG > Subject: Re: Webservices and Queries > > 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' <= "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" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" ____________________________________________________________ FREE 3D EARTH SCREENSAVER - Watch the Earth right on your desktop! Check it out at http://www.inbox.com/earth _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"