[CLOSED] Error Parsing MASTER File SEP_LIST (The operation timed out (12002))
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 ENDThis message has been edited. Last edited by: FP Mod Chuck,
Release: 8.1 Service Pack: 0.5 Version: Branch8105m Application Server: Run with Apache Tomcat/8.0.21
June 26, 2017, 12:04 PM
MartinY
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.
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
June 26, 2017, 12:23 PM
SDF
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.
Release: 8.1 Service Pack: 0.5 Version: Branch8105m Application Server: Run with Apache Tomcat/8.0.21
June 26, 2017, 01:42 PM
FP Mod Chuck
Hi SDF
You might try adding a -RUN after each END statement to insure the code runs in the sequence you want.
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats