Cognos data import: Difference between revisions
TOstryzniuk (talk | contribs) |
TOstryzniuk (talk | contribs) |
||
| Line 20: | Line 20: | ||
* process then returns to [[LoadCognos.bat]] which copies [[CCMDB.accdb]] to the [[Regional Server]] and then calls [[Updt all.bat]] to [[Rolling out changes | roll it out]] to all collectors | * process then returns to [[LoadCognos.bat]] which copies [[CCMDB.accdb]] to the [[Regional Server]] and then calls [[Updt all.bat]] to [[Rolling out changes | roll it out]] to all collectors | ||
== Cognos Error/ | == Cognos Error/ Problem Log == | ||
{{Discuss| Tina, not sure where you want keep and error log and trouble shooting steps.}} | {{Discuss| Tina, not sure where you want keep and error log and trouble shooting steps.}} | ||
*'''2020_Sep-08''' - Cognos ran | *'''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''. | ||
*'''2020_Sep_04''' - task ran on Pagasa computer however the error message was: for Access TYPE mismatch...13. | **PW message box still comes up when exiting CCMDB.accdb Programs. | ||
*'''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. | |||
**Pagasa tried to run the Task schedule manually and email message to staff still not generated. | |||
*email was not generated and sent out to staff that new cognos data is available....... | |||
*other bug that appeared after Cognos ran today was the CCMDB PROGRAM was popping up a PW message box when you EXIT. Had to press cancel to get rid of it. [[User:TOstryzniuk|Trish Ostryzniuk]] 15:15, 2020 September 4 (CDT) | *other bug that appeared after Cognos ran today was the CCMDB PROGRAM was popping up a PW message box when you EXIT. Had to press cancel to get rid of it. [[User:TOstryzniuk|Trish Ostryzniuk]] 15:15, 2020 September 4 (CDT) | ||