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: NIM059178Now 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 existsArcGIS 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.