[GeoNetwork-devel] Harvesting / Error

GeoNetwork GeoNetwork Developer
1

Hi list, I’m getting on error when harvesting crisalis node. Problem is on the isTemplate column of the Metadata table (see below). If I remove not null constraint it works fine but isTemplate is not set to the default value which is ‘n’.

Any ideas ? My node is on http://dev.sandre.eaufrance.fr/gnthesaurus/ admin / admin
Francois

www.crisalis-tech.com

8081

geonetwork

false

false

false

94e787ee-f765-4146-9565-988d95e90364

dummy

5

true

true

true

active

2007-02-12T12:38:34

You tried to add ‘null’ cell to column ‘isTemplate’ which is declared as ‘not_null’

MSQLException

–
Ce message a ete verifie par MailScanner pour des virus ou des polluriels et rien de suspect n’a ete trouve.

Les donnees et renseignements contenus dans ce message sont personnels, confidentiels et privés.Toute publication, utilisation ou diffusion, meme partielle, doit etre autorisee.
Any data and information contained in this electronic mail is personal, confidential and private. Any total or partial publication, use or distribution must be authorized.

2

Hi Francoise,

The test site on Crisalis is for testing CS/W services only. Now, the CS/W
code is complete and aligned but the site will not be updated as soon as
other parts will be finished.

I suggest you to test the harvesting between 2 nodes from the same
codebase.

Cheers,
Andrea

Hi list, I'm getting on error when harvesting crisalis node. Problem is on
the isTemplate column of the Metadata table (see below). If I remove not
null constraint it works fine but isTemplate is not set to the default value
which is 'n'.

Any ideas ? My node is on http://dev.sandre.eaufrance.fr/gnthesaurus/ admin
/ admin
Francois
<nodes>

<node type="geonetwork" name="Crisalis" id="65">

<site>

<host>www.crisalis-tech.com</host>

<port>8081</port>

<servlet>geonetwork</servlet>

<account>

<use>false</use>

<username />

<password />

</account>

</site>

<searches>

<search>

<freeText />

<title />

<abstract />

<keywords />

<digital>false</digital>

<hardcopy>false</hardcopy>

<siteId>94e787ee-f765-4146-9565-988d95e90364</siteId>

<siteName>dummy</siteName>

</search>

</searches>

<options>

<every>5</every>

<createGroups>true</createGroups>

<createCateg>true</createCateg>

<oneRunOnly>true</oneRunOnly>

<status>active</status>

</options>

<info>

<lastRun>2007-02-12T12:38:34</lastRun>

</info>

<error id="error">

<message>You tried to add 'null' cell to column 'isTemplate' which is
declared as 'not_null'</message>

<class>MSQLException</class>

<stack>

<at class="com.mckoi.database.jdbc.RemoteDatabaseInterface"
file="RemoteDatabaseInterface.java" line="280" method="execQuery" />

<at class="com.mckoi.database.jdbc.MConnection" file="MConnection.java"
line="453" method="executeQuery" />

<at class="com.mckoi.database.jdbc.MConnection" file="MConnection.java"
line="436" method="executeQueries" />

<at class="com.mckoi.database.jdbc.MStatement" file="MStatement.java"
line="193" method="executeQueries" />

<at class="com.mckoi.database.jdbc.MStatement" file="MStatement.java"
line="167" method="executeQuery" />

<at class="com.mckoi.database.jdbc.MPreparedStatement"
file="MPreparedStatement.java" line="203" method="executeUpdate" />

<at class="jeeves.resources.dbms.Dbms" file="Dbms.java" line="256"
method="execute" />

<at class="org.fao.geonet.kernel.DataManager" file="DataManager.java"
line="295" method="setTemplate" />

<at class="org.fao.geonet.kernel.harvest.harvester.geonet.Aligner$1"
file="Aligner.java" line="221" method="handleMetadata" />

<at class="org.fao.geonet.kernel.mef.Visitor" file="Visitor.java" line="92"
method="handleXml" />

</stack>

</error>

</node>

</nodes>