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

ACA_2017_Code import_Getting error while importing code.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Environment:
      QA
    • Module:
      ACA - 2017
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed

      Description

      1.Login to LB with Partner.
      2.Edit company "ACA Automation".
      3.Navigate to Home >> Company Home >> BenAdmin Home >> BenAdmin Company Home>> ACA >> Template Management
      4.Use "ACA Correction 1095-C Part II SSN" correction template.
      5.Browse "Code correction" CSV file and Click on Import.

      Actual: Received msg as "Import Failed".
      Expected: File should get imported properly.

      Error log is as follows:
      ErrorID : 0
      ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportValidation.ImportData->ImportValidation.ProcessImportDataFile->ImportValidation.SetPadding
      ErrorMessage: Conversion from string "2C" to type 'Integer' is not valid.

        Attachments

        1. Import.png
          Import.png
          135 kB
        2. Part II-SSN.csv
          11 kB
        3. WT-7367.png
          WT-7367.png
          34 kB

          Issue Links

            Activity

            smita.pawar Smita Pawar (Inactive) created issue -
            smita.pawar Smita Pawar (Inactive) made changes -
            Field Original Value New Value
            Assignee Nandkumar [ satyap ] Revansiddha Gaur [ revansiddha.gaur ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Link This issue is caused by WT-4579 [ WT-4579 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Attachment Import.png [ 35917 ]
            smita.pawar Smita Pawar (Inactive) logged work - 26/Dec/16 02:13 PM
            • Time Spent:
              0.5h
               
              <No comment>
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 40h [ 144000 ] 39.5h [ 142200 ]
            Time Spent 0.5h [ 1800 ]
            Worklog Id 15596 [ 15596 ]
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            Attaching code import file also

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Attaching code import file also
            smita.pawar Smita Pawar (Inactive) made changes -
            Attachment Part II-SSN.csv [ 36013 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited

            CONCERN: Import Failed

            CAUSE: In Plan Start Month expected Month but there is codes.

            CORRECTION: File will not be imported in such scenario it will throw Import failed error.. To import successfully you need to provide valid values.

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited CONCERN: Import Failed CAUSE: In Plan Start Month expected Month but there is codes. CORRECTION: File will not be imported in such scenario it will throw Import failed error.. To import successfully you need to provide valid values.
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Attachment WT-7367.png [ 36126 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Smita Pawar [ smita.pawar ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Code Review Date 28/Dec/2016
            Code Reviewed By Ramya Tantry [ 13001 ]
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Correction :
            Expected: Instead of file import successfully, it should be reflect in bad file. for that code changes has been given.

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Correction : Expected: Instead of file import successfully, it should be reflect in bad file. for that code changes has been given.
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 28/Dec/16 10:00 PM
            • Time Spent:
              3h
               

              Analysis,Coding,Unit Testing,Code Review,Check In to trunk,Lb.

            smita.pawar Smita Pawar (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)
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 39.5h [ 142200 ] 36.5h [ 131400 ]
            Time Spent 0.5h [ 1800 ] 3.5h [ 12600 ]
            Worklog Id 16079 [ 16079 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            smita.pawar Smita Pawar (Inactive) logged work - 02/Jan/17 12:09 PM
            • Time Spent:
              0.5h
               
              <No comment>
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned issue on LB comany [ACA Automation].Its working fine.
            Currently for incorrect data, now workterra system creating a .bad file.
            Now user can check bad file and correct data and re import the data

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on LB comany [ACA Automation] .Its working fine. Currently for incorrect data, now workterra system creating a .bad file. Now user can check bad file and correct data and re import the data
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 36.5h [ 131400 ] 36h [ 129600 ]
            Time Spent 3.5h [ 12600 ] 4h [ 14400 ]
            Worklog Id 16640 [ 16640 ]
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            Fix is ready for stage but we will move to stage with enhancement Jira WT-4579

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Fix is ready for stage but we will move to stage with enhancement Jira WT-4579
            smita.pawar Smita Pawar (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)
            rakeshr Rakesh Roy (Inactive) made changes -
            Developer Revansiddha Gaur [ revansiddha.gaur ]
            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)
            smita.pawar Smita Pawar (Inactive) made changes -
            Summary ACA_2017_Code import_Getting server error while importing code. ACA_2017_Code import_Getting error while importing code.
            smita.pawar Smita Pawar (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)
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            smita.pawar Smita Pawar (Inactive) logged work - 06/Jan/17 01:27 PM
            • Time Spent:
              0.5h
               
              <No comment>
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned issue on Stage [ACA Automation] company.
            Its working fine.
            Fix is ready for production but we will move this production with Enhancement WT-4579.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on Stage [ACA Automation] company. Its working fine. Fix is ready for production but we will move this production with Enhancement WT-4579 .
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 36h [ 129600 ] 35.5h [ 127800 ]
            Time Spent 4h [ 14400 ] 4.5h [ 16200 ]
            Worklog Id 17878 [ 17878 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            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)
            smita.pawar Smita Pawar (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
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned issue on production [Marqutte for Hspl].
            Its working fine.
            Now records are reflecting into bad file.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on production [Marqutte for Hspl] . Its working fine. Now records are reflecting into bad file.
            smita.pawar Smita Pawar (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)
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            This issue is fixed and working fine. Hence closing ticket.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - This issue is fixed and working fine. Hence closing ticket.
            smita.pawar Smita Pawar (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            smita.pawar Smita Pawar (Inactive) logged work - 11/Jan/17 01:06 PM
            • Time Spent:
              0.5h
               
              <No comment>
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 35.5h [ 127800 ] 35h [ 126000 ]
            Time Spent 4.5h [ 16200 ] 5h [ 18000 ]
            Worklog Id 18463 [ 18463 ]
            satyap Satya made changes -
            Environment_New LB [ 18444 ]
            Transition Time In Source Status Execution Times
            Smita Pawar (Inactive) made transition -
            Open In Development
            7d 5h 21m 1
            Smita Pawar (Inactive) made transition -
            In Development In LB Testing
            3s 1
            Smita Pawar (Inactive) made transition -
            In LB Testing Stage Testing
            4d 1h 22m 1
            Smita Pawar (Inactive) made transition -
            Stage Testing In Production Testing
            4d 22h 46m 1
            Smita Pawar (Inactive) made transition -
            In Production Testing Production Complete
            39s 1
            Smita Pawar (Inactive) made transition -
            Production Complete Closed
            13s 1

              People

              Assignee:
              smita.pawar Smita Pawar (Inactive)
              Reporter:
              smita.pawar Smita Pawar (Inactive)
              Developer:
              Revansiddha Gaur (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 40h
                  40h
                  Remaining:
                  Time Spent - 5h Remaining Estimate - 35h
                  35h
                  Logged:
                  Time Spent - 5h Remaining Estimate - 35h
                  5h