topic Re: Analyze Datasets tool - Datasets to Analyze maintenance in Data Management Questions

Analyze Datasets tool - Datasets to Analyze maintenance

AndreaB_ — Tue, 21 May 2024 20:35:19 GMT

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

Re: Analyze Datasets tool - Datasets to Analyze maintenance

MarceloMarques — Tue, 21 May 2024 21:13:48 GMT

@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.

Re: Analyze Datasets tool - Datasets to Analyze maintenance

MarlonAmaya — Tue, 21 May 2024 20:52:23 GMT

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.

Re: Analyze Datasets tool - Datasets to Analyze maintenance

AndreaB_ — Tue, 21 May 2024 21:24:09 GMT

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!

Re: Analyze Datasets tool - Datasets to Analyze maintenance

AndreaB_ — Tue, 21 May 2024 21:59:54 GMT

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.

Re: Analyze Datasets tool - Datasets to Analyze maintenance

MarceloMarques — Tue, 21 May 2024 22:06:42 GMT

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.

Re: Analyze Datasets tool - Datasets to Analyze maintenance

AndreaB_ — Tue, 21 May 2024 22:10:29 GMT

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.

Re: Analyze Datasets tool - Datasets to Analyze maintenance

MarceloMarques — Tue, 21 May 2024 23:04:48 GMT

@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

Re: Analyze Datasets tool - Datasets to Analyze maintenance

AndreaB_ — Wed, 22 May 2024 15:26:05 GMT

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!

Re: Analyze Datasets tool - Datasets to Analyze maintenance

MarceloMarques — Wed, 22 May 2024 15:39:04 GMT

@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. : )

Re: Analyze Datasets tool - Datasets to Analyze maintenance

AndreaB_ — Wed, 22 May 2024 15:52:12 GMT

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

Re: Analyze Datasets tool - Datasets to Analyze maintenance

AndreaB_ — Wed, 22 May 2024 19:00:34 GMT

Hi @MarceloMarques ,

So I tested giving db_owner role to sde user on that old geodatabase. It still didn't allow me to have permissions to run the Analyze Tool. I think there are other things going on with that geodatabase. But no worries - because I tested the Analyze Tool on my new and improved sql geodatabase using the Data Owner connection and it worked perfectly. My goal is to replace the old geodatabase and the sooner the better.

Oh, and I'm not dbo or sysadmin so I can't update statistics directly in SQL Server using that SQL command. Wish I could. I'm a member of db_owner but that didn't seem to matter.

Thanks again.

Re: Analyze Datasets tool - Datasets to Analyze maintenance

MarceloMarques — Wed, 22 May 2024 20:29:30 GMT

@AndreaB_ - I am glad that the new SQL Server Geodatabase that you created following the best practices is working smoothly. That is the goal of my database template scripts and database guidebooks. I am happy is helping. : )

Mapping and Charting Solutions (MCS) Enterprise Databases Best Practices (esri.com)