[Koha] Multiple 999$c biblionumbers Koha 3.14

[Elaine Bradtke]

   - Question: What is the best way to find out if we have records with
   multiple 999c fields?


I need to find out if the record below is an anomaly, or if there is a
bigger problem.

 I've reported a similar problem before, and commented on bug 6657
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6657 . I now have
a record that seems to have lost its item records, acquired an item record
from another record (which itself has vanished) and has a scary number of
999$c fields.  To add to the confusion, the one item that is attached to
the record was uploaded *before* the biblio record was created (and its
parent record is gone without a trace).  See record below.
Some of this could  be human error (merging two records that should not
have been merged, or typing in the wrong number - we don't actually have
barcodes).  But the 999c is machine generated, and that's the worrying
thing.

Do you see anything strange about this record in addition to the 999c
fields? How did that strange $d end up in the midst of them? Any ideas?

=LDR  02138nam a22003737a 4500
=001  201211211518.nw
=003  UkLoVW
=005  20140319230939.0
=008  121120s1922\\\\enkg\\\g\\\\\\000\0\eng\d
=040  \\$aUkLoVW$beng$cUkLoVW
=099  \\$aQS 40
=100  \\$9822$aSharp, Cecil J.
=245  10$aCountry dance tunes, set Xl :$bfrom The English dancing master
(1650-1728) /$cArranged by Cecil J. Sharp.
=260  \\$aLondon :$bNovello & Co.,$c1922.
=300  \\$a26 p. :$bmusic ;$c31 cm.
=500  \\$aIssued in connection with 'The country dance book, part Vl'.
=600  \\$91045$aPlayford, John
=650  \\$9163$aEngland
=650  \\$910905$aCountry dance tunes
=942  \\$2VWML$cBK$hQS 40$n0$6QS0040
=999  \\$c17304 | 18206 | 18205 | 18203 | 18202 | 18202 | 18201 | 18200 |
18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 |
18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 |
18202 | 18202 | 18201 | 18200 | 18199 | 18198 | 18196 | 18194 | 18194 |
18194 | 18194 | 18194 | 18194 | 18199 | 18198 | 18196 | 18194 | 18194 |
18194 | 18194 | 18194 | 18194$d17304 | 18206 | 18205 | 18203 | 18202 |
18202 | 18201 | 18200 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 |
18194 | 18194 | 18194 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 |
18194 | 18194 | 18194 | 18202 | 18202 | 18201 | 18200 | 18199 | 18198 |
18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 | 18199 | 18198 |
18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194
=999  \\$c18206
=999  \\$c18205
=999  \\$c18203 | 18202 | 18202 | 18201 | 18200 | 18199 | 18198 | 18196 |
18194 | 18194 | 18194 | 18194 | 18194 | 18194 | 18199 | 18198 | 18196 |
18194 | 18194 | 18194 | 18194 | 18194 | 18194
=999  \\$c18202
=999  \\$c18202
=999  \\$c18201
=999  \\$c18200 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 |
18194 | 18194
=999  \\$c18199
=999  \\$c18198
=999  \\$c18196 | 18194 | 18194 | 18194
=999  \\$c18194 | 18194
=999  \\$c18194
=952  \\$w2012-10-31$p17354$r2012-10-31$40$6AL_MACCOLL$918199$bVWML$10$oAL
MACCOLL$d2010-01-01$71$2VWML$yBK$00$aVWML


Hoping for a logical answer.  Thanks!
-- 
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 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--------------------------------------------------------------------------
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)