Wednesday, October 4, 2017

HFM 11.1.2.4.205 and SmartView

Oracle has acknowledged a bug in HFM 11.1.2.4.205 PSU and is working on a fix.

The observed behavior is you have an HFM data grid open in SmartView and you get the session expired / disconnected message well in advance of the defined session timeout setting.

I've noticed this seems to happen more frequently if your user has a bunch of VB SmartView retrieval functions on their retrieval template instead of defining a traditional ad-hoc grid.  This is pure speculation on my part as I don't have too many systems I'm supporting that are on this particular patch.  It seems that each VB retrieval cell maintains its own connection, and apparently once one cell gets disconnected, all of them do and your back-end XFM ODL logs are flooded with messages.

Oracle Development has indicated the bug will be fixed in the upcoming patch HFM 11.1.2.4.206 PSU.

For now, the only known workaround available for the issue is to downgrade to HFM 11.1.2.4.204 PSU.