Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [SOLVED] Data Migrator Error FOC003 and FOC009
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Data Migrator Error FOC003 and FOC009
 Login/Join
 
Member
posted
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,


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 2 | Registered: March 20, 2014Reply With QuoteReport This Post
Silver Member
posted Hide Post
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.


WebFocus 7x, 8x, Win / Linux, any output format
 
Posts: 44 | Location: reading, pa | Registered: April 07, 2007Reply With QuoteReport This Post
Member
posted Hide Post
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


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 2 | Registered: March 20, 2014Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [SOLVED] Data Migrator Error FOC003 and FOC009

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.