topic Re: User Schema Geodatabase Creation Errors in Data Management Questions

User Schema Geodatabase Creation Errors

CuyahogaGIS — Wed, 13 Mar 2013 14:40:31 GMT

Using ArcGIS 10.1, ArcSDE 10.1 and Oracle 11 R2.

We have successfully created our SDE Master schema and exactly 1 User Schema Geodatabase on our Oracle instance.

We cannot seem to create another successfully.

We are using the Create Enterprise Geodatabase tool and all required permissions are granted to both the SDE user and the User Schema User in which we will be creating the child Geodatabase: (All of which seems like overkill since we are using the SYS account to run the tool as required.)

On our second attempt to create a User Schema Database, the tool got through the table creation part, but exited with an error before creating the view objects.

On all subsequent attempts the tool gets as far as creating a user, (if not existing,) but will create no objects beyond that.

Does anybody have this experience and can anybody offer suggestions?

Thank You!

Re: User Schema Geodatabase Creation Errors

VinceAngelo — Wed, 13 Mar 2013 16:02:16 GMT

What exact error is being generated (as text, not image, please)? I've seen strange
errors after creating 50-55 user-schema geodatabases in one particular install:

ORA-00001: unique constraint (OWNER051.R310_SDE_ROWID_UK) violated

but haven't been able to reproduce them.

What exact version of Oracle are you using (e.g. 11.2.0.d.e)?

- V

Re: User Schema Geodatabase Creation Errors

MelissaJarman — Tue, 19 Mar 2013 11:33:52 GMT

Joe logged a Support Services incident and we were able to work through these issues. It ends up that somehow one of his user schema geodatabases was partially populated. We later determined in troubleshooting that this may have occurred due to some of the objects within the SDE schema being invalid in his database prior to using the 'Create Enterprise Geodatabase' tool.

We installed the admin commands that are part of the ArcSDE for Oracle install at 10.1 to be able to use the sdesetup -o delete command and remove this user schema geodatabase. In trying to use the sdesetup -o delete we received error messaging due to this not being considered a complete user schema geodatabase.

sdesetup -o delete -d ORACLE11G -u schema_owner -p password -i 5151:userschema
ERROR deleting geodatabase, Error = -416

In this case we had to drop the user and manually clean the entry within the instances table.

Deleting a geodatabase from a user's schema
http://resources.arcgis.com/en/help/main/10.1/index.html#//002n0000008t000000
==================
The following software bug has been logged for this type of situation where the sdesetup -o delete is not cleaning up the user schema geodatabase properly:
NIM085714 - Improve the �??sdesetup �??o delete�?? process so that it cleans the metadata inside the sde.instances table.
====================
Problem: Invalid objects and ST_GEOMETRY operators failure after revoking upgrade privileges
http://support.esri.com/en/knowledgebase/techarticles/detail/37915

Re: User Schema Geodatabase Creation Errors

JimDickerson — Thu, 04 Apr 2013 19:49:17 GMT

I had a problem where I could neither install or delete the user_schema so I started over with different names. But the failed name still shows up with sdemon -o info -I instances.

I already removed the user and tablespace. Did manually cleaning the instance table consist of just removing that one row?

Jim