Focal Point
[CASE-OPENED] Multi-FOCCACHE Creation at the same time and session issue.

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

July 15, 2015, 02:37 PM
GavinL
[CASE-OPENED] Multi-FOCCACHE Creation at the same time and session issue.
SCENARIO:
1 HTML Page
4 iFrames
1 Fex per iframe.

Each Fex, creates a FOCCACHE file, but is not the same FOCCACHE file.

Each fex starts out like the following, but each with their own foccache DB name.

CHECK FILE FOCCACHE/<FexDBName>
-RUN
-IF &LINES GT 0 THEN GOTO CHECKRECEXIST;


I think we have two issues..
1. The first Fex that is called, starts creating a new FOCCACHE, lets call it FOC1, because it doesn't exist. The other 3 think their foccache file already exists, even though it doesn't. HUH!!?

2. After we traced through it, we found that each iFrame is creating it's own session, so the next time, it refreshes, it's creating all new sessions again, which means we lose the FOCCACHE and we get an error on the next display page that pulls from the foccache. Reason we load it on one, is because we have the requirement to put a PLEASE WAIT message, while they are being loaded.

REASON:
I know you might be asking why.. We need multi-threaded calls to pull data from 4 different synonyms. When we do this as a synchronous call, it takes up 30 seconds to load up up them all. When we called them like this it was taking 6 to 7 seconds to load the page.. Still not a good response time, but the lack of speed is coming from HIVE2 side and different group, which we don't control. Notice I said it was.. Because it was working, then all of a sudden started separating out the sessions per iframe. We know it wasn't doing this yesterday, because we were watching the foccache directory and could see all the foccache files being populated in the same folder. Now, WebFOCUS is creating a new folder for each file created.

Is there a setting somewhere that states to use one session per user? We found "IBI_Multiple_Logins_Per_User", but this looks to be an issue on the reporting server and this setting is for the web session so you can't log in close window and log in again..

Any suggestions would be greatly appreciated..

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



- FOCUS Man, just FOCUS!
-----------------------------
Product: WebFOCUS
Version: 8.1.04
Server: Windows 2008 Server
July 16, 2015, 10:34 AM
GavinL
There seems to be a bug based on their documentation, however we found a horrible work around. If we create a foccache file, before entering the page that has the 4 iframes, the the session will be already established and the 4 iframes all write to the same session folder.

Seems there is a race condition that webfocus hasn't prepared the session until one of the foccache tables have already been created.



- FOCUS Man, just FOCUS!
-----------------------------
Product: WebFOCUS
Version: 8.1.04
Server: Windows 2008 Server