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

[Marie Elise Lecoq]

Thanks Nick for your answer.
It helps me a lot.

Cheers,
Marie

On Thu, May 26, 2016 at 10:48 PM, <Nick.Dosremedios at csiro.au> wrote:

> 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> on behalf of Marie
> Elise Lecoq <melecoq at gbif.fr>
> Date: Friday, 27 May 2016 at 10:38 AM
> To: "ala-portal at lists.gbif.org" <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
>
>
> --
>
>


--
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gbif.org/pipermail/ala-portal/attachments/20160527/8e0e38e8/attachment.html>