SAP Knowledge Base Article - Preview

1181724 - Error: "Exception: DBD, [Microsoft][ODBC SQL Server Driver][SQL Server]"" when running a Web Intelligence or Desktop Intelligence report with a two-digit date prompt

Symptom

In BusinessObjects Enterprise XI Release 2 with Critical Hot Fix (CHF) 17 for Monthly Hot Fix (MHF) 1 applied, a Web Intelligence or Desktop Intelligence report contains a date prompt that allows two digits to be entered for the year value.

When the report attempts to connect to the SQL Server data source, the following error message appears:

"Exception: DBD, [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.State: 22007".


Read more...

Product

SAP BusinessObjects Business Intelligence platform R2 ; SAP BusinessObjects Enterprise XI

Keywords

prompt 2 digit year , 1502051 , KBA , BI-BIP , Business intelligence platform , 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.