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 lakshmi bhargavi <la...@gmail.com> on 2012/07/19 21:54:22 UTC

Reg issue with indexing data from one of the sqlserver DB

Hi Team ,

Greetings!

We are trying to index data from one of the sqlserver DB (2008) but we are
getting the following error on start up

Jul 19, 2012 2:41:11 PM org.apache.solr.common.SolrException log
SEVERE: org.apache.solr.common.SolrException
    at org.apache.solr.core.SolrCore.<init>(SolrCore.java:600)
    at org.apache.solr.core.CoreContainer.create(CoreContainer.java:483)
    at org.apache.solr.core.CoreContainer.load(CoreContainer.java:335)
    at org.apache.solr.core.CoreContainer.load(CoreContainer.java:219)
    at
org.apache.solr.core.CoreContainer$Initializer.initialize(CoreContainer.java:161)
    at
org.apache.solr.servlet.SolrDispatchFilter.init(SolrDispatchFilter.java:96)
    at
org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:277)
    at
org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:258)
    at
org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:382)
    at
org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:103)
    at
org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4638)
    at
org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5294)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
    at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:895)
    at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:871)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
    at
org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:649)
    at
org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1585)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown
Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
Caused by: org.apache.solr.common.SolrException: FATAL: Could not create
importer. DataImporter config invalid
    at
org.apache.solr.handler.dataimport.DataImportHandler.inform(DataImportHandler.java:124)
    at
org.apache.solr.core.SolrResourceLoader.inform(SolrResourceLoader.java:527)
    at org.apache.solr.core.SolrCore.<init>(SolrCore.java:594)
    ... 23 more
Caused by: org.apache.solr.handler.dataimport.DataImportHandlerException:
Exception occurred while initializing context
    at
org.apache.solr.handler.dataimport.DataImporter.loadDataConfig(DataImporter.java:216)
    at
org.apache.solr.handler.dataimport.DataImporter.<init>(DataImporter.java:108)
    at
org.apache.solr.handler.dataimport.DataImportHandler.inform(DataImportHandler.java:117)
    ... 25 more
Caused by: org.xml.sax.SAXParseException: The entity name must immediately
follow the '&' in the entity reference.
    at
com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(Unknown
Source)
    at
com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(Unknown
Source)
    at
com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown
Source)
    at
com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(Unknown
Source)
    at
com.sun.org.apache.xerces.internal.impl.XMLScanner.scanAttributeValue(Unknown
Source)
    at
com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanAttribute(Unknown
Source)
    at
com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown
Source)
    at
com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown
Source)
    at
com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown
Source)
    at
com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(Unknown
Source)
    at
com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown
Source)
    at
com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown
Source)
    at
com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown
Source)
    at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown
Source)
    at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(Unknown
Source)
    at
com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Unknown
Source)
    at
org.apache.solr.handler.dataimport.DataImporter.loadDataConfig(DataImporter.java:201)
    ... 27 more

This is the configuration

<dataConfig>
    <dataSource type="JdbcDataSource" name="DGMPO"
driver="net.sourceforge.jtds.jdbc.Driver" url="jdbc:jtds:sqlserver://
devsql08.mmm.com:1530" user="GMPOADMIN" password="8ty&2ty=6"/>


    <document name="GmpoDocuments">

      <entity name="GmpoDocument" dataSource="DGMPO" query="SELECT job_id
as id, job_name as jobname, run_date as rundate, job_Stus_ID as jobstatus
from [DGMPO].[dbo].[t_job]" threads="15">
            <field column="id" name="id"/>
             <field column="jobname" name="jobname"/>
             <field column="rundate" name="rundate" />
             <field column="jobstatus" name="jobstatus" />

        </entity>


        </entity>
    </document>
</dataConfig>

Below is is the data from the table.



Could you please help us out in troubleshooting the issue?

Thanks in advance !
Regards,
lakshmi

Re: Reg issue with indexing data from one of the sqlserver DB

Posted by Michael Della Bitta <mi...@appinions.com>.
Good to hear!

Michael Della Bitta

------------------------------------------------
Appinions, Inc. -- Where Influence Isn’t a Game.
http://www.appinions.com


On Fri, Jul 20, 2012 at 2:56 PM, Lakshmi Bhargavi
<la...@gmail.com> wrote:
> Thank you Michael ..
>
> I overlooked that . Now its working and got the data indexed.
>
> Regards,
> Lakshmi
>
>
>
> --
> View this message in context: http://lucene.472066.n3.nabble.com/Reg-issue-with-indexing-data-from-one-of-the-sqlserver-DB-tp3996078p3996303.html
> Sent from the Solr - User mailing list archive at Nabble.com.

Re: Reg issue with indexing data from one of the sqlserver DB

Posted by Lakshmi Bhargavi <la...@gmail.com>.
Thank you Michael .. 

I overlooked that . Now its working and got the data indexed.

Regards,
Lakshmi



--
View this message in context: http://lucene.472066.n3.nabble.com/Reg-issue-with-indexing-data-from-one-of-the-sqlserver-DB-tp3996078p3996303.html
Sent from the Solr - User mailing list archive at Nabble.com.

Re: Reg issue with indexing data from one of the sqlserver DB

Posted by Michael Della Bitta <mi...@appinions.com>.
Your password has an & in it. Since this is an XML file, you need to
turn it into an XML entity, so your password should be entered as:

8ty&amp;2ty=6

Michael Della Bitta

------------------------------------------------
Appinions, Inc. -- Where Influence Isn’t a Game.
http://www.appinions.com


On Thu, Jul 19, 2012 at 3:54 PM, lakshmi bhargavi
<la...@gmail.com> wrote:
> Hi Team ,
>
> Greetings!
>
> We are trying to index data from one of the sqlserver DB (2008) but we are
> getting the following error on start up
>
> Jul 19, 2012 2:41:11 PM org.apache.solr.common.SolrException log
> SEVERE: org.apache.solr.common.SolrException
>     at org.apache.solr.core.SolrCore.<init>(SolrCore.java:600)
>     at org.apache.solr.core.CoreContainer.create(CoreContainer.java:483)
>     at org.apache.solr.core.CoreContainer.load(CoreContainer.java:335)
>     at org.apache.solr.core.CoreContainer.load(CoreContainer.java:219)
>     at
> org.apache.solr.core.CoreContainer$Initializer.initialize(CoreContainer.java:161)
>     at
> org.apache.solr.servlet.SolrDispatchFilter.init(SolrDispatchFilter.java:96)
>     at
> org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:277)
>     at
> org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:258)
>     at
> org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:382)
>     at
> org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:103)
>     at
> org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4638)
>     at
> org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5294)
>     at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
>     at
> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:895)
>     at
> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:871)
>     at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
>     at
> org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:649)
>     at
> org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1585)
>     at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
>     at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
>     at java.util.concurrent.FutureTask.run(Unknown Source)
>     at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown
> Source)
>     at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
>     at java.lang.Thread.run(Unknown Source)
> Caused by: org.apache.solr.common.SolrException: FATAL: Could not create
> importer. DataImporter config invalid
>     at
> org.apache.solr.handler.dataimport.DataImportHandler.inform(DataImportHandler.java:124)
>     at
> org.apache.solr.core.SolrResourceLoader.inform(SolrResourceLoader.java:527)
>     at org.apache.solr.core.SolrCore.<init>(SolrCore.java:594)
>     ... 23 more
> Caused by: org.apache.solr.handler.dataimport.DataImportHandlerException:
> Exception occurred while initializing context
>     at
> org.apache.solr.handler.dataimport.DataImporter.loadDataConfig(DataImporter.java:216)
>     at
> org.apache.solr.handler.dataimport.DataImporter.<init>(DataImporter.java:108)
>     at
> org.apache.solr.handler.dataimport.DataImportHandler.inform(DataImportHandler.java:117)
>     ... 25 more
> Caused by: org.xml.sax.SAXParseException: The entity name must immediately
> follow the '&' in the entity reference.
>     at
> com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(Unknown
> Source)
>     at
> com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(Unknown
> Source)
>     at
> com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown
> Source)
>     at
> com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(Unknown
> Source)
>     at
> com.sun.org.apache.xerces.internal.impl.XMLScanner.scanAttributeValue(Unknown
> Source)
>     at
> com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanAttribute(Unknown
> Source)
>     at
> com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown
> Source)
>     at
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown
> Source)
>     at
> com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown
> Source)
>     at
> com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(Unknown
> Source)
>     at
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown
> Source)
>     at
> com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown
> Source)
>     at
> com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown
> Source)
>     at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown
> Source)
>     at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(Unknown
> Source)
>     at
> com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Unknown
> Source)
>     at
> org.apache.solr.handler.dataimport.DataImporter.loadDataConfig(DataImporter.java:201)
>     ... 27 more
>
> This is the configuration
>
> <dataConfig>
>     <dataSource type="JdbcDataSource" name="DGMPO"
> driver="net.sourceforge.jtds.jdbc.Driver" url="jdbc:jtds:sqlserver://
> devsql08.mmm.com:1530" user="GMPOADMIN" password="8ty&2ty=6"/>
>
>
>     <document name="GmpoDocuments">
>
>       <entity name="GmpoDocument" dataSource="DGMPO" query="SELECT job_id
> as id, job_name as jobname, run_date as rundate, job_Stus_ID as jobstatus
> from [DGMPO].[dbo].[t_job]" threads="15">
>             <field column="id" name="id"/>
>              <field column="jobname" name="jobname"/>
>              <field column="rundate" name="rundate" />
>              <field column="jobstatus" name="jobstatus" />
>
>         </entity>
>
>
>         </entity>
>     </document>
> </dataConfig>
>
> Below is is the data from the table.
>
>
>
> Could you please help us out in troubleshooting the issue?
>
> Thanks in advance !
> Regards,
> lakshmi