Authority search problems in Koha 3.2, ZOOM error 20003
Greetings all, We did a bulk import of biblios, and then a bulk import of name authorities, Then we ran link_bibs_to_authorities.pl , and finally ran the zebra. Sometime after that we had to reboot the server as something else was causing it to run very slowly. Have we missed any steps in this process? Two possibly? related problems occurred with authorities. 1) The authorities don't seem to have linked to the bibs. 2) Trying to figure out why, I created a new biblio, so we could see where the link is broken in our imported records. I was editing the new record, and asked it to search the authorities for a name (one that isn't in the authorities file, as it happens) in the 100 field. This popped up: ZOOM error 20003 "can't set prefix query" (addinfo: "@or @attr 7=1 @attr 1=Heading 0 @and @attr 1=authtype @attr 5=100 PERSO_NAME @attr 1=Heading @attr 5=1 @attr 4=6 "Maxwell, Robert L.," @attr 1=Heading @attr 5=1 @attr 4=6 "1957- "") from diag-set 'ZOOM' For help, please send mail to the webmaster (webmaster@efdss.org), giving this error message and the time and date of the error. My webmaster doesn't know what this means. I've found multiple bug listings for ZOOM error 20003- I think this is the latest. http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3386 We've got the candidate release of 3.2 installed - do I still need the patch? Does this error message have anything to do with the fact that the links aren't working? As far as I can tell, the MARC framework for the 100 field is set correctly. Thanks again -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 ext 36 Mob +44 (0) 7789 373982 -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
Elaine, We have seen this on one of our systems when the subfield d in the authority is used for date range. I believe that Colin Campbell has been looking at it. I will let Colin (or anyone else) comment on what the solution might be, but thought it worth mentioning you are not alone and I don't think you missed a step. Ian On 14/10/2010 10:51, Elaine Bradtke wrote:
Greetings all,
We did a bulk import of biblios, and then a bulk import of name authorities, Then we ran link_bibs_to_authorities.pl , and finally ran the zebra. Sometime after that we had to reboot the server as something else was causing it to run very slowly. Have we missed any steps in this process?
Two possibly? related problems occurred with authorities. 1) The authorities don't seem to have linked to the bibs. 2) Trying to figure out why, I created a new biblio, so we could see where the link is broken in our imported records. I was editing the new record, and asked it to search the authorities for a name (one that isn't in the authorities file, as it happens) in the 100 field. This popped up:
ZOOM error 20003 "can't set prefix query" (addinfo: "@or @attr 7=1 @attr 1=Heading 0 @and @attr 1=authtype @attr 5=100 PERSO_NAME @attr 1=Heading @attr 5=1 @attr 4=6 "Maxwell, Robert L.," @attr 1=Heading @attr 5=1 @attr 4=6 "1957- "") from diag-set 'ZOOM' For help, please send mail to the webmaster (webmaster@efdss.org), giving this error message and the time and date of the error.
My webmaster doesn't know what this means. I've found multiple bug listings for ZOOM error 20003- I think this is the latest. http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3386
We've got the candidate release of 3.2 installed - do I still need the patch? Does this error message have anything to do with the fact that the links aren't working? As far as I can tell, the MARC framework for the 100 field is set correctly. Thanks again
-- Ian Bays Director of Projects PTFS Europe.com mobile: +44 (0) 7774995297 phone: +44 (0) 800 756 6803 skype: ian.bays email: ian.bays@ptfs-europe.com
You're absolutely correct, I tried the search again without the $d (date) and it worked. I still don't understand why my uploaded authorities aren't linking. Maybe whatever was hanging up the server interfered with the link process? At any rate, we're going to start again from scratch tonight. The uploaded records don't have subfield d in them, so at least that's not part of the problem. I'm supposed to demonstrate the wonders of Koha to the advisory committee tomorrow. I must say, it looks impressive, even if it's not all there yet! On Thu, Oct 14, 2010 at 11:18 AM, Ian Bays <ian.bays@ptfs-europe.com> wrote:
Elaine, We have seen this on one of our systems when the subfield d in the authority is used for date range. I believe that Colin Campbell has been looking at it. I will let Colin (or anyone else) comment on what the solution might be, but thought it worth mentioning you are not alone and I don't think you missed a step. Ian On 14/10/2010 10:51, Elaine Bradtke wrote:
Greetings all,
We did a bulk import of biblios, and then a bulk import of name authorities, Then we ran link_bibs_to_authorities.pl , and finally ran the zebra. Sometime after that we had to reboot the server as something else was causing it to run very slowly. Have we missed any steps in this process?
Two possibly? related problems occurred with authorities. 1) The authorities don't seem to have linked to the bibs. 2) Trying to figure out why, I created a new biblio, so we could see where the link is broken in our imported records. I was editing the new record, and asked it to search the authorities for a name (one that isn't in the authorities file, as it happens) in the 100 field. This popped up:
ZOOM error 20003 "can't set prefix query" (addinfo: "@or @attr 7=1 @attr 1=Heading 0 @and @attr 1=authtype @attr 5=100 PERSO_NAME @attr 1=Heading @attr 5=1 @attr 4=6 "Maxwell, Robert L.," @attr 1=Heading @attr 5=1 @attr 4=6 "1957- "") from diag-set 'ZOOM' For help, please send mail to the webmaster (webmaster@efdss.org), giving this error message and the time and date of the error.
My webmaster doesn't know what this means. I've found multiple bug listings for ZOOM error 20003- I think this is the latest. http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3386
We've got the candidate release of 3.2 installed - do I still need the patch? Does this error message have anything to do with the fact that the links aren't working? As far as I can tell, the MARC framework for the 100 field is set correctly. Thanks again
-- Ian Bays Director of Projects PTFS Europe.com mobile: +44 (0) 7774995297 phone: +44 (0) 800 756 6803 skype: ian.bays email: ian.bays@ptfs-europe.com
-- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 ext 36 -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
Well, we are still having some issues with Authorities and linking. koha-3.02.00-rc with zebra index We have imported biblios with item records using the standard web interface to stage and then import MARC records. (no issues) This was folled by rebuild_zebra -v -b -r We have created 2 different marc files for authoriy records: Names.marc and Terms.marc. These authority files should have complete coverage for all names in the 100$a field and the 653$a field. We imported these with: bulkauthimport.pl -v 2 -file Names.marc bulkauthimport.pl -v 2 -file Terms.marc we then ran: rebuild_zebra.pl -v -a -r Finally we ran: link_bib_to_authorities.pl --verbose --test Bib authority heading linking report ------------------------------------ Number of bibs checked: 1440 Number of bibs modified: 0 Number of bibs with errors: 0 So nothing was linked. I can search on blblios and authorities and everything looks cool. One weird thing is that if I do an authorities search for a Person, the results look fine. If I do the same for a Term (e.g. Texas), I get results, but they have '$a' stuck on the front in the 'Authority search results' page. Even after manually linking, the authority Terms still show Used in: '0 biblio(s)' While doing this we also discovered that if defining terms for a biblio, it does not appear to hand 653 records with repeating $a subfields (as in 653$aword1$aword2$aword3). It appears to be much happier with repeated 653 records with a single $a subfield in each. MARC documentation at LOC is not definitive about how these two variations should behave (that we could find). I am happy to make our marc files available if someone wants to take a look. I am still suspecting that we may not have something right in our configuration or MARC records. I have included some a couple of sample MARC records output with marcdump below. Regards, -Doug- (Elaine's IT wizard...) Names.marc: LDR 00249nz## 2200109n###### 001 AN-000007 003 UkLoVW 005 20101014195710.0 008 101014|ge|dz|||||n##########||||c###|d 035 _aAN-000007 040 _aUkLoVW _beng _cUkLoVW 100 0 _aAfanasyev, Aleksandr N. LDR 00567nz## 2200193n###### 001 AN-000559 003 UkLoVW 005 20101014195710.0 008 101014|ge|dz|||||n##########||||c###|d 035 _aAN-000559 040 _aUkLoVW _beng _cUkLoVW 100 1 _aAgg, John 400 _aAuthor of The royal brood 400 _aAuthor of the r--l brood 400 _aPindar Peter, Junior 400 _aHedgehog, Humphrey 400 _aJuvenal, Jeremiah 670 _aThe Cambridge bibliography of English literature, Volume 4; Volumes 1800-1900 678 0 _aNovelist, satirist, poet, editor Terms.marc: LDR 00234nz## 2200109n###### 001 AT-000001 003 UkLoVW 005 20101014211201.0 008 101014|ge|dz|||||n##########||||c###|d 035 _aAT-000001 040 _aUkLoVW _beng _cUkLoVW 150 _aAberdeen LDR 00239nz## 2200109n###### 001 AT-000002 003 UkLoVW 005 20101014211201.0 008 101014|ge|dz|||||n##########||||c###|d 035 _aAT-000002 040 _aUkLoVW _beng _cUkLoVW 150 _aAberdeenshire On 14 October 2010 13:51, Elaine Bradtke <eb@efdss.org> wrote:
You're absolutely correct, I tried the search again without the $d (date) and it worked. I still don't understand why my uploaded authorities aren't linking. Maybe whatever was hanging up the server interfered with the link process? At any rate, we're going to start again from scratch tonight. The uploaded records don't have subfield d in them, so at least that's not part of the problem.
I'm supposed to demonstrate the wonders of Koha to the advisory committee tomorrow. I must say, it looks impressive, even if it's not all there yet!
On Thu, Oct 14, 2010 at 11:18 AM, Ian Bays <ian.bays@ptfs-europe.com> wrote:
Elaine, We have seen this on one of our systems when the subfield d in the authority is used for date range. I believe that Colin Campbell has been looking at it. I will let Colin (or anyone else) comment on what the solution might be, but thought it worth mentioning you are not alone and I don't think you missed a step. Ian On 14/10/2010 10:51, Elaine Bradtke wrote:
Greetings all,
We did a bulk import of biblios, and then a bulk import of name authorities, Then we ran link_bibs_to_authorities.pl , and finally ran the zebra. Sometime after that we had to reboot the server as something else was causing it to run very slowly. Have we missed any steps in this process?
Two possibly? related problems occurred with authorities. 1) The authorities don't seem to have linked to the bibs. 2) Trying to figure out why, I created a new biblio, so we could see where the link is broken in our imported records. I was editing the new record, and asked it to search the authorities for a name (one that isn't in the authorities file, as it happens) in the 100 field. This popped up:
ZOOM error 20003 "can't set prefix query" (addinfo: "@or @attr 7=1 @attr 1=Heading 0 @and @attr 1=authtype @attr 5=100 PERSO_NAME @attr 1=Heading @attr 5=1 @attr 4=6 "Maxwell, Robert L.," @attr 1=Heading @attr 5=1 @attr 4=6 "1957- "") from diag-set 'ZOOM' For help, please send mail to the webmaster (webmaster@efdss.org), giving this error message and the time and date of the error.
My webmaster doesn't know what this means. I've found multiple bug listings for ZOOM error 20003- I think this is the latest. http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3386
We've got the candidate release of 3.2 installed - do I still need the patch? Does this error message have anything to do with the fact that the links aren't working? As far as I can tell, the MARC framework for the 100 field is set correctly. Thanks again
-- Ian Bays Director of Projects PTFS Europe.com mobile: +44 (0) 7774995297 phone: +44 (0) 800 756 6803 skype: ian.bays email: ian.bays@ptfs-europe.com
-- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 ext 36 -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Google UK Limited Registered Office: Belgrave House, 76 Buckingham Palace Road, London SW1W 9TQ Registered in England Number: 3977902
Well, we are still having some issues with Authorities and linking. koha-3.02.00-rc with zebra index We have imported biblios with item records using the standard web interface to stage and then import MARC records. (no issues) This was folled by rebuild_zebra -v -b -r We have created 2 different marc files for authoriy records: Names.marc and Terms.marc. These authority files should have complete coverage for all names in the 100$a field and the 653$a field. We imported these with: bulkauthimport.pl -v 2 -file Names.marc bulkauthimport.pl -v 2 -file Terms.marc we then ran: rebuild_zebra.pl -v -a -r Finally we ran: link_bib_to_authorities.pl --verbose --test Bib authority heading linking report ------------------------------------ Number of bibs checked: 1440 Number of bibs modified: 0 Number of bibs with errors: 0 So nothing was linked. I can search on blblios and authorities and everything looks cool. One weird thing is that if I do an authorities search for a Person, the results look fine. If I do the same for a Term (e.g. Texas), I get results, but they have '$a' stuck on the front in the 'Authority search results' page. Even after manually linking, the authority Terms still show Used in: '0 biblio(s)' While doing this we also discovered that if defining terms for a biblio, it does not appear to hand 653 records with repeating $a subfields (as in 653$aword1$aword2$aword3). It appears to be much happier with repeated 653 records with a single $a subfield in each. MARC documentation at LOC is not definitive about how these two variations should behave (that we could find). I am happy to make our marc files available if someone wants to take a look. I am still suspecting that we may not have something right in our configuration or MARC records. I have included some a couple of sample MARC records output with marcdump below. Regards, -Doug- (Elaine's IT wizard...) Names.marc: LDR 00249nz## 2200109n###### 001 AN-000007 003 UkLoVW 005 20101014195710.0 008 101014|ge|dz|||||n##########||||c###|d 035 _aAN-000007 040 _aUkLoVW _beng _cUkLoVW 100 0 _aAfanasyev, Aleksandr N. LDR 00567nz## 2200193n###### 001 AN-000559 003 UkLoVW 005 20101014195710.0 008 101014|ge|dz|||||n##########||||c###|d 035 _aAN-000559 040 _aUkLoVW _beng _cUkLoVW 100 1 _aAgg, John 400 _aAuthor of The royal brood 400 _aAuthor of the r--l brood 400 _aPindar Peter, Junior 400 _aHedgehog, Humphrey 400 _aJuvenal, Jeremiah 670 _aThe Cambridge bibliography of English literature, Volume 4; Volumes 1800-1900 678 0 _aNovelist, satirist, poet, editor Terms.marc: LDR 00234nz## 2200109n###### 001 AT-000001 003 UkLoVW 005 20101014211201.0 008 101014|ge|dz|||||n##########||||c###|d 035 _aAT-000001 040 _aUkLoVW _beng _cUkLoVW 150 _aAberdeen LDR 00239nz## 2200109n###### 001 AT-000002 003 UkLoVW 005 20101014211201.0 008 101014|ge|dz|||||n##########||||c###|d 035 _aAT-000002 040 _aUkLoVW _beng _cUkLoVW 150 _aAberdeenshire On 14 October 2010 13:51, Elaine Bradtke <eb@efdss.org> wrote:
You're absolutely correct, I tried the search again without the $d (date) and it worked. I still don't understand why my uploaded authorities aren't linking. Maybe whatever was hanging up the server interfered with the link process? At any rate, we're going to start again from scratch tonight. The uploaded records don't have subfield d in them, so at least that's not part of the problem.
I'm supposed to demonstrate the wonders of Koha to the advisory committee tomorrow. I must say, it looks impressive, even if it's not all there yet!
On Thu, Oct 14, 2010 at 11:18 AM, Ian Bays <ian.bays@ptfs-europe.com> wrote:
Elaine, We have seen this on one of our systems when the subfield d in the authority is used for date range. I believe that Colin Campbell has been looking at it. I will let Colin (or anyone else) comment on what the solution might be, but thought it worth mentioning you are not alone and I don't think you missed a step. Ian On 14/10/2010 10:51, Elaine Bradtke wrote:
Greetings all,
We did a bulk import of biblios, and then a bulk import of name authorities, Then we ran link_bibs_to_authorities.pl , and finally ran the zebra. Sometime after that we had to reboot the server as something else was causing it to run very slowly. Have we missed any steps in this process?
Two possibly? related problems occurred with authorities. 1) The authorities don't seem to have linked to the bibs. 2) Trying to figure out why, I created a new biblio, so we could see where the link is broken in our imported records. I was editing the new record, and asked it to search the authorities for a name (one that isn't in the authorities file, as it happens) in the 100 field. This popped up:
ZOOM error 20003 "can't set prefix query" (addinfo: "@or @attr 7=1 @attr 1=Heading 0 @and @attr 1=authtype @attr 5=100 PERSO_NAME @attr 1=Heading @attr 5=1 @attr 4=6 "Maxwell, Robert L.," @attr 1=Heading @attr 5=1 @attr 4=6 "1957- "") from diag-set 'ZOOM' For help, please send mail to the webmaster (webmaster@efdss.org), giving this error message and the time and date of the error.
My webmaster doesn't know what this means. I've found multiple bug listings for ZOOM error 20003- I think this is the latest. http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3386
We've got the candidate release of 3.2 installed - do I still need the patch? Does this error message have anything to do with the fact that the links aren't working? As far as I can tell, the MARC framework for the 100 field is set correctly. Thanks again
-- Ian Bays Director of Projects PTFS Europe.com mobile: +44 (0) 7774995297 phone: +44 (0) 800 756 6803 skype: ian.bays email: ian.bays@ptfs-europe.com
-- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 ext 36 -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Google UK Limited Registered Office: Belgrave House, 76 Buckingham Palace Road, London SW1W 9TQ Registered in England Number: 3977902
On 2010-10-14, at 10:51 PM, Elaine Bradtke wrote:
Greetings all,
We did a bulk import of biblios, and then a bulk import of name authorities, Then we ran link_bibs_to_authorities.pl , and finally ran the zebra. Sometime after that we had to reboot the server as something else was causing it to run very slowly. Have we missed any steps in this process?
I've found multiple bug listings for ZOOM error 20003- I think this is the latest. http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3386
We've got the candidate release of 3.2 installed - do I still need the patch?
FYI: i think that patch has *not* been added to 3,2-RC yet, so its worth applying and testing perhaps update the bug-report with your findings? cheers, Mason -- KohaAloha, NZ --------------------------------------------------- visit the Koha website at http://koha-community.org
participants (4)
-
Douglas Kingston -
Elaine Bradtke -
Ian Bays -
JAMES Mason