Sitemap

Amicuk Programming Answers

Database search not working

-0001-11-30   Views:0

Advertisement

Hi all, I am new to Orcale SES. I have to search database using SES. I have created database source with the following details: Database Connection String,User ID,Password,View,Document Count,URL Prefix, Parse Attributes, Remove deleted documents,Att

Hi all,
I am new to Orcale SES. I have to search database using SES. I have created database source with the following details:
Database Connection String,User ID,Password,View,Document Count,URL Prefix, Parse Attributes,
Remove deleted documents,Attachment Link Authentication Type
When I schedule crawler on database, log file shows following:
06:26:34:773 INFO     main          Total number of documents fetched = 0
06:26:34:773 INFO     main          Document fetch failures = 0
06:26:34:773 INFO     main          Document conversion failures = 0
06:26:34:774 INFO     main          Total number of unique documents indexed = 0
06:26:34:774 INFO     main          Total data collected = 0 bytes
06:26:34:774 INFO     main          Total number of non-indexable documents = 0
06:26:34:774 INFO     main          
06:26:34:774 INFO     main          Number of times disk cache is full = 0
crawl statistics is 0.
Am I missing something here?
Please help.
Regards,
Purnima

The replay answer
Advertisement
Hi,
I have given table name (TESTSES) in view parameter. Yes TESTSES table contains all the mandatory parameters.
Crawler log file is not showing any errors. Following are the log file details:
06:26:10:518 INFO     main          Loading training data /u01/apps/oracle/product/11.1.2.0.0/ses/seshome/search/data/training//german.dat for language de
06:26:10:528 INFO     main          Loading training data /u01/apps/oracle/product/11.1.2.0.0/ses/seshome/search/data/training//italian.dat for language it
06:26:10:540 INFO     main          Loading training data /u01/apps/oracle/product/11.1.2.0.0/ses/seshome/search/data/training//portugue.dat for language pt
06:26:10:551 INFO     main          Loading training data /u01/apps/oracle/product/11.1.2.0.0/ses/seshome/search/data/training//spanish.dat for language es
06:26:10:570 INFO     main          Done
06:26:11:636 INFO     filter_0          Initializing crawler plug-in "Database Crawler Plugin"
06:26:11:636 INFO     crawler_4          Initializing crawler plug-in "Database Crawler Plugin"
06:26:11:637 INFO     crawler_4          AppJDBC crawler initialization: Connection string is jdbc:oracle:thin:@nacisdell221.us.oracle.com:1534:BFNDEV
06:26:11:636 INFO     crawler_3          Initializing crawler plug-in "Database Crawler Plugin"
06:26:11:636 INFO     filter_0          AppJDBC crawler initialization: Connection string is jdbc:oracle:thin:@nacisdell221.us.oracle.com:1534:BFNDEV
06:26:11:637 INFO     crawler_2          Initializing crawler plug-in "Database Crawler Plugin"
06:26:11:637 INFO     crawler_2          AppJDBC crawler initialization: Connection string is jdbc:oracle:thin:@nacisdell221.us.oracle.com:1534:BFNDEV
06:26:11:637 INFO     crawler_3          AppJDBC crawler initialization: Connection string is jdbc:oracle:thin:@nacisdell221.us.oracle.com:1534:BFNDEV
06:26:11:636 INFO     filter_1          Initializing crawler plug-in "Database Crawler Plugin"
06:26:11:638 INFO     filter_1          AppJDBC crawler initialization: Connection string is jdbc:oracle:thin:@nacisdell221.us.oracle.com:1534:BFNDEV
06:26:11:649 INFO     crawler_4          Loading oracle Driver
06:26:11:649 INFO     crawler_4          Connecting to database jdbc:oracle:thin:@nacisdell221.us.oracle.com:1534:BFNDEV, user: arg
06:26:11:650 INFO     filter_0          Loading oracle Driver
06:26:11:651 INFO     filter_0          Connecting to database jdbc:oracle:thin:@nacisdell221.us.oracle.com:1534:BFNDEV, user: arg
06:26:11:653 INFO     crawler_2          Loading oracle Driver
06:26:11:653 INFO     crawler_2          Connecting to database jdbc:oracle:thin:@nacisdell221.us.oracle.com:1534:BFNDEV, user: arg
06:26:11:658 INFO     crawler_3          Loading oracle Driver
06:26:11:658 INFO     crawler_3          Connecting to database jdbc:oracle:thin:@nacisdell221.us.oracle.com:1534:BFNDEV, user: arg
06:26:11:668 INFO     filter_1          Loading oracle Driver
06:26:11:668 INFO     filter_1          Connecting to database jdbc:oracle:thin:@nacisdell221.us.oracle.com:1534:BFNDEV, user: arg
06:26:15:328 INFO     crawler_4          Crawler plug-in "Database Crawler Plugin" crawl starts
06:26:15:331 INFO     crawler_4          Previous max. last modified date: 2010-05-24T00:00:00
06:26:15:331 INFO     crawler_4          Query key only= false; SQL Statement = select * from (select * from (TESTSES) mqry where LASTMODIFIEDDATE > ?) where ROLLNO = ?
06:26:15:331 INFO     crawler_4          No subqueries to create PreparedStatements
06:26:15:331 INFO     crawler_4          No subqueries to create PreparedStatements
06:26:18:332 INFO     filter_1          Crawler plug-in "Database Crawler Plugin" crawl starts
06:26:18:334 INFO     filter_1          Previous max. last modified date: 2010-05-24T00:00:00
06:26:18:334 INFO     filter_1          Query key only= false; SQL Statement = select * from (select * from (TESTSES) mqry where LASTMODIFIEDDATE > ?) where ROLLNO = ?
06:26:18:334 INFO     filter_1          No subqueries to create PreparedStatements
06:26:18:334 INFO     filter_1          No subqueries to create PreparedStatements
06:26:21:366 INFO     crawler_3          Crawler plug-in "Database Crawler Plugin" crawl starts
06:26:21:367 INFO     crawler_3          Previous max. last modified date: 2010-05-24T00:00:00
06:26:21:368 INFO     crawler_3          Query key only= false; SQL Statement = select * from (select * from (TESTSES) mqry where LASTMODIFIEDDATE > ?) where ROLLNO = ?
06:26:21:368 INFO     crawler_3          No subqueries to create PreparedStatements
06:26:21:368 INFO     crawler_3          No subqueries to create PreparedStatements
06:26:24:367 INFO     crawler_2          Crawler plug-in "Database Crawler Plugin" crawl starts
06:26:24:368 INFO     crawler_2          Previous max. last modified date: 2010-05-24T00:00:00
06:26:24:368 INFO     crawler_2          Query key only= false; SQL Statement = select * from (select * from (TESTSES) mqry where LASTMODIFIEDDATE > ?) where ROLLNO = ?
06:26:24:368 INFO     crawler_2          No subqueries to create PreparedStatements
06:26:24:368 INFO     crawler_2          No subqueries to create PreparedStatements
06:26:27:415 INFO     filter_0          Crawler plug-in "Database Crawler Plugin" crawl starts
06:26:27:416 INFO     filter_0          Previous max. last modified date: 2010-05-24T00:00:00
06:26:27:416 INFO     filter_0          Query key only= true; SQL Statement = select URL,ROLLNO,LANG,LASTMODIFIEDDATE from (select * from (TESTSES) mqry where LASTMODIFIEDDATE > ?)
06:26:27:686 INFO     filter_0          Master query execution time: 270ms
06:26:27:686 INFO     filter_0          Previous max. last modified date: 2010-05-24T00:00:00
06:26:27:687 INFO     filter_0          Query key only= false; SQL Statement = select * from (select * from (TESTSES) mqry where LASTMODIFIEDDATE > ?) where ROLLNO = ?
06:26:27:687 INFO     filter_0          No subqueries to create PreparedStatements
06:26:27:687 INFO     filter_0          No subqueries to create PreparedStatements
06:26:27:687 INFO     filter_0          Shut down crawler plug-in "Database Crawler Plugin"
06:26:27:956 INFO     filter_0          Shut down crawler plug-in "Database Crawler Plugin"
06:26:28:227 INFO     filter_0          Shut down crawler plug-in "Database Crawler Plugin"
06:26:28:497 INFO     filter_0          Shut down crawler plug-in "Database Crawler Plugin"
06:26:28:768 INFO     filter_0          Shut down crawler plug-in "Database Crawler Plugin"
06:26:29:038 INFO     filter_0          Shutting down all crawling threads...
06:26:29:038 INFO     filter_0          Crawler plug-in "Database Crawler Plugin" crawl finishes
06:26:29:039 INFO     filter_0          Shut down document service agent "Default pipeline"
06:26:29:039 INFO     crawler_4          Crawler plug-in "Database Crawler Plugin" crawl finishes
06:26:29:040 INFO     filter_1          Crawler plug-in "Database Crawler Plugin" crawl finishes
06:26:29:041 INFO     crawler_2          Crawler plug-in "Database Crawler Plugin" crawl finishes
06:26:29:041 INFO     crawler_3          Crawler plug-in "Database Crawler Plugin" crawl finishes
06:26:29:061 INFO     cache_0          Caching thread cache_0 returns without getting a file
06:26:29:062 INFO     cache_0          Shutting down all caching threads...
06:26:29:062 INFO     cache_1          Caching thread cache_1 returns without getting a file
06:26:29:062 INFO     cache_2          Caching thread cache_2 returns without getting a file
06:26:29:062 INFO     cache_0          Total number of documents cached = 0
06:26:29:062 INFO     cache_0          Total data collected = 0 bytes
06:26:29:062 INFO     cache_0          Indexing log file is "search_i1ds4.log" under oracle_home/ctx/log/
06:26:29:098 INFO     cache_0          Indexing started at 5/24/10 6:26 AM
06:26:29:098 INFO     cache_0          Task ID = 19
06:26:29:234 INFO     monitor          Remote command "reportstatistics" received, argument = "null"
06:26:29:262 INFO     monitor          Executing remote command "reportstatistics"
06:26:29:266 INFO     monitor          Send back remote command execution result
06:26:29:515 INFO     cache_0          Indexing completed at 5/24/10 6:26 AM
06:26:34:518 INFO     cache_0          Done
06:26:34:518 INFO     main          Shutting down crawler...
06:26:34:518 INFO     main          Shut down crawler plug-in "oracle.search.plugin.db.DBCrawlerManager"
06:26:34:718 INFO     monitor          Remote command "reportstatistics" received, argument = "quit"
06:26:34:718 INFO     monitor          Executing remote command "reportstatistics"
06:26:34:719 INFO     monitor          Send back remote command execution result
06:26:34:772 INFO     main          Done
06:26:34:772 INFO     main          
06:26:34:772 INFO     main          =================== Crawling results ===================
06:26:34:773 INFO     main          Crawling started at 5/24/10 6:26 AM
06:26:34:773 INFO     main          Crawling stopped at 5/24/10 6:26 AM
06:26:34:773 INFO     main          Total crawling time = 0:0:28
06:26:34:773 INFO     main          
06:26:34:773 INFO     main          Total number of documents fetched = 0
06:26:34:773 INFO     main          Document fetch failures = 0
06:26:34:773 INFO     main          Document conversion failures = 0
06:26:34:774 INFO     main          Total number of unique documents indexed = 0
06:26:34:774 INFO     main          Total data collected = 0 bytes
06:26:34:774 INFO     main          Total number of non-indexable documents = 0
06:26:34:774 INFO     main          
06:26:34:774 INFO     main          Number of times disk cache is full = 0

Go to See the other 10 answers

Database search results

Category:DefaultRelease time:-0001-11-30Views:130

i have a master results page (aspVB) from Dreamweaver 8. have search page from WebAssist Database Search using advanced text search (single search box) question 1 - when a user hits 'enter' on the search page, all records show, no matter if there is[More]

How do I create a simple database search

Category:DefaultRelease time:-0001-11-30Views:130

Either I'm being very stupid or all the manuals and books I'm reading really are skirting round the obvious question of how do I build a search page (using Dreamweaver 8) that searches a database using only valid values previously fetched from the da[More]

Capture database search string

Category:DefaultRelease time:-0001-11-30Views:130

Thanks to all who help, I maintain a database search utility on our company Intranet that was developed using FrontPage (our only company standard development tool). The user enters a product code and initiates the search. When the results are found[More]

SOON: Advisor Webcast - WebCenter Content: Database Searching and Indexing

Category:DefaultRelease time:-0001-11-30Views:130

Learn how to improve search performance by attending the 1 hour Advisor Webcast: WebCenter Content: Database Searching and Indexing on March 15, 2012 at 16:00 UK / 167:00 CET / 08:00 am Pacific / 9:00 am Mountain / 11:00 am Eastern. For details, go h[More]

Database Searching Algorithms

Category:DefaultRelease time:-0001-11-30Views:130

Hi.. I have to do some research about database searching algorithms. Would someone here help me and give a list of that algorithms and which one is the best. What is the name of this algorithms which when u type in a key such "a" then it display[More]

How to chart database search results?

Category:DefaultRelease time:-0001-11-30Views:130

I'm new to Macs and Appleworks. I want to make a graph/chart of numbers that come from summary fields of a database search. Do I somehow link the database search results to a spreadsheet? Can I put the graph on a database report page? Thanks.Maybe th[More]

Solution Database search option doesn't work

Category:DefaultRelease time:2015-10-11Views:130

Hi, Iu2019m working withSAP Solution Manager 7.0 (SID=SMG) is at SP 17. SAP_BASIS 700 0016 SAPKB70016 SAP Basis Component SAP_ABA 700 0016 SAPKA70016 Cross-Application Component ST-PI 2005_1_700 0006 SAPKITLQI6 SAP Solution Tools Plug- In PI_BASIS 20[More]

Turn a text database search result into a clickable .pdf link to specific images

Category:DefaultRelease time:2015-10-11Views:130

Hello and Good Afternoon all.  This is baffling me to no end, pretty desperate at this point.  I have a successfully implemented a search and results page from my database table 'products'.  The results page displays a field from this table as produc[More]

Database Search Problem

Category:DefaultRelease time:-0001-11-30Views:130

Hey, I am creating a database with a user profile, where a user can select their interests. i.e Golfing Yes/No Movies Yes/No Travelling Yes/No So, there are 20 interests like that, and each of them is a boolean. Would it be inefficient to create 20 b[More]

Database search not working

Category:DefaultRelease time:-0001-11-30Views:130

Hi all, I am new to Orcale SES. I have to search database using SES. I have created database source with the following details: Database Connection String,User ID,Password,View,Document Count,URL Prefix, Parse Attributes, Remove deleted documents,Att[More]

Database-Searching for dates

Category:DefaultRelease time:-0001-11-30Views:130

If I enter in an exact date (such as 7/9/06) in my database's Find layout that matches an existing record then AppleWorks finds the record. But I want to find all records that contain ANY date in the date field. If I type in a character in the date f[More]

Hot
I updated firefox to the newest version and it wouldn't work (something about the proxy server) so I stupidly tried to fix it by using the restore program. I then realized that the old firefox was uninstalled when I downloaded the new updated version [More]
Hi guys, i get this error "An error occurred while updating mail preferences" when try to enable vacation message in uwc.....any idea? is a hosted domain uwc...hi jay, mmp 2005q1 patched 118207-42 uwc 2005q1 patched 118540-21 there is 2 ldap ser [More]
Hi everybody ! First thing, please excuse me if my english isn't very good. I've got an iMac Core 2 Duo 2.16 GHz with 20" screen, and a videoprojector as a second monitor. I would like to totally shutdown the iMac scree when, for example, I'm watchin [More]
Hi, I am able to create a report using Web Application Designer. I am also able to publish it. Once logging into SAP BW, I can see a shortcut of my web report in the SAP Menu. When I click on this report, it redirects me to a site, opening my web bro [More]
Hi every one I posted this message in the wrong forum, though I must say I got a lot of replies there also. Now dont get me wrong but I have done Java 1 only and know absolutely nothing of Java2. We have the following technologies - Java 2, J2EE, J2S [More]
I am trying to erase and re-title a floppy disk using "Disk Utility." I keep getting an error message that "Disk Utility" cannot open the disk. I'm using an external FD drive that plugs into the USB port and is recognized without the u [More]
Did adobe decide not to release CFMX 7.0.2 as a JAR? I am working on an intel-Mac and this was the only way to have coldfusion running on my machine! I tried searching for it but could not find anything mentioning the JARI'm running CFMX 7.0.2 on my [More]
Hi All, When try to validate the script logics from BPC Admin, I am getting the message "Invalid Dimension Entity in lookup". Can you please let me how to fix this. Thank you, RajuWith the suggestions from this link - ExecuteBaseLogic : Invalid [More]
Hello,  I am using a 6703 card which is a static analog voltage output card.  At some point in my program, once I write to the output voltage channels, I would like to read back this output voltage from the card.  How can I do that?  Is there a prope [More]
Hi Everyone, I facing a strange issue in a program. The program fetches data from a Y-table based on some selection criteria, it then concatenates each field value into a STRING variable and creates a pipe delimited text file. One of the fields is a [More]