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

Quincy: Import Is getting failed

    Details

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

      Description

      Import is getting failed for Special characters like '
      Consider all Characters which are accepted through Ui On import DTS:

      Refer Below Error Log:

      ErrorID : 0
      ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportValidation.ImportData->ImportValidation.ProcessImportDataFile->ImportValidation.ValidateAndInsertData->ImportValidation.CreateUserForEmployee->ImportValidation.GenerateUserInsertQuery
      ErrorMessage: The input is not a valid Base-64 string as it contains a non-base 64 character, more than two padding characters, or an illegal character among the padding characters.
      StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.SaveAndGetData(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity)
      at WORKTERRA.ControllerAppTier.SaveAndGetData(Int32 intProjectsId, String strInput)
      TargetSite: System.String SaveAndGetData(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity)

        Attachments

        1. Import.png
          Import.png
          209 kB
        2. Quincy_EMP_Data.txt
          0.3 kB

          Issue Links

            Activity

            rashmita.dudhe Rashmita Dudhe (Inactive) created issue -
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to WT-9027 [ WT-9027 ]
            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Rakesh Roy , Hrishikesh Deshpande , Jaideep Vinchurkar
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Assignee Vijay Siddha [ vijays ] Suraj Sokasane [ suraj.sokasane ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] snehal katkar [ snehal.katkar ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Assignee snehal katkar [ snehal.katkar ] Ankur Deshpande [ ankur.deshpande ]
            Hide
            ankur.deshpande Ankur Deshpande (Inactive) added a comment -

            Hi Rashmita Dudhe,

            I followed the steps and tried to import, it is working fine on local and stage.

            Regards,
            Ankur

            Show
            ankur.deshpande Ankur Deshpande (Inactive) added a comment - Hi Rashmita Dudhe , I followed the steps and tried to import, it is working fine on local and stage. Regards, Ankur
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Assignee Ankur Deshpande [ ankur.deshpande ] Rashmita Dudhe [ rashmita.dudhe ]
            ankur.deshpande Ankur Deshpande (Inactive) logged work - 19/May/17 03:01 AM
            • Time Spent:
              4h
               
              <No comment>
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 4h [ 14400 ]
            Worklog Id 47417 [ 47417 ]
            ankur.deshpande Ankur Deshpande (Inactive) logged work - 22/May/17 07:10 AM
            • Time Spent:
              2h
               
              <No comment>
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Hi Ankur Deshpande,

            I have again tried this on Quincy For HSPL Copy and it is getting Reproduced refer Screen shots and attached file use import template:9055

            Thanks
            Rashmita

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Hi Ankur Deshpande , I have again tried this on Quincy For HSPL Copy and it is getting Reproduced refer Screen shots and attached file use import template:9055 Thanks Rashmita
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Attachment Import.png [ 48979 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Attachment Quincy_EMP_Data.txt [ 48980 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Time Spent 4h [ 14400 ] 5h [ 18000 ]
            Worklog Id 48177 [ 48177 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Assignee Rashmita Dudhe [ rashmita.dudhe ] Ankur Deshpande [ ankur.deshpande ]
            rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 25/May/17 05:43 AM
            • Time Spent:
              1h
               
              <No comment>
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Time Spent 5h [ 18000 ] 7h [ 25200 ]
            Worklog Id 48640 [ 48640 ]
            ankur.deshpande Ankur Deshpande (Inactive) logged work - 25/May/17 02:35 PM - edited
            • Time Spent:
              2.5h
               
              <No comment>
            Hide
            ankur.deshpande Ankur Deshpande (Inactive) added a comment -

            HI All,

            Password is getting decrypted due to which import is getting failed. We are looking into this.

            Regards,
            Ankur

            Show
            ankur.deshpande Ankur Deshpande (Inactive) added a comment - HI All, Password is getting decrypted due to which import is getting failed. We are looking into this. Regards, Ankur
            ankur.deshpande Ankur Deshpande (Inactive) logged work - 26/May/17 02:37 PM
            • Time Spent:
              3h
               
              <No comment>
            Hide
            suraj.sokasane Suraj Sokasane (Inactive) added a comment -

            Hi Ankur Deshpande, Rashmita Dudhe,

            This is not related to special character in DTS. Can we change the description of issue?

            Rashmita Dudhe, can you please check if special character is present in DTS, how does it work on other company. Also, for the discrepancy in UI and DTS, we may have a different ticket.

            Show
            suraj.sokasane Suraj Sokasane (Inactive) added a comment - Hi Ankur Deshpande , Rashmita Dudhe , This is not related to special character in DTS. Can we change the description of issue? Rashmita Dudhe , can you please check if special character is present in DTS, how does it work on other company. Also, for the discrepancy in UI and DTS, we may have a different ticket.
            ankur.deshpande Ankur Deshpande (Inactive) logged work - 29/May/17 02:37 PM
            • Time Spent:
              3h
               
              <No comment>
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Time Spent 7h [ 25200 ] 9.5h [ 34200 ]
            Worklog Id 51330 [ 51330 ]
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Worklog Id 51330 [ 51330 ]
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Time Spent 9.5h [ 34200 ] 12.5h [ 45000 ]
            Worklog Id 51335 [ 51335 ]
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Time Spent 12.5h [ 45000 ] 15.5h [ 55800 ]
            Worklog Id 51338 [ 51338 ]
            ankur.deshpande Ankur Deshpande (Inactive) logged work - 02/Jun/17 03:17 AM
            • Time Spent:
              2h
               
              <No comment>
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Code Reviewed By Jaideep Vinchurkar [ 11908 ]
            Original Estimate 0h [ 0 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            ankur.deshpande Ankur Deshpande (Inactive) logged work - 03/Jun/17 03:18 AM
            • Time Spent:
              1h
               
              <No comment>
            rakeshr Rakesh Roy (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Assignee Ankur Deshpande [ ankur.deshpande ] Rashmita Dudhe [ rashmita.dudhe ]
            rashmita.dudhe Rashmita Dudhe (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)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Original Estimate 0h [ 0 ] 20h [ 72000 ]
            Hide
            ankur.deshpande Ankur Deshpande (Inactive) added a comment -

            Concern: The input is not a valid Base-64 string as it contains a non-base 64 character, more than two padding characters, or an illegal character among the padding characters.

            Cause : Error while decrypting the password.

            Correction: Removed the code which was used to decrypt the password. Removed the decryption code as the it was used in previous implementation where stored password was getting decrypted and encrypted again.

            Show
            ankur.deshpande Ankur Deshpande (Inactive) added a comment - Concern: The input is not a valid Base-64 string as it contains a non-base 64 character, more than two padding characters, or an illegal character among the padding characters. Cause : Error while decrypting the password. Correction: Removed the code which was used to decrypt the password. Removed the decryption code as the it was used in previous implementation where stored password was getting decrypted and encrypted again.
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Verified on Lb Environment consider below scenarios:
            1]Set Emp id for user id creation and password creation
            2]Import file with Employee ssn with all mandatory field
            3]File imported successfully crossed verified on UI
            4]Verified for new employee and update employee data through import
            working fine as expected

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified on Lb Environment consider below scenarios: 1]Set Emp id for user id creation and password creation 2]Import file with Employee ssn with all mandatory field 3]File imported successfully crossed verified on UI 4]Verified for new employee and update employee data through import working fine as expected
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Summary Import is getting failed for special characters in DTS Quincy: Import Is getting failed
            rashmita.dudhe Rashmita Dudhe (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)
            rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 07/Jun/17 04:35 AM
            • Time Spent:
              2h
               
              <No comment>
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Time Spent 15.5h [ 55800 ] 17.5h [ 63000 ]
            Worklog Id 52734 [ 52734 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Developer Ankur Deshpande [ ankur.deshpande ]
            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 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 12/Jun/17 12:05 PM
            • Time Spent:
              2h
               
              <No comment>
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Verified on Stage Environment consider below scenarios:
            1]Set Emp id for user id creation and password creation
            2]Import file with Employee ssn with all mandatory field
            3]File imported successfully crossed verified on UI
            4]Verified for new employee and update employee data through import
            working fine as expected

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified on Stage Environment consider below scenarios: 1]Set Emp id for user id creation and password creation 2]Import file with Employee ssn with all mandatory field 3]File imported successfully crossed verified on UI 4]Verified for new employee and update employee data through import working fine as expected
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Time Spent 17.5h [ 63000 ] 19.5h [ 70200 ]
            Worklog Id 54089 [ 54089 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Time Spent 19.5h [ 70200 ] 21.5h [ 77400 ]
            Worklog Id 54224 [ 54224 ]
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Time Spent 21.5h [ 77400 ] 22.5h [ 81000 ]
            Worklog Id 54227 [ 54227 ]
            khandu.kshirsagar Khandu Kshirsagar (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)
            rashmita.dudhe Rashmita Dudhe (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)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 20/Jun/17 01:00 PM
            • Time Spent:
              2h
               
              <No comment>
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Verified on Production Environment consider below scenarios:
            1]Set Emp id for user id creation and password creation
            2]Import file with Employee ssn with all mandatory field
            3]File imported successfully crossed verified on UI
            4]Verified for new employee and update employee data through import
            working fine as expected

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified on Production Environment consider below scenarios: 1]Set Emp id for user id creation and password creation 2]Import file with Employee ssn with all mandatory field 3]File imported successfully crossed verified on UI 4]Verified for new employee and update employee data through import working fine as expected
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Time Spent 22.5h [ 81000 ] 24.5h [ 88200 ]
            Worklog Id 56787 [ 56787 ]
            rashmita.dudhe Rashmita Dudhe (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)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Production Complete(10222)Level 1 values: Closed(10223) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 28/Jun/17 04:29 PM - edited
            • Time Spent:
              0.75h
               

              Discussion with Rashmita and Ankur.

            rashmita.dudhe Rashmita Dudhe (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)
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 24.5h [ 88200 ] 25.25h [ 90900 ]
            Worklog Id 58998 [ 58998 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Worklog Id 58998 [ 58998 ]
            rashmita.dudhe Rashmita Dudhe (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)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            rakeshr Rakesh Roy (Inactive) made changes -
            Bug Severity Medium [ 16702 ]
            satyap Satya made changes -
            Environment_New Stage [ 18443 ]
            Transition Time In Source Status Execution Times
            Ankur Deshpande (Inactive) made transition -
            Open In Development
            51d 14h 14m 1
            Rakesh Roy (Inactive) made transition -
            In Development In LB Testing
            14d 7h 51m 1
            Rakesh Roy (Inactive) made transition -
            In LB Testing Stage Testing
            6d 23h 59m 1
            Rashmita Dudhe (Inactive) made transition -
            Stage Testing In Production Testing
            8d 1h 45m 1
            Rashmita Dudhe (Inactive) made transition -
            In Production Testing Production Complete
            23m 34s 1
            Rashmita Dudhe (Inactive) made transition -
            Production Complete Closed
            4s 1

              People

              Assignee:
              rashmita.dudhe Rashmita Dudhe (Inactive)
              Reporter:
              rashmita.dudhe Rashmita Dudhe (Inactive)
              Developer:
              Ankur Deshpande (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 20h Original Estimate - 20h
                  20h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 25.25h
                  25.25h