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

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)

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Read more...

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

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

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