Fixed - Failed to start service Sitecore XConnect Search Indexer

If you are installing Sitecore 9/9.1/9.2, you may get xConnect services error such as

Faulting application name: XConnectSearchIndexer.exe, version: 3.0.0.0, time stamp: 0xf3556d61
Faulting module name: KERNELBASE.dll, version: 10.0.18362.1, time stamp: 0x1a30e11b
Exception code: 0xe0434352
Fault offset: 0x000000000003a839
Faulting process id: 0x1dd8
Faulting application start time: 0x01d563cefdbb60d1
Faulting application path: C:\inetpub\wwwroot\habitathomecorporate_xconnect.dev.local\App_Data\jobs\continuous\IndexWorker\XConnectSearchIndexer.exe
Faulting module path: C:\Windows\System32\KERNELBASE.dll
Report Id: bee07631-f2fa-48b6-9307-b4296f68ff50
Faulting package full name:
Faulting package-relative application ID:

Solution :-

I follow below steps and its solved my issue

• Close all PowerShell window
• Remove any existing "DO_NOT_TRUST_SitecoreRootCert" certificate from your machine
• Provide "Full Permission" to "Everyone" to folder "c:\resourcefiles"
• Provide "Full Permission" to "Everyone" to folder "C:\inetpub\wwwroot.

Try again to install the Sitecore and you should get your instance up now.

I hope this solution helps other in similar situation.

Fixed : Sitecore multilist with search not showing data

In my Sitecore instance, I was not getting data in "Semantics" multilist with search field under "Tagging" section in Home item. By default this field should show atleast one value "Test tag".

Solution :-

Simply rebuild your master index. After that you should get data in multilist with search field.

Multilist with search

How to execute Sitecore GraphQL query in Postman

GraphQL is querying technic to get the result in JSON format. 

It means now you can get Sitecore items in JSON format using GraphQL.

You can test your GraphQL query either directly on browser or on POSTMAN.

This article highlight how you can do the same using Postman GET and POST method.

Using POST Request

1.   Open Postman and create new Request

 

New Request Window

 

2.   Save Request by providing Request name, description etc.

Save Request Window

3.   Select POST request type and enter request URL with “sc_apikey” query string as

http://<dosmainname>/sitecore/api/graph/mygraphapi?sc_apikey={D259F575-F8E2-452F-8A1B-AB699CC6503C}. This will add key "sc_apikey" in “Params” section as

Params in POST request

4.    Select Body tab and select “raw” and format type as “JSON(application/json)”. Write your GraphQL query in body textbox as

Query in Body section

This action add “Content-Type” as "application/json" in “Headers” tab.

5.   Click on “Send” button and you should get your query JSON result as

Post Request

Using GET Request

1.   Open Postman and create new Request

2.   Save Request by providing Request name, description etc.

3.   Select GET request type and enter request URL with “sc_apikey” and “query” query string as “http://my-first-jss-app.dev.local/sitecore/api/graph/mygraphapi?sc_apikey={D259F575-F8E2-452F-8A1B-AB699CC6503C}&query={ search(fieldsEqual: [], first: 10, after: "3") { results { items {item {id name itemPath: path url } } } }}”. This will add key "sc_apikey" and “query” in “Params” section.

 

4.    Click on “Send” button and you should get your query JSON result as

Get Request

Note:- While writing your query, just remove all escape lines. In other words, you must write your query in single line without any truncation.

That's it.

I hope you will use Postman for executing Sitecore GraphQL query.

Stay tuned for more such cool tricks.