Re: [GeoNetwork-users] Gn 2.10.2 to 3.0.2: trouble with postgre database migration

[Francois P. <fx....@gm...>]

2015-12-07 15:57 GMT+01:00 Philippe Clastre <
Phi...@av...>:

> HI,
>
> No custom profiles at all.
> I just built metadata templates based on the iso 19139 standard. Never add
> a function.xsl function anywhere (probably unable to do so !).
> Not sure profiles are related to metadata standards ...
>


ok. Using a custom datadir ? (check in
http://localhost:8080/geonetwork/srv/eng/admin.console#/dashboard/information
the
data directory). If yes, drop the schema_plugins folder which may be the
one from your previous installation ?

Just guessing.




>
> I'm trying to success in upgrading GN version ( 2.10.2 to 3.0.2), and the
> very first problem i met was obviously related to the db migration.
> That why, i'm still stucked to this  ...
>
> Don't know what to do now ...
>
>
>
> Le 07/12/2015 15:16, Francois Prunayre a écrit :
>
> Hi, In the log the main error is:
>
> Error at xsl:variable on line 116 column 81 of functions.xsl:
>   XPST0017: XPath syntax error at char 39 on line 116 in
> {...eISODateTimes($value1,$valu...}:
>     Cannot find a matching 2-argument function named
>   {java:org.fao.geonet.util.JODAISODate}parseISODateTimes()
> 2015-12-07 14:28:29,896 ERROR [geonetwork.index] - Indexing stylesheet
> contains errors: Failed to compile stylesheet. 1 error detected.
>
> and is related to indexing (not to migration) which probably explains why
> you can't see records.
>
> Do you have any custom profiles ? You should check a functions.xsl with
> this invalid function call.
>
> Francois
>
>
>
> 2015-12-07 14:40 GMT+01:00 pclastre < <Phi...@av...>
> Phi...@av...>:
> >
> > Many Thanks for your answer
> >
> > I tried to follow indicated steps, but this drives me to the same problem
> > Here's the new log file:  new_catalina.out
> > <http://osgeo-org.1560.x6.nabble.com/file/n5240262/new_catalina.out>
> >
> > What i did:
> >
> >
> > restore the database and ran the following sql commands:
> >   delete from harvester;
> >   delete from harvesthistory;
> >   update metadata set data = replace(data,
> > 'http://147.100.20.29/geonetwork_anaee/srv',
> > 'http://localhost:8082/geonetwork_anaee/srv');
> >   update metadata set data = replace(data,
> > 'http://147.100.20.29/geonetwork_anaee/apps/tabsearch/../../srv',
> > 'http://localhost:8082/geonetwork_anaee/srv');
> >   update metadata set data = replace(data,
> > 'http://w3.avignon.inra.fr/geonetwork_anaee/srv',
> > 'http://localhost:8082/geonetwork_anaee/srv');
> >   update metadata set data = replace(data,
> > 'http://w3.avignon.inra.fr:80/geonetwork_anaee/srv',
> > 'http://localhost:8082/geonetwork_anaee/srv');
> >   # these 4 lines are intended to show you exactly what im a doing. It
> seems
> > that during the catalog's life, a parameter for xlinks reference has been
> > change several times...
> >
> > Cleaned  index, spatialindex, data/subversion folders
> > Started GN
> >
> > After the database migration, stopped GN, and ran these commands
> >   alter table services add constraint services_pkey primary key (id);
> >   alter table ServiceParameters add constraint
> FK_t32t4xtdqmjhl8xmjpe95e474
> > foreign key (service) references Services;
> >
> > The catalog shows only empty forms, even if i can log in. I cannot see
> the
> > records in the "manage directory tab" (organizations & contacts)
> >
> > Waiting for another suggestions ...
> >
> >
> >
> > --
> > View this message in context:
> http://osgeo-org.1560.x6.nabble.com/Gn-2-10-2-to-3-0-2-trouble-with-postgre-database-migration-tp5233017p5240262.html
> > Sent from the GeoNetwork users mailing list archive at Nabble.com.
> >
> >
> ------------------------------------------------------------------------------
> > Go from Idea to Many App Stores Faster with Intel(R) XDK
> > Give your users amazing mobile app experiences with Intel(R) XDK.
> > Use one codebase in this all-in-one HTML5 development environment.
> > Design, debug & build mobile apps & 2D/3D high-impact games for multiple
> OSs.
> > http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
> > _______________________________________________
> > GeoNetwork-users mailing list
> > Geo...@li...
> > https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> > GeoNetwork OpenSource is maintained at
> <http://sourceforge.net/projects/geonetwork>
> http://sourceforge.net/projects/geonetwork
>
>
> <snip logo image is too big for mailman/>
>