Re: Problem in using Unique key

[con]

Thanks for your update.
But in that case, while doing a full-import I am getting the following
error:

org.apache.solr.common.SolrException: QueryElevationComponent requires the
schema to have a uniqueKeyField 
        at
org.apache.solr.handler.component.QueryElevationComponent.inform(QueryElevationComponent.java:158)
        at
org.apache.solr.core.SolrResourceLoader.inform(SolrResourceLoader.java:311)
        at org.apache.solr.core.SolrCore.<init>(SolrCore.java:480)
        at
org.apache.solr.core.CoreContainer$Initializer.initialize(CoreContainer.java:119)
        at
org.apache.solr.servlet.SolrDispatchFilter.init(SolrDispatchFilter.java:69)
        at org.mortbay.jetty.servlet.FilterHolder.doStart(FilterHolder.java:99)
        at 
org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
        at
org.mortbay.jetty.servlet.ServletHandler.initialize(ServletHandler.java:594)
        at org.mortbay.jetty.servlet.Context.startContext(Context.java:139)
        at
org.mortbay.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1218)
        at
org.mortbay.jetty.handler.ContextHandler.doStart(ContextHandler.java:500)
        at 
org.mortbay.jetty.webapp.WebAppContext.doStart(WebAppContext.java:448)
        at 
org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
        at
org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:147)
        at
org.mortbay.jetty.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:161)
        at 
org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
        at
org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:147)
        at 
org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
        at
org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:117)
        at org.mortbay.jetty.Server.doStart(Server.java:210)
        at 
org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
        at org.mortbay.xml.XmlConfiguration.main(XmlConfiguration.java:929)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.mortbay.start.Main.invokeMain(Main.java:183)
        at org.mortbay.start.Main.start(Main.java:497)
        at org.mortbay.start.Main.main(Main.java:115)

Also, in the schema.xml, for the uniqueKey field there something like:
<!-- Field to use to determine and enforce document uniqueness. 
      Unless this field is marked with required="false", it will be a
required field
   -->

That's why I put the required=false attribute.

Thanks
con



Noble Paul നോബിള്‍ नोब्ळ् wrote:
> 
> <uniqueKey required="false">userID</uniqueKey>
> I do not think there is a required attribute on uniquekey
> By default uniquekey is required . If you do not want to make it
> required remove the tag itself means no uniqueKey
> --Noble
> 
> On Wed, Oct 8, 2008 at 1:17 PM, con <[EMAIL PROTECTED]> wrote:
>>
>> hi guys
>> I am indexing values from an oracle db and them performing searching.
>> Since I have to search multiple tables, that is no way related to each
>> other, I have changed the uniquekey constraint in schema.xml to false.
>>  <uniqueKey required="false">userID</uniqueKey>
>> But when I do indexing, the values from the table that does not have the
>> column USERID is not getting indexed,
>>
>> WARNING: Error creating document :
>> SolrInputDocumnt[{rowtype=rowtype(1.0)={role}
>> , INVOICEID=INVOICEID(1.0)[EMAIL PROTECTED], RATE=RATE(1.0)={1000}}]
>> org.apache.solr.common.SolrException: Document [null] missing required
>> field: USERID
>>        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)
>> 8 Oct, 2008 12:54:48 PM
>> org.apache.solr.handler.dataimport.JdbcDataSource$1
>> call
>>
>> Is there something I missed or done anything wrong.
>>
>> thanks in advance.
>>
>> con
>> --
>> View this message in context:
>> http://www.nabble.com/Problem-in-using-Unique-key-tp19873980p19873980.html
>> Sent from the Solr - User mailing list archive at Nabble.com.
>>
>>
> 
> 
> 
> -- 
> --Noble Paul
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Problem-in-using-Unique-key-tp19873980p19876414.html
Sent from the Solr - User mailing list archive at Nabble.com.