[Spatial] Error during integration of layer
![](https://secure.gravatar.com/avatar/7b1e5c9b210bb159b99e27d188aebb24.jpg?s=120&d=mm&r=g)
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://secure.gravatar.com/avatar/dd0dfc2b2e1120ce51bbca8afff9715e.jpg?s=120&d=mm&r=g)
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@lists.gbif.orgmailto:ala-portal-bounces@lists.gbif.org> on behalf of Marie Elise Lecoq <melecoq@gbif.frmailto:melecoq@gbif.fr> Date: Friday, 27 May 2016 at 10:38 AM To: "ala-portal@lists.gbif.orgmailto:ala-portal@lists.gbif.org" <ala-portal@lists.gbif.orgmailto:ala-portal@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&t...]
![](https://secure.gravatar.com/avatar/7b1e5c9b210bb159b99e27d188aebb24.jpg?s=120&d=mm&r=g)
Thanks Nick for your answer. It helps me a lot.
Cheers, Marie
On Thu, May 26, 2016 at 10:48 PM, Nick.Dosremedios@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@lists.gbif.org on behalf of Marie Elise Lecoq melecoq@gbif.fr Date: Friday, 27 May 2016 at 10:38 AM To: "ala-portal@lists.gbif.org" ala-portal@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
--
--
participants (2)
-
Marie Elise Lecoq
-
Nick.Dosremedios@csiro.au