Error: FDO error: -2147215951 : Target state not found in the STATES table

Error Message

After installing ArcSDE, and while connecting to ArcSDE through ArcCatalog, ArcCatalog returns the following error message:

"Failed to connect to specified server
FDO error: -2147215951
Target state not found in the STATES table"

This is most often seen with a 'Direct Connect' connection with Oracle Spatial, where the ArcSDE application server has not been installed.


State_lineages table may not have been populated.

Solution or Workaround

Select one of the following two options to work around the error:

  • Check for rows in the SDE schema states and state_lineages tables:

    select * from sde.state_lineages;
    select * from sde.states;

    If the sde.state_lineages has no rows, insert one row, with zeros for:

  • Run the sdesetupor9i -o upgrade command, which may force these rows to be populated.