Sharepoint 2016 crashes after MS Office 2016 64bit installation

everyone.

Have been stumbled upon a very unusual issue – after MS Office installation all web applications (bad practice, i know), including central admin, return a 503 error. Reason is application pools in stopped condition. Any attempt to start up application pool fails.

There are no errors in Sharepoint Logs – only in event viewer. This and this

Faulting application name: w3wp.exe, version: 10.0.14393.0, time stamp: 0x57899b8a
Faulting module name: KERNELBASE.dll, version: 10.0.14393.2457, time stamp: 0x5b7e2adb
Exception code: 0xc06d007e
Fault offset: 0x0000000000033c58
Faulting process id: 0x1fcc
Faulting application start time: 0x01d63281c5b132ed
Faulting application path: c:windowssystem32inetsrvw3wp.exe
Faulting module path: C:WindowsSystem32KERNELBASE.dll
Report Id: ef188be8-b68e-4cbd-b7e3-82279f93967e
Faulting package full name:
Faulting package-relative application ID:

and this

The Module name SharePoint14Module path C:Program FilesCommon FilesMicrosoft SharedWeb Server
Extensions16isapiowssvr.dll returned an error from registration. The data is the error.

I looked up a little bit – Enable 32-bit application is set to false, manipulations with ApplicationHost.config doesn’t bring anything.

Does anyone have any idea what is source of this troubles?

Thanks in advance!

How to get certificate expiration date for certificate in mirroring endpoint in SQL Server 2016 Always On Availability Group?

I created a domain-independent 2-node SQL Server 2016 Always On Availability Group using the Microsoft instructions:

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/domain-independent-availability-groups?view=sql-server-ver15

One of the steps creates an endpoint using a certificate:

CREATE ENDPOINT DIAG_EP
STATE = STARTED
AS TCP (   
    LISTENER_PORT = 5022,
    LISTENER_IP = ALL
      )
FOR DATABASE_MIRRORING (
    AUTHENTICATION = CERTIFICATE InstanceX_Cert,
    ROLE = ALL
      )

The cluster is working and some months later I want to check on the expiration date of this certificate. So I run this query:

select * from sys.certificates

This query returns the empty set. This can’t be right, I know the mirroring endpoint is using a certificate. So then I run this query to list all the mirroring endpoints:

select * from sys.database_mirroring_endpoints

And indeed it says connection_auth_desc = CERTIFICATE and certificate_id = XXX in the response. So it must be using a certificate. None of the columns in the response actually say which certificate or what the expiration date is.

Does anyone have any guidance on how to track down this certificate used in the mirroring endpoint in the SQL Server Always On Availability Group and check its expiration date? Also, how can I update this certificate in the future without causing downtime for the cluster?

Any help would be greatly appreciated!

2016 – Taxonomy Field Values/Filtering with SPFx

Taking a stab at it. Please correct me if I am wrong.

Assuming that you need to fetch all data from a SharePoint list including a taxonomy column, you want to display that data on a page. Also, then you want to provide some sort of filter on that data.

So, the approach for that would be to make a standard REST API call to the list and then store the JSON response. Bind this JSON response to HTML and also provide some sort of filter ( input/textbox maybe ? ) so that user can search within this data.

Make use of the TaxCatchAll column to fetch the term value as below:

private _getListData(): Promise<any> {

 let restEndPoint = this.context.pageContext.site.absoluteUrl + `/_api/web/lists/getbytitle('Documents')/items?
                    $select=Title,ID,Description,TaxonomyColumn,TaxCatchAll/ID,TaxCatchAll/Term
                    &$expand=TaxCatchAll`;

 return this.context.spHttpClient.get(restEndPoint , SPHttpClient.configurations.v1)
   .then((response: SPHttpClientResponse) => {

    response.json().then((responseJSON: any) => {  
          console.log(responseJSON);  

          // foreach value in responseJSON
          // do something or other

          // bind data to html
          // bindData(responseJSON);

        });      
   });
}

You’ll get objects back for TaxonomyColumn, and TaxCatchAll. TaxonomyColumn will have the Term Set object information and TaxCatchAll will have the TaxonomyColumn term values. Here, replace the TaxonomyColumn with your managed metadata column internal name.

Once the JSON is received, you can make a copy of it or store it in a global variable. Assuming an input box for filter, when user enters some keyword, fire up an event to filter this JSON itself.

PS – Since you tagged it 2016 and not SPO, you wont be able to use the shiny new RenderListDataAsStream endpoint which is much more reliable.

2016 – SharePoint list exports differently to display Excel

We recently upgraded to SP 2016.
Our Excel reports extract data from linked SharePoint lists.
After the upgrade, the lists display correctly in SharePoint, but are disjoined in Excel with some fields omitted.
The initial investigation of our development team points to columns that linked items, it wasn’t a problem before, did anyone experience it
I enjoyed it.

How to synchronize AD users with the SharePoint 2016 user profile service?

I upgraded SharePoint 2010 from 2013 to 2016. I am unable to successfully synchronize AD with the SharePoint 2016 User Profile Service. I have followed the instructions here https://docs.microsoft. com / en-us / sharepoint / administration / configure-profile-synchronization-by-using-sharepoint-active-directory-import. The sync account has been added as a user in AD Delegate Control. Did I miss a step? How do I get AD users to sync with the SharePoint User Profile service.

Transactional replication between versions of SQL Server 2012 and SQL Server 2016 failed

According to Microsoft documentation – A subscriber to a transactional publication can be any version in two versions of the Publisher version. For example: a SQL Server 2012 (11.x) publisher can have SQL Server 2014 (12.x) and SQL Server 2016 (13.x) subscribers; and a SQL Server 2016 (13.x) publisher can have SQL Server 2014 (12.x) and SQL Server 2012 (11.x) subscribers.

But the subscription I'm trying to create from Microsoft SQL Server 2012 (SP3) (KB3072779) – 11.0.6020.0 (X64) to Microsoft SQL Server 2016 (SP2-CU12) (KB4536648) – 13.0. 5698.0 (X64) fails and here is the error message I receive – The selected subscriber does not meet the minimum version compatibility level of the selected publication.

Are these versions not compatible?

Error i update SP2-CU11 on MS SQL Server 2016

I am trying to update SP2-CU5 (KB4475776) to SP2-CU11 on Microsoft SQL Server 2016. I get the error below again and again. Please suggest possible resolution of this error.enter description of image here

SharePoint 2016 search schema – An unknown error has occurred

We have a SharePoint 2016 server farm on site composed of 3 servers (application and search + wfe + database). We recently found that enterprise search was not working. When looking at the analysis logs under the search service application, the following error was reported and the analysis did not work:

The content processing pipeline could not process the item

There have been comments on the Internet suggesting that this could be due to a problem with the Matedata Manged property mappings, but when you click on the search scheme in Search Administration, it displays the following error without displaying the managed properties.

An unknown error has occurred.

We tried to restart the search host service and the time service, but that did not help.

Any help in solving the problem is greatly appreciated.

If someone told you in 2016 that Trump's presidency would end in a massive recession and the death of the country, would you have been surprised?

Honestly, no. Trump was an unfortunate mistake. I really hope we don't re-elect him.

(I should add that the pandemic was not his fault, but its management could have been better) Sometimes I feel bad for Trump. He must suffer a lot, with his narcissistic personality, make fun of so many things. But the bottom line is that we cannot re-elect him.

2016 – SharePoint site is locked

I have run the script below to unlock the SP site.

$admin = new-object Microsoft.SharePoint.Administration.SPSiteAdministration (“Site-Collection-URL”)
$admin.ClearMaintenanceMode()

Getting below error message when I run the above script

> Exception calling clearmaintenance().Failed to update database
> "".Because the database is read only

When I check the content database, everything is set to read-write mode. Not in read-only mode