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)
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
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
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
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.
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.
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.
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.
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 (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
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 (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
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 (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
Bug
Critical
WT-9027 Quincy - Maximum Contingency 1.5 times salary is not available
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 
Khandu Kshirsagar (Inactive)
made changes -
Rakesh Roy,Hrishikesh Deshpande,Jaideep Vinchurkar