The Garbage Gobbler Web Mapping Application tracks the location and status of roadside garbage cans.

It consists of: 

1. An Oracle database running on a Linux host with:
2. A GeoServer instance running on a Linux host with:

• Table APP_MGG.MGG_GOBBLER_LOCATION
• Table APP_MGG.MGG_GOBBLER_SPONSOR
  • Where records in each table are identified by a unique key value.
• Sequences to generate new values.
• Triggers to populate new key values on insert.
• MGG_GOBBLER_LOCATION has a SDO_GEOMETRY column.
• Each MGG_GOBBLER_LOCATION must belong to one and only one MGG_GOBBLER_SPONSOR as associated by a foreign key relationship.
• Proxy User APP_MGG_PROXY_GIS_READ
• Proxy User APP_MGG_PROXY_GIS_EDIT
• Data Stores (JDBC connections) to Oracle representing each proxy user.
• Feature Types MGG_GOBBLER_LOCATION_READ_ONLY and MGG_GOBBLER_LOCATION_EDIT
• SLD styles for each feature type
• Separate Data Security settings for each feature type granting access by role.

Note: When an HTTP request is made, GeoServer takes user's credentials and queries the permissions database to see if they possess the correct access level for reading and/or writing.

1. A JavaScript/HTML5 mapping client leveraging OpenLayers, JQuery and Bootstrap JavaScript libraries which allows users with administrator access the ability to update the location of garbage cans using web client-based editing tools which communicate via OGC REST calls to GeoServer.

                

The company has migrated the Garbage Gobbler Web Mapping Application (application tier and databases) and to all new host infrastructure as per central government directives. The migrations were performed quickly by contracted staff with limited understanding of the specific details of each application. Sometime after the migration, the application administrator opened a help ticket claiming she is no longer able to update garbage can locations. Describe how you would troubleshoot this ticket. Note any specific software or access you might need to perform this troubleshooting.

Answer rating: 100% (QA)

To troubleshoot the issue reported in the help ticket regarding the inability to update garbage can locations in the Garbage Gobbler Web Mapping Appli... View the full answer