topic Re: Shapes of this entity type not allowed in this layer (-35) in Data Management Questions

Shapes of this entity type not allowed in this layer (-35)

JohnFell — Wed, 08 Sep 2010 19:34:49 GMT

ArcSDE 10
SQL Server 2008 R2
Windows Server 2008
Shape Column: ST_GEOMETRY Storage

Perhaps I am one of the last of the Mohicans who is still using sde command line syntax from the DOS prompt to import coverage annotation:

SDELayer -o add -l "NEWBLKID2006,ShapeID" -e sA -g "5000,0,0" -x "2300000,6800000,1000" -k FC_GEOMETRY -S "Block Numbers (2006)" -i esri_sde -s DCADDBIT -D GIS -u USR -p PAS

The problem is I am getting the following error:

Shapes of this entity type not allowed in this layer (-35).

when trying to create an sde layer using sde command line with the entity type of sA. ESRI Tech Support has not been able to duplicate the issue. Has anyone had this kind of error when just trying to create a layer after building an sde table?

Re: Shapes of this entity type not allowed in this layer (-35)

CherylCleghorn — Thu, 09 Sep 2010 15:00:29 GMT

ST_Geometry is not a supported storage type for SQLServer. What is the esri incident number for this issue? Have you already provided the analyst with your exported dbtune table to investigate your FC_GEOMETRY configuration keyword?

Re: Shapes of this entity type not allowed in this layer (-35)

JohnFell — Thu, 09 Sep 2010 15:14:52 GMT

Incident #843329

I have not supplied the support analyst with the dbtune file. I have attached it to this post.

Re: Shapes of this entity type not allowed in this layer (-35)

CherylCleghorn — Thu, 09 Sep 2010 16:39:00 GMT

Thanks John

Will look into it; the analyst will communicate with you via the incident.

Regards
Cheryl

Re: Shapes of this entity type not allowed in this layer (-35)

ThomasDunn — Thu, 09 Sep 2010 20:17:10 GMT

You are receiving this error because SQL Server GEOMETRY and GEOGRAPHY type storage in ArcSDE does not include support for old-style SDE annotation. ArcGIS annotation is supported.

-- TAD