Where's the data (SQL)

[DavidBrooks3]

I have a geospatialdatabase on an ArcServer using SQL Server 2008.  I created the table objects using ArcCatalog.  Here's where I get confused.  I have created a map and linked it to the ArcServer SQL database.  When I add/edit features the adds/updates are not going into the SQL tables rather some other unknown database.  At this point it is not clear where this data is being stored.  There is only one version of this database.

Another issue is that when users create there own map from the base map and they try to edit the features they get an error stating the table objects don't exist but I assure you they are present location unknown.  The odd thing is they can add and save features but not edit the feature data.

Any help and direction would be greatly appreciated.

[AlexeyTereshenkov]

Hey David,

Let me just clarify a couple of things. You have installed ArcSDE (was it Workgroup or Enterprise?) as well as MS SQL Server 2008. This implies that you have already ArcSDE (which you have licensed).

You have run your Post-Installation for the ArcSDE and have created your spatial database which is stored in the SQL Server. Then you have established the spatial database connection in ArcCatalog and specified the connection details (do you use ArcSDE isntances or direct connections?).

While having the connection established, you have created/loaded a feature class into your database using ArcCatalog. At this step, did you register your data as versioned (http://support.esri.com/index.cfm?fa=knowledgebase.whitepapers.viewPaper&PID=43&MetaID=721)? Have you enabled the move to base option?

If you did register your data as versioned and have not chosen the move to base option, then when editing data that are versioned even if you have just one default version in the database, the edits are stored not in the base(business) table, but in delta tables (A and D)  which are created when you register the data as versioned.

Please refer to this help page for details: http://help.arcgis.com/en/arcgisserver/10.0/help/arcgis_server_dotnet_help/index.html#/A_quick_tour_...

I have created a map and linked it to the ArcServer SQL database

This sounds unclear to me. Have you created a map document in ArcMap and added some of your feature classes from the database into it?

when users create there own map from the base map

I have no idea what you are talking about. Hm, do you users edit data from ArcMap, a web application, or a non-Esri application?

[DavidBrooks3]

Thank you so much Alexey for your response.  Forgive me for not being clear.  The sum of my experience with ArcGIS is a 2 day ArcPad course I took back in March and the rest I have done on the fly. 

I have ArcSDE workgroup installed and licensed.  With your reply I was able to add "Unregister as Versioned" to the toolbar and run it.  Then reran "Register as Versioned" checking the "move to base" checkbox.  Now the data is going to the appropriate tables.  Thank you!

The other issue I failed to describe persists.  I have a master map I created with admin rights in ArcMap - ArcEditor.  Everything works fine under those user credentials.  When other users open the map in ArcMap - ArcEditor and start editing the following occurs.  They can add and save features fine but when they try to edit the attributes an error box states "Attribute Update: An unexpected failure occurred. The specified raster column does not exist [database.dbo.table].  I thought the "move to base" would resolve this but it did not.  The odd thing is when users do the same thing using the ESRI web app all users can edit attributes without this error.  Any help is greatly appreciated.

Thank you for your time.

[AlexeyTereshenkov]

Hi David,

No problem 🙂 I hope you do understand the implication of the unregistering data as versioned. All your data changes from delta tables that have not been transferred to the base table will be lost and the A and D tables are deleted. Refer to the: http://support.esri.com/en/knowledgebase/techarticles/detail/24971 and http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Unregistering_data_as_versioned/002700...

I have seen this error about raster column just once I think. I assume that you have a feature class that contain a field of the Raster type where do you reference a raster? If so, here is the help page you might refer to: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Adding_raster_datasets_as_attributes_i...

Did you move your geodatabase from one machine to another (i.e., from production to development?).

Finally, I assume you work with SQL Server Express, right? Do you have SQL Server Management Studio installed? I was thinking about rebuilding indexes for the feature classes with the raster column.

[DavidBrooks3]

You did it again Alexey, thank you!

Sure enough all the layers throwing this error had an IMAGE (raster) field.  I deleted them out as we are using HyperPic mobile for image management that uses a PhotoID (text) field.  Voila, all users can now edit attributes.

Regarding understanding the implications of unregistering.  Because the users have yet to add permanent data there is no worries about the A and D tables being deleted. 

Thanks again!

[AlexeyTereshenkov]

Hey David,

I am glad it played out well. In case you will need a better understanding of the workflows in the geodatabase later on, please refer to these help sections:

Managing geodatabase in general:
http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/What_is_a_geodatabase/003n000000010000...

Managing your geodatabase in SQL Server Expess:
http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/What_are_database_servers_in_ArcGIS/00...

Good luck!