Can't enable feature access on ArcGIS Server 10 - problem with ArcSDE and PostgreSQL

[RobertSmith5]

Good day,
I've been working to install and configure an instance of ArcGIS Server 10 on a remote computer locally on our network. So far, I've been successful in publishing both MXDs and MSDs to the server and able to access them on the local network using user connections from arc catalog. However, whenever I try to enable feature access during publishing from either the arc catalog admin connection or the web manager.

When publishing an optimized service from ArcGIS Desktop to the server (feature access enabled), I get the following error:
" Configuration SERVICENAME.MapServer can not be started. Server Object Instance creation failed on machine SERVERNAME. "

I've read in another part of the ESRI forums in a search that in order for feature access to be enabled I need to either have an instance of ArcSDE set up and working with a database or use a geodata service. So, I installed and set up arcSDE with postgreSQL 8.3, can access the geodatabase perfectly using the direct connection method from arc catalog on the local machine but not over the network. I still can't get feature access to work and I'm running out of ideas and things to search for.

If someone could help me with this I would greatly appreciate it! I'll try to list all the details I can think of that may be relevant below.

The machine is running on our local network and vlan, connected to a university domain. The server is installed on a local account called ECONET and there are the the appropriate accounts created for the SOM and whatnot. All accounts we use for administering the server are added to the agsadmin and agsusers groups on the local machine and we have also added domain accounts to these groups.

That's all I can think of right now, if you need any more info, please ask and I'll provide!

Cheers and thanks a lot,

Robert Smith

[KimPeter]

Hi Robert,

Did you alter the pg_hba.conf file so that the PostgreSQL database cluster will accept remote connections?

I'm guessing you're on Windows, since you said you were connecting locally from ArcCatalog to the database.  Here's a topic about setting up remote connections when PostgreSQL is on Windows:
http://help.arcgis.com/en/arcgisdesktop/10.0/help/#/Configuring_a_PostgreSQL_database_cluster_on_Win...

Also, does the SOC account have access to the geodatabase and .sde file?
http://help.arcgis.com/en/arcgisserver/10.0/help/arcgis_server_dotnet_help/index.html#/Preparing_res...

[RobertSmith5]

Did you alter the pg_hba.conf file so that the PostgreSQL database cluster will accept remote connections?

I'm guessing you're on Windows, since you said you were connecting locally from ArcCatalog to the database.  Here's a topic about setting up remote connections when PostgreSQL is on Windows:
http://help.arcgis.com/en/arcgisdesktop/10.0/help/#/Configuring_a_PostgreSQL_database_cluster_on_Win...

Yes, I've allowed (trust) the local machine (127.0.0.1/32) and all machines on the local network vlan (132.206.20.0/24) to md5 (but it was trust before, still didn't work). The IP of my workstation laptop is also set to trust.

Also, does the SOC account have access to the geodatabase and .sde file?
http://help.arcgis.com/en/arcgisserver/10.0/help/arcgis_server_dotnet_help/index.html#/Preparing_res...

Yes, I've allowed permission for all users in the asgadmin to access the whole system and data drives for testing purposes, as well as the share.

[RobertSmith5]

I forgot to mention that while trying to connect to the sde database from another computer I get a "bad login user" error, even when using the exact username and password of the sde database user (kept sde and sde for testing purposes). I'm using "sde: postgresql:SERVERNAME" (space included to cancel the emoticon) in the service field as instructed. I'm not sure if this has anything to do with the other problem or not but I thought I'd mention it.

[RobertSmith5]

So, I seem to have figured out how to enable feature access. I added data from my sde database to a map and made a mapservice out of it and was able to successfully host it on my server with feature access enabled. However, I now get an error message that reads like so:

" Create replica failed. Can't create empty replica. Read only data or unversioned data cannot be replicated. Data versioned with the option to move edits to base cannot be replicated, GlobalIDs are required for two way and one way replica data. Creating one way archiving replica requires archiving to be enabled on the parent. "

I'm going to look through http://help.arcgis.com/en/arcgisserver/10.0/help/arcgis_server_dotnet_help/index.html#//009300000021... and try to get this working, but any advice you can offer on the subject would be invaluable.

Thanks,
Robert Smith

[HeatherMcCracken]

Robert,

What operation are you doing when you get the error? Are you using the "Create Local Copy For Editing" command?
If so, are your Local Editing settings set to store data in ArcSDE? (The default is to a file gdb). Can you confirm you do not get this error when going to a target file gdb?

-Heather

[RobertSmith5]

So, I seem to have figured out how to enable feature access. I added data from my sde database to a map and made a mapservice out of it and was able to successfully host it on my server with feature access enabled. However, I now get an error message that reads like so:

" Create replica failed. Can't create empty replica. Read only data or unversioned data cannot be replicated. Data versioned with the option to move edits to base cannot be replicated, GlobalIDs are required for two way and one way replica data. Creating one way archiving replica requires archiving to be enabled on the parent. "

I'm going to look through http://help.arcgis.com/en/arcgisserver/10.0/help/arcgis_server_dotnet_help/index.html#//009300000021... and try to get this working, but any advice you can offer on the subject would be invaluable.

Thanks,
Robert Smith

Okay, I've managed to get the feature service working roughly. I somehow versioned the data and created global ids and that solved the problem for my test data. GREAT!

You can close this post or what ever is is that you do when a problem is solved 😃

[HeatherMcCracken]

Just to be clear - you do not need to version your data, nor add globalIDs to enable Feature Access.

However, in your case you are finding you do.  Which, i think means the following....in your case I'm guessing you are trying to use the "Create local copy for editing" command, and the target of your local copy is SDE? Is this true?  The default target is file geodatabase.  You can set the target workspace type on the Distributed geodatabase toolbar > Options, and going to the Local Editing tab.

http://resources.arcgis.com/en/help/main/10.1/index.html#/Setting_options_for_editing_server_layers_...

If you set the target to SDE, the data needs to have globalIDs and be versioned because we are using a 2 way replica behind the scenes to synchronize the changes between the local copy and the server.  If your target is a file geodatbase, your data does not need to be versioned or have globalIDs because we are using Checkout replica to sync the changes.

If you get the chance to post an answer the above question that would be really helpful to others coming along and reading this posting.

Thanks!
-Heather