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

[Chetna W. <ch...@ug...>]

Hello Steve,

I tried locating the problem and have fixed it today morning.
It took me a while to find out whats the problem but it seems
that there could be two reasons (1) since the installation
failed for me for the first time some inconsistency with the
permissions happened to the files that were not installed
properly Or (2) I may have missed a build step in the process
of debugging the failed installation.

Having said that my obeservation is if I start everything from
 scratch and follow the documentation it worked for me.

Thanks
Chetna

---- Original message ----
>Date: Mon, 27 Oct 2003 18:23:15 -0500
>From: Steve Fischer <sfi...@pc...>  
>Subject: Re: [Gusdev-gusdev] DBD::Oracle::db prepare failed  
>To: Chetna Warade <wa...@ya...>
>Cc: gus...@li..., jki...@ug...
>
>Chetna-
>
>I am not sure what is causing the problem.
>
>However, I can see that the code which is failing is not
doing the best 
>job of reporting what went wrong.
>
>How about you make the following patch to the file 
>$PROJECT_HOME/GUS/ObjRelP/lib/perl/DbiDbHandle.pm:
>
>On around line 74 you will find the method  prepareAndExecute.
>
>Comment it out, and replace it with this:
>
>sub prepareAndExecute {
>  my ($self, $sql_cmd) = @_;
>  if ($verbose) { print STDERR"\n\nprepareAndExecute:
$sql_cmd \n"; }
>
>  my $sth = $self->prepare($sql_cmd) || print STDERR "Prepare
FAILED: " 
>. $self->errstr() . "\n sql_cmd:  \n $sql_cmd \n";
>  $sth->execute() || print STDERR "Execute FAILED: " .
$self->errstr() . 
>"\n sql_cmd:  \n $sql_cmd \n";
>  return $sth;
>}
>
>then try the build again.
>
>let me know what happens.
>
>steve
>
>Chetna Warade wrote:
>
>>Hello All,
>>
>>I have followed the step by step documentation from
>>Terry and also reffered section 2.4 but I am still
>>getting the same error:  I am also printing the values
>>such as userid, host etc.. that assures that the login
>>exists,
>>Here's snapshot:
>>
>># 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
>>
>>Thanks in advance,
>>Chetna
>>
>>
>>--- Terry Clark <tw...@cs...> wrote:
>>  
>>
>>>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
>>>    
>>>
>>
>>
>>
>>
>>__________________________________
>>Do you Yahoo!?
>>The New Yahoo! Shopping - with improved product search
>>http://shopping.yahoo.com
>>
>>
>>-------------------------------------------------------
>>This SF.net email is sponsored by: The SF.net Donation Program.
>>Do you like what SourceForge.net is doing for the Open
>>Source Community?  Make a contribution, and help us add new
>>features and functionality. Click here:
http://sourceforge.net/donate/
>>_______________________________________________
>>Gusdev-gusdev mailing list
>>Gus...@li...
>>https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>>  
>>
>
>
>
>-------------------------------------------------------
>This SF.net email is sponsored by: The SF.net Donation Program.
>Do you like what SourceForge.net is doing for the Open
>Source Community?  Make a contribution, and help us add new
>features and functionality. Click here:
http://sourceforge.net/donate/
>_______________________________________________
>Gusdev-gusdev mailing list
>Gus...@li...
>https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev