Can't Generate Printable Gradebook Worksheet

[Rena Willis]

I receive this error when logged in as a teacher trying to generate a printable worksheet from the gradebook. While in IE I simply receive the error. When in Firefox, another window pops up that I am unable to type into that says I do not have access and asks me to login as a user with access. Both generate this error:

System failure while generating PY2A gradebook. Ticket nr. 50868edd-f2ad-4edb-a713-78416dc9805d.
Please contact your administrator.

If you could point me in the right direction I'd appreciate it.
Thanks,
Rena

[Tom Hoffman (tom-hoffman)]

Hi Rena,

Please attach the error log and server status as described here: http://book.schooltool.org/troubleshooting.html

[Rena Willis (rwillis)]

Tom,
The server status is as follows:

schooltool RUNNING pid 21748, uptime 15 days, 2:38:49
services:celery_report RUNNING pid 21747, uptime 15 days, 2:38:49
services:redis RUNNING pid 21745, uptime 15 days, 2:38:49
services:zeo RUNNING pid 21746, uptime 15 days, 2:38:49

and attached is the error log generated when I try to generate a printable gradebook worksheet.

Thanks!
Rena

[Rena Willis (rwillis)]

Hey Guys,

I am still getting errors when trying to run reports. Only a few reports will actually run. Here is a copy of the error message I received when trying to run the section "Roster" report and the student detail report. In the message above I sent the server status and the error log for the last report. I can do the same for these reports if you need. Let me know.

Feels like a permissions issue... but I'm not sure where to start.

Thanks for your help.

System failure while generating section Artes Plásticas 7A roster. Ticket nr. b9ee7c33-a8be-4122-b624-37e39500d922.

Please contact your administrator.
  2014-07-23 14:35

 System failure while generating Students detail report. Ticket nr. fc3301ec-8d7d-4321-98e1-33c911ddf898.

Please contact your administrator.
  2014-07-23 14:33

[Douglas Cerna (replaceafill)]

Hi Rena.

Could you please attach the paste.log and celery_report.log files?

Thanks.

[Gediminas Paulauskas (menesis)]

Unfortunately, report (and export) generation errors do not end up in log files.

When you see "System failure... ticket nr."

log in as manager and go to Server > Server Information > Scheduled tasks. And click on a task whose status is failed or pending. The interesting information there is Exception and Traceback, please post it here.

[Rena Willis (rwillis)]

Here is the information from the "Server/Server Information/Scheduled Tasks/" failure report:

ID

1f3f6483-d81b-44d1-bd8b-9245bd2876c7

Failed
Traceback Traceback (most recent call last): File "/usr/lib/python2.7/dist-packages/celery/execute/trace.py", line 181, in trace_task R = retval = fun(*args, **kwargs) File "/usr/lib/python2.7/dist-packages/schooltool/task/tasks.py", line 231, in __call__ raise failure FormattedTraceback:
Exception
'Ubuntu_Regular'

Traceback
File "/usr/lib/python2.7/dist-packages/schooltool/task/tasks.py", line 184, in runTransaction
  result = callable(*args, **kw)
File "/usr/lib/python2.7/dist-packages/schooltool/report/report.py", line 450, in execute
  report_file = self.renderToFile(renderer, *args, **kwargs)
File "/usr/lib/python2.7/dist-packages/schooltool/report/report.py", line 499, in renderToFile
  self.renderReport(renderer, stream, *args, **kw)
File "/usr/lib/python2.7/dist-packages/schooltool/report/report.py", line 541, in renderReport
  rml = renderer.render()
File "/usr/lib/python2.7/dist-packages/schooltool/skin/flourish/page.py", line 54, in render
  return self.template(*args, **kw)
File "/usr/lib/python2.7/dist-packages/zope/browserpage/viewpagetemplatefile.py", line 81, in __call__
  return self.im_func(im_self, *args, **kw)
File "/usr/lib/python2.7/dist-packages/zope/browserpage/viewpagetemplatefile.py", line 49, in __call__
  sourceAnnotations=getattr(debug_flags, 'sourceAnnotations', 0),
File "/usr/lib/python2.7/dist-packages/zope/pagetemplate/pagetemplate.py", line 132, in pt_render
  strictinsert=0, sourceAnnotations=sourceAnnotations
Template "/usr/lib/python2.7/dist-packages/schooltool/skin/flourish/rml/pdf.pt"
File "/usr/lib/python2.7/dist-packages/zope/pagetemplate/pagetemplate.py", line 241, in __call__
  interpreter()
File "/usr/lib/python2.7/dist-packages/zope/tal/talinterpreter.py", line 271, in __call__
  self.interpret(self.program)
File "/usr/lib/python2.7/dist-packages/zope/tal/talinterpreter.py", line 343, in interpret
  handlers[opcode](self, args)
File "/usr/lib/python2.7/dist-packages/zope/tal/talinterpreter.py", line 533, in do_optTag_tal
  self.do_optTag(stuff)
File "/usr/lib/python2.7/dist-packages/zope/tal/talinterpreter.py", line 518, in do_optTag
  return self.no_tag(start, program)
File "/usr/lib/python2.7/dist-packages/zope/tal/talinterpreter.py", line 513, in no_tag
  self.interpret(program)
File "/usr/lib/python2.7/dist-packages/zope/tal/talinterpreter.py", line 343, in interpret
  handlers[opcode](self, args)
File "/usr/lib/python2.7/dist-packages/zope/tal/talinterpreter.py", line 533, in do_optTag_tal
  self.do_optTag(stuff)
File "/usr/lib/python2.7/dist-packages/zope/tal/talinterpreter.py", line 518, in do_optTag
  return self.no_tag(start, program)
File "/usr/lib/python2.7/dist-packages/zope/tal/talinterpreter.py", line 513, in no_tag
  self.interpret(program)
File "/usr/lib/python2.7/dist-packages/zope/tal/talinterpreter.py", line 343, in interpret
  handlers[opcode](self, args)
File "/usr/lib/python2.7/dist-packages/zope/tal/talinterpreter.py", line 852, in do_condition
  self.interpret(block)
File "/usr/lib/python2.7/dist-packages/zope/tal/talinterpre...

[Tom Hoffman (tom-hoffman)]

I'd start by trying "sudo apt-get install ttf-ubuntu-font-family"

[Gediminas Paulauskas (menesis)]

Thank you. It shows that the font "Ubuntu" cannot be found. If so, no other report would work.

# See if it is installed

$ ls -1 /usr/share/fonts/truetype/ubuntu-font-family
Ubuntu-BI.ttf
Ubuntu-B.ttf
Ubuntu-C.ttf
Ubuntu-LI.ttf
Ubuntu-L.ttf
Ubuntu-MI.ttf
UbuntuMono-BI.ttf
UbuntuMono-B.ttf
UbuntuMono-RI.ttf
UbuntuMono-R.ttf
Ubuntu-M.ttf
Ubuntu-RI.ttf
Ubuntu-R.ttf

# No such file or directory?

$ sudo apt-get install ttf-ubuntu-font-family

# Check configuration file

$ grep '^reportlab_fontdir' /etc/schooltool/standard/schooltool.conf
reportlab_fontdir /usr/share/fonts/truetype/liberation:/usr/share/fonts/truetype/ubuntu-font-family

# Restart schooltool

$ sudo service schooltool restart