On Dec 7, 2012, at 9:54 AM, Andreas Kuntzagk wrote: > If I click on the small "bug" icon for a dataset in error state, I get this > message in the log: > > URL: http://bbc.mdc-berlin.de/galaxy/dataset/errors?id=e96c6ce43a3d239a > File > '/data/galaxy/galaxy-dist/eggs/Paste-1.6-py2.6.egg/paste/exceptions/errormiddleware.py', > line 143 in __call__ > app_iter = self.application(environ, start_response) > File '/data/galaxy/galaxy-dist/eggs/Paste-1.6-py2.6.egg/paste/recursive.py', > line 80 in __call__ > return self.application(environ, start_response) > File > '/data/galaxy/galaxy-dist/eggs/Paste-1.6-py2.6.egg/paste/httpexceptions.py', > line 632 in __call__ > return self.application(environ, start_response) > File '/data/galaxy/galaxy-dist/lib/galaxy/web/framework/base.py', line 160 in > __call__ > body = method( trans, **kwargs ) > File > '/data/galaxy/galaxy-dist/lib/galaxy/webapps/galaxy/controllers/dataset.py', > line 171 in errors > hda = trans.sa_session.query( model.HistoryDatasetAssociation ).get( id ) > File > '/data/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/orm/query.py', > line 507 in get > return self._get(key, ident) > File > '/data/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/orm/query.py', > line 1500 in _get > return q.all()[0] > File > '/data/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/orm/query.py', > line 1267 in all > return list(self) > File > '/data/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/orm/query.py', > line 1361 in __iter__ > return self._execute_and_instances(context) > File > '/data/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/orm/query.py', > line 1364 in _execute_and_instances > result = self.session.execute(querycontext.statement, params=self._params, > mapper=self._mapper_zero_or_none()) > File > '/data/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/orm/session.py', > line 755 in execute > clause, params or {}) > File > '/data/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/engine/base.py', > line 824 in execute > return Connection.executors[c](self, object, multiparams, params) > File > '/data/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/engine/base.py', > line 874 in _execute_clauseelement > return self.__execute_context(context) > File > '/data/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/engine/base.py', > line 896 in __execute_context > self._cursor_execute(context.cursor, context.statement, > context.parameters[0], context=context) > File > '/data/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/engine/base.py', > line 950 in _cursor_execute > self._handle_dbapi_exception(e, statement, parameters, cursor, context) > File > '/data/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/engine/base.py', > line 931 in _handle_dbapi_exception > raise exc.DBAPIError.instance(statement, parameters, e, > connection_invalidated=is_disconnect) > DataError: (DataError) invalid input syntax for integer: "e96c6ce43a3d239a" > 'SELECT history_dataset_association.id AS history_dataset_association_id, > history_dataset_association.history_id AS > history_dataset_association_history_id, > history_dataset_association.dataset_id AS > history_dataset_association_dataset_id, > history_dataset_association.create_time AS > history_dataset_association_create_time, > history_dataset_association.update_time AS > history_dataset_association_update_time, history_dataset_association.state AS > history_dataset_association_state, > history_dataset_association.copied_from_history_dataset_association_id AS > history_dataset_association_copied_from_history_dataset_a_1, > history_dataset_association.copied_from_library_dataset_dataset_association_id > AS history_dataset_association_copied_from_library_dataset_d_2, > history_dataset_association.hid AS history_dataset_association_hid, > history_dataset_association.name AS history_dataset_association_name, > history_dataset_association.info AS history_dataset_association_info, > history_dataset_associa! tion.blurb AS history_dataset_association_blurb, history_dataset_association.peek AS history_dataset_association_peek, history_dataset_association.tool_version AS history_dataset_association_tool_version, history_dataset_association.extension AS history_dataset_association_extension, history_dataset_association.metadata AS history_dataset_association_metadata, history_dataset_association.parent_id AS history_dataset_association_parent_id, history_dataset_association.designation AS history_dataset_association_designation, history_dataset_association.deleted AS history_dataset_association_deleted, history_dataset_association.purged AS history_dataset_association_purged, history_dataset_association.visible AS history_dataset_association_visible, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_pur! ged, dataset_1.purgable AS dataset_1_purgable, dataset_1.objec! t_store_ id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size \nFROM history_dataset_association LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association.dataset_id \nWHERE history_dataset_association.id = %(param_1)s' {'param_1': u'e96c6ce43a3d239a'} > > > Looks like the id for the dataset is wrong. How can this happen and how can I > fix this? > > regards, Andreas
Hi Andreas, This has been fixed in galaxy-central and will be part of the next distribution release, which is scheduled for next Friday. --nate > > -- > Andreas Kuntzagk > > SystemAdministrator > > Berlin Institute for Medical Systems Biology at the > Max-Delbrueck-Center for Molecular Medicine > Robert-Roessle-Str. 10, 13125 Berlin, Germany > > http://www.mdc-berlin.de/en/bimsb/BIMSB_groups/Dieterich > ___________________________________________________________ > Please keep all replies on the list by using "reply all" > in your mail client. To manage your subscriptions to this > and other Galaxy lists, please use the interface at: > > http://lists.bx.psu.edu/ ___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/
