Oct 09, 2021 at 10:55 AM

SAP BO 4.2 SP8 - Impala Connectivity issue

459 Views Last edit Oct 09, 2021 at 10:59 AM 3 rev

Hi All, Getting the below mentioned error when trying to run webi report based on universe (unx) which is using the Cloudera Impala database connection.

Application Landscape : SAP BO 4.2 SP8

RHEL OS version : 7.8

Cloudera Impala odbc middleware version : 2.5.39

The following database error occurred: [unixODBC][Cloudera][ImpalaODBC] (100) Error from the Impala Thrift API: SASL(-1): generic failure: GSSAPI Error: A supplied name was of an unsupported type (OK). For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901) (Error: INF WIS 10901)

The ODBC configurations:

Description=Cloudera Impala ODBC Driver (64-bit)

[Impala-DSN]

Host=bigdata

Port=21051

Driver=/opt/cloudera/impalaodbc/lib/64/libclouderaimpalaodbc64.so

SSL=1

AllowSelfSignedServerCert=1

AuthMech=1

KrbRealm=<REALM>

KrbFQDN=<_HOST>

KrbServiceName=impala

UseKeytab=1

UID=<bigdata>

UPNKeytabMappingFile=<Install_DIR>/enterprise_xi40/bigdata.json

Tried the below things.

1.Establish the connection from Local IDT Middleware - Successful.

2.Establish the Impala DSN connection from isql in Business Objects Linux Server - Successful.

3.Checked Connection metrics whether Simba impala ODBC is loaded or not - Loaded.

But it is not working from Business Objects Linux server.

Can you please help us to fix the issue.

Thanks,

Chinnu