I can not locate any information on this error message I am receiving, I checked the Desktop Errors Messages reference, did a search on Google and this forum with no luck. I am hoping that someone can shed some light on the issue.

LENGTH OF FIELDS ON FOCUS DATA PATH EXCEEDS 32K BYTES

The closest error meesage was FOC397, which is an error on the segment, this is a Data Path and I not sure what WebFocus is refering to.

Please help point me in theright direction so I can resolve. Thanks!

AM there are limits in the size of segments in a FOCUS file, can you post your master files ?

APP HOLD sol8hld
ENGINE SQLORA SET DEFAULT_CONNECTION oracle_ops
TABLE FILE SQLOUT
PRINT
HOST
OCM_DETAIL/A50V
BU_MIDLEVEL_DETAIL/A50V
BU_DETAIL/A50V
BU_DEPARTMENT/A50V
COST_CENTER_FROM_AC/I8
COSTCENTER_DESC/A50V
SERVER_MAX_APP_CRITICALITY
FSC_SUPPORTED
SERVERROLE/A20V
OS_DETAIL/A12V
HW_EOL_STAGE/I3
SERVER_MODEL/A40V
LOCATION_CITY/A35V
LOCATION_BUILDING/A40V
SERVER_TYPE
DECOM_PPM_ID/I11
PPM_CLOSE_DATE
PPM_PLANNED_DECOM_DATE/A20V
PPM_STATUS/A70V
APP_ID/A20V
APP_NAME/A75V
APPSTATUS
APPLICATIONS_PERCENT/D5.2
APP_CONTACTS
CRITICALITY_CODE
SECURITY_TIER
MAINT_DIV/A50V
MAINT_BU/A50V
USING_BU/A50V
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD AS HLD_SOL8SERVERAPP FORMAT FOCUS
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
TYPE=REPORT,
COLUMN=N1,
WRAP=1.000000,
$
TYPE=REPORT,
COLUMN=N6,
WRAP=1.000000,
$
TYPE=REPORT,
COLUMN=N8,
WRAP=1.000000,
$
TYPE=REPORT,
COLUMN=N9,
WRAP=1.000000,
$
TYPE=REPORT,
COLUMN=N10,
WRAP=1.000000,
$
TYPE=REPORT,
COLUMN=N12,
WRAP=1.000000,
$
TYPE=REPORT,
COLUMN=N14,
WRAP=1.000000,
$
TYPE=REPORT,
COLUMN=N15,
WRAP=1.000000,
$
TYPE=REPORT,
COLUMN=N16,
WRAP=1.000000,
$
TYPE=REPORT,
COLUMN=N17,
WRAP=1.000000,
$
TYPE=REPORT,
COLUMN=N18,
WRAP=1.000000,
$
TYPE=REPORT,
COLUMN=N21,
WRAP=1.000000,
$
TYPE=REPORT,
COLUMN=N23,
WRAP=1.000000,
$
TYPE=REPORT,
COLUMN=N24,
WRAP=1.000000,
$
TYPE=REPORT,
COLUMN=N25,
WRAP=1.000000,
$
TYPE=REPORT,
COLUMN=N26,
WRAP=1.000000,
$
TYPE=REPORT,
COLUMN=N27,
WRAP=1.000000,
$
TYPE=REPORT,
COLUMN=N30,
WRAP=1.000000,
$
TYPE=REPORT,
COLUMN=N29,
WRAP=1.000000,
$
TYPE=REPORT,
COLUMN=N28,
WRAP=1.000000,
$
TYPE=REPORT,
COLUMN=N22,
WRAP=1.000000,
$
TYPE=REPORT,
COLUMN=N20,
WRAP=1.000000,
$
TYPE=REPORT,
COLUMN=N19,
WRAP=1.000000,
$
TYPE=REPORT,
COLUMN=N13,
WRAP=1.000000,
$
TYPE=REPORT,
COLUMN=N11,
WRAP=1.000000,
$
TYPE=REPORT,
COLUMN=N7,
WRAP=1.000000,
$
TYPE=REPORT,
COLUMN=N5,
WRAP=1.000000,
$
TYPE=REPORT,
COLUMN=N4,
WRAP=1.000000,
$
TYPE=REPORT,
COLUMN=N3,
WRAP=1.000000,
$
TYPE=REPORT,
COLUMN=N2,
WRAP=1.000000,
$
ENDSTYLE
END

Can you please add ?FF after the TABLE FILE SQLOUT

TABLE FILE SQLOUT
?FF
...

This will show the field formats

What I don't understand is, I changed all the column sizes within the report? As you can see the fields are way too long for the data they contain, most fields can be about 50.

HOST E01 A30V
OCM_DETAIL E02 A240V
BU_MIDLEVEL_DETAIL E03 A240V
BU_DETAIL E04 A240V
BU_DEPARTMENT E05 A240V
COST_CENTER_FROM_AC E06 D20.2
COSTCENTER_DESC E07 A240V
SERVER_MAX_APP_CRITICALITY E08 A9V
FSC_SUPPORTED E09 A3V
SERVERROLE E10 A50V
OS_DETAIL E11 A65V
HW_EOL_STAGE E12 D20.2
SERVER_MODEL E13 A120V
LOCATION_CITY E14 A42V
LOCATION_BUILDING E15 A45V
SERVER_TYPE E16 A8V
DECOM_PPM_ID E17 D20.2
PPM_CLOSE_DATE E18 HYYMDS
PPM_PLANNED_DECOM_DATE E19 A200V
PPM_STATUS E20 A4000V
APP_ID E21 A32V
APP_NAME E22 A128V
APPSTATUS E23 A15V
APPLICATIONS_PERCENT E24 D20.2
APP_CONTACTS E25 A60V
CRITICALITY_CODE E26 A10V
SECURITY_TIER E27 A10V
MAINT_DIV E28 A250V
MAINT_BU E29 A250V
USING_BU E30 A250V
0 ERROR AT OR NEAR LINE 322 IN PROCEDURE newfex FOCEXEC *
(FOC397) LENGTH OF FIELDS ON FOCUS DATA PATH EXCEEDS 32K BYTES:
1
0 NUMBER OF RECORDS IN TABLE= 30 LINES= 30
0

I would suggest using a COMPUTE or DEFINE to change the size of the fields.

With a HOLD, the redefined formats are not kept.

quote:

LENGTH OF FIELDS ON FOCUS DATA PATH EXCEEDS 32K BYTES

It isn't that your fields are too small, they are too large. This means you have more than 32K in one record.

Am, here is an example for you to follow. remember to not use the V in the format and it will work. I created a dummy field called anvln equal to lastname and made it A50V. This changed the format on the fly to A5. This is the code and output.

SET HOLDLIST =PRINTONLY
TABLE FILE EMPDATA
PRINT PIN COMPUTE ANVLN/A50V=LN; NOPRINT
ANVLN/A5
ON TABLE HOLD
END
?FF HOLD

FILENAME= HOLD
PIN E01 A9
ANVLN E02 A5