Re: Problem caching table households from database...

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 - 10:14:58 PDT