4.5. Troubleshooting Visual Explain

4.5.1. Problems During Operation

The SQL command did not execute when I pressed [Enter].

The [Enter] key enables you to create multi-line SQL commands. To execute an SQL command, either click on the blue Explain/Explain Analyze icon, select Statement => Explain ([Ctrl]-[E]), select Statement => Explain Analyze ([Ctrl]-[L]), or press [Ctrl]-[Enter].

The Edit, Copy, or Delete button on the Edit Database dialog is grayed-out.

You need to select a database connection before you can perform these operations. For example, select the database connection you want to edit by clicking on it, then click on Edit.

I get a warning about lock files when I open a second copy of Visual Explain concurrently.

Visual Explain is designed to run only as a single copy. The first copy creates a lock file that prevents other copies from saving configuration data. All other functions behave normally.

If Visual Explain abnormally shuts down, the subsequent restart may give a warning about an existing lock file. In this case, remove the lock file and restart Visual Explain.

The EXPLAIN button is disabled.

The EXPLAIN button remains disabled until you have established a connection to a database.

The Sun JRE/JDK complains about key binding errors.

If you use the Sun 1.3 JRE/JDK with rhdb-explain, you may see messages about key binding errors. The messages are incorrect--the key bindings actually work. However, if you use the Sun 1.4 JRE/JDK instead, there are no error messages.