Where's the data (SQL)

Question

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 · Answer

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/003n00000001000000/

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

Good luck!

DavidBrooks3 · Answer

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 · Answer

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/00270000000z000000/

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_in_a_feature_class/009t000001np000000/

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.