WORKTERRAProject Type: software

WORKTERRA

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

Wheaton Import Issue

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      Production
    • Module:
      BenAdmin - Import
    • Reported by:
      Support
    • Item State:
      Development - On Hold
    • Issue Importance:
      Must Have

      Description

      I am trying to import attached file "SpouseVerifiedData.txt" with the template "Spouse Dependent Audit Import" and getting an error. I have to get this data in before Monday PST.

      Also I imported another file named "SpouseVerifiedData2.txt" and got a bad file with 85 bad records. The error message is saying "Spouse/Domestic Partner/Common Law Spouse Already Exists for Employee.". I am just trying to update an UDF. Can you please check the bad file as well which is attached herewith?

      CC - Vijay Siddha, Suraj Sokasane

        Attachments

          Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. WT-4845 Import - Session being overwritten due to AJAX calls

          • Critical - This problem will block progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            amitthorve Amit Thorve (Inactive) created issue -
            amitthorve Amit Thorve (Inactive) made changes -
            Field Original Value New Value
            Attachment SpouseVerifiedData.txt [ 41449 ]
            amitthorve Amit Thorve (Inactive) made changes -
            Attachment Bad_SpouseVerifiedData203_05_2017 11_04_50 AM.txt [ 41450 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Suraj Sokasane [ suraj.sokasane ]
            Hide
            Permalink
            amitthorve Amit Thorve (Inactive) added a comment -

            Suraj Sokasane I need the status ASAP. I have to load the data ASAP in the system.

            CC-Jaideep Vinchurkar, Vijay Siddha

            Show
            amitthorve Amit Thorve (Inactive) added a comment - Suraj Sokasane I need the status ASAP. I have to load the data ASAP in the system. CC- Jaideep Vinchurkar , Vijay Siddha
            Hide
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) added a comment - - edited

            Hi Amit Thorve,

            Here are the details about the issue:

            Import failed for file one:
            When a file is big, session is overwritten and Import is called twice leading to the failure. As it fails 2nd time, Import was done once. Data was changed when you imported the file but back-end routines were not executed. This is known issue and we are working on it under WT-4845.
            We have re-imported the files and executed the back-end routines.

            85 Records sent to bad for file two:
            This is caused due to difference in data of dependents in file and system. The major one was relationship type. For most dependents, it is Spouse in file and Domestic Partner in the system currently.
            I've sent a report for first file one which shows the difference.

            Please let us know if you need more details on this.

            Show
            suraj.sokasane Suraj Sokasane (Inactive) added a comment - - edited Hi Amit Thorve , Here are the details about the issue: Import failed for file one: When a file is big, session is overwritten and Import is called twice leading to the failure. As it fails 2nd time, Import was done once. Data was changed when you imported the file but back-end routines were not executed. This is known issue and we are working on it under WT-4845 . We have re-imported the files and executed the back-end routines. 85 Records sent to bad for file two: This is caused due to difference in data of dependents in file and system. The major one was relationship type. For most dependents, it is Spouse in file and Domestic Partner in the system currently. I've sent a report for first file one which shows the difference. Please let us know if you need more details on this.
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 06/Mar/17 05:10 PM - edited
            • Time Spent:
              8h
               

              Analysis, Debug. Generate report and execute back-end routine.

            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] Amit Thorve [ amitthorve ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 8h [ 28800 ]
            Worklog Id 29309 [ 29309 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Worklog Id 29309 [ 29309 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Link This issue relates to WT-4845 [ WT-4845 ]
            Hide
            Permalink
            rakeshr Rakesh Roy (Inactive) added a comment -

            Suraj Sokasane Assigning to you as its related to WT - 4845 on which you are working on. Please keep this JIRA open until that is fixed.

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Suraj Sokasane Assigning to you as its related to WT - 4845 on which you are working on. Please keep this JIRA open until that is fixed.
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Amit Thorve [ amitthorve ] Suraj Sokasane [ suraj.sokasane ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: On Hold(10207)
            Original Estimate 0h [ 0 ]
            satyap Satya made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            Hide
            Permalink
            satyap Satya added a comment -

            Hi Amit Thorve

            We are fixing this issue in scope of WT-4845. Hence linking this jira ticekt & marking as duplicate.

            Regards,
            Satya Prakash

            Cc: Rakesh Roy Vijay Siddha Suraj Sokasane

            Show
            satyap Satya added a comment - Hi Amit Thorve We are fixing this issue in scope of WT-4845 . Hence linking this jira ticekt & marking as duplicate. Regards, Satya Prakash Cc: Rakesh Roy Vijay Siddha Suraj Sokasane
            satyap Satya made changes -
            Resolution Duplicate [ 3 ]
            Status In Development [ 10007 ] Rejected [ 10004 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Status Rejected [ 10004 ] Closed [ 6 ]
            satyap Satya made changes -
            Environment_New Production [ 18442 ]
            Transition Time In Source Status Execution Times
            Satya made transition -
            Open In Development
            		49d 10h 15m 1
            Satya made transition -
            In Development Rejected
            		1m 13s 1
            Suraj Sokasane (Inactive) made transition -
            Rejected Closed
            		7m 47s 1

              People

              Assignee:
              suraj.sokasane Suraj Sokasane (Inactive)
              Reporter:
              amitthorve Amit Thorve (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 8h
                  8h