I am attempting to build a very simple Site Workflow that will email the point of contact for each item in an external list that's in SharePoint (on-premise SP2016). We are running Nintex for SharePoint Standard.
- We have a SQL database external to SharePoint that is used to store HVAC temp/humidity readings. It has a few tables and a few views.
- I created a BDC in SharePoint so I can add an External List in SharePoint. It worked great. The list showed up in SharePoint. It is named “Out of Tolerance” (OOT).
- One of the views in the database filters on temp/humidity that is out of tolerance. This is the list that I had added to SharePoint. So it’s a small list of only 37 items.
- The table that was used to create the view DOES NOT have a key identifier (ID) column.
I was able to select the external list in the “Query List” action and my workflow seems complete and I set it on a schedule but it never runs. It doesn’t error or stall, it just never runs and I don’t see anything at all in the SharePoint ULS logs. I’m wondering if it’s not running because the list doesn’t have an ID column? And unfortunately there’s not a column in the table that would ever have a unique value. The columns that you would think would be unique are “Building” and “Room” but there may be several items in the list with the same building or room as there are several readings from throughout the day. Has anyone ever run into this scenario? Could the lack of ID column be why the workflow doesn't even attempt to run?
Here's the overall workflow and below are some screenshots of the first Query List action and the For Each action.