LSCS Query manager returning 0 Results (Oracle Database)
Hi Team,
When we are trying to get the LSCS query results from oracle and we are getting 0 results with site 200 response. While checking in Oracle database tables we have results.
URL : http://servername:7010/lscs/admin/debugpanel/
Action=query&FieldText=%28%28STRING%7Bdocument%7D%3ADRECONTENT+OR+STRING%7Bed9acd3edaab73c0795e52ba0828df6c%7D%3Aid%29%29+AND+MATCH%7B%2F%2Fservername%2Fdefault%2Fmain%2Finternet%2Ffido%7D%3AprojectName+AND+EMPTY%7B%7D%3AisDeleted&Start=1&MaxResults=100&TotalResults=true&weighfieldtext=false&anylanguage=true&Print=Fields&PrintFields=id%2CcontextId&databasematch=-1434648473_ (127.0.0.1)
01/03/2018 16:00:27 [9] Returning 0 matches
01/03/2018 16:00:27 [9] Query complete
Thanks
Best Answer
Answers
-
Dear Andy,
We have tried query as * and however still Returning 0 matches. This DR server cloned from PROD and DB as well and followed the same config. However its not.
LSCS.log
03-02-18 @ 12:41:10 [DEBUG] IdolACI - executeQuery(): idol params:
03-02-18 @ 12:41:10 [DEBUG] IdolACI - Action=query
03-02-18 @ 12:41:10 [DEBUG] IdolACI - FieldText=(STRING{site/targeted-link}:LSCS_STR_TeamSite__HSALS__Templating__HSALS__DCR__HSALS__Type) AND MATCH{//servername/default/main/internet/rogers}:projectName AND EMPTY{}:isDeleted
03-02-18 @ 12:41:10 [DEBUG] IdolACI - Start=1
03-02-18 @ 12:41:10 [DEBUG] IdolACI - MaxResults=10
03-02-18 @ 12:41:10 [DEBUG] IdolACI - TotalResults=true
03-02-18 @ 12:41:10 [DEBUG] IdolACI - weighfieldtext=false
03-02-18 @ 12:41:10 [DEBUG] IdolACI - anylanguage=true
03-02-18 @ 12:41:10 [DEBUG] IdolACI - Print=Fields
03-02-18 @ 12:41:10 [DEBUG] IdolACI - PrintFields=id,contextId
03-02-18 @ 12:41:10 [DEBUG] IdolACI - databasematch=336493813_services.log
02/03/2018 14:30:04 SERVICE: Action GETSTATUSINFO requested by "IP add"
02/03/2018 14:30:14 SERVICE: Action GETSTATUSINFO requested by "IP add"developer tool URL :
Query.log
02/03/2018 14:32:09 [30] Action=query&text=*&FieldText=MATCH%7B%2F%2Fservername%2Fdefault%2Fmain%2FCWA%2FFido%2Fca%7D%3AprojectName+AND+EMPTY%7B%7D%3AisDeleted&Start=1&MaxResults=100&TotalResults=true&weighfieldtext=false&anylanguage=true&Print=Fields&PrintFields=id%2CcontextId&databasematch=-154945499 (10.31.16.146)
02/03/2018 14:32:09 [30] Returning 0 matches
02/03/2018 14:32:09 [30] Query completeIndex.log
02/03/2018 00:18:26 [0] Index server attached to port 10011.
02/03/2018 00:18:26 [0] Index server attached to port 10011.
02/03/2018 00:18:26 [0] Index server attached to port 10011.
02/03/2018 14:16:28 [0] Index connection granted to: 10.31.16.145
02/03/2018 14:16:28 [0] Index Queue Command: /DREINITIAL
02/03/2018 14:16:28 [1] Index Queue Command: DREINITIAL
02/03/2018 14:16:29 [1] Autonomy IDOL Server Version 7.5.7.0 Build 755734
02/03/2018 14:16:29 [1] Creating empty database...
02/03/2018 14:16:29 [1] Index command finished. Took 0.46 s
02/03/2018 14:29:40 [0] Index connection granted to: 10.31.16.145
02/03/2018 14:29:40 [0] Index Queue Command: /DREINITIAL
02/03/2018 14:29:41 [1] Index Queue Command: DREINITIAL
02/03/2018 14:29:41 [1] Autonomy IDOL Server Version 7.5.7.0 Build 755734
02/03/2018 14:29:41 [1] Creating empty database...
02/03/2018 14:29:41 [1] Index command finished. Took 0.37 sThanks
0 -
Have you tried this from a command prompt on the LSCS server?
(unix)
wget --no-proxy http://localhost:10011/DREREGENERATE?Type=MatchWindows you probably could use a browser on the server (if you have one there) but I'm not sure.
Watch the logs and when it's done restart LSCS
We were facing the same issue last week and this corrected it.
0
Categories
- All Categories
- 107 Developer Announcements
- 53 Articles
- 105 General Questions
- 141 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 898 Cloud Fax and Notifications
- 76 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 118 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
- Docker Automation
- LiveSite Content Services (LSCS) REST API
- Single Page Application (SPA) Modules
- TeamSite Add-ons
If you are interested in gaining full access to the content, you can register for a My Support account here.