Latest Contributions by JonathanFarmer_oldaccount

That makes it a little more challenging then since we don't have any information to go off of. Is this happening with Pro on other machines in your organization? I just tested out Pro 2.2.4 here doing the same workflow and I don't see the same behavior. If this is specific to your machine, it may be worth trying a repair of the software. Right click ArcGIS Pro in Control Panel > Programs and Features and choose to Uninstall/Change. There will be a repair option when the wizard opens. Jonathan ... View more

Hi Jamie, Is there a crash dump file created when this happens? It would typically be found here: C:\Users\<username>\AppData\Local\ESRI\ErrorReports Jonathan ... View more

Hi Jon, While I can't speak on the specifics on the next generation data distribution plan, I did want you to be aware that we are certainly taking care of this line: "Commit to supporting ArcSDE for another 5 years, while you work out the bugs in a next-generation web services model." ArcMap 10.6.1 is supported until January 2024 and ArcMap 10.7 should be coming out Q1 of this year which will extend that time frame. So the current distributed data model will be alive and well (read supported) for a good bit. Jonathan ... View more

Hi, OK, so if the SQL Express instance is setup to allow remote connections then that rules that out. You may consider opening a support case with Esri UK and having them troubleshoot this with you, it would probably be quicker. But I would now check things like: You've got the 32 bit SQL client installed. You need that for ArcMap, regardless of your SQL Express instance version The database name has no spaces or special characters and is less than 31 characters Is the issue specific to one database in this instance? I know you said you can see the list of databases but get the error when you click on one. Does it happen for all of them? Could be an issue with one database for some reason. Some things to check at least. But this may need to be troubleshooted by support in order to screen share and really dig into what is going on. Jonathan ... View more

Hi Faith, I know I'm not the person you replied to but I wanted to ask if you have created a case with Technical Support yet for this crashing issue? This is something they want to know about and gather information on so please do so if you haven't already. I'd also be curious to know some things like: Is it specific to this one line feature class? Does the crashing also happen in ArcMap with this same line feature class? Does the crashing happen for anyone else with Pro and this line feature class? Those are some of the questions Support will ask. It helps to narrow things down. But you shouldn't be seeing several crashes a day, something's not right there. Jonathan ... View more

Hi, This is something to check, I've seen it before with SQL Express. Since Express is meant for home or single computer use, networking protocols are disabled by default. You would need to actually set Express up to accept remote connections. This is an old blog but still valid. Can you make sure you've done this? How to: Configure Express to accept remote connections – SQL Server Express WebLog  Also, make sure your version of SQL Express is compatible with 10.6.1 Microsoft SQL Server database requirements for ArcGIS 10.6.x—System Requirements | ArcGIS Desktop  Jonathan ... View more

Hi Sherrie, I'll look into this some more and see want options I can find. It all depends on how Microsoft has structured things so I'll need to do some research. I haven't dealt much with granting privileges on the database side with users other than a member of sysadmin or db_owner. Jonathan ... View more

Hi Mark, I think you may be running into this bug: BUG-000099829: When publishing a hosted feature service from ArcMap..  It isn't fixed as of yet so you would still run into it with 10.6.1. I don't have a date that this is scheduled to be fixed unfortunately. If you wanted to test publishing the same data using the same user to AGOL and see what happens that may be a good test. But it is a bit odd that your Admin user does not run into this issue. Let me know what happens with the new user. Jonathan ... View more

Hi Sherrie, You are certainly on the right track with your workflow here. I might recommend a slight change though in the implementation. See more below. Granting permissions from the database side is a valid workflow for a lot of our users. However, it requires that the user granting those permissions have some pretty high level clearance, usually the SA user or database owner. It also means that those users that are granted permissions have those permissions across the entire database. There are ways around this last part but I won't muddy this up with that.  Contrast that with ArcGIS, we allow you to set permissions at the feature dataset and feature class level. In this case, you could simply make a connection as the SDECREATOR user in the Catalog pane of ArcMap, right click the desired feature dataset or class, and go to Manage > Privileges. As the data owner, you can grant privileges on that data to any user with just the standard data owner privileges on the database side that you mentioned above. Of course, the downside here, is that you would need to do this for all data so it could be a lot of work if there is a lot of data to set permissions to. The Change Privileges geoprocessing tool would help speed this up though, allowing changes to multiple datasets at once. If using ArcGIS to give permissions to your editors and viewers is not your desired workflow, that's OK. But I would recommend then that you use the SA user or another database administrator user to assign privileges to your users in SSMS. Keeping with the rule of least privileges that you guys are already following, this provides a level of checks and balances rather than giving your SDECREATOR user more privileges than they need. Some links on this below but let me know if you have any questions for me. Permissions (Database Engine) - SQL Server | Microsoft Docs  Privileges for geodatabases in SQL Server—Help | ArcGIS Desktop  Grant and revoke dataset privileges—ArcGIS Help | ArcGIS Desktop  Jonathan ... View more

Thanks for the update Vincenzo. Glad you got it sorted out! Jonathan ... View more

Hi Mark, You asked this question a while ago so I'm not sure if you've gotten this resolved at all? But if not, I do have some questions based on what you've written: You mention your Admin using the same MXD does not see this issue. Have you tried using a brand new MXD to see if the issue still occurs there? It sounds like you are using a publishing connection to Portal. If you use an Admin connection, do you still see the same behavior?  Do you know if this also happens with mixed case field names as well as upper case ones? We had a bug logged for 10.4.1 that was still present at 10.5.1 and dealt with mixed case field names and publishing to Portal. It is possible this is related. Jonathan ... View more

Hi Vincenzo, I'd suggest you look at / try a couple of things here: If you want to rule out an issue with TNS Names, try connecting using the EZConnect syntax instead. If this works with nothing else changing then we know there is an issue with TNS Names in some way. Make sure you are using a 12.1.0.2 client so that it matches your Oracle instance. Since you are connecting to ArcMap, you only really need the 32 bit client. But if you need the 64 bit client as well to use Pro or Server, just make sure it is listed before the 32 bit which I think you already have. Make sure the TNS configuration string is in TNSNAMES.ORA file of 32-bit Oracle client. ArcMap can't use information from the 64 bit client so they need to match here. If you can connect fine from SQL Developer (which I presume is a 64 bit install on your machine?) then I would guess the issue is related to the 32 bit client in some way. We just need to narrow it down a bit more. One more thing, this isn't related to your issue but you may be interested in installing it, we have a patch for 10.5.1 for some Oracle issues. See more below: Esri Support ArcMap 10.5 (10.5.1)  Jonathan ... View more

Thanks for letting me know Ben! Glad they were able to sort to the bottom of it. I believe the way you've described how things work in Pro is the way they designed it to work. That being said, a better error message could be helpful. You can always ask Esri Austrailia to speak with our Support team here and log an enhancement to Pro if you like on this issue. Jonathan ... View more

Michael, Yes, that is possible as well. Enterprise geodatabases automatically check the validity of each geometry when uploaded but they don't actively search out and fix invalid geometry once the data is loaded in. Jonathan ... View more

Bushtel Admin, ArcGIS Pro will throw this error if there are records in the table that have invalid geometry or are invalid in some other way. If this always happens at the same spot, it may be worth checking to see if this is the case in your situation. You can't run a Check Geometry on an Enterprise geodatabase but you can with a File geodatabase. It may be worth exporting this feature class out to a FGDB and running Check Geometry on it just to make sure. I don't know that this is the issue but it is where I would focus. Jonathan ... View more