<div dir="ltr">Thanks Nick for your answer.<div>It helps me a lot.</div><div><br></div><div>Cheers,</div><div>Marie</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, May 26, 2016 at 10:48 PM,  <span dir="ltr"><<a href="mailto:Nick.Dosremedios@csiro.au" target="_blank">Nick.Dosremedios@csiro.au</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">



<div style="word-wrap:break-word">
<div>
<div style="color:rgb(0,0,0)"><font face="Helvetica">Hi Marie,</font></div>
<div style="color:rgb(0,0,0)"><font face="Helvetica"><br>
</font></div>
<div style="color:rgb(0,0,0)"><font face="Helvetica">I asked our SP developer and he said:</font></div>
<div style="color:rgb(0,0,0)"><font face="Helvetica"><br>
</font></div>
<div>
<blockquote style="margin:0 0 0 40px;border:none;padding:0px">
<p style="color:rgb(0,0,0);margin-top:0px;margin-bottom:0px;background-color:rgb(255,255,255)">
<font face="Helvetica">With the listed error, correcting the original shapefile is correct.<br>
</font></p>
<p style="color:rgb(0,0,0);margin-top:0px;margin-bottom:0px;background-color:rgb(255,255,255)">
<font face="Helvetica"><br>
</font></p>
<p style="color:rgb(0,0,0);margin-top:0px;margin-bottom:0px;background-color:rgb(255,255,255)">
<font face="Helvetica">Attempting to reload the shapefile will report that the file already exists in /data/ala/data/layers/ready/shape/. This can be deleted.<br>
</font></p>
<p style="color:rgb(0,0,0);margin-top:0px;margin-bottom:0px;background-color:rgb(255,255,255)">
<font face="Helvetica"><br>
</font></p>
<p style="color:rgb(0,0,0);margin-top:0px;margin-bottom:0px;background-color:rgb(255,255,255)">
<font face="Helvetica">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:<br>
</font></p>
<p style="color:rgb(0,0,0);margin-top:0px;margin-bottom:0px;background-color:rgb(255,255,255)">
<font face="Helvetica">DROP TABLE "LAYERID";<br>
</font></p>
<p style="color:rgb(0,0,0);margin-top:0px;margin-bottom:0px;background-color:rgb(255,255,255)">
<font face="Helvetica">DELETE FROM layers WHERE id = LAYERID;<br>
</font></p>
<p style="color:rgb(0,0,0);margin-top:0px;margin-bottom:0px;background-color:rgb(255,255,255)">
<font face="Helvetica">DELETE FROM fields WHERE spid = 'LAYERID';<br>
</font></p>
<p style="color:rgb(0,0,0);margin-top:0px;margin-bottom:0px;background-color:rgb(255,255,255)">
<font face="Helvetica">DELETE FROM objects WHERE fid = 'clLAYERID';<br>
</font></p>
</blockquote>
<p style="color:rgb(0,0,0);margin-top:0px;margin-bottom:0px;background-color:rgb(255,255,255)">
<font face="Helvetica"><br>
</font></p>
<p style="margin-top:0px;margin-bottom:0px"><font face="Helvetica">I<span style="color:rgb(0,0,0);background-color:rgb(255,254,254)"> hope this helps</span></font></p>
<p style="margin-top:0px;margin-bottom:0px"><span style="color:rgb(0,0,0);background-color:rgb(255,254,254)"><font face="Helvetica"><br>
</font></span></p>
<p style="margin-top:0px;margin-bottom:0px"><span style="color:rgb(0,0,0);background-color:rgb(254,253,253)"><font face="Helvetica">Cheers Nick</font></span></p><span class="HOEnZb"><font color="#888888">
</font></span></div><span class="HOEnZb"><font color="#888888">
<div style="color:rgb(0,0,0)">
<div>
<div>
<div><font face="Helvetica">-- </font></div>
<div>
<div><font face="Helvetica">Nick dos Remedios</font></div>
<div><font face="Helvetica">Atlas of Living Australia</font></div>
<div><font face="Helvetica"><a href="http://www.ala.org.au/" target="_blank">http://www.ala.org.au/</a></font></div>
</div>
</div>
</div>
</div>
</font></span></div><span class="HOEnZb"><font color="#888888">
<div style="color:rgb(0,0,0);font-family:Helvetica,sans-serif;font-size:14px">
<br>
</div>
</font></span><span style="color:rgb(0,0,0);font-family:Helvetica,sans-serif;font-size:14px"><span class="HOEnZb"><font color="#888888">
<div style="font-family:Calibri;font-size:12pt;text-align:left;color:black;BORDER-BOTTOM:medium none;BORDER-LEFT:medium none;PADDING-BOTTOM:0in;PADDING-LEFT:0in;PADDING-RIGHT:0in;BORDER-TOP:#b5c4df 1pt solid;BORDER-RIGHT:medium none;PADDING-TOP:3pt">
<span style="font-weight:bold">From: </span>Ala-portal <<a href="mailto:ala-portal-bounces@lists.gbif.org" target="_blank">ala-portal-bounces@lists.gbif.org</a>> on behalf of Marie Elise Lecoq <<a href="mailto:melecoq@gbif.fr" target="_blank">melecoq@gbif.fr</a>><br>
<span style="font-weight:bold">Date: </span>Friday, 27 May 2016 at 10:38 AM<br>
<span style="font-weight:bold">To: </span>"<a href="mailto:ala-portal@lists.gbif.org" target="_blank">ala-portal@lists.gbif.org</a>" <<a href="mailto:ala-portal@lists.gbif.org" target="_blank">ala-portal@lists.gbif.org</a>><br>
<span style="font-weight:bold">Subject: </span>[Ala-portal] [Spatial] Error during integration of layer<br>
</div></font></span><div><div class="h5">
<div><br>
</div>
<div>
<div>
<div dir="ltr">Hi all,
<div><br>
</div>
<div>When I integreted a new layer on the spatial portal, I got this error :</div>
<div><br>
</div>
<div>
<div>org.postgresql.util.PSQLException: ERROR: value too long for type character varying(160)</div>
<div>at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)</div>
<div>at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)</div>
<div>at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)</div>
<div>at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)</div>
<div>at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)</div>
<div>at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:381)</div>
<div>at au.org.ala.layers.ingestion.contextual.ContextualFromShapefileDatabaseLoader.importShapeFile(ContextualFromShapefileDatabaseLoader.java:293)</div>
<div>at au.org.ala.layers.ingestion.contextual.ContextualFromShapefileDatabaseLoader.create(ContextualFromShapefileDatabaseLoader.java:99)</div>
<div>at au.org.ala.layers.ingestion.contextual.ContextualFromShapefileDatabaseLoader.main(ContextualFromShapefileDatabaseLoader.java:54)</div>
</div>
<div><br>
</div>
<div>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/ ?</div>
<div><br>
</div>
<div>Thanks for your help,</div>
<div>Cheers,</div>
<div>Marie</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div>
<div dir="ltr"><img src="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"><br>
</div>
</div>
</div>
</div>
</div>
</div></div></span>
</div>

</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><img src="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"><br></div></div>
</div>