SAP Knowledge Base Article - Preview

1938025 - Error - "Database error: [Data Federator Driver] [Server] Cannot convert 'M/DD/YYYY 12:00:00 AM' to DATE data type. (IES 10901) (WIS 10901)" is seen when refreshing a Webi report that is based on a multisource .unx universe when the Webi report has two data providers and the results of the first query are used as a query filter for the second query.

Symptom

  • A multisource .unx universe is created.
  • A Webi report is created based on the multisource .unx universe.  The Webi report has two queries.
  • The results of the first query are used as a query filter for the second query.
  • When refreshing the Webi report, the following error is shown: Database error: [Data Federator Driver] [Server] Cannot convert 'M/DD/YYYY 12:00:00 AM' to DATE data type. (IES 10901) (WIS 10901)"


Read more...

Environment

  • SAP BusinessObjects Business Intelligence Platform BI4.0 SP06 - Patch 5 (This issue was also seen to be occurring in BI4.1 SP01 - Patch 1).
  • Microsoft SQL Server 2008 or 2012 (However, I don't think that this issue is specific to SQL Server).

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1

Keywords

ADAPT, 01700540, 1700540, bug, defect, TE5050144332 50144332, WIS10901, IES10901, datatype, issue, dataprovider, , KBA , BI-RA-WBI-DSL , Obsolete, use : BI-RA-WBI-BE-DP , Bug Filed

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.