AnsweredAssumed Answered

arcgis pro crashes clicking on the parcel/shape

Question asked by robert.logan.asr.dev on Dec 4, 2019
Latest reply on Dec 5, 2019 by robert.logan.asr.dev

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

Outcomes