Error code -20011 returned from fnfnd (1410)

[sridevi.stalin]

Hi,

I'm getting the subject error.
Example:-
PgmA:-
DEFINE TEMP-TABLE ttActionTable NO-UNDO
FIELD ttAction AS CHARACTER.

DEFINE TEMP-TABLE opTable NO-UNDO
FIELD ttAction AS CHARACTER.

&SCOPED-DEFINE sdAction "AAction,BAction,CAction"

RUN PgmB (INPUT TABLE ttActionTable, OUTPUT TABLE opTable). /*ttActionTable.ttAction = CAction*/

PgmB:-

DEFINE TEMP-TABLE ttActionTable NO-UNDO
FIELD ttAction AS CHARACTER.

DEFINE TEMP-TABLE opTable NO-UNDO
FIELD ttAction AS CHARACTER.

&SCOPED-DEFINE sdAction "AAction,BAction,CAction"

INPUT PARAMETER TABLE FOR ttActionTable.

FOR EACH ttActionTable NO-LOCK
WHERE LOOKUP(ttActionTable.ttAction, {&sdAction} ) > 0:
CREATE opTable.
ASSIGN opTable.aFiled = ttActionTable.ttAction.
END.

I don't know from where or why this error out?

 

[GregTomkins]

The INPUT PARAMETER statement is missing the DEFINE.

In this statement:

FOR EACH ttActionTable NO-LOCK
WHERE LOOKUP(ttActionTable.ttAction, {&sdAction} ) > 0:
CREATE opTable.
ASSIGN opTable.aFiled = ttActionTable.ttAction.

... unless I am reading it wrong, opTable does not contain a field called 'aFiled'.

Neither of these sound like they would cause an error 20011, but one has to wonder if this is a real code snippet or not.

 

[sridevi.stalin]

Oh, that I forgot to type there,
that is sample code only. not real.
just want to explain the program flow.
I checked in psdn with error code1410. but the answer is not very much related.
one more thing is that working version is OpenEdge10.1A.

Thanks in Advance,
Sridevi Stalin.

 

[rstanciu]

The code , I guess is like this but no error occurs, the error have to be in another place.
Start you session (OpenEdge v.10.x or v.9.E) with more debug
client session parameters, to find more informations.

-clientlog clientlog.txt
-logginglevel 4
-logentrytypes DB.Connects,FileID,4GLMessages,4GLTrace,QryInfo
-clearlog
-logthreshold 1000000
-numlogfiles 3
-debugalert
-errorstack
-yc
-yx

First execute this command:
SESSION:EXECUTION-LOG = true.
in your Progress session, after that, start your application.
You will find a "proexec.log" file in WRKDIR, may be helps.


PgmA.p ->>

DEFINE TEMP-TABLE ttActionTable NO-UNDO
FIELD ttAction AS CHARACTER.

DEFINE TEMP-TABLE opTable NO-UNDO
FIELD ttAction AS CHARACTER.

&SCOPED-DEFINE sdAction "AAction,BAction,CAction"

RUN PgmB.p (INPUT TABLE ttActionTable, OUTPUT TABLE opTable).
/*ttActionTable.ttAction = CAction*/



PgmB.p -->>

DEFINE TEMP-TABLE ttActionTable NO-UNDO
FIELD ttAction AS CHARACTER.

DEFINE TEMP-TABLE opTable NO-UNDO
FIELD aFiled AS CHARACTER.

&SCOPED-DEFINE sdAction "AAction,BAction,CAction"

DEFINE INPUT PARAMETER TABLE FOR ttActionTable.
DEFINE OUTPUT PARAMETER TABLE FOR opTable.

FOR EACH ttActionTable NO-LOCK
WHERE LOOKUP(ttActionTable.ttAction, {&sdAction} ) > 0:
CREATE opTable.
ASSIGN opTable.aFiled = ttActionTable.ttAction.
END.