From: Francois P. <fx....@gm...> - 2010-03-01 08:59:59
|
Hello Wolfgang, 2010/2/26 Wolfgang Grunberg <wgr...@az...>: > 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 > wgr...@az... > 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 > Geo...@li... > https://lists.sourceforge.net/lists/listinfo/geonetwork-devel > GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork > |