Latest Contributions by RexRobichaux2

‎06-28-2018

Hello Ahmad, Although this doesn't really answer your question regarding the versioning toolbar or the GDB administration GUI- perhaps the Create Version GP tool (also scriptable) might provide what you are looking for since it is based on the input .sde connection file (to the respective database)- and therefore specific to the database you choose. Hope this helps! -Rex

‎06-28-2018

Hello Chris, The only methods that I can think of that might work for you depending upon the nature of the data and your needs would be to create new SQL views in the database using our current select / sql queries. Once you create these views in SQL, they could be consumed in ArcGIS clients so long as they have the necessary prerequisites (spatial or non-spatial). For example, I used a similar query to create a non-spatial tabular SQL view which can be added in ArcMap and viewed: Create view Acres (Acres, acrescount) as select Acres, COUNT(*) from dbo.CITYBND where DATA = 'Elm City' group by Acres; The other option which might work would be to create definition queries within your existing tables / feature classes although this will vary depending on the nature of the SQL statements used. I hope this is helpful!

‎06-22-2018

Hello Chris, I have this SQL query that might be relevant for what you are trying to do- if nothing else I think it will allow you to modify it depending upon if you're interested in associated domains and if domains are used in conjunction with subtypes (looks like they are from your screenshot). As you suggested- subtypes and domains are largely managed / stored within the gdb_items and gdb_itemtypes tables (if your geodatabase is dbo schema just change table owner schema from sde. to dbo.- the rest should work as is): SELECT distinct st.SubtypeCode, st.SubtypeName, st.DomainName, dom.DomainCode, dom.DomainValue FROM (SELECT subtype.value('SubtypeCode[1]', 'nvarchar(max)') AS "SubtypeCode", subtype.value('SubtypeName[1]', 'nvarchar(max)') AS "SubtypeName", subtype.value('descendant::DomainName[1]', 'nvarchar(max)') AS "DomainName" FROM dbo.GDB_ITEMS AS items INNER JOIN dbo.GDB_ITEMTYPES AS itemtypes ON items.Type = itemtypes.UUID CROSS APPLY items.Definition.nodes('//Subtypes/Subtype') AS Subtypes(subtype)) st INNER JOIN (SELECT items.Name, codedValue.value('Code[1]', 'nvarchar(max)') AS "DomainCode", codedValue.value('Name[1]', 'nvarchar(max)') AS "DomainValue" FROM dbo.GDB_ITEMS AS items INNER JOIN dbo.GDB_ITEMTYPES AS itemtypes ON items.Type = itemtypes.UUID CROSS APPLY items.Definition.nodes ('//CodedValues/CodedValue') AS CodedValues(codedValue)) dom ON st.DomainName = dom.Name

‎06-22-2018

Hello Kathleen, Thanks for posting up your question. The answer really depends upon what you need out of your potential UID / OID field. Generally speaking, if your data is currently in feature class / file geodatabase format chances are that your five feature classes already have OID (something like an OBJECTID field) fields as it's required by ArcGIS. That said, if they for some reason lack a unique identifier field, you have a few options, you can either copy and paste each feature class in the same file geodatabase which will create a copy with a new unique / OID field, or if you want a unique field in the form of a global ID, you can right click each feature class < Manage < Add Global IDs. Keep in mind that if the records / rows in each feature class vary, their respective OID values will also vary accordingly. More information on OID fields can be found here: Fundamentals of ObjectID fields—Help | ArcGIS Desktop I hope this information is helpful! -Rex

‎06-15-2018

Hello Brandi, This is Rex with Support Services. We expect PostgreSQL 10.3 supportability to begin with the upcoming 10.6.1 / Pro 2.2 releases. I hope this is helpful!

‎06-14-2018

Hi Nathan, Based on this part " how do I relate these two tables by connecting (cross join) several fields such as "street name = street name and house number = house number"" - I'd say the easiest thing for you might be to concatenate / combine the multiple fields that you wish to cross-reference in each table into single columns, and then base your join or relate (depending upon cardinatlity) on the newly merged field in each. What is the expected cardinality? I'm guessing 1:M where one city can be related to many restaurants correct? About joining and relating tables—Help | ArcGIS for Desktop

‎06-14-2018

Hello Michael, Thanks for bringing this behavior in Pro to light. Would it be possible for you to share a simple / sample query layer syntax with an example subset selection that I could test this out with? Also- does the same query layer and selection subset function as expected in ArcMap? Thanks in advance! Best- Rex Geodatabase‌ Managing Data‌

‎06-14-2018

Hello Blake, There are two possible options for enabling editor tracking to record time in database time / local time, by using the dataset's Properties dialog box, or by using the Enable Editor Tracking tool. The following instructions describe these methods. Using the dataset's Properties dialog box Right-click the dataset in the Catalog window and click Properties. Click the Editor Tracking tab and check the Enable editor tracking option. Set the fields to be updated when a feature is created or edited. Note:The desired fields must be an existing field with Date data type. Click the Fields tab to define a new field prior to enabling editor tracking. For more information regarding adding a new field, refer to the following web help document, ArcGIS for Desktop Help: Adding fields. Specify the dates to be recorded in Database Time. Using the Enable Editor Tracking tool The tool allows users to select the local database time for the date field in the attribute table. For more information about the Enable Editor Tracking tool, refer to the following web help document, ArcGIS Help: Enable Editor Tracking. Note:Unlike enabling the editor tracking in a dataset's properties, the Enable Editor Tracking tool does not require an existing date field. Users can add a new field automatically by checking the Add fields if they don't exist option. Note:Recording the time in the database’s time zone is recommended only if users are certain all edits are to be performed within the same time zone. Note:These procedures only change the time option in the set feature class. To enable the editor tracking on multiple feature classes, Python code is required. I hope this is helpful for you! Best- Rex

‎06-14-2018

Hello Sendhil, There is a chance you are running into an older 10.0-10.2 defect: NIM095025: Load object tool from ArcMap fails to load a standalone table into a standalone table and produces the error “No Targets Available: Cannot load, no targets match the geometry type of the selected source(s)”. The workaround for this defect was to attempt the load operation through ArcCatalog instead of ArcMap. With that in mind- I'd consider trying the load through Catalog to see if that works for you. If it does, it's likely related to the above bug- if not, then there might be something annotation or data specific prohibiting the load from completing successfully. I hope this is helpful!

‎06-06-2018

Hello Janaki, It looks like the port #5432 is still being referenced as the instance name. What is the machine name of VM#2 (the PostgreSQL Server machine)? Try entering the machine name where Postgres is running as the instance input (Is it maybe geodb01b or geodb01a?)? See if that runs successfully.

‎06-04-2018

It looks like in the tool inputs you have the default Postgres port 5432 specified as the Instance name input- is this valid per your configuration? There should be no need to specify the port number if Postgres is running on the default port 5432. If you have a running instance / service on the Windows server- try inputting the name of the database instance (might be the server name if you're unsure) and see if that works. Hope this is helpful! Best, Rex R

‎06-04-2018

Hi Kevin, Thanks for posting the screenshots. I have some information that I hope is helpful although it's probably not what you'd want to hear at this point. Essentially, field names starting with an underscore or numeric value is not supported, and ArcGIS is unable to properly interpret such data if it comes across it. The reasons for this or described in more depth here: FAQ: What characters should not be used in ArcGIS for field names and table names? I'd try renaming the columns or altering them so that they begin with an alpha value such as A000to0159, etc., and see if that has any affect on the behavior you see in ArcGIS clients. This also applies to table names- and more from the database perspective can be found online (here is one page describing why this can cause issues: Database - What names should I NOT use for tables/fields/..?-VBForums Again probably not what you wanted to hear but I hope it's helpful nonetheless- Best, Rex R

‎06-04-2018

Hi Kevin, Could you post a screenshot of the tables and / or view columns from SQL Management studio as well as the view properties < fields in ArcGIS Pro so that we can compare what data types SQL is storing the fields as vs. what ArcGIS pro is interpreting them as? Is the view or underlying data registered with the geodatabase, or is this just spatial (or tabular) un-registered data in SQL? Thanks! Best, Rex R

‎06-04-2018

Hi Nils, Very glad to hear that the 4th approach lead you to the issue! I must agree- some error messages could be much more descriptive. I'll do my best to pass it on and hope this approach may assist you should you ever encounter additional connection issues to SQL Server! Best, Rex R

‎05-31-2018

Hi Nils, There could be a variety of culprits causing this issue for you, unfortunately. Just to clarify- can you connect with either database authenticated users OR OS authenticated users or do both (and therefore all) connections fails to this instance from ArcGIS clients? A couple of initial things to check in the database are: Ensure you have mapped logins to the applicable databases in SQL. Right click the login < Properties < User mapping < ensure the applicable database is checked for the user. If OS users succeed and database authenticated users (only) fail- check the Server authentication setting under the server properties (right click instance < Properties < Security page)- ensure SQL Server and Windows Authentication mode is selected. Additionally, under SQL Configuration Manager from the screenshots you provided select Protocols for MSSQLSERVER. Ensure Named pipes and TCP/IP is set to Enabled as below: One nice trick to see if the SQL instance is accessible from your remote workstation at all is to (on a client machine with ArcGIS), create a new text file on the desktop. Once created rename to test.udl and rename the file. This will create a data link file capable of testing connectivity to SQL servers within your domain. Open the new .udl file, and hit the drop down for server name- this will reach out through your available domain to find available instances of SQL. If your instance doesn't show up- you have a network, DNS, or firewall issue If your instance does show up, test connecting outside of ArcGIS by entering a username and password that exist as a mapped login / database user in the database. Select the intentended database if more than one exists on the instance. Test connection- this will utilize the MS SQL ODBC 13 driver and test a connection taking ArcGIS out. If it fails, the issue is with configuration or server availability. If it succeeds we need to determine why ArcGIS is unable to communicate through the client. I hope this is helpful! Best, Rex

Online Status	Offline
Date Last Visited	‎11-11-2020 02:24 AM

My Ideas

Latest Contributions by RexRobichaux2

Re: Control where to create the version in an MXD that has multiple database connections

Re: transfer of Microsoft SQL statement to a statement that can be run against our SDE database

Re: SQL Select to get a subtype value from an ARC Database

Re: Question regarding adding UIDs to a geodatabase

Re: When will PostgreSQL 10 be supported?

Re: relate two tables to display on the map

Re: Available Values for a Query Layer Subset Selection

Re: Display UTC Editor Tracking datetime in local time

Re: Error using Object Loader in ArcMap to load feature linked annos

Re: Issue while creating Enterprise GDB with Postgresql

Re: Issue while creating Enterprise GDB with Postgresql

Re: Why are my field names and values changing when I bring them into my map?

Re: Why are my field names and values changing when I bring them into my map?

Re: ArcGIS Desktop: can't connect to MSSQL via database authentication

Re: ArcGIS Desktop: can't connect to MSSQL via database authentication

Re: ArcGIS 10.5.1 & ArcGIS Pro 2 bug connecting to...

Re: Error with arcgis geodb . How to repair or so...

Re: Manually updating a versioned SDE Geodatabase?

Re: ArcGIS Online Sevice Schema Lock?

Re: Accessing a PostGIS table with a custom SRID