Problem importing Redshift direct query into SPICE: invalid value for "yyyy"

Question & Answer
, , ,
1

We have a QS dashboard with performance issues. It was recommended that we convert our dataset from a direct query against Redshift to SPICE.

When I do that, I get an error as follows:

Your database generated a SQL exception. This can be caused by query timeouts, resource constraints, unexpected DDL alterations before or during a query, and other database errors. Check your database settings and your query, and try again.

When I click the “show details” link, I get the following details:

|region: us-east-1
|timestamp: 1705588637095
|requestId: da9bb7c3-44d0-43e1-91d2-f98a53864c47
|sourceErrorCode: 0
|sourceErrorMessage: ERROR: invalid value for “yyyy” in source string
|sourceErrorState: XX000
|sourceException: org.postgresql.util.PSQLException
|sourceType: REDSHIFT

Does anyone have any suggestions for how I might find additional details about how to find the problematic field / value? Are the details of QuickSight errors logged anywhere?

2

As far as we can tell, this was caused by a calculated field that was trying to parse a date out of some other fields but those other fields were not formatted in the expected way.

Turns out not to be related to SPICE at all, except that SPICE seemed to discover the malformed dates more quickly than the direct query did.