Comment 2 for bug 1443812

Revision history for this message
Ingeborg Hellemo (ingeborg-hellemo) wrote : Re: [Bug 1443812] Re: Report page crashes with UTF8 in function

Sloppy reporting on my side. Sorry! Do you need even more (META? SETTINGS?)

On NAV-server
py27-psycopg2-2.5.5 High performance Python adapter for PostgreSQL
postgresql93-client-9.3.6_1 PostgreSQL database (client)

On DB-server:
postgresql92-server-9.2.10 The most advanced open-source database
available anywhere

(Can the difference i version between client and server be an issue?)

Tracebak (copy-and-paste view)

Environment:

Request Method: GET
Request URL: https://nav.uit.no/report/netbox?function=Tilh%C3%B8rer%20PET-scan
ner%20for%20dyrefors%C3%B8k

Django Version: 1.4.20
Python Version: 2.7.9
Installed Applications:
('nav.models',
 'nav.django',
 'django.contrib.staticfiles',
 'django.contrib.sessions',
 'django.contrib.humanize',
 'crispy_forms',
 'crispy_forms_foundation',
 'django_hstore',
 'rest_framework')
Installed Middleware:
('django.middleware.common.CommonMiddleware',
 'django.contrib.sessions.middleware.SessionMiddleware',
 'nav.django.auth.AuthenticationMiddleware',
 'nav.django.auth.AuthorizationMiddleware',
 'nav.django.legacy.LegacyCleanupMiddleware',
 'django.contrib.messages.middleware.MessageMiddleware')

Traceback:
File "/usr/local/lib/python2.7/site-packages/django/core/handlers/base.py" in
get_response
  109. response = callback(request, *callback_args,
**callback_kwargs)
File "/usr/local/lib/python2.7/nav/web/report/views.py" in get_report
  77. return make_report(request, report_name, export_delimiter, query)
File "/usr/local/lib/python2.7/nav/web/report/views.py" in make_report
  287. result_time) = _fetch_data_from_db()
File "/usr/local/lib/python2.7/nav/web/report/views.py" in _fetch_data_from_db
  258. CONFIG_FILE_LOCAL, query_dict, None, None))
File "/usr/local/lib/python2.7/nav/report/generator.py" in make_report
  83. dbresult = DatabaseResult(config)
File "/usr/local/lib/python2.7/nav/report/dbresult.py" in __init__
  49. database.execute(self.sql)

Exception Type: DataError at /report/netbox
Exception Value: invalid byte sequence for encoding "UTF8": 0xf8