Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Can not Send out a Report in Report Caster

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Can not Send out a Report in Report Caster
 Login/Join
 
Member
posted
Hello,

I can run the report in the Develop Studio, but the report can not be sent from the Report Caster. Below is the job log (see the message at the bottom). We are running on Webfocus V8.

Can someone help to figure out the reason?

Thanks,

BTP1010 Schedule Executed On Demand at diam-webfocus8:8200
BTP1010 Job placed in the waiting queue at 2020-03-30 14:32:50.413-0400 (1,585,593,170,413)
BTP1010 Job started running at 2020-03-30 14:32:50.414-0400 (1,585,593,170,414)
BTP1010 Job remained in waiting queue for 0.0010 seconds
BTP1020 Starting task: Task 12
BTP1020 Task type: WebFOCUS Report
BTP1020 Task domain: developm/
BTP1020 Retrieving WebFOCUS Report: IBFS:/WFC/Repository/developm/std_reports/guangliul6gd/GFAST_GO_LIVE/ATBdailyOrc_TOY.fex
BTP1020 Connecting to server EDA400 with static execution id at 2020-03-30 14:32:50.646-0400 (1,585,593,170,646)
BTP1020 Connection to the Reporting Server EDA400 established at 2020-03-30 14:32:50.978-0400 (1,585,593,170,978)
BTP1020 The time to establish a connection to the Reporting Server EDA400 was 0.332 seconds
BTP1020 Executing focexec.
BTP1020 SET TRACEOFF=ALL;
BTP1020 SET TRACEON=STMTRACE//CLIENT
BTP1020 SET TRACEUSER = ON
BTP1020 ENGINE DB2 SET DEFAULT_CONNECTION CON01
BTP1020 SQL DB2 PREPARE SQLOUT FOR
BTP1020 WITH temp AS (SELECT DISTINCT I.ADJID,I.ADJLID,I.FUT3IN AS FCTINV,
BTP1020 I.PRCDTE AS FCTIDTE FROM FILCOM/FACTTINV I
BTP1020 WHERE EXISTS (SELECT * FROM FILCOM/FACTTIHPF H WHERE H.ADJID=I.ADJID AND
BTP1020 H.ADJLID=I.ADJLID AND H.DMATRL BETWEEN 92000000 AND 92999999))
BTP1020 SELECT RKAAP, RKCRCD, RKFAP, RKDOC, RKDOCZ, RKAN8, RK$AFL,
BTP1020 RKWTXT, RKTXT0, RKDTE0, RKAA, RKAA1, RKAA2, RKAG1, RKAG2, RKAG3, RKAG4, RKAG5,
BTP1020 RK$AG1, RK$AG2, RK$AG3, RK$AG4, RK$AG5, RK$RPC, RMISN1, RMISA3, RMISA4, RK$PON,
BTP1020 RMISA5, RKAG, RKACR, RKDCT, RKDS20, RKRBOL, RKCLRC, RKAC08,
BTP1020 RK$CAB, RKDESN, RKAC06, RKAC04, RKAC07, RKAC09, RKAC10, RKLITM, RKPQOH, RKKCO, RMISA1,
BTP1020 RMISA6, RMISA7, RKASN#, RKALPH, RK#AG1, RK#AG2, RK#AG3, RK#AG4, RK#AG5, FCTINV,
BTP1020 DATE(SUBSTR( CHAR( DATE('1899-12-31') +
BTP1020 INT(RKDTE * 0.001) YEARS +
BTP1020 MOD(RKDTE,1000) DAYS ), 1, 10 )) AS ISO_RKDTE,
BTP1020 DATE(SUBSTR( CHAR( DATE('1899-12-31') +
BTP1020 INT(RKDT1 * 0.001) YEARS +
BTP1020 MOD(RKDT1,1000) DAYS ), 1, 10 )) AS ISO_RKDT1,
BTP1020 DATE(SUBSTR( CHAR( DATE('1899-12-31') +
BTP1020 INT(RKDIVJ * 0.001) YEARS +
BTP1020 MOD(RKDIVJ,1000) DAYS ), 1, 10 )) AS ISO_RKDIVJ
BTP1020 FROM NDSPRDFIL/F55110B
BTP1020 LEFT OUTER JOIN temp ON RKDOC=FCTINV
BTP1020 AND RKDIVJ = DECIMAL((YEAR(FCTIDTE) - 1900) * 1000 +
BTP1020 DAYOFYEAR(FCTIDTE), 6)
BTP1020 END
BTP1020 DEFINE FILE SQLOUT
BTP1020 OPENAMT /D12.2 = RKAAP/100;
BTP1020 CURRENCY_CD /A3 = 'USD';
BTP1020 INVOICENUMB /I8 = RKDOC;
BTP1020 ORDERNUMB /I8 = RKDOCZ;
BTP1020 CUSTNUMB /I8 = RKAN8;
BTP1020 NEW_CO /A2 = RK$AFL;
BTP1020 REMARK/A161 = RKWTXT || ' ' | RKTXT0;
BTP1020 SORTAMT /I1 = IF OPENAMT EQ 0 THEN 1 ELSE 0;
BTP1020 NEWSHPD /I8YYMD = IF RKDTE0 EQ 0 THEN ISO_RKDIVJ ELSE RKDTE0;
BTP1020 CURAGE/D16.2 = RKAA;
BTP1020 PRICE/D16.6 = RK$RPC * .000001;
BTP1020 PAYAG1/P17.2C = RK#AG1/100;
BTP1020 PAYAG2/P17.2C = RK#AG2/100;
BTP1020 PAYAG3/P17.2C = RK#AG3/100;
BTP1020 PAYAG4/P17.2C = RK#AG4/100;
BTP1020 PAYAG5/P17.2C = RK#AG5/100;
BTP1020 CURPAY/D16.2 = RKAA2/100;
BTP1020 ORKAG/P17.2C = RKAG / 100 ;
BTP1020 ORKACR/D16.2N = RKACR / 100 ;
BTP1020 FCUROAMT/D16.2N = RKFAP / 100 ;
BTP1020 INVDATE /I8YYMD = ISO_RKDIVJ ;
BTP1020 INVNOA /A8 = EDIT(INVOICENUMB);
BTP1020 INVNOAT / A8 = TRIM('L', INVNOA, 8, '0', 1, 'A8') ;
BTP1020 ORATRN# /A20 = INVNOAT || '-' || EDIT(INVDATE) ;
BTP1020 ORCTRN/A20 = IF RKDOC GE 97000000 AND RKDOC LE 97999999 THEN RMISA3 ELSE
BTP1020 IF (RKDOC GE 92000000 AND RKDOC LE 92999999) OR (RKDOC EQ FCTINV) THEN INVNOAT ELSE
BTP1020 IF RKDOC GT 0 AND RKDOC LT 92000000 THEN ORATRN# ELSE ' ' ;
BTP1020 ORCSRC/A20 = IF RKDOC GE 97000000 AND RKDOC LE 97999999 THEN 'Unapplied Cash' ELSE
BTP1020 IF (RKDOC GE 92000000 AND RKDOC LE 92999999) OR (RKDOC EQ FCTINV) THEN 'GL Suspense' ELSE
BTP1020 IF RKDOC GT 0 AND RKDOC LT 92000000 THEN 'Invoice' ELSE ' ' ;
BTP1020 END
BTP1020 TABLE FILE SQLOUT
BTP1020 PRINT
BTP1020 RMISN1 AS 'Previous Slip,Number'
BTP1020 ORCTRN AS 'Oracle Transaction,Number'
BTP1020 ORCSRC AS 'Oracle Source'
BTP1020 RK$PON AS 'P.O. No.'
BTP1020 CURRENCY_CD AS 'Accounted,Currency'
BTP1020 ORKAG AS 'Org. Dom. Inv. Amt.'
BTP1020 RMISA5 AS 'Transacted,Currency'
BTP1020 ORKACR AS 'Org. For. Inv. Amt.'
BTP1020 RKDCT AS 'Doc. Type'
BTP1020 ORDERNUMB AS 'Plant,Inv.'
BTP1020 NEWSHPD AS 'Ship,Date'
BTP1020 ISO_RKDTE AS 'Due Code,Due Date'
BTP1020 ISO_RKDT1 AS 'Payment,Term Date'
BTP1020 RKDS20 AS 'Pymt. Ref.'
BTP1020 RKRBOL AS 'BOL,Number'
BTP1020 RKCLRC AS 'Col. Rsn. Cd.'
BTP1020 REMARK AS 'Remark'
BTP1020 OPENAMT AS 'Open Amt. in USD'
BTP1020 FCUROAMT AS 'Open Amt. in FX'
BTP1020 CURPAY AS 'Open Amt - Payment Terms Current'
BTP1020 PAYAG1 AS 'Open Amt - Payment Terms 01 - 30'
BTP1020 PAYAG2 AS 'Open Amt - Payment Terms 31 - 60'
BTP1020 PAYAG3 AS 'Open Amt - Payment Terms 61 - 90'
BTP1020 PAYAG4 AS 'Open Amt - Payment Terms 91 - 120'
BTP1020 PAYAG5 AS 'Open Amt - Payment Terms Over 120'
BTP1020 RKAC08 AS 'Bus. Type'
BTP1020 RK$CAB AS 'Cust. Abbr.'
BTP1020 RKDESN AS 'Dest. Abbr.'
BTP1020 RKAC06 AS 'Tier1 Group'
BTP1020 RKAC04 AS 'Cust. Group'
BTP1020 RKAC07 AS 'Int./Ext.'
BTP1020 RKAC09 AS 'Reclaim'
BTP1020 RKAC10 AS 'Disputed,Item'
BTP1020 BY RKKCO AS 'Co. No.'
BTP1020 BY RMISA1 AS 'InterCompany'
BTP1020 BY NEW_CO AS 'AF Code'
BTP1020 BY RMISA6 AS 'Customer,Account,Number'
BTP1020 BY RMISA7 AS 'Customer,Account,Name'
BTP1020 BY CUSTNUMB AS 'Customer Site,Number'
BTP1020 BY RKASN# AS 'Customer,Rep#'
BTP1020 BY RKALPH AS 'Customer Site,Name'
BTP1020 BY INVOICENUMB AS 'Inv. No.'
BTP1020 BY ISO_RKDIVJ AS 'Inv. Date'
BTP1020 BY SORTAMT NOPRINT
BTP1020 HEADING
BTP1020 "Page BTP1020 WHERE OPENAMT NE 0;
BTP1020 WHERE RKAC06 EQ 'TOY';
BTP1020 ON TABLE SET PAGE-NUM OFF
BTP1020 ON TABLE SET BYDISPLAY ON
BTP1020 ON TABLE NOTOTAL
BTP1020 ON TABLE PCHOLD FORMAT XLSX
BTP1020 ON TABLE SET STYLE *
BTP1020 UNITS=IN,
BTP1020 PAGESIZE='Letter',
BTP1020 LEFTMARGIN=0.250000,
BTP1020 RIGHTMARGIN=0.250000,
BTP1020 TOPMARGIN=0.250000,
BTP1020 BOTTOMMARGIN=0.250000,
BTP1020 SQUEEZE=ON,
BTP1020 ORIENTATION=PORTRAIT,
BTP1020 DEFMACRO=COND0002,
BTP1020 MACTYPE=RULE,
BTP1020 WHEN=N29 GE 10000,
BTP1020 DEFMACRO=COND0003,
BTP1020 MACTYPE=RULE,
BTP1020 WHEN=N29 LE -10000,
BTP1020 DEFMACRO=COND0004,
BTP1020 MACTYPE=RULE,
BTP1020 WHEN=N29 LE 0,
BTP1020 TYPE=REPORT,
BTP1020 FONT='TIMES NEW ROMAN',
BTP1020 TYPE=DATA,
BTP1020 COLUMN=N23,
BTP1020 BACKCOLOR='NONE',
BTP1020 MACRO=COND0002,
BTP1020 TYPE=DATA,
BTP1020 COLUMN=N29,
BTP1020 BACKCOLOR='YELLOW',
BTP1020 MACRO=COND0002,
BTP1020 TYPE=DATA,
BTP1020 COLUMN=N29,
BTP1020 COLOR='RED',
BTP1020 BACKCOLOR='YELLOW',
BTP1020 MACRO=COND0003,
BTP1020 TYPE=DATA,
BTP1020 COLUMN=N29,
BTP1020 COLOR='RED',
BTP1020 MACRO=COND0004,
BTP1020 TYPE=TITLE,
BTP1020 COLUMN=N23,
BTP1020 BACKCOLOR='NONE',
BTP1020 MACRO=COND0002,
BTP1020 ENDSTYLE
BTP1020 END
BTP1020 14.32.51 AE WITH temp AS (SELECT DISTINCT I.ADJID,I.ADJLID,I.FUT3IN AS
BTP1020 14.32.51 AE FCTINV, I.PRCDTE AS FCTIDTE FROM FILCOM/FACTTINV I WHERE EXISTS
BTP1020 14.32.51 AE (SELECT * FROM FILCOM/FACTTIHPF H WHERE H.ADJID=I.ADJID AND
BTP1020 14.32.51 AE H.ADJLID=I.ADJLID AND H.DMATRL BETWEEN 92000000 AND 92999999))
BTP1020 14.32.51 AE SELECT RKAAP, RKCRCD, RKFAP, RKDOC, RKDOCZ, RKAN8, RK$AFL,
BTP1020 14.32.51 AE RKWTXT, RKTXT0, RKDTE0, RKAA, RKAA1, RKAA2, RKAG1, RKAG2, RKAG3,
BTP1020 14.32.51 AE RKAG4, RKAG5, RK$AG1, RK$AG2, RK$AG3, RK$AG4, RK$AG5, RK$RPC,
BTP1020 14.32.51 AE RMISN1, RMISA3, RMISA4, RK$PON, RMISA5, RKAG, RKACR, RKDCT,
BTP1020 14.32.51 AE RKDS20, RKRBOL, RKCLRC, RKAC08, RK$CAB, RKDESN, RKAC06, RKAC04,
BTP1020 14.32.51 AE RKAC07, RKAC09, RKAC10, RKLITM, RKPQOH, RKKCO, RMISA1, RMISA6,
BTP1020 14.32.51 AE RMISA7, RKASN#, RKALPH, RK#AG1, RK#AG2, RK#AG3, RK#AG4, RK#AG5,
BTP1020 14.32.51 AE FCTINV, DATE(SUBSTR( CHAR( DATE('1899-12-31') + INT(RKDTE *
BTP1020 14.32.51 AE 0.001) YEARS + MOD(RKDTE,1000) DAYS ), 1, 10 )) AS ISO_RKDTE,
BTP1020 14.32.51 AE DATE(SUBSTR( CHAR( DATE('1899-12-31') + INT(RKDT1 * 0.001)
BTP1020 14.32.51 AE YEARS + MOD(RKDT1,1000) DAYS ), 1, 10 )) AS ISO_RKDT1,
BTP1020 14.32.51 AE DATE(SUBSTR( CHAR( DATE('1899-12-31') + INT(RKDIVJ * 0.001)
BTP1020 14.32.51 AE YEARS + MOD(RKDIVJ,1000) DAYS ), 1, 10 )) AS ISO_RKDIVJ FROM
BTP1020 14.32.51 AE NDSPRDFIL/F55110B LEFT OUTER JOIN temp ON RKDOC=FCTINV AND
BTP1020 14.32.51 AE RKDIVJ = DECIMAL((YEAR(FCTIDTE) - 1900) * 1000 +
BTP1020 14.32.51 AE DAYOFYEAR(FCTIDTE), 6);
BTP1020 0 HOLDING XLSX FILE ON PC DISK ...
BTP1020 SET DISTRIBUTE=OFF
BTP1020 Connection to the Reporting Server EDA400 closed at 2020-03-30 14:36:34.022-0400 (1,585,593,394,022)
BTP1020 Job ran on the Reporting Server EDA400 for 223.044 seconds
BTP1020 Task finished.
BTP1010 ATBdailyOrc_TOY.xlsx unable to distribute to cynthia.marchetti@na.denso.com
BTP1010 ATBdailyOrc_TOY.xlsx unable to distribute to guang.liu@na.denso.com
BTP1010 ATBdailyOrc_TOY.xlsx unable to distribute to danielle.bresette@na.denso.com
BTP1010 Job finished at 2020-03-30 14:36:35.554-0400 (1,585,593,395,554)
BTP1010 Job time on distribution server after the report completed was 1.385 seconds
BTP1010 Total running time was 225.14 seconds
BTP1010 Total elapsed time (including the queue time) was 225.141 seconds

This message has been edited. Last edited by: FP Mod Chuck,
 
Posts: 29 | Registered: April 16, 2012Report This Post
Virtuoso
posted Hide Post
Guang

I am pretty sure this line of code is preventing it. SET DISTRIBUTE=OFF


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2128 | Location: Customer Support | Registered: April 12, 2005Report This Post
Guru
posted Hide Post
Check your fex, from the log it appears that the HEADING is missing the ending double quote.

quote:
BTP1020 HEADING
BTP1020 "Page BTP1020 WHERE OPENAMT NE 0;
BTP1020 WHERE RKAC06 EQ 'TOY';


Alternatively, try changing the output to HTML or PDF to see if that works.

Also check your Reporting Server edaprint log for error messages at the time you ran the schedule

Cheers

Stu


WebFOCUS 8.2.03 (8.2.06 in testing)
 
Posts: 253 | Location: Melbourne, Australia | Registered: February 07, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Can not Send out a Report in Report Caster

Copyright © 1996-2020 Information Builders