Spreadsheet: 154786d1336565569-run-an-if-statement-of-a-dependent-drop-down-list-application-master_john_v2
Sheet: John's Prod issue 

Date | Application Name | Sev | Incident Timeframe | Ticket/Case # | Description of Issue/Impact | Immediate Fix | Root Cause | Issue Status --Is issue fixed? | Last Follow up Date | RCA Requested | Prbolem Record Complete Y or N | Owner of problem Record From IBM | Last Contact Date | Long Term Corrective Action | Timeline for LTCA | Owner of LTCA | Related Change Request or Incident
2012-01-10 00:00:00 | Care Planner | 2 | 6:30am-7:30:00 AM | IN11683990 | User could not perform a member or provider serach | Servers were rebooted | There was an obsolete portion of a configuration file that prohibited the Care Planner training application from connecting to the to the OLB database. The corrupt configuration file was removed. |  |  |  | N | Nrusingha Sahoo1 | 2012-04-24 00:00:00 | N/A | N/A | N/A | N/A
2012-01-11 00:00:00 | Disease Mgmt Registry | 3 | 08:37:00 | SR14670541 | Disease Management Registry failed to complete - Error message: "The batch process has experienced an error and did not complete successfully. Please contact your production support POC before re-running the batch." This must be resolved today as it effects nearly 25 users of the DMR. | Schedule another batch for tonight | The problem was due to an [NAME] fix last night. The batch workspace load job failed because it was running at the same time the [NAME] fix was being added, and the [NAME] had to be restarted |  |  |  | N | Bhupesh Bothra [[EMAIL]] | 2012-04-24 00:00:00 |  | N/A | N/A | N/A
2012-01-12 00:00:00 | Rightfax | 3 | 18:31:00 | IN11692213 | Faxes are being routed to incorrect telephone numbers. Information is developed in MCPS application and then uses Rightfax to transmit the information | Resolved on it's own | This Incident / ticket was opened to identify the root cause of the outage. |  |  |  | Y | [NAME] | N/A | TBD | N/A | N/A | N/A
2012-01-12 00:00:00 | MCPS / Citrix | 3 | 5 days | IN11691337 SR14677229 | User is a Harvard Vanguard employee delegated to manager [NAME] patients from their group. The user has access to MCPS & Care Planner thru Citrix - when the user clicks on the MCPS icon through citrix, she gets a black screen Contact Person: Deb Corcoran | Citrix Team (I-BCB-US-RA-Citrix) and HD addressed the issue | N/A |  |  |  | N | Mandeep  Sidhu | ? | N/A | N/A | N/A | N/A
2012-01-20 00:00:00 | MCPS Notes Issue | 3 | 7 days | SR14708730 | MCPS notes are being deleted and duplicated | N/A | Unknown |  |  |  | N | [NAME] | 2012-04-24 00:00:00 | Increase the number of generations that are reatined for the notes file. | Complete | Complete | get from Inga
2012-01-26 00:00:00 | Care Planner Slow Respnse | 2 | 10:47-11:42 | IN11724789 | User could not perform a member or provider serach | N/A | Unknown |  |  |  | N | [EMAIL] | 2012-04-24 00:00:00 | N/A | N/A | N/A | N/A
2012-02-15 00:00:00 | Insomnia | 2 | 6:30-7:37 | IN11794238 | Insomnia link was not avaiable on the Member Portal | The link on the member portal expired and needed to added back with a new experiation date. | The link was not before it expired |  |  |  | Y | N/A | N/A | N/A | N/A | N/A | N/A
2012-02-23 00:00:00 | Care Planner Printing Outcomes | 2 | 8:40-10:53 | IN11815140 | Care Planner Printing Outcomes were not being populated within the “Letter History Screen” | The scrip that populates the out comes in the Letter History Screen was rerun manually | The Script letter_user ID was removed from the local server group |  |  |  | Y | N/A | N/A | N/A | N/A | N/A | N/A
2012-02-24 00:00:00 | Care Planner Slow Response | 2 | 3:40-4:14 | IN11819859 | User could not perform a member or provider serach | N/A | Unknown |  |  |  | N | [EMAIL] | 2012-04-24 00:00:00 | N/A | N/A | N/A | N/A
2012-02-28 00:00:00 | MCPS | 3 | 2012-02-28 00:00:00 | IN11818829 | Member appoval letters were being sent to members for deined services | N/A | Defect associated with change CH207201 for Pharmacy UM project |  |  |  | N | [NAME] | 2012-04-24 00:00:00 | N/A | N/A | N/A | N/A
2012-03-02 00:00:00 | W Drive Error –Sev 2 This ticket was opened in error. This was a Macro issue | 2 | N/A | IN11837299 | Ticket Opened in error | N/A | N/A |  |  |  | N/A | N/A | N/A | N/A | N/A | N/A | N/A
2012-03-08 00:00:00 | Rightfax | 3 | N/A | IN11834419 | Faxes number are changing without cause | N/A | N/A |  |  |  | n | Tarkeshwar Roy1 | 2012-04-24 00:00:00 | N/A | N/A | N/A | N/A
2012-03-16 00:00:00 | Care Planner Outage | 1 | 10:10-12:27 | IN11871131 | Users are receiving the message below when searching for Patient Eligibility “The patient Eligibility record is not available for reconciliation for the following reason: MQSeries Communication Error: No response from remote system 'REMOTE'. Do you want to proceed with local patient data?” | Server was rebooted | N/A |  |  |  | N | This was a sev 1 | N/A | N/A | N/A | N/A | N/A
03/23/2012 | Care Planner Outage | 2 | 1:53-2:33 | IN11889293 | Sporadic Slowness throughout the application with member and provider searches which caused cases to lock | Issue corrected itself without manual intervention | N/A |  |  |  | y | N/A | N/A | N/A | N/A | N/A | N/A
2012-03-26 00:00:00 | MCPS -Citrix | 2 | 7:06-1:27 | IN11893173 | Internal and External users who access MCPS and Care Planner through Citrix we not able to access the systems | Server was rebooted | The issue was caused by a service failure on one of the Citrix servers. |  |  |  | Y | N/A | N/A | N/A | N/A | N/A | N/A
2012-03-27 00:00:00 | Care Planner Citrix | 2 | 7:00-8:27 | IN11896499 | External users are not able to logon to Care Planner through Citrix | Server was rebooted | There was a virtualization event that took place over the weekend of March 24th .One of the three servers was experiencing sporadic connectivity issues. | E-mailed on 04/26/2012 Prveen server still of line…IBM is waiting for Citrix Vendor | 2012-04-26 00:00:00 |  | Y | N/A | N/A | N/A | N/A | N/A | N/A
2012-03-29 00:00:00 | Care Planner | 2 | 10:55-11:54 | IN11903327 | Sporadic Slowness throughout the application with member and provider searches which caused cases to lock | Issue corrected itself without manual intervention | Unknown |  |  |  | Y | N/A | N/A | N/A | N/A | N/A | N/A
2012-03-30 00:00:00 | Care  Planner | 2 | 11:27-12:31 | IN11906572 | Sporadic Slowness throughout the application with member and provider searches which caused cases to lock | Issue resolved itself without manual intervention | A warning message was sent from one of the Care Planner Servers---the message was sent out to the solution team and business as a precaution |  |  |  | Y | N/A | N/A | N/A | N/A | N/A | N/A
2012-04-02 00:00:00 | Care Planner | 2 | 1:13-2:15 | IN11913031 | Sporadic Slowness throughout the application with member and provider searches which caused cases to lock | Issue resolved itself without manual intervention | Unknown |  |  |  | N | This was a sev 1 | N/A | N/A | N/A | N/A | N/A
2012-04-03 00:00:00 | MCPS | 2 | 11:39-12:09 | IN11915961 | MCPS slow response times | Issue resolved itself without manual intervention | Unknown |  |  |  | Y | N/A | N/A | N/A | N/A | N/A | N/A
2012-04-11 00:00:00 | Care Planner | 2 | 8:25-9:00 | IN11933684 | Care Planner letters outcomes and the CRIS reporting jobs failed | The Oracle agent was restarted | Orcale Agent |  |  |  | Y | N/A | N/A | N/A | N/A | N/A | N/A
2012-04-12 00:00:00 | Care Planner | 2 | 11:00-12:20 | IN11936511 | CRIS ETL job failed | The Oracle agent was restarted | Orcale Agent |  |  |  | Y | N/A | N/A | N/A | N/A | N/A | N/A
2012-04-20 00:00:00 | Care Planner | 2 | 1:15-1:45 | IN11956340 | Sporadic Slowness throughout the application with member and provider searches which caused cases to lock | Issue resolved itself without manual intervention | Unknown