This discussion is archived
1 Reply Latest reply: Dec 27, 2012 10:46 PM by 981976 RSS

oracleBIPresentation service in OBIEE 11.1.1.6.2  is not going up.

981976 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points