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 <lakshmi.bharg...@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
