Can't Execute "Standard" Reports

James_Schardt_(LMGTUser1_(Delete)_2167537)

We just upgraded to version 9.0 on our test system. I am unable to run one of the "out of the box" LiveReports. I can run the report on version 8.1.5 successfully. When I run the report on version 9, I get ORA error ORA-01455. I'm not sure which column is causing the overflow.Help!!!We are running version 8.1.5 of Oracle.The report is: "Largest Project (physical size)"

Find more posts tagged with

Comments

eLink User

Message from Alex Kowalenko via eLinkParameter %2 should be "Filter Project". The corrected LiveReport isattached.-alex------Original Message-----From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf OfeLink Discussion: Livelink LiveReports DiscussionSent: Wednesday, May 02, 2001 00:08To: eLink RecipientSubject: Can't Execute "Standard" ReportsCan't Execute "Standard" ReportsPosted by LMGTUser1 on 05/01/2001 02:55 PMWe just upgraded to version 9.0 on our test system. I am unable to run oneof the "out of the box" LiveReports. I can run the report on version 8.1.5successfully. When I run the report on version 9, I get ORA errorORA-01455. I'm not sure which column is causing the overflow.Help!!!We are running version 8.1.5 of Oracle.The report is: "Largest Project (physical size)"[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

Jay_Harbeston

Does anyone have a working SQL Script and LiveReport that allows LL V9 Standard LiveReport "Largest Project (physical size)" to function correectly in LL V9? It worked in LL V8, but not in V9. I tried the suggestion offered in the reply dated 05/02/01, however, with no success.We are running LL V9.0.0.1; Oracle 8.1.6.3.0Any assistance would be most appreciated...Mike Higginsmichael.higgins@gd-ais.com

eLink User

Message from Sean M Alderman via eLink--=-k6Jp0YEwefGZ4U4dfxcFContent-Type: text/plainContent-Transfer-Encoding: 7bitI have a perl script which will determine (recursively) the total sizeof a folder or project. The script is setup to connect to oracle, butcould probably be modified to connect to SQL server (if perl has a DBDdriver for it).also it could be modified to make the calculation against all projectsinstead of a user inputed project or folder.On Fri, 2002-03-01 at 10:03, eLink Discussion: Livelink LiveReportsDiscussion wrote:> LL V9 Standard LiveReport "Largest Project (physical size)"> Posted by GDATSAdmin on 03/01/2002 09:58 AM> > Does anyone have a working SQL Script and LiveReport that allows LL V9 Standard LiveReport "Largest Project (physical size)" to function correectly in LL V9? It worked in LL V8, but not in V9. > I tried the suggestion offered in the reply dated 05/02/01, however, with no success.> We are running LL V9.0.0.1; Oracle 8.1.6.3.0> > Any assistance would be most appreciated...> Mike Higgins> michael.higgins@gd-ais.com> > [To reply to this thread, use your normal e-mail reply function.]> > ============================================================> > Topic: Can't Execute "Standard" Reports> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2512541&objAction=view> > Discussion: Livelink LiveReports Discussion> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=view> > Livelink Server:> https://knowledge.opentext.com/knowledge/livelink.exe> > -- Sean M. AldermanITRACK Systems AnalystPACE/NCI - NASA Glenn Research Center(216) 433-2795Calling a windowed operating system "Windows" is like naming anautomobile "Wheels."--=-k6Jp0YEwefGZ4U4dfxcFContent-Disposition: attachment; filename=llrecursivesum.plContent-Transfer-Encoding: quoted-printableContent-Type: text/x-perl; charset=ISO-8859-1#!/usr/bin/perl -wT## This script will query the livelink database and calculate the sum of# document sizes for directory ID supplied on the commandline.## Sean M. Alderman#use strict;use DBI;@ARGV =3D ('-') unless @ARGV;while ( $ARGV =3D shift ) { my $folderid =3D $ARGV; if ( $folderid =3D~ m/[0-9]+/ ) { my $totalsum =3D dirsum($folderid); # Fill in DBI Parameters - , , ... my $dbh =3D DBI->connect( "dbi:Oracle:prdl", "xxxxxx", "yyyyyyy", {PrintE=rror =3D> 1 } ); my $query =3D qq{ select name from dtree where dataid =3D $folderid }; my $sth =3D $dbh->prepare($query); $sth->execute; my $name =3D $sth->fetchrow_array; print "$folderid, $name: $totalsum bytes\n"; #$dbh->disconnect; } else { print "$folderid is not a valid folder id.\n" }}sub dirsum{ my $id =3D shift; my $sum =3D 0; # Fill in DBI Parameters - , , =... my $dbh =3D DBI->connect( "dbi:Oracle:prdl", "xxxxxx", "yyyyyyy", { PrintE=rror =3D> 1 } ); my $contents =3D qq{ select dataid, subtype from dtree where abs(parentid) =3D $id }; my $sth =3D $dbh->prepare($contents); $sth->execute; my ($dataid, $subtype); while (($dataid, $subtype) =3D $sth->fetchrow_array) { if ( $subtype =3D=3D 0 || $subtype =3D=3D 202 ) { $sum +=3D dirsum($dataid); } elsif ( $subtype =3D=3D 144 ) { my $sth2 =3D $dbh->prepare( qq{ select sum(datasize) from dversdata where docid =3D $dataid } ); $sth2->execute; my $result =3D $sth2->fetchrow_array; $sum +=3D $result; } } # $dbh->disconnect; return $sum;}--=-k6Jp0YEwefGZ4U4dfxcF--

Laura_Raab_(nidauser3_-_(deleted))

I'm still stuck on this one...how about a LiveReport that will allow me to pick the project it just gives me the total space it occupies? I don't care about ranking the whole collection of projects by size. Thank you!Patty