|
POST
|
I think the problem is an annotation feature class. The annotation FC gets automatically copied with the main point FC due to a relationship class. The reason I think the problem is the annotation FC: I can add the annotation FC to a map without errors. And the annotations show up in the map if I zoom in. However, when I open the attribute table and navigate to the last row, I get an error: Bud_0-1713368039479.png Failed to load data. Error: Shape integrity error I haven't determined the cause of that error yet.
... View more
04-17-2024
08:35 AM
|
0
|
0
|
5505
|
|
IDEA
|
ArcGIS Pro 2.9.12; File Geodatabase: I have a feature-linked annotation FC. When I create new annotation features for existing lines, I need to manually populate the annotation's Feature ID field in order to link the annotation feature to the line feature. Idea: Instead of manually entering the Feature ID, click the existing line to automatically create a linked annotation. Video:
... View more
04-17-2024
08:23 AM
|
0
|
1
|
939
|
|
IDEA
|
ArcGIS Pro 2.9.12; Oracle 18c 10.7.1 EGDB: As far as I can tell, there isn't a way to determine in the Catalog properties if an annotation feature class is feature-linked or not. Could that functionality be added? If I understand correctly, the presence of a relationship class doesn't necessarily indicate that the annotation is feature-linked.
... View more
04-17-2024
08:07 AM
|
0
|
5
|
1155
|
|
IDEA
|
ArcGIS Pro 2.9.12; File Geodatabase (and Oracle 18c 10.7.1 EGDB): I've created an annotation FC using the Create Feature Class wizard in Catalog: Bud_0-1713366059131.png The annotation FC is shown as SHAPE = Polygon in the attribute table. Bud_1-1713366059477.png Idea: Show the SHAPE as Annotation, not Polygon. I think that would be more intuitive. Related: Annotation shown as SHAPE=Polygon in attribute table
... View more
04-17-2024
08:03 AM
|
0
|
1
|
835
|
|
POST
|
ArcGIS Pro 2.9.12; file geodatabase: I have a line FC and a feature-linked annotation FC. When I create a line, an annotation feature gets automatically created, which is expected. But the annotation feature's STATUS field is 'Unplaced'; an annotation is not displayed in the map. How can I place an unplaced annotation in ArcGIS Pro? Video:
... View more
04-17-2024
07:52 AM
|
0
|
2
|
1910
|
|
POST
|
ArcGIS Pro 2.9.12; File Geodatabase (and Oracle 18c 10.7.1 EGDB): I've created a feature-linked annotation FC using the Create Feature Class wizard in Catalog: Bud_0-1713361349541.png Why is the annotation FC shown as SHAPE = Polygon in the attribute table? Bud_2-1713361411112.png I would have expected the SHAPE to be Annotation, not Polygon.
... View more
04-17-2024
06:44 AM
|
0
|
3
|
1656
|
|
POST
|
I found Route Event Layers were extremely slow in some versions of Pro, like 2.9.12. Removing the geoprocessing history from the FC metadata helped a lot, but it was still slow compared to other versions, so it was clearly a bug. Route Event Layers — Slow performance in ArcGIS Pro 2.9.12, but not in 2.6.8 Maybe upgrading to a newer version of Pro would help.
... View more
04-16-2024
06:42 PM
|
0
|
0
|
3687
|
|
POST
|
I don't like your join: FROM FCS.FCS_LICENSES,
FCS.FCS_ESTABLISHMENTS,
FCS.FCS_LICENSE_OWNERS,
FCS.FCS_LOCATIONS,
FCS.FCS_CITIES,
FCS.FCS_ZIP_CODES It looks like you're doing a CROSS JOIN/cartesian product, and then narrowing down the results in the WHERE clause. The commas in you SQL are basically CROSS JOINs. Comma-separated join (cross join) You should be using a LEFT [OUTER] JOIN or an [INNER] join. https://oracle-base.com/articles/misc/sql-for-beginners-joins If you're rusty with SQL, you could mock up the query in MS Access using the graphical query builder, then grab the auto-generated SQL and convert it to Oracle SQL for the query layer in Pro. (To bring the data into Acess for testing, you could either export the data from Pro and import into an access database. Or set up an ODBC connection and dynamically connect to the Oracle data in Access.)
... View more
04-16-2024
06:06 PM
|
0
|
2
|
3045
|
|
POST
|
Most query layer issues are caused by duplicate IDs or nulls in the unique ID column. Especially when the error is something like the one you mentioned: "failed to retrieve a page of rows." I suggest running the query in a SQL client like SQL Developer or Toad, and checking for duplicate IDs or nulls in the unique ID column there. The reason I suggest using a SQL client for that check, not ArcGIS Pro, is that Pro automatically excludes duplicate rows, which is misleading and not helpful when troubleshooting issues like this. If you are having trouble finding a truly unique id column in your data for the query layer, use Oracle's ROWNUM pseudo column: SELECT CAST(ROWNUM AS INT) AS UNIQUE_ID, Related: Record counts - publishing from ArcGIS Pro vs ArcGIS Desktop (ArcMap) Also, ArcGIS Pro 2.0.7 is beyond ancient. I don't envy you. I thought my organization's 2.6.8 environment was bad. Newer versions are slightly better at handling query layer result sets.
... View more
04-16-2024
05:53 PM
|
0
|
3
|
3046
|
|
POST
|
ArcGIS Pro 2.9.12; Oracle 18c 10.7.1 EGDB; SDE.ST_GEOMETRY: I'm troubleshooting an issue where I can't copy/paste a point FC via Catalog within the same enterprise geodatabase. Copying to a file geodatabase or a mobile geodatabase doesn't work either. But copying to a personal geodatabase in ArcMap does work. Find & repair problem ST_GEOMETRY rows — "Shape integrity error" I get this error: Bud_1-1713299059841.png Copy Failed Message [Error]: ERROR 000260: Shape integrity error Failed to execute (CopyMultiple). That error message mentions something called "CopyMultiple". Is CopyMultiple a geoprocessing tool? I don't see any geoprocessing tools listed in the Geoprocessing Pane in Pro with that name.
... View more
04-16-2024
01:25 PM
|
0
|
4
|
1959
|
|
POST
|
For my notes: This issue also applies to ArcGIS Pro 2.9.12.
... View more
04-16-2024
12:41 PM
|
0
|
0
|
5530
|
|
IDEA
|
ArcGIS Pro 2.9.12; Oracle 18c 10.7.1 EGDB; SDE.ST_GEOMETRY: When I make table design changes to a EGDB FC, I have a workflow where I make a backup to a FGDB. In the Catalog Pane, I copy the EGDB FC and paste it into an FGDB. The benefit of copying/pasting via Catalog is that all GDB functionality gets preserved in the copy, including domains, an entire feature dataset, etc.. It's an easy way to back up a FC (or FD) and everything that comes with it, compared to using GP tools that are clunkier to use and strip out some GDB functionality. That workflow generally goes smoothly. But there are cases where I want to exclude some rows from the copy FC. For example, I have an issue where I can't copy a line EDGB FC to a FGDB. I get an error: Bud_0-1713291893489.png Copy Failed Message [Error]: ERROR 000260: Shape integrity error Failed to execute (CopyMultiple). (My current workaround is to copy to a personal GDB via ArcMap, then from the PGDB to the FGDB. I don't get the error that way. But that workaround won't be possible when I lose ArcMap; using an intermediary mobile geodatabase instead of a PGDB doesn't seem to work.) I have that issue in ArcMap 10.7.1, Pro 2.6.8 and 2.9.12. Find & repair problem ST_GEOMETRY rows — "Shape integrity error" I don't know what the problem is in that FC. And I can't check or fix the FC using ArcGIS Pro functionality because the Repair Geometry geoprocessing tool doesn't support SDE.ST_GEOMETRY. So, I want to try excluding some rows when copying the FC. Such as WHERE SHAPE IS NOT NULL. I was hoping there would be a SQL expression section in the Paste Special dialog. But there doesn't seem to be anything like that. Hint: There is a bug in 2.9.12 where an FGDB's right-click menu doesn't show the Paste Special option. Use CTRL+ALT+V as a workaround. Resolved by at least 3.2.2. Idea: When copying/pasting via the Catalog Pane, filter rows via an SQL expression in the Paste Special dialog.
... View more
04-16-2024
11:50 AM
|
0
|
0
|
572
|
|
IDEA
|
ArcGIS Pro 2.9.12: In the Catalog Pane > Project tab: I want to move the Folders item (via drag-and-drop) so that it is positioned above the Databases item. Bud_0-1713294907109.png Use case: Easily copy/paste GDB items from an EGDB to a FGDB, without collapsing the Databases or Folders items when navigating between geodatabases. Details: I want to keep the Folders item and the Databases item expanded at all times. But the Databases item is very big when a given EGDB connection is expanded (hundreds of FCs and tables). So the Databases item is in the way when I want to navigate to the Folders item, which is smaller (just a handful of GDBs/FCs/tables). I want to put the smaller item (Folders) above the larger item (Databases) so that I can easily navigate between the two items. Idea: Could drag-and-drop/move functionality be added to the Catalog Pane > Project tab for root items?
... View more
04-16-2024
10:56 AM
|
1
|
0
|
3388
|
|
POST
|
Related: Store multiple Projects/APRXs in the same folder? (considering the auto-created supported files and folders)
... View more
04-15-2024
12:06 PM
|
0
|
0
|
2814
|
|
POST
|
It's my understanding that ArcGIS Pro automatically creates supporting files and folders in the same location that the Project/APRX is located. Is it ok to store multiple Projects/APRXs in the same folder? Or should each Project be stored in a separate folder to avoid conflicts with the supporting files? Related: Copying .APRX in File Explorer — Copy supporting files and folders too?
... View more
04-15-2024
12:04 PM
|
2
|
1
|
1532
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 03-20-2026 02:12 PM | |
| 1 | 03-19-2026 11:42 AM | |
| 1 | 06-03-2026 04:02 AM | |
| 1 | 03-18-2026 07:08 PM | |
| 2 | 07-08-2026 01:29 PM |