WORKTERRAProject Type: software

WORKTERRA

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

PSMC in Stage - Ghost Record Issue

    Details

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

      Description

      I need PSMC looked at ASAP in Stage. We have the employee census from the Client and wanted to at least load the Employee census to do all check outs in Stage prior to moving this account up into Production.

      We ran into the same issue we had when first loading Symphony. This group is only 504 lives. We imported as Asynchronous to ensure any eligibility checks etc. ran to successfully load the people and we have the ghost record issue again. The file didn’t load fully or completely (e.g. salary doesn’t appear to have loaded on records).

      We also can’t see these people in the search page but some are accessible via the reporting (361 of the 504). We need all employee records deleted with exception of those with the last name test to allow us to re-load.

      Also, we need root cause as to why we continue to see these issues and what we should be doing differently as we really thought Asynchronous was the way to go across the board.

        Attachments

          Issue Links

          causes

          Enhancement - An improvement or enhancement to an existing feature or task. WT-5525 Login page should allow single quote in User name

          • Medium - Has the potential to affect progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            vishal.bajad Vishal Bajad (Inactive) added a comment -

            HI Jennifer Leugers ,

            After Initial analysis , we found a single error log for import failure at '10/05/2016', so we tried to import same file locally but its imported successfully, We have scanned all imported files on '10/05/2016' but did not found any error log.

            Thanks !

            CC :Rohan J Khandave Jaideep Vinchurkar Satya

            Show
            vishal.bajad Vishal Bajad (Inactive) added a comment - HI Jennifer Leugers , After Initial analysis , we found a single error log for import failure at '10/05/2016', so we tried to import same file locally but its imported successfully, We have scanned all imported files on '10/05/2016' but did not found any error log. Thanks ! CC : Rohan J Khandave Jaideep Vinchurkar Satya
            Hide
            Permalink
            jjsassy99 Jennifer Johnson (Inactive) added a comment -

            H All -

            I dont think there was an error log -

            Please look at Jira WT-4845 This is the same issue -

            Jenni

            Show
            jjsassy99 Jennifer Johnson (Inactive) added a comment - H All - I dont think there was an error log - Please look at Jira WT-4845 This is the same issue - Jenni
            Hide
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) added a comment -

            Hi Jennifer Leugers, Jennifer Johnson,

            Please find the details below:

            Concern : Employees not displayed on search screen / Import failed.

            Cause: Some Employees in file have single quote in their name. For example:

            • O'Reilly
            • O'Donald

            System inserts those employees successfully, but while creating users for those employees insertion query is failed due to single quote.
            Because the user does not exist for employee, it's not displayed on search employee screen.

            Correction : We are looking for a possible solution. Until then, we can delete all employees and import those who do not have single quote in their name. For those who have quote in name, we have to find work arround.

            Please suggest.

            Note : The error was not logged because we have recently made changes in Import Export execution for performance improvement. Now the errors are logged properly.

            Show
            suraj.sokasane Suraj Sokasane (Inactive) added a comment - Hi Jennifer Leugers , Jennifer Johnson , Please find the details below: Concern : Employees not displayed on search screen / Import failed. Cause : Some Employees in file have single quote in their name. For example: O'Reilly O'Donald System inserts those employees successfully, but while creating users for those employees insertion query is failed due to single quote. Because the user does not exist for employee, it's not displayed on search employee screen. Correction : We are looking for a possible solution. Until then, we can delete all employees and import those who do not have single quote in their name. For those who have quote in name, we have to find work arround. Please suggest. Note : The error was not logged because we have recently made changes in Import Export execution for performance improvement. Now the errors are logged properly.
            Hide
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - - edited

            Hi Vikas,

            I think this is related to WT-5016. Please let us know what should be behavior of system in this case? do we need any code change for this? Please suggest

            Show
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - - edited Hi Vikas, I think this is related to WT-5016 . Please let us know what should be behavior of system in this case? do we need any code change for this? Please suggest
            Hide
            Permalink
            vikas.pawar Vikas Pawar (Inactive) added a comment -

            Hi Jaideep,

            Already i had created the common ticket WT-5155 for Single Quote issue. We need to validate all the places from where we are generating user name and password.

            Rakesh,
            Please plan regression testing for this ticket on priority.

            Show
            vikas.pawar Vikas Pawar (Inactive) added a comment - Hi Jaideep, Already i had created the common ticket WT-5155 for Single Quote issue. We need to validate all the places from where we are generating user name and password. Rakesh, Please plan regression testing for this ticket on priority.
            Hide
            Permalink
            vikas.pawar Vikas Pawar (Inactive) added a comment -

            Hi Samir Satya,

            I have listed scenarios in WT-5315 this ticket. Please validate those and add scenarios if any other scenario is misssed.

            CC: Saurabh Sablaka Jaideep Vinchurkar Suraj Sokasane

            Show
            vikas.pawar Vikas Pawar (Inactive) added a comment - Hi Samir Satya , I have listed scenarios in WT-5315 this ticket. Please validate those and add scenarios if any other scenario is misssed. CC: Saurabh Sablaka Jaideep Vinchurkar Suraj Sokasane
            Hide
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

            Please fix this for import.

            Show
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - Please fix this for import.
            Hide
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

            We need handle this scenario, where username contains single quote.

            Show
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - We need handle this scenario, where username contains single quote.
            Hide
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Verified on Lb Environment.
            Imported file with first name like O'Reilly, last name Like O'Donald and Email address:
            O'Donald.test@gmail.com
            O'Reilly.test@gmail.com

            file imported successfully and User id generated properly.

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified on Lb Environment. Imported file with first name like O'Reilly, last name Like O'Donald and Email address: O'Donald.test@gmail.com O'Reilly.test@gmail.com file imported successfully and User id generated properly.
            Hide
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - - edited

            Verified on Stage on PSMC for hspl company
            Imported file with first name like O'Reilly, last name Like O'Donald and Email address:
            O'Donald.test@gmail.com
            O'Reilly.test@gmail.com
            file imported successfully and User id generated properly.

            But using o'donald.test1034 user id not able to login it is showing validation message please check your login credential.

            I have tried with simple user id for same company working fine

            please check

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - - edited Verified on Stage on PSMC for hspl company Imported file with first name like O'Reilly, last name Like O'Donald and Email address: O'Donald.test@gmail.com O'Reilly.test@gmail.com file imported successfully and User id generated properly. But using o'donald.test1034 user id not able to login it is showing validation message please check your login credential. I have tried with simple user id for same company working fine please check
            Hide
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            It is not working on LB also for such type of user id :o'donald.test1034

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - It is not working on LB also for such type of user id :o'donald.test1034
            Hide
            Permalink
            vijayendra Vijayendra Shinde (Inactive) added a comment -

            Hi Rashmita Dudhe,

            For allowing single quote on login page, I have created new ticket-

            Single Quote in User name

            Thanks.

            Show
            vijayendra Vijayendra Shinde (Inactive) added a comment - Hi Rashmita Dudhe , For allowing single quote on login page, I have created new ticket- Single Quote in User name Thanks.
            Hide
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Verified on Production Environment.
            Imported file with first name like O'Reilly, last name Like O'Donald and Email address:
            O'Donald.test@gmail.com
            O'Reilly.test@gmail.com
            file imported successfully and User id generated properly.

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified on Production Environment. Imported file with first name like O'Reilly, last name Like O'Donald and Email address: O'Donald.test@gmail.com O'Reilly.test@gmail.com file imported successfully and User id generated properly.
            Hide
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Hi Jennifer Leugers,

            This is deployed and verified on Production.
            kindly, Update Jira accordingly.

            Thanks,
            Rashmita

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Hi Jennifer Leugers , This is deployed and verified on Production. kindly, Update Jira accordingly. Thanks, Rashmita

              People

              Assignee:
              jennifer.leugers Jennifer Leugers
              Reporter:
              jennifer.leugers Jennifer Leugers
              Developer:
              Suraj Sokasane (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: