I am trying to fetch data from a table in Impala and loading into an Essbase cube. A Cloudera ODBC driver is set up and successfully working (64 bit and Version 2.6.0) Kerberos is also installed and in usage.
But when trying to fetch data via Essbase rules file, I am getting following log-message:
[2023-03-07T09:45:27.492+01:00] [VC_ASO] [NOTIFICATION:16] [SQL-41] [SQL] [ecid: 1678147748126,0] [tid: 23684] [DBNAME: VC_ASO] Connection String is [DSN=Impala_PRD_64;UID=...;PWD=...;]
[2023-03-07T09:45:27.493+01:00] [VC_ASO] [NOTIFICATION:16] [SQL-6] [SQL] [ecid: 1678147748126,0] [tid: 23684] [DBNAME: VC_ASO] SELECT Statement [SELECT * FROM reference.ess_transaction_view WHERE posting_date = '2023-02-08 00:00:00.000'] is generated
[2023-03-07T09:45:27.499+01:00] [VC_ASO] [NOTIFICATION:16] [SQL-13] [SQL] [ecid: 1678147748126,0] [tid: 23684] [DBNAME: VC_ASO] ODBC Layer Error: [S1000] ==> [[Cloudera][Support] (50366) Failed to load the security library: krb5_64.dll]
[2023-03-07T09:45:27.499+01:00] [VC_ASO] [NOTIFICATION:16] [SQL-14] [SQL] [ecid: 1678147748126,0] [tid: 23684] [DBNAME: VC_ASO] ODBC Layer Error: Native Error code [50366]
[2023-03-07T09:45:27.499+01:00] [VC_ASO] [NOTIFICATION:16] [SQL-1] [SQL] [ecid: 1678147748126,0] [tid: 23684] [DBNAME: VC_ASO] Failed to Establish Connection With SQL Database Server. See log for more information
I am very thankful for every hint.
