Largest Projects Physcial Space

I am encountering an ORACLE error ORA-01455 when attempting to run the Largest Projects Physical Space report.I have modified the report to convert the size from bytes to MBselect %1, (sum(c.DataSize)/(1024*1024)) "sumdata", DTree.OwnerID from DTree, DTree b, DVersData c where %2 and DTree.OwnerID = b.OwnerID and b.DataID = c.DocID and %3 group by DTree.Name, DTree.OwnerID, %1 order by sum(c.DataSize) descThe report will work, however the results are not accurate.When I create a new project and there is nothing residing in the project it will list on the report with a size of 413. With my calculation this is 413 MB. Not sure how the project is 413 MB when there is nothing in the project. Is there something I am missing.

Find more posts tagged with

Comments

Xu_Moua_(xumoua_(Delete)_1406611)

Message from Xu Moua via eLinkHi,Looks like you've modified more than just the size conversion. Thereport should have "DTree.DataID=b.OwnerID" instead of "DTree.OwnerID =b.OwnerID".Attached is an export of the LiveReport for the Largest Projects in KB.Also note that LiveReports have a record limit and as such will onlyreturn the number of items specified. The parameter is called "RecordLimit" and by default it is 100.Original LiveReport-------------------select %1, sum(c.DataSize) "sumdata" from DTree DTree, DTree b, DVersData c where %2 and DTree.DataID=b.OwnerID and b.DataID=c.DocID and %3 group by %1 order by sum(c.DataSize) descYour modified LiveReport-----------------------select %1, (sum(c.DataSize)/(1024*1024)) "sumdata", DTree.OwnerID from DTree, DTree b, DVersData c where %2 and DTree.OwnerID = b.OwnerID and b.DataID = c.DocID and %3 group by DTree.Name, DTree.OwnerID, %1 order by sum(c.DataSize) descRegards,Xu Moua-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Friday, May 23, 2003 6:40 PMTo: eLink RecipientSubject: Largest Projects Physcial SpaceLargest Projects Physcial SpacePosted by C4 Systems, General Dynamics on 05/23/2003 06:31 PMI am encountering an ORACLE error ORA-01455 when attempting to run theLargest Projects Physical Space report.I have modified the report to convert the size from bytes to MB select%1, (sum(c.DataSize)/(1024*1024)) "sumdata", DTree.OwnerID from DTree,DTree b, DVersData c where %2 and DTree.OwnerID = b.OwnerID and b.DataID= c.DocID and %3 group by DTree.Name, DTree.OwnerID, %1 order bysum(c.DataSize) descThe report will work, however the results are not accurate. When Icreate a new project and there is nothing residing in the project itwill list on the report with a size of 413. With my calculation this is413 MB. Not sure how the project is 413 MB when there is nothing in theproject. Is there something I am missing. [To reply to this thread, use your normal e-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server: https://knowledge.opentext.com/knowledge/livelink.exe