Cognos data import: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 30: | Line 30: | ||
| always= detailed log | | always= detailed log | ||
| full= | | full= | ||
*'''2020_Oct_9''' - task was stuck because CFE was open | |||
*'''2020_Oct_8''' - Task schedule did not run because computer were rebooted by EHealth overnight. | *'''2020_Oct_8''' - Task schedule did not run because computer were rebooted by EHealth overnight. | ||
*Pagasa changed the Task schedule so it does not run on weekends. Concern will be this long weekend and the task may hang because data from email not deleted before it runs on Tues AM. | *Pagasa changed the Task schedule so it does not run on weekends. Concern will be this long weekend and the task may hang because data from email not deleted before it runs on Tues AM. | ||
Revision as of 09:06, 9 October 2020
This page explains how to get data from the Cognos EPR Report into CCMDB.accdb and rolled out to collectors.
Process
Tina receives the data in a scheduled, automated email from Chastity every morning as early as possible, usually before 8. The data is then imported into CCMDB.accdb master on Regional server and provided to collectors via regular roll-out and news and backup.
Outlook Rule in Tina's profile to get data to Pagasa
Decision Support Services sends a report to Tina. The report needs to go to Pagasa so we can schedule the automated import on a machine that sits on WRHA network at all times. So, there is an outlook rule "Cognos to Pagasa" in Tina's Outlook profile to forward the email to Pagasa from Chastity.
Scheduled Task on Pagasa's PC
There is a scheduled task on Pagasa's PC that calls LoadCognos.bat early each morning.
- it pulls the data from and Excel sheet in an email that is sent to Pagasa (from a Chastity who is works in decision support)
When run on Tina's computer the process will roll out any current changes in the local file; if anything was changed, update log saying it has been rolled out! There should be no instructions required if the scheduled task running LoadCognos.bat works. Follow the trail through that file if troubleshooting is required.
Background
- LoadCognos.bat calls
- LoadCognos.vbs which calls
- CCMDB.accdb.Sub CognosImport for the actual steps performed during import, and how the queries and tables work together and the email to collectors is generated.
- process then returns to LoadCognos.bat which copies CCMDB.accdb to the Regional Server and then calls Updt all.bat to roll it out to all collectors
Known problems with data import
The task requires the user be logged in. If Shared Health re-boots the computer over night, the task won't run until Pagasa logs on.
CFE left open on Pagasa's PC
CFE needs to be closed at the end of the work day on Pagasa's computer. The update process needs to download the newest version of CCMDB.accdb from the Regional Server before it runs so that it doesn't overwrite the master version with an older version from Pagasa's PC. This download of the newest version is blocked when CFE is open.
Problem Log
| detailed log |
|