4 Replies Latest reply on Mar 5, 2015 7:15 AM by 2810934

    Problem: The BI Server will not start / doesn't work

    2810934

      Hi all,


      I have a problem. I am using OBIEE 11g. I get the BI Server / BI Presentation Server not started. I have tried quite a lot of possibilities. Nothing has helped.

      For some reason my default user were gone. I have the BISystemUser again created in WLS and EM. Nothing helps.

       

       

      Can you help me? Here are the log entries for BI Server and BI Presentation Server

       

      nqsserver.log

       

      2015-03-04T12:41:42.000+01:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00iRkgrtZhAFw0zpRu0Dvz2w^TU2zQYyn0000tg000000] [tid: b2c] An error message was received from the BI Security Service: PolicySet Invalid: WSM-02557 oracle.wsm.policymanager.accessor.BeanAccessor Die Dokumente, die zur Konfiguration der Oracle Web Services Manager-Laufzeitumgebung erforderlich sind, wurden nicht aus der Policy Manager-Anwendung (wsm-pm) abgerufen, wahrscheinlich weil die Anwendung nicht ausgeführt wird oder in der Umgebung nicht bereitgestellt wurde. Die Abfrage "&(@appliesTo~="WS-Service()")(policysets:global/%)" wird in die Queue gestellt, damit sie später abgerufen werden kann. WSM-02557 oracle.wsm.policymanager.accessor.BeanAccessor Die Dokumente, die zur Konfiguration der Oracle Web Services Manager-Laufzeitumgebung erforderlich sind, wurden nicht aus der Policy Manager-Anwendung (wsm-pm) abgerufen, wahrscheinlich weil die Anwendung nicht ausgeführt wird oder in der Umgebung nicht bereitgestellt wurde. Die Abfrage "/policies/oracle/wss_username_token_service_policy" wird in die Queue gestellt, damit sie später abgerufen werden kann.

      [2015-03-04T12:41:42.000+01:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00iRkgrtZhAFw0zpRu0Dvz2w^TU2zQYyn0000tg000000] [tid: b2c]  [13026] Error in getting roles from BI Security Service:  'An error message was received from the BI Security Service: PolicySet Invalid: WSM-02557 oracle.wsm.policymanager.accessor.BeanAccessor Die Dokumente, die zur Konfiguration der Oracle Web Services Manager-Laufzeitumgebung erforderlich sind, wurden nicht aus der Policy Manager-Anwendung (wsm-pm) abgerufen, wahrscheinlich weil die Anwendung nicht ausgeführt wird oder in der Umgebung nicht bereitgestellt wurde. Die Abfrage "&(@appliesTo~="WS-Service()")(policysets:global/%)" wird in die Queue gestellt, damit sie später abgerufen werden kann. WSM-02557 oracle.wsm.policymanager.accessor.BeanAccessor Die Dokumente, die zur Konfiguration der Oracle Web Services Manager-Laufzeitumgebung erforderlich sind, wurden nicht aus der Policy Manager-Anwendung (wsm-pm) abgerufen, wahrscheinlich weil die Anwendung nicht ausgeführt wird oder in der Umgebung nicht bereitgestellt wurde. Die Abfrage "/policies/oracle/wss_username_token_service_policy" wird in die Queue gestellt, damit sie später abgerufen werden kann. '

      [2015-03-04T12:41:42.000+01:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 00iRkgrtZhAFw0zpRu0Dvz2w^TU2zQYyn0000tg000000] [tid: b2c]  [46172] Database security store is not available, do not re-associate to this provider type.

      [2015-03-04T12:41:42.000+01:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 00iRkgrtZhAFw0zpRu0Dvz2w^TU2zQYyn0000tg000000] [tid: b2c] nqsserver: Clustered Oracle BI Server (64-bit) started.  Version: 11.1.1.7.0.

      [2015-03-04T12:41:45.000+01:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 00iRkgrtZhAFw0zpRu0Dvz2w^TU2zQYyn0000tg000000] [tid: a18]  [43071] A connection with Cluster Controller Server2008R2.opitz-consulting.int:9706 was established.

      [2015-03-04T12:41:49.000+01:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00iRkgriwg8Fw0zpRu0Dvz2w^TU2zQYyn0000uK000002] [tid: f44] PolicySet Invalid: WSM-02557 oracle.wsm.policymanager.accessor.BeanAccessor Die Dokumente, die zur Konfiguration der Oracle Web Services Manager-Laufzeitumgebung erforderlich sind, wurden nicht aus der Policy Manager-Anwendung (wsm-pm) abgerufen, wahrscheinlich weil die Anwendung nicht ausgeführt wird oder in der Umgebung nicht bereitgestellt wurde. Die Abfrage "&(@appliesTo~="WS-Service()")(policysets:global/%)" wird in die Queue gestellt, damit sie später abgerufen werden kann. WSM-02557 oracle.wsm.policymanager.accessor.BeanAccessor Die Dokumente, die zur Konfiguration der Oracle Web Services Manager-Laufzeitumgebung erforderlich sind, wurden nicht aus der Policy Manager-Anwendung (wsm-pm) abgerufen, wahrscheinlich weil die Anwendung nicht ausgeführt wird oder in der Umgebung nicht bereitgestellt wurde. Die Abfrage "/policies/oracle/wss_username_token_service_policy" wird in die Queue gestellt, damit sie später abgerufen werden kann.

      [2015-03-04T12:41:49.000+01:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00iRkgriwg8Fw0zpRu0Dvz2w^TU2zQYyn0000uK000002] [tid: f44]  [nQSError: 43126] Authentication failed: invalid user/password.

       

       

      sawlogn.log:

       

      [2015-03-04T12:44:41.000+01:00] [OBIPS] [NOTIFICATION:1] [] [saw.sawserver] [ecid: ] [tid: ] Oracle BI Presentation Services (OBIPS) 11.1.1.7.0 (Build 130303.2025 64-bit) are starting up.[[

      File:sawserver.cpp

      Line:455

      Location:

        saw.sawserver

        saw.sawserver.initializesawserver

        saw.sawserver

      ecid: 

      ]]

      [2015-03-04T12:44:41.000+01:00] [OBIPS] [NOTIFICATION:1] [] [saw.sawserver] [ecid: ] [tid: ] Running in catalog upgrade/update/recover mode, will shut down when complete.[[

      File:sawserver.cpp

      Line:475

      Location:

        saw.sawserver

        saw.sawserver.initializesawserver

        saw.sawserver

      ecid: 

      ]]

      [2015-03-04T12:44:41.000+01:00] [OBIPS] [WARNING:16] [] [saw.mas.csf] [ecid: ] [tid: ] Database security store is not available, do not re-associate to this provider type.[[

      File:csfwrapperimpl.cpp

      Line:152

      Location:

        saw.mas.csf

        saw.sawserver

        saw.sawserver.initializesawserver

        saw.sawserver

      ecid: 

      ]]

      [2015-03-04T12:44:41.000+01:00] [OBIPS] [NOTIFICATION:1] [] [saw.sawserver] [ecid: ] [tid: ] Security query timeout sec is: 120[[

      File:odbcuserpoploaderimpl.cpp

      Line:1068

      Location:

        saw.sawserver

        saw.sawserver.initializesawserver

        saw.sawserver

      ecid: 

      ]]

      [2015-03-04T12:44:43.000+01:00] [OBIPS] [ERROR:31] [] [saw.connectionPool.getConnection] [ecid: ] [tid: ] Authentication Failure.

      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: 43126] Authentication failed: invalid user/password. (08004)[[

      File:connection.cpp

      Line:436

      Location:

        saw.connectionPool.getConnection

        saw.security.odbcuserpopulationimpl.initialize

        saw.catalog.local.loadCatalog

        saw.subsystems.catalogbootstrapper.loadcatalog

        saw.webextensionbase.init

        saw.sawserver

        saw.sawserver.initializesawserver

        saw.sawserver

      ecid: 

      ]]

      [2015-03-04T12:44:43.000+01:00] [OBIPS] [ERROR:10] [] [saw.security.odbcuserpopulationimpl.initialize] [ecid: ] [tid: ] Authentication Failure.

      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: 43126] Authentication failed: invalid user/password. (08004)[[

      File:odbcuserpoploaderimpl.cpp

      Line:321

      Location:

        saw.security.odbcuserpopulationimpl.initialize

        saw.catalog.local.loadCatalog

        saw.subsystems.catalogbootstrapper.loadcatalog

        saw.webextensionbase.init

        saw.sawserver

        saw.sawserver.initializesawserver

        saw.sawserver

      ecid: 

      ]]

      [2015-03-04T12:44:43.000+01: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.

      Authentication Failure.

      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: 43126] Authentication failed: invalid user/password. (08004)[[

      File:odbcuserpoploaderimpl.cpp

      Line:324

      Location:

        saw.security.odbcuserpopulationimpl.initialize

        saw.catalog.local.loadCatalog

        saw.subsystems.catalogbootstrapper.loadcatalog

        saw.webextensionbase.init

        saw.sawserver

        saw.sawserver.initializesawserver

        saw.sawserver

      ecid: 

      ]]

      [2015-03-04T12:44:43.000+01:00] [OBIPS] [NOTIFICATION:1] [] [saw.sawserver] [ecid: ] [tid: ] Oracle BI Presentation Services are shutting down.[[

      File:sawserver.cpp

      Line:713

      Location:

        saw.sawserver

        saw.sawserver.terminatesawserver

        saw.sawserver

      ecid: 

      ]]

      [2015-03-04T12:44:48.000+01:00] [OBIPS] [NOTIFICATION:1] [] [saw.sawserver] [ecid: ] [tid: ] Oracle BI Presentation Services (OBIPS) 11.1.1.7.0 (Build 130303.2025 64-bit) are starting up.[[

      File:sawserver.cpp

      Line:455

      Location:

        saw.sawserver

        saw.sawserver.initializesawserver

        saw.sawserver

      ecid: 

      ]]

      [2015-03-04T12:44:48.000+01:00] [OBIPS] [NOTIFICATION:1] [] [saw.sawserver] [ecid: ] [tid: ] Running in catalog upgrade/update/recover mode, will shut down when complete.[[

      File:sawserver.cpp

      Line:475

      Location:

        saw.sawserver

        saw.sawserver.initializesawserver

        saw.sawserver

      ecid: 

      ]]

      [2015-03-04T12:44:48.000+01:00] [OBIPS] [WARNING:16] [] [saw.mas.csf] [ecid: ] [tid: ] Database security store is not available, do not re-associate to this provider type.[[

      File:csfwrapperimpl.cpp

      Line:152

      Location:

        saw.mas.csf

        saw.sawserver

        saw.sawserver.initializesawserver

        saw.sawserver

      ecid: 

      ]]

      [2015-03-04T12:44:48.000+01:00] [OBIPS] [NOTIFICATION:1] [] [saw.sawserver] [ecid: ] [tid: ] Security query timeout sec is: 120[[

      File:odbcuserpoploaderimpl.cpp

      Line:1068

      Location:

        saw.sawserver

        saw.sawserver.initializesawserver

        saw.sawserver

      ecid: 

      ]]

      [2015-03-04T12:44:50.000+01:00] [OBIPS] [ERROR:31] [] [saw.connectionPool.getConnection] [ecid: ] [tid: ] Authentication Failure.

      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: 43126] Authentication failed: invalid user/password. (08004)[[

      File:connection.cpp

      Line:436

      Location:

        saw.connectionPool.getConnection

        saw.security.odbcuserpopulationimpl.initialize

        saw.catalog.local.loadCatalog

        saw.subsystems.catalogbootstrapper.loadcatalog

        saw.webextensionbase.init

        saw.sawserver

        saw.sawserver.initializesawserver

        saw.sawserver

      ecid: 

      ]]

      [2015-03-04T12:44:50.000+01:00] [OBIPS] [ERROR:10] [] [saw.security.odbcuserpopulationimpl.initialize] [ecid: ] [tid: ] Authentication Failure.

      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: 43126] Authentication failed: invalid user/password. (08004)[[

      File:odbcuserpoploaderimpl.cpp

      Line:321

      Location:

        saw.security.odbcuserpopulationimpl.initialize

        saw.catalog.local.loadCatalog

        saw.subsystems.catalogbootstrapper.loadcatalog

        saw.webextensionbase.init

        saw.sawserver

        saw.sawserver.initializesawserver

        saw.sawserver

      ecid: 

      ]]

      [2015-03-04T12:44:50.000+01: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.

      Authentication Failure.

      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: 43126] Authentication failed: invalid user/password. (08004)[[

      File:odbcuserpoploaderimpl.cpp

      Line:324

      Location:

        saw.security.odbcuserpopulationimpl.initialize

        saw.catalog.local.loadCatalog

        saw.subsystems.catalogbootstrapper.loadcatalog

        saw.webextensionbase.init

        saw.sawserver

        saw.sawserver.initializesawserver

        saw.sawserver

      ecid: 

      ]]

      [2015-03-04T12:44:50.000+01:00] [OBIPS] [NOTIFICATION:1] [] [saw.sawserver] [ecid: ] [tid: ] Oracle BI Presentation Services are shutting down.[[

      File:sawserver.cpp

      Line:713

      Location:

        saw.sawserver

        saw.sawserver.terminatesawserver

        saw.sawserver

      ecid: 

      ]]