nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

SQL view not accessible in Catalog

LancasterGIS

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.

Najděte více příspěvků označených jako

Accepted answers

LancasterGIS

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,

All comments

LancasterGIS

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,

LancasterGIS

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?

VinceAngelo

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

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Všechny komunity
Nedávné příspěvky
Sledovaný obsah
Pomoc komunity

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.