WORKTERRAProject Type: software

WORKTERRA

Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-11082

OE Dashboard -> Schedule shift service not reflected schedule start date on dashboard

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      QA
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Export
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed

      Attachments

        Issue Links

        is caused by

        Enhancement - An improvement or enhancement to an existing feature or task. WT-10492 Automated service/job to set the template’s schedule start date.

        • Medium - Has the potential to affect progress.
        • Closed

          Activity

          Ascending order - Click to sort in descending order
          Permalink
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 13/Sep/17 12:00 PM - edited
          • Time Spent:
            1.5h
             
            <No comment>
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) created issue -
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Field Original Value New Value
          Summary OE Dashboard -> Schedule shift service not reflected schedule start time on dashboard OE Dashboard -> Schedule shift service not reflected schedule start date on dashboard
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Remaining Estimate 5h [ 18000 ] 3.5h [ 12600 ]
          Time Spent 1.5h [ 5400 ]
          Worklog Id 78840 [ 78840 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Development(10200)Level 1 values: In Progress(10206)
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Worklog Id 78840 [ 78840 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Code Review Date 14/Sep/2017
          Code Reviewed By Vinalyak Kulkarni [ 12100 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Assignee Ganesh Sadawarte [ ganesh.sadawarte ] Swapnil Eksambekar [ swapnil.eksambekar ]
          swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
          swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
          Permalink
          swapnil.eksambekar Swapnil Eksambekar (Inactive) logged work - 21/Sep/17 03:37 PM
          • Time Spent:
            2h
             
            <No comment>
          Hide
          Permalink
          swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment -

          Verified this issue on LB,Working as expected.

          Ready for Stage

          CC-Aniruddha DevRakesh RoyHrishikesh DeshpandeGaurav Sodani

          Show
          swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment - Verified this issue on LB,Working as expected. Ready for Stage CC- Aniruddha Dev Rakesh Roy Hrishikesh Deshpande Gaurav Sodani
          swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
          Remaining Estimate 3.5h [ 12600 ] 1.5h [ 5400 ]
          Time Spent 1.5h [ 5400 ] 3.5h [ 12600 ]
          Worklog Id 80342 [ 80342 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Production Due Date 28/Sep/2017
          Stage Due Date 27/Sep/17 [ 2017-09-27 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          QA Swapnil Eksambekar [ swapnil.eksambekar ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Environment LB [ 10800 ]
          swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
          Link This issue is caused by WT-10492 [ WT-10492 ]
          Hide
          Permalink
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

          Affected Files: OES_SP_Export_ShiftScheduleStartDateFromOpenEnrollmentDashboard.sql

          Show
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Affected Files: OES_SP_Export_ShiftScheduleStartDateFromOpenEnrollmentDashboard.sql
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
          swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
          swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Re-open(10216)
          Hide
          Permalink
          swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment - - edited

          Verified this issue on Stage,It is getting reproduced on Stage.
          Schedule shift services are not reflected schedule start date on dashboard after setting OE file due date.Hence , i'm assigning this to you,After resolving issue ,Reassign to me.Please let me know,if any query.

          CC-Hrishikesh DeshpandeAniruddha DevRakesh RoyVinayak Kulkarni

          Show
          swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment - - edited Verified this issue on Stage,It is getting reproduced on Stage. Schedule shift services are not reflected schedule start date on dashboard after setting OE file due date.Hence , i'm assigning this to you,After resolving issue ,Reassign to me.Please let me know,if any query. CC- Hrishikesh Deshpande Aniruddha Dev Rakesh Roy Vinayak Kulkarni
          swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
          Assignee Swapnil Eksambekar [ swapnil.eksambekar ] Ganesh Sadawarte [ ganesh.sadawarte ]
          Permalink
          swapnil.eksambekar Swapnil Eksambekar (Inactive) logged work - 05/Oct/17 01:35 PM
          • Time Spent:
            2h
             
            <No comment>
          swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
          Remaining Estimate 1.5h [ 5400 ] 0h [ 0 ]
          Time Spent 3.5h [ 12600 ] 5.5h [ 19800 ]
          Worklog Id 83436 [ 83436 ]
          swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
          Resolution Unresolved [ 10200 ]
          Status Stage Testing [ 10201 ] Reopen in Stage [ 10023 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Time Spent 5.5h [ 19800 ] 7.5h [ 27000 ]
          Worklog Id 83871 [ 83871 ]
          Permalink
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 09/Oct/17 12:19 PM - edited
          • Time Spent:
            4.5h
             
            <No comment>
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Re-open(10216) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Time Spent 7.5h [ 27000 ] 8.5h [ 30600 ]
          Worklog Id 83871 [ 83871 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Status Reopen in Stage [ 10023 ] In Development [ 10007 ]
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Time Spent 8.5h [ 30600 ] 11.5h [ 41400 ]
          Worklog Id 84435 [ 84435 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          Hide
          Permalink
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

          Hi Swapnil Eksambekar,

          Please find below 3C'S

          Concern: Schedule shift services are not reflected schedule start date on dashboard after setting OE file due date

          Cause: There are two point were service not executed.
          1)SQL Agent was stop of stage due to this service not executed on stage from 9/29/2017 to 10/9/2017.
          2) There was code is issue while comparing the ID dynamic query.

          Correction: for point first Ashwin Wankhede has started SQL Agent of stage. Now service will execute on stage. for second point we have fixed code issue.

          Please check and let me know if details.

          CC-Vinayak Kulkarni

          Thanks,
          Ganesh

          Show
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Hi Swapnil Eksambekar , Please find below 3C'S Concern : Schedule shift services are not reflected schedule start date on dashboard after setting OE file due date Cause : There are two point were service not executed. 1)SQL Agent was stop of stage due to this service not executed on stage from 9/29/2017 to 10/9/2017. 2) There was code is issue while comparing the ID dynamic query. Correction : for point first Ashwin Wankhede has started SQL Agent of stage. Now service will execute on stage. for second point we have fixed code issue. Please check and let me know if details. CC- Vinayak Kulkarni Thanks, Ganesh
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Assignee Ganesh Sadawarte [ ganesh.sadawarte ] Swapnil Eksambekar [ swapnil.eksambekar ]
          Permalink
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 12/Oct/17 12:09 PM
          • Time Spent:
            3h
             
            <No comment>
          swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
          Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
          Permalink
          swapnil.eksambekar Swapnil Eksambekar (Inactive) logged work - 12/Oct/17 01:33 PM
          • Time Spent:
            1h
             
            <No comment>
          swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
          Hide
          Permalink
          swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment -

          Verified this issue on Stage,
          Working as expected.

          Ready for Production deployment.

          CC-Aniruddha DevRakesh RoyHrishikesh Deshpande

          Show
          swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment - Verified this issue on Stage, Working as expected. Ready for Production deployment. CC- Aniruddha Dev Rakesh Roy Hrishikesh Deshpande
          swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
          Time Spent 11.5h [ 41400 ] 12.5h [ 45000 ]
          Worklog Id 84615 [ 84615 ]
          swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
          swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
          Production Due Date 28/Sep/2017 19/Sep/2017
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Time Spent 12.5h [ 45000 ] 14h [ 50400 ]
          Worklog Id 83871 [ 83871 ]
          ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
          swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
          Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
          swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
          Hide
          Permalink
          rakeshr Rakesh Roy (Inactive) added a comment -

          Swapnil Eksambekar As discussed with Aniruddha complete it by tomorrow i.e. 19th Oct.

          Show
          rakeshr Rakesh Roy (Inactive) added a comment - Swapnil Eksambekar As discussed with Aniruddha complete it by tomorrow i.e. 19th Oct.
          Hide
          Permalink
          swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment -

          Hello Rakesh,
          Will do it today itself.

          Thanks,
          Swapnil Eksambekar

          From: "Rakesh Roy (Jira)" <jira@workterra.atlassian.net>
          To: "swapnil eksambekar" <swapnil.eksambekar@harbingergroup.com>
          Sent: Wednesday, October 18, 2017 12:17:20 PM
          Subject: [JIRA] (WT-11082) OE Dashboard -> Schedule shift service not reflected schedule start date on dashboard

          Message Title

          Rakesh Roy commented on WT-11082

          Re: OE Dashboard -> Schedule shift service not reflected schedule start date on dashboard

          Swapnil Eksambekar As discussed with Aniruddha complete it by tomorrow i.e. 19th Oct.

          Add Comment

          Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS

          This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100066- sha1:b2cb244 )

          Disclaimer: This e-mail may contain Privileged/Confidential information and is intended
          only for the individual(s) named. Any review, retransmission, dissemination or other use
          of, or taking of any action in reliance upon this information by persons or entities
          other than the intended recipient is prohibited. Please notify the sender, if you have
          received this e-mail by mistake and delete it from your system. Information in this
          message that does not relate to the official business of the company shall be understood
          as neither given nor endorsed by it. E-mail transmission cannot be guaranteed to be
          secure or error-free. The sender does not accept liability for any errors or omissions in
          the contents of this message which arise as a result of e-mail transmission.If
          verification is required please request a hard-copy version.
          Visit us at http://www.harbingergroup.com/

          Show
          swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment - Hello Rakesh, Will do it today itself. Thanks, Swapnil Eksambekar From: "Rakesh Roy (Jira)" <jira@workterra.atlassian.net> To: "swapnil eksambekar" <swapnil.eksambekar@harbingergroup.com> Sent: Wednesday, October 18, 2017 12:17:20 PM Subject: [JIRA] ( WT-11082 ) OE Dashboard -> Schedule shift service not reflected schedule start date on dashboard Message Title Rakesh Roy commented on WT-11082 Re: OE Dashboard -> Schedule shift service not reflected schedule start date on dashboard Swapnil Eksambekar As discussed with Aniruddha complete it by tomorrow i.e. 19th Oct. Add Comment Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100066- sha1:b2cb244 ) Disclaimer: This e-mail may contain Privileged/Confidential information and is intended only for the individual(s) named. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. Please notify the sender, if you have received this e-mail by mistake and delete it from your system. Information in this message that does not relate to the official business of the company shall be understood as neither given nor endorsed by it. E-mail transmission cannot be guaranteed to be secure or error-free. The sender does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission.If verification is required please request a hard-copy version. Visit us at http://www.harbingergroup.com/
          Permalink
          swapnil.eksambekar Swapnil Eksambekar (Inactive) logged work - 19/Oct/17 09:25 AM
          • Time Spent:
            3h
             
            <No comment>
          Hide
          Permalink
          swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment -

          Verified this fix on Production,It is working as expected.

          CC-Rakesh RoyAniruddha DevHrishikesh Deshpande

          Show
          swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment - Verified this fix on Production,It is working as expected. CC- Rakesh Roy Aniruddha Dev Hrishikesh Deshpande
          swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
          Resolution Unresolved [ 10200 ] Fixed [ 1 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
          Status Production Complete [ 10028 ] Closed [ 6 ]
          swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
          swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
          Time Spent 14h [ 50400 ] 17h [ 61200 ]
          Worklog Id 85650 [ 85650 ]
          satyap Satya made changes -
          Environment_New LB [ 18444 ]
          Transition Time In Source Status Execution Times
          Ganesh Sadawarte (Inactive) made transition -
          Open In Development
          		1d 15h 32m 1
          Swapnil Eksambekar (Inactive) made transition -
          Stage Testing Reopened in Stage
          		8d 21h 26m 1
          Ganesh Sadawarte (Inactive) made transition -
          Reopened in Stage In Development
          		5d 19h 29m 1
          Ganesh Sadawarte (Inactive) made transition -
          In Development In LB Testing
          		3d 10h 48m 2
          Swapnil Eksambekar (Inactive) made transition -
          In LB Testing Stage Testing
          		9d 4h 54m 2
          Swapnil Eksambekar (Inactive) made transition -
          Stage Testing In Production Testing
          		4d 12h 30m 1
          Swapnil Eksambekar (Inactive) made transition -
          In Production Testing Production Complete
          		2d 7h 22m 1
          Swapnil Eksambekar (Inactive) made transition -
          Production Complete Closed
          		4s 1

            People

            Assignee:
            swapnil.eksambekar Swapnil Eksambekar (Inactive)
            Reporter:
            Ganesh.sadawarte Ganesh Sadawarte (Inactive)
            Developer:
            Ganesh Sadawarte (Inactive)
            QA:
            Swapnil Eksambekar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Dev Due Date:
              Pre-Prod Due Date:
              Production Due Date:
              Code Review Date:

                Time Tracking

                Estimated:
                Original Estimate - 5h Original Estimate - 5h
                5h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 17h
                17h