please keep in mind that DIH names are case sensitive
try with this
<field column="ORGANIZATION_NAME" name="org" />
On Fri, Jul 24, 2009 at 1:30 AM, Tagge, Tim<tta...@homefinder.com> wrote:
> 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>
>
>
>
--
-----------------------------------------------------
Noble Paul | Principal Engineer| AOL | http://aol.com
