ERROR

Failed to create table. Invalid DBTUNE data found [...]

Last Published: April 26, 2020

Error Message

Copying or creating data in a PostgreSQL geodatabase created with ArcGIS Pro 1.1, ArcGIS 10.4 Beta for Desktop, or ArcGIS 10.4 Pre-release for Desktop using an earlier client (for example, ArcGIS 10.3.x and ArcGIS 10.2.x clients) returns the following error messages:

"Failed to create table.
Invalid DBTUNE data found.[...]"

"Failed to paste [...]
Invalid DBTUNE data found.[...]
DBMS table not found"

Cause

This error is caused by the introduction of new parameters in ArcGIS Pro 1.1, ArcGIS 10.4 Beta for Desktop and ArcGIS 10.4 Pre-release for Desktop that are not consistent with the earlier client software.

This behavior was fixed in ArcGIS Pro 1.2 and ArcGIS 10.4 Final for Desktop.

Solution or Workaround

To work around the issue, implement the following steps:

  1. Log in to the affected PostgreSQL geodatabase as a PostgreSQL administrator through SQL.
  2. Remove the two problematic parameters from the sde_dbtune table using the following SQL:

    DELETE FROM "sde"."sde_dbtune"
    WHERE parameter_name IN ('A_INDEX_SHAPE', 'B_INDEX_SHAPE');

Article ID:000012704

Software:
  • ArcMap
  • ArcGIS Pro 1 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic