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
