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

  • nipper
    #2 Answer ✓

    Well you seem to have no information in LSCS. The index.log shows a DREINITIAL which clears out Idol. So you should deploy your content to LSCS and try again.

Answers

  • Your query is extremely detailed. You may have data but not that specific data.

    Start removing some of the parameters and see what data shows up. You can use a query of * in debugpanel and that will return everything in the DB

  • 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 :

    http://servername.domain.com:7010/lscs/v1/document$?q=*&project=//servername/default/main/CWA/Fido/fido_ca&start=0&max=100

    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 complete

    Index.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 s

    Thanks

  • nipper
    #5 Answer ✓

    Well you seem to have no information in LSCS. The index.log shows a DREINITIAL which clears out Idol. So you should deploy your content to LSCS and try again.

  • We had a simliar issue and found a typo in the project name. Specifically it's case sensitive.

  • Hi Kevin,

    We are facing similar issue, did you find the resolution?

    Thanks,
    Jitu

  • Have you tried this from a command prompt on the LSCS server?
    (unix)
    wget --no-proxy http://localhost:10011/DREREGENERATE?Type=Match

    Windows 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.

  • Hi Denise,

    Thanks for the reply, but I was able to resolve the issue, there was some problem with imported indexes, I cleard all data from LSCS and reimport indexes.

    Thanks,
    Jitu

TeamSite Developer Resources

  • 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.
image
OpenText CE Products
TeamSite
APIs