Hello
We have out of the box geonetwork 2.6.4 installed from exe. We setup an
harvesting node using CSW we were able to successfully harvest 220
records(Mckoi default database). We stopped the server and changed the
database settings pointing to a postgreSQL/PostGIS and set up the same
harvesting node and we were able to harvest only 15 records and failed with
an exception .
Is this a bug in PostgreSQL/PostGIS Schema since we are able to successfully
harvest using Mckoi database. Any inputs in this will be highly appreciated.
Thanks.
Regards
Kumaran
org.postgresql.util.PSQLException: ERROR: value too long for type character
vary
ing(24)
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:2062)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1795)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:257)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:479)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:367)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdb
c2Statement.java:321)
at jeeves.resources.dbms.Dbms.execute(Dbms.java:263)
at
org.fao.geonet.kernel.XmlSerializer.insert(XmlSerializer.java:206)
at
org.fao.geonet.kernel.DataManager.insertMetadataExt(DataManager.java:
1183)
at
org.fao.geonet.kernel.DataManager.insertMetadataExt(DataManager.java:
1141)
at
org.fao.geonet.kernel.harvest.harvester.csw.Aligner.addMetadata(Align
er.java:187)
at
org.fao.geonet.kernel.harvest.harvester.csw.Aligner.align(Aligner.jav
a:153)
hello,
it will be a problem with the date/time datatype. you have to increase
the datatypes for time/date columns in your postgresql to varchar(100)
or s.th. else. otherwise the time/date from some metadata sets will not
be written to the database.
regards
armin
Am Freitag, den 30.09.2011, 14:21 +0530 schrieb Kumaran Narayanaswamy:
Hello
We have out of the box geonetwork 2.6.4 installed from exe. We setup an
harvesting node using CSW we were able to successfully harvest 220
records(Mckoi default database). We stopped the server and changed the
database settings pointing to a postgreSQL/PostGIS and set up the same
harvesting node and we were able to harvest only 15 records and failed with
an exception .
Is this a bug in PostgreSQL/PostGIS Schema since we are able to successfully
harvest using Mckoi database. Any inputs in this will be highly appreciated.
Thanks.
Regards
Kumaran
org.postgresql.util.PSQLException: ERROR: value too long for type character
vary
ing(24)
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:2062)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1795)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:257)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:479)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:367)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdb
c2Statement.java:321)
at jeeves.resources.dbms.Dbms.execute(Dbms.java:263)
at
org.fao.geonet.kernel.XmlSerializer.insert(XmlSerializer.java:206)
at
org.fao.geonet.kernel.DataManager.insertMetadataExt(DataManager.java:
1183)
at
org.fao.geonet.kernel.DataManager.insertMetadataExt(DataManager.java:
1141)
at
org.fao.geonet.kernel.harvest.harvester.csw.Aligner.addMetadata(Align
er.java:187)
at
org.fao.geonet.kernel.harvest.harvester.csw.Aligner.align(Aligner.jav
a:153)
------------------------------------------------------------------------------
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2dcopy2
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork
--
Armin Retterath
Zentrale Stelle Geodateninfrastruktur Rheinland-Pfalz
LVermGeo RP
Ferdinand-Sauerbruchstraße 15
56073 Koblenz
Telefon: +49 (0)261/492-466
E-Mail: armin.retterath@anonymised.com
http://www.geoportal.rlp.de