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)
"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...
Environment
SAP BusinessObjects Design Studio
SAP BusinessObjects Business Intelligence Platform 4.x
Product
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.