Lieutenant Commander
Lieutenant Commander
394 views

Query Results taking long time


Hi,

We have developed a workflow "Search DL" where the user has the
provision to search a DL with a minimum of 4 characters. If there are
multiple DLs the users are displayed with the complete list in forma
drop-down. The input characters are taken and LDAP search (contains) is
performed under the container where the DLs reside. When a user search
in chrome (Version 56.0.2924.87 (64-bit)) and IE (IE 11) it breaks and
displayed with error "Chrome - Page is unresponsive" and "IE-not
responding due to a long running script" But when the same functionality
is performed in Microsoft Edge and Firefox (47.0.2) everything looks
good with out issues.


--
pappa_recd
------------------------------------------------------------------------
pappa_recd's Profile: https://forums.netiq.com/member.php?userid=10809
View this thread: https://forums.netiq.com/showthread.php?t=57388

Labels (1)
0 Likes
5 Replies
Absent Member.
Absent Member.


Hi,

it looks like something is wrong with your query. There are maybe too
many Objects to display from the query.

To track the issue down, i would suggest you to start iMonitor and
acitvate LDAP in the ds trace options. Check the results of the query.
How does the query statement look like and what are the results?

Also some more information about your IDM version and your workflow
would be helpful.

what is the control type of your form field and what are the properties
you have set?


--
Regards

Zisis
------------------------------------------------------------------------
charakopidis's Profile: https://forums.netiq.com/member.php?userid=829
View this thread: https://forums.netiq.com/showthread.php?t=57388

0 Likes
Lieutenant Commander
Lieutenant Commander


Hi,

Below is our tree structure,

All the DLs are staggered under the container ou=groups,o=****. There is
a Form Field with the name SearchDL and it is using the custom query DL
which is bind with the entity DL and the query condition is with
displayName contains %PARAM%. Search Root being OU=Groups,O=**** and
Search Scope being set to Containers and sub containers. Again the
entity has a filter where custom attribute = DL.

IDM version: 4.5 and workflow version: 4.5.3

form field is Picklist and form.setValues() is used.

After running the DStrace I am seeing some errors like

10:25:20 Base "cn=DL CORP ES&\;E G.China ,ou=Global,ou=Groups,o=*****"
not found, err = no such entry (-601)
10:25:20 nds_back_search: Search Control OID 2.16.840.1.113730.3.4.2

The strangest part is why the query is fetching results in Firefox and
Edge instantly without any issues. Do we have some Javascript issues ?


--
pappa_recd
------------------------------------------------------------------------
pappa_recd's Profile: https://forums.netiq.com/member.php?userid=10809
View this thread: https://forums.netiq.com/showthread.php?t=57388

0 Likes
Absent Member.
Absent Member.


to check for javascript error, start the debugging tools (F12) and look
at the console log for any errors.

I would also check the http POST request, to analyse the response of the
query. Under the network tab, there should be requests that look like
http://<ip>:<port>/IDMProv/UIQuery?service=query&uasess=-5841269718455137477.
This will give you information about the size of the query result. Is it
empty or maybe to big, to be displayd?

From the DStrace it would also be interesting to see the ldap query.

Also check for the fixed bugs in 4.4.4 and 4.4.5 is related to your
problem: http://tinyurl.com/htub8vp


--
Regards

Zisis
------------------------------------------------------------------------
charakopidis's Profile: https://forums.netiq.com/member.php?userid=829
View this thread: https://forums.netiq.com/showthread.php?t=57388

0 Likes
Lieutenant Commander
Lieutenant Commander


Root Cause
We wrote a custom code to meet the one of the custom requirement. The
requirement was show to show Hover text for DLs whose display name
doesn't fit the window. Below is the custom code. This code was
interrupting and the search was getting interrupted. On disabling the
code the search result was pretty fast..

Now can someone help me on how to hover text for a value which is very
big to display.

Snippet of the custom code

if(getBrowser()=="Chrome"){
var total = $('#_mailboxNameList option').length;
var cur;
for (var i = 0; i < total; i++) {
cur = $('#_mailboxNameList option:eq(' + i + ')');
var str=cur.html();
var display = globalVars.IDVault.get(null, str, "hwDL",
"displayName");
//str=str.substr(3,str.indexOf(',')-3);
//cur.attr('title', str);
cur.attr('title', display);
}

$('#_mailboxNameList').mouseover(function () {
$(this).attr('title',
$(this).find("option:selected").text());
});
}


--
pappa_recd
------------------------------------------------------------------------
pappa_recd's Profile: https://forums.netiq.com/member.php?userid=10809
View this thread: https://forums.netiq.com/showthread.php?t=57388

0 Likes
Absent Member.
Absent Member.


Setting a title to display all the text in a tooltip ist not a bad idea.


i would suggest you to debug the code. set this statement on top of the
f(getBrowser()=="Chrome"){ line:


Code:
--------------------
eval('debugger;')
--------------------


Start the Developing Tools (F12) before loading the form and check the
result of each statement.

Is the result of var str=cur.html(); a ldap dn?

What error messages do you receive?


This code is unnecessary:

$('#_mailboxNameList').mouseover(function () {
$(this).attr('title', $(this).find("option:selected").text());
});
}


--
Regards

Zisis
------------------------------------------------------------------------
charakopidis's Profile: https://forums.netiq.com/member.php?userid=829
View this thread: https://forums.netiq.com/showthread.php?t=57388

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.