Error: FDO error: -2147215951 : Target state not found in the STATES table
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.