Hi All,I am trying to use solr with 2 cores interacting with 2 different
databases, one core is executing full-import successfully where as when I am
running for 2nd one it is throwing table or view not found exception. If I
am using the query directly It is running fine. Below is the error meassge I
am getting.Kindly help me, not able to understand what could be the issue
here.I am using solr 6.4.1. 2017-04-10 09:17:23.167 INFO (Thread-14) [
x:aggr_content] o.a.s.h.d.DataImporter Starting Full Import2017-04-10
09:17:23.183 WARN (Thread-14) [ x:aggr_content]
o.a.s.h.d.SimplePropertiesWriter Unable to read:
dataimport.properties2017-04-10 09:17:23.304 INFO (Thread-14) [
x:aggr_content] o.a.s.h.d.JdbcDataSource Creating a connection for entity
aggrPropertiesList with URL:
jdbc:oracle:thin:@hostname:1521/serviceId2017-04-10 09:17:23.465 INFO
(qtp1348949648-19) [ x:aggr_content] o.a.s.c.S.Request [aggr_content]
webapp=/solr path=/dataimport
params={indent=on&wt=json&command=status&_=1491815835958} status=0
QTime=02017-04-10 09:17:23.569 INFO (Thread-14) [ x:aggr_content]
o.a.s.h.d.JdbcDataSource Time taken for getConnection(): 2632017-04-10
09:17:23.630 ERROR (Thread-14) [ x:aggr_content] o.a.s.h.d.DocBuilder
Exception while processing: aggrList document : SolrInputDocument(fields:
[]):org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to
execute query: SELECT GLBL_ID FROM AGGR_OWNER2.GLBL_DETAILS Processing
Document # 1 at
org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:69)
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.(JdbcDataSource.java:327)
at
org.apache.solr.handler.dataimport.JdbcDataSource.createResultSetIterator(JdbcDataSource.java:288)
at
org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:283)
at
org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:52)
at
org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:59)
at
org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:73)
at
org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:244)
at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:475)
at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:414)
at
org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:329)
at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:232)
at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:416)
at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:475)
at
org.apache.solr.handler.dataimport.DataImporter.lambda$runAsync$0(DataImporter.java:458)
at
org.apache.solr.handler.dataimport.DataImporter$$Lambda$93/239004134.run(Unknown
Source) at java.lang.Thread.run(Thread.java:745)Caused by:
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at
oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) at
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) at
oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) at
oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195) at
oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:876)
at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
at
oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1916)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1878)
at
oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.executeStatement(JdbcDataSource.java:349)
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.(JdbcDataSource.java:321)
... 15 more
--
View this message in context:
http://lucene.472066.n3.nabble.com/Getting-error-while-excuting-full-import-tp4329153.html
Sent from the Solr - User mailing list archive at Nabble.com.
