Showing posts from April, 2020

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

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

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=, 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