Hello,
I get Unknown field error when I'm indexing an Oracle dB. I've reduced the
number of fields/columns in order to troubleshoot. If I change the uniqeKey
to timestamp (for example) and create a dynamic field <dynamicField name="*"
type="text" indexed="true" stored="true"> the indexing works fine, except
the id-field is empty.
--data-config.xml---------------------------------------------------------------
...
<dataSource driver="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@host:port/service-name"
user="user"
password="pw"
name="ds1"/>
...
<entity name="document"
pk="PUBID"
query="SELECT PUBID FROM UPLMAIN"
dataSource="ds1">
<field column="PUBID" name="id"/>
</entity>
...
--------------------------------------------------------------------------------------
--schema.xml-------------------------------------------------------------------
...
<field name="id" type="text" indexed="true" stored="true" required="true" />
...
<uniqueKey>id</uniqueKey>
...
------------------------------------------------------------------------------------
--ERROR-message--------------------------------------------------------
2008-nov-25 12:25:25 org.apache.solr.handler.dataimport.SolrWriter upload
VARNING: Error creating document :
SolrInputDocument[{PUBID=PUBID(1.0)={43392}}]
org.apache.solr.common.SolrException: ERROR:unknown field 'PUBID'
at
org.apache.solr.update.DocumentBuilder.toDocument(DocumentBuilder.java:274)
...
-----------------------------------------------------------------------------------
Anyone who had similar problems or knows how to solve this!? Any help is
truly appreciated!!
// Joel
