SAPBI4.2 ODBC Impala Configuration

[ramil_rashidov]

Hi there,

Getting the below mentioned error when trying to run report based on universe (unx) with the connection to Cloudera Impala Server.

The following database error occurred: [. For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901) (Error: INF )

The platform is SAP Business Intelligence 4.2 SP06 on RHEL7.4 and Cloudera Impala Server (with active Kerberos auth.) . Information Design Tool was installed on WINDOWS system, 'Impala-DSN' 32-bit ODBC connection have been created, all tests succeeded. New universe with 2 tables, new report on them have been created.

The driver used is 64 bit Cloudera Impala ODBC driver, unixODBC.

Error log for WI is the following:

kctRequestProc.cpp:779:void cdztools::RequestProcBasic::generateResult(cdztools::FixedLength_UTF8String*&, const char*, const char*, const char*, const UTF8*, const UTF8*, std::istream*, int, bool&): TraceLog message 123 |c9c56b25-2d25-a6d6-2ef9-6162a7638802|2019 09 05 18:58:54:432|+0400|Error| |>>|E| |webiserver_bobi42.WebIntelligenceProcessingServer|20948|47226402395904|| |264|16|2|0|BIlaunchpad.WebApp|bobi42.azercell.com:20858:61.33:1|Webi SDK.CorbaServerImpl.doProcess()|bobi42.azercell.com:20858:61.33:12|webiserver_bobi42.WebIntelligenceProcessingServer.processDPCommandsEx|localhost:20948:-1057990912.109:1|Cge8PDAuokK4rkiALqKsdyQ1f|||||Administrator||||||**ERROR:RequestProc:user: Administrator, doc: "<unknown>", error stream: <ERRORS> <ERROR COMPONENT="WIS" ERRORCODE="10901" ERRORTYPE="USER" MESSAGE="The following database error occurred: [. For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901)" PREFIX="ERR"> <DEBUGINFO BORESULT="5" FILENAME="kc3cdbtbdacs.cpp" LINEPOSITION="2528" MODULENAME="C3_CS"/> <REQUESTINFO COMMANDID="0" COMMANDNAME="Refresh batch" DPID="DP0" DPLONGNAME="Query 1 - Impala-Test_BL" DPNAME="Query 1"/> <REASON> <CONTENT> </CONTENT> </REASON> </ERROR> <ERROR COMPONENT="WIS" ERRORCODE="10901" ERRORTYPE="USER" MESSAGE="The following database error occurred: [. For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901)" PREFIX="ERR"> <DEBUGINFO BORESULT="5" FILENAME="kc3cdbtbdacs.cpp" LINEPOSITION="2528" MODULENAME="C3_CS"/> <REQUESTINFO COMMANDID="" COMMANDNAME="" DPID="DP0" DPLONGNAME="Query 1 - Impala-Test_BL" DPNAME="Query 1"/> <REASON> <CONTENT> </CONTENT> </REASON> </ERROR> </ERRORS> [kctRequestProc.cpp;779]

Impala Server encoding is UTF-16, but the BI treats it as UTF8, it seems so to me.

The ODBC configurations:

/app/bobj/sap_bobj/enterprise_xi40/odbc.ini

[Impala-DSN] 
Description=Cloudera Impala ODBC Driver (64-bit) 
Host=dn01bigdata 
Port=21050 
Driver=/opt/cloudera/impalaodbc/lib/64/libclouderaimpalaodbc64.so 
SSL=1 
AllowSelfSignedServerCert=1 
AuthMech=1 
KrbRealm=<REALM> 
ServicePrincipalCanonicalization=0 
KrbFQDN=_HOST 
KrbServiceName=impala 
UseKeytab=1 
UID=dloper 
UPNKeytabMappingFile=/app/bobj/sap_bobj/enterprise_xi40/dloper.json
DefaultKeytabFile=/app/bobj/sap_bobj/enterprise_xi40/dloper.keytab 

/app/bobj/sap_bobj/enterprise_xi40/odbcinst.ini

[ODBC Drivers]
Simba Impala ODBC Driver 64-bit=Installed

[Simba Impala ODBC Driver 64-bit]
Description=Simba Impala ODBC Driver (64-bit)
Driver=/app/bobj/sap_bobj/enterprise_xi40/linux_x64/odbc/simbaimpala/1.0/lib/libsimbaimpalaodbc64.so

/opt/cloudera/impalaodbc/lib/64/cloudera.impalaodbc.ini

[Driver]
# 2 UTF-8, 1 UTF-16
DriverUnicodeEncoding=1
DriverManagerEncoding=UTF-16

ErrorMessagesPath=/opt/cloudera/impalaodbc/ErrorMessages/
LogLevel=0
LogPath=

Environment settings:

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/cloudera/impalaodbc/lib/64:/app/bobj/odbc/lib:/app/bobj/sap_bobj/enterprise_xi40/dataAccess/connectionServer/drivers/lib64
export ODBCINI=/app/bobj/sap_bobj/enterprise_xi40/odbc.iniexport ODBCSYSINI=/app/bobj/sap_bobj/enterprise_xi40
export CLOUDERAIMPALAODBCINI=/opt/cloudera/impalaodbc/lib/64/cloudera.impalaodbc.ini

isql works fine. I think that the WI server tries to handle the UTF-16 data like UTF-8 and gets error.

On the universe itself I've selected the Text File Encoding as UTF-16.

I've also tried to configure the Simba ODBC Impala connection (SAP NOTE 2583832) but even isql gave me error and want work with it.

Please, ask any questions if the situation is unclear or I missed something.

BR,

Ramil R.

[denis_konovalov]

I have fixed your tags to mach content of your question.

[mr1925]

Im facing similar issue and help me to provide the solution exactly where we have to change the driver manager encoding parameter with UTF-16 value.

[ramil_rashidov]

Hello, and thank you Denis!

Recently I was in trouble with the SAS Viya Impala Connection configuration and the error message was the same. Adding the driver manager encoding parameter with UTF-16 value fixed the issue.