Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hi,
I got this exception :
Failed to read data from table, caused by: PSQLException: Bad value for type timestamp : 1853-01-01 04:38:21+00:09:21, caused by: NumberFormatException: Trailing junk on timestamp: ':21'
HTTP code: 500, type: com.dataiku.dip.exceptions.DataStoreIOException
while trying the Hands-On: "In-Database Charts" from the "Dataiku DSS & SQL" course.
I run successfully a prepare recipe on a dataset named "customer_stacked"
But the result dataset "customer_stacked_prepared" is not build due to this error. I can not investigate this error as the prepare recipe runs ok and I don't know where to look at.
Hello,
This can happen with a timestamp that falls outside of a valid range, usually due to a timezone offset. You can set timezone = 'UTC' in postgresql.conf and restart Postgres to force PG to recognize this as UTC time, which should cause the timestamp to fall back into a valid range.
If you have psql on your machine you should be able to run the following command and find the location of the conf file:
psql -U postgres -c 'SHOW config_file'
Thank you
Andrew M
Hello Andrew,
Thank you for your respone! it works fine with the parameter timezone set to 'UTC'.
Regards
Hello,
This can happen with a timestamp that falls outside of a valid range, usually due to a timezone offset. You can set timezone = 'UTC' in postgresql.conf and restart Postgres to force PG to recognize this as UTC time, which should cause the timestamp to fall back into a valid range.
If you have psql on your machine you should be able to run the following command and find the location of the conf file:
psql -U postgres -c 'SHOW config_file'
Thank you
Andrew M
Hello Andrew,
Thank you for your respone! it works fine with the parameter timezone set to 'UTC'.
Regards