topic Re: Analyze ARCSDE featureclass produces Error in Data Management Questions

Analyze ARCSDE featureclass produces Error

TuridBrox — Mon, 19 Mar 2012 16:13:42 GMT

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!

Re: Analyze ARCSDE featureclass produces Error

JakeSkinner — Mon, 19 Mar 2012 17:19:22 GMT

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

Re: Analyze ARCSDE featureclass produces Error

Morten_EirikEines — Tue, 20 Mar 2012 07:16:31 GMT

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.

Re: Analyze ARCSDE featureclass produces Error

JakeSkinner — Sat, 11 Dec 2021 16:16:32 GMT

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?

Re: Analyze ARCSDE featureclass produces Error

TuridBrox — Tue, 20 Mar 2012 11:41:00 GMT

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.

Re: Analyze ARCSDE featureclass produces Error

JakeSkinner — Tue, 20 Mar 2012 12:05:02 GMT

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.

Re: Analyze ARCSDE featureclass produces Error

VinceAngelo — Tue, 20 Mar 2012 14:15:50 GMT

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

Re: Analyze ARCSDE featureclass produces Error

TuridBrox — Tue, 20 Mar 2012 15:48:40 GMT

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

Re: Analyze ARCSDE featureclass produces Error

TuridBrox — Thu, 22 Mar 2012 08:04:52 GMT

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