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 - Make sure you are logged on as the oracle database owner account (usually '
oracle'). - Check that the environment variable
ORACLE_SID points to the correct database instance. - Connect as sysdba:
connect / as sysdba - 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 | Code Block |
|---|
fix_201701_addMissingIndexes.bat <SERVER> <DATABASE> <USER> |
SQLServer | Code Block |
|---|
fix_201701_addMissingIndexes.bat <SERVER> <DATABASE> <USER> |
where SERVER Database server DATABASE Database to update. USER - Fews system user |