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

[Steve F. <st...@pc...>]

glad to hear that, and sorry that you had difficulty.

steev

Chetna Warade wrote:

>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
>>    
>>
>
>
>-------------------------------------------------------
>This SF.net email is sponsored by: SF.net Giveback Program.
>Does SourceForge.net help you be more productive?  Does it
>help you create better code?   SHARE THE LOVE, and help us help
>YOU!  Click Here: http://sourceforge.net/donate/
>_______________________________________________
>Gusdev-gusdev mailing list
>Gus...@li...
>https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>  
>