Bug 32638

Summary:	No reason given for why items ignored during MARC import
Product:	Koha	Reporter:	David Cook <dcook>
Component:	MARC Bibliographic record staging/import	Assignee:	Bugs List <koha-bugs>
Status:	NEW ---	QA Contact:	Testopia <testopia>
Severity:	minor
Priority:	P5 - low
Version:	Main
Hardware:	All
OS:	All
See Also:	https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30739
Change sponsored?:	---	Patch complexity:	---
Documentation contact:		Documentation submission:
Text to go in the release notes:		Version(s) released in:
Circulation function:

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)