Hi,
I'm attempting to setup a simple joined index of some tables with the following
structure...
EMPLOYEE ORGANIZATION
------------ -------------
employee_id organization_id
first_name organization_name
last_name
edr_party_id
organization_id
When running the import, I'm getting this WARNING...
Jul 23, 2009 2:17:41 PM org.apache.solr.handler.dataimport.SolrWriter upload
WARNING: Error creating document : SolrInputDocumnt[{id=id(1.0)={42078},
first_name=first_name(1.0)={Mike}, last_name=last_name(1.0)={Madlock},
edr_party_id=edr
_party_id(1.0)={29131}, organization_id=organization_id(1.0)={138}}]
org.apache.solr.common.SolrException: Document [42078] missing required field:
org
at
org.apache.solr.update.DocumentBuilder.toDocument(DocumentBuilder.java:289)
at
org.apache.solr.update.processor.RunUpdateProcessor.processAdd(RunUpdateProcessorFactory.java:58)
at
org.apache.solr.handler.dataimport.SolrWriter.upload(SolrWriter.java:69)
at
org.apache.solr.handler.dataimport.DataImportHandler$1.upload(DataImportHandler.java:288)
at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:319)
at
org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:178)
at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:136)
at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:334)
at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:386)
at
org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:377)
As a result of this issue, no documents are searchable. If I flip the required
flag to false in schema.xml, the WARNING goes away and the documents are
searchable. However, the documents do not contain organization_name and they
are not searchable by organization_name. Have I overlooked a flag somewhere
that specifies that nested entities are indexed? Or an issue in my config?
I've attached my full data-config and the fields section of schema.xml. Thanks
in advance.
Tim
schema.xml
<fields>
<field name="id" type="integer" indexed="true" stored="true" required="true"
/>
<field name="first_name" type="string" indexed="true" stored="true"
required="false" />
<field name="last_name" type="string" indexed="true" stored="true"
required="false" />
<field name="edr_party_id" type="integer" indexed="true" stored="true"
required="false" />
<field name="org" type="string" indexed="true" stored="true" required="true"
/>
<field name="organization_id" type="integer" indexed="true" stored="true"
required="true" />
<!--field name="city" type="string" indexed="true" stored="true"
required="false" /-->
</fields>
data-config.xml
<dataConfig>
<dataSource
driver="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@hsrdb3:1521:hsint13"
user="user"
password="password" />
<document name="agentDoc">
<entity name="agent" query="SELECT e.employee_id, e.first_name,
e.last_name, e.edr_party_id, e.organization_id
FROM employee e
WHERE e.disabled = 'N'
AND rownum < 1000">
<field column="EMPLOYEE_ID" name="id" />
<field column="FIRST_NAME" name="first_name" />
<field column="LAST_NAME" name="last_name" />
<field column="EDR_PARTY_ID" name="edr_party_id" />
<field column="ORGANIZATION_ID" name="organization_id"
/>
<entity name="organization" query="select
o.organization_name from organizations o where o.organization_id =
'${agent.ORGANIZATION_ID}'">
<field name="org" column="organization_name" />
</entity>
</entity>
</document>
</dataConfig>
