SQL view not accessible in Catalog

55
3
Jump to solution
06-27-2018 06:20 AM
Highlighted
New Contributor II

At some point in the past I've written a SQL view (pulling data from a linked server) within my main Geodatabase to use in ArcGIS, these function properly.  Now I have a need for more information from the same server so I wrote more views, however I cannot access or even preview them Catalog, but I can see them in the catalog tree.

Did I miss something in the process?  I've compared the script I used to create each and there isn't anything standing out as different to me.  Any insight is greatly appreciated.

Tags (1)
0 Kudos
1 Solution

Accepted Solutions
Highlighted
New Contributor II

Problem solved!!!  some of the table names exceeded 31 characters, which prevented ESRI software from reading.  The final answer was to add an "as" statement.

[rate_code_description_sanitation] as rate_code_desc_sani,

View solution in original post

3 Replies
Highlighted
Esri Esteemed Contributor

ArcGIS won't preview tables that contain unsupported datatypes. Please provide a more complete description of the view SQL with a complete description of the member tables.

- V

0 Kudos
Highlighted
New Contributor II

I'm not sure what you mean by a more complete description.  Here is the script I used to create this view:

create view [dbo].[vw_Sanidata] as
SELECT [location_id],
[parcel_num],
[location_class],
[account_num],
[name],
[address],
[service_sanitation],
[rate_code_sanitation],
[rate_code_description_sanitation],
[rate_code_amount_sanitation]
FROM [server].[database].[dbo].[ud_gis_sanitation_data]

Here is the script from the process that created a similar table that works properly:

create view [dbo].[vw_waterdata] as
select [location_id],
[location_class],
[parcel_num],
[address],
[rate_code_water],
[rate_code_description_water],
[rate_code_amount_water],
[service_wellhead],
[rate_code_wellhead],
[rate_code_description_wellhead],
[rate_code_amount_wellhead],
[rate_code_sewer],
[rate_code_description_sewer],
[rate_code_amount_sewer],
[rate_code_fireline],
[rate_code_description_fireline],
[rate_code_amount_fireline]
from [server].[database].[dbo].[ud_gis_water_data]

Does this help?

0 Kudos
Highlighted
New Contributor II

Problem solved!!!  some of the table names exceeded 31 characters, which prevented ESRI software from reading.  The final answer was to add an "as" statement.

[rate_code_description_sanitation] as rate_code_desc_sani,

View solution in original post