cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Workflow Error when connecting with a database

Jump to solution

Hello,

 

I am trying to connect to our database from a Nintex 365 form, however, I am getting an error.(workflow-error.png)

 

My workflow looks like the following.(workflow.png)

 

Build String:

INSERT INTO XX.dbo.My_Table

     (ID

      ,Status

      ,Year

      ,Region

      ,Market

     ,Created

      ,Created_By

      )

 

Values

('‍{Current Item:Region}‍_‍{Current Item:Market}‍',

'Active',

'‍{Current Item:Year}‍','

‍{Current Item:Region}‍','

‍{Current Item:Market}‍','

‍{Current Item:Created}‍','

‍{Current Item:Created By}‍');

 

 

Connection string:   Server=11.11.111.1,1433;Database=XX;User Id=xxnintex_user;Password=xxxxxxx;

 

Thank you so much for your help.  Please let me know if you any more questions.

Labels: (1)
Tags (1)
0 Kudos
Reply
6 Replies
Workflow Hero

Re: Workflow Error when connecting with a database

Jump to solution

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.

0 Kudos
Reply
Workflow Hero

Re: Workflow Error when connecting with a database

Jump to solution

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

0 Kudos
Reply
Workflow Hero

Re: Workflow Error when connecting with a database

Jump to solution

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.

0 Kudos
Reply
Workflow Hero

Re: Workflow Error when connecting with a database

Jump to solution

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,

0 Kudos
Reply
Workflow Hero

Re: Workflow Error when connecting with a database

Jump to solution

Thank you.  I contacted Nintex support.

0 Kudos
Reply
Workflow Hero

Re: Workflow Error when connecting with a database

Jump to solution

Nintex support explained to me that Nintex 365 can connect to the DB if the server is internet accessible.  Unfortunately,  our server is VPN accessible, not internet accessible.

0 Kudos
Reply