[OPEN-ILS-GENERAL] Report View error

[Araik Manukyan]

Dear June,
Thank you for your quick response.

We have enabled the Reporter Daemon service through **clark-kent.pl --daemon** command and it works now.

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. 
-----------

Attached you can find the Report output sceenshot.
 
Any ideas?
Thanks in advanc, 
Arayik.
  ----- Original Message ----- 
  From: Rayner, June 
  To: Evergreen Discussion Group 
  Sent: Friday, January 13, 2012 5:58 AM
  Subject: Re: [OPEN-ILS-GENERAL] Report View error


  Hi Aarayik

   

  When I've seen this, it's because the report itself didn't run, so it did not create the result file.    Do you see any other error messages?

   

  Alternatively, you might look at using the PostgreSQL ODBC driver.    We've done some reports that way.   

   

  Hope that helps

   

  June

   

  From: open-ils-general-bounces at list.georgialibraries.org [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of Araik Manukyan
  Sent: Friday, January 13, 2012 3:43 AM
  To: open-ils-general at list.georgialibraries.org
  Subject: [OPEN-ILS-GENERAL] Report View error

   

  Dear Evergreen community,

   

  We employ Evergreen 2.09 on our Linux running servers.
  While trying to export our patron lists or bibliographic records through Admin>Local Administration> Reports, we encountered some difficulties.

  The problem is that after creating a report on stuff client we are not able to View it, although Stuff client says that the document was created successfully.

  The server responses with this error.

  *************************************************************
  The requested URL /reporter/1/5/5/report-data.html was not found on this server. 
  **************************************************************

  In fact, there is no such directory in

  **/openils/var/web/reporter/1/1/1/report-data.html**. 
  We have even created a *reporter* folder in /openils/var/web/ directory and made it writable by everyone. However, the problem was not fixed.

  In addition, we know that there is another way to export the necessary data through postgre SQL commands. Can someone hint a useful link or advice on this issue? We need to export our patrons.

  Any advices?


  Arayik.




------------------------------------------------------------------------------

  No virus found in this message.
  Checked by AVG - www.avg.com
  Version: 10.0.1416 / Virus Database: 2109/4145 - Release Date: 01/15/12
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20120117/c2900864/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: error.JPG
Type: image/jpeg
Size: 124376 bytes
Desc: not available
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20120117/c2900864/attachment-0001.jpeg>