Changes

Jump to: navigation, search

Scheduling the Staging Area creation

195 bytes added, 20:26, 20 February 2020
no edit summary
The above described '''[[Using Staging Area Generator | generation ]]''' of an IMSMA staging area needs human interaction. However, once all the options are fixed, there might be the requirement to re-generate the staging area regularly, in order to have an up-to-date reporting database. It is possible to automatize the staging area generation by following these steps:
<ol>
<li> Take a decision on how the '''[[Shutdown IMSMA Server | shutdown]]''' of the IMSMA server will be implemented.<li>In the ''C:\IMSMAETLTool '' folder, create a .bat script named for example '''runStagingArea.bat''' with the following content:
<pre>
cd C:\IMSMAETLTool
</pre>
</li>
<li>Edit the properties file C'':\IMSMAETLTool\conf\config.PROPERTIES '' by specifying the required values for all the parameters (they correspond to the ones from the graphical user interface described above'''[[Using Staging Area Generator | here]]'''). If a parameter should not be used, e.g. '''script_file''', then comment it by placing a # at the beginning of the line:
<pre>
conversion_language=en
<li>Next, refine recurrence criteria (e.g. time of the day) and click '''Next'''.</li>
<li>In the next window, select '''Start a Program''' and click '''Next'''.</li>
<li>Browser to the previously created script, e.g. ''C:\IMSMAETLTool\runStagingArea.bat''. Click '''Next''' and then '''Finish'''.</li>
</ol>
</li>
The staging area generation should now start at the specified time. <br/>
[[Image:SAGTaskScheduler.png|center|800px]]
It is advised to plan the generation time carefully, i.e. best during the night when no one is accessing and entering data into {{IMSMANG}}, as this might lead to inconsistencies. Ideally, the IMSMA server should be stopped before the staging area generation and then restarted. It also needs to be assured that no one (and no automatic reporting process) is accessing the staging area database at the time it has to be re-created. As long as there are open connections to the database, it cannot be dropped and re-created. Contact your [[Information Management Team | GICHD IM advisor ]] in case of questions.
{{NavBox Business Intelligence}}
[[Category:VIENAA]]
6,632
edits

Navigation menu