question

JHAMRI-8779 avatar image
0 Votes"
JHAMRI-8779 asked JHAMRI-8779 published

SharePoint 2019 content database migration - No search Results

Hello Experts,
I have migrated a content database containing a basic Team site from SharePoint 2013 to SharePoint 2019. Everything working just fine except no search results within this site collection.
Doubled checked everything : Crawl account and search account have Full read on the web application, the site collection is crawled and I can fin results in the index when I go to browse it in CA. The difference between SP 2013 and SP 2019 for this site collection is that :
- We had too many web applications in SP2013 (One WA for every site collection, configured with Kerberos auth)
- in SP2019, we created a single WA and converted the migrated site collection from path based to Host named site coll, still using Kerberos.
- The SP2019 Web application has a host header, so no server name as URL. I know that combining Host Header Web applications with Host named site collections is not know to be the best marriage, but everything works fine in the QA Farm (SP2019 with 2 servers : 1 WFE with Distributed cache, 1 APP with Search). The Production farm is 4 servers (2 WFE+DistributedCache and 2 APP+Search)
- The SP2019 HNSC has 3 zones : https://defaultzone.domain.com, https://intranetZone.internal.local and http://customZone.domain.com
- The parent SP2019 Web App has only 1 zone : http://DefaultZoneUrl.domain.com

What I already tried :
- Debugging everything
- Recreating Search Service App
- Index reset
- Restarting SPTimer, IIS, Search Service

Search works just fine in other site collections I created within the same Web Application for testing purposes. I also created a Search center which works fine, but I noticed that no items are returned from the migrated site collection.

If anyone has any idea or a potential solution, I would be grateful.

Thanks


office-sharepoint-server-administrationoffice-sharepoint-server-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JHAMRI-8779 avatar image
0 Votes"
JHAMRI-8779 answered JHAMRI-8779 published

We finally managed to solve this with Microsoft's help.

The problem came from the fact that we had some site collections with TENANTADMIN template, using site subscriptions.

We migrated the other site collections but not the tenant site admin site collection.

Solution was to remove all site subscriptions from the SP 2019 Farm, because it will no longer be supported in SP 2019. We managed to do this by removing SubscriptionID values from AllSites Table in the content database and SITEMAP table in the Config Database.
We used this query :

USE [Contentdb]
UPDATE AllSites SET SubscriptionId = NULL where SubscriptionId IS NOT NULL
USE [Configdb]
UPDATE SiteMap SET SubscriptionId = NULL where SubscriptionId IS NOT NULL

This is of course risky and I would highly recommend backing up your farm before editing databases directly.

Thank you all for your help and suggestions.

@sadomovalex @Srini-4386 @JerryXu-MSFT

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JerryXu-MSFT avatar image
0 Votes"
JerryXu-MSFT answered

Hi, @JHAMRI-8779 ,

Have you checked the Site Settings>Search and offline availability to make sure Allow this site to appear in search results is set to yes?

As the content in the site has been correctly crawled, please check the query rule and result source currently used. Ensure that the site collection is not excluded.

From your description, the issue only impacts a certain site collection. I just would like to know a bit more information. The search does not return the site contents in Search Center. Are you testing with an account with permission to view the site contents?


If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JHAMRI-8779 avatar image
0 Votes"
JHAMRI-8779 answered JHAMRI-8779 commented

Hello @JerryXu-MSFT,

Many thanks for you reply.

I did check site settings for offline availability. Everything is fine, no specific exclusion. The site collection is well crawled and I can see all its content in the Crawl Log with "successful" flag (and 2 or 3 errors with the classing parsing of documents).

I am using an account with site collection Admin rights (the same that I use to connect to the 2013 site collection) to test search results.
And yes, in the search center, tried few queries with keywords from this specific site collection and I get also no results from it.

This is the first migrated site collection. The other 2 or 3 site collections we have in the farm are all created directly in SharePoint 2019 for testing purposes.

I am thinking of doing a backup of the site collection and restore it with basic path based url and test the search. Or maybe have the same protocol (https) on the Web app as the HNSC.

If nothing works, would opening a microsoft case help ?

Thanks

· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@ Jhamri have you tried deleting the config cache ?

0 Votes 0 ·

@Srini-4386 Yes I did, on the 4 servers, nothing changed ...

0 Votes 0 ·

Hi, @JHAMRI-8779 ,

Testing with a basic path URL will be a good option for troubleshooting. If that does not help, you can open a support ticket about it. The support team will provide more in-depth investigation against your farm.

1 Vote 1 ·
Show more comments
sadomovalex avatar image
0 Votes"
sadomovalex answered JHAMRI-8779 commented

did you check also full crawl log? Does it contain any mentions of problematic web app?

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Yes we did !
We tried everything. We opened a case, and MS are currently investigating. I'll post an update once we have news from them.

0 Votes 0 ·