Latest Contributions by Robert_LeClair

Aha!  That's awesome!  I was not aware of that - today I learned!  Thx Scott! ... View more

Sarah - I know exactly what you're talking about and used this in my pre-Esri days.  I looked at the internals as well as ArcGIS Ideas and don't see anything about this.  I'd recommend you create a new ArcGIS Idea for this so it gets on the radar for ArcGIS Pro equivalency. ... View more

I believe it will sort it out for you.  Test it the next day or so.  If the login screen no longer pops up, then that was it.  If you feel that my answer was the solution, then come back and mark it as "Accept as Solution" to close out your thread.   ... View more

Rafael - so two questions for you.  If you go to the Windows Start Button -> ArcGIS -> ArcGIS Administrator ->Advanced -> Manage Portal Connections, is your active portal set for https://www.arcgis.com?  Second, when you start ArcMap, click File-Sign in with your username/password credentials AND make sure the check box for "Sign me automatically" is checked.  See below graphics.  This "should" stop the behavior you're seeing.   arcmap_arcgisonline.JPG arcmap_login.JPG ... View more

Thank you for the details.  I wonder why rebuilding indexes takes the longest.  I presume your using the Rebuild Indexes GP tool to accomplish this task.  One test to consider is to use the Remove Spatial Index tool followed by the Add Spatial Index Tool to delete/add spatial grid indexes to see if that speeds things up.  If you wanted to go a step further, you could test attribute indexes performance by using the Remove Attribute Index tool followed by the Add Attribute Index tool.  It does adds more steps in your script but would be interesting to see if this improves or degrades processing time to complete. ... View more

Mark - I think what you're looking for is Compact (Data Management)  to reduce file size on disk.  This keeps the contents still editable whereas Compress File Geodatabase makes the contents read-only. ... View more

Is this an enterprise geodatabase or a file geodatabase? ... View more

Hmmmm...interesting.  Are you able to share the data with us in this thread so I can work with it in my ArcGIS Pro for testing purposes.  If not attached in the thread, my email is rleclair at esri dot com  Thx! ... View more

You're welcome - happy to assist.  With regard to workflow order, I'd recommend keeping Analyze Datasets before AND after the Compress GP tool.  This is what I teach in my eGDB classes and seems to be best practice.  You are correct that many of the database maintenance GP tools are best used on edited FC's, FDS and non-spatial tables.  The non-edited one's really don't change much as you mentioned.  There "could" be a way to set up an "if-then-else" logic for running the script on edited tables but I'm not aware of one built.  Do you run the script nightly?  And do you know how long it takes to complete? ... View more

I would say Analyze Datasets is a critical database management tool to generate statistics for feature classes, tables and such using your Data Owner connections.  In addition, running it with your SDE connection to build statistics on repository tables is again critical for the performance of your eGDB due to the fact that versioning can exact a performance toll on the versioning tables.  The Analyze GP tool works on a FC or FDS basis rather than a *.sde connection file unlike Analyze Datasets (which uses the *.sde file for the Input Database Connection parameter). If it was me, I'd leave this part in else you risk degrading your eGDB performance.  One thing I would add to your workflow is Analyze Datasets AFTER the compress. This will help with eGBD optimization. ... View more

You're welcome - let me know how it goes and if my suggestion resolves this question.  Have a nice day too! ... View more

Yes sir - that's what I saw too! ... View more