Hello, I am a new user and getting this error: "Error Parsing MASTER File SEP_LIST (The operation timed out (12002))." I am able to run each piece of the report from text editor, but the GUI is giving me the above error. I have noticed that somehow the report is creating a hold file named "IN". I was hoping someone might have time to look at my code below and can help with the time out error:

Thank you,

-* File: IBFS:/TEST/WFC/Repository/STCU/Reports/Accounting/Procedure1.fex Created by WebFOCUS AppStudio
TABLE FILE A_MBR_ACCT_RELN
BY A_MBR_ACCT_RELN.ACCOUNT.ACCT_NUM
BY A_MBR_ACCT_RELN.MEMBER_ACCOUNT_RELATIONSHIP.ACCT_RELN_CNT
BY A_MBR_ACCT_RELN.MEMBER_PRIMARY.MBR_SSN AS 'PRIMARY_SSN'
BY A_MBR_ACCT_RELN.MEMBER_ADDL.MBR_SSN
WHERE ( A_MBR_ACCT_RELN.RELATIONSHIP_TYPE.RELN_TYPE EQ 'Joint Owner' OR 'POD Beneficiary' OR 'Primary' );
WHERE ( A_MBR_ACCT_RELN.MEMBER_ADDL.ETL_VERS_CURR_FLAG EQ 'Y' );
WHERE ( A_MBR_ACCT_RELN.RELATIONSHIP_STATUS.RELN_STAT EQ 'Active' );
WHERE ( A_MBR_ACCT_RELN.DATE_END.DTE EQ '12/31/9999' );
WHERE (A_MBR_ACCT_RELN.MEMBER_ADDL.MBR_SSN NE '**NA**');
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE SET BYDISPLAY ON
ON TABLE NOTOTAL
ON TABLE HOLD AS MEMBER
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END
TABLE FILE MEMBER
RANKED AS 'RANK1' BY MEMBER.MEMBER.ACCT_NUM
BY MEMBER.MEMBER.PRIMARY_SSN
RANKED AS 'RANK2' BY MEMBER.MEMBER.MBR_SSN
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE SET BYDISPLAY ON
ON TABLE NOTOTAL
ON TABLE HOLD AS RANK
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END
TABLE FILE RANK
PRINT
RANK.RANK.MBR_SSN
BY RANK.RANK.ACCT_NUM
ACROSS RANK.RANK.RANK2
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE HOLD AS SSN
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END
TABLE FILE MEMBER
SUM
MEMBER.MEMBER.ACCT_RELN_CNT
BY MEMBER.MEMBER.ACCT_NUM
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE SET BYDISPLAY ON
ON TABLE NOTOTAL
ON TABLE HOLD AS SSN2
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END
JOIN
LEFT_OUTER SSN.SSN.ACCT_NUM IN SSN TO UNIQUE SSN2.SSN2.ACCT_NUM IN SSN2 TAG J0
AS J0
END
TABLE FILE SSN
PRINT
SSN.SSN.MBR1
SSN.SSN.MBR2
SSN.SSN.MBR3
SSN.SSN.MBR4
SSN.SSN.MBR5
SSN.SSN.MBR6
SSN.SSN.MBR7
SSN.SSN.MBR8
SSN.SSN.MBR9
SSN.SSN.MBR10
BY SSN.SSN.ACCT_NUM
BY J0.SSN2.ACCT_RELN_CNT
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE HOLD AS SSN3
ON TABLE SET XLSXPAGESETS ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END

DEFINE FILE SSN3
CONCAT/A100V=SSN3.SSN3.MBR1 | '' | SSN3.SSN3.MBR2 | '' | SSN3.SSN3.MBR3 | '' | SSN3.SSN3.MBR4 | '' | SSN3.SSN3.MBR5 | '' | SSN3.SSN3.MBR6 | '' | SSN3.SSN3.MBR7 | '' | SSN3.SSN3.MBR8 | '' | SSN3.SSN3.MBR9 | '' | SSN3.SSN3.MBR10;
COUNT/D12=
IF SSN3.SSN3.MBR2 EQ '' THEN 1 ELSE
IF SSN3.SSN3.MBR3 EQ '' THEN 2 ELSE
IF SSN3.SSN3.MBR4 EQ '' THEN 3 ELSE
IF SSN3.SSN3.MBR5 EQ '' THEN 4 ELSE
IF SSN3.SSN3.MBR6 EQ '' THEN 5 ELSE
IF SSN3.SSN3.MBR7 EQ '' THEN 6 ELSE
IF SSN3.SSN3.MBR8 EQ '' THEN 7 ELSE
IF SSN3.SSN3.MBR9 EQ '' THEN 8 ELSE
IF SSN3.SSN3.MBR10 EQ '' THEN 9 ELSE 10;
END
TABLE FILE SSN3
SUM
SSN3.SSN3.ACCT_RELN_CNT
BY SSN3.SSN3.ACCT_NUM
BY SSN3.SSN3.CONCAT
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE HOLD AS MEMBER
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END
TABLE FILE A_ACCT_ALL_DLY
SUM
A_ACCT_ALL_DLY.ALL_ACCTS_DLY.DLY_BAL
BY A_ACCT_ALL_DLY.ACCOUNT.ACCT_NUM
BY A_ACCT_ALL_DLY.PRODUCT.PROD_ACCT_TYPE
BY LOWEST A_ACCT_ALL_DLY.MEMBER.MBR_NUM
BY A_ACCT_ALL_DLY.PRODUCT.PROD_CLASS_CD
BY A_ACCT_ALL_DLY.MEMBER.MBR_SSN
BY A_ACCT_ALL_DLY.MEMBER.MBR_CLASS_CD
BY A_ACCT_ALL_DLY.PRODUCT.FS_LINE_ITEM
WHERE ( A_ACCT_ALL_DLY.DATE_EFFECTIVE.DTE EQ '01312017' );
WHERE ( A_ACCT_ALL_DLY.ALL_ACCTS_DLY.DLY_BAL GT 0);
WHERE ( A_ACCT_ALL_DLY.PRODUCT.PROD_ACCT_TYPE EQ 'SAV' OR 'CKG' OR 'CRT' OR 'IRA' OR 'ISV' );
WHERE ( A_ACCT_ALL_DLY.PRODUCT.PROD_CLASS_CD NE '296' OR '298' OR '299' );
WHERE (( A_ACCT_ALL_DLY.ACCOUNT.CHRG_OFF_ACCT_FLAG EQ 'N' ) OR ( A_ACCT_ALL_DLY.ACCOUNT.CHRG_OFF_STAT_DTE GT '02012017' ));
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE HOLD AS DEPOSIT1
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END
DEFINE FILE DEPOSIT1
TrustOrgSplit/A20=
IF DEPOSIT1.MBR_CLASS_CD EQ '270'
THEN 'Trust'
ELSE IF DEPOSIT1.MBR_CLASS_CD EQ '260' OR '261' OR '250' OR '251' OR '252' OR '253'
THEN 'Org/Club'
ELSE 'Regular';
NCUSIFType/A20=
IF DEPOSIT1.PROD_ACCT_TYPE EQ 'ISV' OR 'IRA'
THEN 'IRA/KEOGH'
ELSE TrustOrgSplit;
END
TABLE FILE DEPOSIT1
SUM
DEPOSIT1.DLY_BAL
BY DEPOSIT1.ACCT_NUM
BY DEPOSIT1.PROD_ACCT_TYPE
BY LOWEST DEPOSIT1.MBR_NUM
BY DEPOSIT1.PROD_CLASS_CD
BY DEPOSIT1.MBR_SSN
BY DEPOSIT1.MBR_CLASS_CD
BY DEPOSIT1.FS_LINE_ITEM
BY DEPOSIT1.NCUSIFType
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE HOLD AS DEPOSIT
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END
TABLE FILE SEP_LIST
BY SEP_LIST.SEP_LIST.ACCOUNT_NUMBER
BY SEP_LIST.SEP_LIST.IRA_CODE
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE HOLD AS IRA_CODE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END

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

Hi SDF,

Pay attention, you holding twice in the same file's name :

ON TABLE HOLD AS MEMBER

Second, where does input file in

TABLE FILE SEP_LIST

is coming from ? This file is not created from any above code that you have included. So the error you have means that SEP_LIST cannot be located.

Martin Y

Thank you for catching the second Member hold file. I have that corrected. The SEP_LIST is a flat file. I removed the SEP_LIST and get the same error just noting DEPOSIT1 now.

Hi SDF

You might try adding a -RUN after each END statement to insure the code runs in the sequence you want.