[Bioperl-l] Could not load GO terms to BioSQL

Holland, Richard Richard.Holland at agresearch.co.nz
Sun Jan 4 16:09:43 EST 2004

On attempting to load the current GO definitions I get this:

/usr/users/oracle/bioperl-db/scripts/biosql/load_ontology.pl --host
bifo6 --dbname seqstore --dbuser zzzz --dbpass zzzz  --driver Oracle
--namespace "Gene Ontology" --lookup --remove --format goflat --fmtargs
Parsing input ...
Loading ontology Gene Ontology:
        ... terms
DBD::Oracle::st execute failed: ORA-01401: inserted value too large for
column (DBD ERROR: OCIStmtExecute) [for Statement "INSERT INTO dbxref
(dbname, accession, version) VALUES (?, ?, ?)" with ParamValues: :p3=0,
/usr/lib/perl-5.8.0/lib/site_perl/5.8.0/Bio/DB/BioSQL/BaseDriver.pm line
1001, <GEN0> line 10575.

-------------------- WARNING ---------------------
MSG: insert in Bio::DB::BioSQL::DBLinkAdaptor (driver) failed, values
ORA-01401: inserted value too large for column (DBD ERROR:
Could not store GO:0000010 (trans-hexaprenyltranstransferase activity):

------------- EXCEPTION  -------------
MSG: create: object (Bio::Annotation::DBLink) failed to insert or to be
found by unique key
STACK Bio::DB::BioSQL::BasePersistenceAdaptor::create
STACK Bio::DB::BioSQL::TermAdaptor::store_children
STACK Bio::DB::BioSQL::BasePersistenceAdaptor::create
STACK Bio::DB::BioSQL::BasePersistenceAdaptor::store
STACK Bio::DB::Persistent::PersistentObject::store
STACK (eval)
STACK toplevel



Simple fix is to adjust the size of the accession column in dbxref. I
have doubled it to 64 characters. Could someone verify this is sensible
and see if the schema could be updated to match? I don't have access to
CVS to do it myself.

PS. Whilst you're at it could you also modify the rank column of
bioentry_reference to allow numbers up to 3 digits long, not 2, as per
my previous email.


Richard Holland
Bioinformatics Database Developer
ITS, Agresearch Invermay x3279

Attention: The information contained in this message and/or attachments
from AgResearch Limited is intended only for the persons or entities
to which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipients is prohibited by AgResearch
Limited. If you have received this message in error, please notify the
sender immediately.

More information about the Bioperl-l mailing list