59.9.2 Available operations

The functions provided by System Maintenance consists mainly in the reorganization of the fore mentioned database, the checking of its integrity, and its update according to the latest changes.

Once opened, the System Maintenance module would display the Etere system's current version (i.e. of the sql database) and available new version (i.e. to be installed), using the following colors to indicate the differences between versions:

Green - The current version is older than the new one, the system will be upgraded.
Yellow - The current version is the same as the new one, no update will be performed.
Red - The current version is newer than the new one; the system will be downgraded.

Available operations
All maintenance tasks available for the installed version are listed and described below:

Database_version  

Structure check
Check Main database structure - If enabled, the system maintenance function will be performed on the main database, including:
Tables - Create or update the tables and fields on which Etere is based.
Functions - Create or update the stored procedures used for Etere operations.
Other - Other minor operations such as the creation of a database index.
Do.Ma. db - If upgrading from Etere 21 or lower, all existing Do.Ma. data currently stored in the main database will be migrated to the a new Do.Ma. database (set in system settings).
Log db - If upgrading from Etere 24 or lower, all existing logs data currently stored in the main database will be migrated to the a new Log database (set in system settings)..
1 : Please note that this operation requires the user to have "sql administrator" permissions.
2 : A detailed view of this function can be obtained through the "Advanced Scripts View".
3 : if a database collation has been performed, execute this maintenance task to rebuild all database functions and stored procedures in Etere database.
Check Disaster Recovery database structure - If disaster had taken place and the Main database has been synchronized to the disaster recovery database at the DR site, enable the option to perform a system maintenance on database structure on the disaster recovery database.
You must have SQL Administrator rights in order to perform this function.

Common checks
SQL Reports Repository Maintenance - If enabled, the system would search the Etere installation directory and/or a user-defined directory for reports (.RPT and .RDL) files, updating the database according to the retrieved reports (existing reports will be updated, new reports will be inserted and no-longer-existing reports will be removed from the reporting server). 

Please refer to the Etere Reports > Updating the reports repository chapter for detailed information on this function.

NB: It is not mandatory to run “SQL Report Repository Maintenance” on SQL Database Server.
Delete unused fields - If enabled, all fields used by former Etere versions but no longer used in the current version will be deleted from the database tables.

Check database integrity - This function checks the logical and physical integrity of all the objects (tables) in the database. Detailed information on this function can be found in the How to manually check the database integrity chapter. 

Before launching this function it is advised to make sure all Etere modules accessing the SQL database are closed (except Automation), therefore set the database access to "single-user mode" logged as a SQL Server administrator (once finished, the database will be automatically set back in "multi-user mode").
NB: It's highly suggested to perform this operation only when required since it may take several minutes.
Update statistics - If enabled, the query optimization statistics of all Etere tables will be updated to ensure that queries will be compiled with up-to-date statistics, thus improving the query plan and its performance.
The Update Statistics task is particularly useful to mitigate the intermittent slowness during database query if you had upgraded to a new version of Etere software.
Update screen language - If enabled, the system screen language will be updated based on the Etere's language repository (i.e. etereln.mdb), all the EXISTING terms (labels, descriptions, captions, etc) used in Etere would be updated and the NEW terms added.
Create Database of parameters - If enabled, a separate database would be created containing the main database parameters. The new database would be created in the following format:
•For Etere 22.02 or higher : Params_[CustomerCode]
•For Etere 22.01 or lower : Params_[CustomerCode]_[Date]_[Time]
Create asset forms for old memory files - Enable this option to search for the presence of old memory files in database, including memory files already archived in HSM, and link the files to the new asset forms.
•The new asset form would be created with UTC time indicated in file name, any asset code or time related information would be converted to UTC in the new asset form.
•If file already inserted into database with asset code in Local time, another asset with UTC code would not be inserted.
•If there are more than one Encoder per Memory, the Memory files would be associated to the same asset with it dedicated codec.
•Upon completion, when searching for Memory assets created by the System Maintenance task the “Memory” option in the custom Search form must be enabled.

Full-text search
Full-text search - If enabled, a full-text index would be created in the Main (and Do.Ma.) database, thus making it possible to perform full-text searches from the Etere modules such as the Media Library.
Disaster Recovery full-text search - If the Main database has been synchronized to disaster recovery database at the DR site, enable this option to create a full-text index in disaster recovery database and DoMa database to enable a full-text search to be performed in various Etere Modules.
NB: Please note that in order to support the indexing of portable documents (.pdf) and microsoft documents (.docx, etc) it is required to first install the PDF IFilter and MS Filter Pack before enabling the full-text search.

Miscellaneous
Save Certificate - If enabled, the identity certificates of the station would be backed up.
Restore Certificate - If enabled, the identity certificates of the station would be restored from a previous backup.

Structure congruency
Check main database congruency - If enabled, it allows to check the structure of the main production database (e.g. mydatabase) by comparing against a temporary database (e.g. mydatabase#structurecheck#) to verify its correctness after an update operation and point all encountered incongruence through the Etere Database Tools utility.
The temporary database is automatically created on-the-fly, after which, a "check database structure" is performed to create all the tables and functions required for the comparison.  Once the checks ends, the temporary database would be deleted from the SQL server.
It's worthy mentioning that due to the numerous checks implied in this operation, it may last several minutes depending on the system performance.
Etere Database Tools - If enabled, it opens the Etere Database Tools utility, a useful tool for comparing the structure of two different databases and exporting all encountered differences.

NB: Clicking the System Maintenance menu while executing maintenance task would interrupt the maintenance process, simply click again on Maintenance Menu to resume the processing.

After-upgrade maintenance
When you upgrade your system, the system maintenance must be performed with at least the following options enabled:
✓Check main database structure
✓SQL reports repository maintenance
✓Update screen language