topic Re: The semaphore timeout period has expired. (121) in Alteryx Server Discussions

The semaphore timeout period has expired. (121)

Brian_Stoffel — Tue, 12 Jan 2021 14:44:17 GMT

We have a workflow that pulls data from our database, does some work, and then writes to another database/text files. This workflow is scheduled on Alteryx Gallery to run daily at 1am.

The text files are small with 5-15 rows of data. The files are duplicative, meaning the file written to folder 1 is the same as the file written to folder 2.

We received the following error with writing one of the text files but everything else ran as expected in the workflow.

"The semaphore timeout period has expired. (121)"

Does anyone have any troubleshooting tips? There are some similar responses to check the network connections, but I don't think that applies for workflows scheduled on Alteryx Gallery.

Re: The semaphore timeout period has expired. (121)

madler_alteryx — Wed, 27 Jan 2021 10:02:47 GMT

Hi @Brian_Stoffel,

Thanks for writing on Community.

Does the same issue occur when running the workflow on Designer on the Server?

Does it run fine from a client Designer?

As the workflow connects to a Database Server this could well be network related or other database connection issue.

The DBA might be able to help, but this could be also something to look into together with Support.

Thanks,

Michael

Re: The semaphore timeout period has expired. (121)

Brian_Stoffel — Mon, 01 Feb 2021 18:55:19 GMT

Does the same issue occur when running the workflow on Designer on the Server?

- No.

Does it run fine from a client Designer?

- Yes.

This issue hasn't repeated in the last few weeks, so I'll considered the issue closed for now.

In doing a bit of research, it seems that this error is a generic network error. I was thinking that Alteryx had an error lookup table. For example, for error 121 (Semaphore timeout), then check x, y, or z type connections.