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


Popular posts from this blog

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

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 add PDF Icon in SharePoint

Image
How to add PDF Icon in SharePoint When we add new PDF document in to the SharePoint document library, it does not show the PDF Icon in the SharePoint site. Most of the time we face this challenge in SharePoint 2010. 1.        Navigate to Template/Images folder in 14 Hive C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\IMAGES 2.        Copy PDF Icon there 3.        Open Docicon.xml XML file in the XML folder   C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\XML\DOCICON.XML 4.        Copy following tag within ByExtension section    <Mapping Key="pdf" Value="pdficon.gif" /> 5.        Restart the IIS
Read more