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
