Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Can not Run SQL Report from ReportCaster
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Can not Run SQL Report from ReportCaster
 Login/Join
 
Member
posted
Hello,

I have a report running OK from Webfocus Developer Studio. Now, we need to automate the process and need to run from ReportCaster, but I receive an error - Task error: UNRECOGNIZED COMMAND (see below). Can anyone help?

Thanks in advance,

Guang

ReportCaster Log Report Schedule ID: S9609cd0fsc85as4c7asb9f1sd12538ad8c9f, Job Description: ATB Aging - DOMO


Process: J34fddd85j9297j46a5jb884jb7c07bcffeaa
Schedule ID: S9609cd0fsc85as4c7asb9f1sd12538ad8c9f
Start Time: 2020-07-31 14:17:14
End Time: 2020-07-31 14:20:33


Message Code Message Text

BTP1010 Schedule Executed On Demand at diam-webfocus8:8200
BTP1010 Job placed in the waiting queue at 2020-07-31 14:17:14.476-0400 (1,596,219,434,476)
BTP1010 Job started running at 2020-07-31 14:17:14.476-0400 (1,596,219,434,476)
BTP1010 Job remained in waiting queue for 0.0 seconds
BTP1020 Starting task: Task 2
BTP1020 Task type: WebFOCUS Report
BTP1020 Task domain: developm/
BTP1020 Retrieving WebFOCUS Report: IBFS:/WFC/Repository/developm/std_reports/guangliul6gd/Reconcile/atbageOrc.fex
BTP1020 Connecting to server EDA400 with static execution id at 2020-07-31 14:17:14.882-0400 (1,596,219,434,882)
BTP1020 Connection to the Reporting Server EDA400 established at 2020-07-31 14:17:15.178-0400 (1,596,219,435,178)
BTP1020 The time to establish a connection to the Reporting Server EDA400 was 0.296 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 DISTINCT 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/F55110
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.2N = IF RKCRCD EQ 'USD' THEN RKAAP/100 ELSE RKFAP/100;
BTP1020 CURRENCY_CD /A3 = RKCRCD ;
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 AGE1/D16.2 = RKAG1;
BTP1020 AGE2/D16.2 = RKAG2;
BTP1020 AGE3/D16.2 = RKAG3;
BTP1020 AGE4/D16.2 = RKAG4;
BTP1020 AGE5/D16.2 = RKAG5;
BTP1020 CURCC30/D16.2 = RKAA1 * .01;
BTP1020 CC30AG1/D16.2 = RK$AG1 * .01;
BTP1020 CC30AG2/D16.2 = RK$AG2 * .01;
BTP1020 CC30AG3/D16.2 = RK$AG3 * .01;
BTP1020 CC30AG4/D16.2 = RK$AG4 * .01;
BTP1020 CC30AG5/D16.2 = RK$AG5 * .01;
BTP1020 CURPAY/D16.2 = RKAA2/100;
BTP1020 PAYAG1/D16.2 = RK#AG1/100;
BTP1020 PAYAG2/D16.2 = RK#AG2/100;
BTP1020 PAYAG3/D16.2 = RK#AG3/100;
BTP1020 PAYAG4/D16.2 = RK#AG4/100;
BTP1020 PAYAG5/D16.2 = RK#AG5/100;
BTP1020 PRICE/D16.6 = RK$RPC * .000001;
BTP1020 ORKAG/D16.2N = 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 ON TABLE SET BYDISPLAY ON
BTP1020 WHERE OPENAMT NE 0;
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, PAGESIZE='Letter', LEFTMARGIN=0.250000, RIGHTMARGIN=0.250000,
BTP1020 TOPMARGIN=0.250000, BOTTOMMARGIN=0.250000, SQUEEZE=ON,
BTP1020 ORIENTATION=PORTRAIT, $
BTP1020 DEFMACRO=COND0002, MACTYPE=RULE, WHEN=OPENAMT GE 10000, $
BTP1020 DEFMACRO=COND0003, MACTYPE=RULE, WHEN=OPENAMT LE -10000, $
BTP1020 DEFMACRO=COND0004, MACTYPE=RULE, WHEN=OPENAMT LE 0, $
BTP1020 TYPE=DATA, MACRO=COND0002, COLUMN=OPENAMT,
BTP1020 BACKCOLOR=rgb(255 255 0),
BTP1020 TYPE=DATA, MACRO=COND0003, COLUMN=OPENAMT,
BTP1020 COLOR=rgb(255 0 0),
BTP1020 BACKCOLOR=rgb(255 255 0),
BTP1020 TYPE=DATA, MACRO=COND0004, COLUMN=OPENAMT,
BTP1020 COLOR=rgb(255 0 0),
BTP1020 DEFMACRO=COND0001, MACTYPE=RULE, WHEN=N6 LT 0, $
BTP1020 TYPE=REPORT, FONT=TIMES NEW ROMAN, SIZE=10, COLOR=BLACK, BACKCOLOR=NONE,
BTP1020 STYLE=NORMAL, $
BTP1020 TYPE=SUBTOTAL, BY=1, COLOR=RED, MACRO=COND0001, $
BTP1020 ENDSTYLE
BTP1020 END
BTP1020 _______________________________________________________________________________
BTP1020 14.17.15 AE WITH temp AS (SELECT DISTINCT I.ADJID,I.ADJLID,I.FUT3IN AS
BTP1020 14.17.15 AE FCTINV, I.PRCDTE AS FCTIDTE FROM FILCOM/FACTTINV I WHERE EXISTS
BTP1020 14.17.15 AE (SELECT * FROM FILCOM/FACTTIHPF H WHERE H.ADJID=I.ADJID AND
BTP1020 14.17.15 AE H.ADJLID=I.ADJLID AND H.DMATRL BETWEEN 92000000 AND 92999999))
BTP1020 14.17.15 AE SELECT DISTINCT RKAAP, RKCRCD, RKFAP, RKDOC, RKDOCZ, RKAN8,
BTP1020 14.17.15 AE RK$AFL, RKWTXT, RKTXT0, RKDTE0, RKAA, RKAA1, RKAA2, RKAG1,
BTP1020 14.17.15 AE RKAG2, RKAG3, RKAG4, RKAG5, RK$AG1, RK$AG2, RK$AG3, RK$AG4,
BTP1020 14.17.15 AE RK$AG5, RK$RPC, RMISN1, RMISA3, RMISA4, RK$PON, RMISA5, RKAG,
BTP1020 14.17.15 AE RKACR, RKDCT, RKDS20, RKRBOL, RKCLRC, RKAC08, RK$CAB, RKDESN,
BTP1020 14.17.15 AE RKAC06, RKAC04, RKAC07, RKAC09, RKAC10, RKLITM, RKPQOH, RKKCO,
BTP1020 14.17.15 AE RMISA1, RMISA6, RMISA7, RKASN#, RKALPH, RK#AG1, RK#AG2, RK#AG3,
BTP1020 14.17.15 AE RK#AG4, RK#AG5, FCTINV, DATE(SUBSTR( CHAR( DATE('1899-12-31') +
BTP1020 14.17.15 AE INT(RKDTE * 0.001) YEARS + MOD(RKDTE,1000) DAYS ), 1, 10 )) AS
BTP1020 14.17.15 AE ISO_RKDTE, DATE(SUBSTR( CHAR( DATE('1899-12-31') + INT(RKDT1 *
BTP1020 14.17.15 AE 0.001) YEARS + MOD(RKDT1,1000) DAYS ), 1, 10 )) AS ISO_RKDT1,
BTP1020 14.17.15 AE DATE(SUBSTR( CHAR( DATE('1899-12-31') + INT(RKDIVJ * 0.001)
BTP1020 14.17.15 AE YEARS + MOD(RKDIVJ,1000) DAYS ), 1, 10 )) AS ISO_RKDIVJ FROM
BTP1020 14.17.15 AE NDSPRDFIL/F55110 LEFT OUTER JOIN temp ON RKDOC=FCTINV AND
BTP1020 14.17.15 AE RKDIVJ = DECIMAL((YEAR(FCTIDTE) - 1900) * 1000 +
BTP1020 14.17.15 AE DAYOFYEAR(FCTIDTE), 6);
BTP1020 SET DISTRIBUTE=OFF
BTP1020 Connection to the Reporting Server EDA400 closed at 2020-07-31 14:20:33.326-0400 (1,596,219,633,326)
BTP1020 Job ran on the Reporting Server EDA400 for 198.148 seconds
BTP1020 Task error: UNRECOGNIZED COMMAND
BTP1010 No report to distribute.
BTP1010 Job finished at 2020-07-31 14:20:33.468-0400 (1,596,219,633,468)
BTP1010 Job time on distribution server after the report completed was 0.0 seconds
BTP1010 Total running time was 198.992 seconds
BTP1010 Total elapsed time (including the queue time) was 198.992 seconds

This message has been edited. Last edited by: FP Mod Chuck,
 
Posts: 29 | Registered: April 16, 2012Reply With QuoteReport This Post
Gold member
posted Hide Post
The message "unrecognized command" usually means that you forgot to end a previous command properly.

First troubleshooting step would be to verify if you terminated the syntax appropriately.


WebFOCUS 8
Windows, All Outputs
 
Posts: 70 | Registered: May 26, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Guang

Newbee has a good suggestion. What I see is that this fex has a -SET &ECHO=ALL; at the beginning and SQL Trace statements as well.
SET TRACEOFF=ALL
SET TRACEON=STMTRACE//CLIENT
SET TRACEUSER = ON
Those should only be used for debugging issues and removed when done as traces cause overhead that slows the report down but does not cause the error you are getting.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2046 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Member
posted Hide Post
Guang,

Not sure if this is the Reason but it seems you are missing a sime-colon (Wink at the end of your SQL Passthru request (before the line END)

ENGINE DB2 SET DEFAULT_CONNECTION CON01
WITH temp AS (SELECT DISTINCT I.ADJID,I.ADJLID,I.FUT3IN AS FCTINV,
I.PRCDTE AS FCTIDTE FROM FILCOM/FACTTINV I
WHERE EXISTS (SELECT * FROM FILCOM/FACTTIHPF H WHERE H.ADJID=I.ADJID AND
H.ADJLID=I.ADJLID AND H.DMATRL BETWEEN 92000000 AND 92999999))
SELECT DISTINCT RKAAP, RKCRCD, RKFAP, RKDOC, RKDOCZ, RKAN8, RK$AFL,
RKWTXT, RKTXT0, RKDTE0, RKAA, RKAA1, RKAA2, RKAG1, RKAG2, RKAG3, RKAG4, RKAG5,
RK$AG1, RK$AG2, RK$AG3, RK$AG4, RK$AG5, RK$RPC, RMISN1, RMISA3, RMISA4, RK$PON,
RMISA5, RKAG, RKACR, RKDCT, RKDS20, RKRBOL, RKCLRC, RKAC08,
RK$CAB, RKDESN, RKAC06, RKAC04, RKAC07, RKAC09, RKAC10, RKLITM, RKPQOH, RKKCO, RMISA1,
RMISA6, RMISA7, RKASN#, RKALPH, RK#AG1, RK#AG2, RK#AG3, RK#AG4, RK#AG5, FCTINV,
DATE(SUBSTR( CHAR( DATE('1899-12-31') +
INT(RKDTE * 0.001) YEARS +
MOD(RKDTE,1000) DAYS ), 1, 10 )) AS ISO_RKDTE,
DATE(SUBSTR( CHAR( DATE('1899-12-31') +
INT(RKDT1 * 0.001) YEARS +
MOD(RKDT1,1000) DAYS ), 1, 10 )) AS ISO_RKDT1,
DATE(SUBSTR( CHAR( DATE('1899-12-31') +
INT(RKDIVJ * 0.001) YEARS +
MOD(RKDIVJ,1000) DAYS ), 1, 10 )) AS ISO_RKDIVJ
FROM NDSPRDFIL/F55110
LEFT OUTER JOIN temp ON RKDOC=FCTINV
AND RKDIVJ = DECIMAL((YEAR(FCTIDTE) - 1900) * 1000 +
DAYOFYEAR(FCTIDTE), 6) ;
END
  
 
Posts: 16 | Location: Information Builders France | Registered: May 22, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Can not Run SQL Report from ReportCaster

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.