apparently you have not specified the deltaQuery attribute in the entity.
Check the delta-import section in the wiki
http://wiki.apache.org/solr/DataImportHandler
or you can share your data-config file and we can take a quick look
On Tue, Oct 14, 2008 at 5:05 PM, Florian Aumeier
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have some problems with delta-import. Here are the infos I have.
>
> The result from the web API, apparantly everything is fine:
> <response>
> −
> <lst name="responseHeader">
> <int name="status">0</int>
> <int name="QTime">0</int>
> </lst>
> −
> <lst name="initArgs">
> −
> <lst name="defaults">
> <str name="config">db-psql-data-config.xml</str>
> </lst>
> </lst>
> <str name="status">idle</str>
> <str name="importResponse"/>
> −
> <lst name="statusMessages">
> <str name="Time Elapsed">0:29:30.615</str>
> <str name="Total Requests made to DataSource">1</str>
> <str name="Total Rows Fetched">16194</str>
> <str name="Total Documents Processed">0</str>
> <str name="Total Documents Skipped">0</str>
> <str name="Delta Dump started">2008-10-14 11:23:31</str>
> <str name="Identifying Delta">2008-10-14 11:23:31</str>
> <str name="Deltas Obtained">2008-10-14 11:32:16</str>
> <str name="Building documents">2008-10-14 11:32:16</str>
> <str name="Total Changed Documents">16194</str>
> </lst>
> −
> <str name="WARNING">
> This response format is experimental. It is likely to change in the future.
> </str>
> </response>
>
> From the log:
> INFO: Starting Delta Import
> Oct 14, 2008 11:23:31 AM org.apache.solr.core.SolrCore execute
> INFO: [db] webapp=/solr path=/dataimport params={command=delta-import}
> status=0 QTime=1
> Oct 14, 2008 11:23:31 AM org.apache.solr.handler.dataimport.SolrWriter
> readIndexerProperties
> INFO: Read dataimport.properties
> Oct 14, 2008 11:23:31 AM org.apache.solr.handler.dataimport.DocBuilder
> doDelta
> INFO: Starting delta collection.
> Oct 14, 2008 11:23:31 AM org.apache.solr.handler.dataimport.DocBuilder
> collectDelta
> INFO: Running ModifiedRowKey() for Entity: articles
> Oct 14, 2008 11:23:31 AM org.apache.solr.handler.dataimport.JdbcDataSource$1
> call
> INFO: Creating a connection for entity articles with URL:
> jdbc:postgresql://bm02:5432/bm
> Oct 14, 2008 11:23:35 AM org.apache.solr.handler.dataimport.JdbcDataSource$1
> call
> INFO: Time taken for getConnection(): 3694
> Oct 14, 2008 11:29:16 AM org.apache.solr.core.SolrCore execute
> INFO: [db] webapp=/solr path=/dataimport params={} status=0 QTime=0
> Oct 14, 2008 11:32:16 AM org.apache.solr.handler.dataimport.DocBuilder
> collectDelta
> INFO: Completed ModifiedRowKey for Entity: articles rows obtained : 16194
> Oct 14, 2008 11:32:16 AM org.apache.solr.handler.dataimport.DocBuilder
> collectDelta
> INFO: Running DeletedRowKey() for Entity: articles
> Oct 14, 2008 11:32:16 AM org.apache.solr.handler.dataimport.DocBuilder
> collectDelta
> INFO: Completed DeletedRowKey for Entity: articles rows obtained : 0
> Oct 14, 2008 11:32:16 AM org.apache.solr.handler.dataimport.DocBuilder
> collectDelta
> INFO: Completed parentDeltaQuery for Entity: articles
> Oct 14, 2008 11:32:16 AM org.apache.solr.handler.dataimport.DataImporter
> doDeltaImport
> SEVERE: Delta Import Failed
> java.lang.NullPointerException
> at
> org.apache.solr.handler.dataimport.SqlEntityProcessor.getDeltaImportQuery(SqlEntityProcessor.java:136)
> at
> org.apache.solr.handler.dataimport.SqlEntityProcessor.getQuery(SqlEntityProcessor.java:125)
> at
> org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:73)
> at
> org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:285)
> at
> org.apache.solr.handler.dataimport.DocBuilder.doDelta(DocBuilder.java:211)
> at
> org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:133)
> at
> org.apache.solr.handler.dataimport.DataImporter.doDeltaImport(DataImporter.java:359)
> at
> org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:388)
> at
> org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:377)
>
>
> Any help and or hints is appreciated
> Florian
>
>
>
--
--Noble Paul
