Data Migration Documentation

Public and Private Queries

When migrating from a previous version of Calyx RIM to a newer, major version of the product, your public and private queries will not be saved.

After your migration is completed, if an error message appears when running a query saved in your previous version, you can use the selected values on the query page to create a new saved query.

To salvage a broken public or private query after a migration:
  1. Log on to Calyx RIM, and in the GO TO menu click Querying.
  2. On either the Public Query tab or the Private Query tab, locate a saved query that is broken. (When you left-click on a query, an error message appears if the query is broken.
  3. Hover your pointer over the query link and copy the numeric identifier of the hyperlink target of the query. (In this example image, the numeric identifier value is 1761858.)
  4. Execute the SQL using the copied numeric identifier value.
    delete from mgr.report where id = 1761858;