Troubleshooting common issues

Address errors encountered within the portal to ensure continuous access to the management suite. Contact your system administrator if the resolution requires infrastructure-level changes.

Performing system diagnostics

Use the built-in command-line tools on the WarehousePG Enterprise Manager (WEM) host to identify configuration errors or connectivity gaps.

Validate active configuration settings

Run the setup verification tool to ensure your current environment variables and database strings are functional:

wem setup --verify

See wem setup command reference for details.

Perform a comprehensive health audit Check for missing dependencies, incorrect file permissions, or service-level connectivity issues:

wem doctor

See wem doctor command reference for details.

Connectivity issues

Issue: Can't connect to the database

If WEM is unable to reach the WarehousePG cluster:

1. Ensure the database is active and accepting local connections:

   → WrapCopy

   psql -d postgres -c "SELECT version();"

2. Verify that the WEM connection strings are correctly set in the environment:

   → WrapCopy

   env | grep WHPG

3. Use the built-in WEM tool from the WEM host to validate the current configuration:

   → WrapCopy

    wem setup --verify

4. Test the credentials directly via the CLI using the same parameters defined in the WEM Settings tab within the Users panel.

   → WrapCopy

   PGHOST=localhost PGUSER=gpadmin psql -d postgres -c "SELECT current_database();"

Authentication and access issues

Message: "Session expired"

Cause: Your security token has timed out due to a period of inactivity.

Solution: Select Log In to return to the authentication screen and re-enter your credentials.

Error: "Permission denied"

Cause: Your assigned role doesn't have the authorization required to perform the requested action.

Solution:

1. Verify your current role in the top right bar.
2. Review the Role permissions matrix to confirm if the action is permitted for your role.
3. If you require elevated access, contact your administrator to request a role change.

Query editor restrictions

Issue: Query is blocked

Symptoms:

• "Query blocked" error messages.
• Inability to execute INSERT, UPDATE, or DELETE statements.
• DDL commands (CREATE, DROP) are rejected.

Cause: WEM enforces role-based SQL restrictions to prevent accidental data loss or unauthorized schema changes. Review the Role permissions matrix to confirm if the action is permitted for your role.

Observability and metrics

Issue: Charts aren't displaying

Some tabs display the error Prometheus not configured. Set PROMETHEUS_URL to enable metrics charts.

Cause: The connection to the Prometheus metrics server is either not correctly configured or down.

Solution:

1. Verify that Prometheus is running and reachable via the URL defined in the Settings tab within the Management panel.
2. Check network connectivity and firewall rules between the WEM server and the Prometheus endpoint.

Issue: Logs aren't loading

The Loki Logs tab within the Logs panel reports the error: Loki integration is not configured.

Cause: The Loki log aggregation service is unavailable or the URL is incorrect.

Solution:

1. Ensure the Loki service is active.
2. Verify the Loki URL in the Settings tab within the Management panel.
3. Check server-side logs for Connection Refused errors.