Re: [OPEN-ILS-GENERAL] Upgrading from 2.10 to 2.11 error questions

2017-04-19 Thread Daniel Wells
Hello Jesse,

For your first issue, it appears you have some kind of encoding problem in
some of records.  This is very common for any record with foreign
characters.  Without getting into too much detail, MARC records are
generally supposed to use UTF8 encoding (a modern, universal encoding) or
MARC8 encoding (an older, library-centric standard).  Records will commonly
say they use one encoding but have characters from the other, or use
characters from an entirely different, unsupported encoding (e.g. Latin
1).  I would recommend you try to sort these out eventually, but I don't
think you are doing any additional harm here.

For the 901s update, this update is kinda brute-force, so there is a chance
you will run into table lock problems if anyone else tries to update the
biblio.record_entry table while this is running.  The biblio.record_entry
table doesn't get updated during normal OPAC and circ operations, so if you
can avoid saving records, you should be able to run it while live.  A safer
option (which we typically take) in situations like this is to actually
generate a file where every update is a separate command (UPDATE
biblio.record_entry SET marc = marc where id = 123; UPDATE
biblio.record_entry SET marc = marc where id = 124; ... etc.).  Such a
setup lets it plod along without holding onto multiple rows as the work is
done.  Let me know if you need more guidance in creating such a file.

Also, that upgrade step comes from this feature addition:
https://bugs.launchpad.net/evergreen/+bug/1307553 .  Unless you actively
plan to take advantage of this new source subfield $s, you can delay this
entire command until a more convenient time.  It won't affect any normal
operations to not have that subfield populated.

Sincerely,
Dan

On Wed, Apr 19, 2017 at 4:22 PM, Jesse McCarty 
wrote:

> Hello Everyone,
>
>
>
> We are preparing for our spring upgrade to Evergreen, moving from 2.10.3
> to 2.11.3 and ran into one little bump. As part of the DB upgrade, there is
> an update setting the 901$s for bib records. First question, as seen in the
> attached screen shot, this threw a bunch of ‘no mapping found for….’
> Errors. Can this be safely ignored and proceed with running the system
> after upgrading with no issues (we haven’t seen any issue in our testing)?
>
>
>
> The second, this update seem to take longer than 24 hours.  With that in
> mind would we be able to process the entire upgrade, then use Evergreen in
> daily production while this DB update finishes in the background? Or does
> this need to be 100% complete before allowing library’s connection to the
> system?
>
>
>
> Thanks in advance,
>
>
>
> Jesse McCarty
>
> City of Burlington
>
> IT Technical Assistant
>
>
>


[OPEN-ILS-GENERAL] Upgrading from 2.10 to 2.11 error questions

2017-04-19 Thread Jesse McCarty
Hello Everyone,

We are preparing for our spring upgrade to Evergreen, moving from 2.10.3 to 
2.11.3 and ran into one little bump. As part of the DB upgrade, there is an 
update setting the 901$s for bib records. First question, as seen in the 
attached screen shot, this threw a bunch of 'no mapping found for' Errors. 
Can this be safely ignored and proceed with running the system after upgrading 
with no issues (we haven't seen any issue in our testing)?

The second, this update seem to take longer than 24 hours.  With that in mind 
would we be able to process the entire upgrade, then use Evergreen in daily 
production while this DB update finishes in the background? Or does this need 
to be 100% complete before allowing library's connection to the system?

Thanks in advance,

Jesse McCarty
City of Burlington
IT Technical Assistant



Re: [OPEN-ILS-GENERAL] Renew Privilege

2017-04-19 Thread Chris Sharp
As far as I can tell, there's not a way to get that information from
Evergreen reports.  You could do something like this to get a list of
updated accounts from the previous day if you have direct access to the
database server (which uses the auditor schema that tracks changes like
that):

select u.id as "User ID", aauh.expire_date as "Old Expire Date",
u.expire_date as "New Expire Date" from auditor.actor_usr_history aauh join
actor.usr u on (u.id = aauh.id) where date(aauh.audit_time) = date(now() -
'1 day'::interval) and aauh.expire_date <> u.expire_date;

If you just want a count, just change the above to "select count(*)
from...".

Hope that's helpful!

Chris



On Tue, Apr 18, 2017 at 1:27 PM, Carol Yarrison 
wrote:

> I would also like this information.
>
> Carol
>
> On Tue, Apr 18, 2017 at 11:11 AM, Elizabeth Davis 
> wrote:
>
>> Hello
>>
>> Has anyone created a report counting how many users renewed their
>> privilege in a time frame?
>>
>> I was looking at the Action Trigger and User Activity Sources, but my
>> investigating didn’t show any links to that information.
>>
>>
>>
>> Thanks,
>>
>>
>>
>> Elizabeth Davis
>>
>> Head of Digital Services
>>
>> Scranton Public Library
>>
>> 500 Vine Street
>>
>> Scranton, PA 18509
>>
>> 570-348-3000 ext. 3050 <(570)%20348-3000>
>>
>> eda...@albright.org
>>
>>
>>
>
>
>
> --
> “What in the world would we do without our libraries?”
> ― Katharine Hepburn
> 
>
> Carol Yarrison
> Help Desk Coordinator/Trainer
> Bibliomation, Inc
> 24 Wooster Ave
> Waterbury, CT
> 203-577-4070 x112 <(203)%20577-4070>
>



-- 
Chris Sharp
PINES System Administrator
Georgia Public Library Service
1800 Century Place, Suite 150
Atlanta, Georgia 30345
(404) 235-7147