I'm in the process of upgrading to 7.7.03
Anyone having any problems with FML code? I have opened a case with IBI.

This is reading BW data - I have a fex that does not seem to process the FML code and returns 0 records.

When you run this – You get records
TABLE FILE BWP_V_HIER_IS001
SUM
ACT
BUD
ACT_YTD
BUD_YTD
BY CHILD_ID
END
Change it to this…which is the way the report runs and you get 0 records

 TABLE FILE BWP_V_HIER_IS001
SUM
ACT
BUD
ACT_YTD
BUD_YTD
FOR CHILD_ID
'VLO SALAWAGS' GET CHILDREN ALL AS CAPTION LABEL R1 NOPRINT OVER 'VLO SALAWAGS' ADD ALL AS 'Salaries and Wages' LABEL R2 OVER 'VLO OVTIME' GET CHILDREN ALL AS CAPTION LABEL R1 NOPRINT OVER 'VLO OVTIME' ADD ALL AS 'Overtime' LABEL R4 OVER 'VLO EMPLPAYBEN' GET CHILDREN ALL AS CAPTION LABEL R1 NOPRINT OVER 'VLO EMPLPAYBEN' ADD ALL AS 'Employee Payroll Benefits' LABEL R6 OVER 'VLO INCENCOMP' GET CHILDREN ALL AS CAPTION LABEL R1 NOPRINT OVER 'VLO INCENCOMP' ADD ALL AS 'Incentive Compensation' LABEL R8 OVER 'VLO LOANEMPL' GET CHILDREN ALL AS CAPTION LABEL R1 NOPRINT OVER 'VLO LOANEMPL' ADD ALL AS 'Loaned Employees' LABEL R10 OVER 'VLO SEVPAY' GET CHILDREN ALL AS CAPTION LABEL R1 NOPRINT OVER 'VLO SEVPAY' ADD ALL AS 'Severance Pay' LABEL R12 OVER 'VLO OTHBENE' GET CHILDREN ALL AS CAPTION LABEL R1 NOPRINT OVER 'VLO OTHBENE' ADD ALL AS 'Other Benefits' LABEL R14 OVER 'VLO CAPOHEAD' GET CHILDREN ALL AS CAPTION LABEL R1 NOPRINT OVER 'VLO CAPOHEAD' ADD ALL AS 'Capitalized Overhead' LABEL R16 
END 
-EXIT 
0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0 
 

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

Not sure why that posts all on one line...

Assuming that BWP_V_HIER_IS001 is a synonym to a database table/view and not a FOCUS file, would enabling traces to capture the underlying SQL statement shed some light into what it's doing?

well this is that that produced

 FOC2506 - INTERFACE-MANAGED NATIVE JOIN SELECTED FOR THE FOLLOWING REASON:
 FOC2517 - FST. OR LST. WHERE SORT FIELDS DO NOT COVER KEY
 FOC2590 - AGGREGATION NOT DONE FOR THE FOLLOWING REASON:
 FOC2592 - RDBMS-MANAGED JOIN HAS BEEN DISABLED
 SELECT
 T1."CHILD_ID",
 T1."CHILD_ALIAS",
 T1."PARENT_ID"
 FROM
 WEBFOCUS.V_HIER_IS001 T1;
 FOC2590 - AGGREGATION NOT DONE FOR THE FOLLOWING REASON:
 FOC2599 - NON-SQL SEGMENT IN HIERARCHY (OTHER INTERFACE PRESENT)
 SELECT
 T1."CHILD_ID"
 FROM
 WEBFOCUS.V_HIER_IS001 T1
 WHERE
 (T1."CHILD_ID" IN('VLO 0000416950', 'VLO ADVOLTAX', 'VLO ADVT',
 'VLO AMORTEXP', 'VLO AMORTOPEX', 'VLO BADDEBTLOS', 'VLO
 CANCELPROJ', 'VLO CAPOHEAD', 'VLO CASHEXP', 'VLO CATTOT', 'VLO
 CHARITCONT', 'VLO CHEMICLE', 'VLO CHEM_CAT', 'VLO CHGODRS',
 'VLO COMS', 'VLO COMSYSEXP', 'VLO CRTCRDFEES', 'VLO DEPEXP',
 'VLO DEPGL_AST', 'VLO DEPOPEX', 'VLO DUESSUBS', 'VLO ELECSAL',
 'VLO ELECT', 'VLO EMPLACT', 'VLO EMPLPAYBEN', 'VLO EMPLPROC',
 'VLO ENGYPUR', 'VLO ENGYSALE', 'VLO ENGYTOT', 'VLO EPMPLREL',
 'VLO FINESTAX', 'VLO FUEL3PYT', 'VLO FUELSAL', 'VLO FXDBDCAT',
 'VLO INCENCOMP', 'VLO INJECTCAT', 'VLO INSURANCE', 'VLO
 LOANEMPL', 'VLO MAINTNCE', 'VLO MTNCE', 'VLO MTNCEAFE', 'VLO
 NITROGEN', 'VLO NONCASHEXP', 'VLO OPERSUPP', 'VLO OPEX001',
 'VLO OTHBENE', 'VLO OTHEMPLREL', 'VLO OTHEREXP', 'VLO
 OTHFXDEXP', 'VLO OTHOUTSVCS', 'VLO OTHTAXES', 'VLO OUTSERV',
 'VLO OVTIME', 'VLO OXYGEN', 'VLO PERMLIC', 'VLO PMETALCAT',
 'VLO PROFFEES', 'VLO REGULTAX', 'VLO RENTLEASES', 'VLO ROYAL',
 'VLO SALAWAGS', 'VLO SALWAGBENE', 'VLO SEVPAY', 'VLO STEAM',
 'VLO STEAMSAL', 'VLO SUPPOP', 'VLO TOTFXDEXP', 'VLO TOTVAREXP',
 'VLO TRAVEL', 'VLO UTIL', 'VLO VEHICLE', 'VLO WASTEDISP', 'VLO
 WATER'))
 ORDER BY
 T1."CHILD_ID";
 

Oh well, that's not too bad except for the fact that WebFOCUS is doing all of the heavy lifting instead of reying on the database for some of the stuff, but I'm not sure FML requests can easily be translated to SQL.

Anyway, can you run the SQL query directly against your database to see what results you get?

SELECT
 T1."CHILD_ID"
 FROM
 WEBFOCUS.V_HIER_IS001 T1
 WHERE
 (T1."CHILD_ID" IN('VLO 0000416950', 'VLO ADVOLTAX', 'VLO ADVT',
 'VLO AMORTEXP', 'VLO AMORTOPEX', 'VLO BADDEBTLOS', 'VLO
 CANCELPROJ', 'VLO CAPOHEAD', 'VLO CASHEXP', 'VLO CATTOT', 'VLO
 CHARITCONT', 'VLO CHEMICLE', 'VLO CHEM_CAT', 'VLO CHGODRS',
 'VLO COMS', 'VLO COMSYSEXP', 'VLO CRTCRDFEES', 'VLO DEPEXP',
 'VLO DEPGL_AST', 'VLO DEPOPEX', 'VLO DUESSUBS', 'VLO ELECSAL',
 'VLO ELECT', 'VLO EMPLACT', 'VLO EMPLPAYBEN', 'VLO EMPLPROC',
 'VLO ENGYPUR', 'VLO ENGYSALE', 'VLO ENGYTOT', 'VLO EPMPLREL',
 'VLO FINESTAX', 'VLO FUEL3PYT', 'VLO FUELSAL', 'VLO FXDBDCAT',
 'VLO INCENCOMP', 'VLO INJECTCAT', 'VLO INSURANCE', 'VLO
 LOANEMPL', 'VLO MAINTNCE', 'VLO MTNCE', 'VLO MTNCEAFE', 'VLO
 NITROGEN', 'VLO NONCASHEXP', 'VLO OPERSUPP', 'VLO OPEX001',
 'VLO OTHBENE', 'VLO OTHEMPLREL', 'VLO OTHEREXP', 'VLO
 OTHFXDEXP', 'VLO OTHOUTSVCS', 'VLO OTHTAXES', 'VLO OUTSERV',
 'VLO OVTIME', 'VLO OXYGEN', 'VLO PERMLIC', 'VLO PMETALCAT',
 'VLO PROFFEES', 'VLO REGULTAX', 'VLO RENTLEASES', 'VLO ROYAL',
 'VLO SALAWAGS', 'VLO SALWAGBENE', 'VLO SEVPAY', 'VLO STEAM',
 'VLO STEAMSAL', 'VLO SUPPOP', 'VLO TOTFXDEXP', 'VLO TOTVAREXP',
 'VLO TRAVEL', 'VLO UTIL', 'VLO VEHICLE', 'VLO WASTEDISP', 'VLO
 WATER'))
 ORDER BY
 T1."CHILD_ID";

As silly as this may sound, it could be just a matter of not having any data in your DB that matched your hierarchies in FML.

No it works fine in 7.6.1. There is data to match the FML.

Three weeks and several streaming sessions later..
ENGINE SQLORA SET TRIM_LITERALS ON

Fixed the problem. Go Live is Saturday.