US and Worldwide: +1 (866) 660-7555
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.

    Thanks.

  2. #2

    Default

    Did zeroDateTimeBehavior=convertToNull.

    Fixed.

  3. #3
    Join Date
    Oct 2012
    Posts
    3

    Default Please provide more details

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

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


    Thanks,
    Shreyas

  4. #4
    Join Date
    Jan 2013
    Posts
    551

    Default

    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
  •