POST
|
Do both table's fields get converted to Text and that is why the join succeeds? Yes, I believe that's what's happening. They don't get converted until the view is added to ArcMap as a Query Layer. What is the version of the enterprise geodatabase (sde)? The enterprise geodatabase is SQL Server Enterprise Edition (64-bit) version 10.50.6220 SP3 Are both tables registered with the geodatabase? No. We are using the SQL Server geometry data type. I wish I could register them, however, our DB is structured without the use of SDE
... View more
03-02-2018
01:31 PM
|
0
|
5
|
2469
|
POST
|
Thanks Supriya. So what I've noticed is if I add both tables to ArcMap, the join will succeed. However, if I add only one table and try to join to a table through a database connection, I cannot select the field that I need to join with from the second table. The list of available fields is reduced, and each of those fields are Type:Text. Hopefully this workflow description makes sense.
... View more
03-02-2018
11:39 AM
|
0
|
7
|
2469
|
POST
|
I'm currently trying to work with some tables within SQL Server that have GUID fields. I'm running ArcGIS Desktop 10.3.1 and pulling the data through a standard database connection. When I look at the table properties within ArcCatalog the GUID fields are listed as Data Type: GUID. However, when I load them into ArcMap, they show as data type: String. This is causing problems when I then try to join the query layer to another table in the database that has a matching foreign key field (that is GUID as well). Any thoughts on this? I also notice that when I add DB Spatial Views to ArcMap I have to identify a unique identifier field in the query layer. However, a table does not require this. The tables have indexed fields, so this might be the reason, but wanted to be sure. This might be a separate topic than above though.
... View more
03-02-2018
10:55 AM
|
0
|
11
|
4070
|
POST
|
It worked like a champ once I added the GIS Server account to the DB, and defined select permissions. Thanks again for the clarification Adam
... View more
01-05-2018
11:37 AM
|
3
|
0
|
1076
|
POST
|
Thanks for the quick response Adam. I'll give that a try. I was just assuming that the initial account used to make the DB connection would transfer when publishing the service. It makes sense that the account running ArcGIS Server would make the connection once published.
... View more
01-05-2018
09:18 AM
|
0
|
0
|
1076
|
POST
|
Is there a way to create a windows authenticated connection to SQL Server using a different account that is logged onto the client? I'm trying to build a map service that connects to data in SQL Server which has windows authentication only. A domain service account is the preferred choice for connecting to the data rather than using my personal domain account. I was hoping to use the "Create Database Connection" tool/script, however it doesn't allow me to enter domain account credentials when generating the connection file. Any ideas?
... View more
01-05-2018
08:46 AM
|
0
|
3
|
1683
|
POST
|
Michal, I'm totally ashamed to admit it, but in my case I thought IIS was installed when in fact it wasn't. I had installed ArcGIS Server first, used it for a bit, then wanted to open it up to the outside. I was assuming that IIS was installed because it used to be a requirement for older versions of AGS. I've also run into similar situations as Carlos mentions below where I has to bust open the MSI and extract the EXE in order to get it installed. It all depends on security policy within your network. Good luck!
... View more
01-02-2018
12:32 PM
|
0
|
1
|
791
|
POST
|
I'm having the same problem. WinServer 2012 R2, IIS 8, ArcGIS Server 10.5 I've tried everything, and cannot get the Web Adaptor to install. Even tried installing silently. No helpful Event logs, no ArcGIS Server logs, nothing to help figure out why it won't install.
... View more
10-03-2017
09:10 AM
|
0
|
5
|
791
|
POST
|
Jake, So I've tinkered with this a bit more, and I'm getting the results I'm looking for by doing selections on the features or geometry, then clicking the relationship class under Related Tables in the Table window. Do you happen to know if this workflow is accessible in Python? Searching for geoprocessing tools within ArcGIS Desktop doesn't yield anything beyond the building of relationship classes. I essentially want to build some tools the allow the user to do some basic querying, and which results in the selection and display of related features/records. The problem is, I have to work within the dekstop environment at the moment.
... View more
03-15-2017
12:33 PM
|
2
|
0
|
2630
|
POST
|
Thanks Jake. That works. I'll do some more testing, and maybe come back with some more questions. I appreciate the feedback.
... View more
03-01-2017
07:23 AM
|
0
|
0
|
2630
|
POST
|
So looking at it a little more, I'm still not finding anything that answers my question. I'm working within ArcGIS Desktop so using a Web App Query Widget won't be an option. For years I've used Select By Attributes, and Definition Queries to parse out different pieces of data that have similar attributes. Why can't these tools reach through a relationship class to all of the data? Going back to my Blocks and Parcels example, suppose there many parcels being owned by a single person. I'd like to select or query out only those parcels (without adding an owner field to parcels and mass populating it with redundant owner names). Or another example would be, I'd like to select/query for all blocks that owner "John Doe" or "Sally Smith" has property in. I hope what I'm saying makes sense, because I'd really like to benefit from the relational data that we're assembling.
... View more
03-01-2017
06:04 AM
|
0
|
3
|
2630
|
POST
|
Thanks Jake. I think I'll need to look at it a little more. I think what I'm trying to come up with is a way to run some canned queries based on common values within the related data, and have these queries embedded within a geoprocessing model or python script. Then I can attach to a tool, and give the end user some basic query/display capability to look at how the data is related with each other.
... View more
02-27-2017
01:06 PM
|
1
|
0
|
2630
|
POST
|
I'd like to be able to do some basic queries on the related data through ArcMap. Currently when I try to do a definition query, there's no option to access the related data. Basically my question is, once the relationship classes are created, what can we do with them?
... View more
02-27-2017
01:01 PM
|
1
|
1
|
2630
|
POST
|
I can't seem to find anything that describes what to do with relationship classes once they are built. Until now, all I can do is identify on the features in ArcMap, then click through the tree structure within the identify window in order to see the related records. That's fine, but what about the ability to query the related features/records? For instance, suppose you had a relationship class built for relating city blocks to the parcels within them. I'd like to build a query to show all parcels that are "related" to a particular city block. I just can't seem to find any guidance on doing these types of queries. Thanks in advance.
... View more
02-27-2017
10:56 AM
|
0
|
15
|
8053
|
POST
|
I ended up figuring out the problem. It's a long story so I'll try to explain all that I found and resolved. It goes back to your original question of whether or not I could validate the federated server. Apparently the instance of ArcGIS Server was not completely federated with Portal in my case. Even though I could validate it through the Portal Home page ( i.e. /home/organization.html and selecting the "Servers" tab). (Pardon the rambled dump of information that is about to follow, but I pulled it from my notes which aren’t written as a well-developed story.) I think it stems back to some issues I was having with getting certificates loaded properly on the server. At that time I was getting an error "Invalid SSL certificate found. PKIX path building failed..... ". We ended up having to enable client certificates using a NETSH command (our resident server admin took care of it so I don't know all the details). After which federating through the Portal Home page still wasn't working, so I dug into it a bit more. In the Portal logs there was a 403 "not accessible" error associated with a link to the ArcGIS Portal Directory (i.e. /sharing/portals/self/servers/register). On a whim I tried navigating to that link within a browser. I noticed that it gives all of the same options to federate a server as the Portal Home page did. I entered the information, checked "is hosted" to true, and clicked "register". When I went back to the Portal Home federation page the server was now federated and listed as the hosting server. Clicking "Validate Server" verified that all appeared to be configured properly. Well when I tried a test in portal (add a zipped shape file and publish as feature layer), another error occurred. This time it was “Failed to publish item…….exception. Hostname in certificate didn’t match”. To get past this I had to export the certificate used to configure https site bindings within IIS (root certificate with the private key), then import the certificate through the ArcGIS Server Administrator Directory (Home>machines>”machine name”>sslcertificates>importexistingservercertificate). After that I was able to finish configuring the server to use the new certificate for SSL. This finally brings us to the error that I originally posted. The site wouldn’t publish a feature layer (Failed to publish item….. .zip …… could not decrypt token. Token may not be valid”. While doing some digging I found out that it’s possible to import all services within a federated server using the ArcGIS Server Administrator Directory (Home>Services>Supported Operations>federate). However, this wasn’t an option on my page. This is what lead me to believe that the server wasn’t completely federated. So I then unregistered the server federation through the ArcGIS Portal Directory (REST endpoint). Then going back to the Portal Home page I was finally able to federate the server properly. Testing proved that a feature layer could now be published. Again apologies to all for the long winded info dump. I just wanted to throw it out there in case anyone else runs into the same problem.
... View more
12-13-2016
12:00 PM
|
3
|
1
|
3630
|
Title | Kudos | Posted |
---|---|---|
1 | 02-13-2024 08:34 AM | |
1 | 02-28-2024 11:51 AM | |
1 | 02-12-2024 12:55 PM | |
2 | 02-12-2024 12:43 PM | |
1 | 08-21-2020 01:00 PM |
Online Status |
Offline
|
Date Last Visited |
04-04-2024
09:01 PM
|