You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Egonsith <eg...@gmail.com> on 2012/01/25 23:17:03 UTC
WARNING: Unable to read: dataimport.properties DHI issue
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
I am running Solr 3.1 with Tomcat 6.0
Windows server 2003 r2 and SQL 2008
I have the sqljdbc4.jar sitting in C:\Program Files\Apache Software
Foundation\Tomcat 6.0\lib
/My solrconfig.xml/
- <requestHandler name="/dataimport"
class="org.apache.solr.handler.dataimport.DataImportHandler">
- <lst name="defaults">
<str name="config">db-data-config.xml</str>
</lst>
</requestHandler>
/My db-data-config.xml/
- <dataConfig>
<dataSource driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="://localhost:1433;DatabaseName=KnowledgeBase_DM" user="user"
password="password" />
- <document>
- <entity dataSource="ds1" name="Titles" query="SELECT mrID, mrTitle from
KnowledgeBase_DM.dbo.AskMe_Data">
<field column="mrID" name="id" />
<field column="mrTitle" name="title" />
- <entity name="Desc" query="select meDescription from
KnowledgeBase_DM.dbo.AskMe_Data">
<field column="meDescription" name="description" />
</entity>
</entity>
</document>
</dataConfig>
/My logfile Output /
Jan 25, 2012 2:17:37 PM org.apache.solr.handler.dataimport.DataImportHandler
processConfiguration
INFO: Processing configuration from solrconfig.xml:
{config=db-data-config.xml}
Jan 25, 2012 2:17:37 PM org.apache.solr.handler.dataimport.DataImporter
loadDataConfig
INFO: Data Configuration loaded successfully
Jan 25, 2012 2:17:37 PM org.apache.solr.handler.dataimport.DataImporter
doFullImport
INFO: Starting Full Import
Jan 25, 2012 2:17:37 PM org.apache.solr.handler.dataimport.SolrWriter
readIndexerProperties
*WARNING: Unable to read: dataimport.properties*
Jan 25, 2012 2:17:37 PM org.apache.solr.handler.dataimport.JdbcDataSource$1
call
INFO: Creating a connection for entity Titles with URL:
://localhost:1433;DatabaseName=KnowledgeBase_DM
Jan 25, 2012 2:17:37 PM org.apache.solr.handler.dataimport.JdbcDataSource$1
call
INFO: Time taken for getConnection(): 0
Jan 25, 2012 2:17:37 PM org.apache.solr.common.SolrException log
*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
org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:72)
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:253)
at
org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:210)
at
org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:39)
at
org.apache.solr.handler.dataimport.DebugLogger$2.getData(DebugLogger.java:188)
at
org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:59)
at
org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:73)
at
org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:238)
at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:591)
at
org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:267)
at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:186)
at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:353)
at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:411)
at
org.apache.solr.handler.dataimport.DataImportHandler.handleRequestBody(DataImportHandler.java:205)
at
org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:129)
at org.apache.solr.core.SolrCore.execute(SolrCore.java:1360)
at
org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter.java:356)
at
org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NullPointerException
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:241)
... 28 more
Jan 25, 2012 2:17:37 PM org.apache.solr.common.SolrException log
*SEVERE: Full Import
failed:org.apache.solr.handler.dataimport.DataImportHandlerException: Unable
to execute query: SELECT mrID, mrTitle from KnowledgeBase_DM.dbo.AskMe_Data
Processing Document # 1*
at
org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:72)
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:253)
at
org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:210)
at
org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:39)
at
org.apache.solr.handler.dataimport.DebugLogger$2.getData(DebugLogger.java:188)
at
org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:59)
at
org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:73)
at
org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:238)
at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:591)
at
org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:267)
at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:186)
at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:353)
at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:411)
at
org.apache.solr.handler.dataimport.DataImportHandler.handleRequestBody(DataImportHandler.java:205)
at
org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:129)
at org.apache.solr.core.SolrCore.execute(SolrCore.java:1360)
at
org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter.java:356)
at
org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NullPointerException
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:241)
... 28 more
Jan 25, 2012 2:17:37 PM org.apache.solr.update.DirectUpdateHandler2 rollback
INFO: start rollback
Jan 25, 2012 2:17:37 PM org.apache.solr.update.DirectUpdateHandler2 rollback
INFO: end_rollback
Jan 25, 2012 2:17:37 PM org.apache.solr.core.SolrCore execute
INFO: [] webapp=/solr path=/select
params={start=0&dataConfig=<dataConfig>%0d%0a%09<dataSource+driver%3D"com.microsoft.sqlserver.jdbc.SQLServerDriver"+url%3D"://localhost:1433;DatabaseName%3DKnowledgeBase_DM"+user%3D"user"+password%3D"password"+/>%0d%0a%09<document>%0d%0a%09%09<entity+dataSource%3D"ds1"+name%3D"Titles"+query%3D"SELECT+mrID,+mrTitle+from+KnowledgeBase_DM.dbo.AskMe_Data">%0d%0a%09%09%09<field+column%3D"mrID"+name%3D"id"+/>%0d%0a%09%09%09<field+column%3D"mrTitle"+name%3D"title"+/>%0d%0a%09%09%09<entity+name%3D"Desc"+query%3D"select+meDescription+from+KnowledgeBase_DM.dbo.AskMe_Data">%0d%0a%09%09%09%09<field+column%3D"meDescription"+name%3D"description"+/>%0d%0a%09%09%09</entity>%0d%0a%09%09</entity>%0d%0a%09</document>%0d%0a</dataConfig>&verbose=on&command=full-import&debug=on&qt=/dataimport&rows=10}
status=0 QTime=10
--
View this message in context: http://lucene.472066.n3.nabble.com/WARNING-Unable-to-read-dataimport-properties-DHI-issue-tp3689183p3689183.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: WARNING: Unable to read: dataimport.properties DHI issue
Posted by Erick Erickson <er...@gmail.com>.
Yeah, that happens. Glad you're past this issue thanks for closing it out.
Erick
On Thu, Jan 26, 2012 at 10:45 AM, Egonsith <eg...@gmail.com> wrote:
> Erik,
>
> Thanks for the reply,
> i a bit embarres to say this is a clasiic example of a way to messy
> development enviroment and these erros were due to many diffrent drivers and
> xml files that were edited way to many times. i have cleaned my dev
> enviromant and reinstalled tomcat and solr and am now getting past this
> error. thank you for the help.
>
> Mike
>
> --
> View this message in context: http://lucene.472066.n3.nabble.com/WARNING-Unable-to-read-dataimport-properties-DHI-issue-tp3689183p3691278.html
> Sent from the Solr - User mailing list archive at Nabble.com.
Re: WARNING: Unable to read: dataimport.properties DHI issue
Posted by Egonsith <eg...@gmail.com>.
Erik,
Thanks for the reply,
i a bit embarres to say this is a clasiic example of a way to messy
development enviroment and these erros were due to many diffrent drivers and
xml files that were edited way to many times. i have cleaned my dev
enviromant and reinstalled tomcat and solr and am now getting past this
error. thank you for the help.
Mike
--
View this message in context: http://lucene.472066.n3.nabble.com/WARNING-Unable-to-read-dataimport-properties-DHI-issue-tp3689183p3691278.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: WARNING: Unable to read: dataimport.properties DHI issue
Posted by Erick Erickson <er...@gmail.com>.
Nothing jumps out at me, but you might you might get some insight
from http://wiki.apache.org/solr/DataImportHandler, see the
"interactive development mode" section. The dataimport.jsp
page is helpful.
It *looks* like you're sql statement is having problems, but
I confess I only glanced at the output...
Best
Erick
On Wed, Jan 25, 2012 at 2:17 PM, Egonsith <eg...@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
>
> I am running Solr 3.1 with Tomcat 6.0
> Windows server 2003 r2 and SQL 2008
>
> I have the sqljdbc4.jar sitting in C:\Program Files\Apache Software
> Foundation\Tomcat 6.0\lib
>
> /My solrconfig.xml/
> - <requestHandler name="/dataimport"
> class="org.apache.solr.handler.dataimport.DataImportHandler">
> - <lst name="defaults">
> <str name="config">db-data-config.xml</str>
> </lst>
> </requestHandler>
>
> /My db-data-config.xml/
> - <dataConfig>
> <dataSource driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
> url="://localhost:1433;DatabaseName=KnowledgeBase_DM" user="user"
> password="password" />
> - <document>
> - <entity dataSource="ds1" name="Titles" query="SELECT mrID, mrTitle from
> KnowledgeBase_DM.dbo.AskMe_Data">
> <field column="mrID" name="id" />
> <field column="mrTitle" name="title" />
> - <entity name="Desc" query="select meDescription from
> KnowledgeBase_DM.dbo.AskMe_Data">
> <field column="meDescription" name="description" />
> </entity>
> </entity>
> </document>
> </dataConfig>
>
>
> /My logfile Output /
> Jan 25, 2012 2:17:37 PM org.apache.solr.handler.dataimport.DataImportHandler
> processConfiguration
> INFO: Processing configuration from solrconfig.xml:
> {config=db-data-config.xml}
> Jan 25, 2012 2:17:37 PM org.apache.solr.handler.dataimport.DataImporter
> loadDataConfig
> INFO: Data Configuration loaded successfully
> Jan 25, 2012 2:17:37 PM org.apache.solr.handler.dataimport.DataImporter
> doFullImport
> INFO: Starting Full Import
> Jan 25, 2012 2:17:37 PM org.apache.solr.handler.dataimport.SolrWriter
> readIndexerProperties
> *WARNING: Unable to read: dataimport.properties*
> Jan 25, 2012 2:17:37 PM org.apache.solr.handler.dataimport.JdbcDataSource$1
> call
> INFO: Creating a connection for entity Titles with URL:
> ://localhost:1433;DatabaseName=KnowledgeBase_DM
> Jan 25, 2012 2:17:37 PM org.apache.solr.handler.dataimport.JdbcDataSource$1
> call
> INFO: Time taken for getConnection(): 0
> Jan 25, 2012 2:17:37 PM org.apache.solr.common.SolrException log
> *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
> org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:72)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:253)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:210)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:39)
> at
> org.apache.solr.handler.dataimport.DebugLogger$2.getData(DebugLogger.java:188)
> at
> org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:59)
> at
> org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:73)
> at
> org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:238)
> at
> org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:591)
> at
> org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:267)
> at
> org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:186)
> at
> org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:353)
> at
> org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:411)
> at
> org.apache.solr.handler.dataimport.DataImportHandler.handleRequestBody(DataImportHandler.java:205)
> at
> org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:129)
> at org.apache.solr.core.SolrCore.execute(SolrCore.java:1360)
> at
> org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter.java:356)
> at
> org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
> at java.lang.Thread.run(Unknown Source)
> Caused by: java.lang.NullPointerException
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:241)
> ... 28 more
>
> Jan 25, 2012 2:17:37 PM org.apache.solr.common.SolrException log
> *SEVERE: Full Import
> failed:org.apache.solr.handler.dataimport.DataImportHandlerException: Unable
> to execute query: SELECT mrID, mrTitle from KnowledgeBase_DM.dbo.AskMe_Data
> Processing Document # 1*
> at
> org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:72)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:253)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:210)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:39)
> at
> org.apache.solr.handler.dataimport.DebugLogger$2.getData(DebugLogger.java:188)
> at
> org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:59)
> at
> org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:73)
> at
> org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:238)
> at
> org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:591)
> at
> org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:267)
> at
> org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:186)
> at
> org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:353)
> at
> org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:411)
> at
> org.apache.solr.handler.dataimport.DataImportHandler.handleRequestBody(DataImportHandler.java:205)
> at
> org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:129)
> at org.apache.solr.core.SolrCore.execute(SolrCore.java:1360)
> at
> org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter.java:356)
> at
> org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
> at java.lang.Thread.run(Unknown Source)
> Caused by: java.lang.NullPointerException
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:241)
> ... 28 more
>
> Jan 25, 2012 2:17:37 PM org.apache.solr.update.DirectUpdateHandler2 rollback
> INFO: start rollback
> Jan 25, 2012 2:17:37 PM org.apache.solr.update.DirectUpdateHandler2 rollback
> INFO: end_rollback
> Jan 25, 2012 2:17:37 PM org.apache.solr.core.SolrCore execute
> INFO: [] webapp=/solr path=/select
> params={start=0&dataConfig=<dataConfig>%0d%0a%09<dataSource+driver%3D"com.microsoft.sqlserver.jdbc.SQLServerDriver"+url%3D"://localhost:1433;DatabaseName%3DKnowledgeBase_DM"+user%3D"user"+password%3D"password"+/>%0d%0a%09<document>%0d%0a%09%09<entity+dataSource%3D"ds1"+name%3D"Titles"+query%3D"SELECT+mrID,+mrTitle+from+KnowledgeBase_DM.dbo.AskMe_Data">%0d%0a%09%09%09<field+column%3D"mrID"+name%3D"id"+/>%0d%0a%09%09%09<field+column%3D"mrTitle"+name%3D"title"+/>%0d%0a%09%09%09<entity+name%3D"Desc"+query%3D"select+meDescription+from+KnowledgeBase_DM.dbo.AskMe_Data">%0d%0a%09%09%09%09<field+column%3D"meDescription"+name%3D"description"+/>%0d%0a%09%09%09</entity>%0d%0a%09%09</entity>%0d%0a%09</document>%0d%0a</dataConfig>&verbose=on&command=full-import&debug=on&qt=/dataimport&rows=10}
> status=0 QTime=10
>
>
>
>
> --
> View this message in context: http://lucene.472066.n3.nabble.com/WARNING-Unable-to-read-dataimport-properties-DHI-issue-tp3689183p3689183.html
> Sent from the Solr - User mailing list archive at Nabble.com.
Re: WARNING: Unable to read: dataimport.properties DHI issue
Posted by Gora Mohanty <go...@mimirtech.com>.
On Thu, Jan 26, 2012 at 3:47 AM, Egonsith <eg...@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