Hello!
I have a map service that references a non-spatial table (more specifically a view) stored in a SQL Server database. This table is related to a spatial layer (i.e., feature class) in the map service. I have registered both the non-spatial SQL Server database and the file geodatabase containing the feature class with ArcGIS for Server. After publishing the map service, I made changes to the tables referenced by the view in SQL Server. These changes show up when I look at the table in the source mxd for the map service. However, these changes do not show up when I do a search of the spatial layer and try to view information in the related table in the web mapping application (ArcGIS Viewer for Flex) that I'm using to view the map service.
Do I need to overwrite the map service in order to get these changes to show up? I registered my data sources with ArcGIS for Server in an attempt to preclude the need for overwriting the map service every time the SQL Server database is updated. If I shouldn't need to do an overwrite of the map service, then do you have any suggestions for things I should look at/try out in order to identify the source of the problem?
Thank you in advance for any assistance you can provide.
Virginia
I have a map service that references a non-spatial table (more specifically a view) stored in a SQL Server database. This table is related to a spatial layer (i.e., feature class) in the map service. I have registered both the non-spatial SQL Server database and the file geodatabase containing the feature class with ArcGIS for Server. After publishing the map service, I made changes to the tables referenced by the view in SQL Server. These changes show up when I look at the table in the source mxd for the map service. However, these changes do not show up when I do a search of the spatial layer and try to view information in the related table in the web mapping application (ArcGIS Viewer for Flex) that I'm using to view the map service.
Do I need to overwrite the map service in order to get these changes to show up? I registered my data sources with ArcGIS for Server in an attempt to preclude the need for overwriting the map service every time the SQL Server database is updated. If I shouldn't need to do an overwrite of the map service, then do you have any suggestions for things I should look at/try out in order to identify the source of the problem?
Thank you in advance for any assistance you can provide.
Virginia
I am now able to do queries of related tables that are pulled from a remote SQL server database- which is on a different network- via the "query related records" function in the rest services directory.
I need to do more testing to pinpoint all the necessary elements but at this point these were the changes I made:
1) Set up a local (rather than domain) account for SQL server that matches the credentials for the ArcGIS for Server account and that is a sysadmin and has db_owner permissions for the database. This account uses windows rather than SQL server authentication when accessing the database.
2) Used operating system authentication when connecting to the remote SQL server database via ArcCatalog
3) Removed a definition expression that had been placed on the related table in the mxd file prior to publishing the map service. This last step is definitely necessary- again I'd have to do more testing to see which of the first two steps was needed in order for queries of the related tables in the map service to work.
Virginia