State: 08004. Code: 10092. [NQODBC] [SQL_STATE: 08004] [nQSError: 10092] The Oracle BI Server is not — Oracle Analytics

Oracle Analytics Cloud and Server

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

State: 08004. Code: 10092. [NQODBC] [SQL_STATE: 08004] [nQSError: 10092] The Oracle BI Server is not

Received Response
348
Views
7
Comments
3363076
3363076 Rank 4 - Community Specialist

hi expert ,

I am getting this error every time I run reports or dash board in OBIEE 11g

State: 08004.  Code: 10092.  [NQODBC] [SQL_STATE: 08004] [nQSError: 10092] The Oracle BI Server is not currently running. Cannot connect to server machine (08004)

what could possibly cause this problem please if anyone can help

Thanks

Answers

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    For a start, check if your OBIEE services are up.

  • 3363076
    3363076 Rank 4 - Community Specialist

    yes it is up and running

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Ok, so was the environment working fine before and the error started happening recently ? If so was there any changes made to the env? Did you check the server logs for additional error messages (nqserver, sawlog). Also post the exact version of your 11g OBIEE.

  • FTisiot
    FTisiot Rank 6 - Analytics Lead

    Hi,

    I would check BIServer log file

    $FMW_HOME/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1/nqserver.log

  • 3363076
    3363076 Rank 4 - Community Specialist

    I have configured Teradata in my environment and I think that is causing the problem. I try to set the environment variable in user.sh but now it causing

    Error:  [nQSError: 43113] Message returned from OBIS.
    [nQSError: 43119] Query Failed: [nQSError: 16001] ODBC error state: IM002 code:
    0 message: [DataDirect][ODBC lib] Data source name not found and no default
    driver specified. (HY000)

    so could it be that I set the environment variable wrong

    I am putting that here as well and just for reference I have put these details in user.sh and my version of OBIEE is 11.1.1.7.0

    ODBCINI=/opt/teradata/client/ODBC_64/odbc.ini
    LD_LIBRARY_PATH=/opt/teradata/client/ODBC_64/lib/tdata.so:$LD_LIBRARY_PATH
    export ODBCINI  LD_LIBRARY_PATH

    Thanks

  • 3363076
    3363076 Rank 4 - Community Specialist

    it keep showing this error in nqserver.log

    [2017-04-05T09:17:08.000-05:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 200b31463137d8c7:686c059b:15b3b33094f:-8000-0000000000007895,0:1:6] [tid: ee465700]  [nQSError: 16001] ODBC error state: IM002 code: 0 message: [DataDirect][ODBC lib] Data source name not found and no default driver specified.

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    I suggest you check your OBIEE config for Teradata data source. See document below.

    https://sblbharathy.wordpress.com/2013/12/20/configuring-teradata-data-source-for-oracle-bi-under-unix/