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&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