Koha 19.05 Invalid data, cannot decode object (id=, format=marcxml, schema=MARC21)
Dear Colleagues, after update to the Version 19.05 I cant see any details in catalog. The detail script get the Software error. Searching is running without problems. cgi-bin/koha/catalogue/detail.pl?biblionumber=2&searchid=scs_1561546292007 Software error: Invalid data, cannot decode object (id=2, format=marcxml, schema=MARC21) All of the data in the catalog I have imported as MARC21. I have already tried to truncate the database and reimport the data. Any solutions? I think it is the same error: https://www.mail-archive.com/koha@lists.katipo.co.nz/msg24021.html Mit besten Grüßen, Eugen Bastron IT-Manager Deutsches Historisches Institut Moskau
Hi Eugen, Same problem, same questions :) The error says that the XML data in biblio_metadata.metadata is not correct (or does not exist). Try: select count(*) from biblio_metadata where id=2; It will tell you if the metadata for this bibliographic record exists or not. If it exists => my guess is that the XML is incorrect If it does not exist, additional question => from which version did you upgrade? Maybe you got an error during the upgrade process? Regards, Jonathan Le mer. 26 juin 2019 à 05:57, Eugen Bastron <Eugen.Bastron@dhi-moskau.org> a écrit :
Dear Colleagues,
after update to the Version 19.05 I cant see any details in catalog.
The detail script get the Software error. Searching is running without problems.
cgi-bin/koha/catalogue/detail.pl?biblionumber=2&searchid=scs_1561546292007
Software error: Invalid data, cannot decode object (id=2, format=marcxml, schema=MARC21)
All of the data in the catalog I have imported as MARC21.
I have already tried to truncate the database and reimport the data.
Any solutions?
I think it is the same error: https://www.mail-archive.com/koha@lists.katipo.co.nz/msg24021.html
Mit besten Grüßen,
Eugen Bastron IT-Manager
Deutsches Historisches Institut Moskau
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Hello Jonathan, The upgrade process from version 18 was without errors. Count =1 How can I check the XML? Bevor upgrade was details-option ok. Mit besten Grüßen/С уважением IT-Manager Eugen Bastron/Евгений Бастрон Am 26.06.19, 16:15 schrieb "Jonathan Druart" <jonathan.druart@bugs.koha-community.org>: Hi Eugen, Same problem, same questions :) The error says that the XML data in biblio_metadata.metadata is not correct (or does not exist). Try: select count(*) from biblio_metadata where id=2; It will tell you if the metadata for this bibliographic record exists or not. If it exists => my guess is that the XML is incorrect If it does not exist, additional question => from which version did you upgrade? Maybe you got an error during the upgrade process? Regards, Jonathan Le mer. 26 juin 2019 à 05:57, Eugen Bastron <Eugen.Bastron@dhi-moskau.org> a écrit : > > Dear Colleagues, > > after update to the Version 19.05 I cant see any details in catalog. > > The detail script get the Software error. Searching is running without problems. > > cgi-bin/koha/catalogue/detail.pl?biblionumber=2&searchid=scs_1561546292007 > > Software error: > Invalid data, cannot decode object (id=2, format=marcxml, schema=MARC21) > > > All of the data in the catalog I have imported as MARC21. > > I have already tried to truncate the database and reimport the data. > > Any solutions? > > I think it is the same error: > https://www.mail-archive.com/koha@lists.katipo.co.nz/msg24021.html > > > Mit besten Grüßen, > > Eugen Bastron > IT-Manager > > Deutsches Historisches Institut Moskau > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha
You can paste the result of the following query: select metadata from biblio_metadata where id=2; Le mer. 26 juin 2019 à 08:25, Eugen Bastron <Eugen.Bastron@dhi-moskau.org> a écrit :
Hello Jonathan,
The upgrade process from version 18 was without errors.
Count =1
How can I check the XML?
Bevor upgrade was details-option ok.
Mit besten Grüßen/С уважением IT-Manager Eugen Bastron/Евгений Бастрон
Am 26.06.19, 16:15 schrieb "Jonathan Druart" <jonathan.druart@bugs.koha-community.org>:
Hi Eugen,
Same problem, same questions :)
The error says that the XML data in biblio_metadata.metadata is not correct (or does not exist).
Try: select count(*) from biblio_metadata where id=2; It will tell you if the metadata for this bibliographic record exists or not. If it exists => my guess is that the XML is incorrect If it does not exist, additional question => from which version did you upgrade? Maybe you got an error during the upgrade process?
Regards, Jonathan
Le mer. 26 juin 2019 à 05:57, Eugen Bastron <Eugen.Bastron@dhi-moskau.org> a écrit : > > Dear Colleagues, > > after update to the Version 19.05 I cant see any details in catalog. > > The detail script get the Software error. Searching is running without problems. > > cgi-bin/koha/catalogue/detail.pl?biblionumber=2&searchid=scs_1561546292007 > > Software error: > Invalid data, cannot decode object (id=2, format=marcxml, schema=MARC21) > > > All of the data in the catalog I have imported as MARC21. > > I have already tried to truncate the database and reimport the data. > > Any solutions? > > I think it is the same error: > https://www.mail-archive.com/koha@lists.katipo.co.nz/msg24021.html > > > Mit besten Grüßen, > > Eugen Bastron > IT-Manager > > Deutsches Historisches Institut Moskau > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha
Yes, sure: <?xml version="1.0" encoding="UTF-8"?> <record xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd" xmlns="http://www.loc.gov/MARC21/slim"> <leader>00833nam a22002171c 4500</leader> <controlfield tag="001">00000247987</controlfield> <controlfield tag="008">051003s1982 gw ger d</controlfield> <datafield tag="020" ind1=" " ind2=" "> <subfield code="a">3-406-04124-8</subfield> </datafield> <datafield tag="090" ind1=" " ind2=" "> <subfield code="a">D 40 c Poi</subfield> </datafield> <datafield tag="100" ind1="1" ind2=" "> <subfield code="a">Poidevin, Raymond</subfield> <subfield code="4">aut</subfield> </datafield> <datafield tag="240" ind1="0" ind2="4"> <subfield code="a">Les relations franco-allemandes 1815 - 1975</subfield> <subfield code="l">german</subfield> </datafield> <datafield tag="245" ind1="0" ind2="0"> <subfield code="a">Frankreich und Deutschland</subfield> <subfield code="b">die Geschichte ihrer Beziehungen 1815 - 1975</subfield> <subfield code="c">Raymond Poidevin ; Jacques Bariİty</subfield> </datafield> <datafield tag="260" ind1=" " ind2=" "> <subfield code="a">München</subfield> <subfield code="b">Beck</subfield> <subfield code="c">1982</subfield> </datafield> <datafield tag="300" ind1=" " ind2=" "> <subfield code="a">498 S. : graph. Darst., Kt</subfield> </datafield> <datafield tag="500" ind1=" " ind2=" "> <subfield code="a">Aus dem Franz. übers</subfield> </datafield> <datafield tag="650" ind1=" " ind2=" "> <subfield code="a">Politik ; Außenbeziehung</subfield> </datafield> <datafield tag="651" ind1=" " ind2=" "> <subfield code="a">Deutschland <Deutsches Reich> ; Deutschland <Weimarer Republik> ; Deutschland <Drittes Reich> ; Deutschland <Bundesrepublik> ; Frankreich</subfield> </datafield> <datafield tag="700" ind1="1" ind2="2"> <subfield code="a">Bariety, Jacques</subfield> <subfield code="4">aut</subfield> </datafield> <controlfield tag="005">20190625165556.0</controlfield> <datafield tag="099" ind1="1" ind2=" "> <subfield code="a">2005-10-03T12:16:00Z </subfield> </datafield> <datafield tag="999" ind1=" " ind2=" "> <subfield code="c">2</subfield> <subfield code="d">2</subfield> </datafield> </record> -----Original Message----- From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> Sent: Wednesday, June 26, 2019 4:49 PM To: Eugen Bastron <Eugen.Bastron@dhi-moskau.org> Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Koha 19.05 Invalid data, cannot decode object (id=, format=marcxml, schema=MARC21) You can paste the result of the following query: select metadata from biblio_metadata where id=2; Le mer. 26 juin 2019 à 08:25, Eugen Bastron <Eugen.Bastron@dhi-moskau.org> a écrit :
Hello Jonathan,
The upgrade process from version 18 was without errors.
Count =1
How can I check the XML?
Bevor upgrade was details-option ok.
Mit besten Grüßen/С уважением IT-Manager Eugen Bastron/Евгений Бастрон
Am 26.06.19, 16:15 schrieb "Jonathan Druart" <jonathan.druart@bugs.koha-community.org>:
Hi Eugen,
Same problem, same questions :)
The error says that the XML data in biblio_metadata.metadata is not correct (or does not exist).
Try: select count(*) from biblio_metadata where id=2; It will tell you if the metadata for this bibliographic record exists or not. If it exists => my guess is that the XML is incorrect If it does not exist, additional question => from which version did you upgrade? Maybe you got an error during the upgrade process?
Regards, Jonathan
Le mer. 26 juin 2019 à 05:57, Eugen Bastron <Eugen.Bastron@dhi-moskau.org> a écrit : > > Dear Colleagues, > > after update to the Version 19.05 I cant see any details in catalog. > > The detail script get the Software error. Searching is running without problems. > > cgi-bin/koha/catalogue/detail.pl?biblionumber=2&searchid=scs_1561546292007 > > Software error: > Invalid data, cannot decode object (id=2, format=marcxml, schema=MARC21) > > > All of the data in the catalog I have imported as MARC21. > > I have already tried to truncate the database and reimport the data. > > Any solutions? > > I think it is the same error: > https://www.mail-archive.com/koha@lists.katipo.co.nz/msg24021.html > > > Mit besten Grüßen, > > Eugen Bastron > IT-Manager > > Deutsches Historisches Institut Moskau > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha
Do you have any ideas? Am 26.06.19, 18:52 schrieb "Eugen Bastron" <Eugen.Bastron@dhi-moskau.org>: Yes, sure: <?xml version="1.0" encoding="UTF-8"?> <record xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd" xmlns="http://www.loc.gov/MARC21/slim"> <leader>00833nam a22002171c 4500</leader> <controlfield tag="001">00000247987</controlfield> <controlfield tag="008">051003s1982 gw ger d</controlfield> <datafield tag="020" ind1=" " ind2=" "> <subfield code="a">3-406-04124-8</subfield> </datafield> <datafield tag="090" ind1=" " ind2=" "> <subfield code="a">D 40 c Poi</subfield> </datafield> <datafield tag="100" ind1="1" ind2=" "> <subfield code="a">Poidevin, Raymond</subfield> <subfield code="4">aut</subfield> </datafield> <datafield tag="240" ind1="0" ind2="4"> <subfield code="a">Les relations franco-allemandes 1815 - 1975</subfield> <subfield code="l">german</subfield> </datafield> <datafield tag="245" ind1="0" ind2="0"> <subfield code="a">Frankreich und Deutschland</subfield> <subfield code="b">die Geschichte ihrer Beziehungen 1815 - 1975</subfield> <subfield code="c">Raymond Poidevin ; Jacques Bariİty</subfield> </datafield> <datafield tag="260" ind1=" " ind2=" "> <subfield code="a">München</subfield> <subfield code="b">Beck</subfield> <subfield code="c">1982</subfield> </datafield> <datafield tag="300" ind1=" " ind2=" "> <subfield code="a">498 S. : graph. Darst., Kt</subfield> </datafield> <datafield tag="500" ind1=" " ind2=" "> <subfield code="a">Aus dem Franz. übers</subfield> </datafield> <datafield tag="650" ind1=" " ind2=" "> <subfield code="a">Politik ; Außenbeziehung</subfield> </datafield> <datafield tag="651" ind1=" " ind2=" "> <subfield code="a">Deutschland <Deutsches Reich> ; Deutschland <Weimarer Republik> ; Deutschland <Drittes Reich> ; Deutschland <Bundesrepublik> ; Frankreich</subfield> </datafield> <datafield tag="700" ind1="1" ind2="2"> <subfield code="a">Bariety, Jacques</subfield> <subfield code="4">aut</subfield> </datafield> <controlfield tag="005">20190625165556.0</controlfield> <datafield tag="099" ind1="1" ind2=" "> <subfield code="a">2005-10-03T12:16:00Z </subfield> </datafield> <datafield tag="999" ind1=" " ind2=" "> <subfield code="c">2</subfield> <subfield code="d">2</subfield> </datafield> </record> -----Original Message----- From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> Sent: Wednesday, June 26, 2019 4:49 PM To: Eugen Bastron <Eugen.Bastron@dhi-moskau.org> Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Koha 19.05 Invalid data, cannot decode object (id=, format=marcxml, schema=MARC21) You can paste the result of the following query: select metadata from biblio_metadata where id=2; Le mer. 26 juin 2019 à 08:25, Eugen Bastron <Eugen.Bastron@dhi-moskau.org> a écrit : > > Hello Jonathan, > > The upgrade process from version 18 was without errors. > > Count =1 > > How can I check the XML? > > Bevor upgrade was details-option ok. > > Mit besten Grüßen/С уважением > IT-Manager > Eugen Bastron/Евгений Бастрон > > Am 26.06.19, 16:15 schrieb "Jonathan Druart" <jonathan.druart@bugs.koha-community.org>: > > Hi Eugen, > > Same problem, same questions :) > > The error says that the XML data in biblio_metadata.metadata is not > correct (or does not exist). > > Try: select count(*) from biblio_metadata where id=2; > It will tell you if the metadata for this bibliographic record exists or not. > If it exists => my guess is that the XML is incorrect > If it does not exist, additional question => from which version did > you upgrade? Maybe you got an error during the upgrade process? > > Regards, > Jonathan > > Le mer. 26 juin 2019 à 05:57, Eugen Bastron > <Eugen.Bastron@dhi-moskau.org> a écrit : > > > > Dear Colleagues, > > > > after update to the Version 19.05 I cant see any details in catalog. > > > > The detail script get the Software error. Searching is running without problems. > > > > cgi-bin/koha/catalogue/detail.pl?biblionumber=2&searchid=scs_1561546292007 > > > > Software error: > > Invalid data, cannot decode object (id=2, format=marcxml, schema=MARC21) > > > > > > All of the data in the catalog I have imported as MARC21. > > > > I have already tried to truncate the database and reimport the data. > > > > Any solutions? > > > > I think it is the same error: > > https://www.mail-archive.com/koha@lists.katipo.co.nz/msg24021.html > > > > > > Mit besten Grüßen, > > > > Eugen Bastron > > IT-Manager > > > > Deutsches Historisches Institut Moskau > > > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha@lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > >
Hello Jonathan, I have found the solution. If I try to import marc file with a bot 63 000 records I get the error. But If I split the marc file, that is ok. Mit besten Grüßen/С уважением IT-Manager Eugen Bastron/Евгений Бастрон Am 26.06.19, 16:49 schrieb "Jonathan Druart" <jonathan.druart@bugs.koha-community.org>: You can paste the result of the following query: select metadata from biblio_metadata where id=2; Le mer. 26 juin 2019 à 08:25, Eugen Bastron <Eugen.Bastron@dhi-moskau.org> a écrit : > > Hello Jonathan, > > The upgrade process from version 18 was without errors. > > Count =1 > > How can I check the XML? > > Bevor upgrade was details-option ok. > > Mit besten Grüßen/С уважением > IT-Manager > Eugen Bastron/Евгений Бастрон > > Am 26.06.19, 16:15 schrieb "Jonathan Druart" <jonathan.druart@bugs.koha-community.org>: > > Hi Eugen, > > Same problem, same questions :) > > The error says that the XML data in biblio_metadata.metadata is not > correct (or does not exist). > > Try: select count(*) from biblio_metadata where id=2; > It will tell you if the metadata for this bibliographic record exists or not. > If it exists => my guess is that the XML is incorrect > If it does not exist, additional question => from which version did > you upgrade? Maybe you got an error during the upgrade process? > > Regards, > Jonathan > > Le mer. 26 juin 2019 à 05:57, Eugen Bastron > <Eugen.Bastron@dhi-moskau.org> a écrit : > > > > Dear Colleagues, > > > > after update to the Version 19.05 I cant see any details in catalog. > > > > The detail script get the Software error. Searching is running without problems. > > > > cgi-bin/koha/catalogue/detail.pl?biblionumber=2&searchid=scs_1561546292007 > > > > Software error: > > Invalid data, cannot decode object (id=2, format=marcxml, schema=MARC21) > > > > > > All of the data in the catalog I have imported as MARC21. > > > > I have already tried to truncate the database and reimport the data. > > > > Any solutions? > > > > I think it is the same error: > > https://www.mail-archive.com/koha@lists.katipo.co.nz/msg24021.html > > > > > > Mit besten Grüßen, > > > > Eugen Bastron > > IT-Manager > > > > Deutsches Historisches Institut Moskau > > > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha@lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > >
It's good to know that this error can be replicated... the question is why did this suddenly start with the upgrade to 19.05... it worked fine with 18.11. Ron ----------------------------------------------------------------------------------------- Ronald Vyhmeister, PhD Academic Dean IT Manager Middle East University Beirut, Lebanon ronald.vyhmeister@meu.edu.lb Mobile:+961-81767015 Office: +961 1 685-800 x 102 US: +1 301-244-9191 Technology is dominated by two kinds of people: Those who manage what they do not understand and those who understand that which they do not manage. -----Original Message----- From: Koha <koha-bounces@lists.katipo.co.nz> On Behalf Of Eugen Bastron Sent: Thursday, July 4, 2019 9:51 AM To: Jonathan Druart <jonathan.druart@bugs.koha-community.org> Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Koha 19.05 Invalid data, cannot decode object (id=, format=marcxml, schema=MARC21) Hello Jonathan, I have found the solution. If I try to import marc file with a bot 63 000 records I get the error. But If I split the marc file, that is ok. Mit besten Grüßen/С уважением IT-Manager Eugen Bastron/Евгений Бастрон Am 26.06.19, 16:49 schrieb "Jonathan Druart" <jonathan.druart@bugs.koha-community.org>: You can paste the result of the following query: select metadata from biblio_metadata where id=2; Le mer. 26 juin 2019 à 08:25, Eugen Bastron <Eugen.Bastron@dhi-moskau.org> a écrit : > > Hello Jonathan, > > The upgrade process from version 18 was without errors. > > Count =1 > > How can I check the XML? > > Bevor upgrade was details-option ok. > > Mit besten Grüßen/С уважением > IT-Manager > Eugen Bastron/Евгений Бастрон > > Am 26.06.19, 16:15 schrieb "Jonathan Druart" <jonathan.druart@bugs.koha-community.org>: > > Hi Eugen, > > Same problem, same questions :) > > The error says that the XML data in biblio_metadata.metadata is not > correct (or does not exist). > > Try: select count(*) from biblio_metadata where id=2; > It will tell you if the metadata for this bibliographic record exists or not. > If it exists => my guess is that the XML is incorrect > If it does not exist, additional question => from which version did > you upgrade? Maybe you got an error during the upgrade process? > > Regards, > Jonathan > > Le mer. 26 juin 2019 à 05:57, Eugen Bastron > <Eugen.Bastron@dhi-moskau.org> a écrit : > > > > Dear Colleagues, > > > > after update to the Version 19.05 I cant see any details in catalog. > > > > The detail script get the Software error. Searching is running without problems. > > > > cgi-bin/koha/catalogue/detail.pl?biblionumber=2&searchid=scs_1561546292007 > > > > Software error: > > Invalid data, cannot decode object (id=2, format=marcxml, schema=MARC21) > > > > > > All of the data in the catalog I have imported as MARC21. > > > > I have already tried to truncate the database and reimport the data. > > > > Any solutions? > > > > I think it is the same error: > > https://www.mail-archive.com/koha@lists.katipo.co.nz/msg24021.html > > > > > > Mit besten Grüßen, > > > > Eugen Bastron > > IT-Manager > > > > Deutsches Historisches Institut Moskau > > > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha@lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
participants (3)
-
Eugen Bastron -
Jonathan Druart -
Ronald Vyhmeister