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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
I am trying to bring two process together. The run button should be generating two FOCUS files but for some reason the first one disappears when the second is created...both are called via a single run button on an html file.This message has been edited. Last edited by: FP Mod Chuck,
The single HTML page in which the two fexes run need to have two iFrames, one for the display of the results for each fex. The run button would execute each of the two fexes separately (Tasks and Annimations), one in each of the two iFrames.
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005
1) Create an HTML page that prompts user for Fiscal Year and as of Period. User hits blue arrow, 2 FOCUS tables should be built for later use. The user then presses a second button that jumps to a new HTML page for further processing/options/reporting.
Most of our reporting works this way. This is however the first time 2 FOCUS files are created..at once ...usually it is just 1.
1) Started with a Blank HTML page..no template used.
2) Clicked: Insert then New Report then drew a box that should eventually show the outcome of the fex - likely ending with the number of lines written to FOCUS file. I referenced my fex. Upon doing this it auto creates parameters fro FY and Period as well as creating the blue arrow run button.
3) Repeated step 2 for my second fex. Since the parameter names are the same (FY and Period) it uses the parameters already created.
4) I checked the little blue arrow propeties- both fexes are now listed.
5) I run the HTTML page. Fex 2 takes about 15 seconds to run. While it is running I am able to verify it was created since I can add a procedure to reference it and report the contents before fex 1 finishes.
Eventually (2 minutes) fex1 comlpetes. At this point I see the fex 1 FOCUS file but the fex 2 focus file is gone.
Here are the lines of code in each fex:
APP HOLD foccache ON TABLE HOLD AS HOLDDTLS FORMAT FOCUS
APP HOLD foccache ON TABLE HOLD AS HOLDFINDB_ALLDATASETS_FINAL2 FORMAT FOCUS
If I run these fexes independently (double click fex name) they each create their respective hold files without issue.
I am not sure what you mean by iframes...is this the box I drew that houses the outcome of each fex.
Here is the thing....We have dashboards that populate reports/graphs etc in this manner. They each have exactly the same prompts. The user hits ONE button...everything runs at once and populates. The difference seem to be, in those cases, traditional HOLD files are used..not FOCUS files.
I just did a test. Same HTML set up but I made 2 little blue arrow run buttons. The first runs fex 1. The second runs fex 2. I press button one, wait 2 minutes till it finishes then press button 2 wait for fex 2 to finish a few seconds later...I have my two FOCUS files.
I exit 100% out of WF and go back in... If I run button two first then wait and run button 1..it still works.
When I press both buttons at the same time..each runs but I do not get the HOLD file that should have finished first....when I look in Foccache its there but as soon as the other FOCUS file is written it disappears.
I tried writing the second file to foc_meta..so now I have one going to foccache and one to foc-meata and it seems to work...still testing...however I have no idea the implications of writing to foc-meta..never did that before.
well, I tried to create a foccache2 folder. However I have had mixed results. The file does not seem to go away once I log off like regular foccache. Further is does not refresh.
Foc-meta still works. I am just not sure the ***ramifications*** of using it.
I need to make this a FOCUS file so it does not disappear as the user pops from screen to screen, form to form, running different reports and fexes. This is how we were taught. If everything is self contained in one html page, one report etc..regular hold files work well.
The real question is, why, when you try to build 2 differently named focus files CONCURRENLT does the first one written disappear as the subsequent one is created. Sound like another WF8008 bug...
Again, if there are no run concurrently, there is no issue.
Let's start with a question: Can you find the missing HOLD file in another foccache directory perhaps?
If the answer is yes, then you are dealing with 2 separate sessions. That probably means that at the start of either of your two fexes, no session had been started yet. As a consequence, each fex starts a new session separately.
You may be able to start a session before that by explicitly starting a fex, for example to display your form, so that everything is part of the same session.
I've never received a good answer from IBI about when a session starts. That is relevant for cases like these.This message has been edited. Last edited by: Wep5622,
WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010 : Member of User Group Benelux :
Interesting today, two us started looking at this again. Suddenly it works. 4 times in a row!..then the one file did no seem to get replaced, it remained and older vintage..like it did not refresh.... Then at one point it behaved like yesterday, ie the file was created but deleted just as the second completed.