Symptom
-
Unable to refresh a Web Intelligence report that contains empty Date values retrieved from a MySQL database.
-
A database error occurred. The database error text is: 'Value ‘0000-00-00’ cannot be represented as java.sql.Date. (WIS 10901)
Read more...
Environment
-
SAP BusinessObjects Business intelligence Platform 4.0
-
MySQL 5
Product
SAP BusinessObjects Business Intelligence platform 4.0
Keywords
zeroDateTimeBehavior,convertToNull, date, MySQL, java.sql.Date, WIS 10901, java.sql.Date, 0000-00-00 , KBA , BI-RA-WBI , Web Intelligence , 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.