Skip to main content
Nintex Community Menu Bar

Missing Nintex Workflow Constants from farm server

  • October 8, 2019
  • 11 replies
  • 30 views

ZebAhmed
Forum|alt.badge.img+2

I have inherited a SharePoint 2013 environment that makes heavy use of Nintex Worflow and Forms 2013 (on prem.)

 

One of these is a workflow that automatically sets up a Lync account for a new user. This stopped working recently; I assumed this was due to the fact that the SFB Server name had been changed recently (they did some upgrades.)

 

On checking the workflow itself I could only find a reference to the SFBServer workflow constant, problem is, it doesn't exist on any of the SharePoint servers we have. I found the attached image from the original notes the SharePoint dev made in terms of the workflow constants he had set up, and NONE of these exist anymore. Only 3 exist, and of those 3 only 2 are mentioned in the attached image.

Not too sure what has happened here so would love some assitance. Am I looking in the wrong place? Is there a way to bring them back?

11 replies

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • October 8, 2019
Hi,
Isnt the Workflow Constant that you are looking for the 4th one in your screen shot?

ZebAhmed
Forum|alt.badge.img+2
  • Author
  • October 8, 2019

Hi yes it is, what I'm saying is that the ones you see in the screenshot are now missing. Dissapeared. Gone. They don't exist anymore. That's a screenshot from the support documentation from back in 2016 when this was set up.


Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • October 8, 2019
Opps,

Are you looking in Central Administration or from the Nintex Menu in the site settings?

ZebAhmed
Forum|alt.badge.img+2
  • Author
  • October 8, 2019

From Central Administration :)


ZebAhmed
Forum|alt.badge.img+2
  • Author
  • October 8, 2019

Should also add that I checked under site settings as well to see if they were set at a site level (they weren't.) Accoding to the notes the developer made, seems like he did it at the farm level.


Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • October 8, 2019

Not sure why they would disappear.
You can try find the root cause for this issue or you could just re-create them.
If you want to find the root cause you may need to contact Nintex Support support@nintex.com to look at the database etc where the constants are stored. If they were deleted it may be hard to find out by whom and when.


ZebAhmed
Forum|alt.badge.img+2
  • Author
  • October 8, 2019

We have a DBA, is there a way he can check? If so what steps would he need to follow?


Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • October 8, 2019
Your DBA can look in the dbo.WorkflowConstants table in the Nintex Configuration database to see what constants are present.
If they are there it may mean that you cannot see them in SharePoint due to some sort of permissions issue.

ZebAhmed
Forum|alt.badge.img+2
  • Author
  • October 9, 2019

Thanks Simon. He extracted the table for me and all the missing entries are there. You mentioned it could be a permission issue for me not seeing them. I am set as the site colletion administrator (in central admin) so could you point me in the right direction in terms of what elevated permissions I need?


Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • October 9, 2019

Hi,

The screen shot in your first post shows yellow padlocks next to some of the constants.  This means that the Edit Permissions option was used from the workflow constant page and set to certain users or groups that you are obviosly not apart of and that is why you cannot see them at all. (I tested this functionality).
To find out the groups or users that have access have your DBA query the dbo.WorkflowConstantSecurity table in the Nintex configuration database and this will reveal the users that have access to which constant. An Inner join can be used to show the user(s) and the title of the Workflow Constant.

Example.

SELECT [Username]
       ,I.Title
  FROM [NintexWorkflowDB].[dbo].[WorkflowConstantSecurity]
  Inner Join dbo.WorkflowConstants I
  on WorkflowConstantID = I.ID

ZebAhmed
Forum|alt.badge.img+2
  • Author
  • October 9, 2019

HI Simon, just wanted to thank you for your help with this. You were spot on about the reason they weren't appearing for me was because they were locked down to specific accounts. Got my dba to check as per your suggestion and I was able to get the pw for one of the accounts that DID have acces and make the necessary changes. Once again, THANK YOU :)