Tag: 2016

SharePoint 2016 – MySite upgrade from SharePoint 2013 – Wrong URL

I have upgraded from SharePoint 2010 to SharePoint 2013 to SharePoint 2016 for database attachments. I updated my site's host URL in SharePoint 2016 UPS My Site to the new site collection, but Newsfeed, Onedrive, and Sites still point to the SharePoint 2013 URL.

Example:

My SharePoint 2013 website URL: http://sharepoint2013.domain.com/mysite
URL of my SharePoint 2016 website: https://sharepoint2016.domain.com/mysite

Note: In SharePoint 2016, read permission for my website, I can add users, click OK, but in "No exact match was found. Click the items that have not been resolved for more options." Same behavior with the secondary owner under "Clean up my website".

I also display 0 person results in SharePoint 2016 in my employee directory.

Any ideas on what I missed after upgrading my sites in SharePoint 2016.

SQL Server 2016 – Search for a specific query in the query store

I enabled SQL Server query store for a database. I have a specific query that I want to track. I have a lot of details about querying sp_BlitzCache (like SQL text, SQL handle, SQL hash, plan cache handle / hash, …).

Can I search the query memory with the information from sp_BlitzCache to find the query there? Finally, I want to force a specific execution plan because the query has problems with parameter sniffing.

SQL Server 2016 – General "An error occurred while editing the SSRS subscription" – No parameters are displayed

I am relatively new to SSRS reporting. I am trying to maintain a data driven subscription to a two-part report on a SQL Server Developer instance that acts as a dedicated SSRS server. At one time I was able to edit / manage a data-driven subscription to a report, but this no longer seems to work and a general error is displayed.

Steps to reproduce the error:

  • Navigate to the SSRS instance at http: // testReportServer / Reports / browse
  • Click on that Department Portfolio
  • Click on that report Portfolio
  • The report The folder contains a report part (Eval_rpt) and the main part
    Report (Evaluation_rpt)
  • I click on the ellipses for Evaluation_rpt and click on Manage because the subscription is set up there.
  • I click on subscriptions and there is one called exam
  • I click on To edit next to the exam subscription
  • The Edit Subscription page starts loading, then the generic "An error has occurred.
    Something went wrong. Please try again later. "
  • Enabled verbose logging on the SSRS instance and went through the reproduction of this error
    times. Nothing is meaningful or in the SSRS log output
    useful.
  • Open the Chrome / Firefox developer console on the network
    An error 500 for Model.GetParameters is displayed on the tab
  • When I click through the error SSRS gives me two parameters should be listed
    at the bottom of the edit subscription page, and they're not
    Appear for obvious reasons.

Previous facts, analysis, and troubleshooting steps:

  • This ReportServer / ReportServerTempDB database is on a
    SQL Server 2008 instance and were migrated to this 2016 instance late
    last year. This report has been working properly since this migration. It
    I recently tried to update this subscription and found it
    this problem.
  • This instance uses domain service accounts to run services (SQL Server, reporting service). I have checked the permissions / roles for this
    Service accounts on both the SSRS server and the SQL server hosting
    the remote data source for the report and body, and they appear to be correctly authorized.
  • The report in question contains data sources on a remote SQL server (e.g. ProdServer.Domain.org), and the credentials configured in these data sources are authorized to connect to and query the target database on ProdServer
  • This report is owned by the same service account used by the Reporting Services service.
  • I'm trying to edit this subscription with a Windows / AD account that has local administrator privileges on the Windows server, privileges on the SQL Server instance, and full administrator on the Reporting Server instance.
  • This doesn't seem to be a double-hop issue since I've checked that there is a trust relationship between these two servers and I can see KERBEROS connection / authentication methods when I search for them
  • The rsreportserver file is set up to use an authentication type from RsWindowsNegotiate
  • I searched / searched for shared / embedded data sources in the report parts. If necessary, I reconfigured these reports so that I didn't use a shared data source to get parameters, but redirected parameters to use a data source that was manually set up (manage) for the report parts themselves.
    the report section> Data Sources> Connect to a Custom Data Source>
    Specify AD credentials> Test connection)
  • I have confirmed that the service accounts used have rights not only for the report server database, but also for the rsExecRole and the associated subcomponents / stored procedures / tables in master and msdb.

Thank you in advance for any advice / suggestions you can offer.

gounlimited.to | BRAND NEW PLAYERS, BLAZING FAST STREAMING – Clean advertising – 24-hour payouts – Oldest video host since 2016 | Proxies-free

over

The GO Unlimited service, which may be known by the name of many of you, is one of the oldest services that specialize in video hosting. The goal of the service has always been to ensure the provision of a secure and stable platform for its long-term partners and to provide functions and features that match their aspirations, and of course to innovate to keep pace with the needs of the industry.

GO Unlimited, 2020

In 2020, we are trying to move traditional video hosting services to integrated solutions in this area by providing advanced tools, some of which have not previously been proposed or used in this area to keep up with the times Development in this industry and its requirements included.

————————————————– ————

Our goal

Our primary goal is to ensure the long-term stability of the platform and the stability of the services that the tools provide to their partners. We work in GO Unlimited based on long-term, not short, plans to ensure the opportunity to work many years and to successfully meet our partners' aspirations and aspirations.

Our work since 2016 and our achievements are proof of this goal that we strive for. We will continue to work towards this goal.

If you have any suggestions or inquiries, we are always happy to receive them.

2016 – Remove the link from the quick start navigation heading

Is it possible to use quick start headings as categories that are not links themselves? I don't want the headings to be clickable.

I tried to set the web address to empty. javascript: return true;etc., but SharePoint is quite strict because it is a "valid" URL.

The current heading does that, but I feel like it's a special kind of heading.

My best bet seems to be removing the links with some js on the master page, but that seems a bit choppy.

Is there a better way?

gounlimited.to | 5% Lifetime Bounce – DOUBLE PRICES FOR APRIL – Clean Ads – 24 Hour Payouts – Oldest Video Host Since 2016 | Proxies-free

over

The GO Unlimited service, which may be known by the name of many of you, is one of the oldest services that specialize in video hosting. The goal of the service has always been to ensure the provision of a secure and stable platform for its long-term partners and to provide functions and features that match their aspirations, and of course to redevelop to keep up with the demands of the industry.

GO Unlimited, 2020

In 2020, we are trying to move traditional video hosting services to integrated solutions in this area by providing advanced tools, some of which have not previously been proposed or used in this area to keep up with the times Development in this industry and its requirements included.

————————————————– ————

Our goal

Our primary goal is to ensure the long-term stability of the platform and the stability of the services that the tools provide to their partners. We work in GO Unlimited based on long-term, not short, plans to ensure the opportunity to work many years and to successfully meet our partners' aspirations and aspirations.

Our work since 2016 and our achievements are proof of this goal that we strive for. We will continue to work towards this goal.

If you have any suggestions or inquiries, we are always happy to receive them.

Result Source – The SharePoint 2016 Query Builder inserts "ContentTypeId" instead of "ContentType".

In on-premises SharePoint 2016, I was having trouble getting results based on a content type that I created when trying to configure a result source to search for that content type. I finally decided to see what I was doing on a SharePoint 2013 website that worked when I found that I was using Result Source Query Builder in 2016 when I selected "ContentType" and clicked "Add Property Filter" , the query generator "ContentTypeId" inserted, not "ContentType". That threw me off a bit. I just wanted to post this if someone has a similar problem. After I manually edited the pasted text to simply remove the "ID" at the end of "ContentType", the result source worked as intended. Is this a bug in SharePoint 2016 or is it expected in some way? If so, where do you report errors in SharePoint to Microsoft?

Enter the image description here

2016 – Insufficient permissions for the managed metadata service

I'm having an issue where some term store administrators get an error saying they don't have the necessary permissions to add, update, and change terms and settings. Some are still able to do this. I'm lost because they all seem to have the same permissions. These users are all farm administrators.
What kind of things should I investigate?

gounlimited.to | 5% Lifetime Bounce – DOUBLE PRICES FOR APRIL – Clean Ads – 24 Hour Payouts – Oldest Video Host Since 2016 | Proxies-free

over

The GO Unlimited service, which may be known by the name of many of you, is one of the oldest services that specialize in video hosting. The aim of the service has always been to ensure the provision of a secure and stable platform for its long-term partners and to provide functions and features that match their aspirations, and of course to innovate to keep pace with the needs of the industry.

GO Unlimited, 2020

In 2020, we're trying to move traditional video hosting services to integrated solutions in this area by providing advanced tools, some of which have not previously been proposed or used in this area to keep up with the times Development in this industry and its requirements included.

————————————————– ————

Our goal

Our primary goal is to ensure the long-term stability of the platform and the stability of the services that the tools provide to their partners. We work in GO Unlimited based on long-term, not short, plans to ensure the opportunity to work many years and to successfully meet our partners' aspirations and aspirations.

Our work since 2016 and our achievements are proof of this goal that we strive for. We will continue to work towards this goal.

If you have any suggestions or inquiries, we are always happy to receive them.

An attempt to open Excel in SharePoint 2016 via the Office online server failed

I am trying to open an Excel document in SharePoint 2016 with Office Online Server. I installed and configured the Office Online Server on a separate server and configured SharePoint to use the OOS.

I think the configuration is correct because I can view Word documents in the browser.
When I try to view Excel files, blank files appear and there are some errors in the browser console.
The mistakes are 

Redirects are not allowed for CORS preflight requests.

XMLHttpRequest: NEtwork Error 0x80070005, Access is denied.

Error messages in the console

Enter the image description here

There are no errors when I try to open a Word document.
Let me know if more information is needed.