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