Error: Failed to create feature class. DBMS table not found [database.user.fcname]
When creating data in an ArcSDE geodatabase stored within SQL server 2005 the following error message is displayed:
"Failed to create feature class. DBMS table not found [database.user.fcname]"
The schema set in the database is not the same as the username.
ArcSDE is hard-coded to look for a schema that matches the user name within the database specified. This particular problem only occurs with ArcSDE 9.1 sp1 and SQL server 2005, and is a result of the new concept of user schemas with SQL server 2005.
If users are going to be owning/creating data or making large selection sets that require user logfiles to be created, they must ensure that the user and schema name match exactly.
See the link in the Related Information Section below for a white paper with more information.
Solution or Workaround
Ensure that all new users have the same default schema name as their username within each database.
The following example is a screenshot of the log-in properties under the User mapping page in SQL Server Management Studio. This illustrates how the default schema name can be set when adding a login as a user within a particular database. Default schemas must be set for all users within each database.
Last Published: 9/22/2020
Article ID: 000008527
Software: ArcSDE 9.3.1, 9.3, 9.2, 9.1 Legacy Products