In my project I publish map, feature and dynamic services. My task is :
- Add tables or views from Oracle 12c DB to ArcMap, then assign symbology and scale.
- Prepare and save final MXD, then publish it as map, feature and dynamic service.
Until now I understood that the data source of a map service is a MXD, and MXD has a database (.sde) connection. But sometimes the database connection of MXD gets broken and red exclamation appears against layers. But if I execute a query in REST service URL then I do see increased record counts than previous record count. Now if MXD database is broken then how are new records appearing through REST URL query? I think I am missing something here in back end process.