nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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!

Find more posts tagged with

Accepted answers

TuridBrox

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

All comments

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

Skjermbilde2.PNG

Skjermbilde1.PNG

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

jskinner

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.

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.

jskinner

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?

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.

jskinner

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

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.