25 Largest Documents Report Times Out

Krishna_Ravula_(bfgooduser2_-_(deleted))

I am unable to run the 25 Largest Documents Report that is part of core product. We are running Livelink Version 9.2.0.1.176 (Oracle database).When I run the report it times out and will not display the results.Does anyone have an alternate report they run or experienced this same problem? Thanks.

Find more posts tagged with

Comments

Krishna_Ravula_(bfgooduser2_-_(deleted))

select DTree.*, DVersData.MimeType, DVersData.DataSize from DTree, DVersData where %1 and DTree.DataID=DVersData.DocID and %2 order by DVersData.DataSize descThis is the query I have for running the report for the 25 largest documents. Is this correct? Does anyone have something different?

Steve_McDonough

Hello Krishna,I'm not sure why the query times out. The SQL statement is the packaged LiveReport query. You might want to check whether the record limit is set to 25. I use a similar query that reflects the document size in megabytes and adds the creator name to the results. I'm running MS SQL. Here is the SQL:select DTree.*, DVersData.MimeType, (DVersData.DataSize/1048576) "DataSize", Kuaf.LastName from DTree, DVersData, Kuaf where %1 and DTree.DataID=DVersData.DocID and %2 and DTree.UserID = Kuaf.ID order by DVersData.DataSize desc%1 = Filter Documents%2 = Filter PermissionsAdditional Display Columns:DataSize Size(MegaBytes)LastName OwnerCreateDate Date Created.I've attached a .rpt file that you can import if you are interested in trying it on your system.LeonLivelink Admin - RCG Information Technology, Inc.

John_Mills

Our LiveReport was taking a long time to run, so I've made a very simple amendment to the SQL to improve it:

select DTree.*, DVersData.MimeType, DVersData.DataSize from DTree with (Nolock), DVersData with (Nolock) where %1 and DTree.DataID=DVersData.DocID and %2 and DVersData.DataSize > 1000000 order by DVersData.DataSize desc

This means that it ignores the millions of documents that are smaller than about 1MB.