search

rhodges / oregon-marinemap

Automatically exported from code.google.com/p/oregon-marinemap
0 stars 0 forks source link

Intermittent AOI excel report failure #91

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Only seems to happen with AOI 1030 on narwhal. Something to do with excel row 
formatting in omm/analysis/excel/biology.py around line 101

====================================
Request Method: GET
Request URL: http://narwhal.marinemap.org/analysis/nsh/excel_report/1030/all

Traceback:
File "/usr/local/src/django/django/core/handlers/base.py" in get_response
  111.                         response = callback(request, *callback_args, **callback_kwargs)
File "/usr/local/marinemap-src/oregon-marinemap/omm/analysis/views.py" in 
excel_nsh_report
  30.     return excel_report(request, nsh, type)
File 
"/usr/local/marinemap-src/oregon-marinemap/omm/analysis/nsh/nsh_analysis.py" in 
excel_report
  57.     excel_doc = generate_nsh_excel_doc(context)
File "/usr/local/marinemap-src/oregon-marinemap/omm/analysis/nsh/nsh_excel.py" 
in generate_nsh_excel_doc
  16.     generate_bio_sheet(wb, bio_context)
File "/usr/local/marinemap-src/oregon-marinemap/omm/analysis/nsh/nsh_excel.py" 
in generate_bio_sheet
  31.     populate_bio_sheet(ws, bio_context)
File 
"/usr/local/marinemap-src/oregon-marinemap/omm/analysis/nsh/nsh_excel_bio.py" 
in populate_bio_sheet
  12.     bio_subtidal_data(ws, context)
File "/usr/local/marinemap-src/oregon-marinemap/omm/analysis/excel/biology.py" 
in bio_subtidal_data
  101.     ws.write(row, 2, context['green_sturgeon'], data_style)
File "/usr/local/lib/python2.6/dist-packages/xlwt/Worksheet.py" in write
  1003.         self.row(r).write(c, label, style)
File "/usr/local/lib/python2.6/dist-packages/xlwt/Row.py" in write
  231.                     StrCell(self.__idx, col, style_index, self.__parent_wb.add_str(label))
File "/usr/local/lib/python2.6/dist-packages/xlwt/Row.py" in insert_cell
  150.                 raise Exception(msg)

Exception Type: Exception at /analysis/nsh/excel_report/1030/all
Exception Value: Attempt to overwrite cell: sheetname=u'Biology' rowx=15 colx=2 
======================================================

Original issue reported on code.google.com by perrygeo...@gmail.com on 26 Apr 2011 at 7:54