%UNIPLEX
%TO informix-list@rmy.emory.edu
%FROM rridley
%SYSTEM DHLNET
%SUBJECT Tripping Server
%VERIFY y
%DATE 14/12/92 18:03
%REFERENCE 9241
We are experiencing problems with an application developed using
I4GL 4.0, and running on Online version 4.10.UE4 back-end.
The error message returned from either prepared select statements or
normally coded select statements are as follows :
SQL statement error number -211
Cannot read system catalog (systables).
System error number -101.
ISAM error: file is not open.
We have run tbchecks on the databases involved each time the error
appears, but no faults are reported. The problem itself cannot be
purposely duplicated - the engine seems to occasionally trip and send
out the error (it does this about 3 times a day).
The line that is supposedly causing the error is the prepare line
below:
let line3 = "select acc_no,company_name from cmf:accteadd where 1=1
and acct_addr_cat_cd = 'B'"
prepare line1 from line3
declare c4 scroll cursor for line1
Any ideas/help would be much appreciated - this problem does not seem
to occur when people are running 4.0 Online engine, but we are trying
to encourage upgrading to 4.1 Online, so it is important that we
track this one down.
Thanks in advance,
Richard Ridley
%UEND