Consultor Eletrônico



Kbase P128843: Error 1414 and AppServer Agent crash when disconnecting Oracle DataServer connection
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   07/02/2008
Status: Unverified

FACT(s) (Environment):

OpenEdge 10.1B
Oracle DataServer
Windows

SYMPTOM(s):

Windows Error Handler reports crash of AppServer Agent (_proapsv.exe) for each disconnect

Use of application is not hindered

<AppServer>.server.log ends with error 1414

SYSTEM ERROR: gettbl(fd.c) called with bad fdhandle=<index>. (1414)

SYSTEM ERROR: gettbl(fd.c) called with bad fdhandle=2. (1414)

[YY/MM/DD@HH:MM:SS.###+0000] P-##### T-###### 2 AS AS Application Server disconnected. (8360)
[YY/MM/DD@HH:MM:SS.###+0000] P-##### T-###### 2 AS CONN Disconnecting from database <DB>, single user. (9544)
[YY/MM/DD@HH:MM:SS.###+0000] P-##### T-###### 1 AS -- SYSTEM ERROR: gettbl(fd.c) called with bad fdhandle=2. (1414)

AppServer Agent is connecting to Oracle DataServer

Dataserv.lg shows that connection to Oracle terminated correctly and without errors

DataServer Schema Holder is programmatically disconnected before the connection to Oracle

CAUSE:

The exact cause is unknown at the time of this writing; the error message suggests that the Agent is not aware of the disconnection of the Oracle datasource (the connection is lost once the schema holder is disconnected) and attempts to check it.

FIX:

Ensure that the connection to the Oracle datasource is disconnected before the connection to the schema holder