On Thu, Nov 18, 2010 at 10:01 AM, SHAUN WEBB <swebb1@staffmail.ed.ac.uk> wrote:

Hi,
I am having a few issues when developing reports.

If I click on jobs per month I get an error

OperationalError: (OperationalError) (1305, 'FUNCTION galaxy_test.date_trunc does not exist')

Full traceback is below. There are similar errors when I click on links for a specific user or tool.

Any idea what the issue is.

Thanks in advance for any help.

Shaun Webb

URL: http://bifx3.bio.ed.ac.uk:9001/jobs/per_month_all
File '/home/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 '/home/galaxy/galaxy_dist/eggs/Paste-1.6-py2.6.egg/paste/debug/prints.py', line 98 in __call__
environ, self.app)
File '/home/galaxy/galaxy_dist/eggs/Paste-1.6-py2.6.egg/paste/wsgilib.py', line 539 in intercept_output
app_iter = application(environ, replacement_start_response)
File '/home/galaxy/galaxy_dist/eggs/Paste-1.6-py2.6.egg/paste/recursive.py', line 80 in __call__
return self.application(environ, start_response)
File '/home/galaxy/galaxy_dist/eggs/Paste-1.6-py2.6.egg/paste/httpexceptions.py', line 632 in __call__
return self.application(environ, start_response)
File '/home/galaxy/galaxy_dist/lib/galaxy/web/framework/base.py', line 145 in __call__
body = method( trans, **kwargs )
File '/home/galaxy/galaxy_dist/lib/galaxy/webapps/reports/controllers/jobs.py', line 251 in per_month_all
for row in q.execute():
File '/home/galaxy/galaxy_dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/sql/expression.py', line 1121 in execute
return e._execute_clauseelement(self, multiparams, params)
File '/home/galaxy/galaxy_dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/engine/base.py', line 1209 in _execute_clauseelement
return connection._execute_clauseelement(elem, multiparams, params)
File '/home/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 '/home/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 '/home/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 '/home/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)
OperationalError: (OperationalError) (1305, 'FUNCTION galaxy_test.date_trunc does not exist') u'SELECT date_trunc(%s, date(job.create_time)) AS date, sum(CASE WHEN (galaxy_user.email = %s) THEN %s ELSE %s END) AS monitor_jobs, count(job.id) AS total_jobs \nFROM job LEFT OUTER JOIN galaxy_user ON galaxy_user.id = job.user_id GROUP BY date_trunc(%s, date(job.create_time)) ORDER BY date DESC' ['month', 'monitor@bx.psu.edu', 1, 0, 'month']

--
The University of Edinburgh is a charitable body, registered in
Scotland, with registration number SC005336.

_______________________________________________
galaxy-dev mailing list
galaxy-dev@lists.bx.psu.edu
http://lists.bx.psu.edu/listinfo/galaxy-dev

--
Ross Lazarus MBBS MPH
Associate Professor, Harvard Medical School
Director of Bioinformatics, Channing Laboratory
181 Longwood Ave., Boston MA 02115, USA.
Tel: +1 617 505 4850