Stage 2 — Data · ashok.kumar@kwglobal.com

Dispatched View full job

Recipient: ashok.kumar@kwglobal.com (Ashok Kumar) · Template: UrgentAttention · Job: 7EAB6DFF-2D2F-492B-8D91-23A79A557CF3

Stage 2 — Data

Fetched 2026-07-24 03:21:10.560186 · 491 bytes

Urgent Rows 1
Urgent Rows · 1 row(s) × 11 column(s)
HrUserIdHrUserEmailHrFullNameDateUserIdUserNameEmployeeCodeUserFullNameDisplayMessageMessageEnumCompanyId
CCCB3F8C-085C-446A-A54F-74B80C726A8F ashok.kumar@kwglobal.com Ashok Kumar 2026-07-23 8F1B99A5-3C12-4274-839B-0891BD4E4EE3 jitender.prasad@kwglobal.com 48986 Jitender Prasad 0 6E919CFE-74DD-4EBC-8665-3C0D44866649
Meta · non-tabular fields
{
  "row_counts": {
    "desktop_not_assigned": 0,
    "not_tracked": 1,
    "urgent_rows": 1
  }
}
Raw JSON
{"urgent_rows": [{"HrUserId": "CCCB3F8C-085C-446A-A54F-74B80C726A8F", "HrUserEmail": "ashok.kumar@kwglobal.com", "HrFullName": "Ashok Kumar", "Date": "2026-07-23", "UserId": "8F1B99A5-3C12-4274-839B-0891BD4E4EE3", "UserName": "jitender.prasad@kwglobal.com", "EmployeeCode": "48986", "UserFullName": "Jitender Prasad", "DisplayMessage": "", "MessageEnum": 0, "CompanyId": "6E919CFE-74DD-4EBC-8665-3C0D44866649"}], "row_counts": {"urgent_rows": 1, "desktop_not_assigned": 0, "not_tracked": 1}}

Stage 3 — Rendered

Rendered 2026-07-24 03:21:10.763189 · 17353 bytes

Subject: Time Champ: URGENT ATTENTION: Some of your members were not tracked yesterday ( 23-Jul-2026 )

Attachments
[{"name": "UrgentAttentionReport_23-Jul-2026.xlsx", "path": "runs/3d0a41e3-68bb-4955-a5cc-4a7d338578da-attachments/CCCB3F8C-085C-446A-A54F-74B80C726A8F-UrgentAttentionReport_23-Jul-2026.xlsx", "sizeBytes": 4876, "contentType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "kind": "xlsx"}]
Body HTML (source)
<!DOCTYPE html>  <html lang="en">    <head>    <meta charset="utf-8">    <meta name="viewport" content="width=device-width,initial-scale=1,shrink-to-fit=no">    <meta name="x-apple-disable-message-reformatting">    <meta http-equiv="X-UA-Compatible" content="IE=edge">    <title>Account Invitation</title>    <style type="text/css">      a {        text-decoration: none;        outline: 0      }        a:hover {        text-decoration: underline;      }        @media (max-width:649px) {        .o_col-full {          max-width: 100% !important        }          .o_col-half {          max-width: 50% !important        }          .o_hide-lg {          display: inline-block !important;          font-size: inherit !important;          max-height: none !important;          line-height: inherit !important;          overflow: visible !important;          width: auto !important;          visibility: visible !important        }          .o_hide-xs,        .o_hide-xs.o_col_i {          display: none !important;          font-size: 0 !important;          max-height: 0 !important;          width: 0 !important;          line-height: 0 !important;          overflow: hidden !important;          visibility: hidden !important;          height: 0 !important        }          .o_xs-center {          text-align: center !important        }          .o_xs-left {          text-align: left !important        }          .o_xs-right {          text-align: left !important        }          table.o_xs-left {          margin-left: 0 !important;          margin-right: auto !important;          float: none !important        }          table.o_xs-right {          margin-left: auto !important;          margin-right: 0 !important;          float: none !important        }          table.o_xs-center {          margin-left: auto !important;          margin-right: auto !important;          float: none !important        }          h1.o_heading {          font-size: 32px !important;          line-height: 41px !important        }          h2.o_heading {          font-size: 26px !important;          line-height: 37px !important        }          h3.o_heading {          font-size: 20px !important;          line-height: 30px !important        }          .o_xs-py-md {          padding-top: 24px !important;          padding-bottom: 24px !important        }          .o_xs-pt-xs {          padding-top: 8px !important        }          .o_xs-pb-xs {          padding-bottom: 8px !important        }      }        @media screen {        @font-face {          font-family: Roboto;          font-style: normal;          font-weight: 400;          src: local("Roboto"), local("Roboto-Regular"), url(https://fonts.gstatic.com/s/roboto/v18/KFOmCnqEu92Fr1Mu7GxKOzY.woff2) format("woff2");          unicode-range: U+0100-024F, U+0259, U+1E00-1EFF, U+2020, U+20A0-20AB, U+20AD-20CF, U+2113, U+2C60-2C7F, U+A720-A7FF        }          @font-face {          font-family: Roboto;          font-style: normal;          font-weight: 400;          src: local("Roboto"), local("Roboto-Regular"), url(https://fonts.gstatic.com/s/roboto/v18/KFOmCnqEu92Fr1Mu4mxK.woff2) format("woff2");          unicode-range: U+0000-00FF, U+0131, U+0152-0153, U+02BB-02BC, U+02C6, U+02DA, U+02DC, U+2000-206F, U+2074, U+20AC, U+2122, U+2191, U+2193, U+2212, U+2215, U+FEFF, U+FFFD        }          @font-face {          font-family: Roboto;          font-style: normal;          font-weight: 700;          src: local("Roboto Bold"), local("Roboto-Bold"), url(https://fonts.gstatic.com/s/roboto/v18/KFOlCnqEu92Fr1MmWUlfChc4EsA.woff2) format("woff2");          unicode-range: U+0100-024F, U+0259, U+1E00-1EFF, U+2020, U+20A0-20AB, U+20AD-20CF, U+2113, U+2C60-2C7F, U+A720-A7FF        }          @font-face {          font-family: Roboto;          font-style: normal;          font-weight: 700;          src: local("Roboto Bold"), local("Roboto-Bold"), url(https://fonts.gstatic.com/s/roboto/v18/KFOlCnqEu92Fr1MmWUlfBBc4.woff2) format("woff2");          unicode-range: U+0000-00FF, U+0131, U+0152-0153, U+02BB-02BC, U+02C6, U+02DA, U+02DC, U+2000-206F, U+2074, U+20AC, U+2122, U+2191, U+2193, U+2212, U+2215, U+FEFF, U+FFFD        }          .o_heading,        .o_sans {          font-family: Roboto, sans-serif !important        }          .o_heading,        b,        strong {          font-weight: 700 !important        }          a[x-apple-data-detectors] {          color: inherit !important;          text-decoration: none !important        }      }    </style>  </head>    <body class="o_body o_bg-light"    style="width:100%;margin:0;padding:0;-webkit-text-size-adjust:100%;-ms-text-size-adjust:100%;background-color:#f9f8fa">    <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation">      <tbody>        <tr>          <td class="o_hide" align="center"            style="display:none;font-size:0;max-height:0;width:0;line-height:0;overflow:hidden;mso-hide:all;visibility:hidden">            Email Summary (Hidden) </td>        </tr>      </tbody>    </table>    <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation">      <tbody>        <tr>          <td class="o_bg-light o_px-xs" align="center"            style="background-color: #f9f8fa; padding-left: 8px; padding-right: 8px;">            <table class="o_block" width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation"              style="max-width: 632px; margin: 0 auto;">              <tbody>                <tr>                  <td style="padding: 10px 0; text-align: left;">  </td>                </tr>              </tbody>            </table>          </td>        </tr>      </tbody>    </table>    <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation"      style="background-color:#f9f8fa; margin:0; padding:0;">      <tbody>        <tr>          <td align="center">            <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation" style=" max-width:632px;">              <tbody>                <tr>                  <td align="center" style=" max-width:632px;">                    <div style="text-align:center; max-width:632px;"> <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation">
    <tbody>
      <tr>
        <td class="o_bg-light o_px-xs o_pt-lg o_xs-pt-xs" align="center"
          style="background-color: #f9f8fa;">
          <!--[if mso]><table width="632" cellspacing="0" cellpadding="0" border="0" role="presentation"><tbody><tr><td><![endif]-->
          <table class="o_block" width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation"
            style="margin: 0 auto;">
            <tbody>
              <tr>
                <td class="o_re o_bg-white o_px o_pb-md o_br-t" align="center"
                  style="font-size: 0;vertical-align: top;background-color: #ecf9fb;border-radius: 4px 4px 0px 0px;padding-left: 16px;padding-right: 16px;padding-top: 7px;padding-bottom: 7px;">
                  <!--[if mso]><table cellspacing="0" cellpadding="0" border="0" role="presentation"><tbody><tr><td width="200" align="left" valign="top" style="padding:0px 8px;"><![endif]-->
                  <div class="o_col o_col-2"
                    style="display: inline-block;vertical-align: top;width: 100%;max-width: 200px;">
                    <div class="o_px-xs o_sans o_text o_left o_xs-center"
                      style="font-family: Helvetica, Arial, sans-serif;margin-top: 0px;margin-bottom: 0px;font-size: 16px;line-height: 24px;text-align: center;padding-left: 8px;padding-right: 8px;">
                      <p style="margin-top: 0px;margin-bottom: 0px;"><a class="o_text-primary"
                          style="text-decoration: none;outline: none;color: #126de5;"><img
                            src="https://timechampimages.blob.core.windows.net/icons/timechamp_logo.png" width="150" height="36"
                            style="max-width: 150px;-ms-interpolation-mode: bicubic;vertical-align: middle;border: 0;line-height: 100%;height: auto;outline: none;text-decoration: none;"></a>
                      </p>
                    </div>
                  </div>
                </td>
              </tr>
            </tbody>
          </table>
        </td>
      </tr>
    </tbody>
  </table> </div>                  </td>                </tr>              </tbody>            </table>          </td>        </tr>      </tbody>    </table>    <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation">      <tbody>        <tr>          <td class="o_bg-light o_px-xs" align="center"            style="background-color:#f9f8fa;padding-left:8px;padding-right:8px">            <table class="o_block" width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation"              style="max-width:632px;margin:0 auto">              <tbody>                <tr>                  <td class="o_bg-white o_px-md o_py-xl o_xs-py-md o_sans o_text-md o_text-light" align="left"                    style="font-family:Helvetica,Arial,sans-serif;margin-top:0;margin-bottom:0;font-size:16px;line-height:24px;background-color:#fff;color:#363636;padding-left:24px;padding-right:24px;padding-top:15px;padding-bottom:15px">                    <p style="text-align: justify;font-size: 16px;color:#363636;margin:0 0 12px 0;">                      We would like to inform you that time entries were not recorded in Time Champ for some users yesterday.                    </p>                    <p style="text-align: justify;font-size: 16px;color:#363636;margin:0 0 8px 0;">                      Please find the attached report, which includes:                    </p>                    <ul style="text-align: justify;font-size: 16px;color:#363636;margin:0 0 12px 20px;padding:0;">                      <li>Users whose desktops are not assigned</li>                      <li>Users with no time data available for yesterday</li>                    </ul>                    <p style="text-align: justify;font-size: 16px;color:#363636;margin:0 0 12px 0;">                      Kindly review the report and verify whether the users were absent, on leave, or if there was any system-related issue. Additionally, please ensure that all users have desktops properly assigned.                    </p>                    <p style="text-align: justify;font-size: 16px;color:#363636;margin:0 0 12px 0;">                      If you need any assistance, please feel free to contact the Time Champ Support Team&mdash;we&rsquo;re happy to help.                    </p>                  </td>                </tr>              </tbody>            </table>          </td>        </tr>      </tbody>    </table>    <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation"      style="background-color:#f9f8fa; margin:0; padding:0;">      <tbody>        <tr>          <td align="center">            <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation" style=" max-width:632px;">              <tbody>                <tr>                  <td align="center" style=" max-width:632px;">                    <div style="text-align:center;  max-width:632px;"> <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation">
    <tbody>
      <tr>
        <td class="o_bg-light o_px-xs o_pb-lg o_xs-pb-xs" align="center"
          style="background-color: #f9f8fa;padding-bottom:32px;white-space: nowrap;">
          <table class="o_block" width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation"
            style="margin:0 auto;">
            <tbody>
              <tr style="background-color: #ecf9fb;">
                <td class="o_re o_px o_pb-lg" style="font-size:0;padding-left:10px;">
                  <div class="small_font ccc"
                    style="display:inline-block;vertical-align:top;width:100%;max-width:200px">
                    <div class="o_px-xs o_sans o_text-xs o_text-dark_light o_left o_xs-center"
                      style="font-family:Helvetica,Arial,sans-serif;margin-bottom:0;font-size:14px;text-align:left;padding-left:8px;padding-right:8px;white-space: nowrap;">
                      <p style="margin-top:0;margin-bottom:0" class="small_font">For support <a class="small_font"
                          class="o_text-dark_light o_underline"
                          href="https://timechamp.freshdesk.com/support/solutions/articles/101000451716" target="_blank"
                          style="outline:0;color:#1e9999;text-decoration: none;">Contact us</a> </p>
                    </div>
                  </div>
                </td>
                <td style="height: 35px;white-space: nowrap;">
                  <div class="small_font ccc"
                    style="display:inline-block;vertical-align:top;width:100%;max-width:135px">
                    <div class="o_px-xs o_sans o_text-xs o_text-dark_light o_left o_xs-center"
                      style="font-family:Helvetica,Arial,sans-serif;margin-bottom:0;font-size:14px;text-align:Center;padding-left:8px;padding-right:8px;white-space: nowrap;">
                      <span><a class="small_font" href="https://timechamp.io/documents/TimeChampTermsAndConditions.pdf"
                          target="_blank" style="color: #1e9999;text-decoration: none;padding-left: 8px;">Terms &
                          Conditions</a> </span> </div>
                  </div>
                <td>
                  <div class="small_font"
                    style="display:inline-block;vertical-align:top;width:100%;max-width:200px;white-space: nowrap;">
                    <div class="o_px-xs o_sans o_text-xs o_text-dark_light o_right"
                      style="font-family:Helvetica,Arial,sans-serif;margin-top:0;margin-bottom:0;font-size:15px;line-height:21px;text-align:right;padding-left:8px;padding-right:8px;white-space: nowrap;">
                      <p style="margin-top:0;margin-bottom:0"> <a class="o_text-dark_light"
                          href="https://www.youtube.com/@timechamp_io" target="_blank"
                          style="text-decoration:none;outline:0;"> <img class="youtube"
                            src="https://timechampimages.blob.core.windows.net/icons/youtube_logo.png" width="19" height="19" alt="fb"
                            style="max-width:36px;-ms-interpolation-mode:bicubic;vertical-align:middle;border:0;line-height:100%;height:auto;outline:0;text-decoration:none">
                        </a><span>&nbsp;</span> <a class="o_text-dark_light" href="https://www.facebook.com/TimeChamp1/"
                          target="_blank" style="text-decoration:none;outline:0;"> <img class="youtube"
                            src="https://timechampimages.blob.core.windows.net/icons/facebook_logo.png" width="14" height="14" alt="fb"
                            style="max-width:36px;-ms-interpolation-mode:bicubic;vertical-align:middle;border:0;line-height:100%;height:auto;outline:0;text-decoration:none">
                        </a> <span>&nbsp;</span> <a class="o_text-dark_light" href="https://twitter.com/timechamp_io"
                          target="_blank" style="text-decoration:none;outline:0;"> <img class="youtube"
                            src="https://timechampimages.blob.core.windows.net/icons/twitter_logo.png" width="14" height="14" alt="tw"
                            style="max-width:36px;-ms-interpolation-mode:bicubic;vertical-align:middle;border:0;line-height:100%;height:auto;outline:0;text-decoration:none">
                        </a> <span>&nbsp;</span> <a class="o_text-dark_light"
                          href="https://www.linkedin.com/showcase/timechamp/" target="_blank"
                          style="text-decoration:none;outline:0;"> <img class="youtube"
                            src="https://timechampimages.blob.core.windows.net/icons/linkdin_logo.png" width="14" height="14" alt="ig"
                            style="max-width:36px;-ms-interpolation-mode:bicubic;vertical-align:middle;border:0;line-height:100%;height:auto;outline:0;text-decoration:none">
                        </a> <span>&nbsp;</span> <a class="o_text-dark_light"
                          href="https://www.instagram.com/timechamp.io/" target="_blank"
                          style="text-decoration:none;outline:0;"> <img class="youtube"
                            src="https://timechampimages.blob.core.windows.net/icons/instagram_logo.png" width="14" height="14" alt="ig"
                            style="max-width:36px;-ms-interpolation-mode:bicubic;vertical-align:middle;border:0;line-height:100%;height:auto;outline:0;text-decoration:none">
                        </a><span>&nbsp;&nbsp;&nbsp;</span> </p>
                    </div>
                  </div>
                </td>
              </tr>
            </tbody>
          </table>
          <div class="o_hide-xs" style="font-size:64px;line-height:64px;height:64px">&nbsp;</div>
        </td>
      </tr>
    </tbody>
  </table> </div>                  </td>                </tr>              </tbody>            </table>          </td>        </tr>      </tbody>    </table>  </body>    </html>
Rendered preview (sandboxed)

Stage 5 — Dispatched

Outcome
Inserted
SentMailId
65108352-1EF5-4EA6-9615-44E38C1DBC99
Skip reason
Error
At
2026-07-24 03:21:11.494753

Events

AtStageLevelMessagemsWorker
2026-07-24 03:21:10.513191 DataFetch Info --- Stage 2 begin --- template=UrgentAttention recipient=ashok.kumar@kwglobal.com userId=CCCB3F8C-085C-446A-A54F-74B80C726A8F thr-34076
2026-07-24 03:21:10.537184 DataFetch Info UrgentAttention: filtered urgent_cache (6022 rows) by HrUserId=cccb3f8c-085c-446a-a54f-74b80c726a8f -> 1 row(s) thr-34076
2026-07-24 03:21:10.585236 DataFetch Info Wrote EmailComp_Job_Data (491 bytes); shape=dict, top-level=['urgent_rows', 'row_counts'] 27 thr-34076
2026-07-24 03:21:10.604187 Render Info --- Stage 3 begin --- template=UrgentAttention recipient=ashok.kumar@kwglobal.com thr-34076
2026-07-24 03:21:10.608192 Render Info dbo.HtmlTemplates lookup 'UrgentAttentionTemplate': OK (9306 chars, batch-cache hit) thr-34076
2026-07-24 03:21:10.786192 Render Info Rendered (17353 bytes, subject='Time Champ: URGENT ATTENTION: Some of your members were not tracked yesterday ( 23-Jul-2026 )', attachments=1) 178 thr-34076
2026-07-24 03:21:11.311744 QA Info QA passed (15 check(s)) 452 thr-34076
2026-07-24 03:21:11.331746 Dispatch Info >>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='ashok.kumar@kwglobal.com', @Subject='Time Champ: URGENT ATTENTION: Some of your members were not ...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='b8775406-2203-40e0-bec0-975396a9e7d9') thr-34076
2026-07-24 03:21:11.356744 Dispatch Info <<< USP_EmailComp_InsertMail returned MailId=65108352-1ef5-4ea6-9615-44e38c1dbc99 in 18ms (inserted) 18 thr-34076
2026-07-24 03:21:11.445749 Dispatch Info >>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=65108352-1ef5-4ea6-9615-44e38c1dbc99, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/1f54c5277cc242c99d810fd0122ebd73_CCCB3F8C-085C-446A-A54F-74B80C726A8F-UrgentAttentionReport_23-Jul-2026.xlsx') thr-34076
2026-07-24 03:21:11.470750 Dispatch Info <<< USP_EmailComp_InsertMailAttchment OK in 7ms 7 thr-34076
2026-07-24 03:21:11.484787 Dispatch Info Inserted into SentMail. MailId=65108352-1ef5-4ea6-9615-44e38c1dbc99 thr-34076