---- Original Message ----- > From: "Araik Manukyan" <[email protected]> > 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>
