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
Get link
Facebook
Twitter
Pinterest
Email
Other Apps
Enabling Nintex Workflow Feature Failed - Sorry, Something Went Wrong
Get link
Facebook
Twitter
Pinterest
Email
Other Apps
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
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.ContentTypeUpgradeFeatureEventHandler', method 'FeatureActivated' for feature '86c83d16-605d-41b4-bfdd-c75947899ac7' threw an exception: Nintex.Workflow.NWFeatureActivatingException: Nintex.Workflow.NWDatabaseConnectionException: Failed to open a connection to the Nintex Workflow configuration database. ---> System.Data.SqlClient.SqlException: Cannot open database " Nintex workflow configuration db" requested by the login. The login failed. Login failed for user “Domain\webapppoolAccount”.
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at Nintex.Workflow.Administration.Database.OpenConnectionInternal(String connectionString)
at Nintex.Workflow.Administration.ConfigurationDatabase.OpenConfigDataBase() -
-- End of inner exception stack trace ---
at Nintex.Workflow.Administration.ConfigurationDatabase.OpenConfigDataBase()
at Nintex.Workflow.Administration.Database.ExecuteReader(SqlCommand command, CommandBehavior behavior)
at Nintex.Workflow.Administration.GlobalConfig.LoadData()
at Nintex.Workflow.Administration.GlobalConfig.GetGlobalConfig(Boolean forceRefresh)
at Nintex.Workflow.Administration.ConfigSettings.GetConfigSettings(SPSite site)
at Nintex.Workflow.Common.NWSharePointObjects.<>c__DisplayClass2.<SetMultiOutcomeTaskEditForm>b__0()
at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode)
at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param)
at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode)
at Nintex.Workflow.Common.NWSharePointObjects.SetMultiOutcomeTaskEditForm(SPWeb web)
at Nintex.Workflow.Features.ContentTypeUpgradeFeatureEventHandler.FeatureActivated(SPFeatureReceiverProperties props)
at Nintex.Workflow.Features.ContentTypeUpgradeFeatureEventHandler.FeatureActivated(SPFeatureReceiverProperties props)
at Microsoft.SharePoint.SPFeature.DoActivationCallout(Boolean fActivate, Boolean fForce)
Simply issue was In the Database Server, Nintex Workflow Configuration Database does not have enough permission for the Web Application App Pool Account.
Resolution
then I gave the same permission as Contant Database which is WSS_Content_Application_Pools Permission on DB Account Permission Section
Then once permission provided, I was able to successfully enable the required Nintex Workflow Features
hope This might help someone like me :) Leave me a comment in case if it was helpful.
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
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
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 ()
