OBIS1 is down in OBIEE 12.2.1.2.0

Question

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

3363076 · Answer

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

Madasamy -Oracle · Answer

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 · Answer

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