I changed the UniqueKey and it worked fine.....thank you very much Nobel 2009/5/18 Noble Paul നോബിള് नोब्ळ् <noble.p...@corp.aol.com>
> the problem is that your uniquekey may not be unique > > just remove the entry altogether > > On Mon, May 18, 2009 at 10:53 PM, jayakeerthi s <mail2keer...@gmail.com> > wrote: > > Hi Noble, > > Many thanks for the reply > > > > Yes there is a UniqueKey in the Schema which is the ProductID. > > > > I also tried <uniqueKey required="false">PROD_ID</uniqueKey>. But no luck > > same only one document seen after querying *:* > > > > I have attached the Schema.xml used for your reference,please advise. > > > > Thanks and regards, > > Jay > > > > 2009/5/16 Noble Paul നോബിള് नोब्ळ् <noble.p...@corp.aol.com> > >> > >> 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 > > > > > > > > -- > ----------------------------------------------------- > Noble Paul | Principal Engineer| AOL | http://aol.com >
