Error at Update statement

Faiz · Post by **Faiz** » Thu Mar 20, 2003 5:14 pm

Hi,
I am getting this error, "Invalid argument in the function semunlock", at the update statement in my vortex script. I never noticed it before. What could be the reason?

Post by **John** » Thu Mar 20, 2003 8:42 pm

That usually means that the semaphore has been removed while Texis has it locked. Did this happen just once, or is it reproducible?

Faiz · Post by **Faiz** » Fri Mar 21, 2003 9:49 am

I see it happening everytime there is this update statement on a table from a particular script. There are other updates to the same table from different scripts but, they don't produce this error.

Post by **mark** » Fri Mar 21, 2003 9:54 am

You're not running the problem script with a different version of texis are you? Or texis running as a different user?

Faiz · Post by **Faiz** » Fri Mar 21, 2003 10:06 am

No, its the same version and the same user. Basically, updates and inserts are done from the web by the users. The log file shows, this started yesterday and I never noticed it before. However, the records in the tables are not affected. I checked the table and the data seems alright. Could this be a problem in future?

Post by **John** » Fri Mar 21, 2003 10:46 am

By itself it shouldn't cause problems, but it is possible that it is indicative of something else happening. Can you open a support ticket with details of what the update statement is, and how it might be different from other ones?