Right. This is REALLY weird - I've now started from scratch on another machine (this time Windows 7), and got _exactly_ the same problem !?
On Mon, Nov 28, 2011 at 7:37 AM, Husain, Yavar <yhus...@firstam.com> wrote: > Hi Ian > > I am having exactly the same problem what you are having on Win 7 and 2008 > Server http://lucene.472066.n3.nabble.com/DIH-Strange-Problem-tc3530370.html > > I still have not received any replies which could solve my problem till now. > Please do let me know if you have arrived at some solution for your problem. > > Thanks. > > Regards, > Yavar > > -----Original Message----- > From: Ian Grainger [mailto:i...@isfluent.com] > Sent: Friday, November 25, 2011 10:59 PM > To: solr-user@lucene.apache.org > Subject: Re: Unable to index documents using DataImportHandler with MSSQL > > Update on this: I've established: > * It's not a problem in the DB (I can index from this DB into a Solr > instance on another server) > * It's not Tomcat (I get the same problem in Jetty) > * It's not the schema (I have simplified it to one field) > > That leaves SolrConfig.xml and data-config. > > Only thing changed in SolrConfig.xml is adding: > > <lib dir="D:/Software/Solr/example/solr/dist/" > regex="apache-solr-cell-\d.*\.jar" /> > <lib dir="D:/Software/Solr/example/solr/dist/" > regex="apache-solr-clustering-\d.*\.jar" /> > <lib dir="D:/Software/Solr/example/solr/dist/" > regex="apache-solr-dataimporthandler-\d.*\.jar" /> > <requestHandler name="/dataimport" > class="org.apache.solr.handler.dataimport.DataImportHandler"> > <lst name="defaults"> > <str name="config">D:/Software/Solr/example/solr/conf/data-config.xml</str> > </lst> > </requestHandler> > > And data-config.xml is pretty much as attached - except simpler. > > Any help or any advice on how to diagnose would be appreciated! > > > On Fri, Nov 25, 2011 at 12:29 PM, Ian Grainger <i...@isfluent.com> wrote: >> Hi I have copied my Solr config from a working Windows server to a new >> one, and it can't seem to run an import. >> >> They're both using win server 2008 and SQL 2008R2. This is the data >> importer config >> >> <dataConfig> >> <dataSource type="JdbcDataSource" name="ds1" >> driver="com.microsoft.sqlserver.jdbc.SQLServerDriver" >> url="jdbc:sqlserver://localhost;databaseName=DB" >> user="Solr" >> password="pwd"/> >> <document name="datas"> >> <entity name="data" dataSource="ds1" pk="key" >> query="EXEC SOLR_COMPANY_SEARCH_DATA" >> deltaImportQuery="SELECT * FROM Company_Search_Data WHERE >> [key]='${dataimporter.delta.key}'" >> deltaQuery="SELECT [key] FROM Company_Search_Data WHERE modify_dt >>> '${dataimporter.last_index_time}'"> >> <field column="WorkDesc_Comments" >> name="WorkDesc_Comments_Split" /> >> <field column="WorkDesc_Comments" name="WorkDesc_Comments_Edge" >> /> >> </entity> >> </document> >> </dataConfig> >> >> I can use MS SQL Profiler to watch the Solr user log in successfully, >> but then nothing. It doesn't seem to even try and execute the stored >> procedure. Any ideas why this would be working one server and not on >> another? >> >> FTR the only thing in the tomcat catalina log is: >> >> org.apache.solr.handler.dataimport.JdbcDataSource$1 call >> INFO: Creating a connection for entity data with URL: >> jdbc:sqlserver://localhost;databaseName=CATLive >> >> -- >> Ian >> >> i...@isfluent.com >> +44 (0)1223 257903 >> > > > > -- > Ian > > i...@isfluent.com > +44 (0)1223 257903 > ****************************************************************************************** > This message may contain confidential or proprietary information intended > only for the use of the > addressee(s) named above or may contain information that is legally > privileged. If you are > not the intended addressee, or the person responsible for delivering it to > the intended addressee, > you are hereby notified that reading, disseminating, distributing or copying > this message is strictly > prohibited. If you have received this message by mistake, please immediately > notify us by > replying to the message and delete the original message and any copies > immediately thereafter. > > Thank you.- > ****************************************************************************************** > FAFLD > > -- Ian i...@isfluent.com +44 (0)1223 257903
