What, precisely, is the data source of a query layer?

694
4
08-14-2017 10:46 AM
by Anonymous User
Not applicable

I have a query layer that won't publish.

This is the data source of the query layer

C:\Users\#####\AppData\Roaming\ESRI\Desktop10.3\ArcCatalog\#####_15473216B.sde\proj_15473216B."#####\#####".%Latest LNAPL Thisckness_1

There is a table called "Latest LNAPL" in the database that I can see just fine.

AGS Manager log is saying it can't find "Thisckness_1" (misspelling in original).

This is a dumb newbie question:

The layer is actually perfectly fine and I can see it in the mxd. Can some one explain what "Thisckness_1" refers to? I was hoping I could see it in the sde connection, but I can't. I do see the table.

I need "Thisckness_1" to be in a registered database so I can get it to publish, but I just don't know exactly what the darn thing is or how to get at it.

Thank you,

0 Kudos
4 Replies
VinceAngelo
Esri Esteemed Contributor

The data source of a query layer is a query against a database table (or set of tables) which returns one or more rows that have a rowid column and a geometry.

Tables cannot have spaces in their names (nor can columns), so your table is not named "Latest LNAPL" -- This might be the layer name (Table of Contents identifier, which can contain spaces).  If you right-click to bring up the layer properties, then click on the "Source" tab, then press the "Change Query" button, you will see the full content of the SQL query (in the form "SELECT column_list FROM table_list [join_clauses] [WHERE where_clause]").  This is your source SQL.

If the layer fails to validate because the table "Thisckness_1" is not present, then either:

  1. The table is not present or,
  2. You connected with a different login which can't see the original table (i.e., the table is not present)

- V

by Anonymous User
Not applicable

Thanks. I think what it presents as the data source is confusing. This: Latest LNAPL Thisckness_1 is (as you explained) not a table. Frankly, I don't know what it is exactly - some virtual name maybe out of date, kind of like an old sde connection file name that you get when you ask for a data source with arcpy....

I reloaded the data from the database and it still won't publish. I may have a permissions issue or something contacting my db administrator.

Thanks for your input.

0 Kudos
MicahBabinski
Occasional Contributor III

Hi Randy,

Two other things you may wish to check:

1. Make sure your ArcGIS Server account has read access to that DBMS workspace, and

2. The 64-bit version of your DBMS native client is installed on each server machine in your site

This stuff is described here in the AGS documentation:

About registering your data with ArcGIS Server—Documentation (10.3 and 10.3.1) | ArcGIS for Server 

MicahBabinski
Occasional Contributor III

Which version of ArcGIS Server are you using? Are you enabling feature access (aka publishing it as a feature service)? Finally, when you went to publish, did the "Analyze" step of the publishing workflow yield a specific error message which would indicate why the data would not publish? You mentioned the ArcGIS Server logs but was wondering if there was any information given in the publishing wizard.

Micah