user based schema geodatabase

3278
3
05-01-2015 02:26 AM
NCSCMNCSCM
New Contributor III

Hi,

Have created user-schema geodatabase .while trying to shift from  sde.DEFAULT version of the master sde geodatabase to user-schema geodatabase from the Schema drop-down list . am getting below attached error.

Thanks

Ramya

0 Kudos
3 Replies
ChristianWells
Esri Regular Contributor

Can you please post the results from the following query?

select instance_id, instance_name, status from sde.instances;

NCSCMNCSCM
New Contributor III

Thanks for your response.as suggested please find the result of the query.

Q2.png

0 Kudos
MelissaJarman
Esri Contributor

I have seen this error before from there being orphaned instance_name listings within the sde.instances table. From the query that Christian had you get the output from I would check to see the specified schemas actually exist in the geodatabase.

Partially created user schema geodatabases could be caused from dropping users within the database that own user schema geodatabases leaving orphans entries within the SDE.Instances table. I have also seen this occur from invalid database objects in the SDE user schema prior to using the 'Create Enterprise Geodatabase' tool which causes issues creating new user schemas.... ORA-29900, ORA-06540, and ORA-06553 errors can be associated with this related cause - more detail can be found in KB 37915 in solution section.

-----------------------------------------

It is also possible that additional attempts to create new user schema geodatabases will fail but create additional partial/corrupt user schema geodatabases.

Are there user schemas that were recently attempted to be created with error or perhaps user schemas in the database that were dropped??