Users with duplicated Phonenumbers are not getting rejected on the platform

Description

PRDE - Bug default text according to the team DoR (Definition of Ready)

01 - PERSON OF CONTACT (PERSON THAT CAN ANSWER QUESTIONS ABOUT THE PROBLEM):

@Douglas Coimbra Lopes
02 - PROBLEM (WHAT'S THE ISSUE?):

  • We’ve got a user A processed with a phone number 19039205956
  • After this, we sent via intake a user B with the same phone number and we reprocessed the SQL task
  • User B was correctly not registered on the platform
  • However, the user with the duplicated phone number was not rejected on the platform

03 - STEPS TO REPRODUCE (STEP (1...N), VIDEO, SCREENSHOTS, LOGS FOLDER, HEARTBEAT, ETC. – IF IS NOT POSSIBLE TO REPRODUCE EXPLAIN THE REASON):

  • Create the staging table (snapshot provided)
  • Create the DM (snapshot provided)
  • RUN the SQL Processing task using the pipeline
  • Send a user as below with phone number
  • [
      {
        "login": "businesssoap@totvslabs.com",
        "alwaysFalse": true,
        "alwaysTrue": true,
        "isactive": true,
        "shouldcreateuser": true,
        "id": "1234",
        "gender": "M",
        "phonenumber": "+19039202997",
        "roles": "businessUser",
        "password": "Carol3.0!",
        "name": "New User Biz Dev",
        "country": "SOAP UI"
      },
      {
        "login": "adminusersoap@totvslabs.com",
        "alwaysFalse": true,
        "alwaysTrue": true,
        "isactive": true,
        "shouldcreateuser": true,
        "id": "1234",
        "gender": "M",
        "phonenumber": "+19039205956",
        "roles": "tenantAdmin",
        "password": "Carol3.0!",
        "name": "TenantAdmin SOAP",
        "country": " TA SOAP UI"
      }
    ]
  • Run the Pipeline as an example: https://github.com/douglascoimbra/test-sample-pipeline/blob/main/newuser.csql (newuserpipeline.json)
  • Send a second intake with a user with the same email but the same phone number
  • Reprocess the SQL Task
  • Check if the user was rejected on for both layers (RT & BQ)
    04 - LINKS (ADD A LINK TO THE BUG OR TO THE TENANT):
    05 - EXPECTED BEHAVIOR (LIST THE EXPECTED BEHAVIORS TO CONSIDER THIS BUG AS DONE):
  • User with duplicated phone number should be rejected on the Explore + Not being registered on Carol (Already covered)