Analyze ARCSDE featureclass produces Error

[TuridBrox]

I get the following error message when trying to analyze a feature dataset in an SDE gdb (ArcGIS 10 Server Enterprise Standard with MSSQL Server 2008):

"Failed to analyze dataset.
DBMS table not found [Microsoft SQL Server Native Client 10.0: Table 'f63' does not exist.]"

It seems as if the table containing the geometry is missing. Any suggestions for solving this problem?

Thanks in advance!

[JakeSkinner]

Have you checked to see if the f63 tables exits?  You can also find out which feature class this is referring to by executing the following query:

select table_name from sde.SDE_layers where layer_id = 63

[Morten_EirikEines]

Yes, the feature table exist.

select table_name from sde.SDE_layers where layer_id = 63 gives the result RpJuridisklinje. The featureclass is visible in ArcMap and seems ok.

[JakeSkinner]

Try describing the feature class using the 'sdelayer -o describe' command.  Here's an example:

C:\> sdelayer -o describe -l RpJuridisklinje,shape -i sde:sqlserver:sde_server -D vector -u vector -p vector

What is returned for the Layer Configuration?

[TuridBrox]

What is returned for the Layer Configuration?

Thanks for your reply. We get this:

ArcSDE 10.0 for SQL Server Build 685 Fri May 14 12:05:43 2010
Layer Administration Utility
-----------------------------------------------------

----------------------------------------------------------------
Database : SKEDSMOKART
Table Owner : (removed)
Table Name : RPJURIDISKLINJE
Spatial Column : SHAPE
Layer id : 63
Entities : nslc+
Layer Type : In-Line Spatial Type
I/O Mode : NORMAL
Autolocking : Enabled
Precision : High
User Privileges : SELECT, UPDATE, INSERT, DELETE
Layer Configuration: DEFAULTS

Geometry in DEFAULTS is stored as MSSQLs GEOMETRY.

[JakeSkinner]

Hi Turid,

If 'GEOMETRY' is used for the DEFAULTS, then an F table should not exist.  An F table is not created for GEOMETRY or GEOGRAPHY data types.  When executing the 'Analyze' command, uncheck 'F' table and it should succeed.

[VinceAngelo]

The analyze tool should detect the native layer type and either grey-out or at least ignore
the 'F' table analysis option, which would prevent this issue from arising.  Please contact
Tech Support with a screenshot so a NIM can be created.

- V

[TuridBrox]

Thank you for your replies, we have reported this possible bug to our local distributor. (The option to analyze Feature tables is not greyed out - see attached screen shot.)

Will try to update this thread when we know more.

Regards,
Turid

[TuridBrox · Accepted solution]

We have now been in contact with our local provider, and been informed that this is a known bug that will be fixed in 10.1:

#NIM068985 Analyze tool should check internally for SQL Geometry/Geography storage type.

Thanks for all your help!

Turid