[OPEN-ILS-GENERAL] Report View error

[Aaron Zsembery]

---- Original Message ----- 
> From: "Araik Manukyan" <araik at flib.sci.am>
> However, when we try export ILC Users report, the Evergreen responses
> with this error text
> -------------
> DBD::Pg::st execute failed: ERROR: column
> fe21ca9ecd516f33ec379ecc11aa7051.groups does not exist LINE 2:
> "fe21ca9ecd516f33ec379ecc11aa7051"."groups" AS "Additional ... ^ at
> /openils/bin/clark-kent.pl line 217.
> -----------
That would indicate that you have a problem with your template, namely, it cannot find the column "groups" in the database table "fe21ca9ecd516f33ec379ecc11aa7051".
If you click on the "Debugging Info" link from the report page, there should be a "Generated SQL" section. In there where should be a "FROM" statement with a bunch of "LEFT OUTER JOIN" and other "JOIN" statments. They will each have a table name after the JOIN along with an AS. One of the text strings after the AS should match the one you posted above.
For example, one of our reports has the following:
FROM	reporter.overdue_circs AS "c8a790b472655be78d781328a75d9fb5"
	LEFT OUTER JOIN asset.copy AS "4dea4106377793e92f172d1c616f01d1"
That should let you see which table and column it cannot find.

If you have SQL access, you should be able to copy/paste the whole "Generated SQL" section and run that as a query to get the same data as the report will give you.

HTH

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260>