laptop and a wrench

Bug

The Append tool returns the error 000372 when using the NO_TEST option if the user has a 'db_owner' role and is not the data owner of the target dataset.

Last Published: March 14, 2017 ArcSDE/Enterprise Geodatabase
Bug ID Number BUG-000081678
SubmittedSeptember 16, 2014
Last ModifiedMarch 30, 2022
Applies toArcSDE/Enterprise Geodatabase
Version found10.2.1
Operating SystemWindows OS
Operating System Version2012 64 Bit
Version Fixed10.5.0
StatusFixed

Description

Users may encounter error 000372 "Spatial Reference for Output is invalid"- When running Append tool in a SQL Server Geodatabase if they are a member of the db_owner role and not the data owner. 

This is normally only experienced in the following situation:
  • The user running the Append Tool is a member of the db_owner SQL Server database role, and NOT the data owner.
  • If the user running the tool is the data owner it will work no matter the roles.
  • Additionally, if the user is not the data owner, and NOT in the db_owner role- it should work as well.
  • This issue has been resolved at the 10.5 Desktop release.
  • Data is actually getting appended- the error is a false flag warning. This should only cause issues if the Append Tool will be ran in a scripted and repetitive environment where subsequent operations will be ran after the initial Append as the error will likely cause the script to fail.

Cause

This error is commonly related to a commonly-known defect: BUG-000081678: The Append tool returns the error 000372 when using the NO_TEST option if the user has a 'db_owner' role and is not the data owner of the target dataset.

Workaround

BUG-000081678 : The Append tool returns the error 000372 when using the NO_TEST option if the user has a 'db_owner' role and is not the data owner of the target dataset.
  • Run the tool as the data owner
  • Remove the user from the db_owner role or run as a user who is not in the role
  • If scripted- execute individual append scripts so that the error doesn't cause the script with multiple appends to fail after the initial process. 

Steps to Reproduce

Bug ID: BUG-000081678

Software:

  • ArcSDE/Enterprise Geodatabase

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic