|
POST
|
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.
... View more
06-22-2021
02:25 PM
|
1
|
1
|
4569
|
|
POST
|
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
... View more
06-22-2021
01:47 PM
|
0
|
0
|
4605
|
|
DOC
|
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
... View more
05-12-2021
10:47 AM
|
2
|
0
|
1855
|
|
POST
|
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
... View more
09-03-2020
01:57 PM
|
0
|
0
|
4018
|
|
DOC
|
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.
... View more
04-01-2020
11:05 AM
|
0
|
0
|
945
|
|
POST
|
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.
... View more
11-15-2019
12:16 PM
|
0
|
0
|
1662
|
|
POST
|
Take a look at this: GitHub - Esri/arcgis-rest-js: compact, modular JavaScript wrappers for the ArcGIS REST API
... View more
08-14-2019
07:31 PM
|
2
|
0
|
2112
|
|
POST
|
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;
... View more
05-11-2018
08:05 AM
|
1
|
1
|
2446
|
|
POST
|
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 · …
... View more
03-14-2018
08:47 PM
|
0
|
0
|
996
|
|
POST
|
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
... View more
03-14-2018
07:47 PM
|
1
|
2
|
2446
|
|
POST
|
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.
... View more
03-09-2018
10:51 PM
|
1
|
0
|
1227
|
|
POST
|
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
... View more
01-02-2018
08:51 AM
|
6
|
0
|
16619
|
|
POST
|
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?
... View more
04-26-2017
02:36 PM
|
2
|
0
|
1015
|
|
POST
|
Hi Gianni, Does the database reside in a location different than the ArcGIS Server machine? If so, make sure to alter the pg_hba.conf file to allow the IP address of the ArcGIS Server machine to connect. For example, the pg_hba.conf file could contain: Entries for both ipv4 and ipv6 connection types, the second line, indicates that any user from any machine can connect. # IPv4 local connections: host all all 127.0.0.1/32 md5 host all all 0.0.0.0/0 md5 # <-- add the specific address of the ArcGIS Server machine if desired. # IPv6 local connections: host all all ::1/128 md5 host all all ::/0 md5 If this is the case, the "bad login user" error may sound misleading. However, from PostgreSQL's point of view, the proper credentials were never actually passed to the database. Ken
... View more
04-21-2017
03:55 PM
|
2
|
0
|
1786
|
|
POST
|
This is typically done using a SQL trigger that listens for incoming geometries either from editing a map document or inserting geometries with SQL. When using a native DBMS spatial type such as SQL Server Geometry or Postgres' PostGIS type, constructor functions and spatial operator functions are provided that allow one to query different spatial properties. For instance, in SQL Server we can use the shape.Lat, shape.Long functions for Geography types or shape.X and shape.Y for Geometry types on a spatial column called "shape". Here is a simple SQL Server Geography example using shape.Lat and shape.Long. to update columns called "latitude" and "longitude" with their respective values. This sample is provided AS IS and must be properly tested before implementing in a production environment. CREATE TRIGGER [gis].[Insert_xy_if_geometry_fc] ON [gis].[Landmark_fc]
AFTER INSERT
,UPDATE
AS
UPDATE pt
SET pt.latitude = i.Shape.Lat
,pt.longitude = i.Shape.Long
FROM Landmark_fc AS pt
INNER JOIN (
SELECT objectid
,Shape
FROM inserted
WHERE (Shape IS NOT NULL)
) AS i ON i.objectid = pt.objectid;
RETURN
GO
Lat (geography Data Type) Long (geography Data Type)
... View more
05-17-2016
08:53 AM
|
1
|
0
|
1416
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 04-06-2026 11:06 AM | |
| 4 | 04-03-2026 04:46 PM | |
| 2 | 03-23-2026 02:22 PM | |
| 6 | 12-03-2025 10:28 AM | |
| 1 | 10-27-2025 11:33 AM |
| Online Status |
Offline
|
| Date Last Visited |
2 weeks ago
|