laptop and a wrench

Bug

Using an outer join when data is stored in SQL Server 2000, the GET_FEATURES request fails to work and returns an ERR2407 Underlying DBMS error.

Last Published: August 25, 2014 No Product Found
Bug ID Number NIM012262
SubmittedOctober 10, 2007
Last ModifiedApril 2, 2025
Applies toNo Product Found
Version found9.2
StatusDuplicate

Additional Information

This issue will be addressed along with"NIM012610: Support ANSI join syntax".

Workaround

Updated 11/14/07 Explicitly specify the subfields for the query and not include #SHAPE#See example below.<ARCXML version="1.1"><REQUEST><GET_FEATURES featurelimit="25" beginrecord="1" outputmode="xml" geometry="false" envelope="true" checkesc="true"><LAYER id="0"></LAYER><SPATIALQUERY subfields="VTEST.MAP.LANCASTER_PARCELSSHP.AREA VTEST.MAP.LANCASTER_PARCELSSHP.PERIMETER VTEST.MAP.LANCASTER_PARCELSSHP.PRECINCT VTEST.MAP.LANCASTER_PARCELSSHP.SECTION VTEST.MAP.LANCASTER_PARCELSSHP.BLOCK VTEST.MAP.LANCASTER_PARCELSSHP.PARCEL VTEST.MAP.LANCASTER_PARCELSSHP.SUBPARCEL VTEST.MAP.LANCASTER_PARCELSSHP.PID VTEST.MAP.LANCASTER_PARCELSSHP.PROP_ID VTEST.MAP.LANCASTER_PARCELSSHP.PROPOWN_ID VTEST.MAP.LANCASTER_PARCELSSHP.TAX_DIST VTEST.MAP.LANCASTER_PARCELSSHP.PROP_CLASS VTEST.MAP.LANCASTER_PARCELSSHP.PRIME_USE VTEST.MAP.LANCASTER_PARCELSSHP.NBH VTEST.MAP.LANCASTER_PARCELSSHP.ACRES VTEST.MAP.LANCASTER_PARCELSSHP.ASSESSED VTEST.MAP.LANCASTER_PARCELSSHP.VAL_METHOD VTEST.MAP.LANCASTER_PARCELSSHP.GREENBELT VTEST.MAP.LANCASTER_PARCELSSHP.area_1 VTEST.MAP.LANCASTER_PARCELSSHP.len VTEST.MAP.LANCASTER_PARCELSSHP.OBJECTID VTEST.MAP.GLNK2007.PROPERTYID VTEST.MAP.GLNK2007.QUICKREFID VTEST.MAP.GLNK2007.PROPNUMBER VTEST.MAP.GLNK2007.PROPNOSRCH VTEST.MAP.GLNK2007.MAPNUMBER VTEST.MAP.GLNK2007.SALEDATE VTEST.MAP.GLNK2007.SALEPRICE VTEST.MAP.GLNK2007.INSTRNUM VTEST.MAP.GLNK2007.SALESRATIO VTEST.MAP.GLNK2007.ONAME VTEST.MAP.GLNK2007.OADDR1 VTEST.MAP.GLNK2007.OADDR2 VTEST.MAP.GLNK2007.OADDR3 VTEST.MAP.GLNK2007.OWNERCITY VTEST.MAP.GLNK2007.OWNERSTATE VTEST.MAP.GLNK2007.OWNERZIP VTEST.MAP.GLNK2007.OQUICKREF VTEST.MAP.GLNK2007.SITUS VTEST.MAP.GLNK2007.SITUSSNO VTEST.MAP.GLNK2007.SITUSPRDIR VTEST.MAP.GLNK2007.SITUSSNM VTEST.MAP.GLNK2007.SITUSPODIR VTEST.MAP.GLNK2007.SITUSSTP VTEST.MAP.GLNK2007.SITUSAPT VTEST.MAP.GLNK2007.LEGAL VTEST.MAP.GLNK2007.LEGALLOC VTEST.MAP.GLNK2007.DEEDDATE VTEST.MAP.GLNK2007.DEEDBOOK VTEST.MAP.GLNK2007.DEEDPAGE VTEST.MAP.GLNK2007.SALETYPE VTEST.MAP.GLNK2007.NBHDCODE VTEST.MAP.GLNK2007.TAXUNITS VTEST.MAP.GLNK2007.EXEMPTIONS VTEST.MAP.GLNK2007.LISTCOMPS VTEST.MAP.GLNK2007.HIDEOWNER VTEST.MAP.GLNK2007.STATUSCODE VTEST.MAP.GLNK2007.OBJECTID" where="VTEST.MAP.LANCASTER_PARCELSSHP.PID = &apos;1619416050000&apos;" ></SPATIALQUERY></GET_FEATURES></REQUEST></ARCXML>

Steps to Reproduce

Bug ID: NIM012262

Software:

  • No Product Found

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options