Page History

A number of client have reported a slow MC RollingBarrel. This issue can be resolved by adding indexes using the 2017.01 fix_201701_addMissingIndexes.sql script provided in MC build #71105. See fix201701_missing_indexes.zip

Oracle

1. Make sure you are logged on as the oracle database owner account (usually 'oracle').
2. Check that the environment variable ORACLE_SID points to the correct database instance.
3. Connect as sysdba:
          connect / as sysdba
4. Run the data_update.sql script. This takes one argument, the application username or schema name the FEWS database is running under, e.g.
          @fix_201701_addMissingIndexes.sql applicationuser

Postgres

fix_201701_addMissingIndexes.bat <SERVER> <DATABASE> <USER>

SQLServer

fix_201701_addMissingIndexes.bat <SERVER> <DATABASE> <USER>

where

SERVER Database server

DATABASE Database to update.

USER - Fews system user A faster version of the MCRollingBarrel has been made available in revision #70873 of the 2017.01 branch. This has been done in response of a number of client reports of the MC RollingBarrel being exceptionally slow in 2017.01. For upgrading to this improved version, ask FEWS support for the latest Master-controller build, and perform a MasterController update (see Master Controller Upgrade of a Higher build number within the Same Fews release version). Also the rollingbarrel of non-dda OC / FSS 2017.01 clients shall be using the improved RollingBarrel when using patches with a revision number #70873 or higher.