Page 1 of 1
Error at Update statement
Posted: Thu Mar 20, 2003 5:14 pm
by Faiz
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?
Error at Update statement
Posted: Thu Mar 20, 2003 8:42 pm
by John
That usually means that the semaphore has been removed while Texis has it locked. Did this happen just once, or is it reproducible?
Error at Update statement
Posted: Fri Mar 21, 2003 9:49 am
by Faiz
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.
Error at Update statement
Posted: Fri Mar 21, 2003 9:54 am
by mark
You're not running the problem script with a different version of texis are you? Or texis running as a different user?
Error at Update statement
Posted: Fri Mar 21, 2003 10:06 am
by Faiz
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?
Error at Update statement
Posted: Fri Mar 21, 2003 10:46 am
by John
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?