topic Re: Workflow was Cancelled by Properties Setting in Alteryx Server Discussions

Workflow was Cancelled by Properties Setting

Madhavikishtipati — Fri, 17 Feb 2023 17:51:33 GMT

Hi All,

One of my users is facing the issue in gallery but in designer the workflow is running fine.

Below is the error message from gallery. Would be happy to hear your thoughts, Thank you.

Tool Id 35: Error running DELETE FROM "T_EXPEDITOR": SQL compilation error:
Object 'T_EXPEDITOR' does not exist or not authorized.
00:00:52.456 - Error - Tool Id 35: Workflow was Cancelled by Properties Setting

Regards,

Madhavi.

Re: Workflow was Cancelled by Properties Setting

gabrielvilella — Fri, 17 Feb 2023 19:19:01 GMT

Is the user running the workflow from the Gallery the same as the one from Designer? Are you using that user credential when saving or running the workflow? Is that a Gallery Connection or not? What is the authentication type for this database connection?

Re: Workflow was Cancelled by Properties Setting

Madhavikishtipati — Mon, 20 Feb 2023 07:22:03 GMT

Hi gabrielvilella,

Thank you for replying. Yes the same workflow on both designer and gallery and she is using the same credentials while saving and running. it is a DSN connection which we have created in our servers and user in her system. Authentication is username and password.

Re: Workflow was Cancelled by Properties Setting

gabrielvilella — Mon, 20 Feb 2023 13:14:48 GMT

I feel like if the user was the same, there would not be this error. You can contact the DB admin and check which user is generating that request and if that user has the necessary permissions.

Re: Workflow was Cancelled by Properties Setting

Madhavikishtipati — Wed, 22 Feb 2023 14:47:04 GMT

DSN was created like a generic one with only server name, tracing but now we have created the DSN with all the parameters including, database, warehouse, role, schema in all the DSN's in the servers. we asked user to try, and it worked fine in gallery without error.