•SQL SERVER Shutdown
In the event the PC where the SQL SERVER is running malfunction and resulted the shutdown of the server, a database failover might occurred (i.e. malfunctioning of T-workflows, service broker problems, etc). In order to resume the database to its previous state you would need to perform system maintenance with the following options:
•Check database structure
•Select the scripts before performing the maintenance:
- 003_Workflow_1_Schema (wf_admin_resetSysworker) : Reset and reconstruct the Service Broker.
- 003_Workflow_2_Runtime (wf_runtime_restartAllRunningInstances) : Restart all the stuck jobs and T-workflows which was in the queue before the shutdown.
Once the system maintenance is completed, you have to manually execute the updated scripts from the Microsoft SQL Management Studio application, please refer to the chapter How to Reconstruct Service Broker after a System Crash.
•Some asset types have been involuntary deleted
By performing a system maintenance, the system will control that all types currently used by at least one asset is not present on the 'available types table', it will restore them into the system.
NB: To prevent informational message popup when you launch any Etere module while the System Maintenance is executing, set the value of the following System Parameter to “0”.
“Global.ini /Database Maintenance/Executing”