kuiperfoliage

"does not exist or is not supported" - NIM059178

Discussion created by kuiperfoliage on May 12, 2011
Latest reply on May 13, 2011 by kuiperfoliage
I moved an existing sde geodatabase (MS SQL) from one machine to another (production machine).

I initially had problems accessing the data from the geodatabase on the new machine. I was getting the following error:

"DBMS table not found [*********][STATE_ID=0]"

I traced this back to the following problem: NIM059178

Now i can access the data through ArcCatalog and (pre)view the data, but my Python scripts keep failing when they try to access the same feature class:

Failed to execute. Parameters are not valid.
ERROR 000732: Input Features: Dataset <MyFeature> does not exist or is not supported
Failed to execute (Select).


I think this is related to the same problem, but i installed all the current patches and the problem still exists

ArcGIS Desktop 10
 ArcGIS Desktop 10 Service Pack 1
 ArcGIS Desktop 10 Service Pack 2

ArcGIS Server 10 - GIS Services
 ArcGIS Server for the Microsoft .NET Framework 10 - GIS Services Service Pack 1
 ArcGIS Server for the Microsoft .NET Framework 10 - GIS Services Service Pack 2

ArcGIS Server 10 - Web Applications
 ArcGIS Server for the Microsoft .NET Framework 10 - Web Applications Service Pack 1
 ArcGIS Server for the Microsoft .NET Framework 10 - Web Applications Service Pack 2

ArcGIS Server 10 - Web ADF Runtime
 ArcGIS Server for the Microsoft .NET Framework 10 - Web ADF Runtime Service Pack 1
 ArcGIS Server for the Microsoft .NET Framework 10 - Web ADF Runtime Service Pack 2

ArcObjects SDK for the Microsoft .NET Framework 10.0
 ArcObjects SDK for the Microsoft .NET Framework 10 Service Pack 1
 ArcObjects SDK for the Microsoft .NET Framework 10 Service Pack 2

ArcSDE for Microsoft SQL Server 64 bit 10
 ArcSDE 10.0 General Update Patch for SQL Server
 ArcSDE for Microsoft SQL Server 64 bit 10 Service Pack 1
 ArcSDE for Microsoft SQL Server 64 bit 10 Service Pack 2


Any idea how i can fix this or further debug this without having to re-populate all the data!

EDIT:
Note, i'm using the same .sde connection file in ArcCatalog as in my Python scripts. This works on my Dev machine. The users in the database have full access/rights.

Outcomes