Updates and Edits to data on SDE failing

Question

Hi folks,

I am in the process of editing and appending data within one of our SDEs but it now keeps failing and wondering if anyone has come across this error before? We have a number of SDEs and the rest of them are working in allowing us to update and create new feature classes but one SDE appears to have got broken along the way. There is little information on the errors and I have checked the properties on SQL but nothing appears to be any different from the working SDEs

Thanks!

George_Thompson · Answer

That sounds like there is something with that specific user permissions on that Enterprise Geodatabase (EGDB) or there is another issue within the EGDB.

It may be best to work with technical support on this.

KSmyth4 · Answer

Hi @George_Thompson and @MarceloMarques

I will certainly look more into the Append process but the editing tools and other geoprocessing tools are still not working, is there a potential that a connection can be lost to a SDE? We have several other SDEs and they are working okay at the moment, nothing has been changed to the settings of the SDE in SQL and it seems that the data can not be changed or edited to existing feature classes?

Thanks

MMBR · Answer

@KSmyth4 000466: does not match the schema of target .—ArcGIS Pro | Documentation Description If Schema Type is set to Input schema must match target schema, schemas of input feature classes must match the schema of the target feature class. Solution Ensure that the input feature classes or tables have the same attribute schema as the target feature class. If the schemas are not the same, you can set the Schema Type parameter to Use the Field Map to reconcile schema differences, so only those fields and their values in the input that match fields in the target dataset are used. See the Append tool documentation for more information.