The current Server Manager validation process provides limited utility when multiple machines are involved. I propose the following enhancements:
- Parallel and Incremental Validation:
The Validate All function should not wait for every validation task to complete before returning results.
Instead, it should display results from completed validations immediately, while allowing ongoing tasks to continue in the background. - Adaptive Timeout for Datastores:
Introduce shorter timeouts for datastores that take an extended period to respond.
This prevents indefinite waiting periods without visibility into which datastores are responsive and which are still pending validation. - Improved Datastore Management:
Datastores that have not been validated cannot currently be removed in Server Manager (only via the Admin directory). This should be fixed. - Clearer Error Attribution:
In configurations with a Primary and Standby Relational Datastore, validation failures do not indicate which machine caused the issue.
The Server Manager should list all individual datastores (Primary, Secondary, and Cluster) with their respective validation states. - Enhanced Logging and Error Messaging:
Implement more descriptive error messages and logging. For instance, the error
“ERROR: function sde.get_rowid(character varying, character varying, integer) does not exist
Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 15
appears in the Portal Map Viewer when editing feature services connected to an invalid or partially upgraded datastore.
Such errors should explicitly indicate that a datastore issue may be the root cause.
(Note: This issue also occurs for registered (e.g. Oracle) databases and should be investigated further.)
- Improved Datastore Validation Checks:
The describedatastore operation should verify datastore validity more thoroughly.
Currently, both describedatastore and validate datastore in Server Manager may return positive results,
even when the actual machine-level validation (as viewed under server/admin/data/datastoretype/.../machines) indicates problems.
