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