topic Re: Input feature class is not registered as versioned??? in ArcGIS Pro Questions

Input feature class is not registered as versioned???

ThomasColson — Wed, 12 Feb 2020 18:54:57 GMT

So calculating geometry (area) on a 10.8.0.25 SQL 2014 Enterprise Feature Class, Geography Storage Type, GCS projection in 2.5, not registered as versioned, no branch versioning, archiving enabled returns

ERROR 130051: Input feature class is not registered as versioned.
Failed to execute (CalculateGeometryAttributes)

Drew Flater‌ I recall this coming up in the past, can't find the GN post though, or maybe it was in EAP. Is there now a requirement that feature classes have to be registered as versioned to calculate geometry?

SQL trace shows

Violation of UNIQUE KEY constraint 'states_cuk'. Cannot insert duplicate key in object 'dbo.SDE_states'. The duplicate key value is (0, 0). as this is happening.

Re: Input feature class is not registered as versioned???

DrewFlater — Thu, 13 Feb 2020 08:24:20 GMT

Hi Thomas Colson, I'm a little puzzled at this case, as our in-house test suite has cases just as you described that are passing and I just tried it myself in the application and the calc worked as expected.

If you look under the hood of Calculate Geometry Attributes, it uses arcpy.da.UpdateCursor to perform the updates. Some data sources and enterprise gdb configurations require an updatecursor in an edit session, some don't support edit sessions, it's really a grab bag. So the tool attempts to start and use an edit session when required or check that the cursor can retrieve data without the edit session. If it's not able to, it raises the error you described.

Attached is a screenshot of the test I ran using a SQL Server Enterprise GDB polygon feature class that has the Geography Configuration Keyword, GCS coordinate system, not registered as versioned, with archiving enabled. The Double field gets updated with the Area in sq miles as specified on the tool.

I can only say this is a case to report and work withing tech support, please.

All the best,

Drew

Re: Input feature class is not registered as versioned???

ThomasColson — Thu, 13 Feb 2020 12:43:22 GMT

This may be a database issue I've since discovered. One feature (out of hundreds) has non-simple geometry, and SQL trace is showing other issues with the SDE core tables. This is an operational database that can't wait for TS to figure out what's wrong, our solution is going to be stand up a new SQL DB. With that said, I can open a case for the sole purpose of giving you a backup of the SQL DB, there is something going on with SDE that is causing GP tools to fail.

Re: Input feature class is not registered as versioned???

kathyhardinwalker — Thu, 13 Feb 2020 17:04:47 GMT

I too cannot calculate geometry, receiving the same error message - not registered as versioned:

Yet the data set is versioned:

I have gone through many of the posts regarding this problem, but haven't yet found an answer. Maybe the answer is in there, but being this was a brand new thread, I thought I might have more luck here.

I just updated Pro to 2.5.0.

Any direction is appreciated,

Re: Input feature class is not registered as versioned???

ThomasColson — Thu, 13 Feb 2020 17:40:25 GMT

Can you give the exact details of your environment? Where is the data, what type/version of database, is it geometry or geography storage, what is the projection?

Re: Input feature class is not registered as versioned???

kathyhardinwalker — Thu, 13 Feb 2020 19:38:57 GMT

There may be more information here than you need, but I thought more might be better than not enough. I hope I got everything.

SQL Server Enterprise Geodatabase

Enterprise Gdb Feature Dataset

Replica Geodatabase

Microsoft SQL Server Management Studio                        11.0.7001.0
Microsoft Analysis Services Client Tools                        11.0.7001.0
Microsoft Data Access Components (MDAC)                        6.3.9600.16384
Microsoft MSXML                        3.0 6.0
Microsoft Internet Explorer                        9.11.9600.17207
Microsoft .NET Framework                        4.0.30319.34014
Operating System                        6.3.9600

Processor Intel(R) Xeon(R) CPU E5-2683 v4 @ 2.10GHz 2.10GHz

RAM 16.0 GB

64-bit operating system, x64-based processor

Windows Server 2012 R2 Datacenter

Storage High Precision - Geometry

Projected CS: NAD 1983 StatePlane Virginia North FIPS 4501 (US Feet)

Lambert Conformal Conic

Re: Input feature class is not registered as versioned???

ThomasColson — Thu, 13 Feb 2020 21:36:29 GMT

Can you run a SQL trace when your running the calc tool? In the trace, do you see errors with SDE_ITEMS and maybe a reference to a corrupt SDE log file? That's what I'm seeing. I would take this to TS, but I already have a bunch of cases open that I need to pay attention to.

Re: Input feature class is not registered as versioned???

Anonymous User — Thu, 13 Feb 2020 21:44:34 GMT

Kathy is that SQL Server 2012 your hitting with Pro 2.5?

Re: Input feature class is not registered as versioned???

ThomasColson — Thu, 13 Feb 2020 21:52:14 GMT

"Windows Server 2012 R2 Datacenter"

Well there's her problem. But I'm on 2014 and having same problem so......

Re: Input feature class is not registered as versioned???

ThomasColson — Thu, 13 Feb 2020 21:52:54 GMT

opsie that' OS not SQL!

Re: Input feature class is not registered as versioned???

kathyhardinwalker — Thu, 13 Feb 2020 22:07:39 GMT

I thought I included the server # but no!:

It's Enterprise Server 10.3.1

Windows Server 2012 R2 Datacenter

Re: Input feature class is not registered as versioned???

kathyhardinwalker — Thu, 13 Feb 2020 22:09:07 GMT

No worries

Re: Input feature class is not registered as versioned???

kathyhardinwalker — Thu, 13 Feb 2020 22:10:28 GMT

Sean,

I suppose you already saw this:

SQL Server Enterprise GDB 10.3.1

Re: Input feature class is not registered as versioned???

ThomasColson — Thu, 13 Feb 2020 22:21:23 GMT

What version of SQL server (Not Windows Operating SYstem or ArcGIS Server version)? But if you're still on 10.3, I suspect pretty old

Re: Input feature class is not registered as versioned???

Anonymous User — Thu, 13 Feb 2020 22:22:20 GMT

Kathy,

Whats the version of SQL Server Enterprise?

Pro 2.5 has only been certified with SS 2014 and above.

I only ask to be sure because the associated version of management studio you listed seems to be from the SS 2012 time.

Re: Input feature class is not registered as versioned???

kathyhardinwalker — Fri, 14 Feb 2020 14:13:07 GMT

Yes

I see what you are asking.

I have limited access to some of this information. So there's back and forth on my end.

It's SQL Server 2012 and 10.3.1 on arcgis for server.

I'm not sure I'm saying that correctly, but I do understand what you are asking and I hope what I have written makes enough sense that you understand the server environment. But, if calculate geometry doesn't work on 2014 either... what version does it work on? (I ask bc I believe our IT department is getting ready to upgrade, so I would like to know what to tell them we need now and going forward).

Thank you for all of your help guys!

Happy Valentine's Day to you ❤️

Re: Input feature class is not registered as versioned???

kathyhardinwalker — Tue, 18 Feb 2020 16:37:07 GMT

I looked online at the specs. Supported OS = Windows Server 2012 R2 Standard and Datacenter.

Also, on this webpage https://pro.arcgis.com/en/pro-app/get-started/arcgis-pro-system-requirements.htm there's a link to check your computer's ability to run ArcGIS Pro 2.5.

http://www.systemrequirementslab.com/Client/Standard/Analysis/1186/12433/arcgis-pro-2-5

Re: Input feature class is not registered as versioned???

kathyhardinwalker — Tue, 18 Feb 2020 16:38:36 GMT

I'm having to wait for the GIS Admin / IT for this. They have the request to run a trace, etc. But nobody can help right now.

Re: Input feature class is not registered as versioned???

Anonymous User — Tue, 18 Feb 2020 17:37:48 GMT

Hi Kathy,

I took an interest in your question because i work with versioned and non versioned ediitng as part of the development work here. Like Drew with Thomas' question, I couldn't reproduce your problem with Pro 2.5 and SQL Server 2014 but we also run with relatively clean non production databases.

I would probably work with support on this issue unless somebody else chimes in soon. If you do contact support they will likely ask you to upgrade sql server. Upgrading may not solve the issue right away but at least we know it should work.

The list of currently supported versions can be found at: Microsoft SQL Server database requirements for ArcGIS 10.8 and ArcGIS Pro 2.5

Re: Input feature class is not registered as versioned???

kathyhardinwalker — Tue, 18 Feb 2020 22:03:00 GMT

Thank you, that's helpful information.