Kbase P106463: Error (7221) when passing OUTPUT Temp Table by handle to an ActiveX Open Client
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/08/2010 |
|
Status: Unverified
SYMPTOM(s):
Error (7221) from a ActiveX Open Client when passing OUTPUT Temp Table by handle
com.progress.open4gl.Open4GLError: Static schema construction: Field "" is inserted twice. (7221)
com.progress.open4gl.Open4GLException: com.progress.open4gl.Open4GLError: Static schema construction: Field
com.progress.open4gl.Open4GLException: No fields are available. (7268)
The 4GL procedure returns a populated Temp table
The previous call of the 4GL procedure returned a Temp table where the handle was not set.
The error below can also occur:
com.progress.ubroker.client.BrokerSystem$BrokerSystemCommunicationsException: Client Communications Failure - java.net.SocketException: Socket read failed (8409)
This is not reproducible from a 4GL client.
FACT(s) (Environment):
Progress 9.1E
CAUSE:
Bug# OE00117969
FIX:
Modify the 4GL code in order to always return a valid Temp Table handle.
For example:
DEFINE INPUT PARAMETER ipFill AS INTEGER.
DEFINE OUTPUT PARAMETER TABLE-HANDLE htbl.
DEFINE TEMP-TABLE tbl
FIELD fld1 AS CHAR
FIELD fld2 AS CHAR.
IF ipFill = 1 THEN
DO:
CREATE tbl.
fld1 = "Field1".
fld2 = "Field2".
END.
htbl = TEMP-TABLE tbl:HANDLE.
RETURN.