[sdx-users] Pb lors de l'indexation d'un document

[Pierre Dittgen]

(re-)Bonjour,

je cherche à indexer un répertoire contenant des documents XML (via 
sdx:uploadDocuments). Hors une erreur se produit sur chaque document et 
aucun n'est indexé.

Un document exemple :

<?xml version="1.0" encoding="utf-8"?>
<author id="A2" xml:lang="fr-FR">
    <name>Dittgen</name>
    <firstName>Pierre</firstName>
</author>

Le document résultant de la transformation par ma XSL d'indexation :

<?xml version="1.0" encoding="UTF-8"?>
<sdx:document id="A2" xmlns:sdx="http://www.culture.gouv.fr/ns/sdx/sdx";>
<sdx:field code="plein-texte">Dittgen Pierre </sdx:field>
<sdx:field code="doc-lang">fr-FR</sdx:field>
<sdx:field code="name">Dittgen</sdx:field>
<sdx:field code="w-name">Dittgen</sdx:field>
<sdx:field code="firstName">Pierre</sdx:field>
<sdx:field code="w-firstName">Pierre</sdx:field>
</sdx:document>

Lors de l'indexation, j'ai l'erreur suivante :

    <sdx:exception xml:lang="fr-FR" code="307">

        <sdx:message>There was a problem saving the entity with the id, 
"A2", to the database with the id, "author".</sdx:message>
        <sdx:originalException>java.sql.SQLException: Violation of 
unique index: SYS_PK_AUTHOR in statement [INSERT INTO author 
(id,propertyName,propertyValue) VALUES ('A2', '', '')] at 
org.hsqldb.Trace.getError(Unknown Source) at 
org.hsqldb.jdbcResultSet.&lt;init&gt;(Unknown Source) at 
org.hsqldb.jdbcConnection.executeStandalone(Unknown Source) at 
org.hsqldb.jdbcConnection.execute(Unknown Source) at 
org.hsqldb.jdbcStatement.fetchResult(Unknown Source) at 
org.hsqldb.jdbcStatement.executeUpdate(Unknown Source) at 
org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source) at 
fr.gouv.culture.sdx.utils.database.AbstractJDBCDatabase.save(AbstractJDBCDatabase.java:183) 
at 
fr.gouv.culture.sdx.repository.FSRepository.add(FSRepository.java:291) 
at 
fr.gouv.culture.sdx.documentbase.LuceneDocumentBase.add(LuceneDocumentBase.java:1125) 
at 
fr.gouv.culture.sdx.documentbase.LuceneDocumentBase.index(LuceneDocumentBase.java:773) 
at 
fr.gouv.culture.sdx.documentbase.LuceneDocumentBase.index(LuceneDocumentBase.java:843) 
at org.apache.cocoon.www.phamodis.upload_xsp.generate(C:\dev\Tomcat 
4.1\work\Standalone\localhost\sdx-cvs\cocoon-files\org/apache/cocoon/www/phamodis\upload_xsp.java:1252) 
at 
org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenerator.java:258) 
at 
org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEventPipeline.java:250) 
at 
org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:395) 
at 
org.apache.cocoon.components.treeprocessor.sitemap.SerializeNode.invoke(SerializeNode.java:154) 
at 
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:85) 
at 
org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invoke(PreparableMatchNode.java:166) 
at 
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:109) 
at 
org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(PipelineNode.java:151) 
at 
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:109) 
at 
org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(PipelinesNode.java:145) 
at 
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:332) 
at 
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:293) 
at 
org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(MountNode.java:124) 
at 
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:85) 
at 
org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invoke(PreparableMatchNode.java:166) 
at 
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:109) 
at 
org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(PipelineNode.java:151) 
at 
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:109) 
at 
org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(PipelinesNode.java:145) 
at 
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:332) 
at 
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:293) 
at org.apache.cocoon.Cocoon.process(Cocoon.java:579) at 
org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:1043) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) 
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) 
at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) 
at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) 
at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) 
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) 
at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) 
at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) 
at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) 
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) 
at 
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416) 
at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) 
at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) 
at 
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) 
at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) 
at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) 
at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) 
at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) 
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) 
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) 
at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) 
at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) 
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) 
at 
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) 
at 
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601) 
at 
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392) 
at 
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565) 
at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619) 
at java.lang.Thread.run(Thread.java:479) </sdx:originalException>

    </sdx:exception>

Des idées ?
Pierre
--
Pierre Dittgen, address@hidden
PASS Technologie http://www.pass-tech.fr