Re: Unable to use DataImportHandler

2011-05-03 Thread Erick Erickson
OK, put it back According to this page: http://wiki.apache.org/solr/DataImportHandler#Configuration_in_data-config.xml-1 the pk is used for delta imports and "has no relation to uniqueKey defined in the schema.xml...". The error you're getting is because your schema.xml defines the "id" fiel

Re: Unable to use DataImportHandler

2011-05-03 Thread serenity keningston
Dear Erick, I am using Solr 1.4 version. Yes, for each row , we will get one fileNo which is the primary key for the table "file". No, I intentionally removed the from the data-config.xml I tried opening the dataimport.jsp to debug but I don't know, it doesn't show any result but it updates the

Re: Unable to use DataImportHandler

2011-05-03 Thread Erick Erickson
The next thing to check is if your select statement returns the fileNo for every field. Wait.. You took out the bit of your entity definition, is that a cut/paste error? You might get some joy from the DIH debug page at: solr/admin/dataimport.jsp it's not very well known, but it's a debug consol

Re: Unable to use DataImportHandler

2011-05-03 Thread serenity keningston
Dear Stefan, Am still getting the following error message even after including the pk-Attribute to the query : WARNING: Error creating document : SolrInputDocument[{lname=lname(1.0)={cindy}, file=file(1.0)={ http://localhost:8084/Access/UploadFiles/laura.mp3}, fname=fname(1.0)={troutman}}] org.ap

Re: Unable to use DataImportHandler

2011-05-03 Thread Stefan Matheis
Serenity, there is no field fileNo in your SELECT-Query? you've defined it in the pk-Attribut of the Tag, but it's also required in the Query itself. just to note it: you can skip your definition, if the query returns the field with exactly the same name as the solr-schema requires it. Regards

Unable to use DataImportHandler

2011-05-03 Thread serenity keningston
Hello Friends, I am new to Solr and experiencing issue while trying to use DataImportHandler. I added the required fields to schema.xml file and here is my data-config.xml file : I am getting the following errors : org.apache.solr.common.SolrExcepti