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
