Uploaded image for project: 'OpenAM'
  1. OpenAM
  2. OPENAM-14271

sunserviceID index is not created and it needs to be indexed

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 14.0.0, 6.0.0.6
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Sprint:
      AM Sustaining Sprint 63, AM Sustaining Sprint 64, AM Sustaining Sprint 65, AM Sustaining Sprint 66, AM Sustaining Sprint 67, AM Sustaining Sprint 68
    • Story Points:
      5
    • Needs backport:
      No
    • Support Ticket IDs:
    • Needs QA verification:
      No
    • Functional tests:
      No
    • Are the reproduction steps defined?:
      Yes and I used the same an in the description

      Description

      Bug description

      In some of scenarios below and under the right conditions, the following exceptions were encountered with sunserviceID during

      1. AM 5.0.0 Amster export

      [06/Sep/2017:09:55:40 +0800] SEARCH REQ conn=7 op=123 msgID=124 base="ou=default,ou=OrganizationConfig,ou=1.0,ou=sunFMSAML2MetadataService,ou=services,dc=openam,dc=forgerock,dc=org" scope=one filter="(&(&(objectclass=top)(ou=*))(&(objectclass=top)(sunserviceID=EntityDescriptor)))" attrs="o"
       [06/Sep/2017:09:55:40 +0800]
      SEARCH RES conn=7 op=123 msgID=124 result=12 message="The search results cannot be sorted because the given search request is not indexed" nentries=0 unindexed etime=16
      

       

      2. AM 6.0.0.0.x upgrades

      [17/Jan/2019:12:51:37 +1300] SEARCH REQ conn=1968337 op=5411 msgID=5412 base="ou=default,ou=OrganizationConfig,ou=1.0,ou=AgentService,ou=services,o=xxxx,ou=services,dc=openam,dc=xxx,dc=xxx,dc=xx" scope=one filter="(&(&(objectclass=top)(ou=*))(&(objectclass=top)(sunserviceID=WebAgent)))" attrs="o"
      [17/Jan/2019:12:51:37 +1300] SEARCH RES conn=1968337 op=5411 msgID=5412 result=12 message="The search results cannot be sorted because the given search request is not indexed" nentries=0 unindexed etime=123
      

       
      It is apparent that sunserviceID is used in AM's code but oddly this sunServiceID index is missing and it needs to be created.

      A possible workaround

       

      # create a index for sunserviceID
      dsconfig \
       create-backend-index \
       --hostname localhost \
       --port 24444 \
       --bindDN "cn=Directory Manager" \
       --bindPassword password \
       --backend-name userRoot \
       --index-name sunserviceID \
       --set index-type:equality \
       --trustAll \
       --no-prompt
      
      # increase the search limit to be 10000 <=== you may need to increase this higher 
      dsconfig \
       set-backend-index-prop \
       --hostname localhost \
       --port 24444 \
       --bindDN "cn=Directory Manager" \
       --bindPassword password \
       --backend-name userRoot \
       --index-name sunserviceID \
       --set index-entry-limit:10000 \
       --no-prompt \
       --trustAll
      
      # rebuild index 
      rebuild-index \
       --hostname localhost \
       --port 24444 \
       --bindDN "cn=Directory Manager" \
       --bindPassword password \
       --baseDN dc=openam,dc=forgerock,dc=org \
       --index sunserviceID \
       --start 0 \
       --trustAll
      

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                sachiko Sachiko Wallace
                Reporter:
                sam.phua Sam Phua
              • Votes:
                0 Vote for this issue
                Watchers:
                13 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: