1 Reply Latest reply: Dec 28, 2012 12:46 AM by 981976 RSS

    oracleBIPresentation service in OBIEE 11.1.1.6.2  is not going up.

    981976
      Hi All,
      When I deployed the new 11g rpd on OBIEE 11.1.1.6.2 instance its oracleBIPresentation service is not coming up,other services are up.
      It is giving error like


      2012-12-27T06:47:42.000-08:00] [OBIPS] [ERROR:16] [] [saw.security.odbcuserpopulationimpl.initialize] [ecid: ] [tid: ] Unable to create a system user connection to BI Server during start up. Trying again.[[
      File:odbcuserpoploaderimpl.cpp
      Line:325
      Location:
           saw.security.odbcuserpopulationimpl.initialize
           saw.catalog.local.loadCatalog
           saw.subsystems.catalogbootstrapper.loadcatalog
           saw.webextensionbase.init
           saw.sawserver
      ecid:
      ]]
      [2012-12-27T06:47:47.000-08:00] [OBIPS] [ERROR:31] [] [saw.security.odbcuserpopulationimpl.initialize] [ecid: ] [tid: ] Could not create a system user connection to Oracle BI Server during start-up. Please check the error message and try again.[[
      File:odbcuserpoploaderimpl.cpp
      Line:342
      Location:
           saw.security.odbcuserpopulationimpl.initialize
           saw.catalog.local.loadCatalog
           saw.subsystems.catalogbootstrapper.loadcatalog
           saw.webextensionbase.init
           saw.sawserver




      Regards,
      Narottam
        • 1. Re: oracleBIPresentation service in OBIEE 11.1.1.6.2  is not going up.
          981976
          The logfile also contains following error

          [2012-12-27T06:47:24.000-08:00] [OBIPS] [ERROR:10] [] [saw.security.odbcuserpopulationimpl.initialize] [ecid: ] [tid: ] Odbc driver returned an error (SQLDriverConnectW).
          State: 08004. Code: 10018. [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused.
          [nQSError: 43113] Message returned from OBIS.
          [nQSError: 23006] The session variable, NQ_SESSION.ICX_SESSION_COOKIE, has no value definition.
          [nQSError: 13011] Query for Initialization Block 'FndGetSecContext' has failed. (08004)[[
          File:odbcuserpoploaderimpl.cpp
          Line:324
          Location:
               saw.security.odbcuserpopulationimpl.initialize
               saw.catalog.local.loadCatalog
               saw.subsystems.catalogbootstrapper.loadcatalog
               saw.webextensionbase.init
               saw.sawserver
          ecid:



          Regards,
          Narottam