Select to view content in your preferred language

Tax Parcel Viewer parcel search doesn't work outside firewall

3448
4
08-27-2013 12:15 PM
JayGeisen
Regular Contributor
I was wondering if anyone would know why my parcel/address search does not work outside our firewall? It works fine internally, whether using a desktop or mobile device. The map services render fine outside our network and I can click on a parcel and it returns the record and everything, but for some reason the search just hangs. We are using a reverse proxy, for what it's worth.
Thanks
0 Kudos
4 Replies
JayGeisen
Regular Contributor
After doing more testing, I am able to get the search to work outside the firewall IF I search on only one field. For instance:

this works: ParcelQuery: "UPPER(PPN) LIKE '%${0}%'",

this works: ParcelQuery: "UPPER(SiteAddress) LIKE '%${0}%'",

this does not: ParcelQuery: "UPPER(PPN) LIKE '%${0}%' OR UPPER(SiteAddress) LIKE '%${0}%'",

Inside the firewall, all of the above work.

Thoughts?
0 Kudos
JayGeisen
Regular Contributor
For future reference, we have determined that our firewall (SonicWALL) is stopping the requests due to what it is interpreting as a SQL Injection attack (http://software.sonicwall.com/applications/ips/index.asp?ev=sig&sigid=5679). We have yet to determine how to address this issue. The vulnerability, affecting ArcGIS 10.1, is documented here. http://www.cvedetails.com/cve/CVE-2012-4949/

Edit: Apparently, this has been fixed with the following patch: http://support.esri.com/en/downloads/patches-servicepacks/view/productid/66/metaid/1930
0 Kudos
RyanKammerer1
Deactivated User

I'm experiencing the exact same thing as you described, Jay. Did installing the patch work? I'm running ArcGIS for server 10.2.2.

0 Kudos
RyanKammerer1
Deactivated User

Doesn't look as though a patch exists for ArcGIS for Server 10.2.2. Jay, I'm wondering, were you able to go into your Sonic Wall firewall settings to allow this type of query to go through?

Thanks!

Ryan

0 Kudos