[Gusdev-gusdev] Sequence Ontology Tables

[Ed R. <ero...@ug...>]

I'm loading the Sequence ontology table, and I am getting a
constraint violation on a table in SRESVER.SEQUENCEONTOLOGYVER

Does anyone have any idea where this is coming from?  I can't
find any triggers or cross schema constraints involving these
tables.

Here's the stack trace

DBD::Oracle::st execute failed: ORA-00001: unique constraint
(SRESVER.PK_SEQUENCEONTOLOGYVER) violated (DBD ERROR:
OCIStmtExecute) at
/var/local/GUS/gus_home/lib/perl/GUS/ObjRelP/DbiDbHandle.pm
line 147, <GEN0> line 15.
 
 SQL ERROR!! involving
   
 Values: 43 at
/var/local/GUS/gus_home/lib/perl/GUS/ObjRelP/DbiDbHandle.pm
line 187
       
GUS::ObjRelP::DbiDbHandle::death('GUS::ObjRelP::DbiDbHandle=HASH(0x8614aa8)',
'^J SQL ERROR!! involving^J  ^J Values: 43') called at
/var/local/GUS/gus_home/lib/perl/GUS/ObjRelP/DbiDbHandle.pm
line 150
       
GUS::ObjRelP::DbiDbHandle::sqlExec('GUS::ObjRelP::DbiDbHandle=HASH(0x8614aa8)',
'GUS::ObjRelP::DbiDbHandle::st=HASH(0x88e2670)',
'ARRAY(0x88f8af4)') called at
/var/local/GUS/gus_home/lib/perl/GUS/Model/GusRow.pm line 1798
       
GUS::Model::GusRow::version('GUS::Model::SRes::SequenceOntology=HASH(0x8841364)')
called at /var/local/GUS/gus_home/lib/perl/GUS/Model/GusRow.pm
line 1665
       
GUS::Model::GusRow::submit('GUS::Model::SRes::SequenceOntology=HASH(0x8841364)')
called at
/var/local/GUS/gus_home/lib/perl/GUS/Common/Plugin/LoadSODefinitions.pm
line 70
       
GUS::Common::Plugin::LoadSODefinitions::run('GUS::Common::Plugin::LoadSODefinitions=HASH(0x8530354)',
'HASH(0x88412a4)') called at
/var/local/GUS/gus_home/lib/perl/GUS/PluginMgr/GusApplication.pm
line 453
        eval {...} called at
/var/local/GUS/gus_home/lib/perl/GUS/PluginMgr/GusApplication.pm
line 450
       
GUS::PluginMgr::GusApplication::doMajorMode_RunOrReport('GUS::PluginMgr::GusApplication=HASH(0x80fbb4c)',
'GUS::Common::Plugin::LoadSODefinitions', 1) called at
/var/local/GUS/gus_home/lib/perl/GUS/PluginMgr/GusApplication.pm
line 383
       
GUS::PluginMgr::GusApplication::doMajorMode_Run('GUS::PluginMgr::GusApplication=HASH(0x80fbb4c)',
'GUS::Common::Plugin::LoadSODefinitions') called at
/var/local/GUS/gus_home/lib/perl/GUS/PluginMgr/GusApplication.pm
line 289
       
GUS::PluginMgr::GusApplication::doMajorMode('GUS::PluginMgr::GusApplication=HASH(0x80fbb4c)',
'GUS::Common::Plugin::LoadSODefinitions') called at
/var/local/GUS/gus_home/lib/perl/GUS/PluginMgr/GusApplication.pm
line 198
       
GUS::PluginMgr::GusApplication::parseAndRun('GUS::PluginMgr::GusApplication=HASH(0x80fbb4c)',
'ARRAY(0x81051b0)') called at /var/local/GUS/gus_home/bin/ga
line 11


-----------------
Ed Robinson
Center for Tropical and Emerging Global Diseases
University of Georgia, Athens, GA 30602
ero...@ug.../(706)542.1447/254.8883