This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I created an app which take input from SQL server through Connect In-DB tool. The connecion name is "ABcProd". The app is running fine on my local machine but when I try to upload it in gallery and gallery is in differenct server, So I get an error of :- The job Report did not complete successfully and resulted in the following errors:
Unable to find connection "abcprod" (Tool Id: 468)
Can anyone help me on that. My technical team created the same connection name in System DSN in server, but still I get the same error.
The first thing that comes to mind is that your IT may have created a connection within the ODBC manager and named the DSN "abcprod". If that's the case, that won't completely satisfy the need of scheduling the workflow.
They will need to create a System In-DB connection (same name as how you have it on yours) within Alteryx Designer on the server. The rest of the options, they can configure in whatever way needed for it to work in the Server, but those 2 items highlighted below are a MUST.
Thank you for accepting my response as your solution.
In regards to your new problem, the reason why it's not working is because, unlike on your own computer, the Alteryx Server does not have the directory "F:\Analytics_box_sync\Box Sync\APP Outputs\" or even an "F" drive for that matter.
One option is that you can enable network file sharing of that directory (you may need your desktop support to assist) and give read/write access to the Alteryx Server. Additionally you will need to use the fully qualified UNC path (e.g. "\\computer\folder\subfolder\file") to that directory instead of the mapped drive location. The server has no idea what "F" refers to, but by supplying it with a network path, it can attempt to output to that network location.
Once the file is outputted, then the Box Sync app that's on your computer should send it up to Box.
Second option, but a more complex one, is to develop an Alteryx macro that will output a file to Box directly utilizing their API service using our Download tool to send the API requests.
Those error messages are common when the server does not have those same directories in it's environment. It's important to note that a workflow that runs fine on your local machine may not be properly configured to run on another environment, i.e. Server.
If I may recommend, please contact our Customer Support Team so that they may review your workflow and the errors you're receiving and, hopefully, pinpoint the issue and suggest how to correct.
My In-DB Connection does not have type "System". I have googled and do not understand why. I am a designer and save to my company's gallery. is the problem because my system settings are set to designer and not worker/controller?