Latest Contributions by JonathanFarmer_oldaccount

Hi Jeff, Did you just try it this one time and it got stuck or have you tried this a few times? I've had similar behavior happen to me before and I decided to wipe out all the Enterprise folders in Program Files and under my user profile and just run it again. Each time, it worked for me the second time. But yes, taking overnight is way too long in my experience. It seems to complete in an hour or so on my end (depending on environmental factors on that day). Jonathan ... View more

Patrick, To echo what George mentioned, this bug is specific to behavior that is slower at 10.5.1 than 10.3.1. It has not been address as of yet but it also would not pertain to any issues that you are seeing at 10.7. If you still see this behavior at 10.7, we need a case with Tech Support so they can replicate it here and update this bug if needed with new information. Jonathan ... View more

Hi Patrick, That is odd. Are you seeing this from a client like Pro? What is the field type for this date field (is it an actual date field)?  Screen shots of what you see / the differences may help here. Does this happen for all services that are referenced from this same geodatabase and have this same field? What about hosted services or services from another geodatabase? Lastly, what happens if you start and stop the services themselves or even restart the ArcGIS Server service, does this get things back in sync? Jonathan ... View more

I'm not sure why you aren't getting this error but I think this is your issue: https://pro.arcgis.com/en/pro-app/help/projects/00219-raster-catalog-layers-are-not-supported.htm Are these actually raster catalogs? Pro sees them that way it appears. Can you see mosaic datasets in that same database in Pro? ... View more

Thanks Mike! I don't think the screen shots made it here as attachments, could you try again? You can also paste them into the body of your message as well. ... View more

Mike, Can you connect to this database in ArcMap and then screen shot the contents? If you can connect to other databases on this same instance from Pro (this same ArcGIS Pro client), then it can't be a SQL client, permissions, or other issue (I'm assuming you are using the same user to connect to this database and it has the same permissions on this database as the others?). Maybe if we can see the contents, something will stick out as an issue. Jonathan  ... View more

Wim, Yes, unfortunately there isn't going to be a way to accomplish this in ArcMap without making a change in ArcGIS Administrator. This complaint was one of the reasons we made the switch Portal functionality available in ArcGIS Pro because we had heard this from other users as well. As far as a workaround, I'm not aware of any. Someone else could chime in possibly on that. Jonathan ... View more

Mike, Looks like it may be SQL Server. Are there other database in this same instance that you can connect to and view data in Pro?  If this is specific to this one database, have we ruled out a permissions issue? If you try this same workflow on another machine with Pro, does this behavior still occur? If we can narrow the behavior down a bit, it may help. If this is specific to your install of Pro and everything looks good from the database side, a repair or reinstall of Pro could do it. But I wouldn't do that until we ensure this really is an issue with this Pro install. Jonathan  ... View more

Hi Brian, We return this message as a warning to let users know that query performance will be slower the higher number of objects in the query result. It isn't going to cause any harm on its own. That being said, getting this same message every minute 24/7 for only this one service is a bit odd. It has 71 features, are they complex features? Lines with lots of vertices or polygons with lots of vertices? That could play a role. Is it public? Could outside users be accessing it through a public web map or application? Since it is referenced data, do you see queries in a SQL Server trace constantly for this service? Is anything happening on the database side at all when your users are not accessing this service? Could also be something to look at as well. Jonathan ... View more

Hi Wim, I'm not aware of a way to do this within ArcMap. The content that you can search for is based on the environment you are connected to and is set in ArcGIS Administrator. In ArcGIS Pro, we have an option to easily switch back and forth between active Portals (ArcGIS Online being one) allowing you to search content in both. You can also add content from both to the same map. https://pro.arcgis.com/en/pro-app/help/projects/manage-portal-connections-from-arcgis-pro.htm#ESRI_SECTION1_1D170FE7526E4FCB8A36FAAD8A4D5D5B Jonathan ... View more

Well, I'd say we've got an issue here and it isn't a permissions one. We've just tried giving almost all the permissions possible in SQL Server (db_owner) and it still didn't work. So then I'd start asking questions like how was this viewer user created? Are there other viewer users in this database that exhibit the same behavior? Are there other ArcGIS clients that you can test connecting with to see if you see the feature class? Things like that. If you're able, it may not be a bad idea for Tech Support to take a look as well. They can get into the details a lot easier than we can here. Jonathan ... View more

Michael, It certainly would be if we could reproduce it here. I'm not aware of any defects out there now for this issue though (don't see any in our system). ... View more

Hmm... that's odd. I've seen behavior before where a user had to grant editing privileges to a feature class for anyone to be able to see it. I'll need to go back through our cases and see if I can find that and how we fixed it. To see if this is that issue, try 2 things: Grant SELECT, INSERT, UPDATE, DELETE and EXECUTE to this user and see what happens Also try giving the DB_OWNER database role and see what happens But you shouldn't need either of these just to view a feature class. This is just a test to see what we get (if you can view anything at all with this user after giving it full privileges). ... View more

The SELECT privilege is all a data viewer needs in SQL Server: http://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-sql-server/privileges-sqlserver.htm#ESRI_SECTION1_C1C15319C6AE40B8993FDB2E89482D5F If you want to test if this is related to granting permissions on the schema, try granting permissions just to the underlying table and see if they can view it then. I typically don't alter the default roles in SQL Server, it's probably better to setup your own custom role if you want to go that route. Jonathan  ... View more