Query Engine Troubleshooting

About this task

There may be a rare instance when the Query engine does not seem recognize the TADB when a user tries to run an expression.

This could happen, for example, if someone  manually entered an expression directly into the database table instead of through the Query Engine or if someone directly changed the structure of the database.

If you cannot correct the problem any other way, you can use a Query Engine Reset feature.

CAUTION: The Query Engine reset tool should be used only as a last resort.

When you use the tool it:

Procedure

  1. Waits for any queries that are going on to stop first.
  2. Puts all queries that have not yet started on hold.
  3. Will stop until the last running query is done,

    The Stop Queries will last until the longest currently running query finishes, which could require a substantial amount of time.

    This is the issue that particularly requires your attention before you decide to go ahead.

  4. Does the following when the last query is completed.
    1. Reads the meta-data.
    2. Re-reads the expressions out of the database.
    3. Allows the queries to resume when the reset is complete.

    Do the following to use the Reset tool.

    1 Click the Expression Browser button.
    2 Select Reset on the menu.