Hello everyone,
I have some vector data on our test SDE database that I am trying to move to our production. The data is in ST_GEOMETRY format and we are trying to copy it with the same format on the production server. If I use ArcCatalog (either copy and paste or import export) I get the error below.
ERROR 999999: Error executing function.
Underlying DBMS error[ORA-02291: integrity constraint (SDE.GEOM_SRID_FK1) violated - parent key not found]
DBMS table not found[ORA-00942: table or view does not exist
][COM_GIS.test_X][STATE_ID = 0]
Failed to execute (FeatureClassToFeatureClass).
We looked at the constraint being violated and it seems the layers we are trying to import have an SRID not in the SDE.SPATIAL_REFERENCESS_TABLE. When we compare the Spatial_references table on two test servers we have and production we find they are have all different number of records on that table (20 or more on the test servers) and production in particular(the server producing the error) has only 5 records on that table.
The data loads fine on the older servers but not on the production server.
Has anyone seen this problem before?
Why is the SPATIAL_REFERENCES tables different on all servers?
Should it get updated when new layers are uploaded?
Thanks,