Re: [UrbanSim-Users] Problem caching table households from database...

Thanks Hana.

The problem was null values in various places in our baseyear database.

Brian

On Aug 2, 2007, at 1:14 PM, Hana Sevcikova wrote:

> Brian,
>
> This usually happens when there are some invalid values in the
> table, such
> as NULLs.
>
> To see in what column the code breaks, please add this line
>
> print column_name
>
> just before the following line (line 101)
> result[column_name] = array(values, dtype=dtype)
>
> in opus_core/store/mysql_storage.py
>
> Then look at the values of that column in the households table, if
> you see
> anything suspicious.
>
> I will go ahead and put in the code some reasonable error message
> for such
> cases.
>
> Hana
>
>
> On Thu, 2 Aug 2007, Brian Miles wrote:
>
>>
>> Hello,
>>
>> I'm in the process of upgrading to the July 3rd release of Opus
>> (from the
>> April 4.1.0513 release). I've run into a "ValueError: setting an
>> array
>> element with a sequence." while running
>> opus_core/tools/create_baseyear_cache.py.
>>
>> The relevant portion of the output is below. Please let me know
>> if you need
>> more information.
>>
>> Thanks,
>>
>> Brian Miles
>> Graduate Assistant
>> Spatial Analysis Lab - Rubenstein School of Environment and
>> Natural Resources
>> University of Vermont
>>
>> -----------
>>
>> Caching table households: started on Thu Aug 02 18:38:26
>> 2007....1.3
>> sec
>>
>> ERROR: Problem caching table households from database
>> localhost.chittco_
>> 1990_baseyear
>> Running opus_core.cache.cache_mysql_data.CacheMysqlData:
>> completed...14.6
>> se
>> c
>> Running urbansim.model_coordinators.cache_mysql_data.CacheMysqlData:
>> completed..
>> .14.7 sec
>> Traceback (most recent call last):
>> File "create_baseyear_cache.py", line 74, in ?
>> cache_dir = cacher.run(config)
>> File "create_baseyear_cache.py", line 45, in run
>> CacheMysqlData().run(config)
>> File "C:\myworkspace\opus_core\model.py", line 48, in
>> logged_run_method
>> results = run_method(*req_args, **opt_args)
>> File "C:\myworkspace\opus_core\configurable.py", line 38, in
>> config_run_method
>>
>> results = run_method(*req_args, **opt_args)
>> File "C:\myworkspace\urbansim\model_coordinators
>> \cache_mysql_data.py", line
>> 74
>> , in run
>> CoreCacheMysqlData().run(config)
>> File "C:\myworkspace\opus_core\model.py", line 48, in
>> logged_run_method
>> results = run_method(*req_args, **opt_args)
>> File "C:\myworkspace\opus_core\configurable.py", line 38, in
>> config_run_method
>>
>> results = run_method(*req_args, **opt_args)
>> File "C:\myworkspace\opus_core\cache\cache_mysql_data.py", line
>> 49, in run
>> self.cache_database_tables(config, input_db)
>> File "C:\myworkspace\opus_core\cache\cache_mysql_data.py", line
>> 59, in
>> cache_d
>> atabase_tables
>> self.cache_database_table(table_name, input_db, config
>> ['base_year'],
>> config)
>>
>> File "C:\myworkspace\opus_core\cache\cache_mysql_data.py", line
>> 97, in
>> cache_d
>> atabase_table
>> id_name = id_name)
>> File "C:\myworkspace\opus_core\datasets\dataset.py", line 89, in
>> __init__
>> debug = debug)
>> File "C:\myworkspace\opus_core\datasets\abstract_dataset.py",
>> line 140, in
>> __i
>> nit__
>> self.load_dataset(attributes=[self._primary_attribute_names[0]])
>> File "C:\myworkspace\opus_core\datasets\dataset.py", line 219, in
>> load_dataset
>>
>> id_name = self.get_non_hidden_id_name())
>> File "C:\myworkspace\opus_core\store\mysql_chain_storage.py",
>> line 47, in
>> load
>> _table
>> return mysql_storage_for_database.load_table(table_name,
>> column_names=column
>> _names, lowercase=lowercase, id_name=id_name)
>> File "C:\myworkspace\opus_core\store\mysql_storage.py", line 101, in
>> load_tabl
>> e
>> result[column_name] = array(values, dtype=dtype)
>> ValueError: setting an array element with a sequence.
>>
>>
>>
>>
>>
>>
>>
Received on Thu Aug 02 2007 - 13:35:10 PDT