English

Error: [ERR2004] Dataset "..." cannot be created. Dataset is missing, unknown type, or invalid.

Error Message

When attempting to create an Image or Feature map service that references ArcSDE feature classes, you may in special circumstances encounter these errors in the ArcIMS 9.0 Administrator Message Console:

Code:
[ERR0928] ImageServer on <ARCIMS_SERVER>: Layer with ID 3 cannot be created. Dataset <DATABASE.OWNER.TABLE> is missing, unknown type, or invalid.
[ERR0928] ImageServer on <ARCIMS_SERVER>: Layer with ID 3 cannot be created. Dataset <DATABASE.OWNER.TABLE> is missing, unknown type, or invalid.
[ERR0713] FeatureServer on <ARCIMS_SERVER>: Layer with ID 3 cannot be created. Dataset <DATABASE.OWNER.TABLE> is missing, unknown type, or invalid.
[ERR0713] FeatureServer on <ARCIMS_SERVER>: Layer with ID 3 cannot be created. Dataset <DATABASE.OWNER.TABLE> is missing, unknown type, or invalid.”/>
</WARNINGS>
at com.esri.mo.client.io.EsrimapInputStream.a(Unknown Source)
at com.esri.mo.client.io.EsrimapInputStream.read(Unknown Source)
at java.io.DataInputStream.read(Unknown Source) ..etc.


The Spatial Server log files will record an error such as this:

Code:
[Feb 17, 2005 5:10:20 PM][1376 2408 ERROR] [ERR2407] (SDE error code -20 ) SE_table_describe : Layer not found
[Feb 17, 2005 5:10:20 PM][1376 2408 ERROR] [ERR2004] Dataset “<DATABASE.OWNER.TABLE>” cannot be created. Dataset is missing, unknown type, or invalid.

Cause

One possible cause is that the feature class contains an attribute field called SHAPE. This can occur if the source data contains an attribute field with this name. The geometry column will then be named SHAPE_1, and this is acceptable. However, in ArcIMS 9.0, feature classes cannot contain a non-geometry field named SHAPE.

Solution or Workaround

  1. Check the attribute table of the feature class(es) identifed in the error message. Specifically, check to see if there is an attribute column named "SHAPE". In other words, the data type of this column cannot be "text", "long integer" or any other data type except for "geometry".
  2. If the feature class contains a non-geometry field called SHAPE, delete or rename the field.
  3. Exporting to a shapefile and then re-importing it back into ArcSDE also resolves the problem by effectively switching the names of the columns.

Related Information