[CLOSED] Error while referencing an advanced graph from a composer layout
I want to reference an advanced graph from a composer layout..but I keep getting the following error..."The hold file name is missing from the graph request. Please, correct the problem before running layout"This message has been edited. Last edited by: Kerry,
WebFOCUS 7.6, Windows All output
January 04, 2010, 02:12 PM
lovime85
Ok.. now I don't get that error..but when it runs ..the page retrieve me "No HTML output""EDA no data"... any suggestions?
WebFOCUS 7.6, Windows All output
January 04, 2010, 02:25 PM
lovime85
ok...forget last message .. there was no reference..stil the..."The hold file name is missing from the graph request. Please, correct the problem before running layout" error..
WebFOCUS 7.6, Windows All output
January 04, 2010, 02:37 PM
GinnyJakes
Your graph code should include a statement that looks something like this:
Graph code -* File mortality_rate.fex JOIN F_PATIENT_STAY_DETAIL.F_PATIENT_STAY_DETAIL.CYCLE_ID IN F_PATIENT_STAY_DETAIL TO UNIQUE F_PATIENT_STAY_HEADER.F_PATIENT_STAY_HEADER.CYCLE_ID IN F_PATIENT_STAY_HEADER TAG J0 AS J0 END JOIN F_PATIENT_STAY_DETAIL.F_PATIENT_STAY_DETAIL.PATIENT_ID IN F_PATIENT_STAY_DETAIL TO UNIQUE D_PATIENT.D_PATIENT.PATIENT_ID IN D_PATIENT TAG J1 AS J1 END SET NODATA = NONE GRAPH FILE F_PATIENT_STAY_DETAIL -* Created by Advanced Graph Assistant SUM CNT.J1.D_PATIENT.PATIENT_ID AS 'Dead Patients' WHERE J0.F_PATIENT_STAY_HEADER.DOD IS-NOT MISSING; WHERE RECORDLIMIT EQ 1000 ON GRAPH HOLD AS HOLD FORMAT SVG ON GRAPH PCHOLD FORMAT PNG ON GRAPH SET GRAPHDEFAULT OFF ON GRAPH SET VZERO OFF ON GRAPH SET HTMLENCODE ON ON GRAPH SET HAXIS 770 ON GRAPH SET VAXIS 405 ON GRAPH SET UNITS PIXELS ON GRAPH SET LOOKGRAPH GAUGE1 ON GRAPH SET GRMERGE ADVANCED ON GRAPH SET GRMULTIGRAPH 0 ON GRAPH SET GRLEGEND 0 ON GRAPH SET GRXAXIS 0 ON GRAPH SET GRAPHSTYLE * setTemplateFile("/images/tdg/template/IBIRIACarbonRounded.txt"); setReportParsingErrors(false); setSelectionEnableMove(false); setDepthRadius(5); setTransparentBorderColor(getSeries(0),true); setTransparentBorderColor(getSeries(1),true); setTransparentBorderColor(getSeries(2),true); setTransparentBorderColor(getSeries(3),true); setTransparentBorderColor(getSeries(4),true); setTransparentBorderColor(getSeries(5),true); setTransparentBorderColor(getSeries(6),true); setTransparentBorderColor(getSeries(7),true); setTransparentBorderColor(getSeries(8),true); setTransparentBorderColor(getSeries(9),true); setTransparentBorderColor(getSeries(10),true); setTransparentBorderColor(getChartBackground(),true); setPlace(true); setDisplay(getTitle(),true); setTextString(getTitle(),""); ENDSTYLE END
ok..new error.. 0 NUMBER OF RECORDS IN GRAPH= 1 PLOT POINTS= 1 JPEG FILE SAVED ... 0 ERROR AT OR NEAR LINE 20 IN PROCEDURE rltemp2 FOCEXEC * (FOC003) THE FIELDNAME IS NOT RECOGNIZED: NOPRINT BYPASSING TO END OF COMMAND (FOC009) INCOMPLETE REQUEST STATEMENT (FOC3296) Error found in Coordinated Compound Report: At Component graph1 Compound Report is TERMINATING.....
WebFOCUS 7.6, Windows All output
January 04, 2010, 05:06 PM
BlueZone
I am not sure what exact verion of 7.6 you have, but your error may be related to a known bug with AGA that was fixed in 7.6.5 or 7.6.6.
We opened a similar case with IBI for version 764 last year and were notified of this fix.
I suggest you check with IBI tech-support to confirm.
------------------------------------------------------------------------------------------------- Blue Cross & Blue Shield of MS WF.76-10 on (WS2003 + WebSphere) / EDA on z/OS + DB2 + MS-SQL MRE, BID, Dev. Studio, Self-Service apps & a dash of fun !!
January 04, 2010, 05:34 PM
lovime85
I have the 7.6.10 version... i will search for the fix you mentioned... THANKS
WebFOCUS 7.6, Windows All output
January 04, 2010, 05:53 PM
lovime85
Well i still can't find the solution..but i found something weird in the composer code...there is a reference to a pdf..and i don't know where it is created.."ON TABLE PCHOLD FORMAT PDF"
-* File dashboard_mortalityrate1 -* Default Mode: ResourceLayout SET HTMLARCHIVE=ON COMPOUND LAYOUT PCHOLD FORMAT AHTML UNITS=IN, $ SECTION=section1, LAYOUT=ON, METADATA='0.5^0.5^0.5^0.5^1', MERGE=AUTO, ORIENTATION=LANDSCAPE, PAGESIZE=Letter, $ PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, ORIENTATION=LANDSCAPE, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,ORIENTATION=LANDSCAPE,', $ COMPONENT='graph1', TEXT='graph1', TOC-LEVEL=2, POSITION=(0.729 0.625), DIMENSION=(3.021 1.979), METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 3.021in; HEIGHT: 1.979in; TOP: 0.625in; LEFT: 0.729in', $ END SET COMPONENT='graph1' -*component_type graph -INCLUDE mortality_rate1 TABLE FILE F_PATIENT_STAY_DETAIL " " SUM COMPUTE CNTR/I4 = CNTR + 1; NOPRINT COMPUTE CNTR2/A4 = IF &FOCGRAPHCNT EQ 1 THEN ' ' ELSE FTOA(CNTR-1,'(F4)','A4'); NOPRINT COMPUTE IMG/A16 = 'HOLD'||LJUST(4,CNTR2,'A4')|| '.svg';NOPRINT BY NOPRINT ON PAGE-BREAK ON TABLE SET PAGE-NUM NOLEAD ON TABLE PCHOLD FORMAT PDF ON TABLE SET STYLE * type=HEADING, IMAGE=(IMG), position=(0 0), $ TYPE=REPORT,PAGE-LOCATION=OFF,$ END COMPOUND END
WebFOCUS 7.6, Windows All output
January 07, 2010, 01:42 PM
Kerry
Hi lovime85,
Has this issue been resolved on your side?
If not resolved and you have not done so, it is highly recommended that you should open a case with Information Builders' Customer Support Services for assistance. You may either call at 1-800-736-6130, or access online at InfoResponse.
Cheers,
Kerry
Kerry Zhan Focal Point Moderator Information Builders, Inc.