Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

OBIS1 is down in OBIEE 12.2.1.2.0

Received Response
111
Views
6
Comments
3363076
3363076 Rank 4 - Community Specialist
edited Aug 13, 2024 6:05PM in Oracle Analytics Cloud and Server

hi expert ,

my obis1 server component is down is OBIEE 12.2.1.2.0and the logs file in EM show the follow error "

[2017-03-13T23:06:53.860-04:00] [AdminServer] [ERROR] [EM-02658] [oracle.sysman.emai.model.bi.mbean.AvailabilityAssistant] [tid: Thread-95] [userId: weblogic] [ecid: c0cd038d-b108-49b6-b683-d614f2fba5bf-0000008e,0:4] [APP: em] [partition-name: DOMAIN] [tenant-name: GLOBAL] The start operation can not be performed on the Dummy BI Servers component.[[
oracle.sysman.emai.model.bi.ModelException: Failed to start the component
        at oracle.sysman.emai.model.bi.mbean.AvailabilityAssistant.processComponent(AvailabilityAssistant.java:1111)
        at oracle.sysman.emai.model.bi.mbean.AvailabilityAssistant.processClusterComponent(AvailabilityAssistant.java:1155)
        at oracle.sysman.emai.model.bi.mbean.AvailabilityAssistant.processComponent(AvailabilityAssistant.java:1071)
        at oracle.sysman.emai.model.bi.mbean.AvailabilityAssistant.restartComponent(AvailabilityAssistant.java:980)
        at oracle.sysman.emai.view.bi.AvailabilityView.restartComponent(AvailabilityView.java:1075)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at oracle.sysman.emInternalSDK.sdkas.general.pojo.progress.WorkWrapper.run(WorkWrapper.java:113)
        at java.lang.Thread.run(Thread.java:745)

]]
[2017-03-13T23:06:53.865-04:00] [AdminServer] [ERROR] [EM-02667] [oracle.sysman.emai.view.bi.AvailabilityView] [tid: Thread-95] [userId: weblogic] [ecid: c0cd038d-b108-49b6-b683-d614f2fba5bf-0000008e,0:4] [APP: em] [partition-name: DOMAIN] [tenant-name: GLOBAL] Can not restart selected component.[[
oracle.sysman.emai.model.bi.ModelException: Failed to start the component
        at oracle.sysman.emai.model.bi.mbean.AvailabilityAssistant.processComponent(AvailabilityAssistant.java:1111)
        at oracle.sysman.emai.model.bi.mbean.AvailabilityAssistant.processClusterComponent(AvailabilityAssistant.java:1155)
        at oracle.sysman.emai.model.bi.mbean.AvailabilityAssistant.processComponent(AvailabilityAssistant.java:1071)
        at oracle.sysman.emai.model.bi.mbean.AvailabilityAssistant.restartComponent(AvailabilityAssistant.java:980)
        at oracle.sysman.emai.view.bi.AvailabilityView.restartComponent(AvailabilityView.java:1075)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at oracle.sysman.emInternalSDK.sdkas.general.pojo.progress.WorkWrapper.run(WorkWrapper.java:113)
        at java.lang.Thread.run(Thread.java:745)

]]
[2017-03-13T23:06:53.870-04:00] [AdminServer] [ERROR] [] [oracle.sysman.emInternalSDK.sdkas.general.pojo.progress.WorkWrapper] [tid: Thread-95] [userId: weblogic] [ecid: c0cd038d-b108-49b6-b683-d614f2fba5bf-0000008e,0:4] [APP: em] [partition-name: DOMAIN] [tenant-name: GLOBAL] WorkWrapper caught exception: [[
oracle.sysman.emSDK.app.exception.EMSystemException
        at oracle.sysman.emai.view.bi.AvailabilityView.restartComponent(AvailabilityView.java:1080)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at oracle.sysman.emInternalSDK.sdkas.general.pojo.progress.WorkWrapper.run(WorkWrapper.java:113)
        at java.lang.Thread.run(Thread.java:745)
Caused by: oracle.sysman.emai.model.bi.ModelException: Failed to start the component
        at oracle.sysman.emai.model.bi.mbean.AvailabilityAssistant.processComponent(AvailabilityAssistant.java:1111)
        at oracle.sysman.emai.model.bi.mbean.AvailabilityAssistant.processClusterComponent(AvailabilityAssistant.java:1155)
        at oracle.sysman.emai.model.bi.mbean.AvailabilityAssistant.processComponent(AvailabilityAssistant.java:1071)
        at oracle.sysman.emai.model.bi.mbean.AvailabilityAssistant.restartComponent(AvailabilityAssistant.java:980)
        at oracle.sysman.emai.view.bi.AvailabilityView.restartComponent(AvailabilityView.java:1075)
        ... 6 more

"

is there anyway to find out what possibly is causing that

Thanks

Answers

  • Madasamy -Oracle
    Madasamy -Oracle Rank 6 - Analytics Lead

    Hello

    Can you post the log contents from the obis*.out and obis*.log files? and also check the domain logs, let us know if you find anything pertinent to the issue during the startup

    And was there any deployment or changes in the config that caused the issue?

    -M

  • 3363076
    3363076 Rank 4 - Community Specialist

    I actually added Teradata odbc details in odbc.ini file

    as soon as I remove the Teradata details then the obis1 is up and running

    can you please tell me how to configure that

    Thanks

  • Madasamy -Oracle
    Madasamy -Oracle Rank 6 - Analytics Lead

    That is just fine.

    You can use tdata.so odbc lib to configure teradata

    https://docs.oracle.com/middleware/1221/biee/BIEMG/deploy_rpd.htm#BIEMG1181

    -M

  • 3363076
    3363076 Rank 4 - Community Specialist

    I do the same but then it shows the error

    The start operation can not be performed on the Dummy BI Servers component.

    my Teradata details are

    ODBC Data Sources]
    WHLST=tdata.so

    [WHLST]
    Driver=/opt/teradata/client/ODBC_64/lib/tdata.so
    Description=Teradata database
    DBCName=whlst.xxxxx.com
    LastUser=
    Username=xxxxxx
    Password=cdf3tld#17
    Database=xxxxxxxxxxxxx
    DefaultDatabase=D1_WDM_D_CDFPA_NPRIV_S

    these are the details In the server so as soon as I put hose in odbc.ini in OBIEE the obis1 goes down

  • Madasamy -Oracle
    Madasamy -Oracle Rank 6 - Analytics Lead

    I can see that the tdata is configured under [ODBC DS].

    You need to create a separate DSN as mentioned on the doc at the bottom of the file or anywhere) and proceed.

    [Tera_Northwind]

    Driver=/opt/teradata/client/14.10/odbc_64/lib/tdata.so

    Description=NCR 3600 running Teradata V2R6.2

    DBCName=10.345.67.899

    astUser=

    Username=northwind

    Password=northwind

    Database=northwind

    DefaultDatabase=northwind

    NoScan=no

    -M    

  • 3363076
    3363076 Rank 4 - Community Specialist

    this is the details of my odbc.ini in the path $DOMAIN_HOME//config/fmwconfig/bienv/core

    can you please if anything is wrong because whenever I put this details of Teradata the problem happen and obis 1 goes down

    Do you recommend any changes and also my Teradata version is 16 also I whenever I put the same details in obiee 12.2.1.0.0 it works but since we are using the new version of obiee 12.2.1.2.0 so this problem is happening

    also is the my Teradata

    is this my Teradata driver path is correct or do I need to make it as

    /opt/teradata/client/16.00/odbc_64/lib/tdata.so

    [ODBC]
    Trace=0
    TraceFile=/u00/app/oracle/product/fmw12c/OBIEE_Dev/user_projects/domains/bi_dev/odbctrace.out
    TraceDll=/u00/app/oracle/product/fmw12c/OBIEE_Dev/bi/modules/oracle.bi.datadirect.odbc/8.0.1/lib/ARtrc28.so
    InstallDir=/u00/app/oracle/product/fmw12c/OBIEE_Dev/bi/modules/oracle.bi.datadirect.odbc/8.0.1
    UseCursorLib=0
    IANAAppCodePage=4

    [ODBC Data Sources]
    WHLST=tdata.so
    AnalyticsWeb=Oracle BI Server
    opss_datasource=Oracle 7.1 Oracle Wire Protocol
    biplatform_datasource=Oracle 7.1 Oracle Wire Protocol

    WHLST=tdata.so
    [WHLST]
    Driver=/opt/teradata/client/ODBC_64/lib/tdata.so
    Description=Teradata database
    DBCName=wxxxxxxxx.xxxxxxxxxx.com
    LastUser=
    Username=xxxxxxxxx
    Password=cdf3tld#17
    Database=D1_WDM_D_CDFPA_NPRIV_S0
    NoScan=Yes
    SessionMode=TERA
    RunInQuiteMode=Yes
    StCheckLevel=0
    MaxRespSize=1048576
    CharacterSet=UTF8
    DefaultDatabase=D1_WDM_D_CDFPA_NPRIV_S0

    [AnalyticsWeb]
    Description=Oracle BI Server
    UID=
    PWD=
    Catalog=
    SelectPhysical=
    Repository=
    ForwardOnlyCursor=
    CentrallyManaged=Yes
    SSL=No
    Driver=/u00/app/oracle/product/fmw12c/OBIEE_Dev/bi/bifoundation/server/bin/libnqsodbc64.so
    IsClusteredDSN=Yes
    Regional=No

    [opss_datasource]
    HostName=xxxxxxxx.xxxxxxxxxx.com
    PortNumber=1521
    Driver=/u00/app/oracle/product/fmw12c/OBIEE_Dev/bi/modules/oracle.bi.datadirect.odbc/7.1.5/lib/ARora27.so
    EnableNcharSupport=1
    ServiceName=xxxxxxxx.xxxxxxxxxx.com
    Description=Oracle 7.1 Oracle Wire Protocol

    [biplatform_datasource]
    HostName=xxxxxxxx.xxxxxxxxxx.com
    PortNumber=1521
    Driver=/u00/app/oracle/product/fmw12c/OBIEE_Dev/bi/modules/oracle.bi.datadirect.odbc/7.1.5/lib/ARora27.so
    EnableNcharSupport=1
    ServiceName=xxxxxxxx.xxxxxxxxxx.com
    Description=Oracle 7.1 Oracle Wire Protocol