Changes

Jump to: navigation, search

Scheduling the Staging Area creation

116 bytes added, 20:26, 20 February 2020
no edit summary
The '''[[Using Staging Area Generator | generation]]''' of an IMSMA staging area needs human interaction. However, 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>
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