Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Conversion error html to date?

  1. #1
    Join Date
    Mar 2016

    Default Conversion error html to date?

    Hello, I have manually been running a script to load some data into our data warehouse. Today, the script failed with error:

    Date String : couldn't convert string [<html>] to a date using format [yyyy-MM-dd] on offset location 0
    Unparseable date: "<html>"

    There have been no changes made and I'm not sure where this error is coming from. (I am fairly new to pentaho and how it all works)

    Can someone shed some light on the fix for this and why its happening, thanks!

  2. #2
    Join Date
    Jun 2012


    Quote Originally Posted by avoloshin View Post
    There have been no changes made
    Add a Text-File-Output just before the failing step and you'll find out that (1) there's unexpected content in that String field you are trying to convert to a Date and (2) you simply where lucky until now.
    So long, and thanks for all the fish.

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 - 2019 Hitachi Vantara Corporation. All Rights Reserved.