Dear GeoNetwork development list,
I get errors when importing our MEF files in the latest GN trunk version (2/26/2010).
The same MEF files imported through the "Metadata insert" web form without a hitch in GN 2.4.2 and a trunk version from ca. 1/27/2009.
I could reproduce 2 errors depending on the MEF file which appear to be MySQL related.
See error log entries below.
Could this be related to the recent MEF2 file support (http://trac.osgeo.org/geonetwork/ticket/173#comment:1) addition in the trunk?
Ciao, Wolfgang
*** "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'D206EAA22' at line 1"
276391 [http-8080-4] INFO jeeves.request - ==========================================================
276391 [http-8080-4] INFO jeeves.request - HTML Request (from 127.0.0.1) : /geonetwork/srv/en/mef.import
276391 [http-8080-4] DEBUG jeeves.request - Method : POST
276391 [http-8080-4] DEBUG jeeves.request - Content type : multipart/form-data; boundary=---------------------------850742997730
276391 [http-8080-4] DEBUG jeeves.request - Accept : text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
276391 [http-8080-4] DEBUG jeeves.request - Session id is 920F90B39F8D4B050F979C80CC6D29C8
276391 [http-8080-4] DEBUG jeeves.request - Uploading file 0A3D03FB-E9E7-4C34-B996-4E7D206EAA22.mef type: application/octet-stream size: 16929
276391 [http-8080-4] DEBUG jeeves.request - File is called 0A3D03FB-E9E7-4C34-B996-4E7D206EAA22.mef after simplification
276391 [http-8080-4] DEBUG jeeves.request - Adding to parameters:<mefFile type="file" size="16929" content-type="application/octet-stream">0A3D03FB-E9E7-4C34-B996-4E7D206EAA22.mef</mefFile>
276391 [http-8080-4] INFO jeeves.service - Dispatching : mef.import
276391 [http-8080-4] DEBUG jeeves.service - -> parameters are :
<params>
<insert_mode>1</insert_mode>
<file_type>mef</file_type>
<data />
<mefFile type="file" size="16929" content-type="application/octet-stream">0A3D03FB-E9E7-4C34-B996-4E7D206EAA22.mef</mefFile>
<template>n</template>
<title />
<uuidAction>nothing</uuidAction>
<styleSheet>_none_</styleSheet>
<group>2</group>
<category>_none_</category>
</params>
276437 [http-8080-4] ERROR jeeves.service - Exception when executing service
276437 [http-8080-4] ERROR jeeves.service - (C) Exc : com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'D206EAA22' at line 1
276437 [http-8080-4] DEBUG jeeves.service - Raised exception while executing service
<error id="error">
<message>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'D206EAA22' at line 1</message>
<class>MySQLSyntaxErrorException</class>
<stack>
<at class="com.mysql.jdbc.SQLError" file="SQLError.java" line="936" method="createSQLException" />
<at class="com.mysql.jdbc.MysqlIO" file="MysqlIO.java" line="2985" method="checkErrorPacket" />
<at class="com.mysql.jdbc.MysqlIO" file="MysqlIO.java" line="1631" method="sendCommand" />
<at class="com.mysql.jdbc.MysqlIO" file="MysqlIO.java" line="1723" method="sqlQueryDirect" />
<at class="com.mysql.jdbc.Connection" file="Connection.java" line="3256" method="execSQL" />
<at class="com.mysql.jdbc.PreparedStatement" file="PreparedStatement.java" line="1313" method="executeInternal" />
<at class="com.mysql.jdbc.PreparedStatement" file="PreparedStatement.java" line="1448" method="executeQuery" />
<at class="jeeves.resources.dbms.Dbms" file="Dbms.java" line="212" method="selectFull" />
<at class="jeeves.resources.dbms.Dbms" file="Dbms.java" line="177" method="select" />
<at class="org.fao.geonet.kernel.DataManager" file="DataManager.java" line="1051" method="existsMetadata" />
</stack>
<request>
<language>en</language>
<service>mef.import</service>
</request>
</error>
276437 [http-8080-4] INFO jeeves.service - -> dispatching to error for : mef.import
276453 [http-8080-4] INFO jeeves.service - -> transforming with stylesheet : C:\Workspace\GeoNetworkTrunk\GeoNetworkTrunk\web\geonetwork\/xsl/xml-error.xsl
276469 [http-8080-4] INFO jeeves.service - -> end error transformation for : mef.import
276469 [http-8080-4] INFO jeeves.service - -> error ended for : mef.import
*** "Unknown column '00A5D913' in 'where clause'"
159672 [http-8080-4] INFO jeeves.request - ==========================================================
159672 [http-8080-4] INFO jeeves.request - HTML Request (from 127.0.0.1) : /geonetwork/srv/en/mef.import
159672 [http-8080-4] DEBUG jeeves.request - Method : POST
159672 [http-8080-4] DEBUG jeeves.request - Content type : multipart/form-data; boundary=---------------------------2543417709555
159672 [http-8080-4] DEBUG jeeves.request - Accept : text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
159672 [http-8080-4] DEBUG jeeves.request - Session id is 920F90B39F8D4B050F979C80CC6D29C8
159672 [http-8080-4] DEBUG jeeves.request - Uploading file 00A5D913-0336-40A9-9BEA-D60424D74463.mef type: application/octet-stream size: 18071
159672 [http-8080-4] DEBUG jeeves.request - File is called 00A5D913-0336-40A9-9BEA-D60424D74463.mef after simplification
159672 [http-8080-4] DEBUG jeeves.request - Adding to parameters:<mefFile type="file" size="18071" content-type="application/octet-stream">00A5D913-0336-40A9-9BEA-D60424D74463.mef</mefFile>
159672 [http-8080-4] INFO jeeves.service - Dispatching : mef.import
159672 [http-8080-4] DEBUG jeeves.service - -> parameters are :
<params>
<insert_mode>1</insert_mode>
<file_type>mef</file_type>
<data />
<mefFile type="file" size="18071" content-type="application/octet-stream">00A5D913-0336-40A9-9BEA-D60424D74463.mef</mefFile>
<template>n</template>
<title />
<uuidAction>nothing</uuidAction>
<styleSheet>_none_</styleSheet>
<group>2</group>
<category>_none_</category>
</params>
159719 [http-8080-4] ERROR jeeves.service - Exception when executing service
159719 [http-8080-4] ERROR jeeves.service - (C) Exc : com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column '00A5D913' in 'where clause'
159719 [http-8080-4] DEBUG jeeves.service - Raised exception while executing service
<error id="error">
<message>Unknown column '00A5D913' in 'where clause'</message>
<class>MySQLSyntaxErrorException</class>
<stack>
<at class="com.mysql.jdbc.SQLError" file="SQLError.java" line="936" method="createSQLException" />
<at class="com.mysql.jdbc.MysqlIO" file="MysqlIO.java" line="2985" method="checkErrorPacket" />
<at class="com.mysql.jdbc.MysqlIO" file="MysqlIO.java" line="1631" method="sendCommand" />
<at class="com.mysql.jdbc.MysqlIO" file="MysqlIO.java" line="1723" method="sqlQueryDirect" />
<at class="com.mysql.jdbc.Connection" file="Connection.java" line="3256" method="execSQL" />
<at class="com.mysql.jdbc.PreparedStatement" file="PreparedStatement.java" line="1313" method="executeInternal" />
<at class="com.mysql.jdbc.PreparedStatement" file="PreparedStatement.java" line="1448" method="executeQuery" />
<at class="jeeves.resources.dbms.Dbms" file="Dbms.java" line="212" method="selectFull" />
<at class="jeeves.resources.dbms.Dbms" file="Dbms.java" line="177" method="select" />
<at class="org.fao.geonet.kernel.DataManager" file="DataManager.java" line="1051" method="existsMetadata" />
</stack>
<request>
<language>en</language>
<service>mef.import</service>
</request>
</error>
159719 [http-8080-4] INFO jeeves.service - -> dispatching to error for : mef.import
159734 [http-8080-4] INFO jeeves.service - -> transforming with stylesheet : C:\Workspace\GeoNetworkTrunk\GeoNetworkTrunk\web\geonetwork\/xsl/xml-error.xsl
159750 [http-8080-4] INFO jeeves.service - -> end error transformation for : mef.import
159750 [http-8080-4] INFO jeeves.service - -> error ended for : mef.import
--
_______________________________
Wolfgang Grunberg
Arizona Geological Survey
wgrunberg@anonymised.com
520-770-3500
Hello Wolfgang,
2010/2/26 Wolfgang Grunberg <wgrunberg@anonymised.com>:
Dear GeoNetwork development list,
I get errors when importing our MEF files in the latest GN trunk version
(2/26/2010).
The same MEF files imported through the "Metadata insert" web form
without a hitch in GN 2.4.2 and a trunk version from ca. 1/27/2009.
I could reproduce 2 errors depending on the MEF file which appear to be
MySQL related.
See error log entries below.
Could this be related to the recent MEF2 file support
(http://trac.osgeo.org/geonetwork/ticket/173#comment:1) addition in the
trunk?
I can't reproduce the issue on MySQL at least importing sample
metadata files. Any details on your imported file ?
Francois.
Ciao, Wolfgang
*** "You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'D206EAA22' at line 1"
276391 [http-8080-4] INFO jeeves.request - ==========================================================
276391 [http-8080-4] INFO jeeves.request - HTML Request (from 127.0.0.1) : /geonetwork/srv/en/mef.import
276391 [http-8080-4] DEBUG jeeves.request - Method : POST
276391 [http-8080-4] DEBUG jeeves.request - Content type : multipart/form-data; boundary=---------------------------850742997730
276391 [http-8080-4] DEBUG jeeves.request - Accept : text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
276391 [http-8080-4] DEBUG jeeves.request - Session id is 920F90B39F8D4B050F979C80CC6D29C8
276391 [http-8080-4] DEBUG jeeves.request - Uploading file 0A3D03FB-E9E7-4C34-B996-4E7D206EAA22.mef type: application/octet-stream size: 16929
276391 [http-8080-4] DEBUG jeeves.request - File is called 0A3D03FB-E9E7-4C34-B996-4E7D206EAA22.mef after simplification
276391 [http-8080-4] DEBUG jeeves.request - Adding to parameters:<mefFile type="file" size="16929" content-type="application/octet-stream">0A3D03FB-E9E7-4C34-B996-4E7D206EAA22.mef</mefFile>
276391 [http-8080-4] INFO jeeves.service - Dispatching : mef.import
276391 [http-8080-4] DEBUG jeeves.service - -> parameters are :
<params>
<insert_mode>1</insert_mode>
<file_type>mef</file_type>
<data />
<mefFile type="file" size="16929" content-type="application/octet-stream">0A3D03FB-E9E7-4C34-B996-4E7D206EAA22.mef</mefFile>
<template>n</template>
<title />
<uuidAction>nothing</uuidAction>
<styleSheet>_none_</styleSheet>
<group>2</group>
<category>_none_</category>
</params>
276437 [http-8080-4] ERROR jeeves.service - Exception when executing service
276437 [http-8080-4] ERROR jeeves.service - (C) Exc : com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'D206EAA22' at line 1
276437 [http-8080-4] DEBUG jeeves.service - Raised exception while executing service
<error id="error">
<message>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'D206EAA22' at line 1</message>
<class>MySQLSyntaxErrorException</class>
<stack>
<at class="com.mysql.jdbc.SQLError" file="SQLError.java" line="936" method="createSQLException" />
<at class="com.mysql.jdbc.MysqlIO" file="MysqlIO.java" line="2985" method="checkErrorPacket" />
<at class="com.mysql.jdbc.MysqlIO" file="MysqlIO.java" line="1631" method="sendCommand" />
<at class="com.mysql.jdbc.MysqlIO" file="MysqlIO.java" line="1723" method="sqlQueryDirect" />
<at class="com.mysql.jdbc.Connection" file="Connection.java" line="3256" method="execSQL" />
<at class="com.mysql.jdbc.PreparedStatement" file="PreparedStatement.java" line="1313" method="executeInternal" />
<at class="com.mysql.jdbc.PreparedStatement" file="PreparedStatement.java" line="1448" method="executeQuery" />
<at class="jeeves.resources.dbms.Dbms" file="Dbms.java" line="212" method="selectFull" />
<at class="jeeves.resources.dbms.Dbms" file="Dbms.java" line="177" method="select" />
<at class="org.fao.geonet.kernel.DataManager" file="DataManager.java" line="1051" method="existsMetadata" />
</stack>
<request>
<language>en</language>
<service>mef.import</service>
</request>
</error>
276437 [http-8080-4] INFO jeeves.service - -> dispatching to error for : mef.import
276453 [http-8080-4] INFO jeeves.service - -> transforming with stylesheet : C:\Workspace\GeoNetworkTrunk\GeoNetworkTrunk\web\geonetwork\/xsl/xml-error.xsl
276469 [http-8080-4] INFO jeeves.service - -> end error transformation for : mef.import
276469 [http-8080-4] INFO jeeves.service - -> error ended for : mef.import
*** "Unknown column '00A5D913' in 'where clause'"
159672 [http-8080-4] INFO jeeves.request - ==========================================================
159672 [http-8080-4] INFO jeeves.request - HTML Request (from 127.0.0.1) : /geonetwork/srv/en/mef.import
159672 [http-8080-4] DEBUG jeeves.request - Method : POST
159672 [http-8080-4] DEBUG jeeves.request - Content type : multipart/form-data; boundary=---------------------------2543417709555
159672 [http-8080-4] DEBUG jeeves.request - Accept : text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
159672 [http-8080-4] DEBUG jeeves.request - Session id is 920F90B39F8D4B050F979C80CC6D29C8
159672 [http-8080-4] DEBUG jeeves.request - Uploading file 00A5D913-0336-40A9-9BEA-D60424D74463.mef type: application/octet-stream size: 18071
159672 [http-8080-4] DEBUG jeeves.request - File is called 00A5D913-0336-40A9-9BEA-D60424D74463.mef after simplification
159672 [http-8080-4] DEBUG jeeves.request - Adding to parameters:<mefFile type="file" size="18071" content-type="application/octet-stream">00A5D913-0336-40A9-9BEA-D60424D74463.mef</mefFile>
159672 [http-8080-4] INFO jeeves.service - Dispatching : mef.import
159672 [http-8080-4] DEBUG jeeves.service - -> parameters are :
<params>
<insert_mode>1</insert_mode>
<file_type>mef</file_type>
<data />
<mefFile type="file" size="18071" content-type="application/octet-stream">00A5D913-0336-40A9-9BEA-D60424D74463.mef</mefFile>
<template>n</template>
<title />
<uuidAction>nothing</uuidAction>
<styleSheet>_none_</styleSheet>
<group>2</group>
<category>_none_</category>
</params>
159719 [http-8080-4] ERROR jeeves.service - Exception when executing service
159719 [http-8080-4] ERROR jeeves.service - (C) Exc : com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column '00A5D913' in 'where clause'
159719 [http-8080-4] DEBUG jeeves.service - Raised exception while executing service
<error id="error">
<message>Unknown column '00A5D913' in 'where clause'</message>
<class>MySQLSyntaxErrorException</class>
<stack>
<at class="com.mysql.jdbc.SQLError" file="SQLError.java" line="936" method="createSQLException" />
<at class="com.mysql.jdbc.MysqlIO" file="MysqlIO.java" line="2985" method="checkErrorPacket" />
<at class="com.mysql.jdbc.MysqlIO" file="MysqlIO.java" line="1631" method="sendCommand" />
<at class="com.mysql.jdbc.MysqlIO" file="MysqlIO.java" line="1723" method="sqlQueryDirect" />
<at class="com.mysql.jdbc.Connection" file="Connection.java" line="3256" method="execSQL" />
<at class="com.mysql.jdbc.PreparedStatement" file="PreparedStatement.java" line="1313" method="executeInternal" />
<at class="com.mysql.jdbc.PreparedStatement" file="PreparedStatement.java" line="1448" method="executeQuery" />
<at class="jeeves.resources.dbms.Dbms" file="Dbms.java" line="212" method="selectFull" />
<at class="jeeves.resources.dbms.Dbms" file="Dbms.java" line="177" method="select" />
<at class="org.fao.geonet.kernel.DataManager" file="DataManager.java" line="1051" method="existsMetadata" />
</stack>
<request>
<language>en</language>
<service>mef.import</service>
</request>
</error>
159719 [http-8080-4] INFO jeeves.service - -> dispatching to error for : mef.import
159734 [http-8080-4] INFO jeeves.service - -> transforming with stylesheet : C:\Workspace\GeoNetworkTrunk\GeoNetworkTrunk\web\geonetwork\/xsl/xml-error.xsl
159750 [http-8080-4] INFO jeeves.service - -> end error transformation for : mef.import
159750 [http-8080-4] INFO jeeves.service - -> error ended for : mef.import
--
_______________________________
Wolfgang Grunberg
Arizona Geological Survey
wgrunberg@anonymised.com
520-770-3500
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork
Follow up:
Francois found an error in my MEF's info.xml file. I erroneously inserted the metadata record's UUID into the localId element. That optional element allows only unique integers for internal use by GeoNetwork.
Francois also committed better debug information to the trunk.
Ciao, Wolfgang
_______________________________
Wolfgang Grunberg
Arizona Geological Survey
wgrunberg@anonymised.com
520-770-3500
On 3/1/2010 01:59, Francois Prunayre wrote:
Hello Wolfgang,
2010/2/26 Wolfgang Grunberg<wgrunberg@anonymised.com>:
Dear GeoNetwork development list,
I get errors when importing our MEF files in the latest GN trunk version
(2/26/2010).
The same MEF files imported through the "Metadata insert" web form
without a hitch in GN 2.4.2 and a trunk version from ca. 1/27/2009.
I could reproduce 2 errors depending on the MEF file which appear to be
MySQL related.
See error log entries below.
Could this be related to the recent MEF2 file support
(http://trac.osgeo.org/geonetwork/ticket/173#comment:1) addition in the
trunk?
I can't reproduce the issue on MySQL at least importing sample
metadata files. Any details on your imported file ?
Francois.
Ciao, Wolfgang
*** "You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'D206EAA22' at line 1"
276391 [http-8080-4] INFO jeeves.request - ==========================================================
276391 [http-8080-4] INFO jeeves.request - HTML Request (from 127.0.0.1) : /geonetwork/srv/en/mef.import
276391 [http-8080-4] DEBUG jeeves.request - Method : POST
276391 [http-8080-4] DEBUG jeeves.request - Content type : multipart/form-data; boundary=---------------------------850742997730
276391 [http-8080-4] DEBUG jeeves.request - Accept : text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
276391 [http-8080-4] DEBUG jeeves.request - Session id is 920F90B39F8D4B050F979C80CC6D29C8
276391 [http-8080-4] DEBUG jeeves.request - Uploading file 0A3D03FB-E9E7-4C34-B996-4E7D206EAA22.mef type: application/octet-stream size: 16929
276391 [http-8080-4] DEBUG jeeves.request - File is called 0A3D03FB-E9E7-4C34-B996-4E7D206EAA22.mef after simplification
276391 [http-8080-4] DEBUG jeeves.request - Adding to parameters:<mefFile type="file" size="16929" content-type="application/octet-stream">0A3D03FB-E9E7-4C34-B996-4E7D206EAA22.mef</mefFile>
276391 [http-8080-4] INFO jeeves.service - Dispatching : mef.import
276391 [http-8080-4] DEBUG jeeves.service - -> parameters are :
<params>
<insert_mode>1</insert_mode>
<file_type>mef</file_type>
<data />
<mefFile type="file" size="16929" content-type="application/octet-stream">0A3D03FB-E9E7-4C34-B996-4E7D206EAA22.mef</mefFile>
<template>n</template>
<title />
<uuidAction>nothing</uuidAction>
<styleSheet>_none_</styleSheet>
<group>2</group>
<category>_none_</category>
</params>
276437 [http-8080-4] ERROR jeeves.service - Exception when executing service
276437 [http-8080-4] ERROR jeeves.service - (C) Exc : com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'D206EAA22' at line 1
276437 [http-8080-4] DEBUG jeeves.service - Raised exception while executing service
<error id="error">
<message>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'D206EAA22' at line 1</message>
<class>MySQLSyntaxErrorException</class>
<stack>
<at class="com.mysql.jdbc.SQLError" file="SQLError.java" line="936" method="createSQLException" />
<at class="com.mysql.jdbc.MysqlIO" file="MysqlIO.java" line="2985" method="checkErrorPacket" />
<at class="com.mysql.jdbc.MysqlIO" file="MysqlIO.java" line="1631" method="sendCommand" />
<at class="com.mysql.jdbc.MysqlIO" file="MysqlIO.java" line="1723" method="sqlQueryDirect" />
<at class="com.mysql.jdbc.Connection" file="Connection.java" line="3256" method="execSQL" />
<at class="com.mysql.jdbc.PreparedStatement" file="PreparedStatement.java" line="1313" method="executeInternal" />
<at class="com.mysql.jdbc.PreparedStatement" file="PreparedStatement.java" line="1448" method="executeQuery" />
<at class="jeeves.resources.dbms.Dbms" file="Dbms.java" line="212" method="selectFull" />
<at class="jeeves.resources.dbms.Dbms" file="Dbms.java" line="177" method="select" />
<at class="org.fao.geonet.kernel.DataManager" file="DataManager.java" line="1051" method="existsMetadata" />
</stack>
<request>
<language>en</language>
<service>mef.import</service>
</request>
</error>
276437 [http-8080-4] INFO jeeves.service - -> dispatching to error for : mef.import
276453 [http-8080-4] INFO jeeves.service - -> transforming with stylesheet : C:\Workspace\GeoNetworkTrunk\GeoNetworkTrunk\web\geonetwork\/xsl/xml-error.xsl
276469 [http-8080-4] INFO jeeves.service - -> end error transformation for : mef.import
276469 [http-8080-4] INFO jeeves.service - -> error ended for : mef.import
*** "Unknown column '00A5D913' in 'where clause'"
159672 [http-8080-4] INFO jeeves.request - ==========================================================
159672 [http-8080-4] INFO jeeves.request - HTML Request (from 127.0.0.1) : /geonetwork/srv/en/mef.import
159672 [http-8080-4] DEBUG jeeves.request - Method : POST
159672 [http-8080-4] DEBUG jeeves.request - Content type : multipart/form-data; boundary=---------------------------2543417709555
159672 [http-8080-4] DEBUG jeeves.request - Accept : text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
159672 [http-8080-4] DEBUG jeeves.request - Session id is 920F90B39F8D4B050F979C80CC6D29C8
159672 [http-8080-4] DEBUG jeeves.request - Uploading file 00A5D913-0336-40A9-9BEA-D60424D74463.mef type: application/octet-stream size: 18071
159672 [http-8080-4] DEBUG jeeves.request - File is called 00A5D913-0336-40A9-9BEA-D60424D74463.mef after simplification
159672 [http-8080-4] DEBUG jeeves.request - Adding to parameters:<mefFile type="file" size="18071" content-type="application/octet-stream">00A5D913-0336-40A9-9BEA-D60424D74463.mef</mefFile>
159672 [http-8080-4] INFO jeeves.service - Dispatching : mef.import
159672 [http-8080-4] DEBUG jeeves.service - -> parameters are :
<params>
<insert_mode>1</insert_mode>
<file_type>mef</file_type>
<data />
<mefFile type="file" size="18071" content-type="application/octet-stream">00A5D913-0336-40A9-9BEA-D60424D74463.mef</mefFile>
<template>n</template>
<title />
<uuidAction>nothing</uuidAction>
<styleSheet>_none_</styleSheet>
<group>2</group>
<category>_none_</category>
</params>
159719 [http-8080-4] ERROR jeeves.service - Exception when executing service
159719 [http-8080-4] ERROR jeeves.service - (C) Exc : com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column '00A5D913' in 'where clause'
159719 [http-8080-4] DEBUG jeeves.service - Raised exception while executing service
<error id="error">
<message>Unknown column '00A5D913' in 'where clause'</message>
<class>MySQLSyntaxErrorException</class>
<stack>
<at class="com.mysql.jdbc.SQLError" file="SQLError.java" line="936" method="createSQLException" />
<at class="com.mysql.jdbc.MysqlIO" file="MysqlIO.java" line="2985" method="checkErrorPacket" />
<at class="com.mysql.jdbc.MysqlIO" file="MysqlIO.java" line="1631" method="sendCommand" />
<at class="com.mysql.jdbc.MysqlIO" file="MysqlIO.java" line="1723" method="sqlQueryDirect" />
<at class="com.mysql.jdbc.Connection" file="Connection.java" line="3256" method="execSQL" />
<at class="com.mysql.jdbc.PreparedStatement" file="PreparedStatement.java" line="1313" method="executeInternal" />
<at class="com.mysql.jdbc.PreparedStatement" file="PreparedStatement.java" line="1448" method="executeQuery" />
<at class="jeeves.resources.dbms.Dbms" file="Dbms.java" line="212" method="selectFull" />
<at class="jeeves.resources.dbms.Dbms" file="Dbms.java" line="177" method="select" />
<at class="org.fao.geonet.kernel.DataManager" file="DataManager.java" line="1051" method="existsMetadata" />
</stack>
<request>
<language>en</language>
<service>mef.import</service>
</request>
</error>
159719 [http-8080-4] INFO jeeves.service - -> dispatching to error for : mef.import
159734 [http-8080-4] INFO jeeves.service - -> transforming with stylesheet : C:\Workspace\GeoNetworkTrunk\GeoNetworkTrunk\web\geonetwork\/xsl/xml-error.xsl
159750 [http-8080-4] INFO jeeves.service - -> end error transformation for : mef.import
159750 [http-8080-4] INFO jeeves.service - -> error ended for : mef.import
--
_______________________________
Wolfgang Grunberg
Arizona Geological Survey
wgrunberg@anonymised.com
520-770-3500
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork