Spool File Download Fails from Email Report Server - Trace point: 1420

From Support

If you have a question or seek clarification, please call Technical Support.

Problem:

Spool File Download Fails from Email Report Server - Trace point: 1420

Sample error log from Email Report Server:

ERROR: Spool File OUTALL Job: (426746/BONNIE/BFAULK/#445) download to PC File C:\WSPESR32\REPORT.TMP ended abnormally. 12/3/99, 6:29:01 PM Trace Point:1420 INFO: Return spool to original queue command: WSPHOLD FILE(OUTALL) FORMTYPE('*STD') JOB(426746/BONNIE/BFAULK) SPLNBR(445) OUTQ(QGPL/REPORTS) 12/3/99, 6:29:01 PM Trace Point:1420

Solution:

Things to check: Does this same report get stuck each time or does it eventually go ? You might want to turn on the "Generate Joblog After Each TCP/IP Pass" setting. This will create a QPJOBLOG spool file after each pass that should show any errors that occurred during processing. This will help you visually troubleshoot the problem. If a report download fails, it's usually a security related issue. The problem could be one of the following:

1. The spool file is an AFP or other style of spool file. These do not copy via the CPYSPLF command. Can you manually download the report with WinSpool/400 ?

2. The user ID for the Email Report Server may not have *SPLCTL authority ?

3. The user ID may have limited capabilities ?

4. The FTP Server Timeout may be need to set higher depending on the report size. Use the CHGFTPA INACTTIMO(0) command to change the FTP Server timeout to 0 seconds. Then use the ENDTCPSVR *FTP and then the STRTCPSVR *FTP commands to reset the FTP Server.

5. Was the report still spooling when we attempted to download it ? This can cause a problem because reports can't be copied while being spooled.