On Thu, Jan 26, 2012 at 3:47 AM, Egonsith <egons...@gmail.com> wrote:
> I have tried to search for my specific problem but have not found solution. I
> have also read the wiki on the DHI and seem to have everything set up right
> but my Query still fails. Thank you for your help
[...]
This has nothing to do with the warning in the title of your message.
That is very likely because the user running DIH (typically the Jetty/
tomcat user) does not have permissions to read/write the
dataimport.properties file in your Solr conf/ directory
The relevant error in your log is the following one:
> *SEVERE: Exception while processing: Titles document :
> SolrInputDocument[{}]:org.apache.solr.handler.dataimport.DataImportHandlerException:
> Unable to execute query: SELECT mrID, mrTitle from
> KnowledgeBase_DM.dbo.AskMe_Data Processing Document # 1*
> at
[...]
> Caused by: java.lang.NullPointerException
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:241)
[...]
Your SQL select is failing for some reason. Please check the
setup there. E.g., one item that is incorrect is the "url" attribute
in:
<dataSource driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="://localhost:1433;DatabaseName=KnowledgeBase_DM" user="user"
password="password" />
It should be something like
url="jdbc:sqlserver://localhost:1433;DatabaseName=KnowledgeBase_DM"
Regards,
Gora
