You are here: > ESRI Forums > arcsde (9.1 and older) users online discussion forum > Thread Replies

ArcSDE (9.1 and older) Users Online Discussion Forum

ArcSDE: General forum

SDELAYER command returns error   Maxime Roy Apr 17, 2002
Re: SDELAYER command returns error   Pavel Pitsmaus Apr 17, 2002
Re: SDELAYER command returns error   Maxime Roy Apr 18, 2002
Re: SDELAYER command returns error   Andreas Greithanner Apr 18, 2002
Re: SDELAYER command returns error   Maxime Roy Apr 19, 2002
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject SDELAYER command returns error 
Author Maxime Roy 
Date Apr 17, 2002 
Message I everyone,

My problem: I am triying to use the SDELAYER command and it always returns errors...

My goal: See the spatial statistics on a layer to make performance improvement...

Our setup is ArcSDE 8.1.2 with Oracle 8.1.7
All our ArcSDE structure (Tables and FeatureClass) have been created using the UML language and the data has been loaded with ArcCatalog. We have actually no problem using the data in ArcMap except that performance is relatively poor.

HERE are the commands I tested and the response I got from the layer administration utility...

sdelayer -o si_stats -l gfr_polygone_forestier,shape -i esri_sde -s mt_geofor -u gfr -p xxx

ArcSDE 8.1.2 Build 938 Thu Nov 8 13:04:25 PST 2001
Layer Administration Utility
-----------------------------------------------------
Error: Layer not found (-20).
Error: Cannot Retrieve Layer Definition for table gfr_polygone_forestier

sdelayer -o describe -O gfr -l gfr_polygone_forestier,SHAPE -i esri_sde -s mt_geofor -u gfr -p xxx

ArcSDE 8.1.2 Build 938 Thu Nov 8 13:04:25 PST 2001
Layer Administration Utility
-----------------------------------------------------
Error: Layer not found (-20).
Error: Cannot get Map Layer.


QUESTIONS:
Why do i get that error ??? Is it related to using a Geodatabase instead of pure SDE ??? What can i do to get the spatial index statistics ???

Thank you !
 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: SDELAYER command returns error 
Author Pavel Pitsmaus 
Date Apr 17, 2002 
Message Maxime,
Is table GFR_POLYGONE_FORESTIER in GFR user schema ?
You can usually receive this error message when not specifying
fully qualified layer name for objects, that are not in schema of the user, who run sdelayer command. 
  Pavel Pitsmaus 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: SDELAYER command returns error 
Author Maxime Roy 
Date Apr 18, 2002 
Message
Yes GFR_POLYGONE_FORESTIER is in GFR user schema !!!
But it is not only a table, it is an ArcSDE Geodatabase FeatureClass !!!

If you wonder, I have tried the command with other featureClass and they all returns the same error !
Here is part of the output for sdelayer -o describe
it present the description of GFR_POLYGONE_FORESTIER

sdelayer -o describe -i esri_sde -s mt_geofor -u gfr -p xxx
----------------------------------------------------------------
Table Owner : GFR
Table Name : GFR_FOR_POLYGONE_FORESTIER
Spatial Column : SHAPE
Layer id : 18
Entities : nac+
Layer Type : SDE
I/O Mode : NORMAL
User Privileges : SELECT, UPDATE, INSERT, DELETE
Layer Configuration: GFR_GROS


 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: SDELAYER command returns error 
Author Andreas Greithanner 
Date Apr 18, 2002 
Message Hi Maxime,

when you use the sdelayer -o si_stats you want to display the information of an layer called "gfr_polygone_forestier". The output of sdelayer -o describe displays a layer with the name "gfr_for_polygone_forestier". => That's not the same name!
You can display the statistics of an layer using the known sde-commands, even if it is an feature-class.

Andreas 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: SDELAYER command returns error 
Author Maxime Roy 
Date Apr 19, 2002 
Message THANK YOU Andreas !!!

I feel stupid ... I usualy see this kind of typing error !!!
I had lost confidence in the command and thought it was not actual with ArcSDE and the Geodatabase but now I know it is working !!!
I finally got my statistics and will be able to adjust the spatial index grid !!!

Sorry for the time consumed !
Next time I will be more carefull !