Troubleshooting

Driver not found

• Verify the configured driver class.
• For generic JDBC, put the driver JAR in ~/.dataiq/jars/.
• Restart OL DataIQ after adding drivers.
• Check server logs for driver-loading failures.

Connection fails

• Confirm JDBC URL, credentials, and schema.
• Verify the database is running and reachable.
• Test host and firewall connectivity.

Query timeout or memory pressure

• Increase the configured query timeout when appropriate.
• Optimize the query and add indexes.
• Use LIMIT/TOP, pagination, and targeted column lists rather than SELECT * on large tables.
• Increase JVM heap only after addressing query/result-size issues.

Hub issues

Verify the Hub URL, API key, service status, and network connectivity.

For additional diagnosis, review browser-console errors, OL DataIQ server logs, and database permissions.