Unable to find profile with over 50 identities | Community
Skip to main content
mbr4n
mbr4n
Level 2
October 25, 2022
Solved

Unable to find profile with over 50 identities

  • October 25, 2022
  • 3 replies
  • 3097 views

Is there a solution for accessing profiles with over 50 identities? 

 

My own profile was visible in AEP but I am now running into the "There was a problem displaying the profiles. This profile has more than 50 identities and cannot be displayed." message. After running a query, I have over 95 different ECIDs attached. 

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Danny-Miller

    You can use the Identity Graph viewer to see identities for a Profile that have more than 50 and less than 150 identities.

    Once the Profile exceeds 50 identities the Profiles Service begins to ignore them.

    If you would like to know which identities across the board fall into this you can run a query (replace the profile_snapshot_export_xxxx dataset with the one for your sandbox)

     

    -- count number of identities for a profile across rows (assume the first identity is the link across rows)

    select one_NS, one_ID, count(distinct id_count.id) 
from (
	select explode(IDS) as id_count, One_NS, One_ID[0].id as one_ID
	from (
		select 
		explode(map_values(identityMap)) as IDS, (map_values(identityMap))[0] as One_ID, (map_keys(identityMap))[0] as One_NS
		from profile_snapshot_export_xxxx
	)
)
group by one_NS, one_ID
having count(distinct id_count.id) > 90
order by 3 desc
Limit 10

    Output:

     

    one_NS

    one_ID

    count(DISTINCT id_count)

    1

    ecid

    xxx

    136

    2

    ecid

    yyy

    97

    3

    ecid

    zzz

    97

     

    At some point soon, the limit for the identity graph will be reduced to 50 as well and the above query will no longer work.

     

    3 replies

    Anil_Umachigi
    Adobe Employee
    Anil_UmachigiAdobe Employee
    Adobe Employee
    October 26, 2022

    @mbr4n 50 is the hard limit for Identity count for individual profile Identity Graph,  profile with >50 identities are excluded from segmentation, exports, and lookups. 

    Reference doc here

     

    If you don't mind expanding on what is your use case for looking up profile with 50+ ECID attached?

     

     

      mbr4n
      mbr4nAuthor
      Level 2
      October 26, 2022

      @anil_umachigi Thank you for the reply! We are in the early stages of offer decisioning executions but are unable to qualify for experiences as employees for those of us that have over 50 ECIDs attached. Employees are also part of our consumer base. Additionally, I was previously using my own profile as a demonstration of how AEP - segmentation and offer decisioning - work.

       

      Has there been any workaround to the 50 hard limit?

      Anuhya-Y
      Community Advisor
      Anuhya-YCommunity Advisor
      Community Advisor
      October 28, 2022

      @mbr4n 

      Profile system jobs endpoint (Delete requests) workaround you can use to clean up your own profile by deleting a dataset or batch from the Profile store to remove data that is no longer needed or was added in error.. This is not a suggested workaround in production scenario with real customer data.

       

      Check out https://experienceleague.adobe.com/docs/experience-platform/profile/api/profile-system-jobs.html?lang=en

        M
        mdonke
        Level 4
        October 26, 2022

        Please also read the older thread https://experienceleaguecommunities.adobe.com/t5/adobe-experience-platform/profile-merging-on-ecid-what-about-sharing-devices/td-p/546248

          Danny-Miller
          Adobe Employee
          Danny-MillerAdobe EmployeeAccepted solution
          Adobe Employee
          October 28, 2022

          You can use the Identity Graph viewer to see identities for a Profile that have more than 50 and less than 150 identities.

          Once the Profile exceeds 50 identities the Profiles Service begins to ignore them.

          If you would like to know which identities across the board fall into this you can run a query (replace the profile_snapshot_export_xxxx dataset with the one for your sandbox)

           

          -- count number of identities for a profile across rows (assume the first identity is the link across rows)

          select one_NS, one_ID, count(distinct id_count.id) 
from (
	select explode(IDS) as id_count, One_NS, One_ID[0].id as one_ID
	from (
		select 
		explode(map_values(identityMap)) as IDS, (map_values(identityMap))[0] as One_ID, (map_keys(identityMap))[0] as One_NS
		from profile_snapshot_export_xxxx
	)
)
group by one_NS, one_ID
having count(distinct id_count.id) > 90
order by 3 desc
Limit 10

          Output:

           

          one_NS

          one_ID

          count(DISTINCT id_count)

          1

          ecid

          xxx

          136

          2

          ecid

          yyy

          97

          3

          ecid

          zzz

          97

           

          At some point soon, the limit for the identity graph will be reduced to 50 as well and the above query will no longer work.

           

            mbr4n
            mbr4nAuthor
            Level 2
            October 31, 2022

            @danny-miller Thanks for the reply - super helpful! Is there a query that we can run to detect how many profiles inside of Platform have more than 50 identities attached? 

              W
              wesleybrett1
              Level 2
              April 21, 2023

              @mbr4n Did you manage to find a solution for this?  

              Terms & ConditionsAccessibility statement

              Loading footer...