Anyone,

We have been parallel testing 7.6.10 for months. The users have had amble time
to discover this, but of course, they only discover this after we go live!

We have a fex that works fine in 7.1 and crashes the agent in 7.6.

It fails during the MATCH command (I think). No feedback provide when an agent crashes.
I'm sure there are traces that might reveal something. I'm hoping someone may have already
experienced this and is easily spotted in the code below.

Thanks,
--wg

Here's the stripped down version of the code:

  
-SET &YRMO = '201005' ;
-SET &CO = 'ALL' ;
-SET &PROJECT = 'ALL' ;

-SET &WYRMO  = IF &YRMO EQ 'ALL' THEN ' ' ELSE
-              'EQ '''| &YRMO | '''' ;
-SET &WCO    = IF &CO EQ 'ALL' THEN ' ' ELSE
-              'WHERE COMP_ID EQ '''| &CO | '''' ;
-SET &VCO    = IF &CO EQ 'ALL' THEN ' ' ELSE
-              'WHERE COMPANY_SAP_ID EQ '''| &CO | '''' ;
-SET &WPROJ  = IF &PROJECT EQ 'ALL' THEN ' ' ELSE
-              'WHERE PROJ_NO EQ '''| &PROJECT | '''' ;
-*

-SET &ECHO=ON;
SET ASNAMES=ON
SET NODATA='0'
SET ALL=ON
SET BYDISPLAY=ON
-*
JOIN CLEAR *
-*
JOIN COMPANY_SK IN FW_COMPY TO ALL COMPANY_SK IN FW_EXCHG AS J1
END
JOIN EXCHANGE_SK IN FW_COMPY TO EXCHANGE_SK IN FW_PROJT AS J2
END
JOIN VERB_SK IN FW_COMPY TO VERB_SK IN FW_VERB AS J3
END
JOIN PROJECT_SK IN FW_COMPY TO PROJECT_SK IN FW_WBS AS J4
END
JOIN PRIORITY_SK IN FW_COMPY TO PRIORITY_SK IN FW_PRIOR AS J5
END
JOIN CONSTR_COORD_SK IN FW_COMPY TO USER_PROFILE_SK IN FW_USER AS J6
END
-*
-RUN
DEFINE FILE FW_COMPY
PROJ_NO/A8=EDIT (FW_PROJT.PROJECT_SAP_ID, '99999999$$$$$$$$$$$$$$$$');
COMP_ID/A4=COMPANY_SAP_ID;
END
-*
DEFINE FILE FW_PROJT
PROJ_NO/A8=EDIT (PROJECT_SAP_ID, '99999999$$$$$$$$$$$$$$$$');
END
DEFINE FILE FW_PRJWBSE
TOTACT/P13.2C=IF FW_PRJWBSE.WBS_LEVEL EQ '  2'
              THEN FW_PRJWBSE.TOT_ACTUALS_AMT ELSE 0;
SHEATH/P13.1C=IF FW_PRJWBSE.WBS_LEVEL EQ '  2'
              THEN FW_PRJWBSE.SHEATH_MILES ELSE 0;
ACTUAL/P13.2C=IF FW_PRJWBSE.WBS_LEVEL EQ '  2'
              THEN FW_PRJWBSE.ACTUALS_AMT ELSE 0;
COMMIT/P13.2C=IF FW_PRJWBSE.WBS_LEVEL EQ '  2'
              THEN FW_PRJWBSE.COMMITMENTS ELSE 0;
-INCLUDE axshlslu.fex
EYEAR/A4=EDIT (PARM_YYYYMM, '9999$$');
EMONT/A2=EDIT (PARM_YYYYMM, '$$$$99');
EYYM/A7=EYEAR|'/'|EMONT;
END
DEFINE FILE FW_PRJPROJ
EYEAR/A4=EDIT (PARM_YYYYMM, '9999$$');
EMONT/A2=EDIT (PARM_YYYYMM, '$$$$99');
EYYM/A7=EYEAR|'/'|EMONT;
END
DEFINE FILE FW_PRJPLAN
EYEAR/A4=EDIT (PARM_YYYYMM, '9999$$');
EMONT/A2=EDIT (PARM_YYYYMM, '$$$$99');
EYYM/A7=EYEAR|'/'|EMONT;
END
-*
MATCH FILE FW_COMPY
PRINT REGION_SAP_ID
    REGION
    MARKET_CLUSTER_SAP_ID
    MARKET_CLUSTER
EXCHANGE_SAP_ID
EXCHANGE
FW_PROJT.DATE_CREATED
FW_PROJT.DATE_RELEASED
    FW_PROJT.CONSTR_START
    FW_PROJT.CONSTR_COMPLETE
FW_PROJT.NUMBER_FIBER_LOTS
FW_PRIOR.PRIORITY_SAP_ID
FW_PRIOR.PRIORITY
    FW_VERB.VERB_SAP_ID
    FW_VERB.VERB_DESCRIPTION
FW_PROJT.DATE_CLOSED
FINANCE_SUPERVISOR_APPRVL_DATE
ACTUALS_FIN_SUPVSR_APPRVL_DATE
FIRST_NAME MI LAST_NAME
ORIGINAL_SYSTEM_PROJECT_ID
BY PROJ_NO
RUN
FILE FW_COMPY
SUM FW_WBS.ROUTE_MILES
BY PROJ_NO
RUN
FILE FW_PRJPLAN
SUM PLAN_AMOUNT TOT_PLAN_AMOUNT
BY PROJ_NO
WHERE FW_PRJPLAN.VERSION EQ '001';
WHERE WBS_ELEMENT OMITS '.E';
WHERE WBS_ELEMENT OMITS 'C.';
WHERE EYYM EQ '&DATEYYM';
RUN
FILE FW_PRJPROJ
SUM PROJ_DESC
      PLAN_START_DATE
      PLAN_END_DATE
BY PROJ_NO
WHERE EYYM EQ '&DATEYYM';
RUN
FILE FW_PRJWBSE
SUM FST.CATEGORY FST.INIT_DESC FST.MNEMONIC_DESC FST.RESP_PERSON
    FST.S_STATUS FST.U_STATUS FST.INV_REASON FST.SPENDING_CAT
    FST.S_TECO_DATE FST.S_CLOSE_DATE
    FST.CREATE_DATE FST.RELEASE_DATE
    FST.COMP_ID
FST.OLD_PROJ_ID
    SHEATH
    ORIG_BUDGET SUPPL_BUDGET RETURNS
    COMMIT ACTUAL TOTACT
    LOAD_DATE
BY PROJ_NO
WHERE EYYM EQ '&DATEYYM';
RUN
FILE FW_PRJWBSE
SUM ORIG18
BY PROJ_NO
IF FW_PRJWBSE.WBS_LEVEL EQ '  1'
WHERE EYYM EQ '&DATEYYM';
AFTER MATCH HOLD AS 'HELEMENT' OLD-OR-NEW
END

This message has been edited. Last edited by: Winfred Gunter,

I would use a step-by-step approach in debugging this.

I'd start by verifying that the JOINs make sense. Then I'd match only two files, if that works, keep adding back another file until it fails. I would turn XRETRIEVAL to OFF for faster debugging. I would insert the default AFTER MATCH commands for each match for clarity:

AFTER MATCH HOLD OLD-OR-NEW 

But then, that's just me.

Francis,

Thanks, great ideas. I'm on my way to do these very things.

--wg

All,

After stepping thru each match step, it only crashes the agent when the last step is added. This one is the simplest and I don't see anything wrong with it....

Also, I did add the default match conditions line, as Francis suggested.

Is there a SET MATCH = v7.1 command?

--wg

Just a guess ... try replacing your IF with a WHERE. Also, is the format of FW_PRJWBSE.WBS_LEVEL an A3?

IF FW_PRJWBSE.WBS_LEVEL EQ '  1'

WHERE FW_PRJWBSE.WBS_LEVEL EQ '  1';

You could also start removing parts of the Match to see which File is causing the problem.

quote:

AFTER MATCH HOLD AS 'HELEMENT' OLD-OR-NEW

I would remove the quotes around HELEMENT. Maybe it helps ...

Thanks to all,

I'm going to close this because I finally narrowed it down to the last MATCH statements and that was using a weird define decode. I replaced the decode with a table which she joins to now.

This let me remove the last MATCH statements and it's working. However, it doesn't reveal why or what the difference is between v71 and v76 decode limits or restrictions.