WORKTERRAProject Type: software

WORKTERRA

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

          relates to

          Support Activity - Support Activity WT-9027 Quincy - Maximum Contingency 1.5 times salary is not available

          • High - Serious problem that could block progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Rakesh Roy,Hrishikesh Deshpande,Jaideep Vinchurkar

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Rakesh Roy , Hrishikesh Deshpande , Jaideep Vinchurkar
            Hide
            Permalink
            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
            Hide
            Permalink
            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
            Hide
            Permalink
            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
            Hide
            Permalink
            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.
            Hide
            Permalink
            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
            Permalink
            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
            Hide
            Permalink
            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
            Hide
            Permalink
            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

              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