FYI - This is fixed in trunk. 2009/10/9 Noble Paul നോബിള് नोब्ळ् <noble.p...@corp.aol.com>
> raised an issue > https://issues.apache.org/jira/browse/SOLR-1500 > > On Fri, Oct 9, 2009 at 7:10 AM, jayakeerthi s <mail2keer...@gmail.com> > wrote: > > Hi All, > > > > I tried Indexing data and got the following error., Used Solr nightly > Oct5th > > and nightly 8th, The same Configuration/query is working in Older > > version(May nightly Build) > > > > The db-data-config.xml has the simple Select query > > > > > > SEVERE: Full Import failed > > org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to > > execute query: select CATALOG_ID, CATALOG_NUMBER, CATALOG_NAME, > > SEGMENTATION_ > > TYPE, BEGIN_OFFER_DATE, END_OFFER_DATE, FUTURE_BEGIN_DATE, > FUTURE_END_DATE, > > ATONCE_BEGIN_DATE, ATONCE_END_DATE, REFERENCE_BEGIN_DATE, > REFERENCE_END_DA > > TE, BEGIN_SEASON, LANGUAGE, COUNTRY, SIZE_TYPE, CURRENCY, DIVISION, > > LIFECYCLE, PRODUCT_CD, STYLE_CD, GLOBAL_STYLE_NAME, REGION_STYLE_NAME, > > NEW_STYLE, > > SIZE_RUN, COLOR_NBR, GLOBAL_COLOR_DESC, REGION_COLOR_DESC, WIDTH, > CATEGORY, > > SUB_CATEGORY, CATEGORY_SUMMARY, CATEGORY_CORE_FOCUS, SPORT_ACTIVITY, > SPORT > > _ACTIVITY_SUMMARY, GENDER_AGE, GENDER_AGE_SUMMARY, SILO, SILHOUETTE, > > SILHOUETTE_SUMMARY, SEGMENTATION_TIER, PRIMARY_COLOR, NEW_PRODUCT, > > CARRYOVER_PROD > > UCT, WHOLESALE_AMOUNT, RETAIL_AMOUNT, CATALOG_LAST_MOD_DATE, > > PRODUCT_LAST_MOD_DATE, STYLE_LAST_MOD_DATE, CATALOG_ID || '-' || > PRODUCT_CD > > as UNIQ from > > prodsearch_atlasatgcombine 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.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:58) > > at > > > org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:71) > > at > > > org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:237) > > at > > > org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:356) > > at > > > org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:242) > > at > > > org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:180) > > at > > > org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.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) > > Caused by: java.sql.SQLException: Unsupported feature > > at > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) > > at > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) > > at > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269) > > at > > > oracle.jdbc.dbaccess.DBError.throwUnsupportedFeatureSqlException(DBError.java:689) > > at > > > oracle.jdbc.driver.OracleConnection.setHoldability(OracleConnection.java:3065) > > at > > > org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:191) > > at > > > org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:128) > > at > > > org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcDataSource.java:363) > > at > > > org.apache.solr.handler.dataimport.JdbcDataSource.access$300(JdbcDataSource.java:39) > > at > > > org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:240) > > ... 11 more > > Oct 8, 2009 6:30:23 PM org.apache.solr.update.DirectUpdateHandler2 > rollback > > INFO: start rollback > > Oct 8, 2009 6:30:23 PM org.apache.solr.update.DirectUpdateHandler2 > rollback > > INFO: end_rollback > > 2009-10-08 18:31:12.149::INFO: Shutdown hook executing > > 2009-10-08 18:31:12.149::INFO: Shutdown hook complete > > > > Thanks and regards, > > JK > > > > > > -- > ----------------------------------------------------- > Noble Paul | Principal Engineer| AOL | http://aol.com > -- Regards, Shalin Shekhar Mangar.
