1 Reply Latest reply: Mar 8, 2013 5:19 AM by Yogi1729 RSS

    Unable to start presentation services in OBIEE 11g on Linux

    faisalm
      Hello Experts,
      I am facing an issue in starting Presentation services in OBIEE 11g installed on linux machine.

      When I execute ./opmnctl startall, I get following output :

      Communication error with the OPMN server local port.
      Check the OPMN log files

      Communication error with the OPMN server local port.
      Check the OPMN log files

      Communication error with the OPMN server local port.
      Check the OPMN log files

      Communication error with the OPMN server local port.
      Check the OPMN log files

      Communication error with the OPMN server local port.
      Check the OPMN log files

      Communication error with the OPMN server local port.
      Check the OPMN log files



      Here are the snippets from the presentation servers log files :


      Unable to create a system user connection to BI Server during start up. Trying again.
      ---------------------------------------
      Type: ERROR
      Severity: 10
      Time: Mon Feb 18 18:06:53 2013
      File: project/websecurity/odbcuserpoploaderimpl.cpp Line: 324
      Properties: ecid-
      Location:
      +     saw.security.odbcuserpopulationimpl.initialize+
      +     saw.catalog.local.loadCatalog+
      +     saw.catalogcrawler.main+

      Odbc driver returned an error (SQLDriverConnectW).
      +State: HY000.  Code: 10058.  [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.+
      +[nQSError: 73006] Cannot obtain Oracle BI Servers from either the primary Cluster Controller (infva05545.vshodc.lntinfotech.com) or the secondary Cluster Controller () specified for the clustered DSN. (HY000)+
      ---------------------------------------
      Type: ERROR
      Severity: 16
      Time: Mon Feb 18 18:06:53 2013
      File: project/websecurity/odbcuserpoploaderimpl.cpp Line: 325
      Properties: ecid-
      Location:
      +     saw.security.odbcuserpopulationimpl.initialize+
      +     saw.catalog.local.loadCatalog+
      +     saw.catalogcrawler.main+

      Unable to create a system user connection to BI Server during start up. Trying again.
      ---------------------------------------
      Type: ERROR
      Severity: 10
      Time: Mon Feb 18 18:06:58 2013
      File: project/websecurity/odbcuserpoploaderimpl.cpp Line: 324
      Properties: ecid-
      Location:
      +     saw.security.odbcuserpopulationimpl.initialize+
      +     saw.catalog.local.loadCatalog+
      +     saw.catalogcrawler.main+

      Odbc driver returned an error (SQLDriverConnectW).
      +State: HY000.  Code: 10058.  [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.+
      +[nQSError: 73006] Cannot obtain Oracle BI Servers from either the primary Cluster Controller (infva05545.vshodc.lntinfotech.com) or the secondary Cluster Controller () specified for the clustered DSN. (HY000)+
      ---------------------------------------
      Type: ERROR
      Severity: 16
      Time: Mon Feb 18 18:06:58 2013
      File: project/websecurity/odbcuserpoploaderimpl.cpp Line: 325
      Properties: ecid-
      Location:
      +     saw.security.odbcuserpopulationimpl.initialize+
      +     saw.catalog.local.loadCatalog+
      +     saw.catalogcrawler.main+

      Unable to create a system user connection to BI Server during start up. Trying again.
      ---------------------------------------
      Type: ERROR
      Severity: 1
      Time: Mon Feb 18 18:07:04 2013
      File: project/catalogcrawler/catalogcrawlermain.cpp Line: 419
      Properties: ecid-
      Location:
      +     saw.catalogcrawler.main+

      Could not create a system user connection to Oracle BI Server during start-up. Please check the error message and try again.


      Any Suggestions on this ??