Your uniqueKey field is defined as id (in schema.xml) and your query doesn't return an id field.
Ephraim Ofir -----Original Message----- From: nitin.vanaku...@gmail.com [mailto:nitin.vanaku...@gmail.com] Sent: Tuesday, November 02, 2010 12:10 PM To: solr-user@lucene.apache.org Subject: RE: Solr MySQL Adding new column to table ok. i have one more issue. i am getting following exception can you please explore on it INFO: Creating a connection for entity person with URL: jdbc:mysql://localhost:3306/example Nov 2, 2010 3:34:11 PM org.apache.solr.handler.dataimport.JdbcDataSource$1 call INFO: Time taken for getConnection(): 250 Nov 2, 2010 3:34:11 PM org.apache.solr.handler.dataimport.SolrWriter upload WARNING: Error creating document : SolrInputDocument[{eage=eage(1.0)={28}, ename=ename(1.0)={shree}, eid=eid(1.0)={1}}] org.apache.solr.common.SolrException: Document is missing uniqueKey field id at org.apache.solr.update.UpdateHandler.getIndexedId(UpdateHandler.java:115 ) at org.apache.solr.update.DirectUpdateHandler2.addDoc(DirectUpdateHandler2. java:230) at org.apache.solr.update.processor.RunUpdateProcessor.processAdd(RunUpdate ProcessorFactory.java:61) at org.apache.solr.handler.dataimport.SolrWriter.upload(SolrWriter.java:75) at org.apache.solr.handler.dataimport.DataImportHandler$1.upload(DataImport Handler.java:292) at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.j ava:392) at org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java :242) at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:18 0) at org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporte r.java:331) at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java :389) at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java: 370) Nov 2, 2010 3:34:11 PM org.apache.solr.handler.dataimport.SolrWriter upload WARNING: Error creating document : SolrInputDocument[{eage=eage(1.0)={29}, ename=ename(1.0)={ramesh}, eid=eid(1.0)={2}}] org.apache.solr.common.SolrException: Document is missing uniqueKey field id at org.apache.solr.update.UpdateHandler.getIndexedId(UpdateHandler.java:115 ) at org.apache.solr.update.DirectUpdateHandler2.addDoc(DirectUpdateHandler2. java:230) at org.apache.solr.update.processor.RunUpdateProcessor.processAdd(RunUpdate ProcessorFactory.java:61) at org.apache.solr.handler.dataimport.SolrWriter.upload(SolrWriter.java:75) at org.apache.solr.handler.dataimport.DataImportHandler$1.upload(DataImport Handler.java:292) at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.j ava:392) at org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java :242) at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:18 0) at org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporte r.java:331) at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java :389) at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java: 370) Nov 2, 2010 3:34:11 PM org.apache.solr.handler.dataimport.DocBuilder finish INFO: Import completed successfully Nov 2, 2010 3:34:11 PM org.apache.solr.update.DirectUpdateHandler2 commit INFO: start commit(optimize=true,waitFlush=false,waitSearcher=true,expungeDeletes=fa lse) -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-MySQL-Adding-new-column-to-table -tp1826759p1827093.html Sent from the Solr - User mailing list archive at Nabble.com.