Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Pentaho schema workbench cube error message after being published

  1. #1

    Default Pentaho schema workbench cube error message after being published

    I created a cube using schema workbench. I published the report in 'pentaho user console'. When I try to filter ID, It says: 'Oops. There was an error. Please try again, or contact your administrator.'

    On the pentaho.log inside /opt/pentaho/server/biserver-ce/logs, I get below message:

    Caused by: java.lang.RuntimeException: java.sql.SQLException: Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp

    How can I get rid of this error message.


  2. #2


    Did zeroDateTimeBehavior=convertToNull.


  3. #3
    Join Date
    Oct 2012

    Default Please provide more details

    Quote Originally Posted by pentahouser4 View Post
    Did zeroDateTimeBehavior=convertToNull.

    I am new to pentaho workbench. please if you can give me steps where this need to be added that can help a lot.


  4. #4
    Join Date
    Jan 2013


    zeroDateTimeBehavior is a JDBC property, which you would add to the DataSource properties in biserver. I'm not sure how many databases support that, though-- MySQL does, but I'm not sure which others.
    An alternative is to use a view which converts the field to NULL when the date field is zero.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2017 Pentaho Corporation. All Rights Reserved.