Tripping Server III
Posted in 1992
%UNIPLEX
%TO informix-list@rmy.emory.edu
%FROM rridley
%SYSTEM DHLNET
%SUBJECT Tripping Server III
%VERIFY y
%DATE 28/12/92 10:34
%REFERENCE 10020
Alan Denney writes :
>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.
>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
>>Is the cmf database on the same server as your primary database?
>>Is it intact and OK?
Yes, all databases are on the same server
>>Are you mixing 4.0 and 4.1 engine processes or server processes in
>>the same environment?
NO, what we have since discovered is the following :
Online 4.10.UE4 No Informix-Star : Works OK
Online 4.10.UE4 Informix-Star 4.10.UE4 : Gives the error
Online 4.10.UE4 Informix-Star 4.10.UE5 : Works OK
Online 5.00.UC2 No Informix-Star : Works OK
Online 5.00.UC2 Informix-Star 5.00.UC2 : Works OK
It would appear from this that the problem causer is I-Star
4.10.UE4 (This is on an HP-UX 8.02 (9000/827) machine).
Has any related or similar bug been reported on I-Star 4.10.UE4 ?
Cheers,
Richard Ridley
%UEND