[Ala-portal] [Spatial] Error during integration of layer

[Nick.Dosremedios at csiro.au]

Hi Marie,

I asked our SP developer and he said:


With the listed error, correcting the original shapefile is correct.


Attempting to reload the shapefile will report that the file already exists in /data/ala/data/layers/ready/shape/. This can be deleted.


There should be no need to delete anything from postgres. However if required, run each of the following using the LAYERID that is defined in the load script:

DROP TABLE "LAYERID";

DELETE FROM layers WHERE id = LAYERID;

DELETE FROM fields WHERE spid = 'LAYERID';

DELETE FROM objects WHERE fid = 'clLAYERID';


I hope this helps


Cheers Nick

--
Nick dos Remedios
Atlas of Living Australia
http://www.ala.org.au/

From: Ala-portal <ala-portal-bounces at lists.gbif.org<mailto:ala-portal-bounces at lists.gbif.org>> on behalf of Marie Elise Lecoq <melecoq at gbif.fr<mailto:melecoq at gbif.fr>>
Date: Friday, 27 May 2016 at 10:38 AM
To: "ala-portal at lists.gbif.org<mailto:ala-portal at lists.gbif.org>" <ala-portal at lists.gbif.org<mailto:ala-portal at lists.gbif.org>>
Subject: [Ala-portal] [Spatial] Error during integration of layer

Hi all,

When I integreted a new layer on the spatial portal, I got this error :

org.postgresql.util.PSQLException: ERROR: value too long for type character varying(160)
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:381)
at au.org.ala.layers.ingestion.contextual.ContextualFromShapefileDatabaseLoader.importShapeFile(ContextualFromShapefileDatabaseLoader.java:293)
at au.org.ala.layers.ingestion.contextual.ContextualFromShapefileDatabaseLoader.create(ContextualFromShapefileDatabaseLoader.java:99)
at au.org.ala.layers.ingestion.contextual.ContextualFromShapefileDatabaseLoader.main(ContextualFromShapefileDatabaseLoader.java:54)

It seems that one of the name is too long. I tried to fixed on the data and I tried to re-run the script sh but I was not possible because the shapefile is already here. How can reload it ? Do I have to remove rows from the postgresql and remove files in /data/ala/data/layers/ready/shape/ ?

Thanks for your help,
Cheers,
Marie


--
[https://mail.google.com/mail/u/0/?ui=2&ik=f2990c326c&view=fimg&th=143720bd12d267c4&attid=0.1&disp=inline&safe=1&attbid=ANGjdJ-dPPvdDXYTQLEz3sMkSC8MXmmlvNMhRcnZ-5COf76BRKDzNBzALARmrD-ZLTteeCriuqRYcwDCZxnWA6ZjOt8rVgydWnc6h2aRU_hfLDYFdDAPI0uUiC8Do9o&ats=1389188740078&rm=143720bd12d267c4&zw&sz=w1325-h522]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gbif.org/pipermail/ala-portal/attachments/20160527/50b8f955/attachment.html>