Bug 32638 - No reason given for why items ignored during MARC import
Summary: No reason given for why items ignored during MARC import
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: MARC Bibliographic record staging/import (show other bugs)
Version: Main
Hardware: All All
: P5 - low minor (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-01-16 04:32 UTC by David Cook
Modified: 2023-05-18 03:29 UTC (History)
0 users

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description David Cook 2023-01-16 04:32:49 UTC
In the past, if you had a "coded_location_qualifier" that was too long, the whole MARC import would bust (see bug 30739).

That's no longer the case anymore. However, if the item has a "coded_location_qualifier" like "ABCDEFGHIJKLMNOPQRSTUVWXYZ123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ123456789", it will now just be ignored without any more information shown on the Web UI or in the worker logs. 

You wouldn't be able to troubleshoot this issue without writing your own code changes to Koha...
Comment 1 David Cook 2023-05-18 03:17:00 UTC
Bumped into this issue again today when I was trying to import a record that contained an item with a barcode that already existed in Koha.
Comment 2 David Cook 2023-05-18 03:23:55 UTC
I see in C4::ImportBatch::_batchCommitItems that duplicate barcode is the only error that will increment the items errored count...
Comment 3 David Cook 2023-05-18 03:26:38 UTC
Interestingly if the barcode is too long then the whole import fails and I see the following in worker-output.log, so that's something...:

DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Data too long for column 'barcode' at row 1 at /kohadevbox/koha/Koha/Object.pm line 170
Comment 4 David Cook 2023-05-18 03:29:00 UTC
Looks like the coded location qualifier will cause the whole import to fail as well now, so that's good.

You can see this in the worker-output.log:

DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Data too long for column 'coded_location_qualifier' at row 1 at /kohadevbox/koha/Koha/Object.pm line 170

It could be good to add something to the Web UI to ask people to consult their sysadmin so they can check the logs for more specifics...

--

And maybe the duplicate barcode could be hinted at more although given the code flow I can see how that would be very difficult (without throwing a fatal error to stop the whole import)