Ticket #674 (new Task)

Opened 9 years ago

Last modified 8 years ago

Loading Activity Error

Reported by: bryan Owned by: gerry
Priority: issue Milestone: V1.2 Questionnaire release
Component: WP6 - CMIP5 Questionnaire Version:
Keywords: Cc: gerry
Requirement: http://metaforclimate.eu/Work-Package-2/Developing-the-CIM/Project-Requirements-summary.htm

Description

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)


Change History

comment:1 Changed 9 years ago by bryan

  • Status changed from new to assigned

comment:2 Changed 9 years ago by bryan

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

comment:3 Changed 8 years ago by sebastien

  • Component changed from WP3 - Service Content Creation & Testing to WP6 - CMIP5 Questionnaire

Redistribute this ticket which belong to WP6 and the CMIP5 questionnaire

comment:4 Changed 8 years ago by bryan

  • Priority changed from blocker to issue
  • Status changed from assigned to new
  • Owner changed from bryan to gerry

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

Note: See TracTickets for help on using tickets.