Searching Static Hosts Takes A Long Time (Doc ID 957864.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Communications Policy Services - Version: 6.1.1
Information in this document applies to any platform.

Symptoms

-- Problem Statement:
When searching for 25 static hosts the application takes about 7 minutes to return the results.

The following queries are being run.

[02/Dec/2008:03:47:21 -0600] conn=552 op=11 msgId=12 - SRCH base="ou=ipv4 addresses,ou=address
management,ou=ip services,o=woolworths,o=telstra.com" scope=2
filter="(&(mslvAddressAllocationStatus=Static)(objectClass=mslvipv4managedstaticaddress)(objectClass
=mslvipv4managedaddress))" attrs="* aci modifiersName modifyTimestamp creatorsName createTimestamp
numSubordinates"
[02/Dec/2008:03:50:53 -0600] conn=552 op=11 msgId=12 - RESULT err=4 tag=101 nentries=1 etime=212
notes=U
[02/Dec/2008:03:50:53 -0600] conn=552 op=12 msgId=13 - SRCH base="o=telstra.com" scope=1
filter="(&(&(objectClass=organization)(o=Woolworths))(|(businessCategory=presideCustomer)(businessCa
tegory=PresideServiceProvider)))" attrs="* aci modifiersName modifyTimestamp creatorsName
createTimestamp numSubordinates"
[02/Dec/2008:03:50:53 -0600] conn=552 op=12 msgId=13 - RESULT err=0 tag=101 nentries=1 etime=0
[02/Dec/2008:03:50:53 -0600] conn=552 op=13 msgId=14 - SRCH base="ou=ipv4 addresses,ou=address
management,ou=ip services,o=woolworths,o=telstra.com" scope=2
filter="(&(objectClass=mslvipv4managedstaticaddress)(objectClass=mslvipv4managedaddress)(objectClass
=mslvdhcpstatichost)(mslvAddressAllocationStatus=Static))" attrs="* aci modifiersName
modifyTimestamp creatorsName createTimestamp numSubordinates"
[02/Dec/2008:03:54:29 -0600] conn=552 op=13 msgId=14 - RESULT err=4 tag=101 nentries=25 etime=216
notes=U



The first query is only returning 1 result and taking 212 seconds and returning an error 4.

-- Steps To Reproduce:
login to the application and go to the Name/Address. Select "IP Addresses".

Select "Static Host" as the Object Type and enter the customer name with a large data set.

-- Business Impact:
Slow searches impacts user experience

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms