Latest Contributions by RandyBonds_Jr_

‎03-13-2025

Final update on this thing. Thanks A TON! The script now runs in 10 seconds!

‎03-12-2025

Never mind, I read that wrong. I see what you're talking about. Thanks!

‎03-12-2025

I'll give that a try. I'm curious if you could explain why that makes a difference? Isn't it just a string?

‎03-11-2025

I have the following code that will take around 12 Hours in insert 7,000 rows. I have no idea why it is so slow. the routeRunRows is just a dictionary from an oracle database (cursor.fetchAll() using the oracledb library). When I run the loop without the arcpy.da.InsertCursor it take seconds (which makes sense). Any help would be appreciated. for row in routeRunRows: if (x%1000) == 0: message = str(x) + ' Processed...'; show_py_message() x += 1 with arcpy.da.InsertCursor("d:/projects/SolidWaste/SolidWaste.sde/SolidWaste.DBO.cayServiceOrders", ["RouteNumber","RouteDescription","StartDate","RouteOrder","StreetAddress","ServiceItemType","SerialNumber","X","Y","ItemUse","RouteNote","AccountNumber","AccountStatus","ServiceItemID","SHAPE@XY"]) as insertSO: routeNote = " " if row[10] is not None: routeNote = row[10][:120] insertSO.insertRow((row[0],row[1],row[2],row[3],row[4],row[5],row[6],row[7],row[8],row[9],routeNote,row[11],row[12],row[13],(row[7],row[8])))

‎02-13-2025

We added a portaladmin account with the exact same username as the windows user (who is an admin on that server). For us, we used gisadmin as the username. I only say this because there is another issue with special characters, so you don't want to use those.

‎01-29-2025

The solution was marked, we had to adjust the account

‎01-21-2025

We had most of our services that way, a newer one that kind of took off was the real one that we made dedicated. Tuning is never ending, right?!

‎01-14-2025

Is there any kind of basic formula that we could use to start out? Something along the lines of: You have 150 ArcSocs, so you should have x CPUs and x Memory?

‎01-13-2025

Wanted to provide an update to this ongoing issue. We MAY have solved it. Steps taken: Doubled the vCPUs used to 12 Upped shared instance pool to match the change (ESRI recommends 50% of vCPU count) Removed some unused services Tuned other highly used services (mostly making them dedicated instead of shared) Found a backup job that was running weekly that may have caused slowness, but because of vCPU change, it's unclear if this is part of the issue. Right now, I'm at 9 days uptime... here's hoping it's the end of this!

‎01-09-2025

This is what ended up working for us: The name of the portal admin and the windows users (ours is a domain account) had to match. Once we did that, we were able to upgrade with no issue.

‎01-06-2025

The data lives on a high availability SQL Server, the data does not go offline.

‎01-05-2025

We’re at 30% or so. We checked that and CPU, they seem well. The CPU sits around 30-40%

‎01-04-2025

About every seven days or so our services stop serving data and I have to restart the ARCGIS server service. this happened after the upgrade to 11.3. We have set the logs to debug and don’t see anything wrong. just shooting the south there to see if anyone has ideas or suggestions. We’ve talked to support and they’ve been little to no help.

‎12-19-2024

I'm not seeing it on my dashboard... it's working correctly

‎11-20-2024

I had a similar experience when I upgraded to 11.3. I put in a ticket with ESRI and they sent me a batch file that fixed the issue. It was super quick. Maybe it'd work?

Online Status	Offline
Date Last Visited	3 weeks ago

My Ideas

Latest Contributions by RandyBonds_Jr_

Re: da.InsertCursor super slow

Re: da.InsertCursor super slow

Re: da.InsertCursor super slow

da.InsertCursor super slow

Re: Portal 10.9.1 to 11.2 Upgrade Postgres Failure

Re: Portal 10.9.1 to 11.2 Upgrade Postgres Failure

Re: Server service needs restarted every 7 days or so

Re: ArcGIS Server Performance Strategies

Re: Server service needs restarted every 7 days or so

Re: Portal 10.9.1 to 11.2 Upgrade Postgres Failure

Re: Server service needs restarted every 7 days or so

Re: Server service needs restarted every 7 days or so

Server service needs restarted every 7 days or so

Re: ArcGIS Dashboards Arcade Data Expression not working after update

Re: Basemaps not loading in ArcGIS Pro 3.4.0 or Enterprise 11.1

Re: da.InsertCursor super slow

Re: Portal 10.9.1 to 11.2 Upgrade Postgres Failure

Re: Server service needs restarted every 7 days or...

Re: Server service needs restarted every 7 days or...

Re: Portal 10.9.1 to 11.2 Upgrade Postgres Failure

Web AppBuilder Custom Widgets

ArcGIS Server with JavaScript API

GeoGeeks