arcgis pro crashes clicking on the parcel/shape

134
2
Jump to solution
12-04-2019 04:22 PM
RobertLogan
New Contributor II

Clicking on the parcel/shape in arcgis pro crashes.

We have a sql server view that represents a join between two tables.

Table parcels represent parcel shapes and Table situs represent situs data about each parcel

View definition v_parcel_situs

CREATE VIEW [gis].[v_parcel_situs]
AS
SELECT p.ojbectId, p.shape, s.mailingAddress

FROM gis.PARCEL p
LEFT JOIN gis.situs s ON gis.PARCEL.APN = gis.GISwebd2.APN

GO

CREATE TABLE [gis].[situs](
[APN] [int] NULL,
[mailingAddress] [nvarchar](max) NULL

) ON [PRIMARY]
GO

Everything is fine, but if I change the sql server schema column definition of MailingAddress to [nvarchar](50) NULL then clicking on the parcel/shape in arcgis pro crashes.

CREATE TABLE [gis].[situs](
[APN] [int] NULL,
[mailingAddress] [nvarchar](50) NULL

) ON [PRIMARY]
GO

0 Kudos
1 Solution

Accepted Solutions
RobertLogan
New Contributor II

I know SQL Server, but I'm new to ESRI products.

The ArcGIS enterprise geodatabase has metadata on the columns of registered views and tables.dbo.SDE_column_registry

Solution:

1.  delete the view from arcgis pro,

2. re-create the view

3  re-register with arcgis

4. re-publish any services that display data from that view

It would be nice if there was some logging and/or indication somewhere of the issue.  

View solution in original post

0 Kudos
2 Replies
George_Thompson
Esri Frequent Contributor

I would work with technical support on this.

Does the mailingAddress field have records with more than 50 characters?

--- George T.
0 Kudos
RobertLogan
New Contributor II

I know SQL Server, but I'm new to ESRI products.

The ArcGIS enterprise geodatabase has metadata on the columns of registered views and tables.dbo.SDE_column_registry

Solution:

1.  delete the view from arcgis pro,

2. re-create the view

3  re-register with arcgis

4. re-publish any services that display data from that view

It would be nice if there was some logging and/or indication somewhere of the issue.  

View solution in original post

0 Kudos