Latest Contributions by KimberlyGarbade

How are you making a copy of the map?  What steps are you using? ... View more

Sorry didn't notice the ArcMap 10.8 part....  If the three inputs into the Merge are all written to a file GDB or a single directory, and they are the only contents in that GDB or directory, you could create a submodel that used an iterator to step through each file in that GDB or directory and then use "Collect Values" to generate the input into your Merge. ... View more

Have you tried If Data Exists (Model Builder) If Data Exists (ModelBuilder)—ArcGIS Pro | Documentation ... View more

I don't know PostGRE SQL, but slow in SQL Server equals a few things to me.  Managing SQL Server logs to make them smaller and managing the geodatabase.  Is the GDB (traditionally) versioned and are their a lot of edits stored in the Delta tables?  Has it been a long time since your last rec/post?  That can slow you down... or is that what you mean by clearing the metadata history?  If its not that, it could be your Azure setup.  I don't manage our Azure account, but I know their are different tiers and resource limits and I know you can check your Metrics to see if you are maxing any of them out.  If you are you can scale up your resources (memory, number of cores, stuff like that).   ... View more

Could you provide your code so we can take a look?  ... View more

Hmmm... so no matter what the user chooses (like if  they type or choose "GIS_TMP") they are initially connected to the "CEAP_Routed_Output" database instead...  Here is a post that addresses a similar situation.  https://community.esri.com/t5/python-questions/python-script-using-arcpy-createdatabaseconnection/td-p/159152 I think it is saying that you have to fully quality the inputs your putting in your MakeValueArray.  For example rather than populating the array with SQL_SERVER you would use database_platform="SQL_SERVER".  I think the post is suggesting that since the optional inputs into the CreateDatabaseConnection_management function are being left blank, python needs the fully qualified inputs to know which array values are used to populate which parameters of the function.  Sounds just crazy enough to work. The only other thing I can think of is that when your using the function from the app it isn't overwriting a current connection file having the same name as the one you are creating; and that existing file is pointed at "CEAP_Routed_Output".  You might try setting overwriteoutput to true in your script or deleting any existing connection file with the same name in the same folder before creating the new one.    ... View more

See below for a link to the ESRI docs about connecting ArcMap to a SQL Server EGDB. Connect to Microsoft SQL Server from ArcGIS—ArcMap | Documentation I think every machine running ArcMap has to have the appropriate SQL Server drivers installed. Back when this was happening to me installing the SQL Native Client installed the drivers I needed (that was 4 or 5 years ago), but maybe today its just an SQL driver you get from Microsoft... about half way down the page is the title:  I would try installing the recommended SQL Server drivers again on the problem machine... maybe something has gone wrong with the drivers installed there already. The only other thing I can think of is that the user name and password might be wrong and the message you are getting is just generic for both errors (I.E. connection problems AND login problems)... but the UN and PW worked on the other computer so I doubt that's it. ... View more

You've probably checked this already, but when I used to get this error (back when we had an ArcObjects/C# custom add-in for ArcMap) updating the SQL Server Native client on the client machine would fix it.  I seem to remember you could download it from my.esri.com, going to downloads and picking your software version; then it would include the appropriate client for your version in the downloadable files. ... View more

Are the "Randomly Assigned" tables not even contained in the database you are connecting to?  Can you send images of success (in geoprocessing window) and failure (using the add-in)? ... View more

I think after some research, and I could be wrong here, so if I am please post a correction (I don't want to spread false info), the answers are: 1) Versioned views don't exist when you use branched versioning. 2) You cannot use a database (SQL) query to just pull the records you want out of the base tables directly in your DBMS (SQL Server in our case).  You have to direct your queries through the service (REST API). 3) The answer to the P.S. I'm a little more unsure of, but I think those records just stay in the base table, since it is assumed your never going to use it directly anymore (only access is through the service).  Maybe it is assumed the extra records its carrying around aren't a big deal... maybe you have to run some special API Service based Compress I haven't learned yet (now that I have to learn the REST API)...If anyone know the answer to this one I would still appreciate the info.  Thanks.   ... View more

If you absolutely have to use the same feature class I would use this scary method. BEFORE STARTING, BACK UP YOUR DATABASE FIRST AND ENSURE A RESTORE IS POSSIBE. Also I would experiment with a copy of your original data in a test environment or a file geodatabase before proceeding to a full implementation in production. Data safety is concern number one. That being said.  1. Use the "Split Line at Point" tool to create a new feature class. This should pretty much be the end result you want with the exception that it's a new feature class. You can stop here if you can use a different feature class, if not here is where the scary comes in...I almost hesitate to suggest it, so make sure you have a backup of the original data. If you have any concerns don't do it.  2. Select all line features in your original feature class and delete them. This will leave an "empty" feature class with all your attributes defined as you want them.  Deleting all your lines will be scary.  3. Use the "Load Data" tool in the Catalog Pane to load the lines from the feature class resulting from the "Split Line at Point" tool into the now empty original feature class. You'll have to use field mapping to match the fields up between the two, but that should be pretty easy since the fields should have the same names in both files.  Another note of caution here is that if you have related features linked to the original lines feature class, or other third party software linking to the lines, deleting all of those lines could have unpredictable and very negative consequences.  The only other way I can think of is to either program it in Arcpy or build it in Model Builder.  Either way you'll want to iterate through your points, going to each one, selecting the closest line to your point (using your search tolerance), and splitting the line at the point. Also something you should do in a test environment first after backing up your database.  ... View more

Sounds like a job for Arcade and Batch Calculation Rules to me.   I wrote this in a text editor so its not code ready to run, but it should look something like this I think: var intRoomNum = $feature.RoomNumber var pntGeom = Geometry($feature) var fcRooms = FeatureSetByName($datastore, 'PolygonFloorPlanCall', ["globalId", "RoomNumber"],true) var ftJustOneRoom = filter(fcRooms, "RoomNumber = @intRoomNum") if (ftJustOneRoom == null){ return pntGeom } else { return Centroid(ftJustOneRoom) } Here is a great link to something very similar: https://www.youtube.com/watch?v=HFHJFCn2E1M Hope this helps.   K ... View more