Re: "This record is being updated by another job"

Chris. In our over night process when all the subsystems are down and
users have signed off we clear the lock files.

I have seen it happen where in some programs a chain is made to a record
for updating (locking it).  Before the record is released, a call to a
second program from the first program, tries to chain and update the
same record.   
This causes the message "This record is being updated by another job" to
appear and the job to crash.

We are not using FIFO Costing, so I am not sure if this could be your
problem.

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx] On Behalf Of Chris Tringham
Sent: Wednesday, July 05, 2006 9:43 PM
To: system21@xxxxxxxxxxxx
Subject: [SYSTEM21] "This record is being updated by another job"

THIS MESSAGE HAS BEEN SCANNED BY SYMANTEC ANTIVIRUS.
We are having a problem with FIFO Cost Adjustment dumping.  After this
happens, the item gets 'locked' the unhelpful message above is
displayed,
and we cannot do further maintenance.  I hunted through all the obvious
places (APP99, INP99...) but couldn't find any locks there.  It turns
out
that the program locks the record by setting STAT60 on INP60 to 'A'.

So I asked Infor (through Answerlink) if this was documented anywhere,
whether it was safe to set that flag to blanks in the day-end, and
whether
the equivalent field STAT35 on INP35 is used in the same way.

The response I got was "We do not document in detail how programmes work
or
what they do with files".  Well that explains a lot!!

Since Geac/Infor don't know, I wonder if anyone else does.  Or whether
there are similar "non-standard" locks.  I know about PMP02 & OEP40, but
maybe there are others.  We are using Style Aurora v1.2, but I don't
think
this stuff has changed in the last 10 years.

Best Regards
Chris

_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.