topic Re: Apostropes in a Record Name in ArcGIS Parcel Fabric Questions

Apostropes in a Record Name

JonathanMcDowell1 — Tue, 13 Aug 2019 19:41:19 GMT

Has anyone encountered issues with an apostrophe in a record name causing ArcGIS Pro to crash? When I create a record named Merrill's Subdivision ArcGIS Pro crashes. When I name the new record Merills Subdivisions ArcGIS Pro does not crash.

Re: Apostropes in a Record Name

rachelg_esri — Tue, 13 Aug 2019 20:28:18 GMT

Hello Jonathan!

I haven't heard any particular situation similar to what you describe, but the one thing I can think of is I know some softwares do use special characters instead of plain text quotation marks... If you copy the text, paste it into something like Notepad (which should strip out or convert special characters), then copy and paste it back into the row again, do you see the same behavior? If you re-add the quotation mark yourself by editing the table in Pro, do you crash again?

Thanks!

Rachel

Esri Support Services

Re: Apostropes in a Record Name

JoeBorgione — Tue, 13 Aug 2019 20:32:43 GMT

Like Rachel, I've never seen a crash, but the only special character I've ever allowed in any data base I've managed is the under_score. Nothing else....

Re: Apostropes in a Record Name

JonathanMcDowell1 — Tue, 13 Aug 2019 21:32:37 GMT

If I enter the name into the Manage Records document as so..

ArcGIS Pro crashes.

If I enter it this way it will not crash.

I want to use the correct legal name for the subdivision. The subdivision is supposed to belong to Jonathan not imply several Jonathans.

Re: Apostropes in a Record Name

rachelg_esri — Tue, 13 Aug 2019 21:41:01 GMT

Hello Johanthan,

Thank you for those screenshots! Can you verify where this data is stored? Is it inside a file geodatabase, an enterprise geodatabase...? If an enterprise geodatabase, what is the RDBMS name and version? (ex. SQL Server 2012, Oracle 12.1.0.2, etc.)

What version of ArcGIS Pro are you on now?

Thank you!

-- Rachel

Re: Apostropes in a Record Name

JoeBorgione — Tue, 13 Aug 2019 22:15:23 GMT

What is the Manage Records document? A table? A feature class? Something else?

While it made me cringe, I added the word Jonathan's to a feature in a file geodatabase without a problem. Also added an apostrophe to a non-versioned EGDB table without a crash as well.

I appreciate your need for a possessive legal name, as opposed to the implication of plurality, but as you have seen, special characters can be problematic. Just sayin'...

Re: Apostropes in a Record Name

JonathanMcDowell1 — Tue, 13 Aug 2019 22:18:45 GMT

I am using ArcGIS Pro 2.4.1. The parcel fabric is in a file geodatabase.

Re: Apostropes in a Record Name

JonathanMcDowell1 — Tue, 13 Aug 2019 22:24:34 GMT

This issue has to do with the new Parcel Fabric in ArcGIS Pro. The pane is for creating and managing parcel records. My educated guess leads me to believe this is on the application side, not the database side.

Re: Apostropes in a Record Name

JoeBorgione — Tue, 13 Aug 2019 22:28:20 GMT

Good to know: we have an agency considering migration to parcel fabric; I'd place my bet is on your educated guess....

Re: Apostropes in a Record Name

rachelg_esri — Wed, 14 Aug 2019 17:16:24 GMT

Thank you for that information, Jonathan! I just tried adding an apostrophe to the Name field in a record on my end in Pro 2.4.1 and had no problems, so I don't think this is a widespread issue.

Do you have any other machines with Pro installed? Can you try the workflow there with the same data?

Does this happen with any other parcel fabrics, if you have any others?

Thank you!

Re: Apostropes in a Record Name

JonathanMcDowell1 — Wed, 14 Aug 2019 18:20:10 GMT

The answer to all of your questions is yes. I used a different computer and used a different parcel fabric and ArcGIS Pro still crashed.

Re: Apostropes in a Record Name

AmirBar-Maor — Fri, 16 Aug 2019 07:38:52 GMT

I managed to reproduce it on 2.4 and it looks this is already addressed in the unreleased version 2.5.

We will check the possibility of fixing it for 2.4.x.

Why go back and fourth on GeoNet where this can be logged and reproduced quickly with a technical support analyst? After all it can be specific to your data, DBMS, DBMS client and other variables.

Any good experiences to share?

Re: Apostropes in a Record Name

AmirBar-Maor — Wed, 28 Aug 2019 10:10:54 GMT

The crash has been fixed and will be delivered with ArcGIS Pro 2.4.2. All ArcGIS Pro users will see a notification about the availability of download and update Pro 2.4 or 2.4.1 when it gets pushed out in a few weeks.

It is great to hear that you find editing parcels in ArcGIS Pro 'improvement over ArcMap'. More great things to come with the 2.5 release... Did anyone say spirals?

Re: Apostropes in a Record Name

JoeBorgione — Wed, 28 Aug 2019 14:15:07 GMT

Any leaks on a release date for 2.5?

Re: Apostropes in a Record Name

AmirBar-Maor — Wed, 28 Aug 2019 18:36:30 GMT

ArcGIS Pro is released twice a year, usually once around the user conference and another time usually 6 months there after.

Final release dates are usually determined close to the planned release date.