cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

An unexpected error has occurred in  nintex workflow

i am facing an issue  while opening workflow history for my sharepoint 2010 site

error is An unexpected error has occurred in  nintex workflow

detailed error from event log is given below.

please help

bc6f9b9b-5977-4564-a5ae-b3ed23fbc28a             

10/08/2014 17:01:48.82  w3wp.exe (0x5E74)        0x5CD0 SharePoint Foundation Runtime               tkau       Unexpected      

System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)     at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)     at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)     at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)     at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)     at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)     at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)     at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)     at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)     at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)     at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)     at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)     at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)     at System.Data.SqlClient.SqlConnection.Open()     at Nintex.Workflow.Administration.Database.OpenConnectionInternal(String connectionString)     at Nintex.Workflow.Administration.ContentDatabase.OpenConnection()     at Nintex.Workflow.Administration.Database.ExecuteReader(SqlCommand command, CommandBehavior behavior)     at Nintex.Workflow.Reports.ItemWorkflowInfoCollection.kh8=(Guid lx8=, Guid mB8=, WorkflowType mR8=)     at Nintex.Workflow.Reports.ItemWorkflowInfoCollection..ctor(Guid webId, Guid siteId, WorkflowType workflowType)     at Nintex.Workflow.ApplicationPages.ItemWorkflows.Page_Load(Object sender, EventArgs e)     at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)     at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)     at System.Web.UI.Control.OnLoad(EventArgs e)     at Microsoft.SharePoint.WebControls.UnsecuredLayoutsPageBase.OnLoad(EventArgs e)     at Microsoft.SharePoint.WebControls.LayoutsPageBase.OnLoad(EventArgs e)     at Nintex.Workflow.ServerControls.NintexLayoutsBase.OnLoad(EventArgs e)     at System.Web.UI.Control.LoadRecursive()     at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

bc6f9b9b-5977-4564-a5ae-b3ed23fbc28a             

Labels: (1)
0 Kudos
Reply
2 Replies
Workflow Hero

Re: An unexpected error has occurred in nintex workflow

HI Mahes,

Did you manage to sort out the issue?

Seems your user don't have the sufficient permission to access the Nintex content DB.

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: An unexpected error has occurred in nintex workflow

Make sure the user has 'Contribute' permissions in SharePoint. You need to go to all of the logs (including ULS logs) on the server to check for any other messages that may help troubleshoot the problem. Could SQL Server possibly have gone down for a second when you were trying to access the workflow history?

Lisa

0 Kudos
Accept as Solution Reply