Loading Activity Error

[bryan]

just so you know Gerry: postgres is much less forgiving of strings that are too long:

2010-03-03 16:18:10,858 DEBUG Parsing experiment filename ./data/experiments/1.3_10yr_Hindcast_NoVolc_1960.xml

2010-03-03 16:18:10,867 DEBUG Experiment duration  1960-09-01T00:00:00Z to  1970-12-31T23:59:59Z  (10.0None)

2010-03-03 16:18:10,868 DEBUG Metadata maintainer: Gerard Devine

Traceback (most recent call last):

  File "./py", line 50, in <module>

    execfile(__file__)

  File "setupProto.py", line 32, in <module>

    x=NumericalExperiment(os.path.join(experimentDir, f))

  File "/usr/local/cmip5q/eggs/cmip5q-0.9.2_beta2_r1361-py2.5.egg/cmip5q/XMLActivityReader.py", line 183, in __init__

    E.save()

  File "/usr/local/cmip5q/eggs/cmip5q-0.9.2_beta2_r1361-py2.5.egg/cmip5q/protoq/models.py", line 274, in save

    return Fundamentals.save(self,*args,**kwargs)

  File "/usr/local/cmip5q/eggs/Django-1.1.1-py2.5.egg/django/db/models/base.py", line 410, in save

    self.save_base(force_insert=force_insert, force_update=force_update)

  File "/usr/local/cmip5q/eggs/Django-1.1.1-py2.5.egg/django/db/models/base.py", line 495, in save_base

    result = manager._insert(values, return_id=update_pk)

  File "/usr/local/cmip5q/eggs/Django-1.1.1-py2.5.egg/django/db/models/manager.py", line 177, in _insert

    return insert_query(self.model, values, **kwargs)

  File "/usr/local/cmip5q/eggs/Django-1.1.1-py2.5.egg/django/db/models/query.py", line 1087, in insert_query

    return query.execute_sql(return_id)

  File "/usr/local/cmip5q/eggs/Django-1.1.1-py2.5.egg/django/db/models/sql/subqueries.py", line 320, in execute_sql

    cursor = super(InsertQuery, self).execute_sql(None)

  File "/usr/local/cmip5q/eggs/Django-1.1.1-py2.5.egg/django/db/models/sql/query.py", line 2369, in execute_sql

    cursor.execute(sql, params)

psycopg2.DataError: value too long for type character varying(25)

[bryan]

fix released ... at least for loading ... needs checking.

[sebastien]

Redistribute this ticket which belong to WP6 and the CMIP5 questionnaire

[bryan]

I think we've found most of these, but leave hanging around.