I am running the code below and getting the following errors. This same code works in other environments, but not production. I've tried copying the data flow and synonyms from an environment that works to PROD, but am still facing the error. If anyone reading this has any general ideas on how to further troubleshoot this, I'd appreciate it.

Dan

07/18/2014 09:09:26 PROD 0 ERROR AT OR NEAR LINE 17 IN PROCEDURE __WCFEX FOCEXEC *
07/18/2014 09:09:26 PROD (FOC003) THE FIELDNAME IS NOT RECOGNIZED: MAX.ENCTER_DUR_DAILY_SNAP_KEY/I11
07/18/2014 09:09:26 PROD BYPASSING TO END OF COMMAND
07/18/2014 09:09:26 PROD (FOC009) INCOMPLETE REQUEST STATEMENT
07/18/2014 09:09:26 PROD FAILURE ENCOUNTERED WHEN TRYING TO RESOLVE HIGH FACT KEY VALUE


SET MSG=OFF
-SET &&PRIORHIGHKEY = 0;
SET HOLDLIST=PRINTONLY
TABLE FILE ENCTER_DUR_DAILY_SNAP_F
SUM
MAX.ENCTER_DUR_DAILY_SNAP_KEY/I11
ON TABLE HOLD AS KEYHOLDER FORMAT ALPHA
END

-RUN
-IF (&FOCERRNUM NE 0) GOTO :FAILUREEND;
-IF (&LINES EQ 0) GOTO :NOROWS;
-READ KEYHOLDER &&PRIORHIGHKEY.A11B.
-GOTO :SUCCESSEND

-:NOROWS
SET MSG=ON

-TYPE LAST MAX KEY VALUE IS ZERO because the fact table is empty!
-GOTO :SUCCESSEND


-:FAILUREEND
-TYPE FAILURE ENCOUNTERED WHEN TRYING TO RESOLVE HIGH FACT KEY VALUE
-END
-QUIT


-:SUCCESSEND
-TYPE Before execution, the highest key value was found to be: &&PRIORHIGHKEY

This message has been edited. Last edited by: Dan DeFuso,

Hello Dan,

The error message means that ENCTER_DUR_DAILY_SNAP_KEY is not found in the master file.

Possibly there is another master file, with the same name, higher in your path, that doesn't have that field.

can you run a simple program like...

WHENCE FILE ENCTER_DUR_DAILY_SNAP_F MASTER

The response will tell you where the master was found, then you can evaluate if that master that has that fieldname in it.

Thank you, JNC.

I had also received that advice from support and was able to determine that the ENCTER_DUR_DAILY_SNAP_KEY was indeed in a different master file.

I was able to correct that and the flow runs as expected.

Thank you!

Dan