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     [SOLVED] (foc822) offline-fmt REPORT CASTER
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] (foc822) offline-fmt REPORT CASTER
 Login/Join
 
Platinum Member
posted
Hi,

I want to create a Report Caster Job.
The Fex I am using works with no Errors - when I now use it in my Report Caster Job (nothing Special, normal Distribution to my Mail)
I get the Error:
(FOC822) VALID VALUES ARE OFFLINE-FMT=OFF ALPHA STANDARD POSTSCRIPT HTML DHTML PDF PPT XMLR EXL97 EXL2K EXL07 AHTML AFSWF APDF

I already tried to insert:
ON TABLE SET ONLINE-FMT EXL07
with or without
ON TABLE PCHOLD FORMAT EXL07

but there is no difference.

I really have no ideas how to solve this Problem.. and so far, it never appeared...

Thanks for your help.
Regards

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


WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 177 | Registered: October 17, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Can you show us a simplified example of the fex? Are you using -HTMLFORM in your code? Are you trying to combine a bunch of TABLE request into one output?


WebFOCUS 8206, Unix, Windows
 
Posts: 1784 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Master
posted Hide Post
Just curious as to why you are using ONLINE-FMT. It sets the format of the report just as ON TABLE PCHOLD FORMAT EXL07 does. So why do you need it? In your Report Caster job, have you tried to override the format. With Report Caster we always override the format. mostly because almost everything we generate is XLSX with an EXCEL template file.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 949 | Location: Oklahoma City | Registered: October 27, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
@BabakNYC: Yes, have a look:

SET NODATA = ''
-*DAMIT EINE NULL VORRAN STEHT
SET CENT-ZERO=ON
SET &ECHO = ALL;

ENGINE SQLORA SET DEFAULT_CONNECTION ARS
SQL SQLORA PREPARE SQLOUT FOR

...very Long SQL which works

END

DEFINE FILE SQLOUT
WAI_PFLICHTIG/I1 = WAI_PFLICHTIG;
KVG_ID/I2 = KVG_ID;

MYFORMAT/A8 = DECODE ASSETTYP ('Spezial-Fonds' 'D12.4' ELSE 'D12.2');

-*MYFORMAT_BIB_OGC_EA/A8 = DECODE BIB_OGC_EA ('0' 'I4' ELSE MYFORMAT);
MYFORMAT_BIB_OGC_EA/A8 = IF BIB_OGC_EA EQ 0 THEN 'I3'
ELSE IF ASSETTYP EQ 'Spezial-Fonds' AND BIB_OGC_EA NE 0 THEN 'D12.4'
ELSE 'D12.2';
-*MYFORMAT_MIFID_TRX_EA/A8 = DECODE MIFID_TRX_EA ('0' 'I4' ELSE MYFORMAT);
MYFORMAT_MIFID_TRX_EA/A8 = IF MIFID_TRX_EA EQ 0 THEN 'I3'
ELSE IF ASSETTYP EQ 'Spezial-Fonds' AND MIFID_TRX_EA NE 0 THEN 'D12.4'
ELSE 'D12.2';
-*MYFORMAT_BIB_EBV_EA/A8 = DECODE BIB_EBV_EA ('0' 'I4' ELSE MYFORMAT);
MYFORMAT_BIB_EBV_EA/A8 = IF BIB_EBV_EA EQ 0 THEN 'I3'
ELSE IF ASSETTYP EQ 'Spezial-Fonds' AND BIB_EBV_EA NE 0 THEN 'D12.4'
ELSE 'D12.2';
-*MYFORMAT_RA/A8 = DECODE RA ('0' 'I4' ELSE MYFORMAT);
MYFORMAT_RA/A8 = IF RA EQ 0 THEN 'I3'
ELSE IF ASSETTYP EQ 'Spezial-Fonds' AND RA NE 0 THEN 'D12.4'
ELSE 'D12.2';
-*MYFORMAT_AA/A8 = DECODE AA ('0' 'I4' ELSE MYFORMAT);
MYFORMAT_AA/A8 = IF AA EQ 0 THEN 'I3'
ELSE IF ASSETTYP EQ 'Spezial-Fonds' AND AA NE 0 THEN 'D12.4'
ELSE 'D12.2';
-*MYFORMAT_EX_ANTE_KOSTEN/A8 = DECODE EX_ANTE_KOSTEN ('0' 'I4' ELSE MYFORMAT);
MYFORMAT_EX_ANTE_KOSTEN/A8 = IF EX_ANTE_KOSTEN EQ 0 THEN 'I3'
ELSE IF ASSETTYP EQ 'Spezial-Fonds' AND EX_ANTE_KOSTEN NE 0 THEN 'D12.4'
ELSE 'D12.2';

LIEFERDATUM/D.M.YY = HDATE(LIEFERDATUM, 'DMYY');
AUFLEGUNGSDATUM/D.M.YY = HDATE(AUFLEGUNGSDATUM, 'DMYY');
END


TABLE FILE SQLOUT
PRINT
ISIN AS 'ISIN'
LIEFERDATUM AS 'Lieferdatum'
AUFLEGUNGSDATUM AS 'Auflegungsdatum'
GESCHAEFTSJAHR AS 'Geschaeftsjahr'
PRODUKTNAME AS 'PRODUKTNAME'
WAI_PFLICHTIG AS 'WAI-pflichtig'
PRODUKTMANAGER AS 'Produktmanager'
VERTRETER AS 'Vertreter'
ERTRAGSVERWENDUNG AS 'Ertragsverwendung'
FONDSWAEHRUNG AS 'Fondswaehrung'
RECHTSFORM_GROB AS 'Rechtsfrom_grob'
KVG_ID AS 'KVG_ID'
KVG AS 'KVG'
VERWAHRSTELLE AS 'Verwahrstelle'
PRODUKTGENEHMIGUNGSSTATUS AS 'PRODUKTGENEHMIGUNGSSTATUS'
PRIIP_DATENSICHT AS 'PRIIP_DATENSICHT'
ASSETTYP AS 'Assettyp'
INSTI_ÜBERWACHUNG/I3 AS 'INSTI_UEBERWACHUNG'
BIB_OGC_EA/MYFORMAT_BIB_OGC_EA AS 'BIB_OGC_EA'
MIFID_TRX_EA/MYFORMAT_MIFID_TRX_EA AS 'MIFIF_TRX_EA'
BIB_EBV_EA/MYFORMAT_BIB_EBV_EA AS 'BIB_EBV_EA'
RA/MYFORMAT_RA AS 'RA_Ruecknahmeabschlag'
AA/MYFORMAT_AA AS 'AA_Ausgabeaufschlag'
EX_ANTE_KOSTEN/MYFORMAT_EX_ANTE_KOSTEN AS 'Ex_Ante_Kosten'

ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT XLSX
-*ON TABLE SET XLSXPAGESETS ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
ENDSTYLE
END
-*SPÄTER ABLEGEN AUF I:\AMK_63\Weitere\63_Transfer_61\WebFocus\Zielmarkt
-*SOLL Kosten_komplett.xlsx HEISSEN


@jgelona: I am not using it, the error appears the first time today, while it worked great before... and just appears in the Report Caster.


WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 177 | Registered: October 17, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
First, add a - on the line where you have SET &ECHO=ALL? It should read -SET &ECHO=ALL; Test your scheduled job again.

Then, as a diagnostic test comment out all the SET commands both at the top and inside the fex (ON TABLE SET) and try this again.

Also, is this a new scheduled report or did you have a working scheduled report that stopped? If it's the latter, what might have changed?


WebFOCUS 8206, Unix, Windows
 
Posts: 1784 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Platinum Member
posted Hide Post
That's the Point, nothing has changed.. but I try..


WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 177 | Registered: October 17, 2017Reply With QuoteReport This Post
Platinum Member
posted Hide Post
... it has been the - ...

THANKS a lot !!!!!!!


WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 177 | Registered: October 17, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Fantastisch!

Now as an explanation of why you could run this live but were getting the error in Scheduler try this example:

 
SET &ECHO=ALL;
TABLE FILE CAR
PRINT CAR BY COUNTRY
END 


You'll see that you get the report you were expecting. However, if you right click and view source in the browser, you'll see this:

 
(FOC822) VALID VALUES ARE OFFLINE-FMT=OFF ALPHA STANDARD POSTSCRIPT HTML DHTML PDF PPT XMLR EXL97 EXL2K EXL07 AHTML AFSWF APDF
0 NUMBER OF RECORDS IN TABLE=       10  LINES=     10
0 HOLDING HTML FILE ON PC DISK ...
 


So, it seems like scheduler is less forgiving, which is why the FOC822 is visible in your log file.


WebFOCUS 8206, Unix, Windows
 
Posts: 1784 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] (foc822) offline-fmt REPORT CASTER

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