An InfoAssist user has created a report from a join of 2 files. Attempts to run the report result in the error:

FOC205 The Description cannot be found for the file named: J0

There is no table named J0 in the join so perhaps that refers to the join itself. Can anyone tell me what this message indicates and/or what I need to do to debug.

Thanks in advance.

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

Dennis,
Let me welcome you to the forum, I see you are a new poster (assume also new to the forum itself). J0 does in fact refer to the join itself (you probably see 'END AS J0' in your code). Can you post the code you are having issues with? Please trim out as much extraneous code as possible but that the problem still exists.

- ABT

Below is the code. This was written by one of our users. I cut out hundreds of 2 repeating lines which I indicated in the code.

-* Begin MR Prefix -*
-SET &SECTION='PREFIX';
-INCLUDE mrv/new_reporting_object.fex
-* END MR Prefix -*
-* Begin MR Prefix -*
IN BETWEEN THESE 2 STATEMENTS ARE HUNDREDS OF THE SAME 2 END BEGIN STATEMENTS
-* Begin MR Suffix -*
-* END MR Suffix -*
-*INTERNAL_PROPERTIES$fieldDisplayMode=label;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$enablePreview=true;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$prefixDisplayMode=;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$FexState={"_arComponents":[]};OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$GlobalRecordLimit=2000;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$SampleData=false;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$LinkedSorts=;OBJECTID=GLOBAL

TABLE FILE F4801
-SET &SECTION='WHERE';
-INCLUDE mrv/new_reporting_object.fex
PRINT J0.F3112.A_2ND_ITEM_NUMBER AS 'Item #'
F4801.F4801.STATUS_CODE
J0.F3112.SETUP_LABOR NOPRINT
J0.F3112.ACTUAL_RUN_LABOR NOPRINT
J0.F3112.ACTUAL_RUN_MACHINE NOPRINT
J0.F3112.SETUP_LABOR___CURRENT AS 'Set'
J0.F3112.CURRENT_RUN_LABOR AS 'Labor Hrs'
J0.F3112.CURRENT_RUN_MACHINE AS 'Mach Hrs'
J0.F3112.QUANTITY AS 'WO Qty'
J0.F3112.OPERATION_STATUS_CODE NOPRINT
F4801.F4801.REQUESTED AS 'WO Req Date'
J0.F3112.QUANTITY_SHIPPED NOPRINT
J0.F3112.QUANTITY_AT_OPERATION AS 'Qty @ OP'
BY J0.F3112.A__BUISNESS_UNIT AS 'Work Center'
BY J0.F3112.DESCRIPTION AS 'Work Center Desc'
BY J0.F3112.REQUESTED AS 'Seq Req Date'
BY J0.F3112.OPERATIONS_SEQUENCE_NUMBER
BY F4801.F4801.STATUS_WAWR06_CODE AS 'Code'
BY F4801.F4801.ORDER_NUMBER AS 'WO #'
WHERE J0.F3112.OPERATIONS_SEQUENCE_NUMBER NE 1 OR 9;
WHERE J0.F3112.OPERATIONS_SEQUENCE_NUMBER LT 500;
WHERE F4801.F4801.ORDER_TYPE_CODE EQ 'WO' OR 'WX';
WHERE J0.F3112.A__BUISNESS_UNIT EQ '&A__BUISNESS_UNIT.(FIND J0.F3112.A__BUISNESS_UNIT IN J0).Select Work Center.';
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
ON TABLE SET SQUEEZE ON
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET EMPTYREPORT ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET STYLE *
INCLUDE=IBFS:/CFG/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
ENDSTYLE
END

-* Begin MR Suffix -*
-SET &SECTION='SUFFIX';
-INCLUDE mrv/new_reporting_object.fex
-* END MR Suffix -*
-RUN

Thanks Dennis, I suspect the piece that we next need to see is 'mrv/new_reporting_object.fex' as in: -INCLUDE mrv/new_reporting_object.fex.

It looks like that is where the join is being done.

-ABT

Here you go, thanks for helping, Dennis


-DEFAULT &SECTION=WHERE
-IF &SECTION EQ 'WHERE' GOTO WHERE;
-IF &SECTION EQ 'SUFFIX' GOTO SUFFIX;
-* BEGIN OF IBIOBJECTS PROCESSING
-* END OF IBIOBJECTS PROCESSING
-PREFIX
-*Other
-*End Other
JOIN
F4801.F4801.ORDER_NUMBER AND F4801.F4801.BRANCH IN F4801 TO UNIQUE
F3112.F3112.ORDER_NUMBER AND F3112.F3112.BRANCH IN F3112 TAG J0 AS J0
END
JOIN
J0.F3112.BRANCH AND J0.F3112.A_2ND_ITEM_NUMBER IN F4801 TO UNIQUE
F4102.F4102.A__BUISNESS_UNIT AND F4102.F4102.A_2ND_ITEM_NUMBER IN F4102 TAG J1
AS J1
END
DEFINE FILE F4801
END
-GOTO SKIP0
-*
-WHERE
WHERE ( BRANCH EQ ' 10160' ) AND ( STATUS_CODE LT '80' );
-GOTO SKIP0
-TABLE
-*INTERNAL_PROPERTIES$fieldDisplayMode=label;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$enablePreview=true;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$prefixDisplayMode=;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$FexState={"_arComponents":[]};OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$GlobalRecordLimit=500;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$SampleData=false;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$LinkedSorts=;OBJECTID=GLOBAL
TABLE FILE F4801
PRINT J0.F3112.A_2ND_ITEM_NUMBER
J1.F4102.LEGACY_PART_NUMBER
F4801.F4801.STATUS_CODE
F4801.F4801.BRANCH
J0.F3112.OPERATIONS_SEQUENCE_NUMBER
BY F4801.F4801.ORDER_NUMBER
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE=IBFS:/CFG/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
ENDSTYLE
END
-GOTO SKIP0
-GRAPH
GRAPH FILE F4801
END
-GOTO SKIP0
-SUFFIX
-GOTO SKIP0
-SKIP0

quote:

BUISNESS

Typo?

Also, that WHERE statement is not within the TABLE FILE...

My apologies; that was the wrong new_reporting_object.fex; I will try and find the right one.

Sorry, the information I provided is correct. I'm not sure what you mean by the WHERE statement is not within the TABLE FILE.

When I check the WHERE statement in the reporting object it is there.

(The spelling comes from the vendor's database)

Dennis

He means the where statement is outside of the table file block, which is illegal.

quote:

-WHERE
WHERE ( BRANCH EQ ' 10160' ) AND ( STATUS_CODE LT '80' );

....code stuff

TABLE FILE F4801
WHERE statement needs to be here

END

He

Thank you.

Do you have any input on how it came to be outside the table file block?

The Where statement was created as part of a Reporting Object for the InfoAssist User's use.

The user then used the Reporting Object to create a report. The user does not have access to change the source code.

Just seems odd that this could happen.

Thanks for all assistance.