SDELAYER command returns error

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 !