Skip to main content
Nintex Community Menu Bar

Execute SQL Error with System Account

  • December 17, 2018
  • 2 replies
  • 83 views

Forum|alt.badge.img

I have a workflow that includes a Execute SQL action. If I run this workflow manually or start it from another workflow the workflow runs without issue. It will also run without issue if I manually start a site workflow that includes a web service call to start the workflow on a list item.

If this same workflow is changed to start conditionally or I the schedule the site workflow (instead of manually starting) the workflow errors with the following:

Error performing database operation. System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

The only difference would be the account that initiated the workflow, mine vs "system account". Right? In both cases I have the entire workflow in an action set and the option to run as workflow owner selected.

If the logs we are seeing Access is denied errors at the time the workflow is trigger.

Any input as to what would be causing the error? What would I have access to that a the SharePoint system account does not?

2 replies

Forum|alt.badge.img

Hi All,

 

Was there anyone able to find a solution for this one?


Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • July 1, 2019

Hi,

 

Nintex Workflow makes use of the standard ADO.NET OracleConnection and OracleCommand objects under the .NET Framework Data Provider for Oracle.

This requires version 8.1.7 to be installed. You can read more about the requirement here:

http://msdn.microsoft.com/en-us/library/a6cd7c08(v=vs.110).aspx