laptop and a wrench

Erro

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.

Última Publicação: August 25, 2014 No Product Found
Número de ID do Erro NIM012262
EnviadoOctober 10, 2007
Última ModificaçãoApril 2, 2025
Aplica-se àNo Product Found
Versão encontrada9.2
StatusDuplicate

Informações Adicionais

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

Solução Provisória

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>

Etapas para Reproduzir

ID do Erro: NIM012262

Software:

  • No Product Found

Seja notificado quando o status de um erro mudar

Baixe o Aplicativo de Suporte da Esri

Descubra mais sobre este tema

Obtenha ajuda de especialistas do ArcGIS

Entre em contato com Suporte Técnico

Baixe o Aplicativo de Suporte da Esri

Ir para as opções de download