Biggest Folders in Livelink

Hello,I need a live report (oracle) which shows me the folders with most of data in it, which means show me the biggest Folders in Livelink.The report should show me the MBs of the folders.How would you do this?Thanks for your help.Peter

Find more posts tagged with

Comments

Bhupinder_Singh

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

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

I was able to locate one (Oracle-specific) possible starting point for a solution here:

https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=3680068&objAction=view&show=2

- Bhupinder

------------------------------------------------------
Bhupinder Singh, B.Math., B.Ed.
Senior Product Specialist, Customer Support
Open Text Corporation, Waterloo, Ontario, Canada
Customer support e-mail: support@opentext.com
Customer Support Telephone: 800-540-7292
------------------------------------------------------

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, December 15, 2006 7:44 AM
To: eLink Recipient
Subject: Biggest Folders in Livelink

Biggest Folders in Livelink

Posted by parens (Arens, Peter) on 12/15/2006 07:42 AM

Hello,

I need a live report (oracle) which shows me the folders with most of data in it, which means show me the biggest Folders in Livelink.
The report should show me the MBs of the folders.

How would you do this?

Thanks for your help.

Peter

Peter_Arens_(parens_-_(deleted))

Hello,thanks for your help, but that is not what I meant. I need a report which nearly works like the report 25 largest documents, only that this report should show me the 25 biggest folders in the whole system or in any subfolder.Thanks for your help.Peter

Steve_McDonough

Hello Peter,Try this report. We run MS SQL here, but I think that the query should work in Oracle as well.Title: Top 25 Folders Having the Most DocumentsRecord Limit: 25SQL: Select * from DTree Where SubType in (0,202) Order by ChildCount Desc(202 is the subtype for Project - you can remove or replace it if you don't need it.)Report Format: LiveReport:Display Columns: Field: Column Title: ChildCount Count DataID Folder ID ParentID Parent Folder ModifyDate DateYou may want to import the attachment and dress it up in your system. We are running 9.5 SP1 on Windows 2000.I hope that it helps.Leon

Jim_Coursey

Message from Coursey, Jim <jim.coursey@ngc.com> via eLink

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

If a "child" folder qualifies for one of the largest 25, wouldn't its parent, grandparent, etc., folders also qualify?

Jim
Phone: 321-726-7422
An amateur practices until she gets it right. A professional practices until she can't get it wrong - Monday Night Football

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Monday, December 18, 2006 10:21 AM
To: eLink Recipient
Subject: RE Nearly

RE Nearly		Posted by rcgtec01user1 (Kish, Leon S) on 12/18/2006 10:20 AM
In reply to: Nearly		Posted by parens (Arens, Peter) on 12/18/2006 08:45 AM

Hello Peter,

Try this report. We run MS SQL here, but I think that the query should work in Oracle as well.

Title: Top 25 Folders Having the Most Documents

Record Limit: 25

SQL: Select * from DTree Where SubType in (0,202) Order by ChildCount Desc

(202 is the subtype for Project - you can remove or replace it if you don't need it.)

Report Format: LiveReport:

Display Columns: Field: Column Title:
ChildCount Count
DataID Folder ID
ParentID Parent Folder
ModifyDate Date

You may want to import the attachment and dress it up in your system. We are running 9.5 SP1 on Windows 2000.

I hope that it helps.

Leon

Steve_McDonough

It would make sense. By default each 'child' folder would have the Enterprise folder as some ancestorial folder. Depending on the depth of the 'child' folder, the magic number 25 would be achieved quickly and might have to be adjusted to give Peter an idea of his 25 most populated folders.Leon

Peter_Arens_(parens_-_(deleted))

Hello,this is an interesting report, but not what we need. We don't need a report which shows us the folders with the most documents, we need a report which shows us the biggest folders in bytes or mega bytes. Where is the most data in.Does anyone have an idea how to do that?Peter

Glenn_Joseph_Heying_(gheying@opentext.com_(Delete)

Try the following SQL. It rolls up the content for any container in any workspace. Add a filter for c.subtype to filter the container type and c.ownerid to filter the workspace for your specific needs.select round(sum(b.datasize)/1024,3)"Data Size (in K bytes) ",count(b.datasize)"File count",(round(sum(b.datasize)/1024,3)/count(b.datasize))"Average file size (in K bytes)",a.parentid"FolderDataId",c.name from edrms_admin.dtree a,(select docid,datasize from edrms_admin.dversdata ) b, edrms_admin.dtree cwhere a.dataid = b.docid and c.dataid = a.parentid group by a.parentid,c.nameorder by "Data Size (in K bytes) " desc

Steve_McDonough

Oops, the other BIG! My bad! Sorry.

Peter_Arens_(parens_-_(deleted))

Hello Glenn,I don't know what I am doing wrong but I don't have a chance to get a result out of this report. I don't know why, but I get a Error processing request.Is this a Live Report for Oracle, and does it work at your Livelink?Peter

Glenn_Joseph_Heying_(gheying@opentext.com_(Delete)

Sorry, I did a cut and paste from my DB iinstance and it still has the tables referenced by schema. Remove the "edrms_admin." in front of each table and see if that works. I ran it on SQLServer and Oracle and it worked on both.

Peter_Arens_(parens_-_(deleted))

Hello I deleted what you have said but nevertheless it doesn't work.The message I get is:Livelink Error: Error processing request. [ORA-00923: FROM keyword not found where expected - select round(sum(b.datasize)/1024,3)"Data Size (in K bytes) ",count(b.datasize)"File count",(round(sum(b.datasize)/1024,3)/count(b.datasize))"Average file size (in K bytes)",a.parentid"FolderDataId",c.name from dtree a,(select docid,datasizefrom dversdata ) b, dtree cwhere a.dataid = b.docid and c.dataid = a.parentid group by a.parentid,c.nameorder by "Data Size (in K bytes) " desc] Do you have any idea??Thanks and happy new year.Peter

volvostephen

Message from Fisher, Stephen via eLinkYou need a few spaces in there - like "nameorder " should have beenname order.When you cut and paste into the edit SQL box in the Live Report editor,make sure to go to the end of every line and add a space - otherwise youend up with the problem below - works running together.-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Wednesday, January 03, 2007 9:22 AMTo: eLink RecipientSubject: It really doesn't workIt really doesn't workPosted by Arens, Peter on 01/03/2007 09:17 AMHello I deleted what you have said but nevertheless it doesn't work.The message I get is:Livelink Error: Error processing request. [ORA-00923: FROM keyword not found where expected - selectround(sum(b.datasize)/1024,3)"Data Size (in K bytes)",count(b.datasize)"Filecount",(round(sum(b.datasize)/1024,3)/count(b.datasize))"Average filesize (in K bytes)",a.parentid"FolderDataId",c.name from dtree a,(selectdocid,datasizefrom dversdata ) b, dtree cwhere a.dataid = b.docid andc.dataid = a.parentid group by a.parentid,c.nameorder by "Data Size (inK bytes) " desc] Do you have any idea??Thanks and happy new year.Peter[To reply to this thread, use your normal E-mail reply function.]============================================================Topic: Biggest Folders in Livelinkhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/9653671Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/llisapi.dllTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.*****************************NOTICE - This email (including all attachments) is the sole property of the HATCH group of companies. It may contain personal and confidential information, and is intended solely for the addressee. If you are not the intended recipient, any use, disclosure, copying or any other action is unauthorized and may be unlawful. This email is also subject to copyright. No part of it should be reproduced, adapted or communicated without the written consent of the relevant HATCH company.If you have received this email in error, please notify us immediately by return e-mail or via mailto:MailAdmin@Hatch.ca and delete all copies from your system.

Peter_Arens_(parens_-_(deleted))

Hello,I tried I think nearly everything. I don't know what is wrong, but it doesn't work. How would you write the coding of this report?Thanks for answering?Peter

Kyle_Swidrovich

Message from Kyle Swidrovich <kswidrov@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">Thanks Leon interesting Report but..

Hello Peter,

The problem with developing a report as you describe is that it would have to take into account all child objects of the folder in order to properly accumulate a group total for disk usage. With that in mind, the containers occupying the most disk space would end up being things like the Enterprise Workspace and its direct child folders.

You would have to consider limiting how many children to traverse to for each item when adding up the space usage, otherwise your query won't be very helpful.

Would a query work for you that only adds up the count/size of a particular container's direct children and ignore any children of child containers?

If you want to take into account children of children, you will need to develop a recursive query. This is fairly simple to do in Oracle SQL (using CONNECT BY PRIOR) but not in MS SQL as this type of syntax does not exist in the language.

I would suggest basing your LiveReport off of the suggestion Glenn Heying previously provided.

Kyle Swidrovich

Search/SDK Product Specialist

Open Text Corporation

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tue 19/12/2006 4:36 AM
To: eLink Recipient
Subject: Thanks Leon interesting Report but..

Thanks Leon interesting Report but..
Posted by Arens, Peter on 12/19/2006 04:34 AM

Hello,

this is an interesting report, but not what we need. We don't need a report which shows us the folders with the most documents, we need a report which shows us the biggest folders in bytes or mega bytes. Where is the most data in.
Does anyone have an idea how to do that?

Peter

[To reply to this thread, use your normal E-mail reply function.]

============================================================

Topic: Biggest Folders in Livelink
https://knowledge.opentext.com/knowledge/llisapi.dll/open/9653671

Discussion: Livelink LiveReports Discussion
https://knowledge.opentext.com/knowledge/llisapi.dll/open/2249677

Livelink Server:
https://knowledge.opentext.com/knowledge/llisapi.dll

To Unsubscribe from this Discussion, send an e-mail to unsubscribe.livereportsdiscussion@elinkkc.opentext.com.

Steve_McDonough

Hello Peter,I used Glenn's SQL syntax and was able to get the report to work once you remove his specialized prefixes and added some strategic spacing. Here is that syntax:select round(sum(b.datasize)/1024,3) "Data Size (in K bytes)", count(b.datasize)"File count", (round(sum(b.datasize)/1024,3)/count(b.datasize)) "Average file size (in K bytes)", a.parentid "FolderDataId" ,c.name from dtree a, (select docid,datasize from dversdata ) b, dtree c where a.dataid = b.docid and c.dataid = a.parentid group by a.parentid, c.name order by "Data Size (in K bytes)" descBe sure to set up your report format as "Auto LiveReport" and you should be good to go.Regards,Leon

Peter_Arens_(parens_-_(deleted))

After I put in the syntax I got the following message:[ORA-00907: missing right parenthesis - select round(sum(b.datasize)/1024,3) "Data Size (in K Kytes)", count(b.datasize)"File count", (round(sum b.datasize)/1024,3)/count(b.datasize)) "Average file size (in K bytes)", a.parentid "FolderDataId" ,c.name from dtree a, (select docid,datasize from dversdata ) b, dtree c where a.dataid = b.docid and c.dataid = a.parentid group by a.parentid, c.name order by "Data Size (in K bytes)" desc] We do have Oracle alnd Llivelink 9.5SP1, do you have an idea why it doesn't work for us?ThanksPeter

volvostephen

The error message here is quite useful....'missing right parenthesis 'This expression(round(sum b.datasize)/1024,3)/count(b.datasize)) Has 4 closing brackets and 3 opening brackets it should likely be (round(sum b.datasize)/1024,3)/count(b.datasize)Of course - it would seem that an opening bracket is missing so wouldn't that be a missing left parenthesis.... O well.I hope that works.

Peter_Arens_(parens_-_(deleted))

Hello,now I got the following message:[ORA-00907: missing right parenthesis - select round (sum (b.datasize) / 1024,3) "Data Size (in K bytes)", count (b.datasize) "File count", (round (sum b.datasize) / 1024,3) / count (b.datasize) "Average file size (in K bytes)", a.parentid "FolderDataID", c.name from dtree a, (select docid, datasize from dversdata) b, dtree c where a.dataid = b.docid and c.dataid = a.parentid group by a.parentid, c.name order by "Data Size (in K bytes) " desc] This seems to be a never ending story..Peter

Hans Stoop

Message from Hans Stoop via eLinkWhat you could do is run the query directly in the Oracle SQL monitor,and preferable to split it over multiple lines.Oracle will give you a more precise position of where it goes wrong.Hans > -----Original Message-----> From: eLink Discussion: Livelink LiveReports Discussion > [mailto:livereportsdiscussion@elinkkc.opentext.com] > Sent: dinsdag 9 januari 2007 15:29> To: eLink Recipient> Subject: No it doesn't....> > No it doesn't....> Posted by Arens, Peter on 01/09/2007 09:28 AM> > Hello,> > now I got the following message:> > [ORA-00907: missing right parenthesis - select round (sum > (b.datasize) / 1024,3) "Data Size (in K bytes)", count > (b.datasize) "File count", (round (sum b.datasize) / 1024,3) > / count (b.datasize) "Average file size (in K bytes)", > a.parentid "FolderDataID", c.name from dtree a, (select > docid, datasize from dversdata) b, dtree c where a.dataid = > b.docid and c.dataid = a.parentid group by a.parentid, c.name > order by "Data Size (in K bytes) " desc] > > This seems to be a never ending story..> > Peter> > [To reply to this thread, use your normal E-mail reply function.]> > ============================================================> > Topic: Biggest Folders in Livelink> https://knowledge.opentext.com/knowledge/llisapi.dll/open/9653671> > Discussion: Livelink LiveReports Discussion> https://knowledge.opentext.com/knowledge/llisapi.dll/open/2249677> > Livelink Server:> https://knowledge.opentext.com/knowledge/llisapi.dll> > To Unsubscribe from this Discussion, send an e-mail to > unsubscribe.livereportsdiscussion@elinkkc.opentext.com.> > >

Roger_Duplin

Message from Roger Duplin <rduplin@opentext.com> via eLink

eLink

Hi Peter,

The Average file size is using (round(sumb.datasize) / 1024,3) / count( b.datasize ). It should be round( sum(b.datasize ) / 1024, 3) / count( b.datasize ). That should fix your problem.

Regards,

Roger Duplin

Product Support Specialist

Open Text Corporation

From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, January 09, 20079:29 AM
To: eLink Recipient
Subject: No it doesn't....

No it doesn't....		Posted by parens (Arens, Peter) on 01/09/2007 09:28 AM
In reply to: You are missing right parenthesis		Posted by stephenfisher (Fisher, Stephen J) on 01/09/2007 08:47 AM

Hello,

now I got the following message:

[ORA-00907: missing right parenthesis - select round (sum (b.datasize) / 1024,3) "Data Size (in K bytes)", count (b.datasize) "File count", (round (sum b.datasize) / 1024,3) / count (b.datasize) "Average file size (in K bytes)", a.parentid "FolderDataID", c.name from dtree a, (select docid, datasize from dversdata) b, dtree c where a.dataid = b.docid and c.dataid = a.parentid group by a.parentid, c.name order by "Data Size (in K bytes) " desc]

This seems to be a never ending story..

Peter

Peter_Arens_(parens_-_(deleted))

Now I got the following message...[ORA-00907: missing right parenthesis - select round (sum (b.datasize) / 1024,3) "Data Size (in K bytes)", count (b.datasize) "File count", round (sum b.datasize) / 1024,3) / count ( b.datasize ) "Average file size (in K bytes)", a.parentid "FolderDataID", c.name from dtree a, (select docid, datasize from dversdata) b, dtree c where a.dataid = b.docid and c.dataid = a.parentid group by a.parentid, c.name order by "Data Size (in K bytes) " desc] Peter

Roger_Duplin

Message from Roger Duplin <rduplin@opentext.com> via eLink

eLink

Hi Peter,

That will work, but will give you a longfloating point number in many cases. You might want to use round( ( sum(b.datasize ) / 1024 ) / count( b.datasize ), 3 ) instead…

Roger

From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, January 09, 200710:38 AM
To: eLink Recipient
Subject: RE No it doesn't.... 2

RE No it doesn't.... 2		Posted by rduplin (Duplin, Roger) on 01/09/2007 10:37 AM
In reply to: No it doesn't....		Posted by parens (Arens, Peter) on 01/09/2007 09:28 AM

Message from Roger Duplin <rduplin@opentext.com> via eLink

Hi Peter,

The Average file size is using (round(sum b.datasize) / 1024,3) / count( b.datasize ). It should be round( sum( b.datasize ) / 1024, 3) / count( b.datasize ). That should fix your problem.

Regards,

Roger Duplin

Product Support Specialist

Open Text Corporation

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, January 09, 2007 9:29 AM
To: eLink Recipient
Subject: No it doesn't....

No it doesn't....		Posted by parens (Arens, Peter) on 01/09/2007 09:28 AM
In reply to: You are missing right parenthesis		Posted by stephenfisher (Fisher, Stephen J) on 01/09/2007 08:47 AM

Hello,

now I got the following message:

[ORA-00907: missing right parenthesis - select round (sum (b.datasize) / 1024,3) "Data Size (in K bytes)", count (b.datasize) "File count", (round (sum b.datasize) / 1024,3) / count (b.datasize) "Average file size (in K bytes)", a.parentid "FolderDataID", c.name from dtree a, (select docid, datasize from dversdata) b, dtree c where a.dataid = b.docid and c.dataid = a.parentid group by a.parentid, c.name order by "Data Size (in K bytes) " desc]

This seems to be a never ending story..

Peter

<hr

Roger_Duplin

Message from Roger Duplin <rduplin@opentext.com> via eLink

eLink

Hi Peter,

You are just missing a “(“between “sum” and “b.datasize”. Anyways, you shouldprobably use this instead to round off the final figure:

round( ( sum( b.datasize ) / 1024 ) /count( b.datasize ), 3 )

Here’s the full SQL statement withthe substitution in place:

select round (sum (b.datasize) / 1024,3)"Data Size (in K bytes)", count (b.datasize) "File count", round( ( sum( b.datasize ) / 1024 ) / count( b.datasize ), 3 )

"Average file size (in Kbytes)", a.parentid "FolderDataID", c.name from dtree a, (selectdocid, datasize from dversdata) b, dtree c where a.dataid = b.docid andc.dataid = a.parentid group by a.parentid, c.name order by "Data Size (inK bytes) " desc

Regards,

Roger

From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, January 09, 200711:33 AM
To: eLink Recipient
Subject: No it doesn't.....

No it doesn't.....		Posted by parens (Arens, Peter) on 01/09/2007 11:27 AM
In reply to: RE No it doesn't.... 2		Posted by rduplin (Duplin, Roger) on 01/09/2007 10:37 AM

Now I got the following message...

[ORA-00907: missing right parenthesis - select round (sum (b.datasize) / 1024,3) "Data Size (in K bytes)", count (b.datasize) "File count", round (sum b.datasize) / 1024,3) / count ( b.datasize ) "Average file size (in K bytes)", a.parentid "FolderDataID", c.name from dtree a, (select docid, datasize from dversdata) b, dtree c where a.dataid = b.docid and c.dataid = a.parentid group by a.parentid, c.name order by "Data Size (in K bytes) " desc]

Peter

Steve_McDonough

Syntax error is explained in the attached document.

Peter_Arens_(parens_-_(deleted))

That was partly the solution, the message with the right parenthesis is away. But now I got the following:Livelink Error: Error processing request. [ORA-00904: "Data Size (in K bytes)": invalid identifier - select round(sum(b.datasize)/1024,3) "Data Size (in K Kytes)", count(b.datasize)"File count", (round(sum(b.datasize) / 1024,3) / count(b.datasize)) "Average file size (in K bytes)", a.parentid "FolderDataId" ,c.name from dtree a, (select docid,datasize from dversdata ) b, dtree c where a.dataid = b.docid and c.dataid = a.parentid group by a.parentid, c.name order by "Data Size (in K bytes)" desc] Any idea??

Hans Stoop

Message from Hans Stoop via eLinkIs thisjust a typing error? IN the select you write 'Kytes' and not'bytes'.Hans > -----Original Message-----> From: eLink Discussion: Livelink LiveReports Discussion > [mailto:livereportsdiscussion@elinkkc.opentext.com] > Sent: woensdag 31 januari 2007 13:20> To: eLink Recipient> Subject: Now another message> > Now another message> Posted by Arens, Peter on 01/31/2007 07:18 AM> > That was partly the solution, the message with the right > parenthesis is away. But now I got the following:> > Livelink Error: Error processing request. > [ORA-00904: "Data Size (in K bytes)": invalid identifier - > select round(sum(b.datasize)/1024,3) "Data Size (in K > Kytes)", count(b.datasize)"File count", > (round(sum(b.datasize) / 1024,3) / count(b.datasize)) > "Average file size (in K bytes)", a.parentid "FolderDataId" > ,c.name from dtree a, (select docid,datasize from dversdata ) > b, dtree c where a.dataid = b.docid and c.dataid = a.parentid > group by a.parentid, c.name order by "Data Size (in K bytes)" desc] > > Any idea??> > [To reply to this thread, use your normal E-mail reply function.]> > ============================================================> > Topic: Biggest Folders in Livelink> https://knowledge.opentext.com/knowledge/llisapi.dll/open/9653671> > Discussion: Livelink LiveReports Discussion> https://knowledge.opentext.com/knowledge/llisapi.dll/open/2249677> > Livelink Server:> https://knowledge.opentext.com/knowledge/llisapi.dll> > To Unsubscribe from this Discussion, send an e-mail to > unsubscribe.livereportsdiscussion@elinkkc.opentext.com.> > >

Peter_Arens_(parens_-_(deleted))

Yes you are right, it was written wrong, but that wasn't the mistake. I still get the same message..

Bhupinder_Singh

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

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

Can you post the current error message that you get now, after the spelling correction was made? Thanks...

- Bhupinder

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, January 31, 2007 9:22 AM
To: eLink Recipient
Subject: That was not the mistake..

That was not the mistake..		Posted by parens (Arens, Peter) on 01/31/2007 09:18 AM
In reply to: RE Now another message		Posted by hstoop (Stoop, Hans) on 01/31/2007 07:35 AM

Yes you are right, it was written wrong, but that wasn't the mistake. I still get the same message..

Peter_Arens_(parens_-_(deleted))

[ORA-00904: "Data Size (in K bytes)": invalid identifier - select round(sum(b.datasize)/1024,3) "Data Size (in K bytes)", count(b.datasize)"File count", (round(sum(b.datasize) / 1024,3) / count(b.datasize)) "Average file size (in K bytes)", a.parentid "FolderDataId" ,c.name from dtree a, (select docid,datasize from dversdata ) b, dtree c where a.dataid = b.docid and c.dataid = a.parentid group by a.parentid, c.name order by "Data Size (in K bytes)" desc]

Bhupinder_Singh

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

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

That's really quite odd. I copied and pasted your select statement, without any modifications, into my LiveReport on Livelink 9.5 SP1 on Oracle 9i, used the "AutoLiveReport" format and it works without issue, giving me the following results:

Data Size (in K bytes) File count Average file size (in K bytes) FolderDataId NAME 211 3 70 -11398 New Project 209 2 104 2000 Enterprise 194 5 38 4843 Frederick Kong 138 1 138 6137 All Livelink Tables 6 2 3 2212 Enterprise Data Source Folder 4 4 1 2111 Slice Folder 4 2 2 6027 Documents and Other Objects 1 1 1 10628 Help Data Source Folder 1 1 1 11068 Admin Help Data Source Folder 1 1 1 10645 Admin 1 1 1 2008 Personal Search Templates 0 1 0 2004 Livelink Categories 0 1 0 10307 Classifications

Documentation for the ORA-00904 error indicates:

ORA-00904: string: invalid identifier

Cause: The column name entered is either missing or invalid.

Action: Enter a valid column name. A valid column name must begin with a letter, be less than or equal to 30 characters, and consist of only alphanumeric characters and the special characters $, _, and #. If it contains other characters, then it must be enclosed in double quotation marks. It may not be a reserved word.

What version of Oracle are you using? What if you introduce underscores in the alias names, i.e. Data_Size_(in_K_bytes), etc. ?

- Bhupinder

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, January 31, 2007 10:10 AM
To: eLink Recipient
Subject: I think it is still the same

I think it is still the same		Posted by parens (Arens, Peter) on 01/31/2007 10:09 AM
In reply to: RE That was not the mistake..		Posted by bsingh (Singh, Bhupinder) on 01/31/2007 09:27 AM