Page MenuHomePhabricator

FR-Tech reporting fails with missing categories
Closed, ResolvedPublic

Description

FR-tech reporting has not updated properly on Phlogiston labs since November. When running manually, the following error occurs during reporting (reconstruction runs fine):

[...many rows deleted]
 calculate_velocities 
----------------------
 
(1 row)

COPY 26
COPY 26
COPY 26
COPY 26
COPY 26
COPY 34
Traceback (most recent call last):
  File "phlogiston.py", line 864, in <module>
    main(sys.argv[1:])
  File "phlogiston.py", line 100, in main
    source_title, default_points, project_name_list)
  File "phlogiston.py", line 737, in report
    'zoom_list': tuple(zoom_list)})
psycopg2.ProgrammingError: syntax error at or near ")"
LINE 5: ...                                          AND category IN ()
                                                                      ^


real    61m1.376s
[...]

I think this error has occurred before, but cleary more more error handling and documentation is required. May be related to special characters in reconstruction file?