Consultor Eletrônico

Status: Unverified

SYMPTOM(s):

Error 13766 when Windows DB connects to and runs query on AIX DB

CONNECTED() method fails to recognise connection to AppServer

FACT(s) (Environment):

The "client" program under windows has a TIMER, set to 15 seconds (OCX PSTIMER). The executed code is as follows:
IF VALID-HANDLE ( appsrv )
THEN ASSIGN w_appsrv_connected = appsrv:CONNECTED (). IF NOT VALID-HANDLE (htransfert)
THEN ASSIGN w_appsrv_connected = FALSE. IF NOT w_appsrv_connected
THEN DO:
DELETE OBJECT htransfert NO-ERROR.
DELETE OBJECT appsrv NO-ERROR. RUN ConnexionAppServer ( INPUT "LPF":U,
INPUT "LPF":U ,
INPUT "interfac":U,
INPUT "DEFAUT":U,
INPUT "CONNEXION":U,
OUTPUT appsrv,
OUTPUT code_retour).
IF code_retour <> "":U
THEN DO :
/* Error */ RETURN. /* return to main */
END.
ELSE DO : RUN lminit.p( INPUT '':U ,
INPUT wini_process,
INPUT "":U,
OUTPUT code_retour).
IF code_retour <> '':U
THEN DO :
/* Error */ RETURN. /* return to main */
END.
END.
END. The procedure ConnexionAppServer will connect (stateless) the AppAerver handle to the AppServer broker.
The file lminit.p calls a procedure on the AppServer to query the DB.
If the TIMER is executed while the UNIX broker and the AppServer sessions are restarting, we can reconnect to the AppServer. The file lminit.p is then successfully executed but the OK message does not appear. The client session stays waiting for the end of the execution of the file lmtrans.p
If the source code is executed after the UNIX AppServer has finished restarting, then the OK message appears.
Windows
OpenEdge 10.x

CHANGE:

Windows environment was migrated from 9.1D08 to 10.1C01

CAUSE:

When migrating from Progress 9.x to OpenEdge 10.x , the JVM 1.4.2 is replaced with JVM 1.5 . As a result, additional parameters are required in the ubroker.properties file in order to successfully connect to and run the required procedure

FIX:

In the [Adapter] section of the ubroker.properties file, add the following paramters: jvmArgs=-Xms64m