WORKTERRAProject Type: software

WORKTERRA

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

University Health - Export - Internal Error

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Support Task Type:
      Configuration
    • Reported by:
      Client
    • Company:
      University Health
    • Module:
      BenAdmin - Export
    • Severity:
      Simple

      Description

      Hello development team,

      I am getting an error when I export this file. It's 10/17/2017 today at 12:20PM PST.

      Company template name: UH_RxBenefits

        Attachments

          Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. WT-11681 University Health - Incorrect date time inserted

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

            Activity

            Ascending order - Click to sort in descending order
            Van.Nguyen Van Nguyen (Inactive) created issue -
            amruta.lohiya Amruta Lohiya made changes -
            Field Original Value New Value
            Assignee Satya [ ID10004 ] Rohan J Khandave [ rohan.khandave ]
            Hide
            Permalink
            rohan.khandave Rohan J Khandave (Inactive) added a comment -

            When no run-date is there error in
            IsDemographics function – > InsertUpdateChangedImportExportEnrollmentData

            When run date present error in
            GetImportExportTemplateInformation --> UDF_GetExportedDeadEnrollments

            Both having error of DateDiff oveflow exception.

            Show
            rohan.khandave Rohan J Khandave (Inactive) added a comment - When no run-date is there error in IsDemographics function – > InsertUpdateChangedImportExportEnrollmentData When run date present error in GetImportExportTemplateInformation --> UDF_GetExportedDeadEnrollments Both having error of DateDiff oveflow exception.
            rohan.khandave Rohan J Khandave (Inactive) made changes -
            Assignee Rohan J Khandave [ rohan.khandave ] Ganesh Sadawarte [ ganesh.sadawarte ]
            prasadp Prasad Pise (Inactive) made changes -
            Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Export(10110)
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            Permalink
            jyoti.mayne Jyoti Mayne logged work - 18/Oct/17 10:18 AM
            • Time Spent:
              0.75h
               

              analysis and discussion

            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Attachment Incorrect_Datetimestamp.png [ 64892 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Attachment Incorrect_Datetimestamp.png [ 64892 ]
            Permalink
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 18/Oct/17 11:44 AM
            • Time Spent:
              4h
               
              <No comment>
            Hide
            Permalink
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - - edited

            Hi Van Nguyen,

            Please find below 3C's

            Concern: University Health - Export - Internal Error

            Cause: As we checked found that there was incorrect date time inserted against enrollment through the Reduction Schedule Service due to this its throwing error while export. As we comparing enrollment date time to process records on file.

            Correction: We have corrected date time of enrollment, now file exporting properly and we have created separate JIRA WT-11681 for root cause analysis of incorrect date time.

            Jyoti Mayne as we discuss please check incorrect date time issue and update to Van Nguyen.

            CC-Vinayak Kulkarni,Gaurav Sodani,Rohan J Khandave

            Thanks,
            Ganesh

            Show
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - - edited Hi Van Nguyen , Please find below 3C's Concern : University Health - Export - Internal Error Cause : As we checked found that there was incorrect date time inserted against enrollment through the Reduction Schedule Service due to this its throwing error while export. As we comparing enrollment date time to process records on file. Correction : We have corrected date time of enrollment, now file exporting properly and we have created separate JIRA WT-11681 for root cause analysis of incorrect date time. Jyoti Mayne as we discuss please check incorrect date time issue and update to Van Nguyen . CC- Vinayak Kulkarni , Gaurav Sodani , Rohan J Khandave Thanks, Ganesh
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Remaining Estimate 4h [ 14400 ]
            Original Estimate 4h [ 14400 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Remaining Estimate 4h [ 14400 ] 0h [ 0 ]
            Time Spent 4h [ 14400 ]
            Worklog Id 85562 [ 85562 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Assignee Ganesh Sadawarte [ ganesh.sadawarte ] Van Nguyen [ van.nguyen ]
            Resolution Done [ 10000 ]
            Status In Progress [ 3 ] Resolved [ 5 ]
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Status Resolved [ 5 ] Closed [ 6 ]
            Hide
            Permalink
            Van.Nguyen Van Nguyen (Inactive) added a comment -

            Hi Ganesh Sadawarte,

            Thank you, I was able to export the file successfully today.

            Show
            Van.Nguyen Van Nguyen (Inactive) added a comment - Hi Ganesh Sadawarte , Thank you, I was able to export the file successfully today.
            jyoti.mayne Jyoti Mayne made changes -
            Link This issue relates to WT-11681 [ WT-11681 ]
            jyoti.mayne Jyoti Mayne made changes -
            Resolution Done [ 10000 ]
            Status Closed [ 6 ] Reopened [ 4 ]
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 4h [ 14400 ] 4.75h [ 17100 ]
            Worklog Id 86669 [ 86669 ]
            jyoti.mayne Jyoti Mayne made changes -
            Resolution Done [ 10000 ]
            Status Reopened [ 4 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Ganesh Sadawarte (Inactive) made transition -
            Open In Progress
            		10h 33m 1
            Ganesh Sadawarte (Inactive) made transition -
            In Progress Resolved
            		5h 48m 1
            Van Nguyen (Inactive) made transition -
            Resolved Closed
            		1d 12h 4m 1
            Jyoti Mayne made transition -
            Closed Reopen
            		6d 10h 29m 1
            Jyoti Mayne made transition -
            Reopen Closed
            		21s 1

              People

              Assignee:
              Van.Nguyen Van Nguyen (Inactive)
              Reporter:
              Van.Nguyen Van Nguyen (Inactive)
              EDI Analyst 1:
              Van Nguyen (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 4h Original Estimate - 4h
                  4h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 4.75h
                  4.75h