RE: KiWiLoader

[Joshua Dunham <jo...@vrtx.com>]

Hi Sergio,

      I can save out my DB (it's small w/o uniprot) but one line in the marmotta loader output says it should have updated from schema 3 to 4. Did this process not take care of the timezone update as well?

-J


Joshua Dunham
Exploratory App Development | Vertex
E: joshua_dunham@vrtx.com
P: 617-229-5157
W: http://www.vrtx.com
L: http://linkedin.com/in/joshuadunham
S: joshua.dunham

________________________________________
From: Sergio Fernández [wikier@apache.org]
Sent: Saturday, November 29, 2014 04:07
To: users@marmotta.apache.org
Subject: Re: KiWiLoader

Joshua,

On 28/11/14 17:01, Joshua Dunham wrote:
> Thanks for the tip! It ‘worked’ or at least got me a bit further. Now
> I have some errors/warnings about the DB and a final error about not
> being able to represent a timestamp. I don’t think the problem is
> with the data … but I can’t be sure. I can save the data currently in
> the DB and start again if there is an issue after the DB upgrade.

In the last week we had in 3.3.0-SNAPSHOT introduced a schema change
regarding dates storing  for correctly managing timezones. See further
details at MARMOTTA-564.

Therefore I suspect you are using the low level loader on a existing
database, is that correct? There are two options: start with a new db or
update the schema. In case the first solution is not an option because
you cannot start from scratch, we can provide you a guide how to upgrade
the schema (we'll have to provide it anyway when publishing the new
release).

Let us know, please.

Cheers,

--
Sergio Fernández
Partner Technology Manager
Redlink GmbH
m: +43 660 2747 925
e: sergio.fernandez@redlink.co
w: https://urldefense.proofpoint.com/v2/url?u=http-3A__redlink.co_&d=AAIDaQ&c=TzEZu9LIcihmW37vx9Ah6w&r=EjhiT90xylIcLIkX_L1-DfhHQmiIg5hWdNx9dZyVLiA&m=mxfx6LG0y9bebeIpoKGFGxWSQsNql6ChzRqHOqgaZbE&s=FR_BD8ppqxltkM1oXpTkQAjp8vLk0J2iJUlWqeCbePQ&e=
This email message and any attachments are confidential and intended for use by the addressee(s) only. If you are not the intended recipient, please notify me immediately by replying to this message, and destroy all copies of this message and any attachments. Thank you.

Re: KiWiLoader

[Sergio Fernández <wi...@apache.org>]

Hi Joshua,

On 01/12/14 14:09, Joshua Dunham wrote:
> I can save out my DB (it's small w/o uniprot) but one line in the
> marmotta loader output says it should have updated from schema 3 to
> 4. Did this process not take care of the timezone update as well?

As I told you, the schema change has been introduced in the latest 
weeks. Therefore, if you want to use the low-level KiWiLoader, both 
Marmotta runtime and loader must use the sane snapshot version.

When you will upgrade the Marmotta webapp, it'll automatically take care 
of the schema upgrade, and you would see something like "KiWiPersistence 
- upgrading existing KiWi database from version 3 to version 4" in the log.

We have performed yesterday the upgrade of several production databases, 
and the process works as expected.But if you have any issue, please 
contact us again.

Hope that helps.

Cheers,

-- 
Sergio Fernández
Partner Technology Manager
Redlink GmbH
m: +43 660 2747 925
e: sergio.fernandez@redlink.co
w: http://redlink.co