Focal Point
[SOLVED] (FOC1131) INVALID FIELDNAME

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5107028026

June 01, 2012, 05:34 PM
Deana
[SOLVED] (FOC1131) INVALID FIELDNAME
Hello, I have inherited a WebFOCUS system from another developer. I am trying to move from 7.6.8 to 7.7.03. I am receiving the following error:

(FOC1131) INVALID FIELDNAME . FOR KEYFLD. dcs/dcshousg LN 10
----------v
KEYFLD=./POD/LOCATION, IXFLD=CELL/POD/LOCATION,
(FOC1131) INVALID FIELDNAME . FOR KEYFLD. dcs/dcshousg LN 13

This error is pointing to the .acx file (see below). I don't understand why there are so many lines in the DCSHOUSG04 segment that look the same to me. Thank you in advance. I suspect the error is due to the syntax for referencing the DCSHOUSG03 keys './' specifically, but I am not certain. Any help will be appreciated.


Master file description:
FILENAME=DCSHOUSG, SUFFIX=SQLMSS , $
SEGMENT=DCSHOUSG01, SEGTYPE=S0, $
FIELDNAME=LOCATION, ALIAS=LOCATION, USAGE=A4, ACTUAL=A4, $
FIELDNAME=LOC_CASE_WKR, ALIAS=LOC_CASE_WKR, USAGE=A7, ACTUAL=A7, $
FIELDNAME=LAST_UPDT_DT01, ALIAS=LAST_UPDT_DT01, USAGE=HMDYYs, ACTUAL=HYYMDs, $
FIELDNAME=LAST_UPDT_ID01, ALIAS=LAST_UPDT_ID01, USAGE=A7, ACTUAL=A7, $

SEGMENT=DCSHOUSG02, SEGTYPE=S0, PARENT=DCSHOUSG01, $
FIELDNAME=LOCATION, ALIAS=LOCATION, USAGE=A4, ACTUAL=A4, $
FIELDNAME=ENDING_NO, ALIAS=ENDING_NO, USAGE=A1, ACTUAL=A1, $
FIELDNAME=ASN_CASE_WKR, ALIAS=ASN_CASE_WKR, USAGE=A7, ACTUAL=A7, $
FIELDNAME=LAST_UPDT_DT02, ALIAS=LAST_UPDT_DT02, USAGE=HMDYYs, ACTUAL=HYYMDs, $
FIELDNAME=LAST_UPDT_ID02, ALIAS=LAST_UPDT_ID02, USAGE=A7, ACTUAL=A7, $

SEGMENT=DCSHOUSG03, SEGTYPE=S0, PARENT=DCSHOUSG02, $
FIELDNAME=LOCATION, ALIAS=LOCATION, USAGE=A4, ACTUAL=A4, $
FIELDNAME=POD, ALIAS=POD, USAGE=A1, ACTUAL=A1, $
FIELDNAME=POD_CASE_WKR, ALIAS=POD_CASE_WKR, USAGE=A7, ACTUAL=A7, $
FIELDNAME=LAST_UPDT_DT03, ALIAS=LAST_UPDT_DT03, USAGE=HMDYYs, ACTUAL=HYYMDs, $
FIELDNAME=LAST_UPDT_ID03, ALIAS=LAST_UPDT_ID03, USAGE=A7, ACTUAL=A7, $

SEGMENT=DCSHOUSG04, SEGTYPE=S0, PARENT=DCSHOUSG03, $
FIELDNAME=LOCATION, ALIAS=LOCATION, USAGE=A4, ACTUAL=A4, $
FIELDNAME=POD, ALIAS=POD, USAGE=A1, ACTUAL=A1, $
FIELDNAME=CELL, ALIAS=CELL, USAGE=A3, ACTUAL=A3, $
FIELDNAME=BED, ALIAS=BED, USAGE=A1, ACTUAL=A1, $
FIELDNAME=INMATE_NO, ALIAS=INMATE_NO, USAGE=I5, ACTUAL=I4, $
FIELDNAME=CELL_DATE, ALIAS=CELL_DATE, USAGE=MDYY, ACTUAL=DATE, $
FIELDNAME=CEL_CASE_WKR, ALIAS=CEL_CASE_WKR, USAGE=A7, ACTUAL=A7, $
FIELDNAME=LAST_UPDT_DT04, ALIAS=LAST_UPDT_DT04, USAGE=HMDYYs, ACTUAL=HYYMDs, $
FIELDNAME=LAST_UPDT_ID04, ALIAS=LAST_UPDT_ID04, USAGE=A7, ACTUAL=A7, $

SEGMENT=DCSHOUSG05, SEGTYPE=S0, PARENT=DCSHOUSG04, $
FIELDNAME=LOCATION, ALIAS=LOCATION, USAGE=A4, ACTUAL=A4, $
FIELDNAME=H2_INMATE_NO, ALIAS=H2_INMATE_NO, USAGE=I5, ACTUAL=I4, $
FIELDNAME=H2_CELL_DATE, ALIAS=H2_CELL_DATE, USAGE=MDYY, ACTUAL=DATE, $
FIELDNAME=H2_CUSTODY, ALIAS=H2_CUSTODY, USAGE=A3, ACTUAL=A3, $
FIELDNAME=H2_CASE_WKR, ALIAS=H2_CASE_WKR, USAGE=A7, ACTUAL=A7, $
FIELDNAME=H2_POD, ALIAS=H2_POD, USAGE=A1, ACTUAL=A1, $
FIELDNAME=H2_CELL, ALIAS=H2_CELL, USAGE=A3, ACTUAL=A3, $
FIELDNAME=H2_BED, ALIAS=H2_BED, USAGE=A1, ACTUAL=A1, $
FIELDNAME=LAST_UPDT_DT05, ALIAS=LAST_UPDT_DT05, USAGE=HMDYYs, ACTUAL=HYYMDs, $
FIELDNAME=LAST_UPDT_ID05, ALIAS=LAST_UPDT_ID05, USAGE=A7, ACTUAL=A7, $


Access File:
SEGNAME=DCSHOUSG01, TABLENAME=WCIS.dbo.DCSHOUSG01, CONNECTION=WCIS,
GUI_PARAMS='0,100,24,148,72,278,160', KEYS=1, $
SEGNAME=DCSHOUSG02, TABLENAME=WCIS.dbo.DCSHOUSG02, CONNECTION=WCIS,
KEYFLD=LOCATION, IXFLD=LOCATION, GUI_PARAMS='0,100,154,148,202,278,160',
KEYS=2, $
SEGNAME=DCSHOUSG03, TABLENAME=WCIS.dbo.DCSHOUSG03, CONNECTION=WCIS,
KEYFLD=LOCATION, IXFLD=LOCATION, GUI_PARAMS='0,200,154,248,202,278,160',
KEYS=2, $
SEGNAME=DCSHOUSG04, TABLENAME=WCIS.dbo.DCSHOUSG04, CONNECTION=WCIS,
KEYFLD=./POD/LOCATION, IXFLD=CELL/POD/LOCATION,
GUI_PARAMS='0,100,414,148,462,278,160', KEYS=4, $
SEGNAME=DCSHOUSG04, TABLENAME=WCIS.dbo.DCSHOUSG04, CONNECTION=WCIS,
KEYFLD=./POD/LOCATION, IXFLD=CELL/POD/LOCATION, $
SEGNAME=DCSHOUSG04, TABLENAME=WCIS.dbo.DCSHOUSG04, CONNECTION=WCIS,
KEYFLD=./POD/LOCATION, IXFLD=CELL/POD/LOCATION, $
SEGNAME=DCSHOUSG04, TABLENAME=WCIS.dbo.DCSHOUSG04, CONNECTION=WCIS,
KEYFLD=./POD/LOCATION, IXFLD=CELL/POD/LOCATION, $
SEGNAME=DCSHOUSG04, TABLENAME=WCIS.dbo.DCSHOUSG04, CONNECTION=WCIS,
KEYFLD=./POD/LOCATION, IXFLD=CELL/POD/LOCATION, $
SEGNAME=DCSHOUSG04, TABLENAME=WCIS.dbo.DCSHOUSG04, CONNECTION=WCIS,
KEYFLD=./POD/LOCATION, IXFLD=CELL/POD/LOCATION, $
SEGNAME=DCSHOUSG04, TABLENAME=WCIS.dbo.DCSHOUSG04, CONNECTION=WCIS,
KEYFLD=./POD/LOCATION, IXFLD=CELL/POD/LOCATION, $
SEGNAME=DCSHOUSG04, TABLENAME=WCIS.dbo.DCSHOUSG04, CONNECTION=WCIS,
KEYFLD=./POD/LOCATION, IXFLD=CELL/POD/LOCATION, $
SEGNAME=DCSHOUSG04, TABLENAME=WCIS.dbo.DCSHOUSG04, CONNECTION=WCIS,
KEYFLD=./POD/LOCATION, IXFLD=CELL/POD/LOCATION, $
SEGNAME=DCSHOUSG04, TABLENAME=WCIS.dbo.DCSHOUSG04, CONNECTION=WCIS,
KEYFLD=./POD/LOCATION, IXFLD=CELL/POD/LOCATION, $
SEGNAME=DCSHOUSG04, TABLENAME=WCIS.dbo.DCSHOUSG04, CONNECTION=WCIS,
KEYFLD=./POD/LOCATION, IXFLD=CELL/POD/LOCATION, $
SEGNAME=DCSHOUSG04, TABLENAME=WCIS.dbo.DCSHOUSG04, CONNECTION=WCIS,
KEYFLD=./POD/LOCATION, IXFLD=CELL/POD/LOCATION, $
SEGNAME=DCSHOUSG04, TABLENAME=WCIS.dbo.DCSHOUSG04, CONNECTION=WCIS,
KEYFLD=./POD/LOCATION, IXFLD=CELL/POD/LOCATION, $
SEGNAME=DCSHOUSG04, TABLENAME=WCIS.dbo.DCSHOUSG04, CONNECTION=WCIS,
KEYFLD=./POD/LOCATION, IXFLD=CELL/POD/LOCATION, $
SEGNAME=DCSHOUSG04, TABLENAME=WCIS.dbo.DCSHOUSG04, CONNECTION=WCIS,
KEYFLD=./POD/LOCATION, IXFLD=CELL/POD/LOCATION, $
SEGNAME=DCSHOUSG04, TABLENAME=WCIS.dbo.DCSHOUSG04, CONNECTION=WCIS,
KEYFLD=./POD/LOCATION, IXFLD=CELL/POD/LOCATION, $
SEGNAME=DCSHOUSG04, TABLENAME=WCIS.dbo.DCSHOUSG04, CONNECTION=WCIS,
KEYFLD=./POD/LOCATION, IXFLD=CELL/POD/LOCATION, $
SEGNAME=DCSHOUSG04, TABLENAME=WCIS.dbo.DCSHOUSG04, CONNECTION=WCIS,
KEYFLD=./POD/LOCATION, IXFLD=CELL/POD/LOCATION, $
SEGNAME=DCSHOUSG04, TABLENAME=WCIS.dbo.DCSHOUSG04, CONNECTION=WCIS,
KEYFLD=./POD/LOCATION, IXFLD=CELL/POD/LOCATION, $
SEGNAME=DCSHOUSG05, TABLENAME=WCIS.dbo.DCSHOUSG05, CONNECTION=WCIS,
KEYFLD=LOCATION, IXFLD=LOCATION, GUI_PARAMS='0,300,154,348,202,278,160',
KEYS=2, $

This message has been edited. Last edited by: Deana,


WebFOCUS 7.6.8 and 7.7.03; Windows Server 2003 R2 and Windows Server 2008 R2, respectively; Development environments - Windows Server 2003 R2 and Windows 7 Professional, respectively;
excel, html, pdf
June 02, 2012, 02:37 PM
Danny-SRL
Hi Deana,

Welcome to the forum.
quote:
I am receiving the following error:

(FOC1131) INVALID FIELDNAME . FOR KEYFLD. dcs/dcshousg LN 10
----------v
KEYFLD=./POD/LOCATION, IXFLD=CELL/POD/LOCATION,
(FOC1131) INVALID FIELDNAME . FOR KEYFLD. dcs/dcshousg LN 13

There is no reason for all those lines. I would take them all out except for the first occurrence.
As for the error, I would write:
  
KEYFLD=POD/LOCATION, IXFLD=POD/LOCATION



Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

June 07, 2012, 12:02 PM
Deana
Daniel,
Thank you for your help.

Using the synonym refresh option, which I found this morning, I was able to tweak your suggestion and get this error fixed.

The synonym refresh created different syntax FOREIGN_KEY_COLUMN=LOCATION/POD and PRIMARY_KEY_COLUMN=LOCATION/POD. When I tried using the refreshed synonym, I received an error indicating the KEYFLD and IXFLD were missing. I the original code from KEYFLD=./POD/LOCATION, IXFLD=CELL/POD/LOCATION to KEYFLD=LOCATION/POD, IXFLD=LOCATION/POD.

The only difference from your post was the order of the fields.


WebFOCUS 7.6.8 and 7.7.03; Windows Server 2003 R2 and Windows Server 2008 R2, respectively; Development environments - Windows Server 2003 R2 and Windows 7 Professional, respectively;
excel, html, pdf