[kepler-dev] [Bug 4308] New: - Workflow Run Manager - problem with getWorkflowRunsForExecutions in mysql

[bugzilla-daemon at ecoinformatics.org]

http://bugzilla.ecoinformatics.org/show_bug.cgi?id=4308

           Summary: Workflow Run Manager - problem with
                    getWorkflowRunsForExecutions in mysql
           Product: Kepler
           Version: 1.x dev
          Platform: Other
        OS/Version: All
            Status: NEW
          Keywords: REAP
          Severity: normal
          Priority: P2
         Component: general
        AssignedTo: crawl at sdsc.edu
        ReportedBy: barseghian at nceas.ucsb.edu
         QAContact: kepler-dev at kepler-project.org


Dan gets an error from WRM when using a mysql provenance store:

[run] org.kepler.provenance.QueryException: Unable to query workflow runs:
Cannot convert value '0000-00-00 00:00:00' from column 6 to TIMESTAMP.
[run] at
org.kepler.provenance.sql.SQLQueryV8.getWorkflowRunsForExecutions(SQLQueryV8.java:348)

Also, WRM hasn't been tested with mysql for a very long time (just hsql). We
should try to test all functions.