pentaho timestamp issue

From: PropAAS DBA <dba(at)propaas(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pentaho timestamp issue
Date: 2018-03-18 21:54:04
Message-ID: 426393cf-6ffe-e779-60be-66d74c68c415@propaas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Pinging the list on the off chance someone has dealt with this and knows
of a workaroud. We have pentaho pointing to a PostgreSQL v10.3 database,
getting this error:

2018/03/18 15:06:37 - INPUT STEP - Fact.0 - Timestamp : Unable to get
timestamp from resultset at index 55

2018/03/18 15:06:37 - INPUT STEP -  Fact.0 - Bad value for type
timestamp : 0001-02-04 17:00:04-06:59:56

2018/03/18 15:06:37 - INPUT STEP -  Fact.0 -

2018/03/18 15:06:37 - INPUT STEP -  Fact.0 -

2018/03/18 15:06:37 - INPUT STEP -  Fact.0 -           at
org.pentaho.di.core.database.Database.getRow(Database.java:2302)

2018/03/18 15:06:37 - INPUT STEP -  Fact.0 -           at
org.pentaho.di.core.database.Database.getRow(Database.java:2270)

2018/03/18 15:06:37 - INPUT STEP -  Fact.0 -           at
org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:153)

2018/03/18 15:06:37 - INPUT STEP -  Fact.0 -           at
org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)

2018/03/18 15:06:37 - INPUT STEP -  Fact.0 -           at
java.lang.Thread.run(Unknown Source)

2018/03/18 15:06:37 - INPUT STEP -  Fact.0 - Caused by:
org.pentaho.di.core.exception.KettleDatabaseException:

2018/03/18 15:06:37 - INPUT STEP -  Fact.0 - Timestamp : Unable to get
timestamp from resultset at index 55

2018/03/18 15:06:37 - INPUT STEP -  Fact.0 - Bad value for type
timestamp : 0001-02-04 17:00:04-06:59:56

I've done some looking and this is clearly not a PostgreSQL issue, but
maybe there is an easy workaround? Anyone have any thoughts...

Thanks in advance

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2018-03-18 23:13:03 Re: pentaho timestamp issue
Previous Message Michael Paquier 2018-03-18 13:54:35 Re: changing my mail address