[Koha-bugs] [Bug 18719] New: Manage staged MARC records, the Job progress bar stuck at 0%

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18719

            Bug ID: 18719
           Summary: Manage staged MARC records, the Job progress bar stuck
                    at 0%
 Change sponsored?: ---
           Product: Koha
           Version: 16.11
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P5 - low
         Component: Cataloging
          Assignee: gmcharlt at gmail.com
          Reporter: joseanjos at gmail.com
        QA Contact: testopia at bugs.koha-community.org
                CC: m.de.rooy at rijksmuseum.nl

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

-- 
You are receiving this mail because:
You are watching all bug changes.