Cognos data import: Difference between revisions

Line 22:

== Cognos Error/ Problem Log ==

{{Discuss| Tina, not sure where you want keep and error log and trouble shooting steps.}}

*'''2020_Sep_10''' - Cognos ran this am 07:36 from Chastity. Run the Task scheduler the black script screen ran but a message pop up asking ~~the~~ pw to close the ccmdb.mdb, just closed it the script run but no email received for "New Cognos etc" . Rebooted my computer and re run the Task scheduler still no email. Phoned the collectors if they received new cognos and they did ~~only~~ no email. ~~Then after 30~~ minutes the email showed up.

*'''2020_Sep_10''' - Cognos ran this am 07:36 from Chastity. Run the Task scheduler (to run at 0715 daily) the black script screen ran but a message pop up asking for ''pw to close the ccmdb.mdb'', just closed the message box and the script run but no email received for "New Cognos etc" . Rebooted my computer and re run the Task scheduler still no email. Phoned the collectors if they received new cognos and they did, but no email notice. 35 minutes later the email showed up in peoples inbox.

**Contacted Herman about the issue. He forwarded a notice about delivery delays on Exchange this am. He later sent the updated that it was resolved before noon.

*'''2020_Sep-08''' - Cognos scheduled task ran this am at 0715 (as it is scheduled). Pagasa saw black script screen ''hanging'' open when she came in at 0840 hrs. She closed out of it. She noted that Chastity's email came in in 0701 hrs. Pagasa proceeded to manually run Cognos Task Scheduler to roll out to staff. She did not see Type mismatch 13...error message box until 0910 hrs, as she had started to do other work (scanning TISS). Only difference from Friday after running cognos task scheduler manually was that the email was generated and sent out to staff that ''new cognos data is available in 5 min, and to run news and backup''.

**PW message box still comes up when exiting CCMDB.accdb Programs.

*Lisa and Joanna did new and backup after requested at 0945 hrs. They report data appears to be there.

*'''2020_Sep_04''' - task scheduled for Cognos ran on Pagasa computer however the error message was: for Access TYPE mismatch...13.

**We did not know where to look for the field mismatch issue to find out which it was.

@@ Line 22: / Line 22: @@
 == Cognos Error/ Problem Log ==
 {{Discuss| Tina, not sure where you want keep and error log and trouble shooting steps.}}
-*'''2020_Sep_10''' - Cognos ran this am 07:36 from Chastity.  Run the Task scheduler the black script screen ran but a message pop up asking the pw to close the ccmdb.mdb, just closed it the script run but no email received for "New Cognos etc" . Rebooted my computer and re run the Task scheduler  still no email. Phoned the collectors if they received new cognos and they did only no email.  Then after 30 minutes the email showed up.
+*'''2020_Sep_10''' - Cognos ran this am 07:36 from Chastity.  Run the Task scheduler (to run at 0715 daily) the black script screen ran but a message pop up asking for ''pw to close the ccmdb.mdb'', just closed the message box and the script run but no email received for "New Cognos etc" . Rebooted my computer and re run the Task scheduler still no email. Phoned the collectors if they received new cognos and they did, but no email notice. 35 minutes later the email showed up in peoples inbox.
+**Contacted Herman about the issue. He forwarded a notice about delivery delays on Exchange this am.  He later sent the updated that it was resolved before noon.
 *'''2020_Sep-08''' - Cognos scheduled task ran this am at 0715 (as it is scheduled).   Pagasa saw black script screen ''hanging'' open when she came in at 0840 hrs. She closed out of it.  She noted that Chastity's email came in in 0701 hrs.  Pagasa proceeded to manually run Cognos Task Scheduler to roll out to staff. She did not see Type mismatch 13...error message box until 0910 hrs, as she had started to do other work (scanning TISS). Only difference from Friday after running cognos task scheduler manually was that the email was generated and sent out to staff that ''new cognos data is available in 5 min, and to run news and backup''.
 **PW message box still comes up when exiting CCMDB.accdb Programs.
 *Lisa and Joanna did new and backup after requested at 0945 hrs.  They report data appears to be there.
 *'''2020_Sep_04''' - task scheduled for Cognos ran on Pagasa computer however the error message was:  for Access  TYPE mismatch...13.
 **We did not know where to look for the field mismatch issue to find out which it was.