Error when clicking "Calculate Story Points / Time" in Agilo on the old sprint page

[anonymous]

UnableToLoadObjectError: An error occurred while getting ticket from the database: invalid input syntax for integer: "in ()"

Python Traceback
Most recent call last:

    * File "/var/ableton/trac/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/main.py", line 450, in _dispatch_request
      Code fragment:
       445. try:
       446. if not env and env_error:
       447. raise HTTPInternalError(env_error)
       448. try:
       449. dispatcher = RequestDispatcher(env)
       450. dispatcher.dispatch(req)
       451. except RequestDone:
       452. pass
       453. resp = req._response or []
       454.  
       455. except HTTPException, e:
      Local variables:
      Name	Value
      after 	[u' except RequestDone:', u' pass', u' resp = ...
      before 	[u' try:', u' if not env and env_error:', u' raise ...
      dispatcher 	<trac.web.main.RequestDispatcher object at 0xa26aa0c>
      e 	UnableToLoadObjectError(u'An error occurred while getting ticket from the ...
      env 	<trac.env.Environment object at 0x9dfc94c>
      env_error 	None
      exc_info 	(<class 'agilo.core.model.UnableToLoadObjectError'>, ...
      filename 	'/var/ableton/trac/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/w ...
      frames 	[{'function': '_dispatch_request', 'lines_before': [u' try:', u' ...
      has_admin 	True
      line 	u' dispatcher.dispatch(req)'
      lineno 	449
      message 	u'UnableToLoadObjectError: An error occurred while getting ticket from the ...
      req 	<Request "POST u'/oldbacklog/Sprint Backlog/2010-03-22 Incredibles'">
      resp 	[]
      tb 	<traceback object at 0xa28b644>
      tb_hide 	None
      traceback 	u'Traceback (most recent call last):\n File ...
    * File "/var/ableton/trac/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/main.py", line 206, in dispatch
      Code fragment:
       201. req.args.get('__FORM_TOKEN') != req.form_token:
       202. raise HTTPBadRequest('Missing or invalid form token. '
       203. 'Do you have cookies enabled?')
       204.  
       205. # Process the request and render the template
       206. resp = chosen_handler.process_request(req)
       207. if resp:
       208. if len(resp) == 2: # Clearsilver
       209. chrome.populate_hdf(req)
       210. template, content_type = \
       211. self._post_process_request(req, *resp)
      Local variables:
      Name	Value
      chosen_handler 	<agilo.scrum.backlog.web_ui.BacklogDetailView object at 0x9fa7f2c>
      chrome 	<trac.web.chrome.Chrome object at 0x9fb9a4c>
      ctype 	'application/x-www-form-urlencoded'
      e 	InternalError('current transaction is aborted, commands ignored until end ...
      err 	(<class 'agilo.core.model.UnableToLoadObjectError'>, ...
      handler 	<agilo.scrum.backlog.web_ui.BacklogDetailView object at 0x9fa7f2c>
      options 	{}
      req 	<Request "POST u'/oldbacklog/Sprint Backlog/2010-03-22 Incredibles'">
      self 	<trac.web.main.RequestDispatcher object at 0xa26aa0c>
    * File "/var/ableton/trac/lib/python2.5/site-packages/binary_agilo-1.2.1_PRO-py2.5.egg/agilo/api/view.py", line 155, in process_request
      Code fragment:
       150. basically, than send a Command Request to a Controller. The
       151. response has to be rendered according to the view needs."""
       152. try:
       153. handler = self.get_handler(req)
       154. if handler is not None:
       155. return self._call_filters_and_handler(req, handler)
       156. else:
       157. raise TracError('No handler found for method %s' % req.method)
       158. except ICommand.NotValidError, e:
       159. chrome.add_warning(req, unicode(e))
       160. # not that we update the data, so that the set value are
      Local variables:
      Name	Value
      handler 	<bound method BacklogDetailView.do_post of ...
      req 	<Request "POST u'/oldbacklog/Sprint Backlog/2010-03-22 Incredibles'">
      self 	<agilo.scrum.backlog.web_ui.BacklogDetailView object at 0x9fa7f2c>
    * File "/var/ableton/trac/lib/python2.5/site-packages/binary_agilo-1.2.1_PRO-py2.5.egg/agilo/api/view.py", line 143, in _call_filters_and_handler
      Code fragment:
       138. return True
       139.
       140. def _call_filters_and_handler(self, req, handler):
       141. for filter in self.filters:
       142. filter.pre_process_request(req)
       143. data = handler(req) or {}
       144. for filter in self.filters:
       145. filter.post_process_request(req)
       146. return self.respond(data)
       147.
       148. def process_request(self, req):
      Local variables:
      Name	Value
      filter 	<agilo_pro.backlog_in_place_editing.OldBacklogInPlaceEditingInjector ...
      handler 	<bound method BacklogDetailView.do_post of ...
      req 	<Request "POST u'/oldbacklog/Sprint Backlog/2010-03-22 Incredibles'">
      self 	<agilo.scrum.backlog.web_ui.BacklogDetailView object at 0x9fa7f2c>
    * File "/var/ableton/trac/lib/python2.5/site-packages/binary_agilo-1.2.1_PRO-py2.5.egg/agilo/scrum/backlog/web_ui.py", line 834, in do_post
      Code fragment:
       829. elif req.args.has_key('remove'):
       830. self._perform_action(req, backlog, 'remove', data)
       831. elif req.args.has_key('delete'):
       832. self._perform_action(req, backlog, 'delete', data)
       833. elif req.args.has_key('calculate'):
       834. self._perform_action(req, backlog, 'calculate', data)
       835. elif req.args.has_key('confirm'):
       836. self._perform_action(req, backlog, 'confirm', data)
       837.
       838. # Send data
       839. self._do_show(req, data, backlog)
      Local variables:
      Name	Value
      backlog 	<agilo.scrum.backlog.model.Backlog object at 0xa7e914c>
      data 	{'closed_tickets': 0, 'my_tickets': 0}
      req 	<Request "POST u'/oldbacklog/Sprint Backlog/2010-03-22 Incredibles'">
      self 	<agilo.scrum.backlog.web_ui.BacklogDetailView object at 0x9fa7f2c>
    * File "/var/ableton/trac/lib/python2.5/site-packages/binary_agilo-1.2.1_PRO-py2.5.egg/agilo/scrum/backlog/web_ui.py", line 658, in _perform_action
      Code fragment:
       653. def _perform_action(self, req, backlog, action, data):
       654. """Perform the given do_method action, if allowed, or reload with a
       655. warning if not allowed"""
       656. if self.is_allowed_to(req, backlog, action):
       657. do_action = getattr(self, '_do_' + action)
       658. do_action(req, backlog)
       659. # To make it REST we redirect after the save
       660. params = {'name': backlog.name}
       661. if backlog.scope is not None:
       662. params['scope'] = backlog.scope
       663. self.redirect(req, BacklogDetailView, backlog.name, backlog.scope)
      Local variables:
      Name	Value
      action 	'calculate'
      backlog 	<agilo.scrum.backlog.model.Backlog object at 0xa7e914c>
      data 	{'closed_tickets': 0, 'my_tickets': 0}
      do_action 	<bound method BacklogDetailView._do_calculate of ...
      req 	<Request "POST u'/oldbacklog/Sprint Backlog/2010-03-22 Incredibles'">
      self 	<agilo.scrum.backlog.web_ui.BacklogDetailView object at 0x9fa7f2c>
    * File "/var/ableton/trac/lib/python2.5/site-packages/binary_agilo-1.2.1_PRO-py2.5.egg/agilo/scrum/backlog/web_ui.py", line 485, in _do_calculate
      Code fragment:
       480. def _do_calculate(self, req, backlog):
       481. sprint = BacklogModule(self.env)._get_sprint(req, backlog.scope)
       482. if sprint.team == None:
       483. raise TracError(_('No team selected for this sprint'))
       484. story_ids = self._extract_selected_ticket_ids(req)
       485. stories = self._storylike_tickets_for_ids(story_ids)
       486. if len(stories) == 0:
       487. # TODO: verify this as I submitted a patch... and could be in :-)
       488. # we can't use add_warning here because we do a redirect
       489. # at the end of the request and trac does not provide a
       490. # mechanism to preserve the message for the next page to be
      Local variables:
      Name	Value
      backlog 	<agilo.scrum.backlog.model.Backlog object at 0xa7e914c>
      req 	<Request "POST u'/oldbacklog/Sprint Backlog/2010-03-22 Incredibles'">
      self 	<agilo.scrum.backlog.web_ui.BacklogDetailView object at 0x9fa7f2c>
      sprint 	ValueObject({'end': u'04/01/10 23:00:00', 'description': None, 'exists': ...
      story_ids 	[]
    * File "/var/ableton/trac/lib/python2.5/site-packages/binary_agilo-1.2.1_PRO-py2.5.egg/agilo/scrum/backlog/web_ui.py", line 410, in _storylike_tickets_for_ids
      Code fragment:
       405.
       406. def _storylike_tickets_for_ids(self, story_ids):
       407. storylike_tickets = []
       408. criteria = {
       409. 'id': 'in (%s)' % ', '.join([str(st_id) for st_id in story_ids])}
       410. for ticket in AgiloTicketModelManager(self.env).select(criteria=criteria):
       411. if ticket.is_readable_field(Key.STORY_POINTS):
       412. storylike_tickets.append(ticket)
       413. return storylike_tickets
       414.
       415. def _display_options(self, req):
      Local variables:
      Name	Value
      criteria 	{'id': 'in ()'}
      self 	<agilo.scrum.backlog.web_ui.BacklogDetailView object at 0x9fa7f2c>
      story_ids 	[]
      storylike_tickets 	[]
    * File "/var/ableton/trac/lib/python2.5/site-packages/binary_agilo-1.2.1_PRO-py2.5.egg/agilo/ticket/model.py", line 1227, in select
      Code fragment:
      1222. tickets.append(self.get(**params))
      1223.
      1224. except Exception, e:
      1225. raise UnableToLoadObjectError(_("An error occurred while " \
      1226. "getting ticket from the " \
      1227. "database: %s" % to_unicode(e)))
      1228. return tickets
      1229.
      1230. def select_tickets_having_properties(self, properties,
      1231. criteria=None, order_by=None,
      1232. limit=None, db=None):
      Local variables:
      Name	Value
      criteria 	{'id': 'in ()'}
      cursor 	<trac.db.util.IterableCursor object at 0x9fb922c>
      db 	<trac.db.pool.PooledConnection object at 0xa768414>
      e 	DataError('invalid input syntax for integer: "in ()"\n',)
      filter 	' WHERE ticket.id=%(id)s'
      handle_ta 	True
      limit 	None
      order_by 	None
      self 	<agilo.ticket.model.AgiloTicketModelManager object at 0xa2719ac>
      sql 	'SELECT DISTINCT id, type FROM ticket LEFT OUTER JOIN ticket_custom ON ...
      tickets 	[]
      values 	{'id': 'in ()'}

File "/var/ableton/trac/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/main.py", line 450, in _dispatch_request
  dispatcher.dispatch(req)
File "/var/ableton/trac/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/main.py", line 206, in dispatch
  resp = chosen_handler.process_request(req)
File "/var/ableton/trac/lib/python2.5/site-packages/binary_agilo-1.2.1_PRO-py2.5.egg/agilo/api/view.py", line 155, in process_request
  return self._call_filters_and_handler(req, handler)
File "/var/ableton/trac/lib/python2.5/site-packages/binary_agilo-1.2.1_PRO-py2.5.egg/agilo/api/view.py", line 143, in _call_filters_and_handler
  data = handler(req) or {}
File "/var/ableton/trac/lib/python2.5/site-packages/binary_agilo-1.2.1_PRO-py2.5.egg/agilo/scrum/backlog/web_ui.py", line 834, in do_post
  self._perform_action(req, backlog, 'calculate', data)
File "/var/ableton/trac/lib/python2.5/site-packages/binary_agilo-1.2.1_PRO-py2.5.egg/agilo/scrum/backlog/web_ui.py", line 658, in _perform_action
  do_action(req, backlog)
File "/var/ableton/trac/lib/python2.5/site-packages/binary_agilo-1.2.1_PRO-py2.5.egg/agilo/scrum/backlog/web_ui.py", line 485, in _do_calculate
  stories = self._storylike_tickets_for_ids(story_ids)
File "/var/ableton/trac/lib/python2.5/site-packages/binary_agilo-1.2.1_PRO-py2.5.egg/agilo/scrum/backlog/web_ui.py", line 410, in _storylike_tickets_for_ids
  for ticket in AgiloTicketModelManager(self.env).select(criteria=criteria):
File "/var/ableton/trac/lib/python2.5/site-packages/binary_agilo-1.2.1_PRO-py2.5.egg/agilo/ticket/model.py", line 1227, in select
  "database: %s" % to_unicode(e)))

[Remy Blank]

PluginIssue (AgiloForScrum).

[Martin Häcker <martin.haecker@…>]

@reporter: We need more information on your environemnt to help you debug this. Please contact our support google group to help us debug this. For details see AgiloForScrum.

Thanks!

@rblank: thanks for the heads up! :)