[Gusdev-gusdev] insufficient privileges on Core.Algorithm_SQ sequence

[Kevin M. <mu...@ge...>]

Hi gusdev-gusdev list,

(I'm working on the same installation with Juan Perin, who has posted a  
couple times in the last few days).

While following the VBI PDF guide to GUS installation, we've  
encountered an error at the following step:

ga +meta --commit

After writing the </Core::Algorithm> tag (see full output below), there  
is an error, apparently because the user does not have sufficient  
privileges on the Core.Algorithm_SQ sequence.

I inserted a debug statement to look at DBH->{Username}, and it is  
GUSrw.  Using sqlplus shows that GUSrw can't read this sequence, but  
the sequence does exist in ALL_SEQUENCES.

What do you think has gone wrong with our installation?  We've been  
guilty of some errors along the way (typos in config files, use of  
vbi's properties file instead of deriving from the sample, etc) and had  
to run the 'build' script a number of times.  Is it brittle?

Thanks,
Kevin Murphy

- - - -

[gus@rad GUS]$ ga +meta --commit
   <Core::Algorithm>
     <name>GA-Plugin</name>
     <description>GUS application framework for plugins</description>
     <Core::AlgorithmImplementation>
       <cvs_revision>1.49</cvs_revision>
       <cvs_tag> </cvs_tag>
       <executable>GUS::PluginMgr::GusApplication</executable>
       <executable_md5>e291775acbf95c5ed6bae9024ad78e79</executable_md5>
       <description>update for GUS 3.0</description>
       <Core::AlgorithmInvocation>
         <start_time>SYSDATE</start_time>
         <end_time>SYSDATE</end_time>
         <machine_id>0</machine_id>
         <cpus_used>1</cpus_used>
         <result>meta</result>
       </Core::AlgorithmInvocation>
     </Core::AlgorithmImplementation>
   </Core::Algorithm>
DBD::Oracle::db prepare failed: ORA-01031: insufficient privileges (DBD  
ERROR: error possibly near <*> indicator at char 12 in 's\
elect Core.<*>Algorithm_SQ.NEXTVAL from DUAL') [for Statement "select  
Core.Algorithm_SQ.NEXTVAL from DUAL"] at /checkout/GUS/lib/\
perl/GUS/ObjRelP/DbiTable.pm line 551.
Failed preparing sql 'select Core.Algorithm_SQ.NEXTVAL from DUAL' with  
error: ORA-01031: insufficient privileges (DBD ERROR: erro\
r possibly near <*> indicator at char 12 in 'select  
Core.<*>Algorithm_SQ.NEXTVAL from DUAL') at  
/checkout/GUS/lib/perl/GUS/ObjRel\
P/DbiTable.pm line 551
          
GUS::ObjRelP::DbiTable::getNextID('GUS::Model::Core:: 
Algorithm_Table=HASH(0x86b2560)', undef) called at /checkout/GUS/lib\
/perl/GUS/ObjRelP/DbiRow.pm line 535
          
GUS::ObjRelP::DbiRow::getNextID('GUS::Model::Core:: 
Algorithm=HASH(0x86591d0)') called at /checkout/GUS/lib/perl/GUS/ObjRe\
lP/DbiRow.pm line 606
          
GUS::ObjRelP::DbiRow::insert('GUS::Model::Core:: 
Algorithm=HASH(0x86591d0)') called at  
/checkout/GUS/lib/perl/GUS/Model/Gu\
sRow.pm line 1677
          
GUS::Model::GusRow::submit('GUS::Model::Core:: 
Algorithm=HASH(0x86591d0)') called at  
/checkout/GUS/lib/perl/GUS/PluginMgr/\
GusApplication.pm line 355
          
GUS::PluginMgr::GusApplication::doMajorMode_Meta('GUS::PluginMgr:: 
GusApplication=HASH(0x80fbc2c)', undef) called at /chec\
kout/GUS/lib/perl/GUS/PluginMgr/GusApplication.pm line 283
          
GUS::PluginMgr::GusApplication::doMajorMode('GUS::PluginMgr:: 
GusApplication=HASH(0x80fbc2c)', undef) called at /checkout/\
GUS/lib/perl/GUS/PluginMgr/GusApplication.pm line 192
          
GUS::PluginMgr::GusApplication::parseAndRun('GUS::PluginMgr:: 
GusApplication=HASH(0x80fbc2c)', 'ARRAY(0x81049d0)') called \
at /checkout/GUS/bin/ga line 11