RE: fglschema error - database connectivity problem

Hi,

In general, you will choose option "1 --- Development environment" when you want to install the development licence for your dev environment, and you'll choose "2 ---- Runtime environment" when you want to install your runtime licence for the env where the end users connect to the system to run their Four J's applications.

You can not install both runtime and development licences on the same environment (same $FGLDIR) and have them both working.

The output of "fglWrt -a see" will exactly tell you what licence you have installed and how many users for.

If you want to have both runtime and dev licences installed on the same machine that is perfectly fine, but you have to install them on two different $FGLDIR locations.

Basically the minimum required difference between your dev and runtime environments will be the $FGLDIR path (and of course the licences).

Omid 

 
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of June Nebab
Sent: Friday, 1 April 2005 9:12 AM
To: [email protected]
Subject: RE: [fourjs-users] 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 deveelopment 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