POST
|
Final update on this thing. Thanks A TON! The script now runs in 10 seconds!
... View more
03-13-2025
08:06 AM
|
1
|
0
|
388
|
POST
|
Never mind, I read that wrong. I see what you're talking about. Thanks!
... View more
03-12-2025
08:00 AM
|
0
|
1
|
431
|
POST
|
I'll give that a try. I'm curious if you could explain why that makes a difference? Isn't it just a string?
... View more
03-12-2025
07:45 AM
|
0
|
2
|
433
|
POST
|
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])))
... View more
03-11-2025
04:51 PM
|
0
|
5
|
498
|
POST
|
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.
... View more
02-13-2025
09:16 AM
|
1
|
0
|
260
|
POST
|
The solution was marked, we had to adjust the account
... View more
01-29-2025
08:58 AM
|
0
|
0
|
300
|
POST
|
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?!
... View more
01-21-2025
08:44 AM
|
1
|
0
|
875
|
BLOG
|
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?
... View more
01-14-2025
04:03 PM
|
0
|
0
|
1602
|
POST
|
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!
... View more
01-13-2025
02:45 PM
|
2
|
2
|
937
|
POST
|
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.
... View more
01-09-2025
08:08 AM
|
2
|
3
|
1716
|
POST
|
The data lives on a high availability SQL Server, the data does not go offline.
... View more
01-06-2025
08:45 AM
|
0
|
0
|
1014
|
POST
|
We’re at 30% or so. We checked that and CPU, they seem well. The CPU sits around 30-40%
... View more
01-05-2025
11:04 AM
|
1
|
0
|
1075
|
POST
|
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.
... View more
01-04-2025
11:42 AM
|
2
|
10
|
1309
|
POST
|
I'm not seeing it on my dashboard... it's working correctly
... View more
12-19-2024
11:53 AM
|
0
|
0
|
400
|
POST
|
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?
... View more
11-20-2024
09:33 AM
|
1
|
0
|
609
|
Title | Kudos | Posted |
---|---|---|
1 | 03-13-2025 08:06 AM | |
1 | 02-13-2025 09:16 AM | |
1 | 01-21-2025 08:44 AM | |
2 | 01-13-2025 02:45 PM | |
2 | 01-09-2025 08:08 AM |
Online Status |
Offline
|
Date Last Visited |
05-20-2025
09:00 AM
|