Focal Point
[CLOSED]Holding file in memory then report in PDF but report is not displayed

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2947039396

July 17, 2020, 09:51 AM
MartinY
[CLOSED]Holding file in memory then report in PDF but report is not displayed
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
July 17, 2020, 02:27 PM
MartinY
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