Siard file is invalid

[snkrau]

We are using the Joomla CMS to build our website www.amnesty-hamburg.de. The content of the site ist stored in a relational mysql database. I tried to convert it to siard but unfortunately it did not work. First everything looks fine, on the screen several messages are processed which indicate the ongoing process. But at the end the siard file ist being deleted and the message is processed: "Archive Test.siard is invalid" (see attached file). I tried with Siard Suite 2.1.and 2.2.

Do you have an idea what is going wrong? Do you know where I can find the error?

Thanks,

Sönke Rau

[mburri]

Hi @snkrau

did you check if there is an error message visible in the application logs?

Maybe you have to change the log level. It's described in the user manual how to do that: https://sfa-siard.github.io/SiardGui/de/logging.html

[snkrau]

Hallo Herr Burri,

vielen Dank für Ihre Antwort. Ich habe die Protokollierung auf „.level=ALL“ gestellt.

Die Datei Siard21.log enthält eine Reihe von Meldungen wie

D 2022.12.23 12:34:01: >> ch.admin.bar.siard2.gui.UserProperties.getMruConnection(0) D 2022.12.23 12:34:01: -- Invalid connection: ""!

Haben Sie eine Idee, was evtl. falsch gelaufen sein könnte?

Freundliche Grüße,

Sönke Rau

[Uni-Logo 2010 für Email] Sönke Rau Universität Hamburg Universitätsarchiv Referat A13 - Digitale Dienste und interne Beratung LZ: A131 Mittelweg 177 D-20148 Hamburg Raum: +49 40 42838-7525

@.**@.> @.**@.>

www.archiv.uni-hamburg.dehttp://www.archiv.uni-hamburg.de/

Von: Max Burri @.> Gesendet: Freitag, 23. Dezember 2022 07:45 An: sfa-siard/SiardGui @.> Cc: Rau, Sönke @.>; Mention @.> Betreff: Re: [sfa-siard/SiardGui] Siard file is invalid (Issue #49)

Hi @snkrauhttps://github.com/snkrau

did you check if there is an error message visible in the application logs?

Maybe you have to change the log level. It's described in the user manual how to do that: https://sfa-siard.github.io/SiardGui/de/logging.html

— Reply to this email directly, view it on GitHubhttps://github.com/sfa-siard/SiardGui/issues/49#issuecomment-1363667474, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AXIALOGW2GJ7D7STQE4N2GLWOVC55ANCNFSM6AAAAAATGSUP6A. You are receiving this because you were mentioned.Message ID: @.**@.>>

[mburri]

The specific error message does not help me without more context.

Is it possible to share the complete log somehow?

[snkrau]

I don’t know how, I’m sorry. I already changed

.level=INFO

to

.level=All

In

C:\siard_suite-2.1\etc\logging.properties

and

C:\Users\klaus\AppData\Local\siard_suite_2.1\etc\logging.properties

Kind Regards,

Sönke Rau

[Uni-Logo 2010 für Email] Sönke Rau Universität Hamburg Universitätsarchiv Referat A13 - Digitale Dienste und interne Beratung LZ: A131 Mittelweg 177 D-20148 Hamburg Raum: +49 40 42838-7525

@.**@.> @.**@.>

www.archiv.uni-hamburg.dehttp://www.archiv.uni-hamburg.de/

Von: Max Burri @.> Gesendet: Freitag, 23. Dezember 2022 14:14 An: sfa-siard/SiardGui @.> Cc: Rau, Sönke @.>; Mention @.> Betreff: Re: [sfa-siard/SiardGui] Siard file is invalid (Issue #49)

The specific error message does not help me without more context.

Is it possible to share the complete log somehow?

— Reply to this email directly, view it on GitHubhttps://github.com/sfa-siard/SiardGui/issues/49#issuecomment-1363943885, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AXIALOHBPJZ22NIGF5APSIDWOWQR3ANCNFSM6AAAAAATGSUP6A. You are receiving this because you were mentioned.Message ID: @.**@.>>

[mburri]

Are there any other error messages in the log?

[snkrau]

I'm sorry once again. I didn't realize that the logfile wasn't attached to the message, now it is.

Happy cmas anyway ...

Regards siard21.log

[snkrau]

The next days I'm out of office. Please appologize any delaid answer,

[mburri]

Thank you for the logs...

Regarding the following error messages:

D 2022.12.23 12:34:01: >> ch.admin.bar.siard2.gui.UserProperties.getMruConnection(0)
D 2022.12.23 12:34:01:   -- Invalid connection: ""!

getMruConnection tries to load the 10 most recently used connection strings from your user properties - this happens at application startup. The message is printend if you don't have 10 connection strings in your user properties. This is just a bad error message and is not related to your issue.

Now - the log file that you provided stops after the application started - did you then try to archive your database? Because there is nothing about that in the log file! There should be at least some information about the archiving process.

But you still have some options

• do you have to provide the parameter zeroDateTimeBehaviour=convertToNull to your connection string? What happens if you remove the parameter?
• Try to set the option "Nur Metadaten"
• Try to set the option "Ansichten als Tabellen exportieren"

[snkrau]

Thanks for your answer, I will try. The parameter is necessary, otherwise the connection is broken immediately.

[mburri]

Is there an alternative setting for convertToNull? - I suspect this one to generate archives that are not valid...

[mburri]

I just created a database with a table with invalid dates and SIARD GUI handled it just fine.

But I encountered the exact same behaviour as you did if I try to export an empty database. This means that this may happen: The download completes sucessfully but the generated archive is not valid - whatever that means. The problem is that the application often does not provide helpful error messages.

Maybe you could find more information in your log files or if you could provide a minimal example database that helps me reproduce your bug. Otherwise it's really hard for me to guess what the problem might be.

[snkrau]

This is the message that I get when the option "zeroDateTimeBehavior=convertToNull" is omitted

I will go on trying.