Focal Point
[CLOSED] FML - Error FOC32565 - What does this mean?

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1387049106

April 11, 2011, 12:22 PM
Francis Mariani
[CLOSED] FML - Error FOC32565 - What does this mean?
Searched for error FOC32565 on FocalPoint - nada.

This code triggers the error:

TABLE FILE DDT001
SUM
COMPUTE AMT/P17.2BC =
IF (EDIT(DDROW,'999$') NE 'FTE') THEN BALNIE / 1000 ELSE BALNIE;
BY SUMDIV
BY SUMDIV_NAME
ACROSS YRMTH
BY ROWPREFIX
BY ROWPREFIX3
BY DDROW
FOR DDROW
NIE01A                                           LABEL NIE01A       OVER
NIE01B                                           LABEL NIE01B       OVER
RECAP NIE01HIGH/P17.2BC = NIE01A + NIE01B;       LABEL NIE01HIGH
WHERE DDROW NE 'N/A';
WHERE (YRMTH GE '201011' AND YRMTH LE '201102');
ON TABLE HOLD AS H001
END

This code has no error:
TABLE FILE DDT001
SUM
COMPUTE AMT/P17.2BC =
IF (EDIT(DDROW,'999$') NE 'FTE') THEN BALNIE / 1000 ELSE BALNIE;
BY SUMDIV
BY SUMDIV_NAME
ACROSS YRMTH
BY ROWPREFIX
BY ROWPREFIX3
BY DDROW
FOR DDROW
NIE01A                                           LABEL NIE01A       OVER
NIE01B                                           LABEL NIE01B       
WHERE DDROW NE 'N/A';
WHERE (YRMTH GE '201011' AND YRMTH LE '201102');
ON TABLE HOLD AS H001
END

It seems to have something to do with label names or row values that are different in size, i.e. NIE01A and NIE01B are the same length, but NIE01HIGH is longer.

Any ideas?

Thanks,

This message has been edited. Last edited by: Francis Mariani,


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
April 11, 2011, 12:46 PM
Francis Mariani
Seems like including the format in the RECAP (P17.2BC) causes the error. But I need the format, otherwise the RECAP value is zero.


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
April 11, 2011, 12:57 PM
Francis Mariani
I seem to have it working using the CAR file.

SET ASNAMES=ON
SET HOLDLIST=PRINTONLY
SET HOLDFORMAT=ALPHA
TABLE FILE CAR
SUM SALES
BY SEATS
FOR COUNTRY 
JAPAN   LABEL JAPAN   OVER
ENGLAND LABEL ENGLAND OVER
RECAP JPEN/I5 = JAPAN + ENGLAND; OVER
ITALY

ON TABLE HOLD AS H001
END
-RUN

?FF H001
-RUN

TABLE FILE H001
PRINT 
SALES
BY SEATS
BY E02
END
-RUN

As shown in this example, I have an intermediary HOLD file and, when created using FML, you have to be careful.


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
April 11, 2011, 01:18 PM
<JG>
quote:
FOC32565

FML it is documented (I cannot find the specific page to look at).

This is specifically because you are doing a HOLD.

Reformat on RECAP is not allowed.

The formats for NIE01HIGH , NIE01A and NIE01B must all be the same.

Do a DEFINE on NIE01A and NIE01B
April 11, 2011, 02:44 PM
Francis Mariani
It's strange behaviour. It's a combination of RECAP with format AND with the COMPUTE statement - even though the formats are the same. If I remove the COMPUTE, it works. I'll move the COMPUTE out of this piece of code.

I will open a case for this.


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
April 11, 2011, 05:47 PM
Waz
Thought about becoming an IBI tester ?

You certainly find the obscure ones.

Good One


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

October 26, 2011, 04:49 PM
Prarie
Francis,

did you open a case for this? If I open another case I'll scream. I have code that works fine in 7.6.1 but not in 7.7.03
I have a define field that has the same format and never changes but I'm getting that error.