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

SharePoint Cumulative Update Error Could not load file or assembly Microsoft.ReportingServices.Alerting.ServiceContract


SSRS Integrated Mode Issue Microsoft.ReportingServices.Alerting.ServiceContract




Exception: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.ReportingServices.Alerting.ServiceContract, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

After very long time I had to patch my SharePoint farm and during the UAT I was facing this issue.
Unfortunately this was the first time I ever faced this issue and it took me pretty good time to find the solution.
If you also have a SharePoint farm with SSRS Integrated mode and Report Viewer Web Part Deployed to your farm, then you might face this issue.
Issue:
After successful installation of Binaries of SharePoint 2013 CU March 2019 Every time when Product Configuration wizard executed on the Server, I got this error in PSDiagonstic 





Error Log

Exception: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.ReportingServices.Alerting.ServiceContract, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

   at Microsoft.ReportingServices.SharePoint.SharedService.Client.ReportingWebServiceApplicationProxy.InitializeEndpointChannel()

   --- End of inner exception stack trace ---

   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

   at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

   at System.Reflection.ConstructorInfo.Invoke(Object[] parameters)

   at Microsoft.SharePoint.Administration.SPAutoSerializingObject.GetInstanceFromType(Type type, String typename)

   at Microsoft.SharePoint.Administration.SPConfigurationDatabase.GetObject(Guid id, Guid parentId, Guid type, String name, SPObjectStatus status, Byte[] versionBuffer, String xml)

   at Microsoft.SharePoint.Administration.SPConfigurationDatabase.FetchObject(Guid id)

   at Microsoft.SharePoint.Administration.SPConfigurationDatabase.GetObject(Guid id, Boolean checkInMemoryCache, Boolean checkFileSystemCache)

   at Microsoft.SharePoint.Administration.SPConfigurationDatabase.ResolveObjectAndClassVersions(SPLog log)

   at Microsoft.SharePoint.Upgrade.SPConfigurationDatabaseSequence2.Upgrade()

   at Microsoft.SharePoint.Upgrade.SPUpgradeSession.Upgrade(Object o, Boolean bRecurse)

   at Microsoft.SharePoint.Upgrade.SPManager.BootStrap(Guid sessionId, SPUpgradeOperationFlags flags)

   at Microsoft.SharePoint.PostSetupConfiguration.UpgradeBootstrapTask.Run()

   at Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()

Resolution

This is caused by the WSP solution related to the Report Viewer Web part and Microsoft has warned regarding the same.
And resolution suggested in this article (https://docs.microsoft.com/en-us/sql/reporting-services/report-server-sharepoint/deploy-report-viewer-web-part?view=sql-server-2017 ) was  to
1.    Remove the Report Viewer web part
2.    Uninstall SSRS
3.    Reinstall the Report Viewer web part
In my scenario our BI Team was not using this web part in UAT farm, hence I simply uninstall and remove the farm solution from the SharePoint Farm.
Problem Solved, Next time PSConfig executed like a charm.



Cheers

Pre-Upgrade Check List

Download Our Free SharePoint Pre-Upgrade Check List

* indicates required

Vintage Clan

Best Leather Journal

Popular posts from this blog

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
Read more

How to Create Host Header to SharePoint Web Application

Image
How to Create Host Header to SharePoint Web Application Log in to the Server and Open DNS > THost Header and IP Address, Click on Add Host > Create New Web Application Go to Central Administration and Create your new web application Create Web Application and Provide the Host header you just created with Port 80 Once you create the Web Application, Create associated site collection. Edit Bindings in IIS Web Site 1.         Open IIS and find newly created Web Site 2.        Right click and go to Edit Bindings Add Record to the Server Host File  Open Note Pad as Administrator and navigate to following location  C:\Windows\System32\drivers\etc   Add new record as follows Disable loop back of the Web Server Open Registry Editor Navigate to following location HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa    Create New Value (DisableLoopBackCheck) Type of DWORD and set value to 1
Read more

SharePoint 2013 Access Denied in Site Collections in Web Application

Image
Not a good way to start the day. All Site collections in a Web Application is giving Access Denied Error to all the Users. Even SharePoint Setup Account which is a Farm account and Primary Site collection administrator for all the site collections. IIS reset, Server Restart everything was tried. But missed the simple thing SharePoint Super Reader and Super User Account !!! Fortunately one of the Microsoft PFE was in our office today. It came to her mind and just tried the setting Super User and Super Reader Accounts again through powershell. NOTE: same accounts were already configured properly but reconfigured through PowerShell. Problem Solved $ wa = Get-SPWebApplication -Identity "http://WebApplicationURL" $ wa .Properties [ "portalsuperuseraccount" ] = "domainName\SuperUserAccount" $ wa .Properties [ "portalsuperreaderaccount" ] = "domainName\SuperReaderAccount" $ wa .Update ()
Read more