From: Juan P. <BI...@ge...> - 2004-07-20 18:53:34
|
When initially populating the Taxonomy database, the population of the tables with taxon_id's runs until what appears to be the last entry and hangs indefinitely. The following is the output after Ctrl-c 'ing to try to escape. After checking the tables, they seem to be populated fine, and the number of entries seems consistent with the number of entries given in the taxonomy database. DBD::Oracle::db commit failed: ORA-01013: user requested cancel of current operation (DBD ERROR: OCITransCommit) at /checkout/GUS/lib/perl/GUS/ObjRelP/DbiDatabase.pm line 479, <NODES> line 225327. DBD::Oracle::st execute failed: ORA-01013: user requested cancel of current operation (DBD ERROR: OCIStmtExecute) [for Statement "select SRes.TaxonName_SQ.NEXTVAL from DUAL"] at /checkout/GUS/lib/perl/GUS/ObjRelP/DbiTable.pm line 555, <NODES> line 225327. Also... How long should this initial process take? The first run took well over 24 hours, but subsequent runs ran over about 20 minutes... -Juan Perin |