check out if you have a uniqueKey in your schema. I there are duplicates they are overwritten
On Sat, May 16, 2009 at 1:38 AM, jayakeerthi s <mail2keer...@gmail.com> wrote: > I am using Solr for our application with JBoss Integration. > > I have managed to configure the indexing from Oralce db for 22 fields.Here > is the db-data-config.xml > > <dataConfig> > <dataSource type="JdbcDataSource" driver="oracle.jdbc.driver.OracleDriver" > url="jdbc:oracle:thin:@camatld6.***.com:1521:atlasint" > user="service_product_lgd" password="********"/> > > <document name="products"> > > <entity name="PROD" transformer="RegexTransformer" query="SELECT > A.PROD_ID,A.PROD_CD,C.REG_CMRC_STYL_NM,C.SAP_LANG_ID, A.DIV_ID > ,c.SIZE_RUN_DESC, c.INSM_DESC, c.OTSM_DESC, c.DIM_DESC, > c.PRFL_DESC,c.UPR_DESC,c.MDSL_DESC,c.OUTSL_DESC,c.CTNT_DESC, > D.SPORT_ACTY_DESC, E.GNDR_AGE_DESC, > A.PO_GRID_DESC,A.COLR_DISP_CD, B.STYL_CD , A.SILO_ID, A.SILH_ID, > F.SILH_DESC, g.SILO_DESC , h.FRST_PROD_OFFR_DT, > h.END_FTR_OFFR_DT, > h.RETL_PR_AMT,h.RETL_CRCY_ID,h.WHSLE_PR_AMT,h.WHSLE_CRCY_ID,I.ORG_LGCY_DIV_CD > from > PROD A ,PROD_STYL B ,PROD_REG_CMRC_STYL C , PROD_SPORT_ACTY D , > PROD_GNDR_AGE E , PROD_SILH F, PROD_SILO G, PROD_REG H, ORG_DIV I > WHERE > A.PROD_STYL_ID=B.PROD_STYL_ID > AND A.PROD_STYL_ID = c.PROD_STYL_ID > AND B.PROD_STYL_ID = C.PROD_STYL_ID > AND A.SPORT_ACTY_ID = d.SPORT_ACTY_ID > AND A.GNDR_AGE_ID = E.GNDR_AGE_ID > and A.SILH_ID = F.SILH_ID > AND A.SILO_ID = G.SILO_ID > AND A.PROD_ID = H.PROD_ID > AND A.DIV_ID = I.DIV_ID "> > </entity> > </document> > </dataConfig> > > And I have attached the Schema.xml used.done a full-import > http://localhost:8983/solr/dataimport?command=full-import > > > <response> > - > <lst name="responseHeader"> > <int name="status">0</int> > <int name="QTime">0</int> > </lst> > - > <lst name="initArgs"> > - > <lst name="defaults"> > - > <str name="config"> > C:\apache-solr-nightly\example\example-DIH\solr\db\conf\db-data-config.xml > </str> > </lst> > </lst> > <str name="command">full-import</str> > <str name="status">idle</str> > <str name="importResponse"/> > - > <lst name="statusMessages"> > <str name="Total Requests made to DataSource">1</str> > <str name="Total Rows Fetched">15</str> > <str name="Total Documents Skipped">0</str> > <str name="Full Dump Started">2009-05-11 11:27:02</str> > - > <str name=""> > Indexing completed. Added/Updated: 15 documents. Deleted 0 documents. > </str> > <str name="Committed">2009-05-11 11:27:05</str> > <str name="Optimized">2009-05-11 11:27:05</str> > <str name="Time taken ">0:0:2.625</str> > </lst> > - > <str name="WARNING"> > This response format is experimental. It is likely to change in the future. > </str> > </response> > > The issue I am facing is:though the response is "Indexing completed. > Added/Updated: 15 documents. Deleted 0 documents" > I am able to seee only one document when I query *:* so all the other 14 > documents are missing. > Similarly I tried indexing 1 million records and found only 2500 docs by > using *:* query > > So could anyone please help resolving this. > > > Regards, > Jay -- ----------------------------------------------------- Noble Paul | Principal Engineer| AOL | http://aol.com
