Latest Contributions by KenGalliher1

‎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 · …

‎03-14-2018

This isn't an ArcGIS/Esri way but take a look at this tech article describing a SQL script that.. " reports information about a versioned geodatabase in Oracle. The output lists the number of versions, the number of versions blocking the DEFAULT version from being compressed to state 0 and the owner.names of the first 5 blocking versions, the number of states, the number of entries in the state_lineages table, and the number of rows in the versioned table and delta tables." As has been mentioned in the other comments, to see what versioned feature classes have not had their edits posted and compressed to the base table is to look at the delta tables. How To: Report geodatabase versioning statistics in an Oracle geodatabase

‎03-09-2018

Hello Elias, Are you labeling with the ST_Area(shape) or ST_Length(shape) columns specifically? If so, this is a known bug: BUG-000084936 ---------------- Attempting to label features from PostgreSQL based on the st_area(shape) or st_length(shape) field in ArcGIS 10.4.1 fails with an error, "Invalid column data type". BUG-000084936: Attempting to label features from PostgreSQL based o.. ---------------- The workaround for this is to add a new field of the same data type and use the Field Calculator to populate the new field with the ST_Area or ST_Length column values. If this is not a case then it may be best to open a case with Support.

‎01-02-2018

Hi Bob, I have attached a document that outlines the following: 1. Download and install the driver. 2. Add the ODBC driver as a data source on the machine. 3. Connect to the MySQL database in ArcCatalog. Here are some relevant links: MySQL ODBC Driver download (5.2.x) MySQL :: Download Connector/ODBC Adding an OLE DB Connection in ArcGIS Desktop. Adding OLE DB connections to databases—Help | ArcGIS for Desktop - Ken

‎04-26-2017

If you’re still maintaining applications written in the ArcSDE Java or C API you may already know you’re getting close to the end of the code base’s life cycle. As a support analyst, I have been seeing a spike in calls regarding migrating from the SDE SDK by using native database spatial types with SQL and ArcObjects. How are you approaching your migration?

Online Status	Offline
Date Last Visited	Wednesday

My Ideas

Latest Contributions by KenGalliher1

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: Is there an ESRI way to see if there is versioned data still in progress that needs compressing?

Re: Problem labeling geometry attributes with data in PostgreSQL database

Re: How to connect ArcGIS Desktop to MySQL database

Are you planning on replacing an SDE SDK application? If so, what technology will you use?