User cannot create items.Failed to create table. DBMS table not found sde.yourtable.

[MartinAshmore]

Hi,

I am creating a new geodatabase, SDE version 9.3.1 installed on SQL server 2008 RDBMS.

The database is setup, I have created numerous users and loaded data with them.

However I need to create another new user. I have followed the same procedure, but when I try to create data using this User I recieve the error message "Failed to create table. DBMS table not found [sde.yourtable.name]".

I have checked that the user has the correct database permissions (Connect, Create Function, Create Procedurre, Create Table, Create View, References), they also have the matching user names and schema, and the user name relates to a login.

If I attempt to create data using Arc Catalog the error above is received (failed to create table). However if I use the command "sdetable" I can create a new table in SDE using the new users credentials.

I have discounted keyword mispellings and dbtune errors as other users have already been created and loaded data sucessfully.

I have also deleted the login and user and recreated them from scratch.

Can anyone shed any light on this? I'm out of ideas.

Kind regards,

Martin

[MartinAshmore]

The plot thickens!

I've just used another pc with v10.1 and managed to use the same new user to create data without a problem. So the problem must be related to arc catalog on my pc.

Strange, the user can connect and everything seems fine. I have used the same version of catalog to load data for the existing working user - confused!

At least I know it's not something I have done wrong in SQL server.

Martin

[BirajaNayak]

Please contact ESRI Support Services to diagnose this specific user related issue.

[BirajaNayak]

Great. Re-install or repair of desktop on that client box may help.

[MartinAshmore]

Hi,

Thanks for the suggestion.

I just gave the repair a go on my desktop, but sadly the same problem exists.

To check I just tried another client on a different pc, same version, and that works fine. So that pretty much narrows it down to my pc.

I havent changed any settings or anything so cant understand whats changed:mad:

When I get a bit of time I will do a full reinstall and see if that resolves the problem.

Regards,

Martin

[MartinAshmore]

More confused now.

After using arccatalog on another pc and successfully loading data using the sde user, I was assuming that the problem related to my pc. However I installed ArcGIS 10 on another pc, but it cannot load data using this sde user, but can with other sde users. Clearly the problem isnt related to my pc only.

So far all attempts have been using the direct connection method. I have just tried application connect, and this has allowed me to load data from both the pc's that have not been allowing me to load data.

I have raised a support call with ESRIUK, hopefully they can help me get to the bottom of this.