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
            jennifer.leugers Jennifer Leugers created issue -
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Field Original Value New Value
            Assignee Vijay Siddha [ vijays ] Vishal Bajad [ vishal.bajad ]
            Status Open [ 1 ] In Progress [ 3 ]
            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
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Assignee Vishal Bajad [ vishal.bajad ] Jaideep Vinchurkar [ jaideep.vinchurkar ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Status In Progress [ 3 ] Open [ 1 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Suraj Sokasane [ suraj.sokasane ]
            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.
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] Jennifer Leugers [ jennifer.leugers ]
            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
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Vikas Pawar [ vikas.pawar ]
            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.
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Vikas Pawar [ vikas.pawar ] Suraj Sokasane [ suraj.sokasane ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Issue Type Support Activity [ 10301 ] Bug [ 1 ]
            Support Task Type Query Resolution [ 11205 ]
            Workflow WT_Support [ 25017 ] WT_Defects [ 25252 ]
            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.
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] Rashmita Dudhe [ rashmita.dudhe ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            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.
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            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.

                          		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.

             
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            rakeshr Rakesh Roy (Inactive) made changes -
            Developer Jaideep Vinchurkar [ jaideep.vinchurkar ]
            ashwin.wankhede Ashwin Wankhede (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)
            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
            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: Re-open(10216)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Assignee Rashmita Dudhe [ rashmita.dudhe ] Jaideep Vinchurkar [ jaideep.vinchurkar ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Resolution Unresolved [ 10200 ]
            Status Stage Testing [ 10201 ] Reopen in Stage [ 10023 ]
            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.
            vijayendra Vijayendra Shinde (Inactive) made changes -
            Link This issue causes WT-5525 [ WT-5525 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Code Reviewed By Jaideep Vinchurkar [ 11908 ]
            Developer Jaideep Vinchurkar [ jaideep.vinchurkar ] Suraj Sokasane [ suraj.sokasane ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Rashmita Dudhe [ rashmita.dudhe ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Status Reopen in Stage [ 10023 ] In Development [ 10007 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Re-open(10216) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            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.
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Resolution Unresolved [ 10200 ] Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            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
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Assignee Rashmita Dudhe [ rashmita.dudhe ] Jennifer Leugers [ jennifer.leugers ]
            satyap Satya made changes -
            Environment_New Stage [ 18443 ]
            Transition Time In Source Status Execution Times
            Vishal Bajad (Inactive) made transition -
            Open In Progress
            		57m 32s 1
            Vishal Bajad (Inactive) made transition -
            In Progress Open
            		1h 32m 1
            Rakesh Roy (Inactive) made transition -
            Open In Development
            		7d 11h 18m 1
            Rashmita Dudhe (Inactive) made transition -
            Stage Testing Reopened in Stage
            		3s 1
            Jaideep Vinchurkar (Inactive) made transition -
            Reopened in Stage In Development
            		17h 47m 1
            Jaideep Vinchurkar (Inactive) made transition -
            In Development In LB Testing
            		7s 2
            Jaideep Vinchurkar (Inactive) made transition -
            In LB Testing Stage Testing
            		3d 1h 31m 2
            Rashmita Dudhe (Inactive) made transition -
            Stage Testing In Production Testing
            		2h 56m 1
            Rashmita Dudhe (Inactive) made transition -
            In Production Testing Production Complete
            		24s 1

              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: