RE: 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