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.
