SAP Knowledge Base Article - Preview

2329101 - Unable to acquire data from UNX universe based on Apache Hadoop Hive ODBC connection

Symptom

In Lumira Desktop, when trying to acquire data from a UNX universe based on Apache Hadoop Hive 0.13 ODBC connection, getting the following error:

Error in the query panel: Unable to initialize the DSL Service Provider. Ensure that the universe has not been removed, that you have sufficient rights to access it, and that the BI Platform has a valid license.

6-10-2016 10.35.28 AM.png

In Lumira Desktop trace logs, the following errors are recorded:

2016/06/10 10:14:27.977000|  |E| | 4584|  40| |||||||||||||||[com.sap.bi.da.extension.core]java.lang.IllegalArgumentException: com.businessobjects.dsl.services.workspace.impl.WorkspaceException: Specified RDBMS is invalid : Apache Hadoop Hive 0.13 Simba ODBC
 at com.sap.bi.da.extension.unx.xi41.dsl.DSLNormalUniverseServiceProvider.buildAndInitServiceProvider(DSLNormalUniverseServiceProvider.java:68)
 at com.sap.bi.da.extension.unx.xi41.dsl.DSLServiceProviderFactory.createServiceProvider(DSLServiceProviderFactory.java:14)
 at com.sap.bi.da.extension.unx.xi41.dsl.DSLServiceProviderFactory.buildServiceProvider(DSLServiceProviderFactory.java:8)
 at com.sap.bi.da.extension.unx.xi41.internal.BOEHelper.getServiceProvider(BOEHelper.java:85)
 ...
 Caused by: com.businessobjects.dsl.services.workspace.impl.WorkspaceException: Specified RDBMS is invalid : Apache Hadoop Hive 0.13 Simba ODBC
 at com.businessobjects.dsl.services.dataprovider.impl.AbstractDataProviderWithUniverse.createDataSource(AbstractDataProviderWithUniverse.java:485)
 at com.businessobjects.dsl.services.dataprovider.impl.QuerySpecDataProvider.createInitialDataSource(QuerySpecDataProvider.java:612)
 ...
 Caused by: com.businessobjects.mds.services.solver.ConnectionSolverException: Specified RDBMS is invalid : Apache Hadoop Hive 0.13 Simba ODBC
 at com.businessobjects.mds.services.solver.AbstractConnectionSolver.addCredentialInfo(AbstractConnectionSolver.java:238)
 at com.businessobjects.mds.services.solver.AbstractConnectionSolver.solve(AbstractConnectionSolver.java:136)
 at com.businessobjects.mds.services.solver.AbstractConnectionSolver.solveRelational(AbstractConnectionSolver.java:151)
 ...
 Caused by: com.sap.connectivity.cs.core.CSError: Specified RDBMS is invalid : Apache Hadoop Hive 0.13 Simba ODBC
 at com.sap.connectivity.cs.core.Environment.resolveAlias(Environment.java:382)
 at com.sap.connectivity.cs.core.Environment.CreateConnectionManager(Environment.java:530)
 ...


Read more...

Environment

  • SAP BusinessObjects Lumira Desktop 1.30
  • SAP BusinessObjects Lumira Server for BI platform 1.30
  • SAP BusinessObjects Business Intelligence (BI) Platform 4.1 SP6
  • ODBC connection using SAP Hive ODBC Driver v1,4,16,1016 (Simba)

Product

SAP BusinessObjects Business Intelligence platform R2 ; SAP Lumira, desktop edition 1.0

Keywords

lum, dsk, bip, bi, bo, boe, bi41, 4.1, unx, unv, issue, error, bug, unable, cannot, can't, can, not, connect, use, start, open, initialize, odbc, driver, hadoop, hive, server, , KBA , BI-LUM-DIS , Lumira Desktop/Discovery , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.