Extract Documents to Folder based on Managed Metadata Column - SharePoint

  How to Extract documents from Multiple Document libraries in to Folders. Each has a Managed Metadata Column with Sub Terms. I have created three Functions to  Download Document Create Folder Main Method Addition to above, script will log the Document URL and destination Folder Path in .log file Create Folder   Function   Create-Folder {      param  ( $folderPath )      if  (!( Test-Path  -path  $folderPath ))     {          New-Item   $folderPath  -type directory     } } Download Document ( this is stolen from Stackoverflow 😁 ) Function   Download-Document {      param ( $web ,  $folderPath ,  $docItem )       #File Download Snippet Reffered From : https://stackoverflow.com/questions/43350575/how-to-use-powershell-to-download-files-from-sharepoint        $File  =  $web .GetFile ( $docItem .Url )          $Binary  =  $File .OpenBinary ()          $detinationPath  =  $folderPath  +  "\"  +  $File .Name ;          $Stream  =  New-Object  System.IO.FileStream( $detinationPath

How To Fix Nintex Workflow Activation Error

Enabling Nintex Workflow Feature failed

I wanted to Enable the Nintex Workflow Features for the newly created web application. The moment selects the web application and click ok to Activate the feature, below error appeared.

Different Posts on Nintex Community was saying different options for the same error. On of those was database Logical name was different than source Farm DB. But in my case even I make database logical names same, it did not work for me.

Then I had to check with Nintex Support for further details and they helped me to get the solution

Sorry, something went wrong

Warning: Unable to add the application pool account to the Nintex Workflow database. If you have permissions problems, contact support@nintex.com for assistance.

Technical Details

Troubleshoot issues with Microsoft SharePoint Foundation.

Correlation ID: be63519f-6822-4080-8d49-03863e6e0832

Date and Time: 5/11/2020 6:06:34 PM

This was due to two reasons
  1.  Farm account did not has enough permission for the Nintex config database. Error was in ULS As follows 
    1. Permission Error :Cannot open database "Nintex Config DB Name" requested by the login. The login failed. Login failed for user “domain\farm account”.

    2. Solution Provide WSS_Content_Application_Pools db permission for Farm account on Nintex Config Database
  2. Nintex Configuration Database was not getting updated with the new DB Server Name on dbo.Databases Table.
    1. Root Cause :When attached an existing configuration database to the Upgraded SharePoint farm, Nintex was failed to update the New DB Server Name in Databases table in Nintex Config Database.

    2. Solution: Update the ServerName Column on dbo.Databases Table on config Database with Actual DB Server name or SQL Alias you have used in the farm.

Databases  Table

Pre-Upgrade Check List

Download Our Free SharePoint Pre-Upgrade Check List

* indicates required

Vintage Clan

Popular posts from this blog

System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission - User Profile Issue

How to Create Host Header to SharePoint Web Application

SharePoint 2013 Access Denied in Site Collections in Web Application