Workflow Error when connecting with a database

When I googled, they suggested doing the following.  Ensure the Connection String is properly formatted, contains no typographical errors and is not pointing to a server with a private IP address.

I did all that but still get the error.  Any suggestions?  Thank you.

Hi Lily,

The error you are seeing is occurring when the workflow is contacting a SharePoint list rather than SQL. I'm not sure where this is occurring in your workflow, possibly when you are trying to build the string and it's trying to get the values from a list item? If you can work out which list has the ID that starts with 'F7AFDDF' which is listed in the error, it is a failure on contacting that list.

It could also be the Update workflow status possibly - What values are you updating the status to, it may not allow certain characters.

Thanks,

Callum

Thank you so much for your response.  I have checked the list Id's and I couldn't find the Id that starts with 'F7AFDDF'.

For the workflow status, for some reason, the workflow doesn't show the status when I run it.  In order for me to see the status, I needed to add set workflow status.  I only configured it to say Started at the beginning and Completed at the end.

Thanks again.

Hi Lily,

Sorry it has taken me the weekend to have a think about this, I think it's likely that you can't see the list because it is actually the Workflow History list, which is hidden by default. I think what is happening is that the Execute SQL action is failing (for some reason), but then the error being written to the history list is failing for some reason - this second failure is hiding the actual error.

Would it be possible for you to contact the Support team with the details of this and we can have a look into the underlying error that occurred as well as the history list issue (if I am right about that).

Thanks,

Thank you.  I contacted Nintex support.