topic Re: [RPC Fault faultString="Servlet execution threw an exception" faultCode="500"... in ArcGIS API for Flex Questions

[RPC Fault faultString="Servlet execution threw an exception" faultCode="500"...

AshleyOwens — Tue, 15 Mar 2011 12:25:23 GMT

I added a 2nd combobox to my search widget. When the 1st combobox has a selection, the code should populate the 2nd combobox. I am getting the following error in function onFault:

[RPC Fault faultString="Servlet execution threw an exception" faultCode="500" faultDetail=""]

Attached is the xml and mxml. In the mxml, making a selection in the 1st combobox (???Search Layer???) calls function searchLayerChangedText(). That calls function querySearchFeatures(), which is the function where the error is being thrown.

Re: [RPC Fault faultString="Servlet execution threw an exception" faultCode="500"...

RobertScheitlin__GISP — Tue, 15 Mar 2011 14:09:44 GMT

Ashley,

So do you get to line 511 this trace statement?

trace("@@@@ querySearchFeatures(): inside onResult.");

Re: [RPC Fault faultString="Servlet execution threw an exception" faultCode="500"...

AshleyOwens — Tue, 15 Mar 2011 14:40:34 GMT

No, it does not make it to that line. Here are all the trace statements that get printed. Also, the last line "inside onFault" prints about 10 seconds after the other lines.

@@@@ querySearchFeatures(): selectedIndex=11, jqLayer=http://arcprod:8399/arcgis/rest/services/Land/MapServer/4, query.outFields=COUNTY
@@@@ querySearchFeatures(): query.outSpatialReference=SpatialReference[102100]
@@@@ querySearchFeatures(): after queryTask.execute.
@@@@ querySearchFeatures(): inside onFault; info=[RPC Fault faultString="Servlet execution threw an exception" faultCode="500" faultDetail=""], token=null

Re: [RPC Fault faultString="Servlet execution threw an exception" faultCode="500"...

RobertScheitlin__GISP — Tue, 15 Mar 2011 14:49:38 GMT

Ashley,

Have you tried to run the query from the REST Services directory?
Like pasting this in a browsers address bar?

http://arcprod:8399/arcgis/rest/services/Land/MapServer/4/query?text=&geometry=&geometryType=&inSR=&spatialRel=&relationParam=&objectIds=&where=1%3D1&time=&returnCountOnly=false&returnIdsOnly=false&returnGeometry=true&maxAllowableOffset=&outSR=102100&outFields=COUNTY&f=pjson

Re: [RPC Fault faultString="Servlet execution threw an exception" faultCode="500"...

AshleyOwens — Tue, 15 Mar 2011 18:04:04 GMT

Here is the response I got from that URL:

{"error": {
"code": 500,
"message": "Map Service 'Land' does not exist or is inaccessible.",
"details": []
}}

Re: [RPC Fault faultString="Servlet execution threw an exception" faultCode="500"...

AshleyOwens — Tue, 15 Mar 2011 18:05:38 GMT

When I change "Land" to "land" in the URL (to match our services directory), I get this response:

{"error": {
"code": 500,
"message": "Unable to perform query. Please check your parameters",
"details": []
}}

Re: [RPC Fault faultString="Servlet execution threw an exception" faultCode="500"...

RobertScheitlin__GISP — Tue, 15 Mar 2011 18:08:34 GMT

Ashley,

So the next question is does this layer have a field called COUNTY and remember that flex is case sensitive.

Re: [RPC Fault faultString="Servlet execution threw an exception" faultCode="500"...

AshleyOwens — Tue, 15 Mar 2011 18:22:10 GMT

The layer does have a field called COUNTY, but the layer is notated as "Land" in the config XML file and not "land" like it is in the services directory. Do I need to change one or the other?

Re: [RPC Fault faultString="Servlet execution threw an exception" faultCode="500"...

RobertScheitlin__GISP — Tue, 15 Mar 2011 18:25:50 GMT

Ashley,

Definitely in the config.xml. So normally when people get the error unable to perform the query the issue is that they have hidden the shape and/or ObjectId fields in the mxd that the map service is coming from.

Re: [RPC Fault faultString="Servlet execution threw an exception" faultCode="500"...

AshleyOwens — Tue, 15 Mar 2011 18:41:12 GMT

Can you explain why our production server would accept both "land" & "Land" in URL http://arcprod:8399/arcgis/rest/services/Land/MapServer/4/, but has only "Land" listed in services directory? I want to be careful to not break production if I make a change in development.

For my query, I only want to return the COUNTY field so I can populate a dropdown. Then the COUNTY value chosen by the user will be used to query our GMD layer, returning only GMDs in that COUNTY. That being said, would SHAPE or OBJECTID fields play a role in this functionality - would I need to verify those fields are "unhhidden"?

Re: [RPC Fault faultString="Servlet execution threw an exception" faultCode="500"...

RobertScheitlin__GISP — Tue, 15 Mar 2011 18:46:53 GMT

Ashley,

To be able to query a layer in a map service it will allways have to have the Shape and ObjectID fields visible as REST needs these to perform the query. You do not have to return these fields in your query though.

The rule of thumb is always use the name of the service or just copy the url path from the address bar in the services directory.

Re: [RPC Fault faultString="Servlet execution threw an exception" faultCode="500"...

AshleyOwens — Tue, 15 Mar 2011 19:34:45 GMT

As far as SHAPE & OBJECTID, we are currently showing details about this layer so these fields must already be visible.

How can I change the "land" service in Dev to be "Land" so it matches Production? I would like to keep the config XML file as it is now.

Do you have any recommendations to resolve error "Unable to perform query. Please check your parameters" (I see this when I change the URL to "Land").

Thank you so much for all your responses today! I appreciate the help!

Re: [RPC Fault faultString="Servlet execution threw an exception" faultCode="500"...

RobertScheitlin__GISP — Tue, 15 Mar 2011 19:43:32 GMT

Ashley,

As far as SHAPE & OBJECTID, we are currently showing details about this layer so these fields must already be visible.

So does this mean that you physically opened the MXD that this map service is pointing to and opened the attribute table for that particular layer (land) and verified that the shape and objectid field are visible in the table?

As far as making sure that the development server and the production server are using the same name for the land layer look at the mxd that each server is pointing to and ensure that land is spelled using the same case in each of those mxds.

Is your production server publicly visible?

Re: [RPC Fault faultString="Servlet execution threw an exception" faultCode="500"...

AshleyOwens — Tue, 15 Mar 2011 20:09:19 GMT

Yes, I viewed the attribute table for that mxd and could see OBJECTID & SHAPE listed.

I tested again and am getting COUNTY information back!

Thank you so much!

Re: [RPC Fault faultString="Servlet execution threw an exception" faultCode="500"...

AshleyOwens — Thu, 17 Mar 2011 14:35:23 GMT

When I go to the URL you provided, I get COUNTY information back like I said. But when I run through my app, I still get "Servlet execution threw an exception". Can I get the URL the app is creating for this query to compare? Otherwise, the error is vague and it's hard to troubleshoot...

Re: [RPC Fault faultString="Servlet execution threw an exception" faultCode="500"...

RobertScheitlin__GISP — Thu, 17 Mar 2011 14:46:08 GMT

Ashley,

If you install free HTTP utilities like Fiddler or Charles you can see the HTTP traffic that is going back and forth from the server and the client.

Re: [RPC Fault faultString="Servlet execution threw an exception" faultCode="500"...

AshleyOwens — Thu, 17 Mar 2011 15:22:31 GMT

Thanks Robert. I can see the URL now and compared it to the one that works. When I changed query.returnGeometry = false; it worked through the app!

Thanks again for your help Robert! I appreciate your patience with a beginner!

Re: [RPC Fault faultString="Servlet execution threw an exception" faultCode="500"...

AshleyOwens — Wed, 12 Oct 2011 12:39:22 GMT

I am having this problem again. In our test environment that we just upgraded to ArcGIS Server 10, we see error [RPC Fault faultString="Unable to perform query. Please check your parameters" faultCode="500" faultDetail=""] when attempting to access certain layers using Identify or Search widgets.
When I change the xml files to point to our production environment (v9.3), it works.
I went to the REST service in a browser and was able to query on the layers that give an error in the widgets.
How can I further troubleshoot this issue? Could it have to do with the ArcGIS Server upgrade?

Re: [RPC Fault faultString="Servlet execution threw an exception" faultCode="500"...

AshleyOwens — Thu, 13 Oct 2011 11:35:26 GMT

I think I figured this out. If there are fields listed in the widget XML that are not in the corresponding database table, this error will be returned. This was not an issue before, so I'm assuming it's a change with ArcGIS Server version 10.