Joe: I have seen this in the past as well.
In order to get around this, I designed the web service a little differently. It may work for you as well, in your situation, but it depends upon the amount of information you are querying and how you want results returned. Rather than publish a Get service, I published a submit service. The concept is that an interface will 'submit' a query request to a custom form, specifying the query criteria in a single field or a series of fields. Through workflow, i search the target form (or series of forms) to produce the answer in a field (or series of fields). This approach gives me the following: - the ability to ensure that query criteria is specified properly. If not, I can specify the error response in a formatted manner. - no need for complex join forms for the source of the get operation. This is a major benefit! - all queries and their response are logged in my form. The detriment to this design is what happens when you expect multiple rows returned, and how do you want to format the results. Hope this approach might work for you in this situation. Terry Joe D'Souza <[email protected]> wrote: >** <!--p.MSONORMAL {mso-style-unhide:no; mso-style-qformat:yes;} >li.MSONORMAL {mso-style-unhide:no; mso-style-qformat:yes;} div.MSONORMAL > {mso-style-unhide:no; mso-style-qformat:yes;} h1 >{mso-style-priority:9; mso-style-unhide:no; mso-style-qformat:yes;} h2 > {mso-style-priority:9; mso-style-unhide:no; mso-style-qformat:yes;} h3 > {mso-style-priority:9; mso-style-unhide:no; mso-style-qformat:yes;} h4 > {mso-style-priority:9; mso-style-unhide:no; mso-style-qformat:yes;} h5 > {mso-style-priority:9; mso-style-unhide:no; mso-style-qformat:yes;} h6 > {mso-style-priority:9; mso-style-unhide:no; mso-style-qformat:yes;} >p.MSOHEADING7 {mso-style-priority:9; mso-style-unhide:no; >mso-style-qformat:yes;} li.MSOHEADING7 {mso-style-priority:9; >mso-style-unhide:no; mso-style-qformat:yes;} div.MSOHEADING7 >{mso-style-priority:9; mso-style-unhide:no; mso-style-qformat:yes;} >p.MSOHEADING8 {mso-style-priority:9; mso-style-unhide:no; >mso-style-qformat:yes;} li.MSOHEADING8 {mso-style-priority:9; >mso-style-unhide:no; mso-style-qformat:yes;} div.MSOHEADING8 >{mso-style-priority:9; mso-style-unhide:no; mso-style-qformat:yes;} >p.MSOHEADING9 {mso-style-priority:9; mso-style-unhide:no; >mso-style-qformat:yes;} li.MSOHEADING9 {mso-style-priority:9; >mso-style-unhide:no; mso-style-qformat:yes;} div.MSOHEADING9 >{mso-style-priority:9; mso-style-unhide:no; mso-style-qformat:yes;} >p.MSOCAPTION {mso-style-priority:35; mso-style-unhide:no; >mso-style-qformat:yes;} li.MSOCAPTION {mso-style-priority:35; >mso-style-unhide:no; mso-style-qformat:yes;} div.MSOCAPTION >{mso-style-priority:35; mso-style-unhide:no; >mso-style-qformat:yes;} p.MSOTITLE {mso-style-priority:10; >mso-style-unhide:no; mso-style-qformat:yes;} li.MSOTITLE >{mso-style-priority:10; mso-style-unhide:no; >mso-style-qformat:yes;} div.MSOTITLE {mso-style-priority:10; >mso-style-unhide:no; mso-style-qformat:yes;} p.MSOTITLECXSPFIRST >{mso-style-priority:10; mso-style-unhide:no; >mso-style-qformat:yes;} li.MSOTITLECXSPFIRST {mso-style-priority:10; > mso-style-unhide:no; mso-style-qformat:yes;} div.MSOTITLECXSPFIRST >{mso-style-priority:10; mso-style-unhide:no; >mso-style-qformat:yes;} p.MSOTITLECXSPMIDDLE {mso-style-priority:10; > mso-style-unhide:no; mso-style-qformat:yes;} li.MSOTITLECXSPMIDDLE >{mso-style-priority:10; mso-style-unhide:no; >mso-style-qformat:yes;} div.MSOTITLECXSPMIDDLE {mso-style-priority:10; > mso-style-unhide:no; mso-style-qformat:yes;} p.MSOTITLECXSPLAST >{mso-style-priority:10; mso-style-unhide:no; >mso-style-qformat:yes;} li.MSOTITLECXSPLAST {mso-style-priority:10; > mso-style-unhide:no; mso-style-qformat:yes;} div.MSOTITLECXSPLAST >{mso-style-priority:10; mso-style-unhide:no; >mso-style-qformat:yes;} p.MSOSUBTITLE {mso-style-priority:11; >mso-style-unhide:no; mso-style-qformat:yes;} li.MSOSUBTITLE >{mso-style-priority:11; mso-style-unhide:no; >mso-style-qformat:yes;} div.MSOSUBTITLE {mso-style-priority:11; > mso-style-unhide:no; mso-style-qformat:yes;} a:link >{mso-style-priority:99;} span.MSOHYPERLINK {mso-style-priority:99;} >a:visited {mso-style-priority:99;} span.MSOHYPERLINKFOLLOWED >{mso-style-priority:99;} p.MSOPLAINTEXT {mso-style-priority:99;} >li.MSOPLAINTEXT {mso-style-priority:99;} div.MSOPLAINTEXT >{mso-style-priority:99;} p.MSOAUTOSIG {mso-style-priority:99;} li.MSOAUTOSIG > {mso-style-priority:99;} div.MSOAUTOSIG {mso-style-priority:99;} >p.MSONOSPACING {mso-style-priority:1; mso-style-unhide:no; >mso-style-qformat:yes;} li.MSONOSPACING {mso-style-priority:1; >mso-style-unhide:no; mso-style-qformat:yes;} div.MSONOSPACING >{mso-style-priority:1; mso-style-unhide:no; mso-style-qformat:yes;} >p.MSOLISTPARAGRAPH {mso-style-priority:34; mso-style-unhide:no; > mso-style-qformat:yes;} li.MSOLISTPARAGRAPH {mso-style-priority:34; > mso-style-unhide:no; mso-style-qformat:yes;} div.MSOLISTPARAGRAPH >{mso-style-priority:34; mso-style-unhide:no; >mso-style-qformat:yes;} p.MSOLISTPARAGRAPHCXSPFIRST >{mso-style-priority:34; mso-style-unhide:no; >mso-style-qformat:yes;} li.MSOLISTPARAGRAPHCXSPFIRST >{mso-style-priority:34; mso-style-unhide:no; >mso-style-qformat:yes;} div.MSOLISTPARAGRAPHCXSPFIRST >{mso-style-priority:34; mso-style-unhide:no; >mso-style-qformat:yes;} p.MSOLISTPARAGRAPHCXSPMIDDLE >{mso-style-priority:34; mso-style-unhide:no; >mso-style-qformat:yes;} li.MSOLISTPARAGRAPHCXSPMIDDLE >{mso-style-priority:34; mso-style-unhide:no; >mso-style-qformat:yes;} div.MSOLISTPARAGRAPHCXSPMIDDLE >{mso-style-priority:34; mso-style-unhide:no; >mso-style-qformat:yes;} p.MSOLISTPARAGRAPHCXSPLAST >{mso-style-priority:34; mso-style-unhide:no; >mso-style-qformat:yes;} li.MSOLISTPARAGRAPHCXSPLAST >{mso-style-priority:34; mso-style-unhide:no; >mso-style-qformat:yes;} div.MSOLISTPARAGRAPHCXSPLAST >{mso-style-priority:34; mso-style-unhide:no; >mso-style-qformat:yes;} p.MSOQUOTE {mso-style-priority:29; >mso-style-unhide:no; mso-style-qformat:yes;} li.MSOQUOTE >{mso-style-priority:29; mso-style-unhide:no; >mso-style-qformat:yes;} div.MSOQUOTE {mso-style-priority:29; >mso-style-unhide:no; mso-style-qformat:yes;} p.MSOINTENSEQUOTE >{mso-style-priority:30; mso-style-unhide:no; >mso-style-qformat:yes;} li.MSOINTENSEQUOTE {mso-style-priority:30; > mso-style-unhide:no; mso-style-qformat:yes;} div.MSOINTENSEQUOTE >{mso-style-priority:30; mso-style-unhide:no; >mso-style-qformat:yes;} span.MSOSUBTLEEMPHASIS {mso-style-priority:19; > mso-style-unhide:no; mso-style-qformat:yes;} span.MSOINTENSEEMPHASIS > {mso-style-priority:21; mso-style-unhide:no; >mso-style-qformat:yes;} span.MSOSUBTLEREFERENCE >{mso-style-priority:31; mso-style-unhide:no; >mso-style-qformat:yes;} span.MSOINTENSEREFERENCE >{mso-style-priority:32; mso-style-unhide:no; >mso-style-qformat:yes;} span.MSOBOOKTITLE {mso-style-priority:33; > mso-style-unhide:no; mso-style-qformat:yes;} p.MSOTOCHEADING >{mso-style-priority:39; mso-style-unhide:no; >mso-style-qformat:yes;} li.MSOTOCHEADING {mso-style-priority:39; > mso-style-unhide:no; mso-style-qformat:yes;} div.MSOTOCHEADING >{mso-style-priority:39; mso-style-unhide:no; >mso-style-qformat:yes;} span.HEADING1CHAR {mso-style-priority:9; >mso-style-unhide:no;} span.HEADING2CHAR {mso-style-priority:9; >mso-style-unhide:no;} span.HEADING3CHAR {mso-style-priority:9; >mso-style-unhide:no;} span.HEADING4CHAR {mso-style-priority:9; >mso-style-unhide:no;} span.HEADING5CHAR {mso-style-priority:9; >mso-style-unhide:no;} span.HEADING6CHAR {mso-style-priority:9; >mso-style-unhide:no;} span.HEADING7CHAR {mso-style-priority:9; >mso-style-unhide:no;} span.HEADING8CHAR {mso-style-priority:9; >mso-style-unhide:no;} span.HEADING9CHAR {mso-style-priority:9; >mso-style-unhide:no;} span.TITLECHAR {mso-style-priority:10; >mso-style-unhide:no;} span.SUBTITLECHAR {mso-style-priority:11; > mso-style-unhide:no;} span.QUOTECHAR {mso-style-priority:29; >mso-style-unhide:no;} span.INTENSEQUOTECHAR {mso-style-priority:30; > mso-style-unhide:no;} span.PLAINTEXTCHAR {mso-style-priority:99; > mso-style-unhide:no;} span.E-MAILSIGNATURECHAR {mso-style-priority:99; > mso-style-unhide:no;} span.EMAILSTYLE49 {mso-style-unhide:no;} >span.EMAILSTYLE50 {mso-style-unhide:no;} .MSOCHPDEFAULT >{mso-default-props:yes;} table.MSONORMALTABLE {mso-style-priority:99;} /* >Font Definitions */ @font-face {font-family:Tahoma; panose-1:2 11 6 4 >3 5 4 4 2 4;} @font-face {font-family:Consolas; panose-1:2 11 6 9 2 2 4 >3 2 4;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal > {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; >font-family:"Times New Roman";} h1 {margin-top:24.0pt; >margin-right:0in; margin-bottom:0in; margin-left:0in; >margin-bottom:.0001pt; page-break-after:avoid; font-size:14.0pt; > font-family:Arial; color:#365F91;} h2 {margin-top:10.0pt; >margin-right:0in; margin-bottom:0in; margin-left:0in; >margin-bottom:.0001pt; page-break-after:avoid; font-size:13.0pt; > font-family:Arial; color:#4F81BD;} h3 {margin-top:10.0pt; >margin-right:0in; margin-bottom:0in; margin-left:0in; >margin-bottom:.0001pt; page-break-after:avoid; font-size:11.0pt; > font-family:Arial; color:#4F81BD;} h4 {margin-top:10.0pt; >margin-right:0in; margin-bottom:0in; margin-left:0in; >margin-bottom:.0001pt; page-break-after:avoid; font-size:11.0pt; > font-family:Arial; color:#4F81BD; font-style:italic;} h5 >{margin-top:10.0pt; margin-right:0in; margin-bottom:0in; >margin-left:0in; margin-bottom:.0001pt; page-break-after:avoid; > font-size:11.0pt; font-family:Arial; color:#243F60; >font-weight:normal;} h6 {margin-top:10.0pt; margin-right:0in; > margin-bottom:0in; margin-left:0in; margin-bottom:.0001pt; >page-break-after:avoid; font-size:11.0pt; font-family:Arial; > color:#243F60; font-weight:normal; font-style:italic;} p.MsoHeading7, >li.MsoHeading7, div.MsoHeading7 {margin-top:10.0pt; margin-right:0in; > margin-bottom:0in; margin-left:0in; margin-bottom:.0001pt; >page-break-after:avoid; font-size:11.0pt; font-family:Arial; > color:#404040; font-style:italic;} p.MsoHeading8, li.MsoHeading8, >div.MsoHeading8 {margin-top:10.0pt; margin-right:0in; >margin-bottom:0in; margin-left:0in; margin-bottom:.0001pt; >page-break-after:avoid; font-size:12.0pt; font-family:Arial; > color:#4F81BD;} p.MsoHeading9, li.MsoHeading9, div.MsoHeading9 >{margin-top:10.0pt; margin-right:0in; margin-bottom:0in; >margin-left:0in; margin-bottom:.0001pt; page-break-after:avoid; > font-size:12.0pt; font-family:Arial; color:#404040; >font-style:italic;} p.MsoCaption, li.MsoCaption, div.MsoCaption >{margin:0in; margin-bottom:.0001pt; font-size:9.0pt; >font-family:"Times New Roman"; color:#4F81BD; font-weight:bold;} p.MsoTitle, >li.MsoTitle, div.MsoTitle {margin-top:0in; margin-right:0in; > margin-bottom:15.0pt; margin-left:0in; border:none; padding:0in; > font-size:26.0pt; font-family:Arial; color:#17365D; >letter-spacing:.25pt;} p.MsoTitleCxSpFirst, li.MsoTitleCxSpFirst, >div.MsoTitleCxSpFirst {mso-style-type:export-only; margin:0in; >margin-bottom:.0001pt; border:none; padding:0in; font-size:26.0pt; > font-family:Arial; color:#17365D; letter-spacing:.25pt;} >p.MsoTitleCxSpMiddle, li.MsoTitleCxSpMiddle, div.MsoTitleCxSpMiddle >{mso-style-type:export-only; margin:0in; margin-bottom:.0001pt; >border:none; padding:0in; font-size:26.0pt; font-family:Arial; > color:#17365D; letter-spacing:.25pt;} p.MsoTitleCxSpLast, >li.MsoTitleCxSpLast, div.MsoTitleCxSpLast {mso-style-type:export-only; >margin-top:0in; margin-right:0in; margin-bottom:15.0pt; >margin-left:0in; border:none; padding:0in; font-size:26.0pt; > font-family:Arial; color:#17365D; letter-spacing:.25pt;} p.MsoSubtitle, >li.MsoSubtitle, div.MsoSubtitle {margin:0in; margin-bottom:.0001pt; >font-size:12.0pt; font-family:Arial; color:#4F81BD; >letter-spacing:.75pt; font-style:italic;} a:link, span.MsoHyperlink >{color:blue; text-decoration:underline;} a:visited, >span.MsoHyperlinkFollowed {color:purple; text-decoration:underline;} >p.MsoPlainText, li.MsoPlainText, div.MsoPlainText {margin:0in; >margin-bottom:.0001pt; font-size:10.0pt; font-family:"Courier New";} >p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig {margin:0in; >margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New >Roman";} span.Heading1Char {font-family:Arial; color:#365F91; >font-weight:bold;} span.Heading2Char {font-family:Arial; color:#4F81BD; > font-weight:bold;} span.Heading3Char {font-family:Arial; >color:#4F81BD; font-weight:bold;} span.Heading4Char {font-family:Arial; > color:#4F81BD; font-weight:bold; font-style:italic;} span.Heading5Char > {font-family:Arial; color:#243F60;} span.Heading6Char >{font-family:Arial; color:#243F60; font-style:italic;} span.Heading7Char > {font-family:Arial; color:#404040; font-style:italic;} span.Heading8Char > {font-family:Arial; color:#4F81BD;} span.Heading9Char >{font-family:Arial; color:#404040; font-style:italic;} span.TitleChar > {font-family:Arial; color:#17365D; letter-spacing:.25pt;} >span.SubtitleChar {font-family:Arial; color:#4F81BD; >letter-spacing:.75pt; font-style:italic;} span.PlainTextChar >{font-family:Consolas;} span.E-mailSignatureChar {font-family:"Times >New Roman";} p.msonospacing, li.msonospacing, div.msonospacing >{margin:0in; margin-bottom:.0001pt; font-size:10.0pt; >font-family:"Times New Roman";} p.msolistparagraph, li.msolistparagraph, >div.msolistparagraph {margin-top:0in; margin-right:0in; >margin-bottom:0in; margin-left:.5in; margin-bottom:.0001pt; >font-size:12.0pt; font-family:"Times New Roman";} >p.msolistparagraphCxSpFirst, li.msolistparagraphCxSpFirst, >div.msolistparagraphCxSpFirst {mso-style-type:export-only; >margin-top:0in; margin-right:0in; margin-bottom:0in; >margin-left:.5in; margin-bottom:.0001pt; font-size:12.0pt; >font-family:"Times New Roman";} p.msolistparagraphCxSpMiddle, >li.msolistparagraphCxSpMiddle, div.msolistparagraphCxSpMiddle >{mso-style-type:export-only; margin-top:0in; margin-right:0in; > margin-bottom:0in; margin-left:.5in; margin-bottom:.0001pt; >font-size:12.0pt; font-family:"Times New Roman";} >p.msolistparagraphCxSpLast, li.msolistparagraphCxSpLast, >div.msolistparagraphCxSpLast {mso-style-type:export-only; margin-top:0in; > margin-right:0in; margin-bottom:0in; margin-left:.5in; > margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New >Roman";} span.QuoteChar {color:black; font-style:italic;} p.msoquote, >li.msoquote, div.msoquote {margin:0in; margin-bottom:.0001pt; >font-size:11.0pt; font-family:"Times New Roman"; color:black; >font-style:italic;} span.IntenseQuoteChar {color:#4F81BD; >font-weight:bold; font-style:italic;} p.msointensequote, >li.msointensequote, div.msointensequote {margin-top:10.0pt; >margin-right:.65in; margin-bottom:14.0pt; margin-left:.65in; >border:none; padding:0in; font-size:11.0pt; font-family:"Times New >Roman"; color:#4F81BD; font-weight:bold; font-style:italic;} >p.msotocheading, li.msotocheading, div.msotocheading >{margin-top:24.0pt; margin-right:0in; margin-bottom:0in; >margin-left:0in; margin-bottom:.0001pt; page-break-after:avoid; > font-size:14.0pt; font-family:Arial; color:#365F91; >font-weight:bold;} span.msosubtleemphasis {color:gray; >font-style:italic;} span.msointenseemphasis {color:#4F81BD; >font-weight:bold; font-style:italic;} span.msosubtlereference >{font-variant:small-caps; color:#C0504D; text-decoration:underline;} >span.msointensereference {font-variant:small-caps; color:#C0504D; >letter-spacing:.25pt; font-weight:bold; text-decoration:underline;} >span.msobooktitle {font-variant:small-caps; letter-spacing:.25pt; >font-weight:bold;} p.Quote, li.Quote, div.Quote {margin:0in; >margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New >Roman";} p.IntenseQuote, li.IntenseQuote, div.IntenseQuote {margin:0in; > margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New >Roman";} span.EmailStyle49 {mso-style-type:personal; >font-family:"Times New Roman"; color:blue; font-weight:normal; >font-style:normal; text-decoration:none none;} span.EmailStyle50 >{mso-style-type:personal; font-family:Arial; color:#1F497D;} >span.EmailStyle51 {mso-style-type:personal-reply; >font-family:"Times New Roman"; color:blue; font-weight:normal; >font-style:normal; text-decoration:none none;} @page Section1 >{size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in;} div.Section1 > {page:Section1;} --> > >Hey Fred, > > > >Thank you for your response.. > > > >I actually did try it from soapUI when the developer of the consuming system >informed me about the error when he didn’t find a match. I see the 500 error >on soapUI too.. But if I search for a value that does exist, it does return a >result. > > > >Joe > > > >From: Action Request System discussion list(ARSList) >[mailto:[email protected]] On Behalf Of Grooms, Frederick W >Sent: Tuesday, September 17, 2013 10:52 PM >To: [email protected] >Subject: Re: Web Service Get Operations behavior... > > > >Yes, that is normal from an HTTP perspective (where the consuming system does >not handle the Soap Fault). You get that because ARS returns a Soap Fault >and closes the connection. If the consuming system does not detect the Soap >Fault then all it sees is the connection close and to it that is a HTTP 500 >error > > > >Run it from SoapUI and you will see you get a Soap Fault stating no results >found > > > >Fred > > > > > >From: Action Request System discussion list(ARSList) >[mailto:[email protected]] On Behalf Of Joe D'Souza >Sent: Tuesday, September 17, 2013 7:17 PM >To: [email protected] >Subject: Web Service Get Operations behavior... > > > >** > >I think this is as designed but I wanted to cross verify.. > > > >If I have a WS that I publish to the ‘world’ to perform a Get operation, and >lets say the search qualification returns no results. > > > >The is it normal to get a ‘500 – Internal Server Error’ as a response to a >search where no results are to be found? > > > >For some reason I thought the normal thing was to get an envelope with the >elements defined to be returned with blank tags if no results were returned. > > > >I am on ARS 7.6.04 Patch 003 – if it’s a bug in this version upgrading it at >this point is not an option. So if the above is not a regular response I >should have got for no matching entries I may have to live with that for a >while. I just want to know if this is what you’ll get on your versions of the >ARS if at all you’ll have published web services. Please run a search that >would return no rows and let me know what you get.. > > > >Cheers > > > >Joe > > > > > > > >_ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where >the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
