RE: fglschema error - database connectivity problem

Hello again Florencia,
 
I think I found part of the problem and it has something to do with how I
installed BDS.  Is there a different version of 4j's development runner? and
another version for 4js runtime runner?  
 
We have a one user development license and atleast 50 runtime licenses.
During install, the installer script asks whether you want to install "1 ---
Development environment" or "2 --- Runtime environment".  I installed
runtime first then the development.  Should the development environment AND
runtime environment be installed on the same $FGLDIR?  Does one install
overwrite the other? What is the right way to install devt and runtime?
 
 When I ran "fglWrt -a info users", I only see my Development license.   
 
 
 -----Original Message-----
From: [email protected] [mailto:[email protected]]
Sent: Thursday, March 31, 2005 3:49 PM
To: [email protected]
Subject: RE: [fourjs-users] fglschema error



Hi Nebab,
 
Well, I have exactly the same version of fglrun and esql, with IDS 9.40.UC5,
all running under Red Hat 8.0, and fglschema works fine.
 
The only other thing I can imagine, is that you have the FGLRUN environment
variable set to a different runner. Do you have it set ?
 
If you do, change it to :
 
    export FGLRUN=fglrun
 
Or "unset FGLRUN" to use the default.


But that doesn't explain why the problem is random in your case. So maybe
you'll better wait till tomorrow for someone from FourJs to answer, because
for now, I've run out of ideas.

Florencia
 
 
 -----Mensaje original-----
De: [email protected] [mailto:[email protected]]
Enviado el: Jueves, 31 de Marzo de 2005 16:53
Para: [email protected]
Asunto: RE: [fourjs-users] fglschema error



Hello Florencia,
 
Thanks for the quick reply.
 
$INFORMIXDIR/sqlhosts file is ok. $INFORMIXDIR/etc/$ONCONFIG and NETTYPE,
DBSERVERALIAS parameters looks ok too.
 
Here's my "fglrun -V" output:
 
fglrun 620.201                                           
Built Nov 26 2004 17:44:26                               
(c) 1989-2004 Four J's Development Tools                 
Database interface: INFORMIX-ESQL VERSION 9.xx (Standard)
 
And here's the "esql -V" output:
 
IBM Informix CSDK Version 2.81, IBM Informix-ESQL Version 9.53.UC3
Software Serial Number RDS#N000000                                
 
 

-----Original Message-----
From: [email protected] [mailto:[email protected]]
Sent: Thursday, March 31, 2005 1:21 PM
To: [email protected]
Subject: RE: [fourjs-users] fglschema error


Hi Nebab,
 
I guess you should check your conectivity configuration in Informix :
 
1) $INFORMIXDIR/etc/sqlhosts
 
2) $INFORMIXDIR/etc/$ONCONFIG : NETTYPE, DBSERVERNAME, DBSERVERALIASES, ...
 
Also, chechk your runner is correctly built against your database engine.
What's the output of "fglrun -V" command ? The "Database front end" line
should match your Engine/Client-Sdk version. If you need more details on
this, let me know.
 
Florencia

-----Mensaje original-----
De: [email protected] [mailto:[email protected]]
Enviado el: Jueves, 31 de Marzo de 2005 14:16
Para: [email protected]
Asunto: RE: [fourjs-users] fglschema error


Hello Nuno,
 
There is definitelly a 4J's to informix connection problem!  I can run
dbexport, dbschema, and dbaccess and connect to informix database without
any issues; but "fglschema" fails intermittently.   Here's the other error
message we're getting on a successfully compiled program:
 
SQL statement error number -25588.                             
The appl process cannot connect to the database server prod_shm
SYSTEM error number 22.                                        
 
Is there an 4J utility I can run to check dbase connectivity?  What else can
I check?  Please advise.
 
 
 
 

-----Original Message-----
From: [email protected] [mailto:[email protected]]On
Behalf Of Nuno Godinho
Sent: Wednesday, March 23, 2005 11:46 AM
To: [email protected]
Subject: RE: [fourjs-users] fglschema error


Hi Nebab!
    I would risc to say you could have a connection problem to your
database.
    What about try a dbexport or a dbschema just to see what happens ?
 
    HIH
    Nuno Godinho
 
 
-----Mensagem original-----
De: June Nebab [mailto:[email protected]]
Enviada: quarta-feira, 23 de Março de 2005 16:31
Para: [email protected]
Assunto: [fourjs-users] fglschema error



Hello,
 
I sent an email a few days ago but did not get any response at all about an
fglschema error i'm getting whenever running it.   So here is the problem
again and i'm hoping perhaps someone knows the answer.
 
I'm getting the following error whenever regenerating new database schema
file(s) in my $FGLDBPATH. 
 
"ERROR: "<dbname>" The cursor or statement is not available."
 
Fglschema works only after a few tries sometimes it just works on the first
try.  What could be wrong?
 
 
Regards,
June Nebab