id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
16265	DatabaseError: ORA-01403: no data found on Oracle	Tiziano	nobody	"We had a strange problem today: filtering on a model on an object resulted in an ORA-01403: no data found (we use Oracle 11g). Objects is there indeed.

We found the problem to be a lob field (not in the where conditions at all!) that contained a particular log of our application (maybe some content to be escaped??). We updated with a blank value and now all the filtering works. Do you know if this could be a known bug and how can be corrected for future?

This is the code and the traceback for reference:

>>> us=MyModel.objects.filter(pk=123456)
>>> print us
Traceback (most recent call last):
  File ""<console>"", line 1, in <module>
  File ""/usr/lib/python2.5/site-packages/Django-1.1-py2.5.egg/django/db/models/query.py"", line 68, in __repr__
    data = list(self[:REPR_OUTPUT_SIZE + 1])
  File ""/usr/lib/python2.5/site-packages/Django-1.1-py2.5.egg/django/db/models/query.py"", line 83, in __len__
    self._result_cache.extend(list(self._iter))
  File ""/usr/lib/python2.5/site-packages/Django-1.1-py2.5.egg/django/db/models/query.py"", line 238, in iterator
    for row in self.query.results_iter():
  File ""/usr/lib/python2.5/site-packages/Django-1.1-py2.5.egg/django/db/models/sql/query.py"", line 298, in results_iter
    row = self.resolve_columns(row, fields)
  File ""/usr/lib/python2.5/site-packages/Django-1.1-py2.5.egg/django/db/backends/oracle/query.py"", line 53, in resolve_columns
    values.append(self.convert_values(value, field))
  File ""/usr/lib/python2.5/site-packages/Django-1.1-py2.5.egg/django/db/backends/oracle/query.py"", line 58, in convert_values
    value = value.read()
DatabaseError: ORA-01403: no data found


Thanks in advance to all!"	Uncategorized	new	Database layer (models, ORM)	1.1	Normal				Unreviewed	0	0	0	0	0	0