Re: [Gusdev-gusdev] DBD::Oracle::db prepare failed

[Terry C. <tw...@cs...>]

Chetna, this looks like the circular dependence in the build. 
There's a work around for this documented at 
   http://www.gusdb.org/documentation/installguide.html
in section 2.4.

Terry


On  0, Chetna Warade <wa...@ya...> wrote:
> We are trying to install GUS 3.0 from scratch and
> following almost all documentations.
> 
> We are little confused here for the following reasons:
> 
> The GUS documentation says to do:
> Initial build system - (this is failing for us) that
> generates schema creation scritps. Then execute  the
> create-db.sh.
> 
> The error below is about "table or view not found" Are
> there any tables/views besides the 5 known
> (core,rad3,sres,tess,dots) schemas?
> 
> 
> 
> [root@mkiwi install]# build GUS install -append
> 
> ant -f /var/local/checkout/install/build.xml install
> -Dproj=GUS -DtargetDir=/var/local/gus_home -Dcomp=
> -DprojectsDir=/var/local/checkout  -Dappend=true  
> -logger org.apache.tools.ant.NoBannerLogger | grep ']'
> 
>      [echo] .
>      [echo] Installing CBIL/Bio
>      [echo] .
>      [echo] Installing CBIL/CSP
>      [echo] .
>      [echo] Installing CBIL/Util
>    [concat] Warning: Could not find any of the files
> specified in concat task.
>      [echo] .
>      [echo] Installing GUS/Common
>      [echo] .
>      [echo] Installing GUS/DBAdmin
>      [echo] .
>      [echo] Installing GUS/GOPredict
>      [echo] .
>      [echo] Installing GUS/ObjRelP
>      [echo] generating Perl Objects
>      [exec] Reading properties from
> /root/.gus.properties
>      [exec] DBI subclasses
> 'GUS::ObjRelP::DbiDbHandle::db' and ::st are not
> setup, RootClass ignored at
> /var/local/gus_home/lib/perl/GUS/ObjRelP/DbiDatabase.pm
> line 152
>      [exec] DBD::Oracle::db prepare failed: ORA-00942:
> table or view does not exist (DBD ERROR:
> OCIStmtExecute/Describe) at
> /var/local/gus_home/lib/perl/GUS/ObjRelP/DbiDbHandle.pm
> line 78.
>      [exec] prepareAndExecute FAILED:
> GUS::ObjRelP::DbiDbHandle=HASH(0x83dd120)->errstr
>      [exec] Can't call method "execute" without a
> package or object reference at
> /var/local/gus_home/lib/perl/GUS/ObjRelP/DbiDbHandle.pm
> line 79.
>      [exec] GUS::ObjRelP::DbiDbHandle
> dbi:Oracle:host=kiwi.rcr.uga.edu;sid=CTEGD GUSReadOnly
> GUSReadOnly1111  0 1
> 
> BUILD FAILED
> file:/var/local/checkout/GUS/build.xml:194: exec
> returned: -1
> 
> Total time: 6 seconds
> [root@mkiwi install]#
> 
> Thanks,
> Chetna
> 
> 
> 
> __________________________________
> Do you Yahoo!?
> The New Yahoo! Shopping - with improved product search
> http://shopping.yahoo.com
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by OSDN developer relations
> Here's your chance to show off your extensive product knowledge
> We want to know what you know. Tell us and you have a chance to win $100
> http://www.zoomerang.com/survey.zgi?HRPT1X3RYQNC5V4MLNSV3E54
> _______________________________________________
> Gusdev-gusdev mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev