Error in a 4GL-report
Posted in 1995
Hello INFORMIX-Gurus,
I've posted this question twice, but got no response. So this is my last
try in hope to an answer.
I've written a report called "r_red". Sometimes this report produces an
error (but it is not reproducable):
Program error at "repvfg.4gl", line number 796.
SQL statement error number -242.
Could not open database table (scheer.t_r_red).
SYSTEM error number -113.
ISAM error: the file is locked.
In line number 796 you can find a "START REPORT r_red". I have never
created a table "scheer.t_r_red", so I think its a temporary table made
by INFORMIX at runtime. But why should this temptable be locked by
another user??? Can anybody explain the mechanism when starting a
report???
In the rootdbs and in the filesystem pointed to by the DBTEMP variable
is enough space (~ 40 MB). So I don't think its a problem with diskspace.
Any hints are welcome. Please help.
Thanks in advance...
Dirch
+----------------------------------------------------------------------------+
| Dirch Scheer email: scheer@stadt-mh.de |
| Amt 10-3 Tel. : +49 208 455 1006 |
| Stadtverwaltung (snail-)Mail : Ruhrstr. 32 |
| Muelheim an der Ruhr D-45468 Muelheim an der Ruhr |
|----------------------------------------------------------------------------|
| Inspiration gave them the motivation to move on out their isolation |
+----------------------------------------------------------------------------+