Gravatar for amitnicks@gmail.com

Question by amitnicks1, Dec 29, 2017 3:32 PM

Coveo Cloud with Sitecore 8.2 CD issue

Hi,

I am trying to integrate Coveo Cloud with Sitecore. I followed the steps mentioned in the installation guide and able to install Coveo package successfully. When i create a new search page and preview it in CM environment then the preview looks fine but when I open the page in CD then I get the error mentioned below. It is a blank Sitecore instance without and content and custom rules.

{
  "status": 400,
  "message": "Bad Request",
  "type": "ServerReturnedSoapFaultException",
  "name": "ServerReturnedSoapFaultException",
  "queryExecutionReport": [
    {
      "duration": 84,
      "children": [
        {
          "description": "Perform authentication",
          "duration": 0,
          "configured": {
            "primary": "CloudToken",
            "secondary": [
              "sso"
            ],
            "mandatory": []
          },
          "result": {
            "userIds": [
              {
                "name": "extranet\\Anonymous",
                "kind": "User",
                "provider": "Expanded Sitecore Security Provider for V2CO-PProd-CD0-V2CO-PProd-CD0",
                "infos": {}
              },
              {
                "name": "anonymous@anonymous",
                "kind": "User",
                "provider": "Email Security Provider",
                "infos": {}
              }
            ],
            "roles": [
              "queryExecutor"
            ],
            "queryRestrictions": {
              "pipeline": null,
              "filter": null
            },
            "userGroups": []
          },
          "children": [
            {
              "description": "Resolve authentication of provider: CloudToken",
              "duration": 0,
              "result": {
                "userIds": [
                  {
                    "name": "extranet\\Anonymous",
                    "kind": "User",
                    "provider": "Expanded Sitecore Security Provider for V2CO-PProd-CD0-V2CO-PProd-CD0",
                    "infos": {}
                  },
                  {
                    "name": "anonymous@anonymous",
                    "kind": "User",
                    "provider": "Email Security Provider",
                    "infos": {}
                  }
                ],
                "roles": [
                  "queryExecutor"
                ],
                "queryRestrictions": {
                  "pipeline": null,
                  "filter": null
                },
                "userGroups": []
              }
            },
            {
              "description": "Merge authentications (if needed)",
              "duration": 0,
              "result": {
                "userIds": [
                  {
                    "name": "extranet\\Anonymous",
                    "kind": "User",
                    "provider": "Expanded Sitecore Security Provider for V2CO-PProd-CD0-V2CO-PProd-CD0",
                    "infos": {}
                  },
                  {
                    "name": "anonymous@anonymous",
                    "kind": "User",
                    "provider": "Email Security Provider",
                    "infos": {}
                  }
                ],
                "roles": [
                  "queryExecutor"
                ],
                "queryRestrictions": {
                  "pipeline": null,
                  "filter": null
                },
                "userGroups": []
              }
            }
          ]
        },
        {
          "description": "Resolve context",
          "duration": 1,
          "result": {
            "userAgent": {
              "raw": "Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.108 Safari/537.36",
              "browser": [
                "chrome"
              ],
              "device": [
                "desktop",
                "pc",
                "windows"
              ],
              "os": [
                "windows"
              ]
            },
            "expressions": {
              "q": {
                "original": "",
                "parsed": null
              },
              "aq": {
                "original": "@syssource==(\"Coveo_web_index - V2CO-PProd-CD0-V2CO-PProd-CD0\") ((@fz95xpath48272==\"0DE95AE441AB4D019EB067441B7C2450\") (@fhaslayout48272==\"1\")) NOT @ftemplateid48272==(\"adb6ca4f-03ef-4f47-b9ac-9ce2ba53ff97\",\"fe5dd826-48c6-436d-b87a-7c4210c7413b\")",
                "parsed": "@syssource==(\"Coveo_web_index - V2CO-PProd-CD0-V2CO-PProd-CD0\") ((@fz95xpath48272==\"0DE95AE441AB4D019EB067441B7C2450\") (@fhaslayout48272==\"1\")) NOT @ftemplateid48272==(\"adb6ca4f-03ef-4f47-b9ac-9ce2ba53ff97\",\"fe5dd826-48c6-436d-b87a-7c4210c7413b\")"
              },
              "cq": {
                "original": "(@fz95xlanguage48272==\"cs\" @fz95xlatestversion48272==\"1\")",
                "parsed": "(@fz95xlanguage48272==\"cs\" @fz95xlatestversion48272==\"1\")"
              },
              "dq": {
                "original": "",
                "parsed": null
              },
              "lq": {
                "original": "",
                "parsed": null
              }
            },
            "enableDuplicateFiltering": false,
            "filterField": null,
            "filterFieldRange": 5,
            "parentField": null,
            "childField": null,
            "searchHub": "MySearchPage",
            "tab": null,
            "referrer": null,
            "recommendation": null,
            "locale": "cs",
            "lowercaseOperators": false,
            "context": {},
            "sortCriteria": [
              "relevancy"
            ]
          }
        },
        {
          "description": "Resolve pipeline",
          "duration": 0,
          "result": {
            "pipeline": "default",
            "splitTest": null
          }
        },
        {
          "description": "Resolve context",
          "duration": 0,
          "result": {
            "userAgent": {
              "raw": "Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.108 Safari/537.36",
              "browser": [
                "chrome"
              ],
              "device": [
                "desktop",
                "pc",
                "windows"
              ],
              "os": [
                "windows"
              ]
            },
            "expressions": {
              "q": {
                "original": "",
                "parsed": null
              },
              "aq": {
                "original": "@syssource==(\"Coveo_web_index - V2CO-PProd-CD0-V2CO-PProd-CD0\") ((@fz95xpath48272==\"0DE95AE441AB4D019EB067441B7C2450\") (@fhaslayout48272==\"1\")) NOT @ftemplateid48272==(\"adb6ca4f-03ef-4f47-b9ac-9ce2ba53ff97\",\"fe5dd826-48c6-436d-b87a-7c4210c7413b\")",
                "parsed": "@syssource==(\"Coveo_web_index - V2CO-PProd-CD0-V2CO-PProd-CD0\") ((@fz95xpath48272==\"0DE95AE441AB4D019EB067441B7C2450\") (@fhaslayout48272==\"1\")) NOT @ftemplateid48272==(\"adb6ca4f-03ef-4f47-b9ac-9ce2ba53ff97\",\"fe5dd826-48c6-436d-b87a-7c4210c7413b\")"
              },
              "cq": {
                "original": "(@fz95xlanguage48272==\"cs\" @fz95xlatestversion48272==\"1\")",
                "parsed": "(@fz95xlanguage48272==\"cs\" @fz95xlatestversion48272==\"1\")"
              },
              "dq": {
                "original": "",
                "parsed": null
              },
              "lq": {
                "original": "",
                "parsed": null
              }
            },
            "enableDuplicateFiltering": false,
            "filterField": null,
            "filterFieldRange": 5,
            "parentField": null,
            "childField": null,
            "searchHub": "MySearchPage",
            "tab": null,
            "referrer": null,
            "recommendation": null,
            "locale": "cs",
            "lowercaseOperators": false,
            "context": {},
            "sortCriteria": [
              "relevancy"
            ]
          }
        },
        {
          "description": "Apply 'queryParamOverride' rules",
          "duration": 0,
          "applied": []
        },
        {
          "description": "Resolve context",
          "duration": 1,
          "result": {
            "userAgent": {
              "raw": "Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.108 Safari/537.36",
              "browser": [
                "chrome"
              ],
              "device": [
                "desktop",
                "pc",
                "windows"
              ],
              "os": [
                "windows"
              ]
            },
            "expressions": {
              "q": {
                "original": "",
                "parsed": null
              },
              "aq": {
                "original": "@syssource==(\"Coveo_web_index - V2CO-PProd-CD0-V2CO-PProd-CD0\") ((@fz95xpath48272==\"0DE95AE441AB4D019EB067441B7C2450\") (@fhaslayout48272==\"1\")) NOT @ftemplateid48272==(\"adb6ca4f-03ef-4f47-b9ac-9ce2ba53ff97\",\"fe5dd826-48c6-436d-b87a-7c4210c7413b\")",
                "parsed": "@syssource==(\"Coveo_web_index - V2CO-PProd-CD0-V2CO-PProd-CD0\") (@fz95xpath48272==0DE95AE441AB4D019EB067441B7C2450 @fhaslayout48272==1) NOT @ftemplateid48272==(adb6ca4f-03ef-4f47-b9ac-9ce2ba53ff97,fe5dd826-48c6-436d-b87a-7c4210c7413b)"
              },
              "cq": {
                "original": "(@fz95xlanguage48272==\"cs\" @fz95xlatestversion48272==\"1\")",
                "parsed": "@fz95xlanguage48272==cs @fz95xlatestversion48272==1"
              },
              "dq": {
                "original": "",
                "parsed": null
              },
              "lq": {
                "original": "",
                "parsed": null
              }
            },
            "enableDuplicateFiltering": false,
            "filterField": null,
            "filterFieldRange": 5,
            "parentField": null,
            "childField": null,
            "searchHub": "MySearchPage",
            "tab": null,
            "referrer": null,
            "recommendation": null,
            "locale": "cs",
            "lowercaseOperators": false,
            "context": {},
            "sortCriteria": [
              "relevancy"
            ]
          }
        },
        {
          "description": "Preprocess query expression",
          "duration": 0,
          "result": {
            "type": "aq",
            "in": "@syssource==(\"Coveo_web_index - V2CO-PProd-CD0-V2CO-PProd-CD0\") ((@fz95xpath48272==\"0DE95AE441AB4D019EB067441B7C2450\") (@fhaslayout48272==\"1\")) NOT @ftemplateid48272==(\"adb6ca4f-03ef-4f47-b9ac-9ce2ba53ff97\",\"fe5dd826-48c6-436d-b87a-7c4210c7413b\")",
            "out": "@syssource==(\"Coveo_web_index - V2CO-PProd-CD0-V2CO-PProd-CD0\") (@fz95xpath48272==0DE95AE441AB4D019EB067441B7C2450 @fhaslayout48272==1) NOT @ftemplateid48272==(adb6ca4f-03ef-4f47-b9ac-9ce2ba53ff97,fe5dd826-48c6-436d-b87a-7c4210c7413b)"
          },
          "children": [
            {
              "description": "Apply 'thesaurus' rules",
              "duration": 0,
              "applied": []
            },
            {
              "description": "Apply 'stop' rules",
              "duration": 0,
              "applied": []
            },
            {
              "description": "Find and execute query extensions",
              "duration": 0
            }
          ]
        },
        {
          "description": "Preprocess query expression",
          "duration": 0,
          "result": {
            "type": "cq",
            "in": "(@fz95xlanguage48272==\"cs\" @fz95xlatestversion48272==\"1\")",
            "out": "@fz95xlanguage48272==cs @fz95xlatestversion48272==1"
          },
          "children": [
            {
              "description": "Apply 'thesaurus' rules",
              "duration": 0,
              "applied": []
            },
            {
              "description": "Apply 'stop' rules",
              "duration": 0,
              "applied": []
            },
            {
              "description": "Find and execute query extensions",
              "duration": 0
            }
          ]
        },
        {
          "description": "Preprocess query",
          "duration": 0,
          "result": {
            "in": {
              "q": null,
              "aq": "@syssource==(\"Coveo_web_index - V2CO-PProd-CD0-V2CO-PProd-CD0\") (@fz95xpath48272==0DE95AE441AB4D019EB067441B7C2450 @fhaslayout48272==1) NOT @ftemplateid48272==(adb6ca4f-03ef-4f47-b9ac-9ce2ba53ff97,fe5dd826-48c6-436d-b87a-7c4210c7413b)",
              "lq": null,
              "cq": "@fz95xlanguage48272==cs @fz95xlatestversion48272==1",
              "dq": null,
              "mq": null,
              "timezone": "UTC",
              "parentField": null,
              "childField": null,
              "filterField": null,
              "filterFieldRange": 5,
              "enableDuplicateFiltering": false,
              "enableWildcards": false,
              "enableQuestionMark": false,
              "enableDidYouMean": true,
              "enableCollaborativeRanking": false,
              "enableRankingInformation": true,
              "retrieveFirstSentences": true,
              "firstResult": 0,
              "numberOfResults": 10,
              "excerptLength": 200,
              "summaryLength": 0,
              "includedFields": null,
              "excludedFields": null,
              "queryFunctions": [],
              "rankingFunctions": [],
              "sortCriteria": [
                "relevancy"
              ],
              "rankingExpressions": [],
              "rankingOverrides": [],
              "groupByRequests": []
            },
            "out": {
              "q": null,
              "aq": "@syssource==(\"Coveo_web_index - V2CO-PProd-CD0-V2CO-PProd-CD0\") (@fz95xpath48272==0DE95AE441AB4D019EB067441B7C2450 @fhaslayout48272==1) NOT @ftemplateid48272==(adb6ca4f-03ef-4f47-b9ac-9ce2ba53ff97,fe5dd826-48c6-436d-b87a-7c4210c7413b)",
              "lq": null,
              "cq": "@fz95xlanguage48272==cs @fz95xlatestversion48272==1",
              "dq": null,
              "mq": null,
              "timezone": "UTC",
              "parentField": null,
              "childField": null,
              "filterField": null,
              "filterFieldRange": 5,
              "enableDuplicateFiltering": false,
              "enableWildcards": false,
              "enableQuestionMark": false,
              "enableDidYouMean": true,
              "enableCollaborativeRanking": false,
              "enableRankingInformation": true,
              "retrieveFirstSentences": true,
              "firstResult": 0,
              "numberOfResults": 10,
              "excerptLength": 200,
              "summaryLength": 0,
              "includedFields": null,
              "excludedFields": null,
              "queryFunctions": [],
              "rankingFunctions": [],
              "sortCriteria": [
                "relevancy"
              ],
              "rankingExpressions": [],
              "rankingOverrides": [],
              "groupByRequests": []
            }
          },
          "children": [
            {
              "description": "Apply 'filter' rules",
              "duration": 0,
              "applied": []
            },
            {
              "description": "Apply 'ranking' rules",
              "duration": 0,
              "applied": []
            },
            {
              "description": "Apply 'top' rules",
              "duration": 0,
              "applied": []
            },
            {
              "description": "Apply 'topClicks' rules",
              "duration": 0
            },
            {
              "description": "Apply 'recommendation' rules",
              "duration": 0
            },
            {
              "description": "Apply 'rankingweight' rules",
              "duration": 0,
              "applied": []
            }
          ]
        },
        {
          "description": "Send query to index",
          "error": "Call returned SOAP fault CGL::RetryStrategyExpiredException: "
        }
      ]
    }
  ]
}

Any suggestion to fix this?

Thanks,

Amit Mahajan

1 Reply
Gravatar for jflheureux@coveo.com

Answer by Jean-François L'Heureux, Jan 1, 2018 12:09 PM

I see in this error that the name of your security provider is "Expanded Sitecore Security Provider for V2CO-PProd-CD0-V2CO-PProd-CD0" on your CD server. All the CM and CD servers in the same Sitecore farm should share the same security provider. This suggests that you have not followed the Coveo for Sitecore scaling guide that explains how to set the farm name on the CM server before scaling to CD servers.

Ask a question