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.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


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

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[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: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report 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: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report 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]Holding file in memory then report in PDF but report is not displayed

Copyright © 1996-2020 Information Builders