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)