Spreadsheet: 111155d1307612192-macro-formula-to-extract-5-digit-from-text-match-number-in-string
Sheet: Sheet1

Assignee | [NAME] | CHD Record# | [NAME] | Closed by | Closed Date | Country | Create Date | Create Time | Last-modified-by | Problem Description | Problem Type | Resolution | Severity | Status Conversion | Log | Status | Store/Dept.# | Market | Exclude | Classification | Reference | Module | Root Cause | RCA updates | RCA incorrect
dsawant | cs107021 | 4884956 | UOPS000004884956 | dsawant | 2011-06-02 00:00:00 | US | 2011-06-02 00:00:00 | 23:01:00 | dsawant | KM:NORMAL - Error in executing PuOrdSumryRpt_ins in Purchase order summary Report | AUTO-GLS-EON-RPT | Defect 30094 | Medium | Closed | 6/3/2011 9:31:58 AM omnibus  Note:  Updates to this ticket log and the Event Updates screen will not occur for all alert updates.   For more information about how alert updates are recorded, see:  http://event-mgt.wal-mart.com/esm_atgs_logmsg.htm .    To view the Event Updates table, click the Red, Double-Decker Bus icon located on the top of this Help Desk Form or near this field.      Keyword = AUTO-GLS-EON-RPT  [NAME] = NORMAL  Hostname = cs107021.s07021.us.wal-mart.com  script_loc = [NAME] = 10.146.138.12  [NAME] = http://honts2003.homeoffice.wal-mart.com/devsrv/knowledgebase/?kbid=5615  # last 7 days = 6  Message = Error in executing PuOrdSumryRpt_ins in Purchase order summary Report  [NAME]:     6/3/2011 9:41:54 AM dsawant  Defect #30094 exists to address this issue.  Closing the ticket.  ### QA | NA| Application |  Defect #30094 | NA ### | Closed | 7021 | #N/A |  | Application - Defect | 30094 |  |  | QA | NA| Application |  Defect #30094 | NA ###
jrajama | cs107021 | 4881819 | UOPS000004881819 | s1balas | 2011-06-01 00:00:00 | US | 2011-06-01 00:00:00 | 23:01:00 | s1balas | KM:NORMAL - Error in executing PuOrdSumryRpt_ins in Purchase order summary Report | AUTO-GLS-EON-RPT | Defect #30094 | Medium | Closed | 6/2/2011 9:31:51 AM omnibus  Note:  Updates to this ticket log and the Event Updates screen will not occur for all alert updates.   For more information about how alert updates are recorded, see:  http://event-mgt.wal-mart.com/esm_atgs_logmsg.htm .    To view the Event Updates table, click the Red, Double-Decker Bus icon located on the top of this Help Desk Form or near this field.      Keyword = AUTO-GLS-EON-RPT  [NAME] = NORMAL  Hostname = cs107021.s07021.us.wal-mart.com  script_loc = [NAME] = 10.146.138.12  [NAME] = http://honts2003.homeoffice.wal-mart.com/devsrv/knowledgebase/?kbid=5615  # last 7 days = 6  Message = Error in executing PuOrdSumryRpt_ins in Purchase order summary Report  [NAME]:     6/2/2011 9:46:44 AM s1balas  Defect #30094 exists to address this issue.  Closing the ticket.  ### QA | NA| Application |  Defect #30094 | NA ### | Closed | 7021 | #N/A |  | Application - Defect | 30094 |  |  | QA | NA| Application |  Defect #30094 | NA ###
b0palan | cs107021 | 4878604 | UOPS000004878604 | b0palan | 2011-05-31 00:00:00 | US | 2011-05-31 00:00:00 | 23:01:00 | b0palan | KM:NORMAL - Error in executing PuOrdSumryRpt_ins in Purchase order summary Report | AUTO-GLS-EON-RPT | Defect #30094 | Medium | Closed | 6/1/2011 9:31:29 AM omnibus  Note:  Updates to this ticket log and the Event Updates screen will not occur for all alert updates.   For more information about how alert updates are recorded, see:  http://event-mgt.wal-mart.com/esm_atgs_logmsg.htm .    To view the Event Updates table, click the Red, Double-Decker Bus icon located on the top of this Help Desk Form or near this field.      Keyword = AUTO-GLS-EON-RPT  [NAME] = NORMAL  Hostname = cs107021.s07021.us.wal-mart.com  script_loc = [NAME] = 10.146.138.12  [NAME] = http://honts2003.homeoffice.wal-mart.com/devsrv/knowledgebase/?kbid=5615  # last 7 days = 6  Message = Error in executing PuOrdSumryRpt_ins in Purchase order summary Report  [NAME]:     6/1/2011 10:22:51 AM b0palan  Defect #30094 exists to address this issue.  Closing the ticket.  ### QA | NA| Application |  Defect #30094 | NA ### | Closed | 7021 | #N/A |  | Application - Defect | 30094 |  |  | QA | NA| Application |  Defect #30094 | NA ###
dsawant | cs107021 | 4875492 | UOPS000004875492 | dsawant | 2011-05-30 00:00:00 | US | 2011-05-30 00:00:00 | 23:01:00 | dsawant | KM:NORMAL - Error in executing PuOrdSumryRpt_ins in Purchase order summary Report | AUTO-GLS-EON-RPT | Defect 30094 | Medium | Closed | 5/31/2011 9:31:40 AM omnibus  Note:  Updates to this ticket log and the Event Updates screen will not occur for all alert updates.   For more information about how alert updates are recorded, see:  http://event-mgt.wal-mart.com/esm_atgs_logmsg.htm .    To view the Event Updates table, click the Red, Double-Decker Bus icon located on the top of this Help Desk Form or near this field.      Keyword = AUTO-GLS-EON-RPT  [NAME] = NORMAL  Hostname = cs107021.s07021.us.wal-mart.com  script_loc = [NAME] = 10.146.138.12  [NAME] = http://honts2003.homeoffice.wal-mart.com/devsrv/knowledgebase/?kbid=5615  # last 7 days = 5  Message = Error in executing PuOrdSumryRpt_ins in Purchase order summary Report  [NAME]:     5/31/2011 9:39:12 AM dsawant  Defect #30094 exists to address this issue.  Closing the ticket.  ### QA | NA| Application |  Defect #30094 | NA ### | Closed | 7021 | #N/A |  | Application - Defect | 30094 |  |  | QA | NA| Application |  Defect #30094 | NA ###
jrajama | cs107021 | 4872634 | UOPS000004872634 | s1balas | 2011-05-29 00:00:00 | US | 2011-05-29 00:00:00 | 23:01:00 | s1balas | KM:NORMAL - Error in executing PuOrdSumryRpt_ins in Purchase order summary Report | AUTO-GLS-EON-RPT | Defect # 30094 | Medium | Closed | 5/30/2011 9:31:46 AM omnibus  Note:  Updates to this ticket log and the Event Updates screen will not occur for all alert updates.   For more information about how alert updates are recorded, see:  http://event-mgt.wal-mart.com/esm_atgs_logmsg.htm .    To view the Event Updates table, click the Red, Double-Decker Bus icon located on the top of this Help Desk Form or near this field.      Keyword = AUTO-GLS-EON-RPT  [NAME] = NORMAL  Hostname = cs107021.s07021.us.wal-mart.com  script_loc = [NAME] = 10.146.138.12  [NAME] = http://honts2003.homeoffice.wal-mart.com/devsrv/knowledgebase/?kbid=5615  # last 7 days = 4  Message = Error in executing PuOrdSumryRpt_ins in Purchase order summary Report  [NAME]:     5/30/2011 9:46:47 AM s1balas  Defect #30094 exists to address this issue. [NAME] the ticket.  ### QA-Reports | No Action | Application - Defect | Defect #30094 | NA ### | Closed | 7021 | #N/A |  | Application - Defect | 30094 |  |  | QA-Reports | No Action | Application - Defect | Defect #30094 | NA ###
p0malli | ds206598 | 4870989 | UOPS000004870989 | p0malli | 2011-05-29 00:00:00 | US | 2011-05-29 00:00:00 | 06:01:00 | p0malli | KM:NORMAL - Function-sams_unloads_dcpoline failed to write dc_po_line_tbl file | AUTO-GLS-IHC-GEN | Defect 30348 | Medium | Closed | 5/29/2011 4:31:11 PM omnibus  Note:  Updates to this ticket log and the Event Updates screen will not occur for all alert updates.   For more information about how alert updates are recorded, see:  http://event-mgt.wal-mart.com/esm_atgs_logmsg.htm .    To view the Event Updates table, click the Red, Double-Decker Bus icon located on the top of this Help Desk Form or near this field.      Keyword = AUTO-GLS-GEN-PGM  [NAME] = NORMAL  Hostname = ds206598.s06598.us.wal-mart.com  script_loc = gls2SamsUnloads  Sender IP = 10.164.72.12  [NAME] = http://honts2003.homeoffice.wal-mart.com/devsrv/knowledgebase/?kbid=5615  # last 7 days = 3  Message = Function-sams_unloads_dcpoline failed to write dc_po_line_tbl file  [NAME]:     5/30/2011 8:53:19 AM p0malli  gls@ds104792:/u/data/gls/logs $ ls -ltr *gls2SamsUnloads*  gls@ds206598:/u/data/gls/support/p0malli $ log  gls@ds206598:/u/data/gls/logs $ ls -ltr *gls2SamsUnloads*  -rw-rw-rw-   1 gls        walmart        512 May 29 06:00 gls2SamsUnloads.err  -rw-rw-rw-   1 gls        walmart      82838 May 29 06:00 gls2SamsUnloads.log  gls@ds206598:/u/data/gls/logs $ vi gls2SamsUnloads.log      28379|gls2SamsUnloads00.ec|sams_unloads_recvline|1046|2011-05-29 06:00:47|LOG|File closed as there are no more rows to be fetched from c_get_po_det  28379|gls2SamsUnloads00.ec|sams_unloads_recvline|1079|2011-05-29 06:00:47|LOG|EXIT: [NAME] [0]  28379|gls2SamsUnloads00.ec|sams_unloads_dcpoline|1114|2011-05-29 06:00:47|LOG|ENTER: sams_unloads_dcpoline()  28379|gls2SamsUnloads00.ec|sams_unloads_dcpoline|1129|2011-05-29 06:00:50|ERR|ERROR: c_get_po_detl: OPEN  SQL[-244], ISAM[-107].    28379|gls2SamsUnloads00.ec|sams_unloads_dcpoline|1218|2011-05-29 06:00:50|LOG|EXIT: [NAME]28379|gls2SamsUnloads00.ec|main|2334|2011-05-29 06:00:50|ERR|ERROR: sams_unloads_dcpoline() function failed with RetCode:[-1]  28379|gls2SamsUnloads00.ec|main|2395|2011-05-29 06:00:50|LOG|Finishing gls2SamsUnloads l_ret_code = [-1]  28379|gls2SamsUnloads00.ec|main|2408|2011-05-29 06:00:54|LOG|Alert sent successfully  28379|gls2SamsUnloads00.ec|main|2411|2011-05-29 06:00:54|LOG|EXIT [NAME]() with RetCode:[0]      this alert got generated due to temporary table lock. Defect #30348 is created to address this issue.        ### IHC | No action | Application- Defect | Defect 30348 | Temporary inconsistent state from a concurrent update ### | Closed | 6598 | #N/A |  | Application - Defect | 30348 |  |  | IHC | No action | Application- Defect | Defect 30348 | Temporary inconsistent state from a concurrent update ###
b0palan | cs107021 | 4867693 | UOPS000004867693 | b0palan | 2011-05-27 00:00:00 | US | 2011-05-27 00:00:00 | 23:01:00 | b0palan | KM:NORMAL - Error in executing PuOrdSumryRpt_ins in Purchase order summary Report | AUTO-GLS-EON-RPT | Defect #30094 | Medium | Closed | 5/28/2011 9:31:39 AM omnibus  Note:  Updates to this ticket log and the Event Updates screen will not occur for all alert updates.   For more information about how alert updates are recorded, see:  http://event-mgt.wal-mart.com/esm_atgs_logmsg.htm .    To view the Event Updates table, click the Red, Double-Decker Bus icon located on the top of this Help Desk Form or near this field.      Keyword = AUTO-GLS-EON-RPT  [NAME] = NORMAL  Hostname = cs107021.s07021.us.wal-mart.com  script_loc = [NAME] = 10.146.138.12  [NAME] = http://honts2003.homeoffice.wal-mart.com/devsrv/knowledgebase/?kbid=5615  # last 7 days = 3  Message = Error in executing PuOrdSumryRpt_ins in Purchase order summary Report  [NAME]:     5/28/2011 9:52:18 AM b0palan  Defect #30094 exists to address this issue.  Closing the ticket.  ### QA | NA| Application |  Defect #30094 | NA ### | Closed | 7021 | #N/A |  | Application - Defect | 30094 |  |  | QA | NA| Application |  Defect #30094 | NA ###
tghosh | 7021 | 4865879 | UOPS000004865879 | tghosh | 2011-05-27 00:00:00 | US | 2011-05-27 00:00:00 | 08:36:00 | tghosh | 50 receiving associates cannot receive freight due to GLS2 error message. (NO Manual Workarounds) | DCs-[NAME] | Defect# 30456 | Medium | Closed | 5/27/2011 7:06:47 PM grorpin  What is down(application,devices, etc...)?    [NAME].    How long has it been down?  20 minutes.    What are the associates unable to do? Dock associates cannot receive freight from trailers.    What has changed?  Check for Change Controls.  List change controls for past 7 days -      numbers and dates.    How many are impacted?  50 associates cannot work.     If not impacting, who said so?      If not impacting now, when will it?        Is someone already working on this issue?          If so, who?       Do they have an ETA?    ***Please follow documentation and record the results.****       5/27/2011 7:07:23 PM grorpin  The error is on mobile client. 5090s and CV60s.    5/27/2011 7:09:22 PM grorpin  Reason for page: SUPPORT  Message: DC7021,GRANDVIEW,WA - 50 associates cannot receive freight due to GLS2 giving error messages, please call garrettin Unix Ops R#4865879  Sent By: grorpin from UO at 2047066x1256359  Sent On: 5/27/2011  Sent At: 8:39:19 AM  Sent To: GLS II - Cognizant;   Page sent successfully.      5/27/2011 7:12:45 PM grorpin  Engaged Tanmoy from GLS2 Cognizant.    5/27/2011 7:16:29 PM grorpin  [NAME] of issue.    5/27/2011 7:18:27 PM grorpin  Tanmoy is restarting the [NAME] server.    5/27/2011 7:20:12 PM grorpin  Veronica is asking the receiving doc try to log in and create a receiving tag.    5/27/2011 7:25:00 PM grorpin  The site was able to print receiving labels. Impact resolved per Veronica.    5/27/2011 7:25:20 PM grorpin  Tanmoy indicates there is a defect opened for this issue.    5/27/2011 8:45:57 PM tghosh  Site reported that all of there associates were not able to receive freight in receiving area.    Checked the log of gls2Server53 and found that it is locked:    21363|glsServer.ec|srvtrans|278|2011-05-27 06:41:41|LOG|Function N0[2] returned 1  21363|gls2VerifyPallet.ec|VerifyPallet|388|2011-05-27 06:41:44|SQL|Error BEGIN WORK. SQL(-535,0,1) []   Already in transaction.    21363|glsServer.ec|srvtrans|278|2011-05-27 06:41:44|LOG|Function N0[1] returned -1  21363|glsServer.ec|srvtrans|278|2011-05-27 06:41:48|LOG|Function N0[2] returned 1  21363|glsServer.ec|srvtrans|278|2011-05-27 06:41:50|LOG|Function N0[2] returned 1  21363|glsServer.ec|srvtrans|278|2011-05-27 06:41:56|LOG|Function N0[2] returned -1  21363|glsServer.ec|srvtrans|278|2011-05-27 06:42:12|LOG|Function N0[2] returned 1  21363|glsServer.ec|srvtrans|278|2011-05-27 06:42:54|LOG|Function N0[2] returned 1  21363|gls2VerifyPallet.ec|VerifyPallet|388|2011-05-27 06:43:29|SQL|Error BEGIN WORK. SQL(-535,0,1) []   Already in transaction.    21363|glsServer.ec|srvtrans|278|2011-05-27 06:43:29|LOG|Function N0[1] returned -1  21363|glsServer.ec|srvtrans|278|2011-05-27 06:43:44|LOG|Function N0[2] returned -1  21363|gls2VerifyPallet.ec|VerifyPallet|388|2011-05-27 06:43:49|SQL|Error BEGIN WORK. SQL(-535,0,1) []   Already in transaction.    21363|glsServer.ec|srvtrans|278|2011-05-27 06:43:49|LOG|Function N0[1] returned -1  21363|gls2VerifyPallet.ec|VerifyPallet|388|2011-05-27 06:43:57|SQL|Error BEGIN WORK. SQL(-535,0,1) []   Already in transaction.    21363|glsServer.ec|srvtrans|278|2011-05-27 06:43:57|LOG|Function N0[1] returned -1    Found the same in lock_monitor also:    session_id|hostname|pid|lock_type|lock _start|lock_duration  8078869|cs107021.s|21363|X|2011-05-27 06:03:08|        0 00:41:44.430|    glssys 21363  1859  0  May 24  ?         4:47 /u/topend/topenddir/glssys/ac/gls2Server53/gls2Server53  Checking dc_sys_receiving:purchase_order for locks older than 5 sec    So restarted gls2Server53 and asked the site to log off and log back in before continuing their operation.    Site confirmed that everything is fine.    Defect# 30456 exists for this.    Hence closing the ticket.    ### GLS - Receiving | [NAME] | Application - Defect | Defect# 30456 | NA ### | Closed | 7021 | #N/A |  | Application - Defect | 30456 |  |  | GLS - Receiving | [NAME] | Application - Defect | Defect# 30456 | NA ###
aelango | ds206598 | 4865539 | UOPS000004865539 | aelango | 2011-05-28 00:00:00 | US | 2011-05-27 00:00:00 | 06:08:00 | aelango | KM:NORMAL - Function-sams_unloads_dcpoline failed to write dc_po_line_tbl file | AUTO-GLS-IHC-GEN | Defect | Medium | Closed | 5/27/2011 4:38:44 PM omnibus  Note:  Updates to this ticket log and the Event Updates screen will not occur for all alert updates.   For more information about how alert updates are recorded, see:  http://event-mgt.wal-mart.com/esm_atgs_logmsg.htm .    To view the Event Updates table, click the Red, Double-Decker Bus icon located on the top of this Help Desk Form or near this field.      Keyword = AUTO-GLS-GEN-PGM  [NAME] = NORMAL  Hostname = ds206598.s06598.us.wal-mart.com  script_loc = gls2SamsUnloads  Sender IP = 10.164.72.12  [NAME] = http://honts2003.homeoffice.wal-mart.com/devsrv/knowledgebase/?kbid=5615  # last 7 days = 3  Message = Function-sams_unloads_dcpoline failed to write dc_po_line_tbl file  [NAME]:     5/28/2011 4:25:15 PM aelango  gls@ds206598:/u/data/gls/logs $ ls -ltr *SamsUnloads*log  -rw-rw-rw-   1 gls        walmart      73354 May 27 06:00 gls2SamsUnloads.log      17452|gls2SamsUnloads00.ec|sams_unloads_dcpoline|1114|2011-05-27 06:00:48|LOG|ENTER: sams_unloads_dcpoline()  17452|gls2SamsUnloads00.ec|sams_unloads_dcpoline|1129|2011-05-27 06:00:52|ERR|ERROR: c_get_po_detl: OPEN  SQL[-244], ISAM[-107].    17452|gls2SamsUnloads00.ec|sams_unloads_dcpoline|1218|2011-05-27 06:00:52|LOG|EXIT: [NAME]]  17452|gls2SamsUnloads00.ec|main|2334|2011-05-27 06:00:52|ERR|ERROR: sams_unloads_dcpoline() function failed with RetCode:[-1]  17452|gls2SamsUnloads00.ec|main|2395|2011-05-27 06:00:52|LOG|Finishing gls2SamsUnloads l_ret_code = [-1]  17452|gls2SamsUnloads00.ec|main|2408|2011-05-27 06:00:54|LOG|Alert sent successfully  17452|gls2SamsUnloads00.ec|main|2411|2011-05-27 06:00:54|LOG|EXIT [NAME]() with RetCode:[0]      This alert got generated due to temporary table lock. Defect #30348 is created to address this issue.    ### IHC | No action | Defect | 30348 | Temporary inconsistent state from a concurrent update ### | Closed | 6598 | #N/A |  | Application - Defect | 30348 |  |  | IHC | No action | Defect | 30348 | Temporary inconsistent state from a concurrent update ###
pchenni | cs107021 | 4861865 | UOPS000004861865 | pchenni | 2011-05-30 00:00:00 | US | 2011-05-26 00:00:00 | 07:26:00 | pchenni | KM:NORMAL - Item in 3050 record does not exist | AUTO-GLS-IHC-GEN | no action | Low | Closed | 5/26/2011 5:56:15 PM omnibus  Note:  Updates to this ticket log and the Event Updates screen will not occur for all alert updates.   For more information about how alert updates are recorded, see:  http://event-mgt.wal-mart.com/esm_atgs_logmsg.htm .    To view the Event Updates table, click the Red, Double-Decker Bus icon located on the top of this Help Desk Form or near this field.      Keyword = AUTO-GLS-GEN-PGM  [NAME] = NORMAL  Hostname = cs107021.s07021.us.wal-mart.com  script_loc = glsItemDataLoad3050  Sender IP = 10.146.138.12  [NAME] = http://honts2003.homeoffice.wal-mart.com/devsrv/knowledgebase/?kbid=5615  # last 7 days = 5  Message = Item in 3050 record does not exist  [NAME]:     5/30/2011 11:52:51 AM pchenni  ###QA |Application | no action |  defect - 30165 | na| na ### | Closed | 7021 | #N/A |  | Application - Defect | 30165 |  |  | QA |Application | no action |  defect - 30165 | na| na ###