Bug 18719

Summary: Manage staged MARC records, the Job progress bar stuck at 0%
Product: Koha Reporter: José Anjos <joseanjos>
Component: CatalogingAssignee: Galen Charlton <gmcharlt>
Status: RESOLVED DUPLICATE QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: m.de.rooy, marjorie.barry-vila, r.delahunty
Version: 16.11   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

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 ***