topic Problem with creating Schematics Dataset in a enterprise database in Spatial Statistics Questions

Problem with creating Schematics Dataset in a enterprise database

Anonymous User — Mon, 31 Mar 2014 12:01:25 GMT

Original User: tonycmx

I'm recently trying to create a schematics dataset in my PostgreGIS database. But it always raise an error:
[ATTACH=CONFIG]32641[/ATTACH]
After getting this warning, when I refresh the database, I get a new file:"postgis20.sde.SCH_UNIQUEID". So I try to create the schematic dataset again, another error is shown:
[ATTACH=CONFIG]32642[/ATTACH]

What would be the reason for these error?
Thank you for taking a look on my question!

Re: Problem with creating Schematics Dataset in a enterprise database

RickAnderson — Tue, 01 Apr 2014 14:21:12 GMT

The error is very clear to me. To create the first schematic dataset that has ever been in an enterprise geodatabase, you must be connected as the SDE user. The reason for this is that some core system tables are created that must be owned by SDE. After this initial creation, you can delete that dataset if you want (the system tables remain) and then log on as any user that has create table permissions and create a new schematic dataset.

Re: Problem with creating Schematics Dataset in a enterprise database

Anonymous User — Wed, 02 Apr 2014 07:25:56 GMT

Original User: tonycmx

Thanks a lot! I should have read the tutorial better.