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!
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.
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.