Cannot get workflow to run after migrating it from our Dev to Prod server

[craigja]

Hi,

Hoping for some pointers here.... I have a workflow that (if the ready for migration flag is set) will copy a workflow from our Dev server to Production.  This is working at the moment, but the issue is when I try to run a workflow thats been migrated I get this error:

the workflow uses owner specified credentials but those credentials have been deleted please contact the owner of this workflow or your gallery administrator

The way to resolve it, is to open on designer and resave it - which wont work in practice, as the idea is we lock our designers out of production - also, Im sure I tested my sample workflow before and it worked ok, so Im not sure what has changed.  I've looked and checked and the OwnerID Im setting as part of the migration process is my owner ID in the Production server.  I have no idea why this wont work, any pointers?

[fmvizcaino]

Hi @craigja ,

Is the user adding the credential manually when publishing the workflow?

When migrating a workflow with credentials, you are required to provide a credentialID. The problem with manually added credentials is that you don`t have a credentialID attached to that, so as far as I checked, there is no way of moving this type of credentials along with the workflow. I have never had this use case before, so I would suggest validating it with Alteryx Support.

Here you can see the blank credentialID part when you manually add the credential. 

Best,

Fernando Vizcaino

[craigja]

I know what the credential should be as its just a test workflow created by me - I queried the API for the credential ID and tried to pass that in to the POST Workflows endpoint - it failed with Response Code 400, Bad Request

I then tried resaving the workflow to our Dev server, with the 'User is not required to provide credentials' option - What credentials is it talking about then?

[craigja]

OK - got it working, Ive changed my profile workflow defaults (not sure if I needed to do this step) to Shared Credentials and selected my Service Account.  On designer, I saved the workflow again, this time selecting Always run this workflow with these credentials and set it to the service account.  

Questions...

Is there a way to find out what the 'Always runs this workflow with these credentials' is, when querying the API - I think that was what you were saying Fernando, that as far as you can see, you cant find these out

Did I need to change my profile at all?

[fmvizcaino]

Hi @craigja ,

If it is a shared credential, then yes, the example I sent before was only for credentials added manually (not shared credentials). If it is a shared credential, it will return the ID.

Then, you will get the credentialID from your DEV environment and have to change it to the credentialID from your Prod environment and publish the workflow.

Best,

Fernando Vizcaino

[craigja]

I think its a bug, if I hard code the values in, the same values from the fields I am using, it works without error, so seems to be when using fields rather than hard coding that the error surfaces.  Ive opened a support call...