You are viewing a plain text version of this content. The canonical link for it is here.

Posted to solr-user@lucene.apache.org by radha c <ra...@gmail.com> on 2009/03/20 13:56:03 UTC

Error in identifying the primary key

Hi,

I am new to Solr. I am trying to index SQL table rows.
I am getting the below error. Can anyone help me in resolving this issue.

Mar 20, 2009 6:03:38 PM org.apache.solr.handler.dataimport.DataImporter
verifyWithSchema
INFO: id is a required field in SolrSchema . But not found in DataConfig
Mar 20, 2009 6:03:38 PM org.apache.solr.handler.dataimport.DataImportHandler
inform
SEVERE: Exception while loading DataImporter
org.apache.solr.handler.dataimport.DataImportHandlerException: There are
errors in the Schema
The field :age present in DataConfig does not have a counterpart in Solr
Schema
The field :firstname present in DataConfig does not have a counterpart in
Solr Schema
The field :lastName present in DataConfig does not have a counterpart in
Solr Schema

        at
org.apache.solr.handler.dataimport.DataImporter.<init>(DataImporter.java:108)
        at
org.apache.solr.handler.dataimport.DataImportHandler.inform(DataImportHandler.java:95)
        at
org.apache.solr.core.SolrResourceLoader.inform(SolrResourceLoader.java:388)
        at org.apache.solr.core.SolrCore.<init>(SolrCore.java:571)
        at
org.apache.solr.core.CoreContainer$Initializer.initialize(CoreContainer.java:121)
        at
org.apache.solr.servlet.SolrDispatchFilter.init(SolrDispatchFilter.java:69)
        at
org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:221)
        at
org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:302)
        at
org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:78)
        at
org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:3635)
        at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4222)
        at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
        at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
        at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
        at
org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:831)
        at
org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:720)
        at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
        at
org.apache.catalina.startup.HostConfig.start(HostConfig.java:1150)
        at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
        at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
        at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
        at
org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
        at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
        at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
        at
org.apache.catalina.core.StandardService.start(StandardService.java:448)
        at
org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
Mar 20, 2009 6:03:38 PM org.apache.solr.servlet.SolrDispatchFilter init
SEVERE: Could not start SOLR. Check solr/home property
org.apache.solr.common.SolrException: FATAL: Could not create importer.
DataImporter config invalid
        at
org.apache.solr.handler.dataimport.DataImportHandler.inform(DataImportHandler.java:103)
        at
org.apache.solr.core.SolrResourceLoader.inform(SolrResourceLoader.java:388)
        at org.apache.solr.core.SolrCore.<init>(SolrCore.java:571)
        at
org.apache.solr.core.CoreContainer$Initializer.initialize(CoreContainer.java:121)
        at
org.apache.solr.servlet.SolrDispatchFilter.init(SolrDispatchFilter.java:69)

Thanks

Re: Error in identifying the primary key

Posted by radha c <ra...@gmail.com>.

Thanks a lot Nobel,

I missed primary field definition in the schema.xml. I added the field
definition and it is working now.

2009/3/20 Noble Paul നോബിള്‍ नोब्ळ् <no...@gmail.com>

> for all the fields mentioned in data-config.xml there should be a
> counterpart in schema.xml
>
> anyway that is relaxed in the latest nightly
>
>
>
> On Fri, Mar 20, 2009 at 6:26 PM, radha c <ra...@gmail.com> wrote:
> > Hi,
> >
> > I am new to Solr. I am trying to index SQL table rows.
> > I am getting the below error. Can anyone help me in resolving this issue.
> >
> > Mar 20, 2009 6:03:38 PM org.apache.solr.handler.dataimport.DataImporter
> > verifyWithSchema
> > INFO: id is a required field in SolrSchema . But not found in DataConfig
> > Mar 20, 2009 6:03:38 PM
> org.apache.solr.handler.dataimport.DataImportHandler
> > inform
> > SEVERE: Exception while loading DataImporter
> > org.apache.solr.handler.dataimport.DataImportHandlerException: There are
> > errors in the Schema
> > The field :age present in DataConfig does not have a counterpart in Solr
> > Schema
> > The field :firstname present in DataConfig does not have a counterpart in
> > Solr Schema
> > The field :lastName present in DataConfig does not have a counterpart in
> > Solr Schema
> >
> >        at
> >
> org.apache.solr.handler.dataimport.DataImporter.<init>(DataImporter.java:108)
> >        at
> >
> org.apache.solr.handler.dataimport.DataImportHandler.inform(DataImportHandler.java:95)
> >        at
> >
> org.apache.solr.core.SolrResourceLoader.inform(SolrResourceLoader.java:388)
> >        at org.apache.solr.core.SolrCore.<init>(SolrCore.java:571)
> >        at
> >
> org.apache.solr.core.CoreContainer$Initializer.initialize(CoreContainer.java:121)
> >        at
> >
> org.apache.solr.servlet.SolrDispatchFilter.init(SolrDispatchFilter.java:69)
> >        at
> >
> org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:221)
> >        at
> >
> org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:302)
> >        at
> >
> org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:78)
> >        at
> >
> org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:3635)
> >        at
> > org.apache.catalina.core.StandardContext.start(StandardContext.java:4222)
> >        at
> >
> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
> >        at
> > org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
> >        at
> > org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
> >        at
> > org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:831)
> >        at
> > org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:720)
> >        at
> > org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
> >        at
> > org.apache.catalina.startup.HostConfig.start(HostConfig.java:1150)
> >        at
> >
> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
> >        at
> >
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
> >        at
> > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
> >        at
> > org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
> >        at
> > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
> >        at
> > org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
> >        at
> > org.apache.catalina.core.StandardService.start(StandardService.java:448)
> >        at
> > org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
> >        at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
> >        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >        at
> >
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >        at
> >
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >        at java.lang.reflect.Method.invoke(Method.java:585)
> >        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
> >        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
> > Mar 20, 2009 6:03:38 PM org.apache.solr.servlet.SolrDispatchFilter init
> > SEVERE: Could not start SOLR. Check solr/home property
> > org.apache.solr.common.SolrException: FATAL: Could not create importer.
> > DataImporter config invalid
> >        at
> >
> org.apache.solr.handler.dataimport.DataImportHandler.inform(DataImportHandler.java:103)
> >        at
> >
> org.apache.solr.core.SolrResourceLoader.inform(SolrResourceLoader.java:388)
> >        at org.apache.solr.core.SolrCore.<init>(SolrCore.java:571)
> >        at
> >
> org.apache.solr.core.CoreContainer$Initializer.initialize(CoreContainer.java:121)
> >        at
> >
> org.apache.solr.servlet.SolrDispatchFilter.init(SolrDispatchFilter.java:69)
> >
> > Thanks
> >
>
>
>
> --
> --Noble Paul
>

Re: Error in identifying the primary key

Posted by Noble Paul നോബിള്‍ नोब्ळ् <no...@gmail.com>.

for all the fields mentioned in data-config.xml there should be a
counterpart in schema.xml

anyway that is relaxed in the latest nightly



On Fri, Mar 20, 2009 at 6:26 PM, radha c <ra...@gmail.com> wrote:
> Hi,
>
> I am new to Solr. I am trying to index SQL table rows.
> I am getting the below error. Can anyone help me in resolving this issue.
>
> Mar 20, 2009 6:03:38 PM org.apache.solr.handler.dataimport.DataImporter
> verifyWithSchema
> INFO: id is a required field in SolrSchema . But not found in DataConfig
> Mar 20, 2009 6:03:38 PM org.apache.solr.handler.dataimport.DataImportHandler
> inform
> SEVERE: Exception while loading DataImporter
> org.apache.solr.handler.dataimport.DataImportHandlerException: There are
> errors in the Schema
> The field :age present in DataConfig does not have a counterpart in Solr
> Schema
> The field :firstname present in DataConfig does not have a counterpart in
> Solr Schema
> The field :lastName present in DataConfig does not have a counterpart in
> Solr Schema
>
>        at
> org.apache.solr.handler.dataimport.DataImporter.<init>(DataImporter.java:108)
>        at
> org.apache.solr.handler.dataimport.DataImportHandler.inform(DataImportHandler.java:95)
>        at
> org.apache.solr.core.SolrResourceLoader.inform(SolrResourceLoader.java:388)
>        at org.apache.solr.core.SolrCore.<init>(SolrCore.java:571)
>        at
> org.apache.solr.core.CoreContainer$Initializer.initialize(CoreContainer.java:121)
>        at
> org.apache.solr.servlet.SolrDispatchFilter.init(SolrDispatchFilter.java:69)
>        at
> org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:221)
>        at
> org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:302)
>        at
> org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:78)
>        at
> org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:3635)
>        at
> org.apache.catalina.core.StandardContext.start(StandardContext.java:4222)
>        at
> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
>        at
> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
>        at
> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
>        at
> org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:831)
>        at
> org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:720)
>        at
> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
>        at
> org.apache.catalina.startup.HostConfig.start(HostConfig.java:1150)
>        at
> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
>        at
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
>        at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
>        at
> org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
>        at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
>        at
> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
>        at
> org.apache.catalina.core.StandardService.start(StandardService.java:448)
>        at
> org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
>        at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
>        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>        at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>        at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>        at java.lang.reflect.Method.invoke(Method.java:585)
>        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
>        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
> Mar 20, 2009 6:03:38 PM org.apache.solr.servlet.SolrDispatchFilter init
> SEVERE: Could not start SOLR. Check solr/home property
> org.apache.solr.common.SolrException: FATAL: Could not create importer.
> DataImporter config invalid
>        at
> org.apache.solr.handler.dataimport.DataImportHandler.inform(DataImportHandler.java:103)
>        at
> org.apache.solr.core.SolrResourceLoader.inform(SolrResourceLoader.java:388)
>        at org.apache.solr.core.SolrCore.<init>(SolrCore.java:571)
>        at
> org.apache.solr.core.CoreContainer$Initializer.initialize(CoreContainer.java:121)
>        at
> org.apache.solr.servlet.SolrDispatchFilter.init(SolrDispatchFilter.java:69)
>
> Thanks
>



-- 
--Noble Paul