[kepler-users] Provenance Recorder Error!

[Josep Maria Campanera Alsina]

Hi all and Derik,
Your tip worked but there were neceessary 1000 characters instead of 500. I
executed the following command in case any one else has the same problem:
"alter table workflow_exec MODIFY module_dependencies VARCHAR(1000);"

All the best,

Campa,

2011/1/27 Derik Barseghian <barseghian at nceas.ucsb.edu>

> Hi Joseph,
> This is an issue Dan came across w/ mysql too, and there's currently a note
> in the code to fix it. It doesn't seem to affect hsql. The column should be
> defined as 255 chars now (you can see the definition in Column.java); he
> guesses hsql doesn't enforce this size hence the issue not happening with
> the default provenance store. I've counted one module_dependency list as
> being 389 characters. Yes, changing the size of that column should fix the
> issue. I would change to at least VARCHAR(500). We'll fix this for the next
> provenance module release.
>
> Derik
>
> On Jan 27, 2011, at 12:01 PM, Josep Maria Campanera Alsina wrote:
>
> > Dear all,
> > I've found this error when testing Kepler 2.1 (in Mac 10.6 and Mysql
> > 5.2.31) with R-·D_plot.xml workflow in
> > KeplerData/workflow/module/r-2.1.0/demos/R. This error prevents me to
> > go further with Kepler right now since I cannot execute any workflow
> > with the Provenance recorder turned on. The installation was fine!
> >
> > "ptolemy.kernel.util.IllegalActionException: RecordingException:
> > com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for
> > column 'module_dependencies' at row 1 in
> > .ProvenanceRecorder_Example_1.TOP Provenance Recorder"
> >
> > Do I have to change the definition of the variable
> > "module_dependencies" in MySQL database, VARCHAR(100) or longer? Or
> > this is related to other issues? I haven't found any discussion in the
> > list. Any clue?
> >
> > Congratulations for the new version of Kepler, it really seems an step
> forward!
> >
> > Campa,
> > _______________________________________________
> > Kepler-users mailing list
> > Kepler-users at kepler-project.org
> > http://lists.nceas.ucsb.edu/kepler/mailman/listinfo/kepler-users
>
>


-- 
---------------------------------------------
Josep Maria Campanera Alsina
Professor Lector
Departament de Fisicoquímica
Facultat de Farmàcia
Universitat de Barcelona
Avgda Joan XXIII, s/n
08028 Barcelona
Tel: +34 93 4035985
Fax: +34 93 4035987
campanera at ub.edu
--------------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nceas.ucsb.edu/kepler/pipermail/kepler-users/attachments/20110210/28e04819/attachment.html>