Bug 18719 - Manage staged MARC records, the Job progress bar stuck at 0%
Summary: Manage staged MARC records, the Job progress bar stuck at 0%
Status: RESOLVED DUPLICATE of bug 15032
Alias: None
Product: Koha
Classification: Unclassified
Component: Cataloging (show other bugs)
Version: 16.11
Hardware: All All
: P5 - low normal
Assignee: Galen Charlton
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-06-02 08:35 UTC by José Anjos
Modified: 2020-09-13 10:50 UTC (History)
3 users (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description José Anjos 2017-06-02 08:35:21 UTC
Following:
http://koha.1045719.n5.nabble.com/Problem-on-Staged-MARC-management-td5935206.html#a5935320

I can upload the Unimarc file, then "Stage for import", but then when I import this batch into the catalog on "Manage staged MARC records", the Job progress bar will keep 0% forever.
If I refresh page it shows that the record was staged ok.

The problem is related with the Items because when I choose NO on "Check for embedded item record data?" it works, the Job progress bar will go to 100%

I've tried other files and with mysql 5.7 or mariDB

On /var/log/koha/koha/intranet-error.log
[cgi:error] [pid 1580] [client xx.xx.xx.xx:35538] AH01215: [Tue May 30 14:34:16 2017] stage-marc-import.pl: Use of uninitialized value in concatenation (.) or string at /usr/share/perl5/MARC/File/XML.pm line 397, <__ANONIO__> chunk 2.: /usr/share/koha/intranet/cgi-bin/tools/stage-marc-import.pl, referer: <a href="http://yy.yy.yy.yy::8080/cgi-bin/koha/tools/stage-marc-import.pl">http://yy.yy.yy.yy::8080/cgi-bin/koha/tools/stage-marc-import.pl


Trying with bulkmarcimport.pl I have this message:

bib-64150.marcxml
deleting biblios
DBD::mysql::db do failed: Cannot truncate a table referenced in a foreign key constraint (`koha_koha`.`aqorders`, CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `koha_koha`.`biblio` (`biblionumber`)) [for Statement "truncate biblio"] at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 150.
DBD::mysql::db do failed: Cannot truncate a table referenced in a foreign key constraint (`koha_koha`.`items`, CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `koha_koha`.`biblioitems` (`biblioitemnumber`)) [for Statement "truncate biblioitems"] at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 151.
DBD::mysql::db do failed: Cannot truncate a table referenced in a foreign key constraint (`koha_koha`.`accountlines`, CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `koha_koha`.`items` (`itemnumber`)) [for Statement "truncate items"] at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 152.
Characteristic MARC flavour: UNIMARC
.
1 MARC records done in 0.147950887680054 seconds
Comment 1 Katrin Fischer 2020-09-13 10:50:35 UTC

*** This bug has been marked as a duplicate of bug 15032 ***