I am getting messages similar to the following when submitting a particular form over the web:
ti=“…-…” sq=“00000067” THREAD [0CC8:000C-06E8] WAITING FOR SEM 0
x0475 (@17426740) (OWNER=0CC8:19B4) FOR 30000 ms
ti=“…-…” sq=“00000068” THREAD [0CC8:000D-1EA4] WAITING FOR SEM 0x0
475 (@17426740) (OWNER=0CC8:19B4) FOR 30000 ms
“0CC8” is the nhttpd task … but I haven’t been able to tell what type “0x475” is.
Can anyone assist with this? What more information can I provide?
Thanks,
Subject: Looking for assistance on a “waiting for sem” error (resolved)
So I was able to narrow down where this was coming from. The agent was hanging up on an ExecProcedure call via ODBC to the AS/400. It turns out that the stored procedure being called was referencing a member that did not exist. The expected member was created and all was well.
I still don’t know why the AS/400 didn’t return some sort of graceful error condition via ODBC … or why LotusScript didn’t “time-out” the connection instead of holding the semaphore indefinitely. If anyone can propose suggestions to make this bit of code a bit more robust, I’m all ears.