Geoff, Steve Callender helped me with the exact same issue a while back. It is a symptom of having a folder shared at a depth that doesn't make sense.
Try: select * from reporter.template_folder where shared is true and parent in (select id from reporter.template_folder where shared is false); And I bet you'll find your culprit. Sincerely, Michael Peters Indiana State Library MIS | Inspire.IN.gov Helpdesk | Evergreen Indiana Helpdesk office - 317.234.2128 email - [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Geoff Sams Sent: Monday, January 23, 2012 3:56 PM To: Evergreen Development Discussion List Subject: [OPEN-ILS-DEV] FW: FW: [OPEN-ILS-GENERAL] shared report templates don't display correctly for one location Okay, I have been having trouble getting any info on this issue, and any direction would be useful. I'll try to recap what the issue is up here, but the full detail is below. We have been having an issue since migrating to 2.0.9 from 1.6.0.3 that has caused only one library to have an issue in the reports section of Evergreen that is represented in the Reports.jpg attached to this email. When the workstation is registered with that library, it shows only pages where it should show folders. All other registrations at other libraries show what is in Reports-Correct.jpg. We checked to make sure our hierarchy was sane, and ran autogen.sh to no effect. We are at a loss here as to what might be causing this issue at this point. Any help or advice as to where to look for the problem would be greatly appreciated. Thanks, Geoff Sams Roanoke Public Library 817-491-2691 Chairman North Texas Library Consortium Board -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Geoff Sams Sent: Thursday, January 05, 2012 1:53 PM To: [email protected] Subject: [OPEN-ILS-DEV] FW: [OPEN-ILS-GENERAL] shared report templates don't display correctly for one location Okay, after giving general a try and getting nothing I wanted to try the technical discussion and see if anyone could help with this. We are currently running 2.0.10 and could use all the help we can get with this one. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Geoff Sams Sent: Thursday, December 15, 2011 1:30 PM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] shared report templates don't display correctly for one location We've given the suggested method a try and I'm afraid there has been no change. I sent out an email with a screenshot of the problem not long ago in hopes that someone would be able to help with the issue, but I'm afraid it may have gotten lost in transit. So here they are again, the image marked Reports.jpg is what we are seeing from a workstation registered at the library that reported the issue, the other Reports-Correct.jpg is what we should be seeing, and can see via all other registered locations in the system. Thanks, Geoff Sams Assistant Director Roanoke Public Library 817-491-2691 Chairman North Texas Library Consortium Board -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Thomas Berezansky Sent: Wednesday, December 07, 2011 7:54 PM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] shared report templates don't display correctly for one location autogen.sh (more accurate, /openils/bin/autogen.sh I believe) would be run as the opensrf user. I believe it can cause momentary issues if run during the day, although with 14 libraries I wouldn't see that as being excessively important. I don't think you would need to restart anything server-side, but I would restart the affected client(s). Thomas Berezansky Merrimack Valley Library Consortium Quoting Jesse Ephraim <[email protected]>: > Thomas; > > Should we run it as non-admin, OpenSRF, or root? > > Should we run "configure" after that? > > Is it something we should do after hours, when the libraries are > closed (we have 14 libraries on the system)? > > Will it need a server restart, or a restart of anything else? > > Jesse Ephraim > > Director, Roanoke Public Library > 308 S. Walnut > Roanoke, Texas 76262 > (817) 491-2691 > [email protected] > > > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf > Of Thomas Berezansky > Sent: Wednesday, December 07, 2011 3:43 PM > To: Evergreen Discussion Group > Subject: Re: [OPEN-ILS-GENERAL] shared report templates don't display > correctly for one location > > The only thing I could recommend is checking that your org tree is sane. > > That is, the hierarchy of org units matches the hierarchy of their types. > > Then run autogen.sh again either way. > > Thomas Berezansky > Merrimack Valley Library Consortium > > > Quoting Geoff Sams <[email protected]>: > >> I'm going to bump this because it is a really strange occurrence and >> any help on the subject would be greatly appreciated. If any more >> information is necessary please let me know. >> >> Thanks, >> Geoff Sams >> Assistant Director >> Roanoke Public Library >> 817-491-2691 >> Chairman >> North Texas Library Consortium Board >> >> From: [email protected] >> [mailto:[email protected]] On Behalf >> Of Judy Daniluk >> Sent: Thursday, December 01, 2011 4:53 PM >> To: Evergreen Discussion Group >> Subject: [OPEN-ILS-GENERAL] shared report templates don't display >> correctly for one location >> >> One library in our consortium is having trouble seeing shared report >> templates. When you use the staff client as a workstation registered >> at this library, the list of shared report templates is incomplete - >> some folders show a truncated list of pages, some folders are >> displayed as pages instead of folders, some folders don't show up at >> all. The folders that don't display are shared consortium-wide, so >> they should be available. It happens for all the staff users at this >> location. >> >> We recently moved our Evergreen installation to a different server >> and upgraded from 1.6 to 2.0.9. These users were able to see and >> use all the shared report templates before the move and upgrade. The >> problem appeared after the move and the upgrade, and has persisted >> for three months, through many reboots and restarts. >> >> If you use the same userid but a workstation registered for a >> different org unit (even if it's actually the same computer), the >> shared templates display correctly. It's not related to the user's >> permission group or the user's home library or the user's working >> location, just the location where the workstation is registered. >> >> Any suggestions? >> >> >> Judy Daniluk >> >> Director of Internet Services, North Texas Library Partners >> >> 6320 Southwest Blvd., Suite 101, Fort Worth, TX 76109 >> >> [email protected]<mailto:[email protected]> 817-201-6778 >> (cell) www.ntxlibpartners.org<http://www.ntxlibpartners.org> >> >> > > >
