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 email@example.com for further assistance. Reference the community FAQ to learn more about the community.
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, 2013