Hi everyone,
has anyone encountered this error: Internal Error: Invalid parameter detected in function (null). File: (null) Line: 0 Expression: (null)
The workflow is running fine in Alteryx but when it is uploaded to the gallery, it produces that error.
I appreciate the response. Thank you
Solved! Go to Solution.
@digitalmemo Where is the source file which the workflow uses located?
Source file is in our network storage. From there I upload it to our gallery then when I am doing a test run from the gallery then that is the error i encounter.
Does the service account running the Gallery have access to that share?
If you don't know, check with whomever set up your server.
I was getting that same error and it was a really weird/wild ride trying to debug. Let me run you through what we saw and you can let me know if its a similar thing.
What we found, is that our connection string was over 210 characters long, which I guess created a perfect storm for the gallery. It has something to do with when you are publishing and not removing the workflows dependency on the connection as your local machine uses it. I think what happens is that it tries to bring over that connection but the length makes it fail. Once we removed these dependencies we stopped seeing this error. It could also be fixed by trimming up your connection string. Let me know if this is similar to yours and if it is, I am going to give you a ticket to refer to and put in a support request. This specific error has been known since Feb I think but there just isn't enough outcry to prioritize it right now.
Hi @Treyson,
I'm also having this issue - it fits with the 5 bullet points described - so happy to log a support request.
That being said, I'm not sure I understand what you've done to fix the problem.
I have set a data connection up on the gallery and this is the connection I am using in my workflow's dynamic input tool. Shouldn't it just pass the connection alias/name (the aka: My_Connection_Name in the input tool) to the gallery?
I don't understand how I can remove a dependency on a dynamic input tool? if you could let me know what you did to achieve this that would be great, thanks.
Thanks @Treyson , in the end actually managed to switch over to an odbc connection which stopped the error from happening.
I wasn't able to use manage workflow assets as my data connection didn't even appear there for some reason.