title: Unable to import data into ArcSDE (9.3.1) and PostgreSQL (8.3.0)
body: <p>I've just installed ArcGIS Server Enterprise Advanced with ArcSDE and PostgreSQL, on a virtual Windows Server 2008 box.</p>
  
  <p>After installing, I've been trying to import a feature class (stored in a shapefile) into the geodatabase. </p>
  
  <p>In order to do this I've created a connection to ArcSDE (not a direct database connection) using ArcCatalog -> Database Connections -> Add Spatial Database Connection. I've tested the connection successfully. </p>
  
  <p>However, when I run the tool "Feature Class to Geodatabase", I get the following error message: <pre>Failed to convert DNorthEnergyRiskMaps\RiskMapsLibraryTests\Resources\ProbabilityTools\TestFacies.shp. ERROR 000210: Cannot create output Database Connections\s2008NE.sde\arcgis.sde.TestFacies 
  Failed to execute (CopyFeatures).</pre></p>
  
  <p>According to <a href="http://blogs.esri.com/Dev/blogs/geoprocessing/archive/2008/09/05/Digging-deeper-_2D00_-Troubleshooting-geoprocessing-errors-when-using-ArcSDE-data.aspx" rel="nofollow noreferrer">this</a> blog post, this error is a generic "catch-all". </p>
  
  <p>The blog post suggests some debugging steps which I've followed. I've had ArcMap create an <a href="http://www.mediafire.com/download.php?dgmnmdyeinj" rel="nofollow noreferrer">intercept file</a>. However, I'm non-the-wiser after looking at it (users at the ESRI forum says there are no errors in the intercept file). Maybe someone with more experience could interpret it better... </p>
  
  <p>Also, I've scanned through the ArcSDE and PostgreSQL logs... The only reported errors are in the latter log; multiple SELECT queries are failing because the target tables doesn't exist. Some examples: <pre>2009-09-29 13:33:38 CEST ERROR: relation "sde.sdb_surveydatasets" does not exist
  2009-09-29 13:33:38 CEST STATEMENT: SELECT 1 FROM arcgis.sde.SDB_SurveyDatasets WHERE 1 = 0
  2009-09-29 13:33:38 CEST ERROR: relation "sde.sch_dataset" does not exist
  2009-09-29 13:33:38 CEST STATEMENT: SELECT 1 FROM arcgis.sde.SCH_DATASET WHERE 1 = 0</pre></p>
  
  <p>Help would be much appreciated. </p>