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.

• 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)"

• 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).

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