| 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: | Whole Thread | Raw Message | 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
| 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 |