Latest Contributions by KimPeter

Hi, No matter which schema they are in (dbo or sde), geodatabases have the same functionality. The difference is just in who "owns" the geodatabase system tables, procedures, and views.  Since your users are creating their own databases, they are dbo in the databases they create.  When you enable a geodatabase while connected to the database as a login that is dbo, the geodatabase is created in the dbo schema. Some people prefer to create an sde user and schema in the database, connect as the sde user, and create the geodatabase. The geodatabase is then created in the sde schema. This makes it easier to identify which objects are geodatabase system objects.  But if you aren't concerned with visually identifying the geodatabase system objects, dbo schema is fine.  🙂 ... View more

There are also SQL examples here: http://resources.arcgis.com/en/help/main/10.2/#/Determining_which_data_is_versioned/006z000000v1000000/ ... View more

Rather than get an ecp file, you could instead point to the keycodes file that was generated when you authorized ArcGIS Server, as indicated in the Create Enterprise Geodatabase tool side panel help. "Authorization File Provide the path and file name of the keycodes file that was created when you authorized ArcGIS for Server Enterprise. This file is in the \\Program Files\ESRI\License<release#>\sysgen folder on Windows and /arcgis/server/framework/runtime/.wine/drive_c/Program Files/ESRI/License<release#>/sysgen directory on Linux. If you have not already done so, authorize ArcGIS for Server to create this file." ... View more

Hi Jacob, If you can, please contact Esri support or your distributor (if you're outside the U.S.) to help you troubleshoot this. -Kim ... View more

Please contact Esri technical support so they can help identify the issue. ... View more

Hi Manuel, Did you try it without the "hom" portion of your URL?  I think you just need the <fully qualified server name>/<web adaptor name> in the URL. ... View more

Did you install the DBMS client on the ArcGIS Server machine? If so, and your ArcGIS administrator account has been added to your SQL Server instance and databases but you still get this message, check to make sure that the ArcGIS Server service is not running under the Windows "local service" account. ... View more

Completed successfully...? (I hope) Out of curiosity, is your PostgreSQL server a VM?  Or possibly on a subnetwork?  39 minutes is an awfully long time for that tool to run.  Based on what messages are shown from the GP tool, you had all the right information and configuration needed for the tool to run successfully, so I wonder what would make it take so long.  I suppose it could be a network or hardware issue too, though. ... View more

Dominik, It doesn't look like the tool got to the point of creating an sde schema in your database, so you do not have a geodatabase; geodatabase system tables are all stored in the sde schema.  I'm pretty sure the reason the creation failed the first time is the mixed-case you specified for the database name. By default, object names in PostgreSQL are in lower case, which is seen in your pgAdmin screen shot. Try specifying the name of the database in lower case and run the tool again. http://resources.arcgis.com/en/help/main/10.2/#/Creating_a_database_and_geodatabase_in_PostgreSQL/002p000000ss000000/ Type the database name in lower case; upper- and mixed-case object names are not supported for geodatabases in PostgreSQL. You have to specify an sde user name and password when creating a geodatabase in PostgreSQL.  Since this tool also works with SQL Server and Oracle, for which the sde user name and password might not be needed, the tool shows those parameters as optional.  However, they are not optional for PostgreSQL.  Unfortunately, gp tools are not context sensitive in that way. Since you already have an sde login role, so be sure you specify the password of that existing sde login when you run the tool again. As indicated by one of the error messages you got, you cannot connect to the postgres system database from ArcGIS.  The Create Enterprise Geodatabase will (and did) create a database for you to use.  Be aware, though, that this database does not contain the PostGIS type, because it uses the template1 PostgreSQL database, as indicated in the side panel help for the Create Enterprise Geodatabase tool. If you want the geodatabase to contain the PostGIS geometry type, you must manually create a database using your PostGIS template, then you can specify that database when you run the Create Enterprise Geodatabase tool.  Though, looking at your pgAdmin screenshot, it appears that you did not reinstall PostGIS...? To answer your question about ArcSDE...at this point, the ArcSDE installation installs an ArcSDE application server, which is a way for your users to connect to the geodatabase using an ArcSDE service, and command line administration tools.  You do not have to install that. Other than the mixed-case name, it looks like you did everything correctly.  You just got distracted by some other stuff along the way. 🙂 ... View more

Hi Eric, Did you publish the feature service from that same ArcGIS Desktop installation?  I mean, can you connect to the source database from that Desktop? Are you adding the feature service to ArcGIS Desktop from an ArcGIS Server user connection?  I seem to recall seeing an error like that when I'd been using the wrong type of ArcGIS Server connection. (I was using my publisher connection at the time, I believe.) ... View more

The master geodatabase must be in the sde schema, owned by a user named sde. ... View more