nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Execution of Livereports fails for users; works for Admins

Jay_Harbeston

We have some livereports that when executed by an Admin will take just a few seconds. If a normal user executes them, the session will return a CGI Timeout. I am assuming there is a permission to set somewhere, but don't know where it is. The query is only running in one folder whcih the user has been able to navigate to. A couple months ago, this was working fine. Help!

Find more posts tagged with

Comments

Tim_Hunter

what is the code in the livereport? anything that is user specific?

Appu_Nair

Maybe the user is part of a group that is going round and round ,that pointed to recursive problems in enumerating permissions.So I would check if this user is part of a group that is not resolvable by livelink.OT support will send you a function that when executed will try to tell you whether or not there are recursive groups within livelink.I would think that when Admin is the user permission's checks are bypassed.Or take out the "filter permisssons" mask in your livereport and see if it speeds up.Just some suggestions or maybe the folder has too many children it is trying to paint

Joe_Vicioni

Message from Joe Vocioni <Joe.Vocioni@gov.ab.ca> via eLink

eLink

We have the same issue here. We canactually execute the same report with several different users. However, withother users, we get a CGI timeout or no results returned (when results do exist).

Our reports do not contain anythingspecific to users or permission sets. By changing a users permission to SystemAdmin seems to correct the issue – but that isn’t a viablesolution.

I know that wasn’t much help –but you’re not alone.

From: eLinkDiscussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, April 25, 2008 2:17PM
To: eLink Recipient
Subject: Execution of Livereportsfails for users; works for Admins

Execution of Livereports fails for users; works for Admins

Posted by gdatsadmin (Higgins, Michael R) on 04/25/2008 02:05 PM

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.

Joe_Vicioni

Message from Joe Vocioni <Joe.Vocioni@gov.ab.ca> via eLink

eLink

Well, I look forward to seeing thisfunction. I opened a ticket this morning with them – I figured 2 monthsof me banging my head on the wall was enough. As for the filter permission andthings of that nature, I have none. Too many children, the query is returningfrom one volume so I can’t see that being an issue.

From: eLinkDiscussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, April 25, 2008 2:30PM
To: eLink Recipient
Subject: Maybe the user is part ofa group that is going round and round ,that pointed...

Maybe the user is part of a group that is going round and round ,that pointed...		Posted by anair@alitek.com (Nair, Appu) on 04/25/2008 04:28 PM
In reply to: what is the code in the livereport? anything that is user specific?		Posted by timothy.hunter.ctr@wpafb.af.mil (Hunter, Tim ) on 04/25/2008 02:49 PM

Maybe the user is part of a group that is going round and round ,that pointed to recursive problems in enumerating permissions.So I would check if this user is part of a group that is not resolvable by livelink.OT support will send you a function that when executed will try to tell you whether or not there are recursive groups within livelink.I would think that when Admin is the user permission's checks are bypassed.Or take out the "filter permisssons" mask in your livereport and see if it speeds up.
Just some suggestions or maybe the folder has too many children it is trying to paint

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

It would be interesting to see what the Livelink connect logs have to say for the LiveReport run request when executed by the user versus when executed by Admin or Sys Admin. Perhaps it can be remedied by tuning the database. Are you using Oracle or SQL Server, and what version of the database is being used?

- Bhupinder----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Senior Systems Analyst, Information Technology
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, April 25, 2008 4:41 PM
To: eLink Recipient
Subject: RE Maybe the user is part of a group that is going round and round ,that pointed...

RE Maybe the user is part of a group that is going round and round ,that pointed...		Posted by joe.vocioni@gov.ab.ca (Vocioni, Joe) on 04/25/2008 04:40 PM
In reply to: Maybe the user is part of a group that is going round and round ,that pointed...		Posted by anair@alitek.com (Nair, Appu) on 04/25/2008 04:28 PM

Message from Joe Vocioni <Joe.Vocioni@gov.ab.ca> via eLink Well, I look forward to seeing this function. I opened a ticket this morning with them – I figured 2 months of me banging my head on the wall was enough. As for the filter permission and things of that nature, I have none. Too many children, the query is returning from one volume so I can’t see that being an issue. From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Friday, April 25, 2008 2:30 PM To: eLink Recipient Subject: Maybe the user is part of a group that is going round and round ,that pointed... Maybe the user is part of a group that is going round and round ,that pointed...		Posted by anair@alitek.com (Nair, Appu) on 04/25/2008 04:28 PM
In reply to: what is the code in the livereport? anything that is user specific?		Posted by timothy.hunter.ctr@wpafb.af.mil (Hunter, Tim ) on 04/25/2008 02:49 PM

Maybe the user is part of a group that is going round and round ,that pointed to recursive problems in enumerating permissions.So I would check if this user is part of a group that is not resolvable by livelink.OT support will send you a function that when executed will try to tell you whether or not there are recursive groups within livelink.I would think that when Admin is the user permission's checks are bypassed.Or take out the "filter permisssons" mask in your livereport and see if it speeds up.
Just some suggestions or maybe the folder has too many children it is trying to paint

Joe_Vicioni

Message from Joe Vocioni <Joe.Vocioni@gov.ab.ca> via eLink

eLink

It seems that I may have hijacked thisthread and that was not my intention (forgive me Tim).

Our particular db is Oracle. Bhupinder,not sure if you’re able to see the tickets that came in today. But if you’reinterested in troubleshooting this with me perhaps you’d be interested intaking the case.?.

From: eLinkDiscussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, April 25, 2008 2:52PM
To: eLink Recipient
Subject: RE RE Maybe the user ispart of a group that is going round and round ,that pointed...

RE RE Maybe the user is part of a group that is going round and round ,that pointed...		Posted by bsingh (Singh, Bhupinder) on 04/25/2008 04:51 PM
In reply to: RE Maybe the user is part of a group that is going round and round ,that pointed...		Posted by joe.vocioni@gov.ab.ca (Vocioni, Joe) on 04/25/2008 04:40 PM

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

- Bhupinder

----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Senior Systems Analyst, Information Technology
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

RE Maybe the user is part of a group that is going round and round ,that pointed...		Posted by joe.vocioni@gov.ab.ca (Vocioni, Joe) on 04/25/2008 04:40 PM
In reply to: Maybe the user is part of a group that is going round and round ,that pointed...		Posted by anair@alitek.com (Nair, Appu) on 04/25/2008 04:28 PM

Message from Joe Vocioni <Joe.Vocioni@gov.ab.ca> via eLink

Well, I look forward to seeing this function. I opened a ticket this morning with them – I figured 2 months of me banging my head on the wall was enough. As for the filter permission and things of that nature, I have none. Too many children, the query is returning from one volume so I can’t see that being an issue.

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, April 25, 2008 2:30 PM
To: eLink Recipient
Subject: Maybe the user is part of a group that is going round and round ,that pointed...

Maybe the user is part of a group that is going round and round ,that pointed...		Posted by anair@alitek.com (Nair, Appu) on 04/25/2008 04:28 PM
In reply to: what is the code in the livereport? anything that is user specific?		Posted by timothy.hunter.ctr@wpafb.af.mil (Hunter, Tim ) on 04/25/2008 02:49 PM

Maybe the user is part of a group that is going round and round ,that pointed to recursive problems in enumerating permissions.So I would check if this user is part of a group that is not resolvable by livelink.OT support will send you a function that when executed will try to tell you whether or not there are recursive groups within livelink.I would think that when Admin is the user permission's checks are bypassed.Or take out the "filter permisssons" mask in your livereport and see if it speeds up.
Just some suggestions or maybe the folder has too many children it is trying to paint

<HR< p>

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Unfortunately, I can't take the case if you are referring to a support ticket you opened, as I am no longer with Customer Support. I moved to a new role in Open Text in the I.T. department last month.

I can, however, help via discussion postings. Our Oracle DBA, John Postma, has created a document called "Best Practices_ Oracle for Livelink ECM - Enterprise Server" located here:https://knowledge.opentext.com/go/8163428

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, April 25, 2008 5:02 PM
To: eLink Recipient
Subject: RE RE RE Maybe the user is part of a group that is going round and round ,that pointed...

RE RE RE Maybe the user is part of a group that is going round and round ,that pointed...		Posted by joe.vocioni@gov.ab.ca (Vocioni, Joe) on 04/25/2008 05:01 PM
In reply to: RE RE Maybe the user is part of a group that is going round and round ,that pointed...		Posted by bsingh (Singh, Bhupinder) on 04/25/2008 04:51 PM

Message from Joe Vocioni <Joe.Vocioni@gov.ab.ca> via eLink It seems that I may have hijacked this thread and that was not my intention (forgive me Tim). Our particular db is Oracle. Bhupinder, not sure if you’re able to see the tickets that came in today. But if you’re interested in troubleshooting this with me perhaps you’d be interested in taking the case.?. From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Friday, April 25, 2008 2:52 PM To: eLink Recipient Subject: RE RE Maybe the user is part of a group that is going round and round ,that pointed... RE RE Maybe the user is part of a group that is going round and round ,that pointed...		Posted by bsingh (Singh, Bhupinder) on 04/25/2008 04:51 PM
In reply to: RE Maybe the user is part of a group that is going round and round ,that pointed...		Posted by joe.vocioni@gov.ab.ca (Vocioni, Joe) on 04/25/2008 04:40 PM

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

- Bhupinder

RE Maybe the user is part of a group that is going round and round ,that pointed...		Posted by joe.vocioni@gov.ab.ca (Vocioni, Joe) on 04/25/2008 04:40 PM
In reply to: Maybe the user is part of a group that is going round and round ,that pointed...		Posted by anair@alitek.com (Nair, Appu) on 04/25/2008 04:28 PM

Message from Joe Vocioni <Joe.Vocioni@gov.ab.ca> via eLink

Well, I look forward to seeing this function. I opened a ticket this morning with them – I figured 2 months of me banging my head on the wall was enough. As for the filter permission and things of that nature, I have none. Too many children, the query is returning from one volume so I can’t see that being an issue.

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, April 25, 2008 2:30 PM
To: eLink Recipient
Subject: Maybe the user is part of a group that is going round and round ,that pointed...

Maybe the user is part of a group that is going round and round ,that pointed...		Posted by anair@alitek.com (Nair, Appu) on 04/25/2008 04:28 PM
In reply to: what is the code in the livereport? anything that is user specific?		Posted by timothy.hunter.ctr@wpafb.af.mil (Hunter, Tim ) on 04/25/2008 02:49 PM

Maybe the user is part of a group that is going round and round ,that pointed to recursive problems in enumerating permissions.So I would check if this user is part of a group that is not resolvable by livelink.OT support will send you a function that when executed will try to tell you whether or not there are recursive groups within livelink.I would think that when Admin is the user permission's checks are bypassed.Or take out the "filter permisssons" mask in your livereport and see if it speeds up.
Just some suggestions or maybe the folder has too many children it is trying to paint

<HR< p>

Appu_Nair

see this articlehttps://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=12588367&objAction=ArticleView&viewType=1in that you are supposed to run this sqlselect lpad(' ', 2 * (a.l - 1)) || kuaf.name || lpad('*', kuaf.type), kuaf.id from kuaf, ( select childid, level l from kuafchildren start with id in (select kuaf.id from kuaf where lower(name) = 'atsclients') connect by ID = PRIOR ChildID ) a where kuaf.id = a.childid and kuaf.type <= 1"I think when it finds the bad group the connect by will give up.That is probably how my good friend John Simon,showed me at COP with a DBMS output command.We ceratinly had one user who could just not logon to livelink and we saw connect by errors when we put logs.I am not a SQL expert so I really don't know how to debug this situation.If you have an oracle expert in house or if you can get the script from OT I am talking about(the script itself is troublesome on large livelink user installs) you may be able to find things.I beleive the problem is the way livelink is trying to reconcile the user's groups and the object's acl.I just thought being a weekend if you wanted to work something on your own.

Jay_Harbeston

After gleaning the information here, we are looking at the possibilities that we have a 'nesting problem' in the definition of the groups. There are multiple groups involved in the permissions of the folders/documents involved.The query itself is not looking for permissions specifically; rather, it is a rehashed listing of the folders/documents to get additional information from categories, etc.Thank you all for giving me some guidance with this problem!