1 Reply Latest reply: Jun 11, 2014 2:18 PM by KKT RSS

    Smartview giving Invalid session error randomly.

    kkwok

      Hi Experts,

       

      Would anyone have experience resolving this issue?

      Error message: Invalid Session. One possibility is that the connection has timed out. login again.

      I am using Smartview 11.1.2.1.103 connecting to HFM 11.1.2.1.601, and when using ad-hoc analysis on 1/3 HFM apps, I randomly gets the following error, but sometimes it works perfectly.

      Our environment does not have cluster/loadbalancer/high availability.

       

      It has the following behavior:

      1. Has never happened until this morning
      2. Iisreset does not help the issue. Restarted all services: HFM, Foundation, APS.. etc.
      3. Happens on all 3 HFM aps
      4. Doesn’t take 30 seconds to see the timeout error
      5. All users/admins have the issues
      6. The error shows, then on next try it works, then on next try it shows again... and so on....

       

      Steps taken to resolve the issue:

       

      Did all following Oracle note:

      1. 1392736.1
        1050647.1
        1427561.1
        1258184.1

        and we have also added in the client’s registry.
        "ReceiveTimeout"=dword:00075300
        "KeepAliveTimeout"=dword:0000ea60
        "ServerInfoTimeout"=dword:0000ea60

       

      None of the above has helped so far. Any ideas would be appreciated.