[Solved] Error with master file when creating a chart

August 02, 2018, 09:16 AM

Hello,

I'm pulling data from Metadata. I then save the data to a hold file. (On table Hold As MD)

From there I try creating a chart. I select the MD as the Master File. I then get an error saying: Code: 1108 Type: xFDMinit Error with master file: MD.

I already decreased the name length of my master file to only 2 letters.

If I create a chart from the Metadata it will create fine however I need to join two metadata together to get the result set I'm looking for.

Thanks

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

August 02, 2018, 09:33 AM

Doug

quote:
On table Hold As MD

1) Verify the the MD synonym is not in your path using the WHENCE command to determine that before you run your fex.

2) Try ON TABLE HOLD AS MYMASTER FORMAT FOCUS INDEX (1st Sort Value). Where MYMASTER is a name of your choice.

August 02, 2018, 09:33 AM

MartinY

Try holding your file with the following then select MD file to create a chart

ON TABLE HOLD AS MD FORMAT FOCUS

When you do not specify the file format no MFD is created and chart designer is looking for a MFD

August 02, 2018, 10:36 AM

KellyT

I did the WHENCE and it was showing only one MD in a different location. So I added APP Hold metricsdash to put the hold tables into the correct folder.

I added the Index and that didn't help.

I did have it as ON TABLE HOLD MD FORMAT FOCUS however it was getting the error so had removed the Format Focus portion.
Readded and still getting same error.

August 02, 2018, 10:37 AM

KellyT

 

-SET &ECHO = ALL;

APP HOLD metricsdash

JOIN
MDFLEETREPORTDEV.MDFLEETREPORTDEV.FLEETID IN mdfleetreportdev TO MULTIPLE
MDFLEETDEV.MDFLEETDEV.FLEETID IN mdfleetdev TAG J0 AS J0
END

DEFINE FILE MDFLEETREPORTDEV
TODAY/YYMD=&YYMD;
REPORTBEGIN/YYMD=DATEADD(TODAY,'M',-6);
beginDateConv/YYMD=HDATE(MDFLEETREPORTDEV.MDFLEETREPORTDEV.BEGINDATE, 'YYMD');
END

TABLE FILE MDFLEETREPORTDEV
PRINT
     MDFLEETREPORTDEV.MDFLEETREPORTDEV.FLEETID
     MDFLEETREPORTDEV.MDFLEETREPORTDEV.BEGINDATE/HMDYY AS 'FleetBeginDate'
     MDFLEETREPORTDEV.MDFLEETREPORTDEV.MILES AS 'FleetMiles'
     MDFLEETREPORTDEV.MDFLEETREPORTDEV.TRUCKS AS 'FleetTrucks'
     COMPUTE milestruck/D12.2 = MDFLEETREPORTDEV.MDFLEETREPORTDEV.MILES / MDFLEETREPORTDEV.MDFLEETREPORTDEV.TRUCKS; AS 'FleetMilesTrucks'
     J0.MDFLEETDEV.CSRTYPE
BY  LOWEST MDFLEETREPORTDEV.MDFLEETREPORTDEV.FLEETID NOPRINT
WHERE ( fleetId EQ &fleetId ) AND ( MDFLEETREPORTDEV.MDFLEETREPORTDEV.beginDateConv GE REPORTBEGIN ) AND ( J0.MDFLEETDEV.CURRENTFLEETIND EQ 'Y' );
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE HOLD AS MD FORMAT FOCUS
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = enblue_theme,
$
TYPE=DATA,
     SIZE=8,
     BACKCOLOR=( 'WHITE' RGB(235 235 255) ),
$
TYPE=TITLE,
     SIZE=9,
     COLOR='WHITE',
     BACKCOLOR=RGB(45 111 205),
     STYLE=-UNDERLINE+BOLD,
$
ENDSTYLE
END
-*WHENCE MD FOCUS

August 02, 2018, 01:32 PM

FP Mod Chuck

Kelly

I found a case that this is a known issue in WF 8.1.04 and is resolved in 8.1.05 and higher.

This message has been edited. Last edited by: FP Mod Chuck,

August 02, 2018, 01:56 PM

KellyT

Thank you.

I figured out I can create a SQL Chart rather than even using metadata/hold files.

We will be upgrading to 8.2 newest release in the next month or two.