SAP Knowledge Base Article - Preview

1827722 - Error: "A database error occured.The database error text is: Value ‘0000-00-00’ cannot be represented as java.sql.Date. (WIS 10901)"

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.