Hi Shawn,
Thank you for helpful information and suggestions.
> Are you using the Oracle JVM? This is recommended. Version 1.8.x (Java
> 8)
> is required for Solr 6.3.0.
I'm using Oracle Java 8 (1.8.0_111).
In response to your advice, I've changed the logging level for
JdbcDataSource to DEBUG.
Looks like rootEntity's query was running.
> Executing SQL: select book_id, title from books where deleted = 0
(excerpt)
2017-01-21 13:39:07.782 INFO (Thread-16) [ x:bookstore]
o.a.s.h.d.SimplePropertiesWriter Read dataimport.properties
2017-01-21 13:39:07.803 INFO (Thread-16) [ x:bookstore]
o.a.s.s.SolrIndexSearcher Opening [Searcher@32c6746f[bookstore] realtime]
2017-01-21 13:39:07.807 INFO (Thread-16) [ x:bookstore]
o.a.s.h.d.JdbcDataSource Creating a connection for entity books with URL:
jdbc:oracle:thin:@<MASKED>
2017-01-21 13:39:09.980 INFO (Thread-16) [ x:bookstore]
o.a.s.h.d.JdbcDataSource Time taken for getConnection(): 2164
2017-01-21 13:39:09.980 DEBUG (Thread-16) [ x:bookstore]
o.a.s.h.d.JdbcDataSource Executing SQL: select book_id, title from books
where deleted = 0
2017-01-21 13:39:10.041 INFO (Thread-16) [ x:bookstore]
o.a.s.h.d.JdbcDataSource Creating a connection for entity contents with URL:
jdbc:oracle:thin:@<MASKED>
2017-01-21 13:39:10.640 INFO (Thread-16) [ x:bookstore]
o.a.s.h.d.JdbcDataSource Time taken for getConnection(): 598
2017-01-21 13:39:10.640 DEBUG (Thread-16) [ x:bookstore]
o.a.s.h.d.JdbcDataSource Executing SQL: select book_id, content_id, content
from contents where book_id = and deleted = 0
2017-01-21 13:39:10.750 ERROR (Thread-16) [ x:bookstore]
o.a.s.h.d.DocBuilder Exception while processing: books document :
SolrInputDocument(fields: [book_id=1,
title=First]):org.apache.solr.handler.dataimport.DataImportHandlerException:
Unable to execute query: select book_id, content_id, content from contents
where book_id = and deleted = 0 Processing Document # 1
(/excerpt)
When enclosing the property ${books.book_id} in single quotes, the condition
"where book_id = '' and delete = 0" was applied, so query could not hit
child entity.
> It is possible that your DIH config contains invisible characters in the
> section where the property is referenced, that is causing the property
> to not be correctly inserted. I don't know how likely this is, but it
> is something that could happen. This can usually be seen in a hex editor.
I see. I tried to confirm that config files contain no illegal characters.
Now I've made the core of vanilla and applied the settings again,
hope that the possibility of including illegal characters should be low.
And then, I compared my environment with others.
1. Not only my virtual server, but Amazon RDS for Oracle also gave the same
results.
2. Using MySQL, those config and queries work out (with only changing Data
Types of DB column).
If possible, I'd like to test other versions of Solr (6.2, 6.1, ...).
Kind,
Keiichi
--
View this message in context:
http://lucene.472066.n3.nabble.com/DIH-do-not-work-Child-entity-cannot-refer-parent-s-id-tp4315023p4315192.html
Sent from the Solr - User mailing list archive at Nabble.com.
