Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE login page content issue

Received Response
14
Views
5
Comments
User_4FT2Z
User_4FT2Z Rank 1 - Community Starter
in Oracle Business Intelligence Applications

Hi Guru's

Need ur help on t3h below issue.

i have installed BI Apps in my PROD environment . All my OBIEE services are up and running.

when i try to open my Analysis page i am unable to login,

below is the error log and screenshot

pastedImage_0.png

below is the error log from sawlog of presentation services.

]]

[2016-10-20T23:45:33.000-07:00] [OBIPS] [ERROR:31] [] [saw.security.odbcuserpopulationimpl.getbisystemconnection] [ecid: 005FpdZHmvV6eLcLHio2yf0006IO000000,0:1] [tid: 1108355392] Unable to create a system user connection to BI Server while running user population queries

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 (ulcakcrmap1v) or the secondary Cluster Controller () specified for the clustered DSN. (HY000)[[

File:odbcuserpoploaderimpl.cpp

Line:1023

Location:

saw.security.odbcuserpopulationimpl.getbisystemconnection

saw.security.odbcuserpopulationimpl.getroles

saw.security.userpopulationcache.populateapproleshierarchy

saw.RoleHierarchyCache.cache.cleanup

saw.taskScheduler.processJob

taskscheduler

saw.threads

ecid: 005FpdZHmvV6eLcLHio2yf0006IO000000,0:1

ThreadID: 1108355392

task: Cache/RoleHierarchyCache

]]

[2016-10-20T23:45:33.000-07:00] [OBIPS] [ERROR:31] [] [saw.security.odbcuserpopulationimpl.getroles] [ecid: 005FpdZHmvV6eLcLHio2yf0006IO000000,0:1] [tid: 1108355392] Error retrieving user/group data from Oracle BI Server's User Population API.

Unable to create a system user connection to BI Server while running user population queries

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 (ulcakcrmap1v) or the secondary Cluster Controller () specified for the clustered DSN. (HY000)[[

File:odbcuserpoploaderimpl.cpp

Line:524

Location:

saw.security.odbcuserpopulationimpl.getroles

saw.security.userpopulationcache.populateapproleshierarchy

saw.RoleHierarchyCache.cache.cleanup

saw.taskScheduler.processJob

taskscheduler

saw.threads

ecid: 005FpdZHmvV6eLcLHio2yf0006IO000000,0:1

ThreadID: 1108355392

task: Cache/RoleHierarchyCache

]]

[2016-10-20T23:45:33.000-07:00] [OBIPS] [ERROR:16] [] [saw.security.userpopulationcache.populateapproleshierarchy]

[ecid: 005FpdZHmvV6eLcLHio2yf0006IO000000,0:1] [tid: 1108355392]

Error retrieving user/group data from Oracle BI Server's User Population API.

Unable to create a system user connection to BI Server while running user population queries

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 (ulcakcrmap1v) or the secondary Cluster Controller () specified for the clustered DSN. (HY000)[[

File:userpopulationcache.cpp

Line:381

Location:

saw.security.userpopulationcache.populateapproleshierarchy

saw.RoleHierarchyCache.cache.cleanup

saw.taskScheduler.processJob

taskscheduler

saw.threads

ecid: 005FpdZHmvV6eLcLHio2yf0006IO000000,0:1

ThreadID: 1108355392

task: Cache/RoleHierarchyCache

]]

Thanks,

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    1838680 wrote:[nQSError: 73006] Cannot obtain Oracle BI Servers from either the primary Cluster Controller (ulcakcrmap1v) or the secondary Cluster Controller () specified for the clustered DSN.

    ^-- All services may seem to be up but they're definitely not talking to each other

  • Venkata Yaswanth Ramisetty
    Venkata Yaswanth Ramisetty Rank 5 - Community Champion

    Hi,

    Can you share us the bi server log to check in detail.

    Thanks,

    Yaswanth

  • User_SERCU
    User_SERCU Rank 1 - Community Starter

    Hi Yaswanth,

    Please find BI server log below,

    2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [nQSError: 17010] SQL statement preparation failed. [[

    [nQSError: 17001] Oracle Error code: 942, message: ORA-00942: table or view does not exist

    at OCI call OCIStmtExecute.

    ]]

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [nQSError: 17010] SQL statement preparation failed. [[

    [nQSError: 17001] Oracle Error code: 942, message: ORA-00942: table or view does not exist

    at OCI call OCIStmtExecute.

    [nQSError: 43059] Init block 'LAST_SYND_DS_DATES': Dynamic refresh of repository scope variables has failed.

    ]]

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43143] Blacklisted connection pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'LAST_SYND_IDS_DATES' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'LAST_SYND_RX_DATES' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'PREVIOUS_YEAR' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'Current Balance Date Key - AR' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'Current Balance Date Key - AP' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'Current Balance Date Key - GL' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'LAST_SYND_PT_DATES' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'LAST_SYND_XPT_DATES' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'LAST_SYND_W_DATES' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'LAST_CALL_ATTND_DATES' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'LAST_CALL_CON_DATES' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'LAST_CALL_ACCNT_DATES' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'MONTH-1' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'NQTR-8' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'NQTR-7' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'NQTR-6' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'NQTR-5' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'NQTR-4' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'NQTR-3' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'NQTR-2' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'NQTR-1' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'NWEEK-4' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'NWEEK-3' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'NWEEK-2' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'NWEEK-1' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'QTR-3' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'QTR-2' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'QTR-1' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'PREVIOUS YEAR - 3' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'PREVIOUS YEAR - 2' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'PREVIOUS YEAR - 1' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'PREVIOUS YEAR' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'QTR-8' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'QTR-7' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'PREVIOUS WEEK-2' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'PREVIOUS WEEK-1' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'QTR-5' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'QTR-4' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'QTR-6' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'PREVIOUS WEEK' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'JULIAN SYSDATE' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'ETL_RUN_DATE' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'LAST_SYND_DS_YTD_QTD' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'LAST_SYND_RX_YTD_QTD' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43144] Skipping execution of Initialization Block: 'LAST_SYND_IDS_YTD_QTD' due to blacklisted Connection Pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    [2016-11-02T19:06:58.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005FpdePWHb6eLcLHio2yf0006IL00002X,0] [tid: 482fc940]  [43065] The connection with Cluster Controller ulcakcrmap1v:9706 was lost.

    [2016-11-02T19:06:59.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005FpdeGJwU6eLcLHio2yf0006IL00002V,0] [tid: 480fa940]  [nQSError: 46066] Operation cancelled.

    [2016-11-02T19:06:59.000-07:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: afb96700] [43031] : Oracle BI Server shutdown.

    [2016-11-02T19:07:03.000-07:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: afb96700] [85008] MDX Member Name Cache subsystem statistics - Entries: 0, Sizes: 0 bytes, Overall Queries: 0, Hits: 0(0%), Misses: 0(0%).

    [2016-11-02T19:07:03.000-07:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: afb96700] [85007] MDX Member Name Cache subsystem stopped.

    [2016-11-02T19:07:03.000-07:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: afb96700] [58001] Query Cache Statistics -- Hits:0(0%), Qualified Misses:0(0%), Unqualified Misses:0(0%).

    [2016-11-02T19:16:01.000-07:00] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 98b1d700] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled.  This can lead to inconsistencies.

    [2016-11-02T19:16:02.000-07:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 98b1d700] [36007] Loading repository /Websrvr1/bi_apps/instances/instance1/bifoundation/OracleBIServerComponent/coreapplication_obis1/repository/OracleBIApps_BI0002.rpd.

    [2016-11-02T19:16:47.000-07:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 005G5kaKfhf6eLcLHio2yf0006Kd000017,0] [tid: 450da940]  [14055] Loading subject area: Usage Tracking ...

    [2016-11-02T19:16:47.000-07:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 005G5kaKfns6eLcLHio2yf0006Kd00001A,0] [tid: 453dd940]  [14055] Loading subject area: Core ...

    [2016-11-02T19:16:47.000-07:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 005G5kaKfjt6eLcLHio2yf0006Kd000018,0] [tid: 451db940]  [14055] Loading subject area: Fusion SPE Analytics ...

    [2016-11-02T19:16:47.000-07:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 005G5kaKfpF6eLcLHio2yf0006Kd00001B,0] [tid: 452dc940]  [14055] Loading subject area: RTD Analytics ...

    [2016-11-02T19:16:47.000-07:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 005G5kaKfjt6eLcLHio2yf0006Kd000018,0] [tid: 451db940]  [14056] Finished loading subject area: Fusion SPE Analytics.

    [2016-11-02T19:16:47.000-07:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 005G5kaKfhf6eLcLHio2yf0006Kd000017,0] [tid: 450da940]  [14056] Finished loading subject area: Usage Tracking.

    [2016-11-02T19:16:47.000-07:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 005G5kaKoDu6eLcLHio2yf0006Kd00001C,0] [tid: 450da940]  [14055] Loading subject area: Data Lineage ...

    [2016-11-02T19:16:47.000-07:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 005G5kaKfpF6eLcLHio2yf0006Kd00001B,0] [tid: 452dc940]  [14056] Finished loading subject area: RTD Analytics.

    [2016-11-02T19:16:47.000-07:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 005G5kaKoDu6eLcLHio2yf0006Kd00001C,0] [tid: 450da940]  [14056] Finished loading subject area: Data Lineage.

    your help is highly appreciated.

    Thanks,

  • User_SERCU
    User_SERCU Rank 1 - Community Starter

    @ Chrisian Berg: how do we identify the server which are not talking to each other

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    You got many issues there...

    1.)

    2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [nQSError: 17010] SQL statement preparation failed. [[

    [nQSError: 17001] Oracle Error code: 942, message: ORA-00942: table or view does not exist

    2.)

    [2016-11-02T19:00:00.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005Fpde65ah6eLcLHio2yf0006IL00001n,0] [tid: 455cf940]  [43143] Blacklisted connection pool: '"Oracle Data Warehouse"."Oracle Data Warehouse Repository Initblocks Connection Pool"'

    3.)

    [2016-11-02T19:16:01.000-07:00] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 98b1d700] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled.  This can lead to inconsistencies.

    and obviously:

    [2016-11-02T19:06:59.000-07:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: afb96700] [43031] : Oracle BI Server shutdown.

    ^--- I think some communication issues may result from your BI server not actually starting. (That was a sarcastic joke in case this gets lost in translation).

    Fix your issues. Your setup is quite bug-ridden all over the place.