first do you have a unique key defined in your schema.xml? If you do, some of those 300 rows could be replacing earlier rows.
You say: " if I have 200 rows indexed from postgres and 100 rows from Oracle, the full-import process only indexes 200 documents from oracle, although it shows clearly that the query retruned 300 rows." Which really looks like a typo, if you have 100 rows from Oracle how did you get 200 rows from Oracle? Are you perhaps doing this in two different jobs and deleting the first import before running the second? And if this is irrelevant, could you provide more details like how you're indexing things (I'm assuming DIH, but you don't state that anywhere). If it *is* DIH, providing that configuration would help. Best Erick On Tue, Jul 6, 2010 at 11:19 AM, Xavier Rodriguez <xee...@gmail.com> wrote: > Hi, > > I have a SOLR installed on a Tomcat application server. This solr instance > has some data indexed from a postgres database. Now I need to add some > entities from an Oracle database. When I run the full-import command, the > documents indexed are only documents from postgres. In fact, if I have 200 > rows indexed from postgres and 100 rows from Oracle, the full-import > process > only indexes 200 documents from oracle, although it shows clearly that the > query retruned 300 rows. > > I'm not doing a delta-import, simply a full import. I've tried to clean the > index, reload the configuration, and manually remove dataimport.properties > because it's the only metadata i found. Is there any other file to check > or > modify just to get all 300 rows indexed? > > Of course, I tried to find one of that oracle fields, with no results. > > Thanks a lot, > > Xavier Rodriguez. >
