2395293 - DataTypeConversion Exception occours, when UNX universe used as a DataSource | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2395293 - DataTypeConversion Exception occours, when UNX universe used as a DataSource

Symptom

DataTypeConversion Exception occours, when an UNX Universe consumed by a frontend or client tool, where the BICS acting as the middle layer to access the UNX Universe(e.g. Design Studio - Edit Initial View).
There is no exception on the Query Panel, as it is only the Sematic Layer in the picture that time. The issue happens, as soon as BICS involved.

The issue persist, regardless from the used Database (Eg.: HANA, MSSQL, ..).

By setting the Log Level to DEBUGGING in the Client, the following Exception could be found:

!MESSAGE [BICS DSL] Exception of type com.businessobjects.dsl.services.dataprovider.impl.DataTypeConversionException occurred with message "You cannot convert <"Data Type"> into <"Data Type">.":
[com.sap.sl.edp.dataprovider.relational.fetcher.AbstractRelationalFetcher.createDataTypeException(AbstractRelationalFetcher.java:449)
com.sap.sl.edp.dataprovider.relational.fetcher.AbstractRelationalFetcher.validateValue(AbstractRelationalFetcher.java:396)
com.sap.sl.edp.dataprovider.relational.fetcher.AbstractRelationalFetcher.fetchRow(AbstractRelationalFetcher.java:317)
com.sap.sl.edp.dataprovider.relational.streaming.AxisIteratorStreamer.next(AxisIteratorStreamer.java:43)
com.sap.ip.bi.bics.dataaccess.resource.impl.dsl.resultset.DslResultSet.getDslData(DslResultSet.java:168)
com.sap.ip.bi.bics.dataaccess.resource.impl.dsl.resultset.DslResultSet.getData(DslResultSet.java:123)
com.sap.ip.bi.bics.dataaccess.resource.impl.dsl.query.DslQuery.getResultSet(DslQuery.java:233)
com.sap.ip.bi.bics.dataaccess.resource.impl.dsl.query.DslQuery.getResultSet(DslQuery.java:1)
com.sap.ip.bi.bics.dataaccess.provider.relational.impl.rel2queryview.resultset.RelResultSet.refresh(RelResultSet.java:147)
com.sap.ip.bi.bics.dataaccess.provider.relational.impl.rel2queryview.Rel2QueryView.getResultSet(Rel2QueryView.java:175)
com.sap.ip.bi.bics.dataaccess.provider.relational.impl.rel2queryview.Rel2QueryView.getResultSet(Rel2QueryView.java:83)
com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.resultset.ResultSet.getData(ResultSet.java:614)
com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.resultset.RsResultSetManager.getResultSet(RsResultSetManager.java:235)
com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.resultset.RsResultSetManager.getResultSet(RsResultSetManager.java:169)
com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.resultset.RsResultSetManager.getResultSet(RsResultSetManager.java:57)
com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.QueryView.getResultSet(QueryView.java:747)


Read more...

Environment

SAP BusinessObjects Design Studio
SAP BusinessObjects Business Intelligence Platform 4.x

Product

SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2 ; SAP BusinessObjects Design Studio 1.3 ; SAP BusinessObjects Design Studio 1.4 ; SAP BusinessObjects Design Studio 1.5 ; SAP BusinessObjects Design Studio 1.6

Keywords

Data Type, Convesrion, Database, Universe, Business Layer, BICS, Semantic Layer, DSL , KBA , BI-RA-BICS-DSL , BICS DSL Provider , BI-RA-AD-BIP , Business Intelligence Platform Integration , 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.