lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From abhayd <ajdabhol...@hotmail.com>
Subject DIH error when nested db datasource and file data source
Date Sun, 18 Sep 2011 05:05:42 GMT
hi 
I have a requirement where i fetch some data from db , and based on db data
i pull details from XML file to index solr.

When i try to import it gives me following error. 
------------------------------------------------------------------------------------------------------
SEVERE: Exception while processing: topic_tree document :
SolrInputDocument[{topic_id=topic_id(1.0)={9000034},
category_level_1=category_level_1(1.0)={Internet
Services}}]:org.apache.solr.h
ndler.dataimport.DataImportHandlerException: Unable to execute query:
C:\Projects\att\solr\catalogSOLRSearch.ear\SOLR-HOME\live_meta.xml
Processing Document # 1
        at
org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:72)
        at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:252)
        at
org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:209)
        at
org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:38)
        at
org.apache.solr.handler.dataimport.XPathEntityProcessor.initQuery(XPathEntityProcessor.java:283)
        at
org.apache.solr.handler.dataimport.XPathEntityProcessor.fetchNextRow(XPathEntityProcessor.java:224)
        at
org.apache.solr.handler.dataimport.XPathEntityProcessor.nextRow(XPathEntityProcessor.java:201)
        at
org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:237)
        at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:594)
        at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:620)
        at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:620)
        at
org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:266)
        at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:185)
        at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:358)
        at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:426)
        at
org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:407)

-------------------------------------------------------------------------------------------------------

Here is my dih config file
<dataConfig>
	<dataSource name="esupport_db"
				type="JdbcDataSource" 		
                driver="oracle.jdbc.driver.OracleDriver"
                url="xxxxx" 
                user="xxxx" 
                password="yyyy"
		        convertType="true" />
	
	<dataSource type="FileDataSource" name="video_datasource"/>
	          
    <document>
		<entity name="topic_tree" datasource="esupport_db" 
				query="SELECT topic_id, parent_id,
					   REGEXP_SUBSTR (SYS_CONNECT_BY_PATH (display_name, ';'), '[^;]+', 1,
1) AS category_level_1,
					   FROM src_topic
					   START WITH parent_id = 9000033
					   CONNECT BY parent_id = PRIOR topic_id" 
				deltaQuery="" 
				pk="TOPIC_ID">
            <field column="topic_id" name="topic_id" />
            <field column="category_level_1" name="CATEGORY_LEVEL_1" />
            				
	        <entity name="f" processor="FileListEntityProcessor"
baseDir="${solr.solr.home}" fileName=".xml" 
                recursive="false" rootEntity="true"
dataSource="video_datasource">
    	        <entity name="x" processor="XPathEntityProcessor" 
            	
forEach="/gvpVideoMetaData/mediaItem[@media_id='${topic_tree.topic_id}']" 
            		url="${f.fileAbsolutePath}" 
                    >
                <field column="media_details"
xpath="/gvpVideoMetaData/mediaItem/media_details"/>
                </entity>                               
            </entity>
		</entity>
    </document>
</dataConfig>

--
View this message in context: http://lucene.472066.n3.nabble.com/DIH-error-when-nested-db-datasource-and-file-data-source-tp3345664p3345664.html
Sent from the Solr - User mailing list archive at Nabble.com.

Mime
View raw message