Posts

Showing posts from April, 2020

Extract Documents to Folder based on Managed Metadata Column - SharePoint

Image
  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

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

Image
Another Database Level Challenge I faced with the User Profile My Site Host. Once I have configured entire SharePoint 2019 Farm and User Profile Service, While Loading My Site Site Collection I was getting below Error. as ULS log Explained detail Error was as follows System.Data.SqlClient. SqlException (0x80131904):  The EXECUTE permission was denied on the object 'profile_GetUserProfileData', database profileDB, schema 'upa' .     at System.Data.SqlClient. SqlConnection.OnError( SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)     at System.Data.SqlClient. TdsParser. ThrowExceptionAndWarning( TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)     at System.Data.SqlClient. TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)     at System.Data.SqlClient. SqlDat

Enabling Nintex Workflow Feature Failed - Sorry, Something Went Wrong

Image
Finally I was bring SharePoint 2019 Up and running on On Prem. Then I wanted to test my Nintex Workflows and tried to Enable the Nintex Workflow Feature on the Site Collection Level. Then... This Happen The Error message which we all are familiar Sorry, something went wrong An unexpected error has occurred. Technical Details Troubleshoot issues with Microsoft SharePoint Foundation. Correlation ID: Correlation  ID Date and Time: date and time then I followed the old fashion  ULS Logs check with my ULS Viewer  Finally Found the Culprit  Feature receiver assembly 'Nintex.Workflow.Features, Version=1.0.0.0, Culture=neutral, PublicKeyToken= 913f6bae0ca5ae12', class 'Nintex.Workflow.Features. ContentTypeUpgradeFeatureEvent Handler', method 'FeatureActivated' for feature '86c83d16-605d-41b4-bfdd- c75947899ac7' threw an exception: Nintex.Workflow. NWFeatureActivatingException: Nintex.Workflow. NWDatabaseConnectionException: Failed to op

Pre-Upgrade Check List

Download Our Free SharePoint Pre-Upgrade Check List

* indicates required

Vintage Clan