Not able to see the output when search is clicked
Hi, In my SOLR, I have a query based data-config written and was able to manage below steps but i was not able to see the output 1) Register Data Import Request handler in Solr-config.xml 2) Modify Data-Config.xml for the appropriate query to get data imported from which includes making use of Jtds Driver for Sql server 3) Modify SolrConfig.xml file for registering db-data-config.xml in Request Handler item 4) Modify schema.xml for the output result. Right now we are facing issues here.please let me attach 2 files 1) schema.xml 2) db-data-config.xml. Schema.xml ?xml version=1.0 encoding=UTF-8 ? schema name=example version=1.2 types fieldType name=string class=solr.StrField sortMissingLast=true omitNorms=true / fieldType name=int class=solr.TrieIntField precisionStep=0 omitNorms=true positionIncrementGap=0 / fieldType name=date class=solr.TrieDateField omitNorms=true precisionStep=0 positionIncrementGap=0 / fieldType name=text class=solr.TextField positionIncrementGap=100 analyzer type=index tokenizer class=solr.WhitespaceTokenizerFactory / filter class=solr.StopFilterFactory ignoreCase=true words=stopwords.txt enablePositionIncrements=true / filter class=solr.WordDelimiterFilterFactory generateWordParts=1 generateNumberParts=1 catenateWords=1 catenateNumbers=1 catenateAll=0 splitOnCaseChange=1 / filter class=solr.LowerCaseFilterFactory / filter class=solr.SnowballPorterFilterFactory language=English protected=protwords.txt / /analyzer analyzer type=query tokenizer class=solr.WhitespaceTokenizerFactory / filter class=solr.SynonymFilterFactory synonyms=synonyms.txt ignoreCase=true expand=true / filter class=solr.StopFilterFactory ignoreCase=true words=stopwords.txt enablePositionIncrements=true / filter class=solr.WordDelimiterFilterFactory generateWordParts=1 generateNumberParts=1 catenateWords=0 catenateNumbers=0 catenateAll=0 splitOnCaseChange=1 / filter class=solr.LowerCaseFilterFactory / filter class=solr.SnowballPorterFilterFactory language=English protected=protwords.txt / /analyzer /fieldType /types fields field name=FileId type=string indexed=true stored=true required=true / field name=Title type=string indexed=true stored=true required=true / /fields uniqueKeyFileId/uniqueKey defaultSearchFieldFileId/defaultSearchField solrQueryParser defaultOperator=AND / /schema db-data-config.xml dataConfig dataSource type=JdbcDataSource driver=net.sourceforge.jtds.jdbc.Driver url=jdbc:jtds:sqlserver://17.30.199.667:1433;databaseName= user= password=XXX / document entity name=Files query=Select FileID,Title from files field column=FileID name=FileID / field column=Title name=Title / /entity /document /dataConfig 5) Make full import http request for data to get indexed into solr server. Even though i see that all the rows are indexed but not able to find results when search is clicked on the admin page Thanks Raj Deep Benefitfocus is the largest benefits technology provider in the U.S. More than 15 million consumers, 300,000 employers and 60,000 brokers use our cloud-based platform to shop, enroll, manage and exchange all their benefits in one place. From consumer engagement and education to enrollment, communication and billing, Benefitfocus is helping companies find a better way to manage their benefits. For more information, visit www.benefitfocus.com Benefitfocus  All Your Benefits. One Place. CONFIDENTIALITY NOTICE: This message and any attachments are for the use of the intended individuals and may contain information that is confidential and exempt from disclosure under law. If you are not the intended recipient, any further use, distribution, or disclosure of this message or attachments is strictly prohibited. If you have received this communication in error, please contact the sender or bfpostmas...@benefitfocus.com immediately and delete this message and any attachments from your system. (01/2012) dataConfig dataSource type=JdbcDataSource driver=net.sourceforge.jtds.jdbc.Driver url=jdbc:jtds:sqlserver://17.30.199.667:1433;databaseName= user= password=XXX / document entity name=Files query=Select FileID,Title from files field column=FileID name=FileID / field column=Title name=Title / /entity /document /dataConfig ?xml version=1.0 encoding=UTF-8 ? schema name=example version=1.2 types fieldType name=string class=solr.StrField sortMissingLast=true omitNorms=true / fieldType name=int class=solr.TrieIntField precisionStep=0 omitNorms=true
RE: Not able to see the output when search is clicked
Hi Mohanty, I have entered *:* in the search box and the url it redirected to was http://localhost:8983/solr/select/?q=*%3A*version=2.2start=0rows=10indent=on; and the output was the below content where i expected 3 rows in 3 items Thanks Raj Deep Alapati ?xml version=1.0 encoding=UTF-8 ? - response - lst name=responseHeader int name=status0/int int name=QTime0/int /lst - lst name=initArgs - lst name=defaults str name=configdb-data-config.xml/str /lst /lst str name=statusidle/str str name=importResponse / - lst name=statusMessages str name=Total Requests made to DataSource1/str str name=Total Rows Fetched3/str str name=Total Documents Skipped0/str str name=Full Dump Started2012-01-10 06:24:14/str str name=Indexing completed. Added/Updated: 3 documents. Deleted 0 documents./str str name=Committed2012-01-10 06:24:16/str str name=Optimized2012-01-10 06:24:16/str str name=Total Documents Processed3/str str name=Time taken0:0:2.578/str /lst str name=WARNINGThis response format is experimental. It is likely to change in the future./str /response From: Gora Mohanty [g...@mimirtech.com] Sent: 11 January 2012 17:15 To: solr-user@lucene.apache.org Subject: Re: Not able to see the output when search is clicked On Wed, Jan 11, 2012 at 4:31 PM, Rajdeep Alapati rajdeep.alap...@benefitfocus.com wrote: [...] 5) Make full import http request for data to get indexed into solr server. Even though i see that all the rows are indexed but not able to find results when search is clicked on the admin page Sorry, what do you mean by when search is clicked on the admin page? What are you entering in the text input box? Please, cut and paste the exact URL that you are taken to after clicking. Regards, Gora Benefitfocus is the largest benefits technology provider in the U.S. More than 15 million consumers, 300,000 employers and 60,000 brokers use our cloud-based platform to shop, enroll, manage and exchange all their benefits in one place. From consumer engagement and education to enrollment, communication and billing, Benefitfocus is helping companies find a better way to manage their benefits. For more information, visit www.benefitfocus.com Benefitfocus  All Your Benefits. One Place. CONFIDENTIALITY NOTICE: This message and any attachments are for the use of the intended individuals and may contain information that is confidential and exempt from disclosure under law. If you are not the intended recipient, any further use, distribution, or disclosure of this message or attachments is strictly prohibited. If you have received this communication in error, please contact the sender or bfpostmas...@benefitfocus.com immediately and delete this message and any attachments from your system. (01/2012)
Mohanty:RE: Not able to see the output when search is clicked
Hi Mohanty, Can you please guess what is happening on my side. Any help would be great Thanks Raj Deep Alapati From: Gora Mohanty [g...@mimirtech.com] Sent: 11 January 2012 17:15 To: solr-user@lucene.apache.org Subject: Re: Not able to see the output when search is clicked On Wed, Jan 11, 2012 at 4:31 PM, Rajdeep Alapati rajdeep.alap...@benefitfocus.com wrote: [...] 5) Make full import http request for data to get indexed into solr server. Even though i see that all the rows are indexed but not able to find results when search is clicked on the admin page Sorry, what do you mean by when search is clicked on the admin page? What are you entering in the text input box? Please, cut and paste the exact URL that you are taken to after clicking. Regards, Gora Benefitfocus is the largest benefits technology provider in the U.S. More than 15 million consumers, 300,000 employers and 60,000 brokers use our cloud-based platform to shop, enroll, manage and exchange all their benefits in one place. From consumer engagement and education to enrollment, communication and billing, Benefitfocus is helping companies find a better way to manage their benefits. For more information, visit www.benefitfocus.com Benefitfocus  All Your Benefits. One Place. CONFIDENTIALITY NOTICE: This message and any attachments are for the use of the intended individuals and may contain information that is confidential and exempt from disclosure under law. If you are not the intended recipient, any further use, distribution, or disclosure of this message or attachments is strictly prohibited. If you have received this communication in error, please contact the sender or bfpostmas...@benefitfocus.com immediately and delete this message and any attachments from your system. (01/2012)
Indexing Failed.Rolled back all changes Issue
Hi, I am new to this SOLR.I was digging data import request handler for past few days and now i am doing some poc after i download the solr server. I do have a table called files and i want to perform the Full import as part of POC. I changed the data-config.xml and registered the data-config.xml at solr-config.xml at conf/. I hit the http request for full-import. Even though my query returns 3 rows outside the solr but it is not returning any rows inside the import.when i see the /data-import status i do find the error message.Indexing Failed.Rolled back all changes. after i did some digging regarding the issue.i came to know that i missed dataimport.properties file at conf/. Now pls help me here. 1) Can anybody send me the sample file how the dataimport.properties file should be? 2) Even though i am not performing delta import do i need dataimport.properties 3) why i am not able to see any rows? what is the attribute i can check if the dataimport is successful? and in which file i will find this information.i think solr/data-import http request will help me? Can any body help me? i know this should be a basic problem, but i am beginner. Thanks Raj Deep Benefitfocus is the largest benefits technology provider in the U.S. More than 15 million consumers, 300,000 employers and 60,000 brokers use our cloud-based platform to shop, enroll, manage and exchange all their benefits in one place. From consumer engagement and education to enrollment, communication and billing, Benefitfocus is helping companies find a better way to manage their benefits. For more information, visit www.benefitfocus.com Benefitfocus  All Your Benefits. One Place. CONFIDENTIALITY NOTICE: This message and any attachments are for the use of the intended individuals and may contain information that is confidential and exempt from disclosure under law. If you are not the intended recipient, any further use, distribution, or disclosure of this message or attachments is strictly prohibited. If you have received this communication in error, please contact the sender or bfpostmas...@benefitfocus.com immediately and delete this message and any attachments from your system. (01/2012)
