Error: Failed to create table. Invalid DBTUNE data found [...]
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"
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:
- Log in to the affected PostgreSQL geodatabase as a PostgreSQL administrator through SQL.
- 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');