topic Re: Define Projection Not working in Data Management Questions

Define Projection Not working

MJune — Wed, 03 Jun 2020 12:01:43 GMT

I am trying to use the Define Projection tool and a feature class in an enterprise geodatabase. I am receiving an error that it can't create a projection file (ERROR 000054). I have confirmed there is no locks on the table, the user logged in is the owner of the table and has db owner on the database. I am using a standard license. I've tried in both Pro and ArcCatalog (10.5.1). I've tried several tables with the same result. Is there security I am missing? Can there not be any locks on any table/view in the database while running the tool?

Re: Define Projection Not working

JoshuaBixby — Wed, 03 Jun 2020 13:57:26 GMT

From the screenshot, the FC appears to be a stand-alone FC in the root level and not a FC in a feature dataset participating in a special relationship, like geometric network, topology, etc... Correct?

Check the database logs. If it is an issue on the DBMS that is forcing the error on the client, the logs should help you find the issue.

Re: Define Projection Not working

MJune — Wed, 03 Jun 2020 14:35:14 GMT

You are correct, this is a stand along feature class. I will see what we can find in the database logs

Thank You,

Melissa

Re: Define Projection Not working

ManuKaur — Tue, 30 Jun 2020 15:23:30 GMT

This documentation may be of some help to you.

000054: Cannot create a projection file for .—Help | Documentation

I suggest double checking that the output is not read only.

Re: Define Projection Not working

NicolasGIS — Thu, 01 Jun 2023 08:53:09 GMT

Hello @MJune ,

Out of curiosity, are you on Oracle ? I opened a BUG less than a year ago regarding this issue:

BUG-000152217: In ArcGIS Pro, the Define Projection tool fails to assign a projected coordinate system for Oracle geodatabase feature classes.

Upgraded yesterday to latest SDE version, still not fixed...

Re: Define Projection Not working

vijaybadugu — Thu, 08 Jun 2023 15:42:54 GMT

I am also facing same issue with SQL Server. I was trying to use define projection for a spatial and it always throws error and even after restarted the desktop . I don't have any clue on this