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 Datasets tool - Datasets to Analyze maintenance

AndreaB_

Hi all,

I'm looking into using the Analyze Datasets tool in ArcGIS Pro. Couple questions:

2) I see Only datasets that are owned by the connected user will be displayed. So do people end up running this tool at least twice - once as 'sde' and once as the DataOwner user?

Thanks,

Andrea

Find more posts tagged with

Geodatabase

Databases

Accepted answers

AndreaB_

Great, thank you! Posted: https://community.esri.com/t5/arcgis-pro-ideas/make-the-ui-panes-the-same-for-quot-select-all/idi-p/1477041

MarlonAmaya

Hi @AndreaB_ ,

With tool you can select the down arrow and then click the checkbox. yes, this will only display data owned by schema owner and should be ran with "data owner" and SDE user.

MarceloMarques

@AndreaB_

1) Is there a way to pick all Datasets in the geodatabase? Would be nice if we had a select all button here - I have a lot and I haven't picked them all from the drop down yet. I think you all are going to say - use Python. and I'm sure I should but I really just wanted a quick way to run this tool on all datasets.

[Marcelo]: You can drag and drop all the featuredatasets, featureclasses, tables into the "Datasets to Analyze" box and the tool will update the statistics for all of them. You can them turn the tool into a Model Builder or Python Script.

2) I see Only datasets that are owned by the connected user will be displayed. So do people end up running this tool at least twice - once as 'sde' and once as the DataOwner user?

[Marcelo]: I prefer to always use the data owner user connection to analyze and get new statistics, I do not use the sde user connection. If I have multiple data owner users, then I execute the analyze multiple times.

Note, you still need to run the Analyze with the sde user connection but with the option "Include System Tables" to update statistics of the ArcSDE Geodatabase tables. When you run the Analyze with the data owner users you turn off that option.

Analyze Datasets example:

sde user connection

note: sde user is the arcsde geodatabase repository owner and shall not be used to load featureclasses and tables.

data owner user connection

In my case I am also a database administrator, hence I prefer to use the RDBMS SQL commands to get new statistics instead of using the ArcGIS Pro Analyze GP tool, the RDBMS SQL commands provide advanced options that the Analyze GP tool does not have.

I hope this helps.

All comments

AndreaB_

Great, thank you! Posted: https://community.esri.com/t5/arcgis-pro-ideas/make-the-ui-panes-the-same-for-quot-select-all/idi-p/1477041

MarceloMarques

@AndreaB_ - I am not aware of any idea posted asking to make the GP Tools UI similar for "Select All".
Please go ahead and post an idea about this, if there is a duplicate idea then when your idea is reviewed, we will know for sure. I agree it is a good enhancement. : )

AndreaB_

Now I know why I was looking for the Select All button - because there is one on the Rebuild Indexes pane (see below). Are you aware of any Ideas to make these panes have the same look and feel to 'select all'? or @KoryKramer ? Super confusing to have to 2 different ways (and the help documentation doesn't talk about Select All). If there isn't one then I can start one.

Thank you!

MarceloMarques

@AndreaB_ - grant db_owner role to the sde user on the geodatabase that has the sde user as the data owner user, close/open ArcGIS Pro and then try again the Analyze Tool using the connection file of the sde user and it shall work this time.

Tip: You can update statistics directly in SQL Server using this SQL command.

USE <your_db_name_here>
GO
EXEC sp_updatestats
GO

https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-updatestats-transact-sql?view=sql-server-ver16

AndreaB_

Well, I thought the tool was done. But it said 100% and it was still working. And when I went to close ArcGIS Pro - it said the tool was still running. So there's a chance all of the error messages weren't loaded yet. In that case none of them would have worked.

This is the "not best practices" geodatabase that has 'sde' as the Data Owner for everything (not doing that in future, I promise!) . so I was connected as 'sde'. I am using this one to test Prod before I replace Prod with the best, new one. But maybe this geodatabase is too messed up to function.

MarceloMarques

which is the data owner user for the layers that worked?
which is the data owner user for the layers that did not work?
which connection file did you use? the sde user? or which data owner user?

based on how permissions are set for the users and if a particular data owner user can see the data of other data owner user, then that data owner user will not have privileges, and you will need to run the Analyze with the other data owner user.

AndreaB_

oh interesting....I got "Could not analyze dataset ... (You might not have sufficient permissions.)" on 19 of the layers. The other 30 ran fine. I used the dataowner connection - or so it appears.

AndreaB_

ah ok!! Thank you both!! Never knew that little arrow was there hiding the checkbox for select all. And the rest all makes sense to me. Appreciate it!

MarlonAmaya

Hi @AndreaB_ ,

With tool you can select the down arrow and then click the checkbox. yes, this will only display data owned by schema owner and should be ran with "data owner" and SDE user.

MarceloMarques

@AndreaB_

2) I see Only datasets that are owned by the connected user will be displayed. So do people end up running this tool at least twice - once as 'sde' and once as the DataOwner user?

sde user connection

note: sde user is the arcsde geodatabase repository owner and shall not be used to load featureclasses and tables.

data owner user connection

I hope this helps.

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.