Latest Contributions by KenGalliher1

‎02-09-2022

Another suggestion would be to join the Pro and ArcMap polygon tables and create a database view. This view can be filtered by dates, parcel types, branch versions, etc. The feature classes remain editable which essentially updates the view. Here is some more info on querying branch versioned feature classes and creating views. Query Branch Versioned Parcels - Esri Community

‎02-01-2022

Adding an attribute index should only require a connection as the data owner. Is there any other information in the error message?

‎10-21-2021

Interesting. If you can, please log a case with Support. This shouldn't be happening.

‎10-21-2021

Hi Bryn, Update: False alarm. My error came from a different issue. However, staying with the path theme, can you confirm that the same path used the GP tool or model builder is the same path in the script? I was able to reproduce the error by putting my .sde connection file in a path with a very long character length. I know there are technically limitations on path character lengths in Windows, Python and ArcPy but I'm not sure which one(s) is occurring here since it works from the GP tool and Model Builder. My path above is 252 characters long so I don't think my issue is Windows. https://desktop.arcgis.com/en/system-requirements/10.5/os-limits-windows.htm Please try to shorten the inFeatures path length and see if that helps. I'll see if I can find more info.

‎10-13-2021

It looks to me like you're setting the environment workspace to a file geodatabase while working between two enterprise geodatabases. That shouldn't be a problem but, try commenting out that line or set the env.workspace to your inFeatures SDE connection file. arcpy.env.workspace = <inFeatures_connection_file.sde> Also, do you get the same error running the Feature Class to Feature Class geoprocessing tool from Pro? Ken

‎06-22-2021

With the sysadmin role removed, copy in the feature dataset again with that user logged in. In the catalog pane, the new feature dataset should say <database>.GIS_Admin.<fds_name>. From there, try publish again.

‎06-22-2021

Does your GIS_Admin user have the "sysadmin" role applied? If so, take the user out of that role and try to publish again. What might be happening is the user was given an elevated privilege which causes the user to be seen as having the DBO schema. This creates a mismatched schema situation which is perfectly legal in SQL Server but causes problems in the geodatabase.

‎06-22-2021

Hi Matthew, Double check you are logged into the .sde connection file as the "gis_admin" user. It sounds to me the database connection properties are pointing to a user other than the owner of the data. For example I have a fabric owned by "GIS". To publish this fabric, I would need to log in as the GIS user to the database connection. Let me know if that helps or if you have any more questions. Ken

‎05-12-2021

In our "What's New in 2.8" meetup, I demonstrated using a database view to display parcel fabric features joined with an external table. I didn't spend much time on the SQL so check out the code block and link below for examples. Please be aware that INSERT, UPDATE and DELETE functionality is not available. https://github.com/Esri/developer-support/tree/master/arcsde-sql/sql-server/branch-versioning SELECT a.NAME, a.objectid, b.description_, b.address_, b.owner_, a.shape, a.gdb_geomattr_data FROM gis.tax_4 a LEFT JOIN gis.fake_cama b -- keep all parcels (null external rows ok) ON a.name = b.Name -- Start branch versioning magic WHERE a.GDB_ARCHIVE_OID IN ( SELECT GDB_ARCHIVE_OID FROM ( SELECT GDB_ARCHIVE_OID, ROW_NUMBER() OVER( PARTITION BY OBJECTID ORDER BY GDB_FROM_DATE DESC ) AS rn_, GDB_IS_DELETE FROM GIS.TAX_4 WHERE GDB_BRANCH_ID IN (0) AND GDB_FROM_DATE <= GETUTCDATE() AND OBJECTID IN ( SELECT OBJECTID FROM GIS.TAX_4 WHERE (RetiredByRecord IS NULL) ) ) AS br__ WHERE br__.rn_ = 1 AND br__.GDB_IS_DELETE = 0 ) -- End branch versioning magic -- Filter from sub result set AND a.RetiredByRecord IS NULL AND a.IsSeed <> 1

‎09-03-2020

Hi Craig, Can you let me know the following: - SQL Server version (2014, 2017, etc.) - ArcGIS Pro version (2.4, 2.6.1, etc.) - Geodatabase version (10.7, 10.8, etc.) - Version of the parcel fabric being copied in. This can be found in the parcel fabric properties pane. There are a couple of things that jumped out at me in the error message although I can't reproduce the error. The first one is the length of the fully qualified table name. In SQL Server geodatabases, the table name can be 128 characters long but the alias can only be 31. If possible, try a shorter data owner name. Or better, a shorter database name and owner name. Enterprise geodatabase size and name limits—Help | ArcGIS Desktop The username has the word "admin" in it. Make sure there are no elevated database or server privileges associated to that user such as sysadmin or DBO. Create a parcel fabric—ArcGIS Pro | Documentation My last observation is the version of the SQL Server ODBC client. The ODBC 17 client is the latest. Try installing this and copying the fabric again. Download ODBC Driver for SQL Server - SQL Server | Microsoft Docs Thanks, Ken

‎04-01-2020

This zip file contains a Jupyter notebook and a python file that demonstrates using the ArcGIS Python API to merge parcels in a branch versioned feature service.

‎11-15-2019

Take a look at the following link: Task parameter properties (REST)—Documentation | ArcGIS Enterprise Features that have a geometry, spatial reference, field definitions, and features.

‎08-14-2019

Take a look at this: GitHub - Esri/arcgis-rest-js: compact, modular JavaScript wrappers for the ArcGIS REST API

‎05-11-2018

Also, try this query to check the count of unposted states on all versioned feature classes: SELECT tr.table_name AS table_name , s.owner AS state_owner, count(*) AS total_unposted_states FROM sde.table_registry tr INNER JOIN sde.mvtables_modified mv ON tr.registration_id = mv.registration_id INNER JOIN sde.states s ON mv.state_id = s.state_id GROUP BY tr.table_name, s.owner;

‎03-14-2018

The "no ntvinv in java.library.path" error typically comes from a mismatch between the Java's bit level and the bit level of ArcObjects. The ArcObjects libraries are comprised of 32 bit components while Java is 64 bit. Try using a 32 bit Java version that is supported for your version of ArcObjects. Regarding the sample script, the key is the Geoprocessing object which makes use of ArcGIS's Python functionality. If the goal is to create a file geodatabase then the CreateFileGDBClass is the way to go. com.esri.arcgis.geoprocessing.tools.datamanagementtools.CreateFileGDB Creating enterprise, multi-user geodatabases can be accomplished by running the CreateEnterpriseGeodatabase geoprocessing tool with the Geoprocessor class methods. Create Enterprise Geodatabase—Help | ArcGIS Desktop ArcObjects Java API - Geoprocessor class .NET example of executing a geoprocessing tool with ArcObjects arcobjects-sdk-community-samples/Net/Geoprocessing/GPExecutingTools at master · Esri/arcobjects-sdk-community-samples · …

Online Status	Offline
Date Last Visited	a week ago

My Ideas

Latest Contributions by KenGalliher1

Re: Scripting a sync process from fabric to traditional parcels feature class

Re: Indexing field in the Parcel Fabric - no permissions?

Re: Export features from Parcel Fabric using Python

Re: Export features from Parcel Fabric using Python

Re: Export features from Parcel Fabric using Python

Re: Problem Publishing Parcel Fabric Feature Class

Re: Problem Publishing Parcel Fabric Feature Class

Re: Problem Publishing Parcel Fabric Feature Class

Query Branch Versioned Parcels

Re: Migrating Parcel Fabric Data from File Geodatabase to SDE

MergeParcelsPythonAPI.zip

Re: What is GPMultiValue:GPFeatureRecordSetLayer

Re: arcgis javascipt api using node.js

Re: Is there an ESRI way to see if there is versioned data still in progress that needs compressing?

Re: Can I create a gdb using ArcObjects in ArcGIS runtime sdk for java 10.2.4?

Re: Issue converting H3 cell boundary WKT to geome...

Re: FeatureLayerCollection.replicas.create always ...

Re: Issue converting H3 cell boundary WKT to geome...

Re: A Special Thanks to the ArcGIS API for Python ...

A Special Thanks to the ArcGIS API for Python Comm...