topic Re: Error migrating to ST_GEOMETRY in Geodatabase Questions

Error migrating to ST_GEOMETRY

BartPittari — Mon, 01 Mar 2021 17:47:16 GMT

There are a number of feature classes in our current Oracle 12c/19 GDB that are still SDE Binary or ESRI LOB that I'm running an impact analysis on for upgrading to ST_GEOMETRY.

When I tried to use the Migrate Storage tool, I received an underlying DBMS error (Error 000955). Upon having a trace run on the backend, we found that

The following statements encountered a error during parse:

SELECT * FROM SDE.SCH_DATASET

Error encountered: ORA-00942

--------------------------------------------------------------------------------
UPDATE MYSCHEMA.BIRDS_FEATURES SET SDE_CONVERSION = SDE.ST_GEOMETRY(:s1,:s2,:s3,:s4,:s5,:s6,:s7,:s8,:s9,:s10,:s11,:s12,:s13,:s14) WHERE SHAPE = :fid1

Error encountered: ORA-00600

So, it appears that SDE.SCH_DATASET doesn't exist (?) - is there a way to remedy this?

I think the preferred upgrade path (especially since it's what ESRI suggests) would be the Migrate Storage route. The other route (copy, paste as ST, then rename) while successful, could raise too many impact issues on possible roles inherited, privs, and any underlying tables that get updated from a different interface.

Re: Error migrating to ST_GEOMETRY

George_Thompson — Mon, 01 Mar 2021 21:14:13 GMT

What is the version of the ArcGIS client and Enterprise Geodatabase that you are using?

Are you running this GP tool as the data owner?

The ORA-00600 seems like an internal Oracle error parsing the SQL statement.

Are these feature classes point / line / polygon FC's or have networks, topology, etc. with them?

Re: Error migrating to ST_GEOMETRY

BartPittari — Mon, 01 Mar 2021 21:24:19 GMT

Yes, the tool is being run as the schema owner.

The 600 error occurs during the update attempt. I thought it may be related to the 942 error.

The FCs are all point, line, polygon ones, no topology or networks.

Re: Error migrating to ST_GEOMETRY

George_Thompson — Mon, 01 Mar 2021 22:00:16 GMT

What version of Pro and Geodatabase (not the Oracle version) are you running this on?

Just checking that you reviewed this doc: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-oracle/data-migration.htm

Re: Error migrating to ST_GEOMETRY

BartPittari — Mon, 01 Mar 2021 22:07:20 GMT

I've tried in all versions we have (10.4.1, 10.8.1 and 2.5). The Geodatabase version I think is 10.4.

And yes, I reviewed that document and my data meets all the migration prerequisites.

Re: Error migrating to ST_GEOMETRY

George_Thompson — Tue, 02 Mar 2021 11:57:47 GMT

It may be best to work with Esri Technical Support on this moving forward. I have seen successful migrations in the past so not sure what is going on.