Issue uploading shapefile for GIS data points

[TylerArruda]

Hello, 

I am having issue uploading shapefiles into my company enterprise dtatabase project. When I try to define projection i get Error 000051:

When I upload shapefiles to a blanket project and map I have no issuse.

Also, my co-worker on his own machine has no issuse uploading shapefiles into the company enterprise database project. I have even tried when he is not logged in. 

Any help would be great. 

Thank you

[TylerArruda]

Snippet of error message

[DanPatterson]

The Define Projection tool is only used when the dataset doesn't have a defined coordinate system and you know what it is.  Do the defining before you upload it not after

[Robert_LeClair]

And to add to Dan's response, it also appears that the Feature Dataset has a lock on it as well which prevents any schema changes.  You can do a right-click on the *.sde connection and choose Administration->Locks to see who has the lock.  Once that's identified, you can ask the user(s) to close their ArcGIS Pro applications to release the locks and update any schemas.

Adding to this - there is a BUG-000152217 - "In ArcGIS Pro, the Define Projection tool fails to assign a projected coordinate system for Oracle geodatabase feature classes."  Is your organization using an Oracle RDMBS by chance?

[TylerArruda]

Rob when i go to locks it says I am the one with schema locks. When my co worker is just on it says he has schema locks, but allow him to input the shapefile. So why is it only my account??

[Robert_LeClair]

Sounds like a permissions problem then.  Who owns the FDS and do you have read-write access to the FDS?

[TylerArruda]

Rob,

I am using NAD 1983 2011 Mass main land

[Robert_LeClair]

Okay - let's discuss workflow to try:

1.  Does your shapefile have a *.prj file?  If not, then Define Projection (Data Management) GP tool will write out the *.prj file for your shapefile.  This is the first requirement.

2.  What is the coordinate system of your Feature Dataset?  All feature classes in a FDS are forced to be in the same coordinate system for geodatabase behaviors.  If the incoming shapefile is not in the same coordinate system then you'll need to use the Project (Data Management) GP tool to create  a new shapefile/feature class in the coordinate system of the FDS.

3.  Once your incoming shapefile is in the same coordinate system as the FDS, then you can try to use the Copy Features (Data Management) GP tool first.  If that tool doesn't work, then try the Feature Class to Geodatabase (Conversion) GP tool.

What is the result?