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]Holding file in memory then report in PDF but report is not displayed
Go
New
Search
Notify
Tools
Reply
  
[CLOSED]Holding file in memory then report in PDF but report is not displayed
 Login/Join
 
Virtuoso
posted
Hi,
I have something strange that I am not able to explain.

I have a single fex that extract several data and hold it in memory (HOLD AS abc). I am holding 4 files.
Then I use those files in a loop to create one PDF report (with OPEN / CLOSE feature) where each HOLD file has its one page on the PDF. So, 4 pages.

When I first run only the part where the data is extracted and hold on disk using APP HOLD, wait for completion, then execute the report part, I have the PDF report has expected.
But if I run the whole fex extract + report as it supposed to be, I have a bunch of crap instead of the PDF result. It's the PDF "code" not formatted such as below sample.

%PDF-1.4 6 0 obj << /Length 7 0 R >> stream BT /F1 1 Tf ET /GS1 gs 0 Tc 0 Tw 0 0 0 rg 0 0 0 RG 0 J 0 j 10.000000 w 10 M []0 d 1 i q 0.050000 0 0 0.050000 0 0 cm q 0 576.00 -576.00 0 936 360 cm /Im1 Do Q BT /F3 1 Tf 0.031373 0.380392 0.290196 rg 0 280 -280 0 860 5709 Tm (Customer Invoicing)Tj /F2 1 Tf 0 200 -200 0 1140 6473 Tm (---------- Up To July 16 ----------)Tj 0 200 -200 0 1400 4394 Tm (Canadian Dollars, Freight Included In Total Cost, Duty Included In Total Cost )Tj /F2 1 Tf 0 140 -140 0 1920 2555 Tm (2019 July)Tj 0 140 -140 0 1920 5422 Tm (2020 July)Tj 0 140 -140 0 1920 8289 Tm (2019)Tj 0 140 -140 0 1920 11156 Tm (2020)Tj ET 0.949020 0.705882 0.341176 rg 


It's like if I need to hold the data on disk, wait few second to let the RS knows that the data exist and then run the PDF report...
It doesn't seems to have any execution error. Detailed execution log doesn't show any...

EXTDATA :      318
SGYTD :       40
TOTSGYTD :        2
SGDATA :       83
SGVAR :       42
0 HOLDING PDF FILE ON PC DISK ...


Any idea of what can cause that ?

Regards,

This message has been edited. Last edited by: MartinY,


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
 
Posts: 2365 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Here a little update :
I have include my fex (where it does everything : HOLD in memory and PDF report) in a schedule and for a reason that I cannot explain it work as expected


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
 
Posts: 2365 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED]Holding file in memory then report in PDF but report is not displayed

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