<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">
<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>
</div>
<div style="color: rgb(0, 0, 0);">
<div id="MAC_OUTLOOK_SIGNATURE">
<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">http://www.ala.org.au/</font></div>
</div>
</div>
</div>
</div>
</div>
<div style="color: rgb(0, 0, 0); font-family: Helvetica, sans-serif; font-size: 14px;">
<br>
</div>
<span id="OLK_SRC_BODY_SECTION" style="color: rgb(0, 0, 0); font-family: Helvetica, sans-serif; font-size: 14px;">
<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">ala-portal-bounces@lists.gbif.org</a>> on behalf of Marie Elise Lecoq <<a href="mailto:melecoq@gbif.fr">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">ala-portal@lists.gbif.org</a>" <<a href="mailto:ala-portal@lists.gbif.org">ala-portal@lists.gbif.org</a>><br>
<span style="font-weight:bold">Subject: </span>[Ala-portal] [Spatial] Error during integration of layer<br>
</div>
<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 class="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>
</div>
</div>
</span>
</body>
</html>