Re: [Gusdev-gusdev] LoadTaxon plugin

[pjm <pj...@sa...>]

Steve,

I tried your instructions and did a: `ga +meta --commit`
Arnaud has setup the DB so maybe he knows why - I needed to create a record in
the MACHINE table so I created the following SQL;

INSERT INTO MACHINE
       (MACHINE_ID,
        NAME,
        CPUS,
        MEMORY,
        MODIFICATION_DATE,
        USER_READ,
        USER_WRITE,
        GROUP_READ,
        GROUP_WRITE,
        OTHER_READ,
        OTHER_WRITE,
        ROW_USER_ID,
        ROW_GROUP_ID,
        ROW_PROJECT_ID,
        ROW_ALG_INVOCATION_ID)
VALUES (0, 'Fake_machine', 1, 1, SYSDATE, 1,1,1,1,1,1,1,1,1,1);

If this is useful I can create a new file called;
	GUS/Model/schema/oracle/core-machine-row.sql
or something. If I shouldn't, please let me know :)
Anyway, creating this record made the `ga +meta --commit` work.

Below is the error message I got when no MACHINE record existed.

pcs2b[pjm]63: ga +meta --commit
Reading properties from /nfs/team81/pjm/.gus.properties
DBD::Oracle::db do failed: ORA-01534: rollback segment 'BIGRBS0' doesn't exist
(DBD ERROR: OCIStmtExecute) at
/nfs/team81/pjm/GUS/lib/perl/GUS/ObjRelP/DbiDatabase.pm line 148.
DBD::Oracle::db do failed: ORA-01534: rollback segment 'BIGRBS0' doesn't exist
(DBD ERROR: OCIStmtExecute) at
/nfs/team81/pjm/GUS/lib/perl/GUS/ObjRelP/DbiDatabase.pm line 148.
DBD::Oracle::db do failed: ORA-01534: rollback segment 'BIGRBS0' doesn't exist
(DBD ERROR: OCIStmtExecute) at
/nfs/team81/pjm/GUS/lib/perl/GUS/ObjRelP/DbiDatabase.pm line 148.
  <Core::Algorithm>
    <name>GA-Plugin</name>
    <description>GUS application framework for plugins</description>
    <Core::AlgorithmImplementation>
      <cvs_revision>1.25</cvs_revision>
      <cvs_tag> </cvs_tag>
      <executable>GUS::PluginMgr::GusApplication</executable>
      <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::st execute failed: ORA-02291: integrity constraint
(CORE.ALGORITHMINVOCATION_FK04) violated - parent key not found (DBD ERROR:
OCIStmtExecute) at /nfs/team81/pjm/GUS/lib/perl/GUS/ObjRelP/DbiDbHandle.pm line
134.

 DbiDbHandle:sqlExec: SQL ERROR!! involving
 
    INSERT INTO Core.AlgorithmInvocation (  end_time, row_user_id, user_write,
group_write, algorithm_implementation_id, row_project_id,
algorithm_invocation_id, group_read, row_group_id, result, other_read,
cpus_used, start_time, modification_date, user_read, row_alg_invocation_id,
other_write, machine_id )
    VALUES   (  sysdate, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, sysdate, SYSDATE, ?,
?, ?, ? ) 
 bindValues (1, 1, 1, 2, 1, 2, 1, 1, meta, 1, 1, 1, 1, 0, 0)



steve fischer wrote:
> 
> arnaud-
> 
> we have fixed this for now by using the oracle-specific 'sysdate' function.
> 
> try this:
>   - cd $PROJECT_HOME/GUS/PluginMgr/lib/perl
>   - cvs update (should bring in a new GusApplication.pm)
>   - build GUS install -append
>   - ga +meta --commit
> 
> steve
> 
> Jonathan Crabtree wrote:
> 
> >
> > steve fischer wrote:
> >
> >>
> >> Jonathan-  is there an easy way in perl to get an oracle compatible
> >> date?
> >>
> >
> > The problem is that you're relying on Oracle's implicit conversion
> > (from a string
> > to a DATE type) which will only work if the format of the provided
> > string matches
> > the default NLS_DATE_FORMAT of the Oracle instance in question.  We
> > should instead
> > use the TO_DATE function to do an explicit conversion from string ->
> > DATE.  Using
> > TO_DATE you can specify the format along with the string, so there's
> > no chance of
> > a mismatch.  Here's the man page for TO_DATE:
> >
> > <http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/server.901/a90125/functions134.htm#1003595>
> >
> >
> > We probably should use something like this:
> >
> > TO_DATE('2002/12/6', 'YYYY/MM/DD')
> >
> > (assuming that the date is December 6th, not June 12th.)
> >
> > Jonathan
> >
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: SlickEdit Inc. Develop an edge.
> The most comprehensive and flexible code editor you can use.
> Code faster. C/C++, C#, Java, HTML, XML, many more. FREE 30-Day Trial.
> www.slickedit.com/sourceforge
> _______________________________________________
> Gusdev-gusdev mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev