1 Reply Latest reply: Aug 19, 2013 8:59 PM by BIDev RSS

    Error: Invalid login id - please login again

    BIDev

      Hi Experts,

       

       

      ESSBASE: 11.1.2.1

      BIEE: 11.1.1.6.11

       

       

      Since customers review data twice in one day,and the time for loading and aggregating data is very long, so we adopt one 'SWAP' machanism .

      For example:

      It has one ESSBASE cube named 'Sales' and one SWAP cube named 'Sales_C'.

      Sales Cube is used in production environment, and Sales_C Cube is used for loading and aggregating data, when the process will be finished, it will rename Sales Cube to Sales_C for loading and aggregating next time,and rename Sales_C Cube to Sales for using.

      So our problem is that when ESSBASE do SWAP machanism , BIEE will generate the following error messages in NQServer log files  as below, and users will look at error report .After click the refresh button below report, it will be OK. Why? How to solve this issue? Thanks.

       

       

      [2013-08-18T07:40:15.000+08:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 5dcb9c2494014f83:11cd6270:1407caf226c:-8000-00000000003bd31b] [tid: 25a4]  [nQSError: 96002] Essbase Error: Invalid login id - please login again

      [2013-08-18T07:40:15.000+08:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 5dcb9c2494014f83:11cd6270:1407caf226c:-8000-00000000003bd31b] [tid: 2700]  [nQSError: 96002] Essbase Error: Invalid login id - please login again

      [2013-08-18T07:40:15.000+08:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 5dcb9c2494014f83:11cd6270:1407caf226c:-8000-00000000003bd31b] [tid: 2700]  [nQSError: 96002] Essbase Error: Invalid login id - please login again [[

      [nQSError: 43113] Message returned from OBIS.