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 Parish
WebFOCUS 7.6 Windows, All Outputs
September 29, 2010, 02:54 PM
ABT
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.
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
Dennis Parish
WebFOCUS 7.6 Windows, All Outputs
September 30, 2010, 09:01 AM
ABT
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.
-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
Dennis Parish
WebFOCUS 7.6 Windows, All Outputs
September 30, 2010, 09:46 AM
Francis Mariani
quote:
BUISNESS
Typo?
Also, that WHERE statement is not within the TABLE FILE...
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
September 30, 2010, 10:17 AM
Dennis Parish
My apologies; that was the wrong new_reporting_object.fex; I will try and find the right one.
Dennis Parish
WebFOCUS 7.6 Windows, All Outputs
September 30, 2010, 11:17 AM
Dennis Parish
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
Dennis Parish
WebFOCUS 7.6 Windows, All Outputs
September 30, 2010, 12:49 PM
N.Selph
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' );